BorrowerMITerminationDate 
Base Entity  MI_DATA_DETAIL 
Attribute Name  BorrowerMITerminationDate 
Logical Rolename   
ColumnName  BorrowerMITerminationDate 
RoleName   
Domain  MISMODate 
Definition  The date that the borrower may request cancellation of MI insurance as identified by HOEPA regulations. 
Note 
 

BorrowerMITerminationDate Logical Attribute Properties 
Logical Attribute Name  BorrowerMITerminationDate 
Datatype  DATE 
Nullable  NO 

BorrowerMITerminationDate Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

BorrowerMITerminationDate Bound Attachments 
Name  Current Value 

BorrowerMITerminationDate User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

BorrowerMITerminationDate Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

BorrowerMITerminationDate Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

BorrowerMITerminationDate Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

BorrowerMITerminationDate Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


LenderPaidMIInterestRateAdjustmentPercent 
Base Entity  MI_DATA_DETAIL 
Attribute Name  LenderPaidMIInterestRateAdjustmentPercent 
Logical Rolename   
ColumnName  LenderPaidMIInterestRateAdjustmentPercent 
RoleName   
Domain  MISMOPercent 
Definition  The percentage of the mortgage interest rate allocated to fund lender purchased mortgage insurance premiums. 
Note 
 

LenderPaidMIInterestRateAdjustmentPercent Logical Attribute Properties 
Logical Attribute Name  LenderPaidMIInterestRateAdjustmentPercent 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

LenderPaidMIInterestRateAdjustmentPercent Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

LenderPaidMIInterestRateAdjustmentPercent Bound Attachments 
Name  Current Value 

LenderPaidMIInterestRateAdjustmentPercent User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

LenderPaidMIInterestRateAdjustmentPercent Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

LenderPaidMIInterestRateAdjustmentPercent Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

LenderPaidMIInterestRateAdjustmentPercent Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

LenderPaidMIInterestRateAdjustmentPercent Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MI_LTVCutoffPercent 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MI_LTVCutoffPercent 
Logical Rolename   
ColumnName  MI_LTVCutoffPercent 
RoleName   
Domain  MISMOPercent 
Definition  LTV cutoff for collection of mortgage insurance. 
Note 
 

MI_LTVCutoffPercent Logical Attribute Properties 
Logical Attribute Name  MI_LTVCutoffPercent 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

MI_LTVCutoffPercent Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MI_LTVCutoffPercent Bound Attachments 
Name  Current Value 

MI_LTVCutoffPercent User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MI_LTVCutoffPercent Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MI_LTVCutoffPercent Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MI_LTVCutoffPercent Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MI_LTVCutoffPercent Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MICancellationDate 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MICancellationDate 
Logical Rolename   
ColumnName  MICancellationDate 
RoleName   
Domain  MISMODate 
Definition  Actual cancellation date of mortgage insurance coverage 
Note 
 

MICancellationDate Logical Attribute Properties 
Logical Attribute Name  MICancellationDate 
Datatype  DATE 
Nullable  NO 

MICancellationDate Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MICancellationDate Bound Attachments 
Name  Current Value 

MICancellationDate User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MICancellationDate Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MICancellationDate Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MICancellationDate Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MICancellationDate Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MI_LTVCutoffType 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MI_LTVCutoffType 
Logical Rolename   
ColumnName  MI_LTVCutoffType 
RoleName   
Domain  MI_LTVCutoffEnum 
Definition  Specifies the basis of the mortgage insurance LTV cutoff  
Note 
 

MI_LTVCutoffType Logical Attribute Properties 
Logical Attribute Name  MI_LTVCutoffType 
Datatype  VARCHAR(0) 
Nullable  YES 

MI_LTVCutoffType Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MI_LTVCutoffType Reference Value (Bound to Domain) 
Name  ValidationRule302 
Description   
Type  By List 
Value  Value Description 
AppraisedValue  AppraisedValue 
SalesPrice  SalesPrice 

MI_LTVCutoffType Bound Attachments 
Name  Current Value 

MI_LTVCutoffType User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MI_LTVCutoffType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MI_LTVCutoffType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MI_LTVCutoffType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MI_LTVCutoffType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MICertificateIdentifier 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MICertificateIdentifier 
Logical Rolename   
ColumnName  MICertificateIdentifier 
RoleName   
Domain  MISMOIdentifier 
Definition  The number assigned by the private mortgage insurance company to track a loan. 
Note 
 

MICertificateIdentifier Logical Attribute Properties 
Logical Attribute Name  MICertificateIdentifier 
Datatype  VARCHAR(0) 
Nullable  NO 

MICertificateIdentifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MICertificateIdentifier Bound Attachments 
Name  Current Value 

MICertificateIdentifier User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MICertificateIdentifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MICertificateIdentifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MICertificateIdentifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MICertificateIdentifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MICertificationStatusType 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MICertificationStatusType 
Logical Rolename   
ColumnName  MICertificationStatusType 
RoleName   
Domain  MICertificationStatusEnum 
Definition  Defines the party that will obtain an MI Certificate.  
Note 
 

MICertificationStatusType Logical Attribute Properties 
Logical Attribute Name  MICertificationStatusType 
Datatype  VARCHAR(0) 
Nullable  YES 

MICertificationStatusType Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MICertificationStatusType Reference Value (Bound to Domain) 
Name  ValidationRule281 
Description   
Type  By List 
Value  Value Description 
LenderToObtain  LenderToObtain 
Other  Other 
SellerOfLoanToObtain  SellerOfLoanToObtain 

MICertificationStatusType Bound Attachments 
Name  Current Value 

MICertificationStatusType User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MICertificationStatusType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MICertificationStatusType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MICertificationStatusType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MICertificationStatusType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MICertificationStatusTypeOtherDescription 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MICertificationStatusTypeOtherDescription 
Logical Rolename   
ColumnName  MICertificationStatusTypeOtherDescription 
RoleName   
Domain  MISMOString 
Definition  A free form text field used to collect additional information when Other is selected for MI Certification Status Type. 
Note 
 

MICertificationStatusTypeOtherDescription Logical Attribute Properties 
Logical Attribute Name  MICertificationStatusTypeOtherDescription 
Datatype  VARCHAR(0) 
Nullable  NO 

MICertificationStatusTypeOtherDescription Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MICertificationStatusTypeOtherDescription Bound Attachments 
Name  Current Value 

MICertificationStatusTypeOtherDescription User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MICertificationStatusTypeOtherDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MICertificationStatusTypeOtherDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MICertificationStatusTypeOtherDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MICertificationStatusTypeOtherDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MICollectedNumberOfMonthsCount 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MICollectedNumberOfMonthsCount 
Logical Rolename   
ColumnName  MICollectedNumberOfMonthsCount 
RoleName   
Domain  MISMOCount 
Definition  The number of months of MI escrow that is collected at settlement. 
Note 
 

MICollectedNumberOfMonthsCount Logical Attribute Properties 
Logical Attribute Name  MICollectedNumberOfMonthsCount 
Datatype  INTEGER 
Nullable  NO 

MICollectedNumberOfMonthsCount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MICollectedNumberOfMonthsCount Bound Attachments 
Name  Current Value 

MICollectedNumberOfMonthsCount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MICollectedNumberOfMonthsCount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MICollectedNumberOfMonthsCount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MICollectedNumberOfMonthsCount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MICollectedNumberOfMonthsCount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MICompanyNameType 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MICompanyNameType 
Logical Rolename   
ColumnName  MICompanyNameType 
RoleName   
Domain  MICompanyNameEnum 
Definition  To convey the private MI company short/common name from whom the private mortgage insurance coverage was obtained.  
Note 
 

MICompanyNameType Logical Attribute Properties 
Logical Attribute Name  MICompanyNameType 
Datatype  VARCHAR(0) 
Nullable  YES 

MICompanyNameType Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MICompanyNameType Reference Value (Bound to Domain) 
Name  ValidationRule282 
Description   
Type  By List 
Value  Value Description 
CMG  CMG 
Essent  Essent 
Genworth  Genworth 
MGIC  MGIC 
Other  Other 
PMI  PMI 
Radian  Radian 
RMIC  RMIC 
Triad  Triad 
UGI  UGI 

MICompanyNameType Bound Attachments 
Name  Current Value 

MICompanyNameType User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MICompanyNameType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MICompanyNameType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MICompanyNameType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MICompanyNameType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MICompanyNameTypeOtherDescription 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MICompanyNameTypeOtherDescription 
Logical Rolename   
ColumnName  MICompanyNameTypeOtherDescription 
RoleName   
Domain  MISMOString 
Definition  A free-form text field used to capture the mortgage insurance company name if Other is selected as the mortgage insurance company name. 
Note 
 

MICompanyNameTypeOtherDescription Logical Attribute Properties 
Logical Attribute Name  MICompanyNameTypeOtherDescription 
Datatype  VARCHAR(0) 
Nullable  NO 

MICompanyNameTypeOtherDescription Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MICompanyNameTypeOtherDescription Bound Attachments 
Name  Current Value 

MICompanyNameTypeOtherDescription User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MICompanyNameTypeOtherDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MICompanyNameTypeOtherDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MICompanyNameTypeOtherDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MICompanyNameTypeOtherDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MIConventionalUpfrontPremiumPercent 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MIConventionalUpfrontPremiumPercent 
Logical Rolename   
ColumnName  MIConventionalUpfrontPremiumPercent 
RoleName   
Domain  MISMOPercent 
Definition  Percentage of base loan amount paid to the mortgage insurer for initial up-front premium 
Note 
 

MIConventionalUpfrontPremiumPercent Logical Attribute Properties 
Logical Attribute Name  MIConventionalUpfrontPremiumPercent 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

MIConventionalUpfrontPremiumPercent Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MIConventionalUpfrontPremiumPercent Bound Attachments 
Name  Current Value 

MIConventionalUpfrontPremiumPercent User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MIConventionalUpfrontPremiumPercent Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIConventionalUpfrontPremiumPercent Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIConventionalUpfrontPremiumPercent Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MIConventionalUpfrontPremiumPercent Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MICoverageEffectiveDate 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MICoverageEffectiveDate 
Logical Rolename   
ColumnName  MICoverageEffectiveDate 
RoleName   
Domain  MISMODate 
Definition  The date the current MI policy went into effect. 
Note 
 

MICoverageEffectiveDate Logical Attribute Properties 
Logical Attribute Name  MICoverageEffectiveDate 
Datatype  DATE 
Nullable  NO 

MICoverageEffectiveDate Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MICoverageEffectiveDate Bound Attachments 
Name  Current Value 

MICoverageEffectiveDate User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MICoverageEffectiveDate Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MICoverageEffectiveDate Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MICoverageEffectiveDate Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MICoverageEffectiveDate Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MICoveragePercent 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MICoveragePercent 
Logical Rolename   
ColumnName  MICoveragePercent 
RoleName   
Domain  MISMOPercent 
Definition  The percentage of mortgage insurance coverage obtained. 
Note 
 

MICoveragePercent Logical Attribute Properties 
Logical Attribute Name  MICoveragePercent 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

MICoveragePercent Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MICoveragePercent Bound Attachments 
Name  Current Value 

MICoveragePercent User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MICoveragePercent Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MICoveragePercent Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MICoveragePercent Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MICoveragePercent Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MICoveragePlanType 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MICoveragePlanType 
Logical Rolename   
ColumnName  MICoveragePlanType 
RoleName   
Domain  MICoveragePlanEnum 
Definition  Specifies the coverage category of mortgage insurance applicable to the loan.  
Note 
 

MICoveragePlanType Logical Attribute Properties 
Logical Attribute Name  MICoveragePlanType 
Datatype  VARCHAR(0) 
Nullable  YES 

MICoveragePlanType Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MICoveragePlanType Reference Value (Bound to Domain) 
Name  ValidationRule283 
Description   
Type  By List 
Value  Value Description 
LossLimitCap  LossLimitCap 
Other  Other 
Pool  Pool 
RiskSharing  RiskSharing 
SecondLayer  SecondLayer 
StandardPrimary  StandardPrimary 

MICoveragePlanType Bound Attachments 
Name  Current Value 

MICoveragePlanType User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MICoveragePlanType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MICoveragePlanType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MICoveragePlanType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MICoveragePlanType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MICoveragePlanTypeOtherDescription 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MICoveragePlanTypeOtherDescription 
Logical Rolename   
ColumnName  MICoveragePlanTypeOtherDescription 
RoleName   
Domain  MISMOString 
Definition  A free-form text field used to capture the description of the type of MI Coverage Plan if Other is selected as the MICoveragePlanType. 
Note 
 

MICoveragePlanTypeOtherDescription Logical Attribute Properties 
Logical Attribute Name  MICoveragePlanTypeOtherDescription 
Datatype  VARCHAR(0) 
Nullable  NO 

MICoveragePlanTypeOtherDescription Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MICoveragePlanTypeOtherDescription Bound Attachments 
Name  Current Value 

MICoveragePlanTypeOtherDescription User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MICoveragePlanTypeOtherDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MICoveragePlanTypeOtherDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MICoveragePlanTypeOtherDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MICoveragePlanTypeOtherDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MICurrentAnnualPremiumAmount 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MICurrentAnnualPremiumAmount 
Logical Rolename   
ColumnName  MICurrentAnnualPremiumAmount 
RoleName   
Domain  MISMOAmount 
Definition  The current dollar amount paid per year for mortgage insurance. 
Note 
 

MICurrentAnnualPremiumAmount Logical Attribute Properties 
Logical Attribute Name  MICurrentAnnualPremiumAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

MICurrentAnnualPremiumAmount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MICurrentAnnualPremiumAmount Bound Attachments 
Name  Current Value 

MICurrentAnnualPremiumAmount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MICurrentAnnualPremiumAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MICurrentAnnualPremiumAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MICurrentAnnualPremiumAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MICurrentAnnualPremiumAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MICushionNumberOfMonthsCount 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MICushionNumberOfMonthsCount 
Logical Rolename   
ColumnName  MICushionNumberOfMonthsCount 
RoleName   
Domain  MISMOCount 
Definition  The number of months of MI escrow that is to be considered in the cushion for aggregate accounting. 
Note 
 

MICushionNumberOfMonthsCount Logical Attribute Properties 
Logical Attribute Name  MICushionNumberOfMonthsCount 
Datatype  INTEGER 
Nullable  NO 

MICushionNumberOfMonthsCount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MICushionNumberOfMonthsCount Bound Attachments 
Name  Current Value 

MICushionNumberOfMonthsCount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MICushionNumberOfMonthsCount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MICushionNumberOfMonthsCount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MICushionNumberOfMonthsCount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MICushionNumberOfMonthsCount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MIDurationType 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MIDurationType 
Logical Rolename   
ColumnName  MIDurationType 
RoleName   
Domain  MIDurationEnum 
Definition  Specifies the period of time for which mortgage insurance coverage has been obtained/paid.  
Note 
 

MIDurationType Logical Attribute Properties 
Logical Attribute Name  MIDurationType 
Datatype  VARCHAR(0) 
Nullable  YES 

MIDurationType Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MIDurationType Reference Value (Bound to Domain) 
Name  ValidationRule285 
Description   
Type  By List 
Value  Value Description 
Annual  Annual 
NotApplicable  NotApplicable 
Other  Other 
PeriodicMonthly  PeriodicMonthly 
SingleLifeOfLoan  SingleLifeOfLoan 
SingleSpecific  SingleSpecific 
SplitPremium  SplitPremium 

MIDurationType Bound Attachments 
Name  Current Value 

MIDurationType User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MIDurationType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIDurationType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIDurationType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MIDurationType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MIDurationTypeOtherDescription 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MIDurationTypeOtherDescription 
Logical Rolename   
ColumnName  MIDurationTypeOtherDescription 
RoleName   
Domain  MISMOString 
Definition  A free-form text field used to capture the description of the type of MI Duration if Other is selected as the MIDurationType. 
Note 
 

MIDurationTypeOtherDescription Logical Attribute Properties 
Logical Attribute Name  MIDurationTypeOtherDescription 
Datatype  VARCHAR(0) 
Nullable  NO 

MIDurationTypeOtherDescription Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MIDurationTypeOtherDescription Bound Attachments 
Name  Current Value 

MIDurationTypeOtherDescription User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MIDurationTypeOtherDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIDurationTypeOtherDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIDurationTypeOtherDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MIDurationTypeOtherDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MIEscrowedIndicator 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MIEscrowedIndicator 
Logical Rolename   
ColumnName  MIEscrowedIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates whether mortgage insurance premium is being collected by the lender/servicer and deposited into an escrow account from which a future payment will be made. 
Note 
 

MIEscrowedIndicator Logical Attribute Properties 
Logical Attribute Name  MIEscrowedIndicator 
Datatype  BIT 
Nullable  NO 

MIEscrowedIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MIEscrowedIndicator Bound Attachments 
Name  Current Value 

MIEscrowedIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MIEscrowedIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIEscrowedIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIEscrowedIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MIEscrowedIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MIEscrowIncludedInAggregateIndicator 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MIEscrowIncludedInAggregateIndicator 
Logical Rolename   
ColumnName  MIEscrowIncludedInAggregateIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates whether Private Mortgage Insurance Escrow is to be included in the cushion for Aggregate Accounting. 
Note 
 

MIEscrowIncludedInAggregateIndicator Logical Attribute Properties 
Logical Attribute Name  MIEscrowIncludedInAggregateIndicator 
Datatype  BIT 
Nullable  NO 

MIEscrowIncludedInAggregateIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MIEscrowIncludedInAggregateIndicator Bound Attachments 
Name  Current Value 

MIEscrowIncludedInAggregateIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MIEscrowIncludedInAggregateIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIEscrowIncludedInAggregateIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIEscrowIncludedInAggregateIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MIEscrowIncludedInAggregateIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MIInitialPremiumAmount 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MIInitialPremiumAmount 
Logical Rolename   
ColumnName  MIInitialPremiumAmount 
RoleName   
Domain  MISMOAmount 
Definition  Amount of the first premium paid to MI. For monthly plans, one months premium; for all other plans, Initial Premium Rate times Base Loan Amount. 
Note 
 

MIInitialPremiumAmount Logical Attribute Properties 
Logical Attribute Name  MIInitialPremiumAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

MIInitialPremiumAmount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MIInitialPremiumAmount Bound Attachments 
Name  Current Value 

MIInitialPremiumAmount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MIInitialPremiumAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIInitialPremiumAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIInitialPremiumAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MIInitialPremiumAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MIInitialPremiumAtClosingType 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MIInitialPremiumAtClosingType 
Logical Rolename   
ColumnName  MIInitialPremiumAtClosingType 
RoleName   
Domain  MIInitialPremiumAtClosingEnum 
Definition  Specifies whether the initial Mortgage Insurance premium is prepaid upon closing or deferred until first principle payment.  
Note 
 

MIInitialPremiumAtClosingType Logical Attribute Properties 
Logical Attribute Name  MIInitialPremiumAtClosingType 
Datatype  VARCHAR(0) 
Nullable  YES 

MIInitialPremiumAtClosingType Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MIInitialPremiumAtClosingType Reference Value (Bound to Domain) 
Name  ValidationRule286 
Description   
Type  By List 
Value  Value Description 
Deferred  Deferred 
Other  Other 
Prepaid  Prepaid 

MIInitialPremiumAtClosingType Bound Attachments 
Name  Current Value 

MIInitialPremiumAtClosingType User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MIInitialPremiumAtClosingType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIInitialPremiumAtClosingType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIInitialPremiumAtClosingType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MIInitialPremiumAtClosingType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MIInitialPremiumAtClosingTypeOtherDescription 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MIInitialPremiumAtClosingTypeOtherDescription 
Logical Rolename   
ColumnName  MIInitialPremiumAtClosingTypeOtherDescription 
RoleName   
Domain  MISMOString 
Definition  A free-form text field used to capture the description of the type of MI Initial Premium At Closing if Other is selected as the MIInitialPremiumAtClosingType. 
Note 
 

MIInitialPremiumAtClosingTypeOtherDescription Logical Attribute Properties 
Logical Attribute Name  MIInitialPremiumAtClosingTypeOtherDescription 
Datatype  VARCHAR(0) 
Nullable  NO 

MIInitialPremiumAtClosingTypeOtherDescription Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MIInitialPremiumAtClosingTypeOtherDescription Bound Attachments 
Name  Current Value 

MIInitialPremiumAtClosingTypeOtherDescription User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MIInitialPremiumAtClosingTypeOtherDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIInitialPremiumAtClosingTypeOtherDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIInitialPremiumAtClosingTypeOtherDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MIInitialPremiumAtClosingTypeOtherDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MIInitialPremiumRateDurationMonthsCount 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MIInitialPremiumRateDurationMonthsCount 
Logical Rolename   
ColumnName  MIInitialPremiumRateDurationMonthsCount 
RoleName   
Domain  MISMOCount 
Definition  Indicates the number of months for which the MI Initial Premium Rate applies. 
Note 
 

MIInitialPremiumRateDurationMonthsCount Logical Attribute Properties 
Logical Attribute Name  MIInitialPremiumRateDurationMonthsCount 
Datatype  INTEGER 
Nullable  NO 

MIInitialPremiumRateDurationMonthsCount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MIInitialPremiumRateDurationMonthsCount Bound Attachments 
Name  Current Value 

MIInitialPremiumRateDurationMonthsCount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MIInitialPremiumRateDurationMonthsCount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIInitialPremiumRateDurationMonthsCount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIInitialPremiumRateDurationMonthsCount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MIInitialPremiumRateDurationMonthsCount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MIInitialPremiumRatePercent 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MIInitialPremiumRatePercent 
Logical Rolename   
ColumnName  MIInitialPremiumRatePercent 
RoleName   
Domain  MISMOPercent 
Definition  MI initial premium rate percent used to compute the initial MI premium amount. 
Note 
 

MIInitialPremiumRatePercent Logical Attribute Properties 
Logical Attribute Name  MIInitialPremiumRatePercent 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

MIInitialPremiumRatePercent Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MIInitialPremiumRatePercent Bound Attachments 
Name  Current Value 

MIInitialPremiumRatePercent User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MIInitialPremiumRatePercent Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIInitialPremiumRatePercent Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIInitialPremiumRatePercent Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MIInitialPremiumRatePercent Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MIPremiumCalculationRatePercent 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MIPremiumCalculationRatePercent 
Logical Rolename   
ColumnName  MIPremiumCalculationRatePercent 
RoleName   
Domain  MISMOPercent 
Definition  The percentage of the principal balance used to calculate the annual PMI premium. 
Note 
 

MIPremiumCalculationRatePercent Logical Attribute Properties 
Logical Attribute Name  MIPremiumCalculationRatePercent 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

MIPremiumCalculationRatePercent Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MIPremiumCalculationRatePercent Bound Attachments 
Name  Current Value 

MIPremiumCalculationRatePercent User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MIPremiumCalculationRatePercent Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumCalculationRatePercent Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumCalculationRatePercent Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumCalculationRatePercent Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MIPremiumCalculationType 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MIPremiumCalculationType 
Logical Rolename   
ColumnName  MIPremiumCalculationType 
RoleName   
Domain  MIPremiumCalculationEnum 
Definition  Method by which new PMI premium is calculated.  
Note 
 

MIPremiumCalculationType Logical Attribute Properties 
Logical Attribute Name  MIPremiumCalculationType 
Datatype  VARCHAR(0) 
Nullable  YES 

MIPremiumCalculationType Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MIPremiumCalculationType Reference Value (Bound to Domain) 
Name  ValidationRule288 
Description   
Type  By List 
Value  Value Description 
PercentOfCurrentBalance  PercentOfCurrentBalance 
PercentOfOriginalBalance  PercentOfOriginalBalance 

MIPremiumCalculationType Bound Attachments 
Name  Current Value 

MIPremiumCalculationType User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MIPremiumCalculationType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumCalculationType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumCalculationType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumCalculationType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MIPremiumCalendarYearAmount 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MIPremiumCalendarYearAmount 
Logical Rolename   
ColumnName  MIPremiumCalendarYearAmount 
RoleName   
Domain  MISMOAmount 
Definition  The amount of the Mortgage Insurance Premiums that the Borrower has paid for the calendar year. 
Note 
 

MIPremiumCalendarYearAmount Logical Attribute Properties 
Logical Attribute Name  MIPremiumCalendarYearAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

MIPremiumCalendarYearAmount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MIPremiumCalendarYearAmount Bound Attachments 
Name  Current Value 

MIPremiumCalendarYearAmount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MIPremiumCalendarYearAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumCalendarYearAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumCalendarYearAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumCalendarYearAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MIPremiumFinancedAmount 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MIPremiumFinancedAmount 
Logical Rolename   
ColumnName  MIPremiumFinancedAmount 
RoleName   
Domain  MISMOAmount 
Definition  The amount of the up-front premium that is financed 
Note 
 

MIPremiumFinancedAmount Logical Attribute Properties 
Logical Attribute Name  MIPremiumFinancedAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

MIPremiumFinancedAmount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MIPremiumFinancedAmount Bound Attachments 
Name  Current Value 

MIPremiumFinancedAmount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MIPremiumFinancedAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumFinancedAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumFinancedAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumFinancedAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MIPremiumFinancedIndicator 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MIPremiumFinancedIndicator 
Logical Rolename   
ColumnName  MIPremiumFinancedIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates whether mortgage insurance premium has been added to loan amount. 
Note 
 

MIPremiumFinancedIndicator Logical Attribute Properties 
Logical Attribute Name  MIPremiumFinancedIndicator 
Datatype  BIT 
Nullable  NO 

MIPremiumFinancedIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MIPremiumFinancedIndicator Bound Attachments 
Name  Current Value 

MIPremiumFinancedIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MIPremiumFinancedIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumFinancedIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumFinancedIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumFinancedIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MIPremiumFromClosingAmount 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MIPremiumFromClosingAmount 
Logical Rolename   
ColumnName  MIPremiumFromClosingAmount 
RoleName   
Domain  MISMOAmount 
Definition  Amount of MI premium due from closing. Zero for deferred monthly; otherwise is a months, years or life premium for regular monthly, annual, or life of loan premium plans. 
Note 
 

MIPremiumFromClosingAmount Logical Attribute Properties 
Logical Attribute Name  MIPremiumFromClosingAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

MIPremiumFromClosingAmount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MIPremiumFromClosingAmount Bound Attachments 
Name  Current Value 

MIPremiumFromClosingAmount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MIPremiumFromClosingAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumFromClosingAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumFromClosingAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumFromClosingAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MIPremiumPaymentType 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MIPremiumPaymentType 
Logical Rolename   
ColumnName  MIPremiumPaymentType 
RoleName   
Domain  MIPremiumPaymentEnum 
Definition  Defines the source of premium payments and how they are to be paid.  
Note 
 

MIPremiumPaymentType Logical Attribute Properties 
Logical Attribute Name  MIPremiumPaymentType 
Datatype  VARCHAR(0) 
Nullable  YES 

MIPremiumPaymentType Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MIPremiumPaymentType Reference Value (Bound to Domain) 
Name  ValidationRule289 
Description   
Type  By List 
Value  Value Description 
Escrowed  Funds are collected monthly and places in an escrow account to pay the anual priemium when due. 
Financed  Rolled into mortgage. 
Other  Other 
RatePremium  RatePremium 
Upfront  Upfront 

MIPremiumPaymentType Bound Attachments 
Name  Current Value 

MIPremiumPaymentType User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MIPremiumPaymentType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumPaymentType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumPaymentType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumPaymentType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MIPremiumPaymentTypeOtherDescription 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MIPremiumPaymentTypeOtherDescription 
Logical Rolename   
ColumnName  MIPremiumPaymentTypeOtherDescription 
RoleName   
Domain  MISMOString 
Definition  A free-form text field used to capture the description of the type of MI Premium Payment if Other is selected as the MIPremiumPaymentType. 
Note 
 

MIPremiumPaymentTypeOtherDescription Logical Attribute Properties 
Logical Attribute Name  MIPremiumPaymentTypeOtherDescription 
Datatype  VARCHAR(0) 
Nullable  NO 

MIPremiumPaymentTypeOtherDescription Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MIPremiumPaymentTypeOtherDescription Bound Attachments 
Name  Current Value 

MIPremiumPaymentTypeOtherDescription User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MIPremiumPaymentTypeOtherDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumPaymentTypeOtherDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumPaymentTypeOtherDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumPaymentTypeOtherDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MIPremiumRefundableType 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MIPremiumRefundableType 
Logical Rolename   
ColumnName  MIPremiumRefundableType 
RoleName   
Domain  MIPremiumRefundableEnum 
Definition  Specifies how the unearned portion of any private mortgage insurance premiums will be treated if the private mortgage insurance coverage is canceled.  
Note 
 

MIPremiumRefundableType Logical Attribute Properties 
Logical Attribute Name  MIPremiumRefundableType 
Datatype  VARCHAR(0) 
Nullable  YES 

MIPremiumRefundableType Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MIPremiumRefundableType Reference Value (Bound to Domain) 
Name  ValidationRule291 
Description   
Type  By List 
Value  Value Description 
NotRefundable  NotRefundable 
Other  Other 
Refundable  Refundable 
RefundableWithLimits  RefundableWithLimits 

MIPremiumRefundableType Bound Attachments 
Name  Current Value 

MIPremiumRefundableType User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MIPremiumRefundableType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumRefundableType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumRefundableType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumRefundableType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MIPremiumRefundableTypeOtherDescription 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MIPremiumRefundableTypeOtherDescription 
Logical Rolename   
ColumnName  MIPremiumRefundableTypeOtherDescription 
RoleName   
Domain  MISMOString 
Definition  A free-form text field used to capture the description of the type of MI Premium Refundable if Other is selected as the MIPremiumRefundableType. 
Note 
 

MIPremiumRefundableTypeOtherDescription Logical Attribute Properties 
Logical Attribute Name  MIPremiumRefundableTypeOtherDescription 
Datatype  VARCHAR(0) 
Nullable  NO 

MIPremiumRefundableTypeOtherDescription Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MIPremiumRefundableTypeOtherDescription Bound Attachments 
Name  Current Value 

MIPremiumRefundableTypeOtherDescription User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MIPremiumRefundableTypeOtherDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumRefundableTypeOtherDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumRefundableTypeOtherDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumRefundableTypeOtherDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MIPremiumSourceType 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MIPremiumSourceType 
Logical Rolename   
ColumnName  MIPremiumSourceType 
RoleName   
Domain  MIPremiumSourceEnum 
Definition  Defines the source of the MI premium payment.  
Note 
 

MIPremiumSourceType Logical Attribute Properties 
Logical Attribute Name  MIPremiumSourceType 
Datatype  VARCHAR(0) 
Nullable  YES 

MIPremiumSourceType Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MIPremiumSourceType Reference Value (Bound to Domain) 
Name  ValidationRule292 
Description   
Type  By List 
Value  Value Description 
Borrower  Borrower 
BorrowerAndLender  BorrowerAndLender 
Lender  Lender 
Other  Other 

MIPremiumSourceType Bound Attachments 
Name  Current Value 

MIPremiumSourceType User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MIPremiumSourceType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumSourceType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumSourceType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumSourceType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MIPremiumSourceTypeOtherDescription 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MIPremiumSourceTypeOtherDescription 
Logical Rolename   
ColumnName  MIPremiumSourceTypeOtherDescription 
RoleName   
Domain  MISMOString 
Definition  A free-form text field to collect MI premium source when Other is selected for MI Premium Source Type. 
Note 
 

MIPremiumSourceTypeOtherDescription Logical Attribute Properties 
Logical Attribute Name  MIPremiumSourceTypeOtherDescription 
Datatype  VARCHAR(0) 
Nullable  NO 

MIPremiumSourceTypeOtherDescription Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MIPremiumSourceTypeOtherDescription Bound Attachments 
Name  Current Value 

MIPremiumSourceTypeOtherDescription User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MIPremiumSourceTypeOtherDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumSourceTypeOtherDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumSourceTypeOtherDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumSourceTypeOtherDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MIPremiumTermMonthsCount 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MIPremiumTermMonthsCount 
Logical Rolename   
ColumnName  MIPremiumTermMonthsCount 
RoleName   
Domain  MISMOCount 
Definition  The number of months of mortgage insurance coverage paid for. 
Note 
 

MIPremiumTermMonthsCount Logical Attribute Properties 
Logical Attribute Name  MIPremiumTermMonthsCount 
Datatype  INTEGER 
Nullable  NO 

MIPremiumTermMonthsCount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MIPremiumTermMonthsCount Bound Attachments 
Name  Current Value 

MIPremiumTermMonthsCount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MIPremiumTermMonthsCount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumTermMonthsCount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumTermMonthsCount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MIPremiumTermMonthsCount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MIRenewalCalculationType 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MIRenewalCalculationType 
Logical Rolename   
ColumnName  MIRenewalCalculationType 
RoleName   
Domain  MIRenewalCalculationEnum 
Definition  Specifies the way in which the renewal premiums will be calculated.  
Note 
 

MIRenewalCalculationType Logical Attribute Properties 
Logical Attribute Name  MIRenewalCalculationType 
Datatype  VARCHAR(0) 
Nullable  YES 

MIRenewalCalculationType Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MIRenewalCalculationType Reference Value (Bound to Domain) 
Name  ValidationRule294 
Description   
Type  By List 
Value  Value Description 
Constant  Constant 
Declining  Declining 
NoRenewals  NoRenewals 

MIRenewalCalculationType Bound Attachments 
Name  Current Value 

MIRenewalCalculationType User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MIRenewalCalculationType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIRenewalCalculationType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIRenewalCalculationType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MIRenewalCalculationType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MIRenewalPremiumRatePercent 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MIRenewalPremiumRatePercent 
Logical Rolename   
ColumnName  MIRenewalPremiumRatePercent 
RoleName   
Domain  MISMOPercent 
Definition  The renewal premium rate that will be applied to calculate the dollar amount of the MI renewal premium. 
Note 
 

MIRenewalPremiumRatePercent Logical Attribute Properties 
Logical Attribute Name  MIRenewalPremiumRatePercent 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

MIRenewalPremiumRatePercent Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MIRenewalPremiumRatePercent Bound Attachments 
Name  Current Value 

MIRenewalPremiumRatePercent User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MIRenewalPremiumRatePercent Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIRenewalPremiumRatePercent Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIRenewalPremiumRatePercent Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MIRenewalPremiumRatePercent Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MIScheduledTerminationDate 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MIScheduledTerminationDate 
Logical Rolename   
ColumnName  MIScheduledTerminationDate 
RoleName   
Domain  MISMODate 
Definition  The projected mandatory date the mortgage insurance must be terminated when a set loan to value percent is reached as identified by HOEPA regulations. Also know as Mandatory MI Termination Date on PMI disclosure forms. 
Note 
 

MIScheduledTerminationDate Logical Attribute Properties 
Logical Attribute Name  MIScheduledTerminationDate 
Datatype  DATE 
Nullable  NO 

MIScheduledTerminationDate Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MIScheduledTerminationDate Bound Attachments 
Name  Current Value 

MIScheduledTerminationDate User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MIScheduledTerminationDate Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIScheduledTerminationDate Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIScheduledTerminationDate Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MIScheduledTerminationDate Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MISourceType 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MISourceType 
Logical Rolename   
ColumnName  MISourceType 
RoleName   
Domain  MISourceEnum 
Definition  The source (FHA or Private) of mortgage protection insurance.  
Note 
 

MISourceType Logical Attribute Properties 
Logical Attribute Name  MISourceType 
Datatype  VARCHAR(0) 
Nullable  YES 

MISourceType Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MISourceType Reference Value (Bound to Domain) 
Name  ValidationRule299 
Description   
Type  By List 
Value  Value Description 
FHA  FHA 
PMI  PMI 

MISourceType Bound Attachments 
Name  Current Value 

MISourceType User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MISourceType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MISourceType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MISourceType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MISourceType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MISplitPremiumUpfrontPercent 
Base Entity  MI_DATA_DETAIL 
Attribute Name  MISplitPremiumUpfrontPercent 
Logical Rolename   
ColumnName  MISplitPremiumUpfrontPercent 
RoleName   
Domain  MISMOPercent 
Definition  Reflects the actual up-front MI Premium percent associated with the plan. 
Note 
 

MISplitPremiumUpfrontPercent Logical Attribute Properties 
Logical Attribute Name  MISplitPremiumUpfrontPercent 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

MISplitPremiumUpfrontPercent Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MISplitPremiumUpfrontPercent Bound Attachments 
Name  Current Value 

MISplitPremiumUpfrontPercent User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MISplitPremiumUpfrontPercent Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MISplitPremiumUpfrontPercent Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MISplitPremiumUpfrontPercent Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MISplitPremiumUpfrontPercent Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


PrimaryMIAbsenceReasonType 
Base Entity  MI_DATA_DETAIL 
Attribute Name  PrimaryMIAbsenceReasonType 
Logical Rolename   
ColumnName  PrimaryMIAbsenceReasonType 
RoleName   
Domain  PrimaryMIAbsenceReasonEnum 
Definition  Specifies the reason that primary mortgage insurance is not required or provided.  
Note 
 

PrimaryMIAbsenceReasonType Logical Attribute Properties 
Logical Attribute Name  PrimaryMIAbsenceReasonType 
Datatype  VARCHAR(0) 
Nullable  YES 

PrimaryMIAbsenceReasonType Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

PrimaryMIAbsenceReasonType Reference Value (Bound to Domain) 
Name  ValidationRule376 
Description   
Type  By List 
Value  Value Description 
CharterParticipation  CharterParticipation 
DelinquencyDisposition  DelinquencyDisposition 
InvestorPurchasedMortgageInsurance  InvestorPurchasedMortgageInsurance 
MICanceledBasedOnCurrentLTV  MICanceledBasedOnCurrentLTV 
NoMIBasedOnOriginalLTV  NoMIBasedOnOriginalLTV 
Other  Other 
PledgedAsset  PledgedAsset 
PoolCoverage  PoolCoverage 
Repurchase  Repurchase 
SelfInsured  SelfInsured 

PrimaryMIAbsenceReasonType Bound Attachments 
Name  Current Value 

PrimaryMIAbsenceReasonType User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

PrimaryMIAbsenceReasonType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

PrimaryMIAbsenceReasonType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

PrimaryMIAbsenceReasonType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

PrimaryMIAbsenceReasonType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


PrimaryMIAbsenceReasonTypeOtherDescription 
Base Entity  MI_DATA_DETAIL 
Attribute Name  PrimaryMIAbsenceReasonTypeOtherDescription 
Logical Rolename   
ColumnName  PrimaryMIAbsenceReasonTypeOtherDescription 
RoleName   
Domain  MISMOString 
Definition  A free form text field used to collect additional information when Other is selected for Primary MI Absence Reason Type. 
Note 
 

PrimaryMIAbsenceReasonTypeOtherDescription Logical Attribute Properties 
Logical Attribute Name  PrimaryMIAbsenceReasonTypeOtherDescription 
Datatype  VARCHAR(0) 
Nullable  NO 

PrimaryMIAbsenceReasonTypeOtherDescription Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

PrimaryMIAbsenceReasonTypeOtherDescription Bound Attachments 
Name  Current Value 

PrimaryMIAbsenceReasonTypeOtherDescription User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

PrimaryMIAbsenceReasonTypeOtherDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

PrimaryMIAbsenceReasonTypeOtherDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

PrimaryMIAbsenceReasonTypeOtherDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

PrimaryMIAbsenceReasonTypeOtherDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ScheduledAmortizationMidpointDate 
Base Entity  MI_DATA_DETAIL 
Attribute Name  ScheduledAmortizationMidpointDate 
Logical Rolename   
ColumnName  ScheduledAmortizationMidpointDate 
RoleName   
Domain  MISMODate 
Definition  Based on scheduled amortization, date at which the loan due date reaches the midpoint of the loans amortization period (e.g., for a 360 month loan, the date of month number 181). 
Note 
 

ScheduledAmortizationMidpointDate Logical Attribute Properties 
Logical Attribute Name  ScheduledAmortizationMidpointDate 
Datatype  DATE 
Nullable  NO 

ScheduledAmortizationMidpointDate Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

ScheduledAmortizationMidpointDate Bound Attachments 
Name  Current Value 

ScheduledAmortizationMidpointDate User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

ScheduledAmortizationMidpointDate Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ScheduledAmortizationMidpointDate Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ScheduledAmortizationMidpointDate Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ScheduledAmortizationMidpointDate Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


SellerMIPaidToDate 
Base Entity  MI_DATA_DETAIL 
Attribute Name  SellerMIPaidToDate 
Logical Rolename   
ColumnName  SellerMIPaidToDate 
RoleName   
Domain  MISMODate 
Definition  The date through which MI has been paid by the seller. 
Note 
 

SellerMIPaidToDate Logical Attribute Properties 
Logical Attribute Name  SellerMIPaidToDate 
Datatype  DATE 
Nullable  NO 

SellerMIPaidToDate Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

SellerMIPaidToDate Bound Attachments 
Name  Current Value 

SellerMIPaidToDate User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

SellerMIPaidToDate Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SellerMIPaidToDate Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SellerMIPaidToDate Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SellerMIPaidToDate Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description