Element | Required Inbound Acct Validation | Required Inbound Data Mgt | Value Type | Star Tag | SP Parameter | Eagle DB | DB Table | DB Field | DB Field Type | XPATH | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| objectType | Required | ObjectTypeEnum | not stored in DB | EagleML/referenceTransaction/issueVariableRate/objectType | |||||||||||||
| objectId | ObjectId | not stored in DB | EagleML/referenceTransaction/issueVariableRate/objectId | ||||||||||||||
| objectDescription | FeedTypeEnum | not stored in DB | EagleML/referenceTransaction/issueVariableRate/objectDescription | ||||||||||||||
| updateTimestamp | dateTime | SECURITYDBO | VARIABLE_RATE | UPDATE_DATE | DATE | EagleML/referenceTransaction/issueVariableRate/updateTimestamp | |||||||||||
| customElements | Not recommended | CustomElements - Complex type | reserved for customizations | EagleML/referenceTransaction/issueVariableRate/customElements | |||||||||||||
| sourceName | Required | Required | string - needed for resolution logics | PACE_MASTERDBO | INTERFACES | short_desc | CHAR(15) | EagleML/referenceTransaction/issueVariableRate/sourceName | |||||||||
| updateSource | string | 944 | in_source_name | SECURITYDBO | VARIABLE_RATE | UPDATE_SOURCE | VARCHAR2(255) | EagleML/referenceTransaction/issueVariableRate/updateSource | |||||||||
| effectiveDate | Required | Required | date | 1109 | in_effective_date | DATE | EagleML/referenceTransaction/issueVariableRate/effectiveDate | ||||||||||
| languageId | integer | not stored in DB | EagleML/referenceTransaction/issueVariableRate/languageId | ||||||||||||||
| tagNochangecase | string | not stored in DB | EagleML/referenceTransaction/issueVariableRate/tagNochangecase | ||||||||||||||
| preserveNull | string | not stored in DB | EagleML/referenceTransaction/issueVariableRate/preserveNull | ||||||||||||||
| noLoadValidationFlag | YesNoOptionEnum | YesNoOptionEnum | not stored in DB | EagleML/referenceTransaction/issueVariableRate/noLoadValidationFlag | |||||||||||||
| accountingValidationFlag | YesNoOptionEnum | not stored in DB | EagleML/referenceTransaction/issueVariableRate/ | noLoadValidationFlagaccountingValidationFlag | |||||||||||||
| Asset Identifiers Model | EagleML/referenceTransaction/issueVariableRate/ | ||||||||||||||||
| variableRate | Required | decimal | 96 | in_variable_rate | SECURITYDBO | VARIABLE_RATE | VARIABLE_RATE | NUMBER(28,12) | EagleML/referenceTransaction/issueVariableRate/variableRate | ||||||||
| nextRefixDate | date | 1125 | in_next_refix_date | SECURITYDBO | VARIABLE_RATE | NEXT_REFIX_DATE | DATE | EagleML/referenceTransaction/issueVariableRate/nextRefixDate | |||||||||
| schedulePeriodTypes | string | not stored in DB | EagleML/referenceTransaction/issueVariableRate/schedulePeriodTypes | ||||||||||||||
| floatPaymentSchedule | string | 8023 | in_float_pmt_schd | SECURITYDBO | VARIABLE_RATE | FLOAT_PMT_SCHD | CHAR(30) | EagleML/referenceTransaction/issueVariableRate/floatPaymentSchedule | |||||||||
| resetDateCode | string | 1122 | in_reset_date_code | SECURITYDBO | VARIABLE_RATE | RESET_DATE_CODE | CHAR(30) | EagleML/referenceTransaction/issueVariableRate/resetDateCode | |||||||||
| status | string | not stored in DB | EagleML/referenceTransaction/issueVariableRate/status | ||||||||||||||
| variableResetCode | string | 1123 | in_variable_reset_code | SECURITYDBO | VARIABLE_RATE | VARIABLE_RESET_CODE | CHAR(30) | EagleML/referenceTransaction/issueVariableRate/variableResetCode | |||||||||
| couponRefixFreq | integer | 9916 | in_coupon_refix_freq | SECURITYDBO | VARIABLE_RATE | COUPON_REFIX_FREQ | NUMBER | EagleML/referenceTransaction/issueVariableRate/couponRefixFreq | |||||||||
| couponFloor | decimal | 1518 | in_coupon_floor | SECURITYDBO | VARIABLE_RATE | COUPON_FLOOR | NUMBER(28,12) | EagleML/referenceTransaction/issueVariableRate/couponFloor | |||||||||
| couponCap | decimal | 1517 | in_coupon_cap | SECURITYDBO | VARIABLE_RATE | COUPON_CAP | NUMBER(28,12) | EagleML/referenceTransaction/issueVariableRate/couponCap | |||||||||
| vrFloor | decimal | 8025 | in_vr_floor | SECURITYDBO | VARIABLE_RATE | VR_FLOOR | NUMBER(28,12) | EagleML/referenceTransaction/issueVariableRate/vrFloor | |||||||||
| vrCap | decimal | 8024 | in_vr_cap | SECURITYDBO | VARIABLE_RATE | VR_CAP | NUMBER(28,12) | EagleML/referenceTransaction/issueVariableRate/vrCap | |||||||||
| resetDay | string | 1121 | in_reset_day | SECURITYDBO | VARIABLE_RATE | RESET_DAY | CHAR(30) | EagleML/referenceTransaction/issueVariableRate/resetDay | |||||||||
| resetMargin | decimal | 10538 | in_reset_margin | SECURITYDBO | VARIABLE_RATE | RESET_MARGIN | NUMBER(28,12) | EagleML/referenceTransaction/issueVariableRate/resetMargin | |||||||||
| cashMovement | Required - Defaulted to "No" by the Panel | string | 3664 | in_cash_movement | SECURITYDBO | VARIABLE_RATE | CASH_MOVEMENT | VARCHAR2(1) | EagleML/referenceTransaction/issueVariableRate/cashMovement | ||||||||
| rateMaturityDate | date | 16725 | in_rate_maturity_dt | SECURITYDBO | VARIABLE_RATE | RATE_MATURITY_DT | DATE | EagleML/referenceTransaction/issueVariableRate/rateMaturityDate | |||||||||
| journalizingFlag | JournalizingFlagEnum | 1293 | in_journal_flag | not stored in DB | EagleML/referenceTransaction/issueVariableRate/journalizingFlag | ||||||||||||
| coupon | extract-only | decimal | 70 | in_coupon | SECURITYDBO | SECURITY_MASTER | COUPON | NUMBER(28,12) | EagleML/referenceTransaction/issueVariableRate/coupon | ||||||||
...