Earnings Time Period Data Map Table

Element

Required Inbound Acct Validation

Required Inbound Data Mgt

Value Type

Star Tag

SP Parameter

SP Type

Eagle DB

DB Table

DB Field

DB Type

Xpath

Element

Required Inbound Acct Validation

Required Inbound Data Mgt

Value Type

Star Tag

SP Parameter

SP Type

Eagle DB

DB Table

DB Field

DB Type

Xpath

objectType

 

 

ObjectTypeEnum

 

 

 

not stored in DB

 

EagleML/referenceTransaction/earningsTimePeriod/objectType

objectId

 

 

ObjectId

 

 

 

not stored in DB

 

EagleML/referenceTransaction/earningsTimePeriod/objectId

objectDescription

 

 

FeedTypeEnum

 

 

 

 

 

 

 

EagleML/referenceTransaction/earningsTimePeriod/objectDescription

updateTimestamp

 

 

dateTime

 

 

 

SECURITYDBO

SMF_EARNINGS_TIME_PERIOD

UPDATE_DATE

DATE

EagleML/referenceTransaction/earningsTimePeriod/updateTimestamp

customElements

Not recommended

CustomElements - Complex Type

EagleML/referenceTransaction/earningsTimePeriod/customElements/

sourceName

 

 

string

 

 

 

not stored in DB

 

EagleML/referenceTransaction/earningsTimePeriod/sourceName

updateSource

 

 

string

 

 

 

 

 

 

 

EagleML/referenceTransaction/earningsTimePeriod/updateSource

effectiveDate

 

 

date

 

 

 

not stored in DB

 

EagleML/referenceTransaction/earningsTimePeriod/effectiveDate

languageId

 

 

integer

 

 

 

not stored in DB

 

EagleML/referenceTransaction/earningsTimePeriod/languageId

tagNochangecase

 

 

string

 

 

 

not stored in DB

 

EagleML/referenceTransaction/earningsTimePeriod/tagNochangecase

preserveNull

 

 

string

 

 

 

not stored in DB

 

EagleML/referenceTransaction/earningsTimePeriod/preserveNull

noLoadValidationFlag

 

 

YesNoOptionEnum

 

 

 

not stored in DB

 

EagleML/referenceTransaction/earningsTimePeriod/noLoadValidationFlag

accountingValidationFlag

 

 

YesNoOptionEnum

 

 

 

not stored in DB

 

EagleML/referenceTransaction/earningsTimePeriod/accountingValidationFlag

skipIfExistFlag

 

 

YesNoOptionEnum

 

 

 

not stored in DB

 

EagleML/referenceTransaction/earningsTimePeriod/skipIfExistFlag

Asset Identifiers Model (see extra table)

 

EagleML/referenceTransaction/earningsTimePeriod/

beginDate

 

Required

date

220

in_begin_date

 

SECURITYDBO

SMF_EARNINGS_TIME_PERIOD

BEGIN_DATE

DATE

EagleML/referenceTransaction/earningsTimePeriod/beginDate

endDate

 

 

date

221

in_end_date

 

SECURITYDBO

SMF_EARNINGS_TIME_PERIOD

END_DATE

DATE

EagleML/referenceTransaction/earningsTimePeriod/endDate

couponTypeCode

 

 

CouponTypeCodeEnum

97

in_coupon_type_code

 

SECURITYDBO

SMF_EARNINGS_TIME_PERIOD

COUPON_TYPE_CODE

CHAR(8)

EagleML/referenceTransaction/earningsTimePeriod/couponTypeCode

dayCountBasis

 

 

DayCountFraction

471

in_day_cnt

 

SECURITYDBO

SMF_EARNINGS_TIME_PERIOD

DAY_CNT

CHAR(20)

EagleML/referenceTransaction/earningsTimePeriod/dayCountBasis

indexOffset

 

 

decimal

215

in_offset

 

SECURITYDBO

SMF_EARNINGS_TIME_PERIOD

OFFSET

NUMBER(38,12)

EagleML/referenceTransaction/earningsTimePeriod/indexOffset

coupon

 

 

decimal

70

in_coupon

 

SECURITYDBO

SMF_EARNINGS_TIME_PERIOD

COUPON

NUMBER(38,12)

EagleML/referenceTransaction/earningsTimePeriod/coupon

underlyingSecAlias

 

 

integer

1347

in_underlying_sec_alias

 

SECURITYDBO

SMF_EARNINGS_TIME_PERIOD

UNDERLYING_SEC_ALIAS

NUMBER

EagleML/referenceTransaction/earningsTimePeriod/underlyingSecAlias

paymentFrequencyCode

 

 

StringWithCodeScheme

472

in_coupon_freq_code

 

SECURITYDBO

SMF_EARNINGS_TIME_PERIOD

COUPON_FREQ_CODE

CHAR(8)

EagleML/referenceTransaction/earningsTimePeriod/paymentFrequencyCode

Â