Generic SMF - Fixed Income Extension Model Data Map
- Natalie Gesin (Deactivated)
- 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 |