Generic SMF - Issue Variable Rate Model Data Map
- Natalie Gesin (Deactivated)
- Kinga Huszno
- Dmitry Donosiyan (Unlicensed)
Please note, that Issue Variable Rate Model is separated by the smf_mi stream and loaded as a Issue Variable Rate EagleML object - so you should use ISSUEVARRATEEXTRACT feedtype to extract it.
Element | Optional/ Required | Value Type | Star Tag | SP Parameter | SP Type | Include File Name | Eagle DB | DB Table | DB Field | DB Field Type | Xpath |
|---|---|---|---|---|---|---|---|---|---|---|---|
assetIdentifiersModel |
| EagleML/referenceTransaction/genericSMF/IssueVariableRateModel/assetIdentifiersModel/ | |||||||||
effectiveDate | Required | date | 1109 | in_effective_date | S |
| SECURITYDBO | VARIABLE_RATE | EFFECTIVE_DATE | DATE | EagleML/referenceTransaction/genericSMF/IssueVariableRateModel/effectiveDate |
variableRate |
| decimal | 96 | in_variable_rate | F |
| SECURITYDBO | VARIABLE_RATE | VARIABLE_RATE | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/IssueVariableRateModel/variableRate |
nextRefixDate |
| date | 3006 | in_nxt_refix_dt | S |
| SECURITYDBO | VARIABLE_RATE | NEXT_REFIX_DATE | DATE | EagleML/referenceTransaction/genericSMF/IssueVariableRateModel/nextRefixDate |
schedulePeriodTypes |
| string | - |
|
|
| not stored in DB |
| EagleML/referenceTransaction/genericSMF/IssueVariableRateModel/schedulePeriodTypes | ||
floatPaymentSchedule |
| string | 8023 | in_float_pmt_schd | S |
| SECURITYDBO | VARIABLE_RATE | FLOAT_PMT_SCHD | CHAR(30) | EagleML/referenceTransaction/genericSMF/IssueVariableRateModel/floatPaymentSchedule |
resetDateCode |
| string | 1122 | in_reset_date_code | S |
| SECURITYDBO | VARIABLE_RATE | RESET_DATE_CODE | CHAR(30) | EagleML/referenceTransaction/genericSMF/IssueVariableRateModel/resetDateCode |
status |
| string | - |
|
|
| not stored in DB |
| EagleML/referenceTransaction/genericSMF/IssueVariableRateModel/status | ||
variableResetCode |
| string | 1123 | in_variable_reset_code | S |
| SECURITYDBO | VARIABLE_RATE | VARIABLE_RESET_CODE | CHAR(30) | EagleML/referenceTransaction/genericSMF/IssueVariableRateModel/variableResetCode |
couponRefixFreq |
| integer | 9916 | in_coupon_refix_freq | I |
| SECURITYDBO | VARIABLE_RATE | COUPON_REFIX_FREQ | NUMBER | EagleML/referenceTransaction/genericSMF/IssueVariableRateModel/couponRefixFreq |
couponFloor |
| decimal | 1518 | in_coupon_floor | F |
| SECURITYDBO | VARIABLE_RATE | COUPON_FLOOR | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/IssueVariableRateModel/couponFloor |
couponCap |
| decimal | 1517 | in_coupon_cap | F |
| SECURITYDBO | VARIABLE_RATE | COUPON_CAP | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/IssueVariableRateModel/couponCap |
vrFloor |
| decimal | 8025 | in_vr_floor | F |
| SECURITYDBO | VARIABLE_RATE | VR_FLOOR | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/IssueVariableRateModel/vrFloor |
vrCap |
| decimal | 8024 | in_vr_cap | F |
| SECURITYDBO | VARIABLE_RATE | VR_CAP | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/IssueVariableRateModel/vrCap |
resetDay |
| string | 1121 | in_reset_day | S |
| SECURITYDBO | VARIABLE_RATE | RESET_DAY | CHAR(30) | EagleML/referenceTransaction/genericSMF/IssueVariableRateModel/resetDay |
resetMargin |
| decimal | 10538 | in_reset_margin | I |
| SECURITYDBO | VARIABLE_RATE | RESET_MARGIN | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/IssueVariableRateModel/resetMargin |
cashMovement |
| string | 3664 | in_cash_movement | S |
| SECURITYDBO | VARIABLE_RATE | CASH_MOVEMENT | VARCHAR2(1) | EagleML/referenceTransaction/genericSMF/IssueVariableRateModel/cashMovement |