PACE Calendar Data Map Table

Element

Required/Optional

Value Type

Star Tag

Eagle DB

DB Table

DB Field

XPATH

Element

Required/Optional

Value Type

Star Tag

Eagle DB

DB Table

DB Field

XPATH

objectType

 

ObjectTypeEnum

 

not stored in DB

EagleML\referenceTransaction\paceCalendar\objectType

objectId

 

ObjectId

 

not stored in DB

EagleML\referenceTransaction\paceCalendar\objectId

objectDescription

 

FeedTypeEnum

 

not stored in DB

EagleML\referenceTransaction\paceCalendar\objectDescription

updateTimestamp

 

dateTime

 

 

 

 

EagleML\referenceTransaction\paceCalendar\updateTimestamp

customElements

Not recommended

CustomElements  -  ComplexType 

EagleML\referenceTransaction\paceCalendar\customElements

sourceName

 

string

 

not stored in DB

EagleML\referenceTransaction\paceCalendar\sourceName

updateSource

 

string

 

 

 

 

EagleML\referenceTransaction\paceCalendar\updateSource

effectiveDate

 

date

 

 

 

 

EagleML\referenceTransaction\paceCalendar\effectiveDate

languageId

 

integer

 

not stored in DB

EagleML\referenceTransaction\paceCalendar\languageId

tagNochangecase

 

string

 

not stored in DB 

EagleML\referenceTransaction\paceCalendar\tagNochangecase

preserveNull

 

string

 

not stored in DB

EagleML\referenceTransaction\paceCalendar\preserveNull

noLoadValidationFlag

 

YesNoOptionEnum

 

not stored in DB

EagleML\referenceTransaction\paceCalendar\noLoadValidationFlag

calendarName

 Required

string

1941

PACE_MASTERDBO

INTERFACES

SHORT_DESC

EagleML\referenceTransaction\paceCalendar\calendarName

calendarDescription

 

string

1103

PACE_MASTERDBO

INTERFACES

LONG_DESC

EagleML\referenceTransaction\paceCalendar\calendarDescription

calendarComments

 

string

1104

PACE_MASTERDBO

INTERFACES

COMMENTS

EagleML\referenceTransaction\paceCalendar\calendarComments

businessDate

 

date

 

PACE_MASTERDBO

BUSINESS_CALENDAR

BUSINESS_DATE

EagleML\referenceTransaction\paceCalendar\businessDate

currentBusinessDay

 

YesNoOptionEnum

 

PACE_MASTERDBO

BUSINESS_CALENDAR

CURR_BUSINESS_DAY

EagleML\referenceTransaction\paceCalendar\currentBusinessDay

monthEndFlag

 

YesNoOptionEnum

 

PACE_MASTERDBO

BUSINESS_CALENDAR

MONTH_END_FLAG

EagleML\referenceTransaction\paceCalendar\monthEndFlag

quarterEndFlag

 

YesNoOptionEnum

 

PACE_MASTERDBO

BUSINESS_CALENDAR

QTR_END_FLAG

EagleML\referenceTransaction\paceCalendar\quarterEndFlag

yearEndFlag

 

YesNoOptionEnum

 

PACE_MASTERDBO

BUSINESS_CALENDAR

YEAR_END_FLAG

EagleML\referenceTransaction\paceCalendar\yearEndFlag

weekEndFlag

 

YesNoOptionEnum

 

PACE_MASTERDBO

BUSINESS_CALENDAR

WEEK_END_FLAG

EagleML\referenceTransaction\paceCalendar\weekEndFlag

dailyFlag

 

YesNoOptionEnum

 

PACE_MASTERDBO

BUSINESS_CALENDAR

DAILY_FLAG

EagleML\referenceTransaction\paceCalendar\dailyFlag

numberOfYears

 Required

decimal

 

 

 

 

EagleML\referenceTransaction\paceCalendar\numberOfYears

Â