LoanRoleType 
Base Entity  LOAN 
Attribute Name  LoanRoleType 
Logical Rolename   
ColumnName  LoanRoleType 
RoleName   
Domain  LoanRoleEnum 
Definition  An attribute of LOAN used to identify the role the associated LOAN plays in the transaction. 
Note 
 

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

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

LoanRoleType Reference Value (Bound to Domain) 
Name  ValidationRule272 
Description   
Type  By List 
Value  Value Description 
HistoricalLoan  A loan linked to this transaction via past relationship to the borrower and mortgage type. Does not have a direct bearing on the Related Loan or Subject Loan. 
RelatedLoan  A loan linked to the subject loan by virtue of being collateralized by the same property. Examples include the loan being refinanced, or a HELOC or other subordinate lien collateralized by the same property as the subject loan. 
SubjectLoan  The loan that is the object of the transaction, upon which the receiving business partner will take some action. 

LoanRoleType Bound Attachments 
Name  Current Value 

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

LoanRoleType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

LoanRoleType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

LoanRoleType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

LoanRoleType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


SelectionType 
Base Entity  LOAN 
Attribute Name  SelectionType 
Logical Rolename   
ColumnName  SelectionType 
RoleName   
Domain  SelectionEnum 
Definition  A classification of the collection of loan parameters to support borrower shopping for loan products. 
Note 
 

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

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

SelectionType Reference Value (Bound to Domain) 
Name  ValidationRule444 
Description   
Type  By List 
Value  Value Description 
Comparison  one of possibly many loan paramter sets used to complate GFE Page 3 
Requested  Borrower or lender selected paramters for searching for a loan 
Selected  Loan paramters that will be processed or has been processed. Assumed value if SelectionType is not present 

SelectionType Bound Attachments 
Name  Current Value 

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

SelectionType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SelectionType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SelectionType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SelectionType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


SequenceNumber 
Base Entity  LOAN 
Attribute Name  SequenceNumber 
Logical Rolename   
ColumnName  SequenceNumber 
RoleName   
Domain  XSD:Integer 
Definition  An integer value used to provide an order to multi-instance sibling elements. The value must be unique for each sibling element. 
Note 
 

SequenceNumber Logical Attribute Properties 
Logical Attribute Name  SequenceNumber 
Datatype  INTEGER 
Nullable  YES 

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

SequenceNumber Bound Attachments 
Name  Current Value 

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

SequenceNumber Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SequenceNumber Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SequenceNumber Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SequenceNumber Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


IneligibleLoanProductIndicator 
Base Entity  LOAN 
Attribute Name  IneligibleLoanProductIndicator 
Logical Rolename   
ColumnName  IneligibleLoanProductIndicator 
RoleName   
Domain  MISMOIndicator_Base 
Definition  When true, indicates this Loan Product is ineligible based on Deal characteristics. 
Note 
 

IneligibleLoanProductIndicator Logical Attribute Properties 
Logical Attribute Name  IneligibleLoanProductIndicator 
Datatype  BIT 
Nullable  YES 

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

IneligibleLoanProductIndicator Bound Attachments 
Name  Current Value 

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

IneligibleLoanProductIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

IneligibleLoanProductIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

IneligibleLoanProductIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

IneligibleLoanProductIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description