Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


 

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

Optional


Asset Identifiers Model - (see extra table)

EagleML/referenceTransaction/genericSMF/IssueVariableRateModel/assetIdentifiersModel/

nextRefixDateOptional


date

3006

in_nxt_refix_dt

S

 


SECURITYDBO

VARIABLE_RATE

NEXT_REFIX_DATE

DATE

EagleML/referenceTransaction/genericSMF/IssueVariableRateModel/nextRefixDate

schedulePeriodTypesOptional


string

-

 

 

 




not stored in DB

 

 

 




EagleML/referenceTransaction/genericSMF/IssueVariableRateModel/schedulePeriodTypes

floatPaymentSchedule

Optional


string

8023

 in_float_pmt_schd

S 


SECURITYDBO

VARIABLE_RATE

FLOAT_PMT_SCHD

CHAR(30)

EagleML/referenceTransaction/genericSMF/IssueVariableRateModel/floatPaymentSchedule

resetDateCode

Optional


string

1122

in_reset_date_code

S 


SECURITYDBO

VARIABLE_RATE

RESET_DATE_CODE

CHAR(30)

EagleML/referenceTransaction/genericSMF/IssueVariableRateModel/resetDateCode

statusOptional


string

-

 

 

 




not stored in DB

 

 

 




EagleML/referenceTransaction/genericSMF/IssueVariableRateModel/status

variableResetCodeOptional


string

1123

in_variable_reset_code

S

 


SECURITYDBO

VARIABLE_RATE

VARIABLE_RESET_CODE

CHAR(30)

EagleML/referenceTransaction/genericSMF/IssueVariableRateModel/variableResetCode

couponRefixFreqOptional


integer

9916

in_coupon_refix_freq

I 


SECURITYDBO

VARIABLE_RATE

COUPON_REFIX_FREQ

NUMBER

EagleML/referenceTransaction/genericSMF/IssueVariableRateModel/couponRefixFreq

couponFloor

Optional


decimal

1518

in_coupon_floor

F 


SECURITYDBO

VARIABLE_RATE

COUPON_FLOOR

NUMBER(28,12)

EagleML/referenceTransaction/genericSMF/IssueVariableRateModel/couponFloor

couponCap

Optional


decimal

1517

in_coupon_cap

F 


SECURITYDBO

VARIABLE_RATE

COUPON_CAP

NUMBER(28,12)

EagleML/referenceTransaction/genericSMF/IssueVariableRateModel/couponCap

vrFloorOptional


decimal

8025

in_vr_floor

F

 


SECURITYDBO

VARIABLE_RATE

VR_FLOOR

NUMBER(28,12)

EagleML/referenceTransaction/genericSMF/IssueVariableRateModel/vrFloor

vrCapOptional


decimal

8024

in_vr_cap

F

 


SECURITYDBO

VARIABLE_RATE

VR_CAP

NUMBER(28,12)

EagleML/referenceTransaction/genericSMF/IssueVariableRateModel/vrCap

resetDayOptional


string

1121

in_reset_day

S 


SECURITYDBO

VARIABLE_RATE

RESET_DAY

CHAR(30)

EagleML/referenceTransaction/genericSMF/IssueVariableRateModel/resetDay

resetMargin

Optional


decimal

10538

in_reset_margin

I 


SECURITYDBO

VARIABLE_RATE

RESET_MARGIN

NUMBER(28,12)

EagleML/referenceTransaction/genericSMF/IssueVariableRateModel/resetMargin

cashMovement

Optional


string

3664

in_cash_movement

S 


SECURITYDBO

VARIABLE_RATE

CASH_MOVEMENT

VARCHAR2(1)

EagleML/referenceTransaction/genericSMF/IssueVariableRateModel/cashMovement

...