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 |