Calendar Holiday Data Map Table

Element

Optional/Required

Value Type

Eagle DB

DB Table

DB Field

Star Tag

DB Data Type

SP Parameter

XPATH

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