Generic SMF - MBS Model Data Map
Element | Required Inbound Acct Validation | Required Inbound Data Mgt | Value Type | Star Tag | SP Parameter | SP Type | Include File Name | Eagle DB | DB Table | DB Field | DB Field Type | Xpath |
---|---|---|---|---|---|---|---|---|---|---|---|---|
poolType |
|
| string | 1127 | in_pool_type | S | mbs_model.inc | SECURITYDBO | MBS | POOL_TYPE | CHAR(8) | EagleML/referenceTransaction/genericSMF/MBSModel/poolType |
delayDays |
|
| integer | 1567 | in_delay_days | N | mbs_model.inc | SECURITYDBO | MBS | DELAY_DAYS | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/delayDays |
agency |
|
| string | 1202 | in_agency | S | mbs_model.inc | SECURITYDBO | MBS | AGENCY | CHAR(12) | EagleML/referenceTransaction/genericSMF/MBSModel/agency |
balloonDate |
|
| date | 1203 | in_balloon_date | S | mbs_model.inc | SECURITYDBO | MBS | BALLOON_DATE | DATE | EagleML/referenceTransaction/genericSMF/MBSModel/balloonDate |
collateralCoupon |
|
| decimal | 1207 | in_collateral_coupon | F | mbs_model.inc | SECURITYDBO | MBS | COLLATERAL_COUPON | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/collateralCoupon |
collateralPoolType |
|
| string | 1209 | in_collatrl_type | S | mbs_model.inc | SECURITYDBO | MBS | COLLATRL_TYPE | CHAR(25) | EagleML/referenceTransaction/genericSMF/MBSModel/collateralPoolType |
origFaceAmt |
|
| decimal | 1215 | in_orig_face_amt | F | mbs_model.inc | SECURITYDBO | MBS | ORIG_FACE_AMT | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/origFaceAmt |
wacCurrent |
|
| decimal | 1227 | in_wac_current | F | mbs_model.inc | SECURITYDBO | MBS | WAC_CURRENT | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/wacCurrent |
wACOrig |
|
| decimal | 1228 | in_wac_orig | F | mbs_model.inc | SECURITYDBO | MBS | WAC_ORIG | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/wACOrig |
walInMonths |
|
| decimal | 1229 | in_wal_in_months | F | mbs_model.inc | SECURITYDBO | MBS | WAL_IN_MONTHS | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/walInMonths |
wAMOrigInMonths |
|
| decimal | 1230 | in_wam_orig_in_months | F | mbs_model.inc | SECURITYDBO | MBS | WAM_ORIG_IN_MONTHS | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/wAMOrigInMonths |
wamRemainInMonths |
|
| decimal | 1231 | in_wam_remain_in_months | F | mbs_model.inc | SECURITYDBO | MBS | WAM_REMAIN_IN_MONTHS | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/wamRemainInMonths |
mortgageType |
|
| string | 1572 | in_mortgage_type | S | mbs_model.inc | SECURITYDBO | MBS | MORTGAGE_TYPE | CHAR(25) | EagleML/referenceTransaction/genericSMF/MBSModel/mortgageType |
tranche |
|
| string | 1591 | in_tranche | S | mbs_model.inc | SECURITYDBO | MBS | TRANCHE | CHAR(30) | EagleML/referenceTransaction/genericSMF/MBSModel/tranche |
origWACG |
|
| decimal | 1818 | in_orig_wacg | F | mbs_model.inc | SECURITYDBO | MBS | ORIG_WACG | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/origWACG |
mtgAmortWAM |
|
| decimal | 3037 | in_mtg_amort_wam | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_AMORT_WAM | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mtgAmortWAM |
mtgCurPayDate |
|
| date | 3038 | in_mtg_cur_pay_dt | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_CUR_PAY_DT | DATE | EagleML/referenceTransaction/genericSMF/MBSModel/mtgCurPayDate |
mtgFirstRstDate |
|
| date | 3042 | in_mtg_first_rst_dt | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_FIRST_RST_DT | DATE | EagleML/referenceTransaction/genericSMF/MBSModel/mtgFirstRstDate |
mtgPayChgFreq |
|
| string | 3051 | in_mtg_pay_chg_freq | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_PAY_CHG_FREQ | VARCHAR2(16) | EagleML/referenceTransaction/genericSMF/MBSModel/mtgPayChgFreq |
mtgStatedDate |
|
| date | 3055 | in_mtg_stated_dt | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_STATED_DT | DATE | EagleML/referenceTransaction/genericSMF/MBSModel/mtgStatedDate |
mtgPoolFactor |
|
| decimal | 3066 | in_mtg_pool_factor | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_POOL_FACTOR | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mtgPoolFactor |
mtgFactorPayDate |
|
| date | 3086 | in_mtg_factor_pay_dt | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_FACTOR_PAY_DT | DATE | EagleML/referenceTransaction/genericSMF/MBSModel/mtgFactorPayDate |
collateralDesc |
|
| string | 1208 | in_collateral_desc | S | mbs_model.inc | SECURITYDBO | MBS | COLLATERAL_DESC | CHAR(50) | EagleML/referenceTransaction/genericSMF/MBSModel/collateralDesc |
serviceFee |
|
| decimal | 1823 | in_service_fee | F | mbs_model.inc | SECURITYDBO | MBS | SERVICE_FEE | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/serviceFee |
servicer |
|
| string | 1588 | in_servicer | S | mbs_model.inc | SECURITYDBO | MBS | SERVICER | VARCHAR2(50) | EagleML/referenceTransaction/genericSMF/MBSModel/servicer |
mtgTrustee |
|
| string | 3057 | in_mtg_trustee | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_TRUSTEE | VARCHAR2(16) | EagleML/referenceTransaction/genericSMF/MBSModel/mtgTrustee |
mtgLoanAge |
|
| decimal | 3046 | in_mtg_loan_age | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_LOAN_AGE | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mtgLoanAge |
prepaySpeed |
|
| decimal | 1128 | in_prepay_speed | F | mbs_model.inc | SECURITYDBO | MBS | PREPAY_SPEED | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/prepaySpeed |
allocationratio |
|
| decimal | 1812 | in_allocationratio | F | mbs_model.inc | SECURITYDBO | MBS | ALLOCATIONRATIO | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/allocationratio |
cap |
|
| decimal | 1204 | in_cap | F | mbs_model.inc | SECURITYDBO | MBS | CAP | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/cap |
cmoSeriesDescription |
|
| string | 1205 | in_cmo_series_description | S | mbs_model.inc | SECURITYDBO | MBS | CMO_SERIES_DESCRIPTION | CHAR(30) | EagleML/referenceTransaction/genericSMF/MBSModel/cmoSeriesDescription |
collateral |
|
| decimal | 1782 | in_collateral | F | mbs_model.inc | SECURITYDBO | MBS | COLLATERAL | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/collateral |
collateralmatdate |
|
| date | 1813 | in_collateralmatdate | S | mbs_model.inc | SECURITYDBO | MBS | COLLATERALMATDATE | DATE | EagleML/referenceTransaction/genericSMF/MBSModel/collateralmatdate |
collateralpercent1 |
|
| decimal | 1814 | in_collateralpercent1 | F | mbs_model.inc | SECURITYDBO | MBS | COLLATERALPERCENT1 | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/collateralpercent1 |
couponhi |
|
| decimal | 1815 | in_couponhi | F | mbs_model.inc | SECURITYDBO | MBS | COUPONHI | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/couponhi |
couponlo |
|
| decimal | 1816 | in_couponlo | F | mbs_model.inc | SECURITYDBO | MBS | COUPONLO | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/couponlo |
cpr12mnths |
|
| decimal | 1213 | in_cpr_12mnths | F | mbs_model.inc | SECURITYDBO | MBS | CPR_12MNTHS | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/cpr12mnths |
cpr1mnth |
|
| decimal | 1210 | in_cpr_1mnth | F | mbs_model.inc | SECURITYDBO | MBS | CPR_1MNTH | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/cpr1mnth |
cpr3mnths |
|
| decimal | 1211 | in_cpr_3mnths | F | mbs_model.inc | SECURITYDBO | MBS | CPR_3MNTHS | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/cpr3mnths |
cpr6mnths |
|
| decimal | 1212 | in_cpr_6mnths | F | mbs_model.inc | SECURITYDBO | MBS | CPR_6MNTHS | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/cpr6mnths |
dealmatdate |
|
| date | 1817 | in_dealmatdate | S | mbs_model.inc | SECURITYDBO | MBS | DEALMATDATE | DATE | EagleML/referenceTransaction/genericSMF/MBSModel/dealmatdate |
delayIndicator |
|
| string | 1134 | in_delay_indicator | S | mbs_model.inc | SECURITYDBO | MBS | DELAY_INDICATOR | CHAR(4) | EagleML/referenceTransaction/genericSMF/MBSModel/delayIndicator |
floor |
|
| decimal | 1214 | in_floor | F | mbs_model.inc | SECURITYDBO | MBS | FLOOR | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/floor |
gnmaPoolSuffix |
|
| string | 1135 | in_gnma_pool_suffix | S | mbs_model.inc | SECURITYDBO | MBS | GNMA_POOL_SUFFIX | CHAR(30) | EagleML/referenceTransaction/genericSMF/MBSModel/gnmaPoolSuffix |
govtPoolNumber |
|
| string | 107 | in_govt_pool_number | S | mbs_model.inc | SECURITYDBO | MBS | GOVT_POOL_NUMBER | CHAR(12) | EagleML/referenceTransaction/genericSMF/MBSModel/govtPoolNumber |
mtgOrigYear |
|
| decimal | 1783 | in_mtg_orig_year | F | mbs_model.inc | SECURITYDBO | MBS | MTG_ORIG_YEAR | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mtgOrigYear |
mbsMtgPlCprIss |
|
| decimal | 1206 | in_mbs_mtg_pl_cpr_iss | F | mbs_model.inc | SECURITYDBO | MBS | MTG_PL_CPR_ISS | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsMtgPlCprIss |
mbsMtgPlPsaIss |
|
| decimal | 1573 | in_mbs_mtg_pl_psa_iss | F | mbs_model.inc | SECURITYDBO | MBS | MTG_PL_PSA_ISS | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsMtgPlPsaIss |
notionalPrincipal |
|
| decimal | 1784 | in_notional_principal | F | mbs_model.inc | SECURITYDBO | MBS | NOTIONAL_PRINCIPAL | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/notionalPrincipal |
ofvCollateral |
|
| decimal | 3149 | in_ofv_collateral | F | mbs_model.inc | SECURITYDBO | MBS | OFV_COLLATERAL | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/ofvCollateral |
pacHigherCollar |
|
| decimal | 1216 | in_pac_higher_collar | F | mbs_model.inc | SECURITYDBO | MBS | PAC_HIGHER_COLLAR | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/pacHigherCollar |
pacLowerCollar |
|
| decimal | 1217 | in_pac_lower_collar | F | mbs_model.inc | SECURITYDBO | MBS | PAC_LOWER_COLLAR | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/pacLowerCollar |
pacSchedule |
|
| string | 1577 | in_pac_schedule | S | mbs_model.inc | SECURITYDBO | MBS | PAC_SCHEDULE | CHAR(2) | EagleML/referenceTransaction/genericSMF/MBSModel/pacSchedule |
paymentAccuralRate |
|
| decimal | 3151 | in_payment_accural_rate | F | mbs_model.inc | SECURITYDBO | MBS | PAYMENT_ACCURAL_RATE | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/paymentAccuralRate |
paymentDelay |
|
| decimal | 1133 | in_payment_delay | F | mbs_model.inc | SECURITYDBO | MBS | PAYMENT_DELAY | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/paymentDelay |
prepayTypeCode |
|
| string | 1129 | in_prepay_type_code | S | mbs_model.inc | SECURITYDBO | MBS | PREPAY_TYPE_CODE | CHAR(8) | EagleML/referenceTransaction/genericSMF/MBSModel/prepayTypeCode |
psa_12mnths |
|
| decimal | 1221 | in_psa_12mnths | F | mbs_model.inc | SECURITYDBO | MBS | PSA_12MNTHS | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/psa_12mnths |
psa_1mnth |
|
| decimal | 1218 | in_psa_1mnth | F | mbs_model.inc | SECURITYDBO | MBS | PSA_1MNTH | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/psa_1mnth |
psa_3mnths |
|
| decimal | 1219 | in_psa_3mnths | F | mbs_model.inc | SECURITYDBO | MBS | PSA_3MNTHS | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/psa_3mnths |
psa_6mnths |
|
| decimal | 1220 | in_psa_6mnths | F | mbs_model.inc | SECURITYDBO | MBS | PSA_6MNTHS | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/psa_6mnths |
psaMax |
|
| decimal | 1819 | in_psa_max | F | mbs_model.inc | SECURITYDBO | MBS | PSA_MAX | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/psaMax |
psaMin |
|
| decimal | 1820 | in_psa_min | F | mbs_model.inc | SECURITYDBO | MBS | PSA_MIN | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/psaMin |
repayEndDate |
|
| date | 1284 | in_repay_end_date | S | mbs_model.inc | SECURITYDBO | MBS | REPAY_END_DATE | DATE | EagleML/referenceTransaction/genericSMF/MBSModel/repayEndDate |
repayStartDate |
|
| date | 1587 | in_repay_start_date | S | mbs_model.inc | SECURITYDBO | MBS | REPAY_START_DATE | DATE | EagleML/referenceTransaction/genericSMF/MBSModel/repayStartDate |
spreadBnchmark |
|
| decimal | 1589 | in_spread_bnchmark | F | mbs_model.inc | SECURITYDBO | MBS | SPREAD_BNCHMARK | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/spreadBnchmark |
spreadTreasury |
|
| decimal | 1590 | in_spread_treasury | F | mbs_model.inc | SECURITYDBO | MBS | SPREAD_TREASURY | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/spreadTreasury |
trancheNumber |
|
| string | 1592 | in_tranche_number | S | mbs_model.inc | SECURITYDBO | MBS | TRANCHE_NUMBER | CHAR(30) | EagleML/referenceTransaction/genericSMF/MBSModel/trancheNumber |
trancheType |
|
| string | 1593 | in_tranche_type | S | mbs_extension.inc \mbs_model.inc | SECURITYDBO | MBS | TRANCHE_TYPE | CHAR(8) | EagleML/referenceTransaction/genericSMF/MBSModel/trancheType |
tranchmatdate |
|
| date | 1586 | in_tranchmatdate | S | mbs_model.inc | SECURITYDBO | MBS | TRANCHMATDATE | DATE | EagleML/referenceTransaction/genericSMF/MBSModel/tranchmatdate |
wamCollateral |
|
| decimal | 1822 | in_wam_collateral | F | mbs_model.inc | SECURITYDBO | MBS | WAM_COLLATERAL | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/wamCollateral |
prepaidLife |
|
| decimal | 10520 | in_prepaid_life | N | mbs_model.inc | SECURITYDBO | MBS | PREPAID_LIFE | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/prepaidLife |
issueSpreadBenchmark |
|
| decimal | 16918 | in_issue_spread_bnchmrk | N | mbs_model.inc | SECURITYDBO | MBS | ISSUE_SPREAD_BNCHMRK | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/MBSModel/issueSpreadBenchmark |
sinkingFundFactor |
|
| decimal | 16919 | in_sinking_fund_factor | N | mbs_model.inc | SECURITYDBO | MBS | SINKING_FUND_FACTOR | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/MBSModel/sinkingFundFactor |
fmaeIssuerConcentration |
|
| decimal | 17541 | in_fmae_issuer_concentration | N | mbs_model.inc | SECURITYDBO | MBS | FMAE_ISSUER_CONCENTRATION | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/MBSModel/fmaeIssuerConcentration |
fmacIssuerConcentration |
|
| decimal | 17542 | in_fmac_issuer_concentration | N | mbs_model.inc | SECURITYDBO | MBS | FMAC_ISSUER_CONCENTRATION | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/MBSModel/fmacIssuerConcentration |
umbsLegacyPoolIdentifier |
|
| string | 17545 | in_umbs_legacy_pool_number | S | mbs_model.inc | SECURITYDBO | MBS | UMBS_LEGACY_POOL_NUMBER | VARCHAR2(12) | EagleML/referenceTransaction/genericSMF/MBSModel/umbsLegacyPoolIdentifier |
umbsLegacyPoolCusip |
|
| string | 17546 | in_umbs_legacy_pool_cusip | S | mbs_model.inc | SECURITYDBO | MBS | UMBS_LEGACY_POOL_CUSIP | VARCHAR2(12) | EagleML/referenceTransaction/genericSMF/MBSModel/umbsLegacyPoolCusip |
mtgAmortTyp |
|
| string | 3065 | in_mtg_amort_typ | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_AMORT_TYP | CHAR(15) | EagleML/referenceTransaction/genericSMF/MBSModel/mtgAmortTyp |
mtgAmtOutFace |
|
| decimal | 3083 | in_mtg_amt_out_face | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_AMT_OUT_FACE | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mtgAmtOutFace |
mtgBalloonWam |
|
| decimal | 3084 | in_mtg_balloon_wam | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_BALLOON_WAM | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mtgBalloonWam |
mtgDealCurCollatAmt |
|
| decimal | 3039 | in_mtg_deal_cur_collat_amt | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_DEAL_CUR_COLLAT_AMT | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mtgDealCurCollatAmt |
mtgDealCurNet |
|
| decimal | 3040 | in_mtg_deal_cur_net | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_DEAL_CUR_NET | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mtgDealCurNet |
mtgFaceAmt |
|
| decimal | 3085 | in_mtg_face_amt | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_FACE_AMT | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mtgFaceAmt |
mtgFactorNumDt |
|
| date | 3067 | in_mtg_factor_num_dt | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_FACTOR_NUM_DT | DATE | EagleML/referenceTransaction/genericSMF/MBSModel/mtgFactorNumDt |
mtgFactorPayRt |
|
| decimal | 3087 | in_mtg_factor_pay_rt | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_FACTOR_PAY_RT | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mtgFactorPayRt |
mtgFirstPayDt |
|
| date | 3088 | in_mtg_first_pay_dt | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_FIRST_PAY_DT | DATE | EagleML/referenceTransaction/genericSMF/MBSModel/mtgFirstPayDt |
mtgFirstPayRstDt |
|
| date | 3041 | in_mtg_first_pay_rst_dt | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_FIRST_PAY_RST_DT | DATE | EagleML/referenceTransaction/genericSMF/MBSModel/mtgFirstPayRstDt |
mtgFltLastRst |
|
| date | 3043 | in_mtg_flt_last_rst | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_FLT_LAST_RST | DATE | EagleML/referenceTransaction/genericSMF/MBSModel/mtgFltLastRst |
mtgFltNxtRst |
|
| date | 3044 | in_mtg_flt_nxt_rst | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_FLT_NXT_RST | DATE | EagleML/referenceTransaction/genericSMF/MBSModel/mtgFltNxtRst |
mtgGenCprIss |
|
| decimal | 3089 | in_mtg_gen_cpr_iss | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_GEN_CPR_ISS | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mtgGenCprIss |
mtgGenPsaIss |
|
| decimal | 3090 | in_mtg_gen_psa_iss | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_GEN_PSA_ISS | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mtgGenPsaIss |
mtgGenTicker |
|
| string | 3045 | in_mtg_gen_ticker | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_GEN_TICKER | CHAR(100) | EagleML/referenceTransaction/genericSMF/MBSModel/mtgGenTicker |
mtgNxtAdjDt |
|
| date | 3047 | in_mtg_nxt_adj_dt | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_NXT_ADJ_DT | DATE | EagleML/referenceTransaction/genericSMF/MBSModel/mtgNxtAdjDt |
mtgOrigAmt |
|
| decimal | 3048 | in_mtg_orig_amt | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_ORIG_AMT | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mtgOrigAmt |
mtgOrigWal |
|
| decimal | 3049 | in_mtg_orig_wal | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_ORIG_WAL | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mtgOrigWal |
mtgPayCap |
|
| decimal | 3050 | in_mtg_pay_cap | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_PAY_CAP | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mtgPayCap |
mtgPerRtCap |
|
| decimal | 3052 | in_mtg_per_rt_cap | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_PER_RT_CAP | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mtgPerRtCap |
mtgPlAbsIss |
|
| decimal | 3053 | in_mtg_pl_abs_iss | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_PL_ABS_ISS | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mtgPlAbsIss |
mbsdMtgPlCprIss |
|
| decimal | 3091 | in_mbsd_mtg_pl_cpr_iss | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_PL_CPR_ISS | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsdMtgPlCprIss |
mbsdMtgPlPsaIss |
|
| decimal | 3092 | in_mbsd_mtg_pl_psa_iss | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_PL_PSA_ISS | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsdMtgPlPsaIss |
mtgRtChgFreq |
|
| string | 3054 | in_mtg_rt_chg_freq | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_RT_CHG_FREQ | VARCHAR2(16) | EagleML/referenceTransaction/genericSMF/MBSModel/mtgRtChgFreq |
mtgStatedWala |
|
| decimal | 3093 | in_mtg_stated_wala | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_STATED_WALA | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mtgStatedWala |
mtgStatedWarm |
|
| decimal | 3094 | in_mtg_stated_warm | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_STATED_WARM | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mtgStatedWarm |
mtgTrancheTypLong |
|
| string | 3056 | in_mtg_tranche_typ_long | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_TRANCHE_TYP_LONG | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSModel/mtgTrancheTypLong |
mtgWacArmCpn |
|
| decimal | 3058 | in_mtg_wac_arm_cpn | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_WAC_ARM_CPN | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mtgWacArmCpn |
mtgWalaCalc |
|
| decimal | 3059 | in_mtg_wala_calc | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_WALA_CALC | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mtgWalaCalc |
mtgWamSd |
|
| decimal | 3060 | in_mtg_wam_sd | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_WAM_SD | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mtgWamSd |
mtgWamSdYrm |
|
| decimal | 3061 | in_mtg_wam_sd_yrm | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_WAM_SD_YRM | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mtgWamSdYrm |
mtgWamYrm |
|
| decimal | 3062 | in_mtg_wam_yrm | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_WAM_YRM | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mtgWamYrm |
mtgWhlnWala |
|
| decimal | 3063 | in_mtg_whln_wala | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_WHLN_WALA | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mtgWhlnWala |
mtgWhlnWaltv |
|
| decimal | 3064 | in_mtg_whln_waltv | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_WHLN_WALTV | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mtgWhlnWaltv |
mbsChar1 |
|
| string | 3073 | in_mbs_char1 | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_CHAR1 | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsChar1 |
mbsChar2 |
|
| string | 3074 | in_mbs_char2 | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_CHAR2 | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsChar2 |
mbsChar3 |
|
| string | 3075 | in_mbs_char3 | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_CHAR3 | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsChar3 |
mbsChar4 |
|
| string | 3076 | in_mbs_char4 | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_CHAR4 | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsChar4 |
mbsChar5 |
|
| string | 3077 | in_mbs_char5 | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_CHAR5 | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsChar5 |
mbsChar6 |
|
| string | 3537 | in_mbs_char6 | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_CHAR6 | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsChar6 |
mbsChar7 |
|
| string | 3538 | in_mbs_char7 | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_CHAR7 | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsChar7 |
mbsChar8 |
|
| string | 3539 | in_mbs_char8 | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_CHAR8 | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsChar8 |
mbsChar9 |
|
| string | 3540 | in_mbs_char9 | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_CHAR9 | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsChar9 |
mbsChar10 |
|
| string | 3541 | in_mbs_char10 | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_CHAR10 | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsChar10 |
mbsDate1 |
|
| date | 3078 | in_mbs_date1 | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_DATE1 | DATE | EagleML/referenceTransaction/genericSMF/MBSModel/mbsDate1 |
mbsDate2 |
|
| date | 3079 | in_mbs_date2 | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_DATE2 | DATE | EagleML/referenceTransaction/genericSMF/MBSModel/mbsDate2 |
mbsDate3 |
|
| date | 3080 | in_mbs_date3 | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_DATE3 | DATE | EagleML/referenceTransaction/genericSMF/MBSModel/mbsDate3 |
mbsDate4 |
|
| date | 3081 | in_mbs_date4 | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_DATE4 | DATE | EagleML/referenceTransaction/genericSMF/MBSModel/mbsDate4 |
mbsDate5 |
|
| date | 3082 | in_mbs_date5 | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_DATE5 | DATE | EagleML/referenceTransaction/genericSMF/MBSModel/mbsDate5 |
mbsDate6 |
|
| date | 3562 | in_mbs_date6 | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_DATE6 | DATE | EagleML/referenceTransaction/genericSMF/MBSModel/mbsDate6 |
mbsDate7 |
|
| date | 3563 | in_mbs_date7 | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_DATE7 | DATE | EagleML/referenceTransaction/genericSMF/MBSModel/mbsDate7 |
mbsDate8 |
|
| date | 3564 | in_mbs_date8 | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_DATE8 | DATE | EagleML/referenceTransaction/genericSMF/MBSModel/mbsDate8 |
mbsDate9 |
|
| date | 3565 | in_mbs_date9 | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_DATE9 | DATE | EagleML/referenceTransaction/genericSMF/MBSModel/mbsDate9 |
mbsDate10 |
|
| date | 3566 | in_mbs_date10 | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_DATE10 | DATE | EagleML/referenceTransaction/genericSMF/MBSModel/mbsDate10 |
mbsFloat1 |
|
| decimal | 3068 | in_mbs_float1 | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_FLOAT1 | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsFloat1 |
mbsFloat2 |
|
| decimal | 3069 | in_mbs_float2 | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_FLOAT2 | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsFloat2 |
mbsFloat3 |
|
| decimal | 3070 | in_mbs_float3 | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_FLOAT3 | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsFloat3 |
mbsFloat4 |
|
| decimal | 3071 | in_mbs_float4 | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_FLOAT4 | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsFloat4 |
mbsFloat5 |
|
| decimal | 3072 | in_mbs_float5 | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_FLOAT5 | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsFloat5 |
mbsFloat6 |
|
| decimal | 3542 | in_mbs_float6 | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_FLOAT6 | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsFloat6 |
mbsFloat7 |
|
| decimal | 3543 | in_mbs_float7 | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_FLOAT7 | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsFloat7 |
mbsFloat8 |
|
| decimal | 3544 | in_mbs_float8 | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_FLOAT8 | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsFloat8 |
mbsFloat9 |
|
| decimal | 3545 | in_mbs_float9 | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_FLOAT9 | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsFloat9 |
mbsFloat10 |
|
| decimal | 3546 | in_mbs_float10 | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_FLOAT10 | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsFloat10 |
mbsFloat11 |
|
| decimal | 3547 | in_mbs_float11 | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_FLOAT11 | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsFloat11 |
mbsFloat12 |
|
| decimal | 3548 | in_mbs_float12 | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_FLOAT12 | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsFloat12 |
mbsFloat13 |
|
| decimal | 3549 | in_mbs_float13 | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_FLOAT13 | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsFloat13 |
mbsFloat14 |
|
| decimal | 3550 | in_mbs_float14 | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_FLOAT14 | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsFloat14 |
mbsFloat15 |
|
| decimal | 3551 | in_mbs_float15 | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_FLOAT15 | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsFloat15 |
mbsFloat16 |
|
| decimal | 3552 | in_mbs_float16 | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_FLOAT16 | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsFloat16 |
mbsFloat17 |
|
| decimal | 3553 | in_mbs_float17 | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_FLOAT17 | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsFloat17 |
mbsFloat18 |
|
| decimal | 3554 | in_mbs_float18 | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_FLOAT18 | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsFloat18 |
mbsFloat19 |
|
| decimal | 3555 | in_mbs_float19 | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_FLOAT19 | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsFloat19 |
mbsFloat20 |
|
| decimal | 3556 | in_mbs_float20 | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_FLOAT20 | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsFloat20 |
mbsFloat21 |
|
| decimal | 3557 | in_mbs_float21 | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_FLOAT21 | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsFloat21 |
mbsFloat22 |
|
| decimal | 3558 | in_mbs_float22 | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_FLOAT22 | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsFloat22 |
mbsFloat23 |
|
| decimal | 3559 | in_mbs_float23 | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_FLOAT23 | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsFloat23 |
mbsFloat24 |
|
| decimal | 3560 | in_mbs_float24 | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_FLOAT24 | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsFloat24 |
mbsFloat25 |
|
| decimal | 3561 | in_mbs_float25 | F | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MBS_FLOAT25 | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/MBSModel/mbsFloat25 |
mtgDealCallDate |
|
| date | 17565 | in_mtg_deal_call_dt | S | mbs_model.inc | SECURITYDBO | MBS_DETAIL | MTG_DEAL_CALL_DT | DATE | EagleML/referenceTransaction/genericSMF/MBSModel/mtgDealCallDate |