Generic SMF - MBS Extension Data Map
- Natalie Gesin (Deactivated)
- Kinga Huszno
- Alexey Chunikhin
Element | Optional/ Required | Value Type | Star Tag | SP Parameter | SP Type | Include File Name | Eagle DB | DB Table | DB Field | DB Field Type | Xpath |
|---|---|---|---|---|---|---|---|---|---|---|---|
mtgExpectedMaturityDate |
| date | 10273 | in_mtg_expected_maturity_date | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MTG_EXPECTED_MATURITY_DATE | DATE | EagleML/referenceTransaction/genericSMF/MBSExtension/mtgExpectedMaturityDate |
issueYield |
| decimal | 10253 | in_issue_yield | N | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | ISSUE_YIELD | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSExtension/issueYield |
mortgageDealType |
| string | 10269 | in_mortgage_deal_type | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MORTGAGE_DEAL_TYPE | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSExtension/mortgageDealType |
mtgDealOrigCurrentNetCpn |
| decimal | 10305 | in_mtg_deal_orig_currt_net_cpn | N | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MTG_DEAL_ORIG_CURRENT_NET_CPN | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSExtension/mtgDealOrigCurrentNetCpn |
mortgageOIDDeMinimis |
| string | 10308 | in_mortgage_oid_de_minimis | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MORTGAGE_OID_DE_MINIMIS | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSExtension/mortgageOIDDeMinimis |
cmoClass |
| string | 10262 | in_cmo_class | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | CMO_CLASS | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSExtension/cmoClass |
currDesMtgCmClsDlPct |
| decimal | 10260 | in_curr_des_mtg_cm_cls_dl_pct | N | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | CURR_DES_MTG_COM_CLS_DEAL_PCT | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSExtension/currDesMtgCmClsDlPct |
genericFactor |
| decimal | 10275 | in_generic_factor | N | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | GENERIC_FACTOR | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSExtension/genericFactor |
issueBenchmark |
| string | 10254 | in_issue_benchmark | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | ISSUE_BENCHMARK | VARCHAR2(20) | EagleML/referenceTransaction/genericSMF/MBSExtension/issueBenchmark |
isLottery |
| string | 10255 | in_is_lottery | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | IS_LOTTERY | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSExtension/isLottery |
mortgage1984TaxIndicator |
| string | 10293 | in_mortgage_1984_tax_indicator | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MORTGAGE_1984_TAX_INDICATOR | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSExtension/mortgage1984TaxIndicator |
mortgage1985TaxIndicator |
| string | 10294 | in_mortgage_1985_tax_indicator | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MORTGAGE_1985_TAX_INDICATOR | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSExtension/mortgage1985TaxIndicator |
mortgageBaseRate |
| decimal | 10306 | in_mortgage_base_rate | N | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MORTGAGE_BASE_RATE | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSExtension/mortgageBaseRate |
mortgageCmoGroup |
| string | 10264 | in_mortgage_cmo_group | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MORTGAGE_CMO_GROUP | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSExtension/mortgageCmoGroup |
mortgCollateralAsOfDate |
| date | 10265 | in_mortg_collateral_as_of_date | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MORTGAGE_COLLATERAL_AS_OF_DATE | DATE | EagleML/referenceTransaction/genericSMF/MBSExtension/mortgCollateralAsOfDate |
mortgageComplianceCode |
| string | 10266 | in_mortgage_compliance_code | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MORTGAGE_COMPLIANCE_CODE | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSExtension/mortgageComplianceCode |
mortgContributedCashflows |
| string | 10267 | in_mortg_contributed_cashflows | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MORTGAGE_CONTRIBUTED_CASHFLOWS | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSExtension/mortgContributedCashflows |
mortgDealCallPercentage |
| decimal | 10268 | in_mortg_deal_call_percentage | N | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MORTGAGE_DEAL_CALL_PERCENTAGE | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSExtension/mortgDealCallPercentage |
mortgageDtcType |
| string | 10270 | in_mortgage_dtc_type | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MORTGAGE_DTC_TYPE | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSExtension/mortgageDtcType |
mortgageEndAccrualDate |
| date | 10271 | in_mortgage_end_accrual_date | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MORTGAGE_END_ACCRUAL_DATE | DATE | EagleML/referenceTransaction/genericSMF/MBSExtension/mortgageEndAccrualDate |
mortgageFinalPaymentDate |
| date | 10300 | in_mortgage_final_payment_date | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MORTGAGE_FINAL_PAYMENT_DATE | DATE | EagleML/referenceTransaction/genericSMF/MBSExtension/mortgageFinalPaymentDate |
mortgInterestDistributed |
| decimal | 10276 | in_mortg_interest_distributed | N | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MORTGAGE_INTEREST_DISTRIBUTED | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSExtension/mortgInterestDistributed |
mortgageOidClassType |
| string | 10307 | in_mortgage_oid_class_type | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MORTGAGE_OID_CLASS_TYPE | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSExtension/mortgageOidClassType |
mortgOidDiscountStatus |
| string | 10310 | in_mortg_oid_discount_status | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MORTGAGE_OID_DISCOUNT_STATUS | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSExtension/mortgOidDiscountStatus |
mortgageOidRetailFlag |
| string | 10309 | in_mortgage_oid_retail_flag | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MORTGAGE_OID_RETAIL_FLAG | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSExtension/mortgageOidRetailFlag |
mortgOriginalPacCollars |
| string | 10296 | in_mortg_original_pac_collars | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MORTGAGE_ORIGINAL_PAC_COLLARS | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSExtension/mortgOriginalPacCollars |
mortgageOriginalWam |
| decimal | 10303 | in_mortgage_original_wam | N | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MORTGAGE_ORIGINAL_WAM | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSExtension/mortgageOriginalWam |
mortgagePacCollars |
| string | 10295 | in_mortgage_pac_collars | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MORTGAGE_PAC_COLLARS | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSExtension/mortgagePacCollars |
mortgagePacUpdateDate |
| date | 10301 | in_mortgage_pac_update_date | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MORTGAGE_PAC_UPDATE_DATE | DATE | EagleML/referenceTransaction/genericSMF/MBSExtension/mortgagePacUpdateDate |
mortgagePreviousBalance |
| string | 10285 | in_mortgage_previous_balance | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MORTGAGE_PREVIOUS_BALANCE | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSExtension/mortgagePreviousBalance |
mortgPreviousFactorDate |
| string | 10286 | in_mortg_previous_factor_date | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MORTGAGE_PREVIOUS_FACTOR_DATE | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSExtension/mortgPreviousFactorDate |
mortgagePricingSpeed |
| string | 10288 | in_mortgage_pricing_speed | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MORTGAGE_PRICING_SPEED | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSExtension/mortgagePricingSpeed |
mortgagePricingSpeedDate |
| date | 10289 | in_mortgage_pricing_speed_date | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MORTGAGE_PRICING_SPEED_DATE | DATE | EagleML/referenceTransaction/genericSMF/MBSExtension/mortgagePricingSpeedDate |
mortgagePrincipalWindow |
| string | 10298 | in_mortgage_principal_window | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MORTGAGE_PRINCIPAL_WINDOW | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSExtension/mortgagePrincipalWindow |
mortgageRecordDate |
| date | 10290 | in_mortgage_record_date | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MORTGAGE_RECORD_DATE | DATE | EagleML/referenceTransaction/genericSMF/MBSExtension/mortgageRecordDate |
mortgageSmmeaStatus |
| string | 10291 | in_mortgage_smmea_status | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MORTGAGE_SMMEA_STATUS | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSExtension/mortgageSmmeaStatus |
mortgStartAccrualDate |
| date | 10292 | in_mortg_start_accrual_date | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MORTGAGE_START_ACCRUAL_DATE | DATE | EagleML/referenceTransaction/genericSMF/MBSExtension/mortgStartAccrualDate |
mortgageWamInMonths |
| decimal | 10315 | in_mortgage_wam_in_months | N | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MORTGAGE_WAM_IN_MONTHS | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSExtension/mortgageWamInMonths |
mostRecentAccrualRate |
| decimal | 10256 | in_most_recent_accrual_rate | N | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MOST_RECENT_ACCRUAL_RATE | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSExtension/mostRecentAccrualRate |
mtgBegnOfNxtAccrPeriod |
| date | 10282 | in_mtg_begn_of_nxt_accr_period | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MTG_BEGIN_OF_NXT_ACCR_PERIOD | DATE | EagleML/referenceTransaction/genericSMF/MBSExtension/mtgBegnOfNxtAccrPeriod |
mtgCleanupCallPercentage |
| decimal | 10259 | in_mtg_cleanup_call_percentage | N | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MTG_CLEANUP_CALL_PERCENTAGE | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSExtension/mtgCleanupCallPercentage |
mtgCmoCollateralCurrency |
| string | 10263 | in_mtg_cmo_collateral_currency | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MTG_CMO_COLLATERAL_CURRENCY | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSExtension/mtgCmoCollateralCurrency |
mtgDealCurrentNetCoupon |
| decimal | 10304 | in_mtg_deal_current_net_coupon | N | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MTG_DEAL_CURRENT_NET_COUPON | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSExtension/mtgDealCurrentNetCoupon |
mtgEndAccrDatePerSetle |
| date | 10272 | in_mtg_end_accr_date_per_setle | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MTG_END_ACCR_DATE_PER_SETTLE | DATE | EagleML/referenceTransaction/genericSMF/MBSExtension/mtgEndAccrDatePerSetle |
mtgEndPripalWndw4Matu |
| date | 10316 | in_mtg_end_pripal_wndw_4_matu | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MTG_END_PRINCPAL_WNDW_FOR_MATU | DATE | EagleML/referenceTransaction/genericSMF/MBSExtension/mtgEndPripalWndw4Matu |
mtgFactorDate |
| string | 10319 | in_mtg_factor_date | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MTG_FACTOR_DATE | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSExtension/mtgFactorDate |
mtgFactorPerSettle |
| decimal | 10321 | in_mtg_factor_per_settle | N | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MTG_FACTOR_PER_SETTLE | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSExtension/mtgFactorPerSettle |
mtgFctrPerStlEndAccDt |
| date | 10320 | in_mtg_fctr_per_stl_end_acc_dt | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MTG_FACTOR_PER_STL_END_ACC_DT | DATE | EagleML/referenceTransaction/genericSMF/MBSExtension/mtgFctrPerStlEndAccDt |
mtgFactorPerStlPayDt |
| date | 10322 | in_mtg_factor_per_stl_pay_dt | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MTG_FACTOR_PER_STL_PAY_DT | DATE | EagleML/referenceTransaction/genericSMF/MBSExtension/mtgFactorPerStlPayDt |
mtgFactrPerStlStAccDt |
| date | 10323 | in_mtg_factr_per_stl_st_acc_dt | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MTG_FACTOR_PER_STL_ST_ACC_DT | DATE | EagleML/referenceTransaction/genericSMF/MBSExtension/mtgFactrPerStlStAccDt |
mtgFactStlStrNxtAcrDt |
| date | 10274 | in_mtg_fact_stl_str_nxt_acr_dt | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MTG_FACT_STL_START_NXT_ACCR_DT | DATE | EagleML/referenceTransaction/genericSMF/MBSExtension/mtgFactStlStrNxtAcrDt |
mtgIsMegaPlatinumGiant |
| string | 10277 | in_mtg_is_mega_platinum_giant | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MTG_IS_MEGA_PLATINUM_GIANT | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSExtension/mtgIsMegaPlatinumGiant |
mtgNbrOfBdsInDealrgrp |
| string | 10279 | in_mtg_nbr_of_bds_in_dealrgrp | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MTG_NBR_OF_BDS_IN_DEAL_OR_GRP | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSExtension/mtgNbrOfBdsInDealrgrp |
mtgNbrOfCptBdsInDeal |
| string | 10280 | in_mtg_nbr_of_cpt_bds_in_deal | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MTG_NBR_OF_CPT_BDS_IN_DEAL | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSExtension/mtgNbrOfCptBdsInDeal |
mtgNxtPayDtPerSettle |
| date | 10283 | in_mtg_nxt_pay_dt_per_settle | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MTG_NEXT_PAY_DATE_PER_SETTLE | DATE | EagleML/referenceTransaction/genericSMF/MBSExtension/mtgNxtPayDtPerSettle |
mtgNotionalPrincipalFlag |
| string | 10278 | in_mtg_notional_principal_flag | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MTG_NOTIONAL_PRINCIPAL_FLAG | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSExtension/mtgNotionalPrincipalFlag |
mtgNumpolsRLoanBakDeal |
| string | 10281 | in_mtg_numpols_r_loan_bak_deal | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MTG_NUMPOOLS_OR_LOAN_BACK_DEAL | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSExtension/mtgNumpolsRLoanBakDeal |
mtgOriginalWac |
| decimal | 10324 | in_mtg_original_wac | N | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MTG_ORIGINAL_WAC | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSExtension/mtgOriginalWac |
mtgPrevFactorNumericDt |
| date | 10287 | in_mtg_prev_factor_numeric_dt | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MTG_PREVIOUS_FACTOR_NUMERIC_DT | DATE | EagleML/referenceTransaction/genericSMF/MBSExtension/mtgPrevFactorNumericDt |
mtgPymtMethProrataRandm |
| string | 10284 | in_mtg_pymt_meth_prorata_randm | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MTG_PYMT_METH_PRORATA_RANDOM | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSExtension/mtgPymtMethProrataRandm |
mtgRecentAccRateEndDt |
| date | 10257 | in_mtg_recent_acc_rate_end_dt | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MTG_RECENT_ACC_RATE_END_DT | DATE | EagleML/referenceTransaction/genericSMF/MBSExtension/mtgRecentAccRateEndDt |
mtgRecentAccRateStrtDt |
| date | 10258 | in_mtg_recent_acc_rate_strt_dt | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MTG_RECENT_ACC_RATE_START_DT | DATE | EagleML/referenceTransaction/genericSMF/MBSExtension/mtgRecentAccRateStrtDt |
mtgStartPrincplWndwMatu |
| string | 10302 | in_mtg_start_princpl_wndw_matu | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MTG_START_PRINCIPAL_WNDW_MATU | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSExtension/mtgStartPrincplWndwMatu |
mtgWacUsedInCalclations |
| decimal | 10299 | in_mtg_wac_used_in_calclations | N | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MTG_WAC_USED_IN_CALCULATIONS | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSExtension/mtgWacUsedInCalclations |
origDesMtgCmoClsDlPct |
| decimal | 10261 | in_orig_des_mtg_cmo_cls_dl_pct | N | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | ORIG_DES_MTG_CMO_CLS_DEAL_PCT | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSExtension/origDesMtgCmoClsDlPct |
poolAbs12Months |
| decimal | 10314 | in_pool_abs_12_months | N | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | POOL_ABS_12_MONTHS | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSExtension/poolAbs12Months |
poolAbs1Month |
| decimal | 10311 | in_pool_abs_1_month | N | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | POOL_ABS_1_MONTH | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSExtension/poolAbs1Month |
poolAbs3Months |
| decimal | 10312 | in_pool_abs_3_months | N | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | POOL_ABS_3_MONTHS | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSExtension/poolAbs3Months |
poolAbs6Months |
| decimal | 10313 | in_pool_abs_6_months | N | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | POOL_ABS_6_MONTHS | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSExtension/poolAbs6Months |
prepaymentSpeedAndType |
| string | 10297 | in_prepayment_speed_and_type | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | PREPAYMENT_SPEED_AND_TYPE | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSExtension/prepaymentSpeedAndType |
previousFactor |
| decimal | 10317 | in_previous_factor | N | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | PREVIOUS_FACTOR | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSExtension/previousFactor |
trancheTypeLongDesc |
| string | 10318 | in_tranche_type_long_desc | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | TRANCHE_TYPE_LONG_DESC | VARCHAR2(180) | EagleML/referenceTransaction/genericSMF/MBSExtension/trancheTypeLongDesc |
prepaySensitiveFlag |
| string | 10521 | in_prepay_sensitive_flag | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | PREPAY_SENSITIVE_FLAG | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/MBSExtension/prepaySensitiveFlag |
remicFlag |
| string | 10522 | in_remic_flag | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | REMIC_FLAG | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/MBSExtension/remicFlag |
nextFactorDate |
| date | 16916 | in_nxt_factor_dt | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | NXT_FACTOR_DT | DATE | EagleML/referenceTransaction/genericSMF/MBSExtension/nextFactorDate |
recentReportedFactor |
| decimal | 16917 | in_recent_reported_factor | N | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | RECENT_REPORTED_FACTOR | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/MBSExtension/recentReportedFactor |
mortgageCprSpeed |
| PaymentFrequencyEnum | 18319 | in_mtg_spr_speed | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MTG_CPR_SPEED | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/MBSExtension/mortgageCprSpeed |
mortgagePsaSpeed |
| PaymentFrequencyEnum | 18320 | in_mtg_psa_speed | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MTG_PSA_SPEED | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/MBSExtension/mortgagePsaSpeed |
mortgageWeightedAverageLife |
| decimal | 18321 | in_mtg_wal | N | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MTG_WAL | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/MBSExtension/mortgageWeightedAverageLife |
mortgagePrincipalLosses |
| decimal | 18322 | in_mtg_princ_loses | N | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | MTG_PRINC_LOSSES | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/MBSExtension/mortgagePrincipalLosses |
wamNextResetTerm |
| string | 18374 | in_wam_neext_reset | S |
| SECURITYDBO | MBS_DETAIL_EXT | WAM_NEXT_RESET | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/MBSExtension/wamNextResetTerm |
prepayPenaltyTerm |
| integer | 18383 | in_prepay_penalty_term | N |
| SECURITYDBO | MBS_DETAIL_EXT | PREPAY_PENALTY_TERM | NUMBER(38) | EagleML/referenceTransaction/genericSMF/MBSExtension/prepayPenaltyTerm |
prepayPenaltyType |
| string | 18384 | in_prepay_penalty_type | S |
| SECURITYDBO | MBS_DETAIL_EXT | PREPAY_PENALTY_TYPE | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/MBSExtension/prepayPenaltyType |
armInitFixedPeriodMonths |
| integer | 18566 | in_arm_ini_fixed_period_months | S | mbs_extension.inc | SECURITYDBO | MBS_DETAIL_EXT | ARM_INIT_FIXED_PERIOD_MONTHS | NUMBER(38,0) | EagleML/referenceTransaction/genericSMF/MBSExtension/armInitFixedPeriodMonths |