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

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