Generic SMF - Floater Model, Issue Variable Rate Base Model Data Map

assetIdentifiersModel

Asset Identifiers Model - (see extra table)

EagleML/referenceTransaction/genericSMF/IssueVariableRateModel/assetIdentifiersModel/

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