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

QUALIFICATION Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
BorrowerReservesMonthlyPaymentCount  MISMOCount  INTEGER  NO  The number of loan payments that are available to the borrower from verified financial reserves after closing. CALCULATED RESULTS FIELD 
HousingExpenseRatioPercent  MISMOPercent  DECIMAL(0, 2)  NO  The ratio of the proposed housing expenses to the qualifying income of the borrowers as per lender or investor guidelines. AKA Front End Ratio. CALCULATED RESULT FIELD 
ProjectedReservesAmount  MISMOAmount  DECIMAL(0, 2)  NO  Based on investor guidelines, the projected dollar amount of remaining liquid assets after settlement. CALCULATED RESULTS FIELD. 
QualifyingPaymentAmount  MISMOAmount  DECIMAL(0, 2)  NO  The PITI used to qualify the borrower for a loan, calculated using the investor or regulator specified interest rate that is higher than the initial rate. 
QualifyingRatePercent  MISMOPercent  DECIMAL(0, 2)  NO  The rate used to calculate the borrowers payment (PITI) to qualify the borrower for the subject mortgage. 
QualifyingRateType  QualifyingRateEnum  VARCHAR(0)  YES  Indicates what interest rate was used to qualify the borrower in correlation with the note rate.
 
QualifyingRateTypeOtherDescription  MISMOString  VARCHAR(0)  NO  A free-form text field used to capture the Qualifying Rate type if Other is selected. 
SummaryInterestedPartyContributionsPercent  MISMOPercent  DECIMAL(0, 2)  NO  Percentage of the loan amount contributed by all interested parties. This may be captured on the Uniform Underwriting Transmittal Summary (1008/1077). CALCULATED RESULTS and FORM SPECIFIC 
TotalDebtExpenseRatioPercent  MISMOPercent  DECIMAL(0, 2)  NO  The ratio of all debt payments of the borrowers, including proposed housing expenses, to the qualifying income of the borrowers. AKA Back End Ratio. CALCULATED RESULT FIELD 
TotalLiabilitiesMonthlyPaymentAmount  MISMOAmount  DECIMAL(0, 2)  NO  The total monthly liabilities for all borrowers on the loan. CALCULATED RESULTS FIELD. 
TotalMonthlyCurrentHousingExpenseAmount  MISMOAmount  DECIMAL(0, 2)  NO  The total monthly current housing expense for all borrowers on the loan. CALCULATED RESULTS FIELD. 
TotalMonthlyIncomeAmount  MISMOAmount  DECIMAL(0, 2)  NO  The total monthly income for all borrowers on the loan. CALCULATED RESULTS FIELD. 
TotalMonthlyProposedHousingExpenseAmount  MISMOAmount  DECIMAL(0, 2)  NO  The total monthly proposed housing expense for all borrowers on the loan. CALCULATED RESULTS FIELD. 
TotalVerifiedReservesAmount  MISMOAmount  DECIMAL(0, 2)  NO  The actual dollar amount of remaining verified liquid assets after settlement. CALCULATED RESULTS FIELD 
VerifiedAssetsTotalAmount  MISMOAmount  DECIMAL(0, 2)  NO  The total amount of all assets of the borrowers that have been verified by the lender. This may be used on the Uniform Underwritting Transmittal Summary. Calculated results field. 

QUALIFICATION Keys 
Key Name  Key Type  Keys 

QUALIFICATION 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 

QUALIFICATION Check Constraints 
Check Constraint Name  CheckConstraint 

QUALIFICATION Bound Attachments 
Name  Current Value 

QUALIFICATION User-Defined Mappings 
Model  Name  Description 

QUALIFICATION Data Movement Rules 
Name  Type  Rule Text/Value