...
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 |
Optional
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 |
Optional
string | 3000 | in_series | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_DETAIL | SERIES | CHAR(8) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/series | |
firstPrinDate |
Optional
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 |
Optional
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 |
Optional
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 |
Optional
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 |
Optional
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 |
Optional
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 |
Optional
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 |
Optional
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 |
Optional
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 |
Optional
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 |
Optional
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 |
Optional
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 |
Optional
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 |
Optional
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 |
Optional
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 |
Optional
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 |
Optional
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 |
Optional
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 |
Optional
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 |
Optional
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 |
Optional
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 |
Optional
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 |
Optional
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 |
Optional
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 |
Optional
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 |
Optional
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 |
Optional
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 |
Optional
string | - |
EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/calendarTyp | |||||||
deal |
Optional
string | 7159 | in_fi_ext_deal | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME_EXT | deal | VARCHAR2(34) | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension/deal | |
grossMargin |
Optional
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 |
Optional
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 |