Issue Variable Rate Data Map Table
- Natalie Gesin (Deactivated)
- Kinga Huszno
- Dmitry Donosiyan (Unlicensed)
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 |
|
| not stored in DB |
| EagleML/referenceTransaction/issueVariableRate/noLoadValidationFlag | ||
accountingValidationFlag |
|
| YesNoOptionEnum |
|
| not stored in DB |
| EagleML/referenceTransaction/issueVariableRate/accountingValidationFlag | ||
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 | |