AutomatedUnderwritingCaseIdentifier 
Base Entity  AUTOMATED_UNDERWRITING 
Attribute Name  AutomatedUnderwritingCaseIdentifier 
Logical Rolename   
ColumnName  AutomatedUnderwritingCaseIdentifier 
RoleName   
Domain  MISMOIdentifier 
Definition  A unique identifier assigned by the underwriting system to the underwriting case for a specific loan application. 
Note 
 

AutomatedUnderwritingCaseIdentifier Logical Attribute Properties 
Logical Attribute Name  AutomatedUnderwritingCaseIdentifier 
Datatype  VARCHAR(0) 
Nullable  NO 

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

AutomatedUnderwritingCaseIdentifier Bound Attachments 
Name  Current Value 

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

AutomatedUnderwritingCaseIdentifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

AutomatedUnderwritingCaseIdentifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

AutomatedUnderwritingCaseIdentifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

AutomatedUnderwritingCaseIdentifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


SequenceNumber 
Base Entity  AUTOMATED_UNDERWRITING 
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 


AutomatedUnderwritingDecisionDatetime 
Base Entity  AUTOMATED_UNDERWRITING 
Attribute Name  AutomatedUnderwritingDecisionDatetime 
Logical Rolename   
ColumnName  AutomatedUnderwritingDecisionDatetime 
RoleName   
Domain  MISMODatetime 
Definition  The date and time of the underwriting decision. 
Note 
 

AutomatedUnderwritingDecisionDatetime Logical Attribute Properties 
Logical Attribute Name  AutomatedUnderwritingDecisionDatetime 
Datatype  TIMESTAMP/DATE 
Nullable  NO 

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

AutomatedUnderwritingDecisionDatetime Bound Attachments 
Name  Current Value 

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

AutomatedUnderwritingDecisionDatetime Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

AutomatedUnderwritingDecisionDatetime Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

AutomatedUnderwritingDecisionDatetime Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

AutomatedUnderwritingDecisionDatetime Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


AutomatedUnderwritingEvaluationStatusDescription 
Base Entity  AUTOMATED_UNDERWRITING 
Attribute Name  AutomatedUnderwritingEvaluationStatusDescription 
Logical Rolename   
ColumnName  AutomatedUnderwritingEvaluationStatusDescription 
RoleName   
Domain  MISMOString 
Definition  The status of the Automated Underwriting Certificate Request. 
Note 
 

AutomatedUnderwritingEvaluationStatusDescription Logical Attribute Properties 
Logical Attribute Name  AutomatedUnderwritingEvaluationStatusDescription 
Datatype  VARCHAR(0) 
Nullable  NO 

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

AutomatedUnderwritingEvaluationStatusDescription Bound Attachments 
Name  Current Value 

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

AutomatedUnderwritingEvaluationStatusDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

AutomatedUnderwritingEvaluationStatusDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

AutomatedUnderwritingEvaluationStatusDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

AutomatedUnderwritingEvaluationStatusDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


AutomatedUnderwritingMethodVersionIdentifier 
Base Entity  AUTOMATED_UNDERWRITING 
Attribute Name  AutomatedUnderwritingMethodVersionIdentifier 
Logical Rolename   
ColumnName  AutomatedUnderwritingMethodVersionIdentifier 
RoleName   
Domain  MISMOIdentifier 
Definition  Specifies the version of the Automated underwriting system used to underwrite the loan. Move from Underwriting Detail to Automated Underwriting. 
Note 
 

AutomatedUnderwritingMethodVersionIdentifier Logical Attribute Properties 
Logical Attribute Name  AutomatedUnderwritingMethodVersionIdentifier 
Datatype  VARCHAR(0) 
Nullable  NO 

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

AutomatedUnderwritingMethodVersionIdentifier Bound Attachments 
Name  Current Value 

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

AutomatedUnderwritingMethodVersionIdentifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

AutomatedUnderwritingMethodVersionIdentifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

AutomatedUnderwritingMethodVersionIdentifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

AutomatedUnderwritingMethodVersionIdentifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


AutomatedUnderwritingProcessDescription 
Base Entity  AUTOMATED_UNDERWRITING 
Attribute Name  AutomatedUnderwritingProcessDescription 
Logical Rolename   
ColumnName  AutomatedUnderwritingProcessDescription 
RoleName   
Domain  MISMOString 
Definition  A free form text description of the automated underwriting process or procedure used on the loan. 
Note 
 

AutomatedUnderwritingProcessDescription Logical Attribute Properties 
Logical Attribute Name  AutomatedUnderwritingProcessDescription 
Datatype  VARCHAR(0) 
Nullable  NO 

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

AutomatedUnderwritingProcessDescription Bound Attachments 
Name  Current Value 

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

AutomatedUnderwritingProcessDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

AutomatedUnderwritingProcessDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

AutomatedUnderwritingProcessDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

AutomatedUnderwritingProcessDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


AutomatedUnderwritingRecommendationDescription 
Base Entity  AUTOMATED_UNDERWRITING 
Attribute Name  AutomatedUnderwritingRecommendationDescription 
Logical Rolename   
ColumnName  AutomatedUnderwritingRecommendationDescription 
RoleName   
Domain  MISMOString 
Definition  The loan approval recommendation determined by the Automated Underwriting system. 
Note 
 

AutomatedUnderwritingRecommendationDescription Logical Attribute Properties 
Logical Attribute Name  AutomatedUnderwritingRecommendationDescription 
Datatype  VARCHAR(0) 
Nullable  NO 

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

AutomatedUnderwritingRecommendationDescription Bound Attachments 
Name  Current Value 

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

AutomatedUnderwritingRecommendationDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

AutomatedUnderwritingRecommendationDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

AutomatedUnderwritingRecommendationDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

AutomatedUnderwritingRecommendationDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


AutomatedUnderwritingSystemDocumentWaiverIndicator 
Base Entity  AUTOMATED_UNDERWRITING 
Attribute Name  AutomatedUnderwritingSystemDocumentWaiverIndicator 
Logical Rolename   
ColumnName  AutomatedUnderwritingSystemDocumentWaiverIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  When a returned AU system recommendation indicates that some or all of the loan information is not required to be formally documented in the loan submission package, e.g., no requirement to provide a wage statement, tax returns, etc. A loan of this type 
Note 
 

AutomatedUnderwritingSystemDocumentWaiverIndicator Logical Attribute Properties 
Logical Attribute Name  AutomatedUnderwritingSystemDocumentWaiverIndicator 
Datatype  BIT 
Nullable  NO 

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

AutomatedUnderwritingSystemDocumentWaiverIndicator Bound Attachments 
Name  Current Value 

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

AutomatedUnderwritingSystemDocumentWaiverIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

AutomatedUnderwritingSystemDocumentWaiverIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

AutomatedUnderwritingSystemDocumentWaiverIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

AutomatedUnderwritingSystemDocumentWaiverIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


AutomatedUnderwritingSystemResultValue 
Base Entity  AUTOMATED_UNDERWRITING 
Attribute Name  AutomatedUnderwritingSystemResultValue 
Logical Rolename   
ColumnName  AutomatedUnderwritingSystemResultValue 
RoleName   
Domain  MISMOValue 
Definition  The result of the private automated underwriting evaluation system. 
Note 
 

AutomatedUnderwritingSystemResultValue Logical Attribute Properties 
Logical Attribute Name  AutomatedUnderwritingSystemResultValue 
Datatype  VARCHAR(0) 
Nullable  NO 

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

AutomatedUnderwritingSystemResultValue Bound Attachments 
Name  Current Value 

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

AutomatedUnderwritingSystemResultValue Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

AutomatedUnderwritingSystemResultValue Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

AutomatedUnderwritingSystemResultValue Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

AutomatedUnderwritingSystemResultValue Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


AutomatedUnderwritingSystemType 
Base Entity  AUTOMATED_UNDERWRITING 
Attribute Name  AutomatedUnderwritingSystemType 
Logical Rolename   
ColumnName  AutomatedUnderwritingSystemType 
RoleName   
Domain  AutomatedUnderwritingSystemEnum 
Definition  The type of automated underwriting system used to evaluate the loan.  
Note 
 

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

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

AutomatedUnderwritingSystemType Reference Value (Bound to Domain) 
Name  ValidationRule35 
Description   
Type  By List 
Value  Value Description 
Assetwise  GMAC / RFC 
Capstone  Capstone 
Clues  Bank of America 
DesktopUnderwriter  Fannie Mae 
ECS  Wells Fargo 
LoanProspector  Freddie Mac 
Other  Other 
Strategyware  Strategyware 
Zippy  Chase 

AutomatedUnderwritingSystemType Bound Attachments 
Name  Current Value 

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

AutomatedUnderwritingSystemType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

AutomatedUnderwritingSystemType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

AutomatedUnderwritingSystemType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

AutomatedUnderwritingSystemType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


AutomatedUnderwritingSystemTypeOtherDescription 
Base Entity  AUTOMATED_UNDERWRITING 
Attribute Name  AutomatedUnderwritingSystemTypeOtherDescription 
Logical Rolename   
ColumnName  AutomatedUnderwritingSystemTypeOtherDescription 
RoleName   
Domain  MISMOString 
Definition  A free-form text field used to collect additional information when Other is selected for Automated Underwriting System Type. 
Note 
 

AutomatedUnderwritingSystemTypeOtherDescription Logical Attribute Properties 
Logical Attribute Name  AutomatedUnderwritingSystemTypeOtherDescription 
Datatype  VARCHAR(0) 
Nullable  NO 

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

AutomatedUnderwritingSystemTypeOtherDescription Bound Attachments 
Name  Current Value 

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

AutomatedUnderwritingSystemTypeOtherDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

AutomatedUnderwritingSystemTypeOtherDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

AutomatedUnderwritingSystemTypeOtherDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

AutomatedUnderwritingSystemTypeOtherDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


DesktopUnderwriterRecommendationType 
Base Entity  AUTOMATED_UNDERWRITING 
Attribute Name  DesktopUnderwriterRecommendationType 
Logical Rolename   
ColumnName  DesktopUnderwriterRecommendationType 
RoleName   
Domain  DesktopUnderwriterRecommendationEnum 
Definition  To convey the DU recommendation.  
Note 
 

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

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

DesktopUnderwriterRecommendationType Reference Value (Bound to Domain) 
Name  ValidationRule130 
Description   
Type  By List 
Value  Value Description 
ApproveEligible  ApproveEligible 
ApproveIneligible  ApproveIneligible 
Error  Error 
ExpandedApproval1Eligible  ExpandedApproval1Eligible 
ExpandedApproval1Ineligible  ExpandedApproval1Ineligible 
ExpandedApproval2Eligible  ExpandedApproval2Eligible 
ExpandedApproval2Ineligible  ExpandedApproval2Ineligible 
ExpandedApproval3Eligible  ExpandedApproval3Eligible 
ExpandedApproval3Ineligible  ExpandedApproval3Ineligible 
OutOfScope  OutOfScope 
ReferEligible  ReferEligible 
ReferIneligible  ReferIneligible 
ReferWithCaution4  ReferWithCaution4 
Unknown  Unknown 

DesktopUnderwriterRecommendationType Bound Attachments 
Name  Current Value 

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

DesktopUnderwriterRecommendationType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

DesktopUnderwriterRecommendationType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

DesktopUnderwriterRecommendationType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

DesktopUnderwriterRecommendationType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


FREPurchaseEligibilityType 
Base Entity  AUTOMATED_UNDERWRITING 
Attribute Name  FREPurchaseEligibilityType 
Logical Rolename   
ColumnName  FREPurchaseEligibilityType 
RoleName   
Domain  FREPurchaseEligibilityEnum 
Definition  To convey the Freddie Mac purchase eligibility.  
Note 
 

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

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

FREPurchaseEligibilityType Reference Value (Bound to Domain) 
Name  ValidationRule166 
Description   
Type  By List 
Value  Value Description 
FreddieMacEligible  FreddieMacEligible 
FreddieMacIneligible  FreddieMacIneligible 

FREPurchaseEligibilityType Bound Attachments 
Name  Current Value 

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

FREPurchaseEligibilityType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FREPurchaseEligibilityType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FREPurchaseEligibilityType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FREPurchaseEligibilityType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


LoanProspectorCreditRiskClassificationDescription 
Base Entity  AUTOMATED_UNDERWRITING 
Attribute Name  LoanProspectorCreditRiskClassificationDescription 
Logical Rolename   
ColumnName  LoanProspectorCreditRiskClassificationDescription 
RoleName   
Domain  MISMOString 
Definition  The Loan Prospector credit risk classification for a loan. 
Note 
 

LoanProspectorCreditRiskClassificationDescription Logical Attribute Properties 
Logical Attribute Name  LoanProspectorCreditRiskClassificationDescription 
Datatype  VARCHAR(0) 
Nullable  NO 

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

LoanProspectorCreditRiskClassificationDescription Bound Attachments 
Name  Current Value 

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

LoanProspectorCreditRiskClassificationDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

LoanProspectorCreditRiskClassificationDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

LoanProspectorCreditRiskClassificationDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

LoanProspectorCreditRiskClassificationDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


LoanProspectorDocumentationClassificationDescription 
Base Entity  AUTOMATED_UNDERWRITING 
Attribute Name  LoanProspectorDocumentationClassificationDescription 
Logical Rolename   
ColumnName  LoanProspectorDocumentationClassificationDescription 
RoleName   
Domain  MISMOString 
Definition  The Loan Prospector documentation classification for the loan. 
Note 
 

LoanProspectorDocumentationClassificationDescription Logical Attribute Properties 
Logical Attribute Name  LoanProspectorDocumentationClassificationDescription 
Datatype  VARCHAR(0) 
Nullable  NO 

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

LoanProspectorDocumentationClassificationDescription Bound Attachments 
Name  Current Value 

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

LoanProspectorDocumentationClassificationDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

LoanProspectorDocumentationClassificationDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

LoanProspectorDocumentationClassificationDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

LoanProspectorDocumentationClassificationDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description