Generic SMF - MBS Model Data Map
- Natalie Gesin (Deactivated)
- Anna Krapivina
- Dmitry Donosiyan (Unlicensed)
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 |