REFINANCE 
EntityType  Dependent 
Logical Entity Name  REFINANCE 
Default Table Name  DEAL/SERVICES/SERVICE/CREDIT/CREDIT_RESPONSE/LOANS/LOAN/REFINANCE 
Definition   
Note 
 

REFINANCE Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
CurrentFirstMortgageHolderType  CurrentFirstMortgageHolderEnum  VARCHAR(0)  YES  Specifies the investor holding the first mortgage that is being refinanced.
 
CurrentFirstMortgageHolderTypeOtherDescription  MISMOString  VARCHAR(0)  NO  A free form text field used to collect additional information when Other is selected for Current First Mortgage Holder Type. 
EstimatedCashOutAmount  MISMOAmount  DECIMAL(0, 2)  NO  The estimated amount of cash that the borrower may receive at closing based on a calculation agreed to by the parties to the transaction. 
NonStructuralAlterationsConventionalAmount  MISMOAmount  DECIMAL(0, 2)  NO  The amount of non-structural alterations, improvements and repairs. 
RefinanceAssetsAcquiredAmount  MISMOAmount  DECIMAL(0, 2)  NO  The dollar amount applied to assets aquired with the proceeds from a refinance transaction. 
RefinanceCashOutAmount  MISMOAmount  DECIMAL(0, 2)  NO  The amount of cash the borrower will receive at the closing of the loan on a refinance transaction. 
RefinanceCashOutDeterminationType  RefinanceCashOutDeterminationEnum  VARCHAR(0)  YES  Specifies how the lender has classified a refinanced loan.
 
RefinanceCashOutPercent  MISMOPercent  DECIMAL(0, 2)  NO  Percentage of Base Loan Amount that will be dispersed as cash to the borrower. 
RefinanceDebtReductionAmount  MISMOAmount  DECIMAL(0, 2)  NO  The dollar amount applied to debt reduction from the proceeds from refinance transaction. 
RefinanceHomeImprovementAmount  MISMOAmount  DECIMAL(0, 2)  NO  The dollar amount applied to home improvements from the proceeds from a refinance transaction. 
RefinancePrimaryPurposeType  RefinancePrimaryPurposeEnum  VARCHAR(0)  YES  Specifies the primary purpose of the refinance.
 
RefinancePrimaryPurposeTypeOtherDescription  MISMOString  VARCHAR(0)  NO  A free form text field used to collect additional information when Other is selected for Refinance Primary Purpose Type. 
SecondaryFinancingRefinanceIndicator  MISMOIndicator  BIT  NO  Indicates whether a subordinate mortgage will be paid off by the refinance and rolled into the new first mortgage balance. Used for refinances. 
StructuralAlterationsConventionalAmount  MISMOAmount  DECIMAL(0, 2)  NO  The amount of structural alterations, improvements, and repairs. 
TotalPriorLienPayoffAmount  MISMOAmount  DECIMAL(0, 2)  NO  The total dollar amount of the refinance proceeds that is applied to liens on the subject property. CALCULATED RESULTS FIELD 
TotalPriorLienPrepaymentPenaltyAmount  MISMOAmount  DECIMAL(0, 2)  NO  The total dollar amount of the prepayment penalty that is incurred for all liens being paid off as a result of the refinance. 

REFINANCE Keys 
Key Name  Key Type  Keys 

REFINANCE Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
LOAN  Identifying  One to Zero or One          NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 

REFINANCE Check Constraints 
Check Constraint Name  CheckConstraint 

REFINANCE Bound Attachments 
Name  Current Value 

REFINANCE User-Defined Mappings 
Model  Name  Description 

REFINANCE Data Movement Rules 
Name  Type  Rule Text/Value