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 |
---|---|---|---|---|---|---|---|---|---|---|---|
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 |
Â