| 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 Id 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 | |||
...