Generic SMF - Mtg Loan Model Data Map
- Natalie Gesin (Deactivated)
- Kinga Huszno
- Dmitry Donosiyan (Unlicensed)
- Anna Krapivina
MTG_LOAN table is available only in environments v13.0 and higher.
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
dscrNext12 |
|
| decimal | 11586 | in_ml_dscr_next12 | N | mtgloan_model.inc | SECURITYDBO | MTG_LOAN | DSCR_NEXT12 | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/mtgLoanModel/dscrNext12 |
dscrNext12Date |
|
| date | 11587 | in_ml_dscr_next12_date | S | mtgloan_model.inc | SECURITYDBO | MTG_LOAN | DSCR_NEXT12_DATE | DATE | EagleML/referenceTransaction/genericSMF/mtgLoanModel/dscrNext12Date |
dscrTrail12 |
|
| decimal | 11588 | in_ml_dscr_trail12 | N | mtgloan_model.inc | SECURITYDBO | MTG_LOAN | DSCR_TRAIL12 | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/mtgLoanModel/dscrTrail12 |
dscrTrail12Date |
|
| date | 11589 | in_ml_dscr_trail12_date | S | mtgloan_model.inc | SECURITYDBO | MTG_LOAN | DSCR_TRAIL12_DATE | DATE | EagleML/referenceTransaction/genericSMF/mtgLoanModel/dscrTrail12Date |
lossGivenDefault |
|
| decimal | 11590 | in_ml_lcg_pct | N | mtgloan_model.inc | SECURITYDBO | MTG_LOAN | LCG_PCT | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/mtgLoanModel/lossGivenDefault |
loanToValue |
|
| decimal | 11591 | in_ml_loan_to_value | N | mtgloan_model.inc | SECURITYDBO | MTG_LOAN | LOAN_TO_VALUE | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/mtgLoanModel/loanToValue |
strategy |
|
| string | 11592 | in_ml_strategy | S | mtgloan_model.inc | SECURITYDBO | MTG_LOAN | STRATEGY | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/mtgLoanModel/strategy |
origPrinLockoutMos |
|
| decimal | 11595 | in_ml_orig_prin_lockout_mos | N | mtgloan_model.inc | SECURITYDBO | MTG_LOAN | ORIG_PRIN_LOCKOUT_MOS | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/mtgLoanModel/origPrinLockoutMos |
amortMaturityDate |
|
| date | 11594 | in_ml_amort_maturity_date | S | mtgloan_model.inc | SECURITYDBO | MTG_LOAN | AMORT_MATURITY_DATE | DATE | EagleML/referenceTransaction/genericSMF/mtgLoanModel/amortMaturityDate |
loanTermInMonthsOrYear |
|
| decimal | 17578 | in_loan_term_in_months_or_year | N | mtgloan_model.inc | SECURITYDBO | MTG_LOAN | LOAN_TERM_IN_MONTHS_OR_YEAR | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/mtgLoanModel/loanTermInMonthsOrYear |
accountingInterestDefaultDate |
|
| date | 16667 | in_acct_int_default_date | S | mtgloan_model.inc | SECURITYDBO | MTG_LOAN | ACCT_INT_DEFAULT_DATE | DATE | EagleML/referenceTransaction/genericSMF/mtgLoanModel/accountingInterestDefaultDate |
accountingPrincipalDefaultDate |
|
| date | 16668 | in_acct_prin_default_date | S | mtgloan_model.inc | SECURITYDBO | MTG_LOAN | ACCT_PRIN_DEFAULT_DATE | DATE | EagleML/referenceTransaction/genericSMF/mtgLoanModel/accountingPrincipalDefaultDate |
balloonFlag |
|
| string | 16670 | in_balloon_flag | S | mtgloan_model.inc | SECURITYDBO | MTG_LOAN | BALLOON_FLAG | VARCHAR2(2) | EagleML/referenceTransaction/genericSMF/mtgLoanModel/balloonFlag |
balloonPaymentFactor |
|
| decimal | 16671 | in_balloon_pmt_factor | N | mtgloan_model.inc | SECURITYDBO | MTG_LOAN | BALLOON_PMT_FACTOR | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/mtgLoanModel/balloonPaymentFactor |
firstInterestPaymentDate |
|
| date | 16672 | in_first_int_pmt_date | S | mtgloan_model.inc | SECURITYDBO | MTG_LOAN | FIRST_INT_PMT_DATE | DATE | EagleML/referenceTransaction/genericSMF/mtgLoanModel/firstInterestPaymentDate |
firstPrincipalPaymentDate |
|
| date | 16673 | in_first_prin_pmt_date | S | mtgloan_model.inc | SECURITYDBO | MTG_LOAN | FIRST_PRIN_PMT_DATE | DATE | EagleML/referenceTransaction/genericSMF/mtgLoanModel/firstPrincipalPaymentDate |
loanBorrowerType |
|
| string | 16675 | in_loan_borrower_type | S | mtgloan_model.inc | SECURITYDBO | MTG_LOAN | LOAN_BORROWER_TYPE | VARCHAR2(50) | EagleML/referenceTransaction/genericSMF/mtgLoanModel/loanBorrowerType |
loanStatus |
|
| string | 16676 | in_loan_status | S | mtgloan_model.inc | SECURITYDBO | MTG_LOAN | LOAN_STATUS | VARCHAR2(50) | EagleML/referenceTransaction/genericSMF/mtgLoanModel/loanStatus |
origAmortLoanMaturity |
|
| decimal | 16677 | in_orig_amort_loan_maturity | N | mtgloan_model.inc | SECURITYDBO | MTG_LOAN | ORIG_AMORT_LOAN_MATURITY | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/mtgLoanModel/origAmortLoanMaturity |
origAppraisedPropValue |
|
| decimal | 16678 | in_orig_appraised_prop_value | N | mtgloan_model.inc | SECURITYDBO | MTG_LOAN | ORIG_APPRAISED_PROP_VALUE | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/mtgLoanModel/origAppraisedPropValue |
origCollateralMktValue |
|
| decimal | 16679 | in_orig_collateral_mkt_value | N | mtgloan_model.inc | SECURITYDBO | MTG_LOAN | ORIG_COLLATERAL_MKT_VALUE | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/mtgLoanModel/origCollateralMktValue |
origLoanMaturity |
|
| decimal | 16680 | in_orig_loan_maturity | N | mtgloan_model.inc | SECURITYDBO | MTG_LOAN | ORIG_LOAN_MATURITY | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/mtgLoanModel/origLoanMaturity |
origPrepayLockoutMOS |
|
| decimal | 16681 | in_orig_prepay_lockout_mos | N | mtgloan_model.inc | SECURITYDBO | MTG_LOAN | ORIG_PREPAY_LOCKOUT_MOS | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/mtgLoanModel/origPrepayLockoutMOS |
ownerOccupied |
|
| string | 16683 | in_owner_occupied | S | mtgloan_model.inc | SECURITYDBO | MTG_LOAN | OWNER_OCCUPIED | VARCHAR2(2) | EagleML/referenceTransaction/genericSMF/mtgLoanModel/ownerOccupied |
pastDueDate |
|
| date | 16674 | in_past_due_date | S | mtgloan_model.inc | SECURITYDBO | MTG_LOAN | PAST_DUE_DATE | DATE | EagleML/referenceTransaction/genericSMF/mtgLoanModel/pastDueDate |
primaryPropertyACLI |
|
| string | 16684 | in_primary_property_acli | S | mtgloan_model.inc | SECURITYDBO | MTG_LOAN | PRIMARY_PROPERTY_ACLI | VARCHAR2(50) | EagleML/referenceTransaction/genericSMF/mtgLoanModel/primaryPropertyACLI |
primaryPropertyId |
|
| string | 16685 | in_primary_property_id | S | mtgloan_model.inc | SECURITYDBO | MTG_LOAN | PRIMARY_PROPERTY_ID | VARCHAR2(50) | EagleML/referenceTransaction/genericSMF/mtgLoanModel/primaryPropertyId |
primaryPropertyMSA |
|
| string | 16686 | in_primary_property_msa | S | mtgloan_model.inc | SECURITYDBO | MTG_LOAN | PRIMARY_PROPERTY_MSA | VARCHAR2(50) | EagleML/referenceTransaction/genericSMF/mtgLoanModel/primaryPropertyMSA |
primaryPropertyName |
|
| string | 16687 | in_primary_property_name | S | mtgloan_model.inc | SECURITYDBO | MTG_LOAN | PRIMARY_PROPERTY_NAME | VARCHAR2(50) | EagleML/referenceTransaction/genericSMF/mtgLoanModel/primaryPropertyName |
primaryPropertyType |
|
| string | 16688 | in_primary_property_type | S | mtgloan_model.inc | SECURITYDBO | MTG_LOAN | PRIMARY_PROPERTY_TYPE | VARCHAR2(50) | EagleML/referenceTransaction/genericSMF/mtgLoanModel/primaryPropertyType |
userMLDate1 |
|
| date | 16690 | in_user_ml_date1 | S | mtgloan_model.inc | SECURITYDBO | MTG_LOAN | USER_ML_DATE1 | DATE | EagleML/referenceTransaction/genericSMF/mtgLoanModel/userMLDate1 |
userMLFloat1 |
|
| decimal | 16691 | in_user_ml_float1 | N | mtgloan_model.inc | SECURITYDBO | MTG_LOAN | USER_ML_FLOAT1 | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/mtgLoanModel/userMLFloat1 |
watchListStatus |
|
| string | 16689 | in_watch_list_status | S | mtgloan_model.inc | SECURITYDBO | MTG_LOAN | WATCH_LIST_STATUS | VARCHAR2(50) | EagleML/referenceTransaction/genericSMF/mtgLoanModel/watchListStatus |