CurrentFirstMortgageHolderType 
Base Entity  REFINANCE 
Attribute Name  CurrentFirstMortgageHolderType 
Logical Rolename   
ColumnName  CurrentFirstMortgageHolderType 
RoleName   
Domain  CurrentFirstMortgageHolderEnum 
Definition  Specifies the investor holding the first mortgage that is being refinanced.  
Note 
 

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

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

CurrentFirstMortgageHolderType Reference Value (Bound to Domain) 
Name  ValidationRule123 
Description   
Type  By List 
Value  Value Description 
FNM  Fannie Mae 
FRE  Freddie Mac 
Other  Other 
Unknown  Unknown 

CurrentFirstMortgageHolderType Bound Attachments 
Name  Current Value 

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

CurrentFirstMortgageHolderType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

CurrentFirstMortgageHolderType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

CurrentFirstMortgageHolderType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

CurrentFirstMortgageHolderType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


CurrentFirstMortgageHolderTypeOtherDescription 
Base Entity  REFINANCE 
Attribute Name  CurrentFirstMortgageHolderTypeOtherDescription 
Logical Rolename   
ColumnName  CurrentFirstMortgageHolderTypeOtherDescription 
RoleName   
Domain  MISMOString 
Definition  A free form text field used to collect additional information when Other is selected for Current First Mortgage Holder Type. 
Note 
 

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

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

CurrentFirstMortgageHolderTypeOtherDescription Bound Attachments 
Name  Current Value 

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

CurrentFirstMortgageHolderTypeOtherDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

CurrentFirstMortgageHolderTypeOtherDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

CurrentFirstMortgageHolderTypeOtherDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

CurrentFirstMortgageHolderTypeOtherDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


EstimatedCashOutAmount 
Base Entity  REFINANCE 
Attribute Name  EstimatedCashOutAmount 
Logical Rolename   
ColumnName  EstimatedCashOutAmount 
RoleName   
Domain  MISMOAmount 
Definition  The estimated amount of cash that the borrower may receive at closing based on a calculation agreed to by the parties to the transaction. 
Note 
 

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

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

EstimatedCashOutAmount Bound Attachments 
Name  Current Value 

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

EstimatedCashOutAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

EstimatedCashOutAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

EstimatedCashOutAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

EstimatedCashOutAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


NonStructuralAlterationsConventionalAmount 
Base Entity  REFINANCE 
Attribute Name  NonStructuralAlterationsConventionalAmount 
Logical Rolename   
ColumnName  NonStructuralAlterationsConventionalAmount 
RoleName   
Domain  MISMOAmount 
Definition  The amount of non-structural alterations, improvements and repairs. 
Note 
 

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

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

NonStructuralAlterationsConventionalAmount Bound Attachments 
Name  Current Value 

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

NonStructuralAlterationsConventionalAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

NonStructuralAlterationsConventionalAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

NonStructuralAlterationsConventionalAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

NonStructuralAlterationsConventionalAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


RefinanceAssetsAcquiredAmount 
Base Entity  REFINANCE 
Attribute Name  RefinanceAssetsAcquiredAmount 
Logical Rolename   
ColumnName  RefinanceAssetsAcquiredAmount 
RoleName   
Domain  MISMOAmount 
Definition  The dollar amount applied to assets aquired with the proceeds from a refinance transaction. 
Note 
 

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

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

RefinanceAssetsAcquiredAmount Bound Attachments 
Name  Current Value 

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

RefinanceAssetsAcquiredAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

RefinanceAssetsAcquiredAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

RefinanceAssetsAcquiredAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

RefinanceAssetsAcquiredAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


RefinanceCashOutAmount 
Base Entity  REFINANCE 
Attribute Name  RefinanceCashOutAmount 
Logical Rolename   
ColumnName  RefinanceCashOutAmount 
RoleName   
Domain  MISMOAmount 
Definition  The amount of cash the borrower will receive at the closing of the loan on a refinance transaction. 
Note 
 

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

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

RefinanceCashOutAmount Bound Attachments 
Name  Current Value 

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

RefinanceCashOutAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

RefinanceCashOutAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

RefinanceCashOutAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

RefinanceCashOutAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


RefinanceCashOutDeterminationType 
Base Entity  REFINANCE 
Attribute Name  RefinanceCashOutDeterminationType 
Logical Rolename   
ColumnName  RefinanceCashOutDeterminationType 
RoleName   
Domain  RefinanceCashOutDeterminationEnum 
Definition  Specifies how the lender has classified a refinanced loan.  
Note 
 

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

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

RefinanceCashOutDeterminationType Reference Value (Bound to Domain) 
Name  ValidationRule420 
Description   
Type  By List 
Value  Value Description 
CashOut  CashOut 
LimitedCashOut  LimitedCashOut 
NoCashOut  NoCashOut 
Unknown  Unknown 

RefinanceCashOutDeterminationType Bound Attachments 
Name  Current Value 

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

RefinanceCashOutDeterminationType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

RefinanceCashOutDeterminationType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

RefinanceCashOutDeterminationType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

RefinanceCashOutDeterminationType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


RefinanceCashOutPercent 
Base Entity  REFINANCE 
Attribute Name  RefinanceCashOutPercent 
Logical Rolename   
ColumnName  RefinanceCashOutPercent 
RoleName   
Domain  MISMOPercent 
Definition  Percentage of Base Loan Amount that will be dispersed as cash to the borrower. 
Note 
 

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

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

RefinanceCashOutPercent Bound Attachments 
Name  Current Value 

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

RefinanceCashOutPercent Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

RefinanceCashOutPercent Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

RefinanceCashOutPercent Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

RefinanceCashOutPercent Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


RefinanceDebtReductionAmount 
Base Entity  REFINANCE 
Attribute Name  RefinanceDebtReductionAmount 
Logical Rolename   
ColumnName  RefinanceDebtReductionAmount 
RoleName   
Domain  MISMOAmount 
Definition  The dollar amount applied to debt reduction from the proceeds from refinance transaction. 
Note 
 

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

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

RefinanceDebtReductionAmount Bound Attachments 
Name  Current Value 

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

RefinanceDebtReductionAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

RefinanceDebtReductionAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

RefinanceDebtReductionAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

RefinanceDebtReductionAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


RefinanceHomeImprovementAmount 
Base Entity  REFINANCE 
Attribute Name  RefinanceHomeImprovementAmount 
Logical Rolename   
ColumnName  RefinanceHomeImprovementAmount 
RoleName   
Domain  MISMOAmount 
Definition  The dollar amount applied to home improvements from the proceeds from a refinance transaction. 
Note 
 

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

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

RefinanceHomeImprovementAmount Bound Attachments 
Name  Current Value 

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

RefinanceHomeImprovementAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

RefinanceHomeImprovementAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

RefinanceHomeImprovementAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

RefinanceHomeImprovementAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


RefinancePrimaryPurposeType 
Base Entity  REFINANCE 
Attribute Name  RefinancePrimaryPurposeType 
Logical Rolename   
ColumnName  RefinancePrimaryPurposeType 
RoleName   
Domain  RefinancePrimaryPurposeEnum 
Definition  Specifies the primary purpose of the refinance.  
Note 
 

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

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

RefinancePrimaryPurposeType Reference Value (Bound to Domain) 
Name  ValidationRule422 
Description   
Type  By List 
Value  Value Description 
AssetAcquisition  AssetAcquisition 
CapitalizedInterestTaxesInsuranceOrFees  CapitalizedInterestTaxesInsuranceOrFees 
Cash  Cash 
Convenience  Convenience 
DebtConsolidation  DebtConsolidation 
Education  Education 
EquityBuyout  EquityBuyout 
HomeImprovement  HomeImprovement 
InterestRateReduction  To decrease the Note Rate Percent 
Medical  Medical 
MortgageTermReduction  To shorten the maturity period of the note 
Other  Other 
PayoffLeaseholdInterest  PayoffLeaseholdInterest 
PrimaryLienPayoff  PrimaryLienPayoff 
SecondaryLienPayoff  SecondaryLienPayoff 
SpecialPurpose  SpecialPurpose 
UnsecuredLienPayoff  UnsecuredLienPayoff 
Unspecified  Unspecified 

RefinancePrimaryPurposeType Bound Attachments 
Name  Current Value 

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

RefinancePrimaryPurposeType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

RefinancePrimaryPurposeType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

RefinancePrimaryPurposeType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

RefinancePrimaryPurposeType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


RefinancePrimaryPurposeTypeOtherDescription 
Base Entity  REFINANCE 
Attribute Name  RefinancePrimaryPurposeTypeOtherDescription 
Logical Rolename   
ColumnName  RefinancePrimaryPurposeTypeOtherDescription 
RoleName   
Domain  MISMOString 
Definition  A free form text field used to collect additional information when Other is selected for Refinance Primary Purpose Type. 
Note 
 

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

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

RefinancePrimaryPurposeTypeOtherDescription Bound Attachments 
Name  Current Value 

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

RefinancePrimaryPurposeTypeOtherDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

RefinancePrimaryPurposeTypeOtherDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

RefinancePrimaryPurposeTypeOtherDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

RefinancePrimaryPurposeTypeOtherDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


SecondaryFinancingRefinanceIndicator 
Base Entity  REFINANCE 
Attribute Name  SecondaryFinancingRefinanceIndicator 
Logical Rolename   
ColumnName  SecondaryFinancingRefinanceIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates whether a subordinate mortgage will be paid off by the refinance and rolled into the new first mortgage balance. Used for refinances. 
Note 
 

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

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

SecondaryFinancingRefinanceIndicator Bound Attachments 
Name  Current Value 

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

SecondaryFinancingRefinanceIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SecondaryFinancingRefinanceIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SecondaryFinancingRefinanceIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SecondaryFinancingRefinanceIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


StructuralAlterationsConventionalAmount 
Base Entity  REFINANCE 
Attribute Name  StructuralAlterationsConventionalAmount 
Logical Rolename   
ColumnName  StructuralAlterationsConventionalAmount 
RoleName   
Domain  MISMOAmount 
Definition  The amount of structural alterations, improvements, and repairs. 
Note 
 

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

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

StructuralAlterationsConventionalAmount Bound Attachments 
Name  Current Value 

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

StructuralAlterationsConventionalAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

StructuralAlterationsConventionalAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

StructuralAlterationsConventionalAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

StructuralAlterationsConventionalAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


TotalPriorLienPayoffAmount 
Base Entity  REFINANCE 
Attribute Name  TotalPriorLienPayoffAmount 
Logical Rolename   
ColumnName  TotalPriorLienPayoffAmount 
RoleName   
Domain  MISMOAmount 
Definition  The total dollar amount of the refinance proceeds that is applied to liens on the subject property. CALCULATED RESULTS FIELD 
Note 
 

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

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

TotalPriorLienPayoffAmount Bound Attachments 
Name  Current Value 

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

TotalPriorLienPayoffAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

TotalPriorLienPayoffAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

TotalPriorLienPayoffAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

TotalPriorLienPayoffAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


TotalPriorLienPrepaymentPenaltyAmount 
Base Entity  REFINANCE 
Attribute Name  TotalPriorLienPrepaymentPenaltyAmount 
Logical Rolename   
ColumnName  TotalPriorLienPrepaymentPenaltyAmount 
RoleName   
Domain  MISMOAmount 
Definition  The total dollar amount of the prepayment penalty that is incurred for all liens being paid off as a result of the refinance. 
Note 
 

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

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

TotalPriorLienPrepaymentPenaltyAmount Bound Attachments 
Name  Current Value 

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

TotalPriorLienPrepaymentPenaltyAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

TotalPriorLienPrepaymentPenaltyAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

TotalPriorLienPrepaymentPenaltyAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

TotalPriorLienPrepaymentPenaltyAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description