Earnings Time Period Data Map Table
- Dmitry Donosiyan (Unlicensed)
- Kinga Huszno
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 |