...
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 | 3086date | 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 |
| 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 | 1587date | 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/prepaidLifemtgAmortTyp | |||||||||||
issueSpreadBenchmark | decimal | 16918 | string | 3065 | in_ | mtgissue_ | amortspread_ | typbnchmrk | SN | mbs_model.inc | SECURITYDBO | MBS | _DETAILMTG | ISSUE_ | AMORTSPREAD_ | TYPBNCHMRK | CHARNUMBER( | 1538,12) | EagleML/referenceTransaction/genericSMF/MBSModel/ | mtgAmortTypissueSpreadBenchmark | mtgAmtOutFace | ||
| sinkingFundFactor |
| decimal | 308316919 | in_ | mtgsinking_ | amtfund_ | out_facefactor | FN | 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 | |||||||||||||
| umbsLegacyPoolNumber | string | 17545 | in_umbs_legacy_pool_number | S | mbs_model.inc | SECURITYDBO | MBS | UMBS_LEGACY_POOL_NUMBER | VARCHAR2(12) | EagleML/referenceTransaction/genericSMF/MBSModel/umbsLegacyPoolNumber | |||||||||||||
| 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 |
| |||||||||
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 |