BorrowerAgeAtApplicationYearsCount |
Base Entity | BORROWER_DETAIL |
Attribute Name | BorrowerAgeAtApplicationYearsCount |
Logical Rolename | |
ColumnName | BorrowerAgeAtApplicationYearsCount |
RoleName | |
Domain | MISMOCount |
Definition | The age of the borrower at the time of application in years. |
Note |
BorrowerAgeAtApplicationYearsCount Logical Attribute Properties |
Logical Attribute Name | BorrowerAgeAtApplicationYearsCount |
Datatype | INTEGER |
Nullable | NO |
BorrowerAgeAtApplicationYearsCount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
BorrowerAgeAtApplicationYearsCount Bound Attachments |
Name | Current Value |
BorrowerAgeAtApplicationYearsCount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
BorrowerAgeAtApplicationYearsCount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerAgeAtApplicationYearsCount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerAgeAtApplicationYearsCount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerAgeAtApplicationYearsCount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerApplicationSignedDate |
Base Entity | BORROWER_DETAIL |
Attribute Name | BorrowerApplicationSignedDate |
Logical Rolename | |
ColumnName | BorrowerApplicationSignedDate |
RoleName | |
Domain | MISMODate |
Definition | The date that the borrower signed the loan application. Collected on the URLA in Section IX (Borrowers Signature Date). |
Note |
BorrowerApplicationSignedDate Logical Attribute Properties |
Logical Attribute Name | BorrowerApplicationSignedDate |
Datatype | DATE |
Nullable | NO |
BorrowerApplicationSignedDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
BorrowerApplicationSignedDate Bound Attachments |
Name | Current Value |
BorrowerApplicationSignedDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
BorrowerApplicationSignedDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerApplicationSignedDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerApplicationSignedDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerApplicationSignedDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerBirthDate |
Base Entity | BORROWER_DETAIL |
Attribute Name | BorrowerBirthDate |
Logical Rolename | |
ColumnName | BorrowerBirthDate |
RoleName | |
Domain | MISMODate |
Definition | Borrowers date of birth. |
Note |
BorrowerBirthDate Logical Attribute Properties |
Logical Attribute Name | BorrowerBirthDate |
Datatype | DATE |
Nullable | NO |
BorrowerBirthDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
BorrowerBirthDate Bound Attachments |
Name | Current Value |
BorrowerBirthDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
BorrowerBirthDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerBirthDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerBirthDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerBirthDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerCanadianSocialInsuranceNumberIdentifier |
Base Entity | BORROWER_DETAIL |
Attribute Name | BorrowerCanadianSocialInsuranceNumberIdentifier |
Logical Rolename | |
ColumnName | BorrowerCanadianSocialInsuranceNumberIdentifier |
RoleName | |
Domain | MISMOIdentifier |
Definition | The Canadian Social Insurance Number associated with the borrower. |
Note |
BorrowerCanadianSocialInsuranceNumberIdentifier Logical Attribute Properties |
Logical Attribute Name | BorrowerCanadianSocialInsuranceNumberIdentifier |
Datatype | VARCHAR(0) |
Nullable | NO |
BorrowerCanadianSocialInsuranceNumberIdentifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
BorrowerCanadianSocialInsuranceNumberIdentifier Bound Attachments |
Name | Current Value |
BorrowerCanadianSocialInsuranceNumberIdentifier User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
BorrowerCanadianSocialInsuranceNumberIdentifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerCanadianSocialInsuranceNumberIdentifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerCanadianSocialInsuranceNumberIdentifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerCanadianSocialInsuranceNumberIdentifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerCharacteristicType |
Base Entity | BORROWER_DETAIL |
Attribute Name | BorrowerCharacteristicType |
Logical Rolename | |
ColumnName | BorrowerCharacteristicType |
RoleName | |
Domain | BorrowerCharacteristicEnum |
Definition | Specifies the classification applied to a borrower for the purposes of processing or reporting. |
Note |
BorrowerCharacteristicType Logical Attribute Properties |
Logical Attribute Name | BorrowerCharacteristicType |
Datatype | VARCHAR(0) |
Nullable | YES |
BorrowerCharacteristicType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
BorrowerCharacteristicType Reference Value (Bound to Domain) |
Name | ValidationRule39 |
Description | |
Type | By List |
Value | Value Description |
LivingTrust | LivingTrust |
Other | Other |
SeasonedWorker | SeasonedWorker |
SellerEmployee | SellerEmployee |
TrailingBorrower | TrailingBorrower |
BorrowerCharacteristicType Bound Attachments |
Name | Current Value |
BorrowerCharacteristicType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
BorrowerCharacteristicType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerCharacteristicType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerCharacteristicType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerCharacteristicType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerCharacteristicTypeOtherDescription |
Base Entity | BORROWER_DETAIL |
Attribute Name | BorrowerCharacteristicTypeOtherDescription |
Logical Rolename | |
ColumnName | BorrowerCharacteristicTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | The description of the Borrower Characteristic Type when Other is selected as the option from the enumerated list. |
Note |
BorrowerCharacteristicTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | BorrowerCharacteristicTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
BorrowerCharacteristicTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
BorrowerCharacteristicTypeOtherDescription Bound Attachments |
Name | Current Value |
BorrowerCharacteristicTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
BorrowerCharacteristicTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerCharacteristicTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerCharacteristicTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerCharacteristicTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerClassificationType |
Base Entity | BORROWER_DETAIL |
Attribute Name | BorrowerClassificationType |
Logical Rolename | |
ColumnName | BorrowerClassificationType |
RoleName | |
Domain | BorrowerClassificationEnum |
Definition | Indicates whether the borrower is the primary or a secondary borrower. |
Note |
BorrowerClassificationType Logical Attribute Properties |
Logical Attribute Name | BorrowerClassificationType |
Datatype | VARCHAR(0) |
Nullable | YES |
BorrowerClassificationType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
BorrowerClassificationType Reference Value (Bound to Domain) |
Name | ValidationRule40 |
Description | |
Type | By List |
Value | Value Description |
Primary | Primary |
Secondary | Also know as co-borrower |
BorrowerClassificationType Bound Attachments |
Name | Current Value |
BorrowerClassificationType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
BorrowerClassificationType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerClassificationType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerClassificationType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerClassificationType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerMailToAddressSameAsPropertyIndicator |
Base Entity | BORROWER_DETAIL |
Attribute Name | BorrowerMailToAddressSameAsPropertyIndicator |
Logical Rolename | |
ColumnName | BorrowerMailToAddressSameAsPropertyIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | When true, indicates that the mailing address for the borrower is the same as the property address. |
Note |
BorrowerMailToAddressSameAsPropertyIndicator Logical Attribute Properties |
Logical Attribute Name | BorrowerMailToAddressSameAsPropertyIndicator |
Datatype | BIT |
Nullable | NO |
BorrowerMailToAddressSameAsPropertyIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
BorrowerMailToAddressSameAsPropertyIndicator Bound Attachments |
Name | Current Value |
BorrowerMailToAddressSameAsPropertyIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
BorrowerMailToAddressSameAsPropertyIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerMailToAddressSameAsPropertyIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerMailToAddressSameAsPropertyIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerMailToAddressSameAsPropertyIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerQualifyingIncomeAmount |
Base Entity | BORROWER_DETAIL |
Attribute Name | BorrowerQualifyingIncomeAmount |
Logical Rolename | |
ColumnName | BorrowerQualifyingIncomeAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The total monthly borrower income per lender or investor guidelines. |
Note |
BorrowerQualifyingIncomeAmount Logical Attribute Properties |
Logical Attribute Name | BorrowerQualifyingIncomeAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
BorrowerQualifyingIncomeAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
BorrowerQualifyingIncomeAmount Bound Attachments |
Name | Current Value |
BorrowerQualifyingIncomeAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
BorrowerQualifyingIncomeAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerQualifyingIncomeAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerQualifyingIncomeAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerQualifyingIncomeAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerRelationshipTitleType |
Base Entity | BORROWER_DETAIL |
Attribute Name | BorrowerRelationshipTitleType |
Logical Rolename | |
ColumnName | BorrowerRelationshipTitleType |
RoleName | |
Domain | BorrowerRelationshipTitleEnum |
Definition | The description of the relationship of a borrower to (an) other borrower(s), if any, for Title purposes. |
Note |
BorrowerRelationshipTitleType Logical Attribute Properties |
Logical Attribute Name | BorrowerRelationshipTitleType |
Datatype | VARCHAR(0) |
Nullable | YES |
BorrowerRelationshipTitleType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
BorrowerRelationshipTitleType Reference Value (Bound to Domain) |
Name | ValidationRule41 |
Description | |
Type | By List |
Value | Value Description |
AHusbandAndWife | AHusbandAndWife |
AMarriedMan | AMarriedMan |
AMarriedPerson | AMarriedPerson |
AMarriedWoman | AMarriedWoman |
AnUnmarriedMan | AnUnmarriedMan |
AnUnmarriedPerson | AnUnmarriedPerson |
AnUnmarriedWoman | AnUnmarriedWoman |
ASingleMan | ASingleMan |
ASinglePerson | ASinglePerson |
ASingleWoman | ASingleWoman |
AWidow | AWidow |
AWidower | AWidower |
AWifeAndHusband | AWifeAndHusband |
HerHusband | HerHusband |
HisWife | HisWife |
NotApplicable | NotApplicable |
Other | Other |
BorrowerRelationshipTitleType Bound Attachments |
Name | Current Value |
BorrowerRelationshipTitleType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
BorrowerRelationshipTitleType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerRelationshipTitleType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerRelationshipTitleType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerRelationshipTitleType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerRelationshipTitleTypeOtherDescription |
Base Entity | BORROWER_DETAIL |
Attribute Name | BorrowerRelationshipTitleTypeOtherDescription |
Logical Rolename | |
ColumnName | BorrowerRelationshipTitleTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | When Other is specified in Borrower Relationship Title Type, this element contains the description. |
Note |
BorrowerRelationshipTitleTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | BorrowerRelationshipTitleTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
BorrowerRelationshipTitleTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
BorrowerRelationshipTitleTypeOtherDescription Bound Attachments |
Name | Current Value |
BorrowerRelationshipTitleTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
BorrowerRelationshipTitleTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerRelationshipTitleTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerRelationshipTitleTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerRelationshipTitleTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerSameAsBuilderIndicator |
Base Entity | BORROWER_DETAIL |
Attribute Name | BorrowerSameAsBuilderIndicator |
Logical Rolename | |
ColumnName | BorrowerSameAsBuilderIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | When true, indicates that the Borrower is also the Builder on the loan transaction. |
Note |
BorrowerSameAsBuilderIndicator Logical Attribute Properties |
Logical Attribute Name | BorrowerSameAsBuilderIndicator |
Datatype | BIT |
Nullable | NO |
BorrowerSameAsBuilderIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
BorrowerSameAsBuilderIndicator Bound Attachments |
Name | Current Value |
BorrowerSameAsBuilderIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
BorrowerSameAsBuilderIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerSameAsBuilderIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerSameAsBuilderIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerSameAsBuilderIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerTotalMortgagedPropertiesCount |
Base Entity | BORROWER_DETAIL |
Attribute Name | BorrowerTotalMortgagedPropertiesCount |
Logical Rolename | |
ColumnName | BorrowerTotalMortgagedPropertiesCount |
RoleName | |
Domain | MISMOCount |
Definition | The number of 1-4 unit properties that are financed and owned and/or obligated on by an individual borrower. |
Note |
BorrowerTotalMortgagedPropertiesCount Logical Attribute Properties |
Logical Attribute Name | BorrowerTotalMortgagedPropertiesCount |
Datatype | INTEGER |
Nullable | NO |
BorrowerTotalMortgagedPropertiesCount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
BorrowerTotalMortgagedPropertiesCount Bound Attachments |
Name | Current Value |
BorrowerTotalMortgagedPropertiesCount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
BorrowerTotalMortgagedPropertiesCount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerTotalMortgagedPropertiesCount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerTotalMortgagedPropertiesCount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerTotalMortgagedPropertiesCount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CreditFileBorrowerAgeYearsCount |
Base Entity | BORROWER_DETAIL |
Attribute Name | CreditFileBorrowerAgeYearsCount |
Logical Rolename | |
ColumnName | CreditFileBorrowerAgeYearsCount |
RoleName | |
Domain | MISMOCount |
Definition | The age of the borrower reported in the credit file returned from the repository bureau. The age is sometimes reported in lieu of the date of birth. |
Note |
CreditFileBorrowerAgeYearsCount Logical Attribute Properties |
Logical Attribute Name | CreditFileBorrowerAgeYearsCount |
Datatype | INTEGER |
Nullable | NO |
CreditFileBorrowerAgeYearsCount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CreditFileBorrowerAgeYearsCount Bound Attachments |
Name | Current Value |
CreditFileBorrowerAgeYearsCount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
CreditFileBorrowerAgeYearsCount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CreditFileBorrowerAgeYearsCount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CreditFileBorrowerAgeYearsCount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CreditFileBorrowerAgeYearsCount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CreditReportAuthorizationIndicator |
Base Entity | BORROWER_DETAIL |
Attribute Name | CreditReportAuthorizationIndicator |
Logical Rolename | |
ColumnName | CreditReportAuthorizationIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates that the borrower gave the lender consent to pull credit report. |
Note |
CreditReportAuthorizationIndicator Logical Attribute Properties |
Logical Attribute Name | CreditReportAuthorizationIndicator |
Datatype | BIT |
Nullable | NO |
CreditReportAuthorizationIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CreditReportAuthorizationIndicator Bound Attachments |
Name | Current Value |
CreditReportAuthorizationIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
CreditReportAuthorizationIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CreditReportAuthorizationIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CreditReportAuthorizationIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CreditReportAuthorizationIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CreditReportIdentifier |
Base Entity | BORROWER_DETAIL |
Attribute Name | CreditReportIdentifier |
Logical Rolename | |
ColumnName | CreditReportIdentifier |
RoleName | |
Domain | MISMOIdentifier |
Definition | A reference number assigned by the credit bureau to a specific credit report. This report number is also referenced when a Reissue, Upgrade, or Status Query of an existing report is requested. |
Note |
CreditReportIdentifier Logical Attribute Properties |
Logical Attribute Name | CreditReportIdentifier |
Datatype | VARCHAR(0) |
Nullable | NO |
CreditReportIdentifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CreditReportIdentifier Bound Attachments |
Name | Current Value |
CreditReportIdentifier User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
CreditReportIdentifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CreditReportIdentifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CreditReportIdentifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CreditReportIdentifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
DependentCount |
Base Entity | BORROWER_DETAIL |
Attribute Name | DependentCount |
Logical Rolename | |
ColumnName | DependentCount |
RoleName | |
Domain | MISMOCount |
Definition | The number of dependents disclosed by the borrower. Collected on the URLA in Section III (Dependents No.). |
Note |
DependentCount Logical Attribute Properties |
Logical Attribute Name | DependentCount |
Datatype | INTEGER |
Nullable | NO |
DependentCount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
DependentCount Bound Attachments |
Name | Current Value |
DependentCount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
DependentCount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DependentCount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DependentCount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DependentCount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
JointAssetLiabilityReportingType |
Base Entity | BORROWER_DETAIL |
Attribute Name | JointAssetLiabilityReportingType |
Logical Rolename | |
ColumnName | JointAssetLiabilityReportingType |
RoleName | |
Domain | JointAssetLiabilityReportingEnum |
Definition | A statement made by two borrowers on a single loan application indicating whether their reporting of assets and liabilities is being completed jointly or not jointly. Collected on the URLA in Section VI (Completed Jointly / Not Jointly - Check Box). |
Note |
JointAssetLiabilityReportingType Logical Attribute Properties |
Logical Attribute Name | JointAssetLiabilityReportingType |
Datatype | VARCHAR(0) |
Nullable | YES |
JointAssetLiabilityReportingType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
JointAssetLiabilityReportingType Reference Value (Bound to Domain) |
Name | ValidationRule241 |
Description | |
Type | By List |
Value | Value Description |
Jointly | The income or assets of a person other than the borrower (including the spouse of the borrower ) will be used as a basis for loan qualification. |
NotJointly | Assets and liabilities are sufficiently separate and are being reported as such for the co-borrowers. |
JointAssetLiabilityReportingType Bound Attachments |
Name | Current Value |
JointAssetLiabilityReportingType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
JointAssetLiabilityReportingType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
JointAssetLiabilityReportingType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
JointAssetLiabilityReportingType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
JointAssetLiabilityReportingType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MaritalStatusType |
Base Entity | BORROWER_DETAIL |
Attribute Name | MaritalStatusType |
Logical Rolename | |
ColumnName | MaritalStatusType |
RoleName | |
Domain | MaritalStatusEnum |
Definition | The marital status of the party as disclosed by the party. |
Note |
MaritalStatusType Logical Attribute Properties |
Logical Attribute Name | MaritalStatusType |
Datatype | VARCHAR(0) |
Nullable | YES |
MaritalStatusType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MaritalStatusType Reference Value (Bound to Domain) |
Name | ValidationRule307 |
Description | |
Type | By List |
Value | Value Description |
Married | Married |
NotProvided | NotProvided |
Separated | Separated |
Unknown | Unknown |
Unmarried | Single, divorced, or widowed |
MaritalStatusType Bound Attachments |
Name | Current Value |
MaritalStatusType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MaritalStatusType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MaritalStatusType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MaritalStatusType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MaritalStatusType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SchoolingYearsCount |
Base Entity | BORROWER_DETAIL |
Attribute Name | SchoolingYearsCount |
Logical Rolename | |
ColumnName | SchoolingYearsCount |
RoleName | |
Domain | MISMOCount |
Definition | The number of years the borrower has attended school. Collected on the URLA in Section III (Yrs. School). |
Note |
SchoolingYearsCount Logical Attribute Properties |
Logical Attribute Name | SchoolingYearsCount |
Datatype | INTEGER |
Nullable | NO |
SchoolingYearsCount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SchoolingYearsCount Bound Attachments |
Name | Current Value |
SchoolingYearsCount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
SchoolingYearsCount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SchoolingYearsCount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SchoolingYearsCount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SchoolingYearsCount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SignedAuthorizationToRequestTaxRecordsIndicator |
Base Entity | BORROWER_DETAIL |
Attribute Name | SignedAuthorizationToRequestTaxRecordsIndicator |
Logical Rolename | |
ColumnName | SignedAuthorizationToRequestTaxRecordsIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates that the IRS form (4506 or 4506T) that gives the lender the authority to request copies of tax records is present. |
Note |
SignedAuthorizationToRequestTaxRecordsIndicator Logical Attribute Properties |
Logical Attribute Name | SignedAuthorizationToRequestTaxRecordsIndicator |
Datatype | BIT |
Nullable | NO |
SignedAuthorizationToRequestTaxRecordsIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SignedAuthorizationToRequestTaxRecordsIndicator Bound Attachments |
Name | Current Value |
SignedAuthorizationToRequestTaxRecordsIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
SignedAuthorizationToRequestTaxRecordsIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SignedAuthorizationToRequestTaxRecordsIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SignedAuthorizationToRequestTaxRecordsIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SignedAuthorizationToRequestTaxRecordsIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SSNCertificationIndicator |
Base Entity | BORROWER_DETAIL |
Attribute Name | SSNCertificationIndicator |
Logical Rolename | |
ColumnName | SSNCertificationIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates whether the Social Security # has been certified. |
Note |
SSNCertificationIndicator Logical Attribute Properties |
Logical Attribute Name | SSNCertificationIndicator |
Datatype | BIT |
Nullable | NO |
SSNCertificationIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SSNCertificationIndicator Bound Attachments |
Name | Current Value |
SSNCertificationIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
SSNCertificationIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SSNCertificationIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SSNCertificationIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SSNCertificationIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TaxRecordsObtainedIndicator |
Base Entity | BORROWER_DETAIL |
Attribute Name | TaxRecordsObtainedIndicator |
Logical Rolename | |
ColumnName | TaxRecordsObtainedIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates that the IRS form (4506 or 4506T) that gives the lender the authority to request copies of tax records has been executed by the lender. |
Note |
TaxRecordsObtainedIndicator Logical Attribute Properties |
Logical Attribute Name | TaxRecordsObtainedIndicator |
Datatype | BIT |
Nullable | NO |
TaxRecordsObtainedIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TaxRecordsObtainedIndicator Bound Attachments |
Name | Current Value |
TaxRecordsObtainedIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
TaxRecordsObtainedIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TaxRecordsObtainedIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TaxRecordsObtainedIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TaxRecordsObtainedIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |