TERMS_OF_LOAN 
EntityType  Dependent 
Logical Entity Name  TERMS_OF_LOAN 
Default Table Name  DEAL/SERVICES/SERVICE/CREDIT/CREDIT_RESPONSE/LOANS/LOAN/TERMS_OF_LOAN 
Definition  Describes characteristics of the loan, including the behavior defined in the financial instrument. 
Note 
 

TERMS_OF_LOAN Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
BaseLoanAmount  MISMOAmount  DECIMAL(0, 2)  NO  The base loan amount to be loaned to the borrower not including PMI, MIP, or Funding Fee. 
DisclosedFullyIndexedRatePercent  MISMOPercent  DECIMAL(0, 2)  NO  The value of the fully indexed interest rate, expressed as a percent, that must be disclosed to the borrower for adjustable rate mortgages. 
DisclosedIndexRatePercent  MISMOPercent  DECIMAL(0, 2)  NO  The value of the financial index, expressed as a percent, used to calculate the Disclosed Fully Indexed Interest Rate that must be disclosed to the borrower for adjustable rate mortgages. 
DisclosedMarginRatePercent  MISMOPercent  DECIMAL(0, 2)  NO  The number of percentage points to be added to the Disclosed Index Rate Percent to arrive at the Disclosed Fully Indexed Interest Rate that must be disclosed to the borrower for adjustable rate mortgages. 
LienPriorityType  LienPriorityEnum  VARCHAR(0)  YES  Specifies the priority of the lien against the subject property.
 
LienPriorityTypeOtherDescription  MISMOString  VARCHAR(0)  NO  A free-form text field used to capture the lien priority type if Other is selected as the lien priority type. 
LoanPurposeType  LoanPurposeEnum  VARCHAR(0)  YES  Specifies the purpose for which the loan proceeds will be used.
 
LoanPurposeTypeOtherDescription  MISMOString  VARCHAR(0)  NO  A free-form text field used to capture the purpose of the loan when Other is indicated for Loan Purpose. 
MortgageType  MortgageEnum  VARCHAR(0)  YES  Identifies the highest level private or public sector entity under whose guidelines the mortgage is originated.
 
MortgageTypeOtherDescription  MISMOString  VARCHAR(0)  NO  A free-form text field used to collect additional information or a description of the mortgage type when Other is selected. 
NoteAmount  MISMOAmount  DECIMAL(0, 2)  NO  The amount to be repaid as disclosed on the note. 
NoteDate  MISMODate  DATE  NO  The date on the note. 
NoteRatePercent  MISMOPercent  DECIMAL(0, 2)  NO  The actual interest rate as disclosed on the note. 
OriginalInterestRateDiscountPercent  MISMOPercent  DECIMAL(0, 2)  NO  For mortgages with an initial discounted rate (teaser rate), the difference in percentage points between the initial discounted rate and the fully indexed rate. 
SupplementalMortgageType  MortgageEnum  VARCHAR(0)  YES  Identifies another lower-level private or public sector agency under whose guidelines the mortgage is originated.Identifies the highest level private or public sector entity under whose guidelines the mortgage is originated.
 
SupplementalMortgageTypeOtherDescription  MISMOString  VARCHAR(0)  NO  A free-form text field used to collect additional information or a description of the Supplemental Mortgage Type when Other is selected. 
UPBChangeFrequencyType  UPBChangeFrequencyEnum  VARCHAR(0)  YES  Frequency of changes to the unpaid principal balance.
 

TERMS_OF_LOAN Keys 
Key Name  Key Type  Keys 

TERMS_OF_LOAN 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 

TERMS_OF_LOAN Check Constraints 
Check Constraint Name  CheckConstraint 

TERMS_OF_LOAN Bound Attachments 
Name  Current Value 

TERMS_OF_LOAN User-Defined Mappings 
Model  Name  Description 

TERMS_OF_LOAN Data Movement Rules 
Name  Type  Rule Text/Value