Business Date Rule Data Map Table
- Dmitry Donosiyan (Unlicensed)
- Kinga Huszno
Element | Required Inbound Acct Validation | Value Type | Eagle DB | DB Table | DB Field | Data_Type | Xpath |
|---|---|---|---|---|---|---|---|
objectType | Required |
| not stored in DB |
| EagleML/referenceTransaction/businessDateRule/objectType | ||
objectId |
|
| not stored in DB |
| EagleML/referenceTransaction/businessDateRule/objectId | ||
objectDescription |
|
| not stored in DB |
| EagleML/referenceTransaction/businessDateRule/objectDescription | ||
updateTimestamp |
|
| RULESDBO | DATERANGES | UPDATE_DATE | DATE | EagleML/referenceTransaction/businessDateRule/updateTimestamp |
updateSource | Required | string | RULESDBO | DATERANGES | UPDATE_USER | CHAR(100) | EagleML/referenceTransaction/businessDateRule/updateSource |
dateRuleId | Required | integer | RULESDBO | DATERANGES | ID | NUMBER | EagleML/referenceTransaction/businessDateRule/dateRuleId |
dateRuleName | Required | string | RULESDBO | DATERANGES | NAME | CHAR(50) | EagleML/referenceTransaction/businessDateRule/dateRuleName |
businessCalendarName |
| string | PACE_MASTERDBO | INTERFACES | SHORT_DESC | CHAR(15) | EagleML/referenceTransaction/businessDateRule/businessCalendarName |
businessStartDate | BusinessDayAdjustmentsModel - Complex type (see extra table) | EagleML/referenceTransaction/businessDateRule/businessStartDate/ | |||||
businessEndDate | BusinessDayAdjustmentsModel - Complex type (see extra table) | EagleML/referenceTransaction/businessDateRule/businessEndDate/ | |||||
comments |
| string | RULESDBO | DATERANGES | COMMENTS | VARCHAR2(255) | EagleML/referenceTransaction/businessDateRule/comments |
inceptFiscalField |
| integer | RULESDBO | DATERANGES | INCEPT_FISCAL_FIELD | NUMBER | EagleML/referenceTransaction/businessDateRule/inceptFiscalField |
monthEndFlag |
| YesNoOptionEnum | RULESDBO | DATERANGES | ONLY_MONTHENDS_FLAG | NUMBER | EagleML/referenceTransaction/businessDateRule/monthEndFlag |
scope |
| integer | RULESDBO | DATERANGES | SCOPE | NUMBER | EagleML/referenceTransaction/businessDateRule/scope |
singlePeriod |
| SinglePeriodEnum | RULESDBO | DATERANGES | SINGLE_PERIOD | CHAR(2) | EagleML/referenceTransaction/businessDateRule/singlePeriod |
timeZoneCode |
| ISOTimeZoneOffset | RULESDBO | DATERANGES | TIME_ZONE_ID | NUMBER | EagleML/referenceTransaction/businessDateRule/timeZoneCode |
timeZoneName |
| string | PACE_MASTERDBO | TIME_ZONES | STANDARD_NAME | VARCHAR2(255) | EagleML/referenceTransaction/businessDateRule/timeZoneName |
BusinessDayAdjustments Model | |||||||
unadjustedDate | Required if dateTypeCode = 'FIXED' | date | RULESDBO | DATERANGES | START_DATE | DATE | ../unadjustedDate |
END_DATE | DATE | ||||||
dateTypeCode |
| DateTypeCodeEnum | RULESDBO | DATERANGES | START_CODE | CHAR(10) | ../dateTypeCode |
END_CODE | CHAR(10) | ||||||
dayAdjustments | ../dayAdjustments/ | ||||||
DayAdjustments Model | |||||||
offsetCode |
| OffsetCodeEnum | RULESDBO | DATERANGES | START_OFF_CODE | NUMBER | ../offsetCode |
END_OFF_CODE | NUMBER | ||||||
offsetQuantity |
| integer | RULESDBO | DATERANGES | START_OFF_QUAN | NUMBER | ../offsetQuantity |
END_E_OFF_QUAN | NUMBER | ||||||
offsetCalendarFlag |
| YesNoOptionEnum | RULESDBO | DATERANGES | BUSINESS_CAL_FLAG | NUMBER | ../offsetCalendarFlag |
adjustmentCode |
| AdjustmentCodeEnum | RULESDBO | DATERANGES | START_ADJ_CODE | CHAR(5) | ../adjustmentCode |
END_ADJ_CODE | CHAR(5) | ||||||
adjustmentCalendarFlag |
| YesNoOptionEnum | RULESDBO | DATERANGES | BUSINESS_CAL_FLAG | NUMBER | ../adjustmentCalendarFlag |
additionalOffsetCode |
| OffsetCodeEnum | RULESDBO | DATERANGES | START_E_OFF_CODE | CHAR(5) | ../additionalOffsetCode |
END_E_OFF_CODE | CHAR(5) | ||||||
additionalOffsetQuantity |
| integer | RULESDBO | DATERANGES | START_E_OFF_QUAN | NUMBER | ../additionalOffsetQuantity |
END_E_OFF_QUAN | NUMBER | ||||||
additionalCalendarFlag |
| YesNoOptionEnum | RULESDBO | DATERANGES | BUSINESS_CAL_FLAG | NUMBER | ../additionalCalendarFlag |