Generic SMF - Fixed Income Extension Model Data Map
- Natalie Gesin (Deactivated)
- Kinga Huszno
- Dmitry Donosiyan (Unlicensed)
Element | Optional/ Required | Value Type | Star Tag | SP Parameter | SP Type | Include File Name | Eagle DB | DB Table | DB Field | DB Field Type | Xpath |
|---|---|---|---|---|---|---|---|---|---|---|---|
callType |
| string | 7102 | in_fi_ext_call_type | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | call_type | VARCHAR2(1) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/callType |
conduit |
| string | 7103 | in_fi_ext_conduit | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | conduit | VARCHAR2(1) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/conduit |
coupFreq |
| string | 7106 | in_fi_ext_coup_freq | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | coup_freq | VARCHAR2(10) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/coupFreq |
dateConv |
| string | 7107 | in_fi_ext_date_conv | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | date_conv | VARCHAR2(6) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/dateConv |
delayConv |
| string | 7108 | in_fi_ext_delay_conv | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | delay_conv | VARCHAR2(1) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/delayConv |
series |
| string | 3000 | in_series | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_DETAIL | SERIES | CHAR(8) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/series |
firstPrinDate |
| date | 7111 | in_fi_ext_first_prin_dt | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | first_prin_dt | DATE | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/firstPrinDate |
maxCallNotice |
| integer | 7116 | in_fi_ext_max_call_notice | N | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | max_call_notice | NUMBER(38) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/maxCallNotice |
putNotificationMaxDays |
| integer | 7145 | in_fi_ext_put_notif_max_days | N | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | put_notification_max_days | NUMBER(38) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/putNotificationMaxDays |
minCallNotice |
| integer | 7117 | in_fi_ext_min_call_notice | N | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | min_call_notice | NUMBER(38) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/minCallNotice |
minLotSize |
| decimal | 7118 | in_fi_ext_min_lot_size | N | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | min_lot_size | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/minLotSize |
putNotificationMinDays |
| integer | 7146 | in_fi_ext_put_notif_min_days | N | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | put_notification_min_days | NUMBER(38) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/putNotificationMinDays |
oIdPrice |
| decimal | 7123 | in_fi_ext_oid_price | N | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | oid_price | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/oIdPrice |
pcDayConv |
| string | 7129 | in_fi_ext_pc_day_conv | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | pc_day_conv | VARCHAR2(1) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/pcDayConv |
pmtAdjMeth |
| string | 7137 | in_fi_ext_pmt_adj_meth | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | pmt_adj_meth | VARCHAR2(1) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/pmtAdjMeth |
pmtCal |
| string | 7138 | in_fi_ext_pmt_cal | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | pmt_cal | VARCHAR2(40) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/pmtCal |
pmtFreqType |
| string | 7139 | in_fi_ext_pmt_freq_type | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | pmt_freq_type | VARCHAR2(1) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/pmtFreqType |
pmtLocation |
| string | 7140 | in_fi_ext_pmt_location | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | pmt_location | VARCHAR2(1) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/pmtLocation |
prospectus |
| string | 10340 | in_prospectus | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_DETAIL_EXT | PROSPECTUS | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/prospectus |
embeddedOption |
| string | 7109 | in_fi_ext_embedded_option | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | embedded_option | VARCHAR2(2) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/embeddedOption |
putType |
| string | 7147 | in_fi_ext_put_type | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | put_type | VARCHAR2(1) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/putType |
salIndustry |
| string | 7151 | in_fi_ext_sal_industry | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | sal_industry | VARCHAR2(6) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/salIndustry |
settleCal |
| string | 7152 | in_fi_ext_settle_cal | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | settle_cal | VARCHAR2(40) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/settleCal |
settlementLocation |
| string | 7153 | in_fi_ext_settle_location | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | settle_location | VARCHAR2(1) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/settlementLocation |
sinkMandatory |
| string | 7154 | in_fi_ext_sink_mandatory | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | sink_mandatory | VARCHAR2(1) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/sinkMandatory |
structure |
| string | 7155 | in_fi_ext_structure | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | structure | VARCHAR2(8) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/structure |
firstResetCapPct |
| decimal | 7112 | in_fi_ext_first_reset_cap_pct | N | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | first_reset_cap_pct | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/firstResetCapPct |
firstResetFlavor |
| string | 7113 | in_fi_ext_first_reset_flavor | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | first_reset_flavor | VARCHAR2(1) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/firstResetFlavor |
firstResetFloorPct |
| decimal | 7114 | in_fi_ext_first_res_floor_pct | N | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | first_reset_floor_pct | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/firstResetFloorPct |
multiOrigFl |
| decimal | 7119 | in_fi_ext_multi_orig_fl | N | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | multi_orig_fl | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/multiOrigFl |
negAmCap |
| decimal | 7122 | in_fi_ext_neg_am_cap | N | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | neg_am_cap | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/negAmCap |
origLifeCap |
| decimal | 7124 | in_fi_ext_orig_life_cap | N | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | orig_life_cap | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/origLifeCap |
origLifeFloor |
| decimal | 7125 | in_fi_ext_orig_life_floor | N | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | orig_life_floor | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/origLifeFloor |
origNetMargin |
| decimal | 7126 | in_fi_ext_orig_net_margin | N | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | orig_net_margin | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/origNetMargin |
origTerm |
| decimal | 7127 | in_fi_ext_orig_term | N | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | orig_term | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/origTerm |
payCap |
| decimal | 7128 | in_fi_ext_pay_cap | N | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | pay_cap | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/payCap |
pdAols |
| decimal | 7130 | in_fi_ext_pd_aols | N | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | pd_aols | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/pdAols |
pdGeoPct |
| decimal | 7131 | in_fi_ext_pd_geo_pct | N | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | pd_geo_pct | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/pdGeoPct |
pdGeoState |
| string | 7132 | in_fi_ext_pd_geo_state | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | pd_geo_state | VARCHAR2(2) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/pdGeoState |
pdGrossMargin |
| decimal | 7133 | in_fi_ext_pd_gross_margin | N | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | pd_gross_margin | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/pdGrossMargin |
pdMosToRoll |
| decimal | 7134 | in_fi_ext_pd_mos_to_roll | N | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | pd_mos_to_roll | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/pdMosToRoll |
pdNetMargin |
| decimal | 7135 | in_fi_ext_pd_net_margin | N | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | pd_net_margin | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/pdNetMargin |
pdWaolt |
| decimal | 7136 | in_fi_ext_pd_waolt | N | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | pd_waolt | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/pdWaolt |
progCode |
| string | 7143 | in_fi_ext_prog_code | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | prog_code | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/progCode |
progCodeSub |
| string | 7144 | in_fi_ext_prog_code_sub | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | prog_code_sub | VARCHAR2(4) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/progCodeSub |
indxLookback |
| decimal | 7115 | in_fi_ext_indx_lookback | N | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | indx_lookback | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/indxLookback |
prinFloor |
| string | 7142 | in_fi_ext_prin_floor | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | prin_floor | VARCHAR2(1) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/prinFloor |
baseLevelDate |
| date | 7101 | in_fi_ext_base_level_date | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | base_level_date | DATE | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/baseLevelDate |
pricing |
| string | 7141 | in_fi_ext_pricing | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | pricing | VARCHAR2(1) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/pricing |
indexResetTerm |
| decimal | 7156 | in_fi_ext_index_reset_term | N | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | index_reset_term | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/indexResetTerm |
maturity2 |
| date | 10356 | in_maturity2 | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_DETAIL_EXT | MATURITY2 | DATE | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/maturity2 |
perpetualFlag |
| string | 10519 | in_perpetual_flag | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_DETAIL_EXT | PERPETUAL_FLAG | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/perpetualFlag |
muniIndustry |
| string | 7120 | in_fi_ext_muni_ind | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | muni_ind | VARCHAR2(16) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/muniIndustry |
muniPledgeFunding |
| string | 7121 | in_fi_ext_muni_pf | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | muni_pf | VARCHAR2(16) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/muniPledgeFunding |
convertibleIndicator |
| YesNoOptionEnum | 7104 | in_fi_ext_convertible_flag | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | convertible_flag | VARCHAR2(1) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/convertibleIndicator |
county |
| string | 7105 | in_fi_ext_county | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | county | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/county |
recoveryRate |
| decimal | 7148 | in_fi_ext_recovery_rate | F | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | recovery_rate | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/recoveryRate |
accrualPeriod |
| string | 7158 | in_fi_ext_accrual_period | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | accrual_period | VARCHAR2(1) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/accrualPeriod |
calendarTyp |
| string | - |
|
|
|
|
|
|
| EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/calendarTyp |
deal |
| string | 7159 | in_fi_ext_deal | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | deal | VARCHAR2(34) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/deal |
grossMargin |
| decimal | 7162 | in_fi_ext_gross_margin | N | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | gross_margin | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/grossMargin |
cpnDelayDays |
| integer | 4909 | in_cpn_delay_days | N | capsandfloors_model.inc | SECURITYDBO | FIXED_INCOME | CPN_DELAY_DAYS | NUMBER(38) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/cpnDelayDays |
cpnDelayDaysType |
| string | 3999 | in_CPN_DELAY_DAYS_TYPE | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME | CPN_DELAY_DAYS_TYPE | VARCHAR2(1) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/cpnDelayDaysType |
restructIndicator |
| string | 7150 | in_fi_ext_restruct_ind | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | restruct_ind | VARCHAR2(2) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/restructIndicator |