Calendar Holiday Data Map Table
- Natalie Gesin (Deactivated)
- Kinga Huszno
- Dmitry Donosiyan (Unlicensed)
Element | Optional/Required | Value Type | Eagle DB | DB Table | DB Field | Star Tag | DB Data Type | SP Parameter | XPATH |
|---|---|---|---|---|---|---|---|---|---|
objectType | Optional | ObjectTypeEnum | not stored in DB |
|
|
| EagleML/referenceTransaction/calendarHoliday/objectType | ||
objectId | Optional | ObjectId | not stored in DB |
|
|
| EagleML/referenceTransaction/calendarHoliday/objectId | ||
objectDescription | Optional | FeedTypeEnum | not stored in DB |
|
|
| EagleML/referenceTransaction/calendarHoliday/objectDescription | ||
updateTimestamp | Optional | dateTime | PACE_MASTERDBO | ESTAR_CALENDAR_DAY | UPDATE_DATE |
| DATE |
| EagleML/referenceTransaction/calendarHoliday/updateTimestamp |
customElements | Not recommended | CustomElements - Complex type | reserved for customizations | EagleML/referenceTransaction/calendarHoliday/customElements | |||||
sourceName | Optional | string - needed for resolution logics | not stored in DB |
|
|
| EagleML/referenceTransaction/calendarHoliday/sourceName | ||
updateSource | Optional | string | PACE_MASTERDBO | ESTAR_CALENDAR_DAY | UPDATE_SOURCE | 944 | varchar2(32) | in_upd_source | EagleML/referenceTransaction/calendarHoliday/updateSource |
effectiveDate | Optional | date | not stored in DB |
|
|
| EagleML/referenceTransaction/calendarHoliday/effectiveDate | ||
languageId | Optional | integer | not stored in DB |
|
|
| EagleML/referenceTransaction/calendarHoliday/languageId | ||
tagNochangecase | Optional | string | not stored in DB |
|
|
| EagleML/referenceTransaction/calendarHoliday/tagNochangecase | ||
preserveNull | Optional | string | not stored in DB |
|
|
| EagleML/referenceTransaction/calendarHoliday/preserveNull | ||
noLoadValidationFlag | Optional | YesNoOptionEnum | not stored in DB |
|
|
| EagleML/referenceTransaction/calendarHoliday/noLoadValidationFlag | ||
calendarName | Required | string | PACE_MASTERDBO | ESTAR_CALENDAR | NAME | 1941 | varchar2(50) | in_cal_name | EagleML/referenceTransaction/calendarHoliday/calendarName |
calendarDate | Required | date | PACE_MASTERDBO | ESTAR_CALENDAR_DAY | THE_DATE | 3259 | date | in_datetype | EagleML/referenceTransaction/calendarHoliday/calendarDate |
nonBusinessDayFlag | Required | YesNoOptionEnum | not stored in DB | 1946 |
| in_non_bus_day_flag | EagleML/referenceTransaction/calendarHoliday/nonBusinessDayFlag | ||
holidayName | Required | string | PACE_MASTERDBO | ESTAR_CALENDAR_DAY | HOLIDAY | 4593 | varchar2(50) | in_holiday_name | EagleML/referenceTransaction/calendarHoliday/holidayName |