mortgage - mismo/hmda 2016
TRANSCRIPT
AnalytiX Data Services
Use case on MISMO Mapping Standards using AnalytiX Mapping Manager
A Short Presentation highlighting the Use Case to map MISMO attributes to UI attributes to Canonical Data Model equivalents using the AnalytiX Mapping Manager Platform.
Private and Confidential
Ashley Ancker
Manager, Strategic Accounts
469-734-7755
Sam Benedict
Vice President, Strategic Accounts
972-974-0625
Contact us for a one hour demo of this
innovative platform and a free
evaluation!
MISMO Metadata (Source)
MISMO Metadata can be derived from MISMO XSD models. For demo purpose, this is uploaded into AMM using an Excel file format.
Private and Confidential
CDM Metadata (Target)
CDM Metadata is derived from Flat files. This is uploaded into AMM using an Excel file format.
Private and Confidential
UI Metadata (Source & Target)
UI Metadata is derived from Flat files. This is uploaded into AMM using an Excel file format.
Private and Confidential
Mappings -
“MISMO to MISMO”“CDM to CDM”“MISMO to CDM”“MISMO to UI”“UI to CDM”“UI to UI”
539 Mappings have been created in AMM to demonstrate MISMO to UI to CDM mapping standards using the “MISMO 3_4 to CDM 6_3 new” document supplied.
Private and Confidential
CDM to CDM
MISMO to CDM
MISMO to MISMO
MISMO to UI to CDM
Sample MISMO to CDM MAPPINGS
Mappings have been categorized and named by target CDM Entity (table)
ADDRESS
Private and Confidential
Closing Adjustment Item
Loan Settlement
Insurance Policy
MISMO_3.4B316_To_CDM_6.2
Sample MISMO to MISMO MAPPINGS
Mappings have been categorized and named by target MISMO Container (table)
Private and Confidential
Amortization Rule MISMO_3.3.1_To_MISMO_3.4B316
ESCROW Item Payment
Liability Detail
Sample CDM to CDM MAPPINGS
Mappings have been categorized and named by target CDM entity (table)
Private and Confidential
CDM_6.1_To_CDM_6.2Borrower Liability
High Cost Mortgage
Loan
Sample MISMO to UI to CDM MAPPINGS
Mappings have been categorized and named by target UCD container & CDM entity (table)
Private and Confidential
MISMO_3.4B316_To_UCD
HUD1_To_UCD
UCD_To_CDM_6.2
Borrower Asset
Address
Automated Underwriting
Instant Data Lineage & Impact Analysis capabilities
Private and Confidential
Forward Lineage for MISMO_ 3.3.0 attribute EVENTTYPEOTHERDESCRIPTION1. MISMO_3.3.1 “EVENTTYPEOTHER DESCRIPTION ” AUDIT_TRAIL_ENTRY_DETAILS (column/table)2. MISMO_3.4B316 “EVENTTYPEOTHER DESCRIPTION ” AUDIT_TRAIL_ENTRY_DETAILS (column/table)
a. CDM_6.2 “Document Status type” Document Status (column/table)b. UCD “EVENTTYPEOTHER DESCRIPTION ” AUDIT_TRAIL_ENTRY_DETAILS (column/table)
Forward Lineage
Instant Data Lineage & Impact Analysis capabilities
Private and Confidential
Reverse Lineage
Reverse Lineage for CDM 6.2 attribute INSURANCE REQUIRED INDICATOR1. CDM_6.1 “Insurance Required Indicator ” Insurance Policy (column/table)2. MISMO_3.4B316 “MIRequiredIndicator” Loan_Detail (column/table)
a. MISMO_3.3.1 ““MIRequiredIndicator” Loan_Detail (column/table)b. MISMO_3.3.0 “MIRequiredIndicator” Loan_Detail (column/table)
3. UCD “MIRequiredIndicator” Loan_Detail (column/table)
Instant Data Lineage & Impact Analysis capabilities
Private and Confidential
Impact Analysis
UI -> UCD -> Loan_Detail -> BalloonIndicator