| Attribute/Logical Rolename |
Domain |
Datatype |
NULL |
Definition |
| AgencyProgramDescription |
MISMOString |
VARCHAR(0) |
NO |
Describes the federal, state, or local agency program under which the loan is originated. |
| BorrowerFinancedFHADiscountPointsAmount |
MISMOAmount |
DECIMAL(0, 2) |
NO |
The dollar amount of discount points allowable by the applicable FHA guidelines to be financed on a FHA no cash out refinance. Used for FHA loans. Note: Discount points financed and not financed by borrower are equal to the Discount Points Total Amount Pa |
| BorrowerFundingFeePercent |
MISMOPercent |
DECIMAL(0, 2) |
NO |
The funding fee percentage due from the borrower. The fee is entered as a percentage. |
| BorrowerHomeInspectionChosenIndicator |
MISMOIndicator |
BIT |
NO |
When true indicates that borrower(s) have chosen to have a home inspection performed. |
| BorrowerPaidFHA_VAClosingCostsAmount |
MISMOAmount |
DECIMAL(0, 2) |
NO |
The estimated dollar amount of closing costs that will be paid by the borrower on the subject property excluding discount points and prepaid items. Used for FHA and VA loans. |
| BorrowerPaidFHA_VAClosingCostsPercent |
MISMOPercent |
DECIMAL(0, 2) |
NO |
The percentage of the estimated closing costs that will be paid by the borrower on the subject property excluding discount points and prepaids. |
| DaysToFHA_MIEligibilityCount |
MISMOCount |
INTEGER |
NO |
Specifies the number of days in which the borrower will be determined to be eligible for insurance under the National Housing Act. |
| FHA_MIPremiumRefundAmount |
MISMOAmount |
DECIMAL(0, 2) |
NO |
For refinance loans, the amount of the MIP that will be refunded to the borrower. |
| FHAAlimonyLiabilityTreatmentType |
FHAAlimonyLiabilityTreatmentEnum |
VARCHAR(0) |
YES |
Identifies how the borrower or lender prefers that the judgment process treat alimony in an FHA transaction.
|
| FHAAnniversaryDate |
MISMODate |
DATE |
NO |
Date the next premium change will be effective (YYYY-MM) for an FHA insured loan. |
| FHAAssignmentDate |
MISMODate |
DATE |
NO |
The date the lender registers the loan through FHA connection. (This date can impact the upfront and renewal MI rates for FHA Loans.) |
| FHACoverageRenewalRatePercent |
MISMOPercent |
DECIMAL(0, 2) |
NO |
Indicates the percentage of the renewal mortgage insurance premiums for FHA loans. |
| FHAEndorsementDate |
MISMODate |
DATE |
NO |
The date of the FHA mortgage insurance certificate endorsement |
| FHAEnergyRelatedRepairsOrImprovementsAmount |
MISMOAmount |
DECIMAL(0, 2) |
NO |
Dollar amount considered for energy related items. |
| FHAGeneralServicesAdministrationIdentifier |
MISMOIdentifier |
VARCHAR(0) |
NO |
The General Services Administrations (GSA) identifier from the List of Parties Excluded from Federal Procurement or Nonprocurement Programs. This is documented on the HUD-92900-WS. |
| FHAInsuranceProgramType |
FHAInsuranceProgramEnum |
VARCHAR(0) |
YES |
Type of FHA mortage protection insurance program.
|
| FHALimitedDenialParticipationIdentifier |
MISMOIdentifier |
VARCHAR(0) |
NO |
Identifier obtained from review of HUDs Limited Denial of Participation (LDP). This identifier is placed on the HUD-92900-WS. |
| FHALoanLenderIdentifier |
MISMOIdentifier |
VARCHAR(0) |
NO |
An FHA-assigned identifier of the originator making an underwriting request using the FHA Total Scorecard program. |
| FHALoanSponsorIdentifier |
MISMOIdentifier |
VARCHAR(0) |
NO |
An FHA-assigned identifier of the lender acting as an approved sponsor for the originator making the underwriting request using the FHA Total Scorecard program. |
| FHANonOwnerOccupancyRiderRule248Indicator |
MISMOIndicator |
BIT |
NO |
On the FHA Non Owner Occupancy Rider, this indicates that the Borrower is an Indian Tribe as provided in Section 248 of the National Housing Act or a serviceperson who is unable to occupy the Property because of his or her duty assignment as provided in S |
| FHAPendingPremiumAmount |
MISMOAmount |
DECIMAL(0, 2) |
NO |
New FHA premium payment amount. |
| FHAPendingPremiumChangeDate |
MISMODate |
DATE |
NO |
Effective date of pending premium amount for an FHA insured loan. |
| FHAPremiumAnniversaryYearToDateRemittanceAmount |
MISMOAmount |
DECIMAL(0, 2) |
NO |
The amount of FHA Mortgage Insurance Premium (MIP) paid in current anniversary year. |
| FHARefinanceInterestOnExistingLienAmount |
MISMOAmount |
DECIMAL(0, 2) |
NO |
Dollar amount of interest on existing lien, for FHA refinance |
| FHARefinanceOriginalExistingFHACaseIdentifier |
MISMOIdentifier |
VARCHAR(0) |
NO |
Original FHA Case Number for refinance |
| FHARefinanceOriginalExistingUpfrontMIPremiumAmount |
MISMOAmount |
DECIMAL(0, 2) |
NO |
Amount paid for Original Upfront MIP for refinance loan |
| FHAUnderwriterComputerizedHomesUnderwritingSystemIdentifier |
MISMOIdentifier |
VARCHAR(0) |
NO |
The FHA assigned number that identifies the Direct Endorsement underwriter authorized to approve the loan on behalf of the FHA. (Frequently referred to as the CHUMS ID.) |
| FHAUpfrontPremiumAmount |
MISMOAmount |
DECIMAL(0, 2) |
NO |
Amount of FHA mortgage insurance paid at closing |
| FHAUpfrontPremiumPercent |
MISMOPercent |
DECIMAL(0, 2) |
NO |
The percentage of upfront MIP, used for FHA loans. |
| GovernmentLoanApplicationType |
GovernmentLoanApplicationEnum |
VARCHAR(0) |
YES |
Specifies the type of government loan application. This information is referenced on VA forms 26-1802a and 26-1820, for example.
|
| GovernmentMortgageCreditCertificateAmount |
MISMOAmount |
DECIMAL(0, 2) |
NO |
The dollar amount of the Mortgage Credit Certificate. This is entered as a whole number. It is an annual tax credit. FHA allows it to be treated as monthly income. May also be used for VA loans. |
| GovernmentRefinanceType |
GovernmentRefinanceEnum |
VARCHAR(0) |
YES |
Indicates the amount of documentation for FHA/VA no cash out refinance loans.
|
| GovernmentRefinanceTypeOtherDescription |
MISMOString |
VARCHAR(0) |
NO |
A free form text field used to collect additional information when Other is selected for Government Refinance Type. |
| HUDAdequateAvailableAssetsIndicator |
MISMOIndicator |
BIT |
NO |
Indicates that borrower has adequate available assets for HUD approval |
| HUDAdequateEffectiveIncomeIndicator |
MISMOIndicator |
BIT |
NO |
Indicates borrower effective income is adequate for HUD approval |
| HUDCreditCharacteristicsIndicator |
MISMOIndicator |
BIT |
NO |
Indicates borrower meets credit characteristics for HUD approval |
| HUDStableEffectiveIncomeIndicator |
MISMOIndicator |
BIT |
NO |
Indicates borrowers stable effective income meets HUD approval |
| MasterCertificateOfReasonableValueIdentifier |
MISMOIdentifier |
VARCHAR(0) |
NO |
Identifier for the MCRV associated with the property. |
| OtherPartyPaidFHA_VAClosingCostsAmount |
MISMOAmount |
DECIMAL(0, 2) |
NO |
The estimated closing costs which will be paid by a party, other than the borrower or seller, on the subject property. Used for FHA or VA loans. |
| OtherPartyPaidFHA_VAClosingCostsPercent |
MISMOPercent |
DECIMAL(0, 2) |
NO |
The percentage of estimated closing costs that will be paid by any party other than the borrower or seller including any seller paid prepaids but excluding discount points. |
| PreviousVAHomeLoanIndicator |
MISMOIndicator |
BIT |
NO |
When true, indicates the borrower has previously had a VA home loan. |
| PropertyEnergyEfficientHomeIndicator |
MISMOIndicator |
BIT |
NO |
Indicates that the appraiser states that the property meets FHA /VA Energy Efficient Home guidelines. Usually applies to new construction. |
| RuralHousingConditionalGuarantyExpirationDate |
MISMODate |
DATE |
NO |
For Rural Housing loans, the expiration date of the guaranty. |
| RuralHousingConditionalGuarantyInterestRatePercent |
MISMOPercent |
DECIMAL(0, 2) |
NO |
For Rural Housing loans, the interest rate included in the USDA guaranty. |
| SectionOfActType |
SectionOfActEnum |
VARCHAR(0) |
YES |
Identifies the section of the National Housing Act which defines underwriting guidelines for VA or FHA loan evaluations.
|
| SectionOfActTypeOtherDescription |
MISMOString |
VARCHAR(0) |
NO |
A free form text field used to collect additional information when Other is selected for Section of Act Type. |
| SellerPaidFHA_VAClosingCostsPercent |
MISMOPercent |
DECIMAL(0, 2) |
NO |
The percentage of estimated closing costs that will be paid by the seller of the subject property, including any seller prepaids, but excluding discount points. |
| SoldUnderHUDSingleFamilyPropertyDispositionProgramIndicator |
MISMOIndicator |
BIT |
NO |
|
| USDA198021RuralHousingAdjustedAnnualHouseholdIncomeAmount |
MISMOAmount |
DECIMAL(0, 2) |
NO |
The total annual income of all members of the household as defined by Rural Housing Program Guidelines. This amount can be found on USDA Form 1980-21, Line 7. FORM SPECIFIC FIELD |
| VAAppraisalType |
VAAppraisalEnum |
VARCHAR(0) |
YES |
Specifies the property appraisal type used, as appears on VA Loan Summary Sheet (VA 26-0286), for example.
|
| VAAppraisalTypeOtherDescription |
MISMOString |
VARCHAR(0) |
NO |
A free-form text field which contains the description of the type of VA appraisal when Other is selected as the VA Appraisal Type. |
| VABorrowerCoBorrowerMarriedIndicator |
MISMOIndicator |
BIT |
NO |
Indicates whether the co-borrower is married to the borrower. Used for VA loans only. |
| VAClaimFolderIdentifier |
MISMOIdentifier |
VARCHAR(0) |
NO |
Identification number of the associated VA claim folder. |
| VAEntitlementAmount |
MISMOAmount |
DECIMAL(0, 2) |
NO |
The dollar amount of guarantee by the VA available to the veteran borrower. |
| VAEntitlementIdentifier |
MISMOIdentifier |
VARCHAR(0) |
NO |
VA entitlement identifier from Certificate of Eligibility for VA Loan Summary Sheet. |
| VAFundingFeeExemptionType |
VAFundingFeeExemptionEnum |
VARCHAR(0) |
YES |
The Exemption Status given by the VA Administration (exemption from VA Funding Fees).
|
| VAFundingFeeExemptionTypeOtherDescription |
MISMOString |
VARCHAR(0) |
NO |
A free form text field used to collect additional information when Other is selected for VA Funding Fee Exemption Type. |
| VAHouseholdSizeCount |
MISMOCount |
INTEGER |
NO |
Size of household at the loan level as defined by the VA. The lender must meet VA requirements for determining the size of household. |
| VALoanProcedureType |
VALoanProcedureEnum |
VARCHAR(0) |
YES |
Specifies the procedure used to qualify the borrower(s).
|
| VALoanProcedureTypeOtherDescription |
MISMOString |
VARCHAR(0) |
NO |
A free-form text field which contains the description of the type of VA loan procedure when Other is selected as the VA Loan Procedure Type. |
| VALoanProgramType |
VALoanProgramEnum |
VARCHAR(0) |
YES |
Identifies the type of VA Loan Program established by Title 38 of the US Code.
|
| VALoanProgramTypeOtherDescription |
MISMOString |
VARCHAR(0) |
NO |
A free-form text field used to describe the VA Loan Program Type if Other is selected as the VA Loan Program Type. |
| VAMaintenanceExpenseMonthlyAmount |
MISMOAmount |
DECIMAL(0, 2) |
NO |
The estimated dollar amount of monthly maintenance expense used for VA loans. |
| VAReasonableValueImprovementsCompletionIndicator |
MISMOIndicator |
BIT |
NO |
When true, indicates that any improvements upon which the reasonable value of the property is predicated and which were not approved subsequent to completion by a compliance inspector designated by the Secretary have been completed properly. |
| VAResidualIncomeAmount |
MISMOAmount |
DECIMAL(0, 2) |
NO |
The dollar amount of the monthly balance of funds available for family support after meeting the borrowers shelter expenses, debts, and taxes as defined by the VA. |
| VAResidualIncomeGuidelineAmount |
MISMOAmount |
DECIMAL(0, 2) |
NO |
Dollar amount used as a guideline for assessing residual income. |
| VATitleVestingType |
VATitleVestingEnum |
VARCHAR(0) |
YES |
The VA specific vesting under which the property is, or will be, held.
|
| VATitleVestingTypeOtherDescription |
MISMOString |
VARCHAR(0) |
NO |
A free-form text field which contains the description of the type of VA title vesting when Other is selected as the VA Title Vesting Type. |
| VAUtilityExpenseMonthlyAmount |
MISMOAmount |
DECIMAL(0, 2) |
NO |
The estimated dollar amount of monthly utility expense used for VA loans. |