LoanStateDate 
Base Entity  LOAN_STATE 
Attribute Name  LoanStateDate 
Logical Rolename   
ColumnName  LoanStateDate 
RoleName   
Domain  MISMODate 
Definition  Specifies the date for the "Loan State Type". 
Note 
 

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

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

LoanStateDate Bound Attachments 
Name  Current Value 

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

LoanStateDate Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

LoanStateDate Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

LoanStateDate Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

LoanStateDate Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


LoanStateType 
Base Entity  LOAN_STATE 
Attribute Name  LoanStateType 
Logical Rolename   
ColumnName  LoanStateType 
RoleName   
Domain  LoanStateEnum 
Definition  Identifies the state in time for the information associated with this occurrence of LOAN.  
Note 
 

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

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

LoanStateType Reference Value (Bound to Domain) 
Name  ValidationRule273 
Description   
Type  By List 
Value  Value Description 
AtClosing  A snapshot of the loan data at the completion of the closing process. This is sometimes referred to as original. 
AtConversion  For loans with a conversion option, a snapshot of the loan data at the time the conversion features become effective (e.g., biweekly to monthly payments; adjustable to fixed rate amortization). 
AtModification  For loans which undergo term modifications not originally specified in the note, a snapshot of the loan data at the time the new note terms become effective. 
AtReset  For balloon mortgages with a reset feature, a snapshot of the loan data on the balloon maturity date at the time the borrower exercises the reset option to modify and extend the balloon note. 
Current  A snapshot of the loan data as of the Loan State Date. 

LoanStateType Bound Attachments 
Name  Current Value 

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

LoanStateType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

LoanStateType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

LoanStateType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

LoanStateType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description