Business Date Rule Data Map Table
- Dmitry Donosiyan (Unlicensed)
Owned by Dmitry Donosiyan (Unlicensed)
| 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 | DayAdjustmentsModel - Complex type (see extra table) | ../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 | |