| CAIVRSIdentifier |
| Base Entity | GOVERNMENT_BORROWER |
| Attribute Name | CAIVRSIdentifier |
| Logical Rolename | |
| ColumnName | CAIVRSIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | An identifier assigned by HUDs Credit Alert Interactive Voice Response System, an interactive system used to check the applicants outstanding federal obligations. |
| Note |
| CAIVRSIdentifier Logical Attribute Properties |
| Logical Attribute Name | CAIVRSIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| CAIVRSIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CAIVRSIdentifier Bound Attachments |
| Name | Current Value |
| CAIVRSIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| CAIVRSIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CAIVRSIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CAIVRSIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CAIVRSIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationLeadPaintIndicator |
| Base Entity | GOVERNMENT_BORROWER |
| Attribute Name | FHABorrowerCertificationLeadPaintIndicator |
| Logical Rolename | |
| ColumnName | FHABorrowerCertificationLeadPaintIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Property built prior to 1978, Lead Paint Notice provided to borrower. FHA Borrower Certification, HUD-92900-A (HUD/VA Addendum to URLA), section 25(6) |
| Note |
| FHABorrowerCertificationLeadPaintIndicator Logical Attribute Properties |
| Logical Attribute Name | FHABorrowerCertificationLeadPaintIndicator |
| Datatype | BIT |
| Nullable | NO |
| FHABorrowerCertificationLeadPaintIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FHABorrowerCertificationLeadPaintIndicator Bound Attachments |
| Name | Current Value |
| FHABorrowerCertificationLeadPaintIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FHABorrowerCertificationLeadPaintIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationLeadPaintIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationLeadPaintIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationLeadPaintIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationOriginalMortgageAmount |
| Base Entity | GOVERNMENT_BORROWER |
| Attribute Name | FHABorrowerCertificationOriginalMortgageAmount |
| Logical Rolename | |
| ColumnName | FHABorrowerCertificationOriginalMortgageAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | Original mortgage amount of property that was sold with in the past 60 months secured by HUD/FHA mortgage. FHA Borrower Certification HUD92900-A (FHA/VA Addendum to URLA) value used in Section 22c: Original Mortgage Amount. |
| Note |
| FHABorrowerCertificationOriginalMortgageAmount Logical Attribute Properties |
| Logical Attribute Name | FHABorrowerCertificationOriginalMortgageAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| FHABorrowerCertificationOriginalMortgageAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FHABorrowerCertificationOriginalMortgageAmount Bound Attachments |
| Name | Current Value |
| FHABorrowerCertificationOriginalMortgageAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FHABorrowerCertificationOriginalMortgageAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationOriginalMortgageAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationOriginalMortgageAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationOriginalMortgageAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationOwnFourOrMoreDwellingsIndicator |
| Base Entity | GOVERNMENT_BORROWER |
| Attribute Name | FHABorrowerCertificationOwnFourOrMoreDwellingsIndicator |
| Logical Rolename | |
| ColumnName | FHABorrowerCertificationOwnFourOrMoreDwellingsIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Does borrower own four or more dwellings. FHA Borrower Certification, HUD-92900-A (HUD/VA Addendum to URLA), section 22f. |
| Note |
| FHABorrowerCertificationOwnFourOrMoreDwellingsIndicator Logical Attribute Properties |
| Logical Attribute Name | FHABorrowerCertificationOwnFourOrMoreDwellingsIndicator |
| Datatype | BIT |
| Nullable | NO |
| FHABorrowerCertificationOwnFourOrMoreDwellingsIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FHABorrowerCertificationOwnFourOrMoreDwellingsIndicator Bound Attachments |
| Name | Current Value |
| FHABorrowerCertificationOwnFourOrMoreDwellingsIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FHABorrowerCertificationOwnFourOrMoreDwellingsIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationOwnFourOrMoreDwellingsIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationOwnFourOrMoreDwellingsIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationOwnFourOrMoreDwellingsIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationOwnOtherPropertyIndicator |
| Base Entity | GOVERNMENT_BORROWER |
| Attribute Name | FHABorrowerCertificationOwnOtherPropertyIndicator |
| Logical Rolename | |
| ColumnName | FHABorrowerCertificationOwnOtherPropertyIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Do you own or have you sold other real estate within the past 60 months on which there was a HUD/FHA mortgage? FHA Borrower Certification, HUD-92900-A, (HUD/VA Addendum to URLA) Section 22a: |
| Note |
| FHABorrowerCertificationOwnOtherPropertyIndicator Logical Attribute Properties |
| Logical Attribute Name | FHABorrowerCertificationOwnOtherPropertyIndicator |
| Datatype | BIT |
| Nullable | NO |
| FHABorrowerCertificationOwnOtherPropertyIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FHABorrowerCertificationOwnOtherPropertyIndicator Bound Attachments |
| Name | Current Value |
| FHABorrowerCertificationOwnOtherPropertyIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FHABorrowerCertificationOwnOtherPropertyIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationOwnOtherPropertyIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationOwnOtherPropertyIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationOwnOtherPropertyIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationPropertySoldCityName |
| Base Entity | GOVERNMENT_BORROWER |
| Attribute Name | FHABorrowerCertificationPropertySoldCityName |
| Logical Rolename | |
| ColumnName | FHABorrowerCertificationPropertySoldCityName |
| RoleName | |
| Domain | MISMOString |
| Definition | City of property sold in the past 60 months on which there was a HUD/FHA mortgage. FHA Borrower Certification, HUD-92900-A (HUD/VA Addendum to URLA), section 22d |
| Note |
| FHABorrowerCertificationPropertySoldCityName Logical Attribute Properties |
| Logical Attribute Name | FHABorrowerCertificationPropertySoldCityName |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| FHABorrowerCertificationPropertySoldCityName Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FHABorrowerCertificationPropertySoldCityName Bound Attachments |
| Name | Current Value |
| FHABorrowerCertificationPropertySoldCityName User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FHABorrowerCertificationPropertySoldCityName Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationPropertySoldCityName Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationPropertySoldCityName Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationPropertySoldCityName Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationPropertySoldPostalCode |
| Base Entity | GOVERNMENT_BORROWER |
| Attribute Name | FHABorrowerCertificationPropertySoldPostalCode |
| Logical Rolename | |
| ColumnName | FHABorrowerCertificationPropertySoldPostalCode |
| RoleName | |
| Domain | MISMOCode |
| Definition | Postal Code of property sold in the past 60 months on which there was a HUD/FHA mortgage. FHA Borrower Certification, HUD-92900-A (HUD/VA Addendum to URLA), section 22d |
| Note |
| FHABorrowerCertificationPropertySoldPostalCode Logical Attribute Properties |
| Logical Attribute Name | FHABorrowerCertificationPropertySoldPostalCode |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| FHABorrowerCertificationPropertySoldPostalCode Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FHABorrowerCertificationPropertySoldPostalCode Bound Attachments |
| Name | Current Value |
| FHABorrowerCertificationPropertySoldPostalCode User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FHABorrowerCertificationPropertySoldPostalCode Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationPropertySoldPostalCode Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationPropertySoldPostalCode Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationPropertySoldPostalCode Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationPropertySoldStateName |
| Base Entity | GOVERNMENT_BORROWER |
| Attribute Name | FHABorrowerCertificationPropertySoldStateName |
| Logical Rolename | |
| ColumnName | FHABorrowerCertificationPropertySoldStateName |
| RoleName | |
| Domain | MISMOString |
| Definition | State of property sold in the past 60 months on which there was a HUD/FHA mortgage. FHA Borrower Certification, HUD-92900-A (HUD/VA Addendum to URLA), section 22d |
| Note |
| FHABorrowerCertificationPropertySoldStateName Logical Attribute Properties |
| Logical Attribute Name | FHABorrowerCertificationPropertySoldStateName |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| FHABorrowerCertificationPropertySoldStateName Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FHABorrowerCertificationPropertySoldStateName Bound Attachments |
| Name | Current Value |
| FHABorrowerCertificationPropertySoldStateName User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FHABorrowerCertificationPropertySoldStateName Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationPropertySoldStateName Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationPropertySoldStateName Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationPropertySoldStateName Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationPropertySoldStreetAddressLineText |
| Base Entity | GOVERNMENT_BORROWER |
| Attribute Name | FHABorrowerCertificationPropertySoldStreetAddressLineText |
| Logical Rolename | |
| ColumnName | FHABorrowerCertificationPropertySoldStreetAddressLineText |
| RoleName | |
| Domain | MISMOString |
| Definition | Street address of property sold in the past 60 months on which there was a HUD/FHA mortgage. FHA Borrower Certification, HUD-92900-A (HUD/VA Addendum to URLA), section 22d |
| Note |
| FHABorrowerCertificationPropertySoldStreetAddressLineText Logical Attribute Properties |
| Logical Attribute Name | FHABorrowerCertificationPropertySoldStreetAddressLineText |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| FHABorrowerCertificationPropertySoldStreetAddressLineText Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FHABorrowerCertificationPropertySoldStreetAddressLineText Bound Attachments |
| Name | Current Value |
| FHABorrowerCertificationPropertySoldStreetAddressLineText User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FHABorrowerCertificationPropertySoldStreetAddressLineText Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationPropertySoldStreetAddressLineText Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationPropertySoldStreetAddressLineText Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationPropertySoldStreetAddressLineText Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationPropertyToBeSoldIndicator |
| Base Entity | GOVERNMENT_BORROWER |
| Attribute Name | FHABorrowerCertificationPropertyToBeSoldIndicator |
| Logical Rolename | |
| ColumnName | FHABorrowerCertificationPropertyToBeSoldIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | If owned property within the past 60 months that was secured by a HUD/FHA mortgage, is it to be sold? FHA Borrower Certification, HUD-92900-A, (HUD/VA Addendum to URLA) Section 22a: |
| Note |
| FHABorrowerCertificationPropertyToBeSoldIndicator Logical Attribute Properties |
| Logical Attribute Name | FHABorrowerCertificationPropertyToBeSoldIndicator |
| Datatype | BIT |
| Nullable | NO |
| FHABorrowerCertificationPropertyToBeSoldIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FHABorrowerCertificationPropertyToBeSoldIndicator Bound Attachments |
| Name | Current Value |
| FHABorrowerCertificationPropertyToBeSoldIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FHABorrowerCertificationPropertyToBeSoldIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationPropertyToBeSoldIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationPropertyToBeSoldIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationPropertyToBeSoldIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationRentalIndicator |
| Base Entity | GOVERNMENT_BORROWER |
| Attribute Name | FHABorrowerCertificationRentalIndicator |
| Logical Rolename | |
| ColumnName | FHABorrowerCertificationRentalIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Property covered by mortgage is to be rented, or is adjacent to rental properties involving eight or more dwelling units in which the borrower has a financial interest. FHA Borrower Certification, HUD-92900-A (HUD/VA Addendum to URLA), section 22e |
| Note |
| FHABorrowerCertificationRentalIndicator Logical Attribute Properties |
| Logical Attribute Name | FHABorrowerCertificationRentalIndicator |
| Datatype | BIT |
| Nullable | NO |
| FHABorrowerCertificationRentalIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FHABorrowerCertificationRentalIndicator Bound Attachments |
| Name | Current Value |
| FHABorrowerCertificationRentalIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FHABorrowerCertificationRentalIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationRentalIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationRentalIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationRentalIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationSalesPriceAmount |
| Base Entity | GOVERNMENT_BORROWER |
| Attribute Name | FHABorrowerCertificationSalesPriceAmount |
| Logical Rolename | |
| ColumnName | FHABorrowerCertificationSalesPriceAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | Sales price of property sold in the past 60 months that was secured by HUD/FHA mortgage. FHA Borrower Certification, HUD-92900-A, (HUD/VA Addendum to URLA) Section 22b: |
| Note |
| FHABorrowerCertificationSalesPriceAmount Logical Attribute Properties |
| Logical Attribute Name | FHABorrowerCertificationSalesPriceAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| FHABorrowerCertificationSalesPriceAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FHABorrowerCertificationSalesPriceAmount Bound Attachments |
| Name | Current Value |
| FHABorrowerCertificationSalesPriceAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FHABorrowerCertificationSalesPriceAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationSalesPriceAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationSalesPriceAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHABorrowerCertificationSalesPriceAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHA_VABorrowerCertificationSalesPriceExceedsAppraisedValueType |
| Base Entity | GOVERNMENT_BORROWER |
| Attribute Name | FHA_VABorrowerCertificationSalesPriceExceedsAppraisedValueType |
| Logical Rolename | |
| ColumnName | FHA_VABorrowerCertificationSalesPriceExceedsAppraisedValueType |
| RoleName | |
| Domain | FHA_VA_BorrowerCertificationSalesPriceExceedsAppraisedValueEnum |
| Definition | FHA/VA Borrower acknowledgement when Sales Price exceeds the Appraised Value. FHA/VA Borrower Certification, HUD-92900-A (HUD/VA Addendum to URLA), section 25(3) |
| Note |
| FHA_VABorrowerCertificationSalesPriceExceedsAppraisedValueType Logical Attribute Properties |
| Logical Attribute Name | FHA_VABorrowerCertificationSalesPriceExceedsAppraisedValueType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| FHA_VABorrowerCertificationSalesPriceExceedsAppraisedValueType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FHA_VABorrowerCertificationSalesPriceExceedsAppraisedValueType Reference Value (Bound to Domain) |
| Name | ValidationRule162 |
| Description | |
| Type | By List |
| Value | Value Description |
| A | I was aware of this valuation when I signed my contract and I have paid or will pay in cash from my own resources at or prior to loan closing a sum equal to the difference, between the contract purchase price or cost and the VA or HUD FHA established value. I do not and will not have outstanding after loan closing any unpaid contractual obligation on account of such cash payment. |
| B | I was not aware of this valuation when I signed my contract but have elected to complete the transaction at the contract purchase price or cost. I have paid or will pay in cash from my own resources at or prior to loan closing a sum equal to the difference between the contract purchase price or cost and the VA or HUD FHA established value. I do not and will not have outstanding after loan closing any unpaid contractual obligation on account of such cash payment. |
| FHA_VABorrowerCertificationSalesPriceExceedsAppraisedValueType Bound Attachments |
| Name | Current Value |
| FHA_VABorrowerCertificationSalesPriceExceedsAppraisedValueType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FHA_VABorrowerCertificationSalesPriceExceedsAppraisedValueType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHA_VABorrowerCertificationSalesPriceExceedsAppraisedValueType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHA_VABorrowerCertificationSalesPriceExceedsAppraisedValueType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FHA_VABorrowerCertificationSalesPriceExceedsAppraisedValueType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| VABorrowerCertificationOccupancyType |
| Base Entity | GOVERNMENT_BORROWER |
| Attribute Name | VABorrowerCertificationOccupancyType |
| Logical Rolename | |
| ColumnName | VABorrowerCertificationOccupancyType |
| RoleName | |
| Domain | VABorrowerCertificationOccupancyEnum |
| Definition | VA Borrower Certification type of occupancy. VA Borrower Certification, HUD-92900-A (HUD/VA Addendum to URLA), section 25(2) |
| Note |
| VABorrowerCertificationOccupancyType Logical Attribute Properties |
| Logical Attribute Name | VABorrowerCertificationOccupancyType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| VABorrowerCertificationOccupancyType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| VABorrowerCertificationOccupancyType Reference Value (Bound to Domain) |
| Name | ValidationRule486 |
| Description | |
| Type | By List |
| Value | Value Description |
| A | I now actually occupy the above described property as my home or intend to move into and occupy said property as my home within a reasonable period of time or intend to reoccupy it after the completion of major alterations, repairs or improvements |
| B | My spouse is on active military duty and in his or her absence, I occupy or intend to occupy the property securing this loan as my home |
| C | I previously occupied the property securing this loan as my home. (for interest rate reductions.) |
| D | While my spouse was on active military duty and unable to occupy the property securing this loan, I previously occupied the property that is securing this loan as my home. (for interest rate reduction loans) |
| VABorrowerCertificationOccupancyType Bound Attachments |
| Name | Current Value |
| VABorrowerCertificationOccupancyType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| VABorrowerCertificationOccupancyType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VABorrowerCertificationOccupancyType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VABorrowerCertificationOccupancyType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| VABorrowerCertificationOccupancyType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| VABorrowerSurvivingSpouseIndicator |
| Base Entity | GOVERNMENT_BORROWER |
| Attribute Name | VABorrowerSurvivingSpouseIndicator |
| Logical Rolename | |
| ColumnName | VABorrowerSurvivingSpouseIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | VA Borrower Surviving Spouse Indicator |
| Note |
| VABorrowerSurvivingSpouseIndicator Logical Attribute Properties |
| Logical Attribute Name | VABorrowerSurvivingSpouseIndicator |
| Datatype | BIT |
| Nullable | NO |
| VABorrowerSurvivingSpouseIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| VABorrowerSurvivingSpouseIndicator Bound Attachments |
| Name | Current Value |
| VABorrowerSurvivingSpouseIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| VABorrowerSurvivingSpouseIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VABorrowerSurvivingSpouseIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VABorrowerSurvivingSpouseIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| VABorrowerSurvivingSpouseIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| VACoBorrowerNonTaxableIncomeAmount |
| Base Entity | GOVERNMENT_BORROWER |
| Attribute Name | VACoBorrowerNonTaxableIncomeAmount |
| Logical Rolename | |
| ColumnName | VACoBorrowerNonTaxableIncomeAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The dollar amount of the monthly income that is not subject to taxation for a co-borrower. |
| Note |
| VACoBorrowerNonTaxableIncomeAmount Logical Attribute Properties |
| Logical Attribute Name | VACoBorrowerNonTaxableIncomeAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| VACoBorrowerNonTaxableIncomeAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| VACoBorrowerNonTaxableIncomeAmount Bound Attachments |
| Name | Current Value |
| VACoBorrowerNonTaxableIncomeAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| VACoBorrowerNonTaxableIncomeAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VACoBorrowerNonTaxableIncomeAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VACoBorrowerNonTaxableIncomeAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| VACoBorrowerNonTaxableIncomeAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| VACoBorrowerTaxableIncomeAmount |
| Base Entity | GOVERNMENT_BORROWER |
| Attribute Name | VACoBorrowerTaxableIncomeAmount |
| Logical Rolename | |
| ColumnName | VACoBorrowerTaxableIncomeAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The dollar amount of the monthly income that is subject to taxation for a co-borrower. |
| Note |
| VACoBorrowerTaxableIncomeAmount Logical Attribute Properties |
| Logical Attribute Name | VACoBorrowerTaxableIncomeAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| VACoBorrowerTaxableIncomeAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| VACoBorrowerTaxableIncomeAmount Bound Attachments |
| Name | Current Value |
| VACoBorrowerTaxableIncomeAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| VACoBorrowerTaxableIncomeAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VACoBorrowerTaxableIncomeAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VACoBorrowerTaxableIncomeAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| VACoBorrowerTaxableIncomeAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| VAFederalTaxAmount |
| Base Entity | GOVERNMENT_BORROWER |
| Attribute Name | VAFederalTaxAmount |
| Logical Rolename | |
| ColumnName | VAFederalTaxAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The monthly amount of federal income tax from the applicable table for VA loans. |
| Note |
| VAFederalTaxAmount Logical Attribute Properties |
| Logical Attribute Name | VAFederalTaxAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| VAFederalTaxAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| VAFederalTaxAmount Bound Attachments |
| Name | Current Value |
| VAFederalTaxAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| VAFederalTaxAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VAFederalTaxAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VAFederalTaxAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| VAFederalTaxAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| VALocalTaxAmount |
| Base Entity | GOVERNMENT_BORROWER |
| Attribute Name | VALocalTaxAmount |
| Logical Rolename | |
| ColumnName | VALocalTaxAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The monthly amount of income tax other than that paid to state or federal governments from the applicable table for VA loans. |
| Note |
| VALocalTaxAmount Logical Attribute Properties |
| Logical Attribute Name | VALocalTaxAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| VALocalTaxAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| VALocalTaxAmount Bound Attachments |
| Name | Current Value |
| VALocalTaxAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| VALocalTaxAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VALocalTaxAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VALocalTaxAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| VALocalTaxAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| VAPrimaryBorrowerNonTaxableIncomeAmount |
| Base Entity | GOVERNMENT_BORROWER |
| Attribute Name | VAPrimaryBorrowerNonTaxableIncomeAmount |
| Logical Rolename | |
| ColumnName | VAPrimaryBorrowerNonTaxableIncomeAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The dollar amount of the monthly income that is not subject to taxation of the primary borrower. |
| Note |
| VAPrimaryBorrowerNonTaxableIncomeAmount Logical Attribute Properties |
| Logical Attribute Name | VAPrimaryBorrowerNonTaxableIncomeAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| VAPrimaryBorrowerNonTaxableIncomeAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| VAPrimaryBorrowerNonTaxableIncomeAmount Bound Attachments |
| Name | Current Value |
| VAPrimaryBorrowerNonTaxableIncomeAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| VAPrimaryBorrowerNonTaxableIncomeAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VAPrimaryBorrowerNonTaxableIncomeAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VAPrimaryBorrowerNonTaxableIncomeAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| VAPrimaryBorrowerNonTaxableIncomeAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| VAPrimaryBorrowerTaxableIncomeAmount |
| Base Entity | GOVERNMENT_BORROWER |
| Attribute Name | VAPrimaryBorrowerTaxableIncomeAmount |
| Logical Rolename | |
| ColumnName | VAPrimaryBorrowerTaxableIncomeAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The dollar amount of monthly income of the borrower that is subject to taxation. |
| Note |
| VAPrimaryBorrowerTaxableIncomeAmount Logical Attribute Properties |
| Logical Attribute Name | VAPrimaryBorrowerTaxableIncomeAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| VAPrimaryBorrowerTaxableIncomeAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| VAPrimaryBorrowerTaxableIncomeAmount Bound Attachments |
| Name | Current Value |
| VAPrimaryBorrowerTaxableIncomeAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| VAPrimaryBorrowerTaxableIncomeAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VAPrimaryBorrowerTaxableIncomeAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VAPrimaryBorrowerTaxableIncomeAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| VAPrimaryBorrowerTaxableIncomeAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| VASocialSecurityTaxAmount |
| Base Entity | GOVERNMENT_BORROWER |
| Attribute Name | VASocialSecurityTaxAmount |
| Logical Rolename | |
| ColumnName | VASocialSecurityTaxAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The monthly amount of social security tax from the applicable table for VA loans. |
| Note |
| VASocialSecurityTaxAmount Logical Attribute Properties |
| Logical Attribute Name | VASocialSecurityTaxAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| VASocialSecurityTaxAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| VASocialSecurityTaxAmount Bound Attachments |
| Name | Current Value |
| VASocialSecurityTaxAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| VASocialSecurityTaxAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VASocialSecurityTaxAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VASocialSecurityTaxAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| VASocialSecurityTaxAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| VAStateTaxAmount |
| Base Entity | GOVERNMENT_BORROWER |
| Attribute Name | VAStateTaxAmount |
| Logical Rolename | |
| ColumnName | VAStateTaxAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The monthly amount of state income tax from the applicable table for VA loans. |
| Note |
| VAStateTaxAmount Logical Attribute Properties |
| Logical Attribute Name | VAStateTaxAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| VAStateTaxAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| VAStateTaxAmount Bound Attachments |
| Name | Current Value |
| VAStateTaxAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| VAStateTaxAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VAStateTaxAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VAStateTaxAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| VAStateTaxAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| VeteranStatusIndicator |
| Base Entity | GOVERNMENT_BORROWER |
| Attribute Name | VeteranStatusIndicator |
| Logical Rolename | |
| ColumnName | VeteranStatusIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates whether the borrower qualifies as a Veteran under HUD guidelines and that the loan application should be evaluated as a 203(b)(2) Veteran Loan. If any borrower qualifies as a Veteran under VA guidelines then the loan (including all borrowers) ma |
| Note |
| VeteranStatusIndicator Logical Attribute Properties |
| Logical Attribute Name | VeteranStatusIndicator |
| Datatype | BIT |
| Nullable | NO |
| VeteranStatusIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| VeteranStatusIndicator Bound Attachments |
| Name | Current Value |
| VeteranStatusIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| VeteranStatusIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VeteranStatusIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VeteranStatusIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| VeteranStatusIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |