AgencyProgramDescription 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  AgencyProgramDescription 
Logical Rolename   
ColumnName  AgencyProgramDescription 
RoleName   
Domain  MISMOString 
Definition  Describes the federal, state, or local agency program under which the loan is originated. 
Note 
 

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

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

AgencyProgramDescription Bound Attachments 
Name  Current Value 

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

AgencyProgramDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

AgencyProgramDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

AgencyProgramDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

AgencyProgramDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

BorrowerFinancedFHADiscountPointsAmount 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  BorrowerFinancedFHADiscountPointsAmount 
Logical Rolename   
ColumnName  BorrowerFinancedFHADiscountPointsAmount 
RoleName   
Domain  MISMOAmount 
Definition  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 
Note 
 

BorrowerFinancedFHADiscountPointsAmount Logical Attribute Properties 
Logical Attribute Name  BorrowerFinancedFHADiscountPointsAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

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

BorrowerFinancedFHADiscountPointsAmount Bound Attachments 
Name  Current Value 

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

BorrowerFinancedFHADiscountPointsAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

BorrowerFinancedFHADiscountPointsAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

BorrowerFinancedFHADiscountPointsAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

BorrowerFinancedFHADiscountPointsAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

BorrowerFundingFeePercent 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  BorrowerFundingFeePercent 
Logical Rolename   
ColumnName  BorrowerFundingFeePercent 
RoleName   
Domain  MISMOPercent 
Definition  The funding fee percentage due from the borrower. The fee is entered as a percentage. 
Note 
 

BorrowerFundingFeePercent Logical Attribute Properties 
Logical Attribute Name  BorrowerFundingFeePercent 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

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

BorrowerFundingFeePercent Bound Attachments 
Name  Current Value 

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

BorrowerFundingFeePercent Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

BorrowerFundingFeePercent Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

BorrowerFundingFeePercent Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

BorrowerFundingFeePercent Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

BorrowerHomeInspectionChosenIndicator 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  BorrowerHomeInspectionChosenIndicator 
Logical Rolename   
ColumnName  BorrowerHomeInspectionChosenIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  When true indicates that borrower(s) have chosen to have a home inspection performed. 
Note 
 

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

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

BorrowerHomeInspectionChosenIndicator Bound Attachments 
Name  Current Value 

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

BorrowerHomeInspectionChosenIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

BorrowerHomeInspectionChosenIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

BorrowerHomeInspectionChosenIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

BorrowerHomeInspectionChosenIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

BorrowerPaidFHA_VAClosingCostsAmount 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  BorrowerPaidFHA_VAClosingCostsAmount 
Logical Rolename   
ColumnName  BorrowerPaidFHA_VAClosingCostsAmount 
RoleName   
Domain  MISMOAmount 
Definition  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. 
Note 
 

BorrowerPaidFHA_VAClosingCostsAmount Logical Attribute Properties 
Logical Attribute Name  BorrowerPaidFHA_VAClosingCostsAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

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

BorrowerPaidFHA_VAClosingCostsAmount Bound Attachments 
Name  Current Value 

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

BorrowerPaidFHA_VAClosingCostsAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

BorrowerPaidFHA_VAClosingCostsAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

BorrowerPaidFHA_VAClosingCostsAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

BorrowerPaidFHA_VAClosingCostsAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

BorrowerPaidFHA_VAClosingCostsPercent 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  BorrowerPaidFHA_VAClosingCostsPercent 
Logical Rolename   
ColumnName  BorrowerPaidFHA_VAClosingCostsPercent 
RoleName   
Domain  MISMOPercent 
Definition  The percentage of the estimated closing costs that will be paid by the borrower on the subject property excluding discount points and prepaids. 
Note 
 

BorrowerPaidFHA_VAClosingCostsPercent Logical Attribute Properties 
Logical Attribute Name  BorrowerPaidFHA_VAClosingCostsPercent 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

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

BorrowerPaidFHA_VAClosingCostsPercent Bound Attachments 
Name  Current Value 

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

BorrowerPaidFHA_VAClosingCostsPercent Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

BorrowerPaidFHA_VAClosingCostsPercent Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

BorrowerPaidFHA_VAClosingCostsPercent Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

BorrowerPaidFHA_VAClosingCostsPercent Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

DaysToFHA_MIEligibilityCount 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  DaysToFHA_MIEligibilityCount 
Logical Rolename   
ColumnName  DaysToFHA_MIEligibilityCount 
RoleName   
Domain  MISMOCount 
Definition  Specifies the number of days in which the borrower will be determined to be eligible for insurance under the National Housing Act. 
Note 
 

DaysToFHA_MIEligibilityCount Logical Attribute Properties 
Logical Attribute Name  DaysToFHA_MIEligibilityCount 
Datatype  INTEGER 
Nullable  NO 

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

DaysToFHA_MIEligibilityCount Bound Attachments 
Name  Current Value 

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

DaysToFHA_MIEligibilityCount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

DaysToFHA_MIEligibilityCount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

DaysToFHA_MIEligibilityCount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

DaysToFHA_MIEligibilityCount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHA_MIPremiumRefundAmount 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  FHA_MIPremiumRefundAmount 
Logical Rolename   
ColumnName  FHA_MIPremiumRefundAmount 
RoleName   
Domain  MISMOAmount 
Definition  For refinance loans, the amount of the MIP that will be refunded to the borrower. 
Note 
 

FHA_MIPremiumRefundAmount Logical Attribute Properties 
Logical Attribute Name  FHA_MIPremiumRefundAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

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

FHA_MIPremiumRefundAmount Bound Attachments 
Name  Current Value 

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

FHA_MIPremiumRefundAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHA_MIPremiumRefundAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHA_MIPremiumRefundAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHA_MIPremiumRefundAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHAAlimonyLiabilityTreatmentType 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  FHAAlimonyLiabilityTreatmentType 
Logical Rolename   
ColumnName  FHAAlimonyLiabilityTreatmentType 
RoleName   
Domain  FHAAlimonyLiabilityTreatmentEnum 
Definition  Identifies how the borrower or lender prefers that the judgment process treat alimony in an FHA transaction.  
Note 
 

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

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

FHAAlimonyLiabilityTreatmentType Reference Value (Bound to Domain) 
Name  ValidationRule160 
Description   
Type  By List 
Value  Value Description 
AdditionToDebt  This means that the alimony is included in the aggregate of obligations. 
ReductionToIncome  This means that the income entered is to be reduced by the amount of alimony. 

FHAAlimonyLiabilityTreatmentType Bound Attachments 
Name  Current Value 

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

FHAAlimonyLiabilityTreatmentType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHAAlimonyLiabilityTreatmentType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHAAlimonyLiabilityTreatmentType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHAAlimonyLiabilityTreatmentType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHAAnniversaryDate 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  FHAAnniversaryDate 
Logical Rolename   
ColumnName  FHAAnniversaryDate 
RoleName   
Domain  MISMODate 
Definition  Date the next premium change will be effective (YYYY-MM) for an FHA insured loan. 
Note 
 

FHAAnniversaryDate Logical Attribute Properties 
Logical Attribute Name  FHAAnniversaryDate 
Datatype  DATE 
Nullable  NO 

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

FHAAnniversaryDate Bound Attachments 
Name  Current Value 

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

FHAAnniversaryDate Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHAAnniversaryDate Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHAAnniversaryDate Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHAAnniversaryDate Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHAAssignmentDate 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  FHAAssignmentDate 
Logical Rolename   
ColumnName  FHAAssignmentDate 
RoleName   
Domain  MISMODate 
Definition  The date the lender registers the loan through FHA connection. (This date can impact the upfront and renewal MI rates for FHA Loans.) 
Note 
 

FHAAssignmentDate Logical Attribute Properties 
Logical Attribute Name  FHAAssignmentDate 
Datatype  DATE 
Nullable  NO 

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

FHAAssignmentDate Bound Attachments 
Name  Current Value 

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

FHAAssignmentDate Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHAAssignmentDate Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHAAssignmentDate Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHAAssignmentDate Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHACoverageRenewalRatePercent 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  FHACoverageRenewalRatePercent 
Logical Rolename   
ColumnName  FHACoverageRenewalRatePercent 
RoleName   
Domain  MISMOPercent 
Definition  Indicates the percentage of the renewal mortgage insurance premiums for FHA loans. 
Note 
 

FHACoverageRenewalRatePercent Logical Attribute Properties 
Logical Attribute Name  FHACoverageRenewalRatePercent 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

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

FHACoverageRenewalRatePercent Bound Attachments 
Name  Current Value 

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

FHACoverageRenewalRatePercent Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHACoverageRenewalRatePercent Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHACoverageRenewalRatePercent Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHACoverageRenewalRatePercent Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHAEndorsementDate 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  FHAEndorsementDate 
Logical Rolename   
ColumnName  FHAEndorsementDate 
RoleName   
Domain  MISMODate 
Definition  The date of the FHA mortgage insurance certificate endorsement 
Note 
 

FHAEndorsementDate Logical Attribute Properties 
Logical Attribute Name  FHAEndorsementDate 
Datatype  DATE 
Nullable  NO 

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

FHAEndorsementDate Bound Attachments 
Name  Current Value 

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

FHAEndorsementDate Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHAEndorsementDate Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHAEndorsementDate Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHAEndorsementDate Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHAEnergyRelatedRepairsOrImprovementsAmount 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  FHAEnergyRelatedRepairsOrImprovementsAmount 
Logical Rolename   
ColumnName  FHAEnergyRelatedRepairsOrImprovementsAmount 
RoleName   
Domain  MISMOAmount 
Definition  Dollar amount considered for energy related items. 
Note 
 

FHAEnergyRelatedRepairsOrImprovementsAmount Logical Attribute Properties 
Logical Attribute Name  FHAEnergyRelatedRepairsOrImprovementsAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

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

FHAEnergyRelatedRepairsOrImprovementsAmount Bound Attachments 
Name  Current Value 

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

FHAEnergyRelatedRepairsOrImprovementsAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHAEnergyRelatedRepairsOrImprovementsAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHAEnergyRelatedRepairsOrImprovementsAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHAEnergyRelatedRepairsOrImprovementsAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHAGeneralServicesAdministrationIdentifier 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  FHAGeneralServicesAdministrationIdentifier 
Logical Rolename   
ColumnName  FHAGeneralServicesAdministrationIdentifier 
RoleName   
Domain  MISMOIdentifier 
Definition  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. 
Note 
 

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

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

FHAGeneralServicesAdministrationIdentifier Bound Attachments 
Name  Current Value 

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

FHAGeneralServicesAdministrationIdentifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHAGeneralServicesAdministrationIdentifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHAGeneralServicesAdministrationIdentifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHAGeneralServicesAdministrationIdentifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHAInsuranceProgramType 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  FHAInsuranceProgramType 
Logical Rolename   
ColumnName  FHAInsuranceProgramType 
RoleName   
Domain  FHAInsuranceProgramEnum 
Definition  Type of FHA mortage protection insurance program.  
Note 
 

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

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

FHAInsuranceProgramType Reference Value (Bound to Domain) 
Name  ValidationRule161 
Description   
Type  By List 
Value  Value Description 
FHAUpfront  FHAUpfront 
RBP  RBP 
Section530  Section530 

FHAInsuranceProgramType Bound Attachments 
Name  Current Value 

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

FHAInsuranceProgramType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHAInsuranceProgramType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHAInsuranceProgramType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHAInsuranceProgramType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHALimitedDenialParticipationIdentifier 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  FHALimitedDenialParticipationIdentifier 
Logical Rolename   
ColumnName  FHALimitedDenialParticipationIdentifier 
RoleName   
Domain  MISMOIdentifier 
Definition  Identifier obtained from review of HUDs Limited Denial of Participation (LDP). This identifier is placed on the HUD-92900-WS. 
Note 
 

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

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

FHALimitedDenialParticipationIdentifier Bound Attachments 
Name  Current Value 

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

FHALimitedDenialParticipationIdentifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHALimitedDenialParticipationIdentifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHALimitedDenialParticipationIdentifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHALimitedDenialParticipationIdentifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHALoanLenderIdentifier 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  FHALoanLenderIdentifier 
Logical Rolename   
ColumnName  FHALoanLenderIdentifier 
RoleName   
Domain  MISMOIdentifier 
Definition  An FHA-assigned identifier of the originator making an underwriting request using the FHA Total Scorecard program. 
Note 
 

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

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

FHALoanLenderIdentifier Bound Attachments 
Name  Current Value 

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

FHALoanLenderIdentifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHALoanLenderIdentifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHALoanLenderIdentifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHALoanLenderIdentifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHALoanSponsorIdentifier 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  FHALoanSponsorIdentifier 
Logical Rolename   
ColumnName  FHALoanSponsorIdentifier 
RoleName   
Domain  MISMOIdentifier 
Definition  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. 
Note 
 

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

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

FHALoanSponsorIdentifier Bound Attachments 
Name  Current Value 

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

FHALoanSponsorIdentifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHALoanSponsorIdentifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHALoanSponsorIdentifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHALoanSponsorIdentifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHANonOwnerOccupancyRiderRule248Indicator 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  FHANonOwnerOccupancyRiderRule248Indicator 
Logical Rolename   
ColumnName  FHANonOwnerOccupancyRiderRule248Indicator 
RoleName   
Domain  MISMOIndicator 
Definition  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 
Note 
 

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

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

FHANonOwnerOccupancyRiderRule248Indicator Bound Attachments 
Name  Current Value 

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

FHANonOwnerOccupancyRiderRule248Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHANonOwnerOccupancyRiderRule248Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHANonOwnerOccupancyRiderRule248Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHANonOwnerOccupancyRiderRule248Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHAPendingPremiumAmount 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  FHAPendingPremiumAmount 
Logical Rolename   
ColumnName  FHAPendingPremiumAmount 
RoleName   
Domain  MISMOAmount 
Definition  New FHA premium payment amount. 
Note 
 

FHAPendingPremiumAmount Logical Attribute Properties 
Logical Attribute Name  FHAPendingPremiumAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

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

FHAPendingPremiumAmount Bound Attachments 
Name  Current Value 

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

FHAPendingPremiumAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHAPendingPremiumAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHAPendingPremiumAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHAPendingPremiumAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHAPendingPremiumChangeDate 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  FHAPendingPremiumChangeDate 
Logical Rolename   
ColumnName  FHAPendingPremiumChangeDate 
RoleName   
Domain  MISMODate 
Definition  Effective date of pending premium amount for an FHA insured loan. 
Note 
 

FHAPendingPremiumChangeDate Logical Attribute Properties 
Logical Attribute Name  FHAPendingPremiumChangeDate 
Datatype  DATE 
Nullable  NO 

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

FHAPendingPremiumChangeDate Bound Attachments 
Name  Current Value 

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

FHAPendingPremiumChangeDate Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHAPendingPremiumChangeDate Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHAPendingPremiumChangeDate Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHAPendingPremiumChangeDate Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHAPremiumAnniversaryYearToDateRemittanceAmount 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  FHAPremiumAnniversaryYearToDateRemittanceAmount 
Logical Rolename   
ColumnName  FHAPremiumAnniversaryYearToDateRemittanceAmount 
RoleName   
Domain  MISMOAmount 
Definition  The amount of FHA Mortgage Insurance Premium (MIP) paid in current anniversary year. 
Note 
 

FHAPremiumAnniversaryYearToDateRemittanceAmount Logical Attribute Properties 
Logical Attribute Name  FHAPremiumAnniversaryYearToDateRemittanceAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

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

FHAPremiumAnniversaryYearToDateRemittanceAmount Bound Attachments 
Name  Current Value 

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

FHAPremiumAnniversaryYearToDateRemittanceAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHAPremiumAnniversaryYearToDateRemittanceAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHAPremiumAnniversaryYearToDateRemittanceAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHAPremiumAnniversaryYearToDateRemittanceAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHARefinanceInterestOnExistingLienAmount 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  FHARefinanceInterestOnExistingLienAmount 
Logical Rolename   
ColumnName  FHARefinanceInterestOnExistingLienAmount 
RoleName   
Domain  MISMOAmount 
Definition  Dollar amount of interest on existing lien, for FHA refinance 
Note 
 

FHARefinanceInterestOnExistingLienAmount Logical Attribute Properties 
Logical Attribute Name  FHARefinanceInterestOnExistingLienAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

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

FHARefinanceInterestOnExistingLienAmount Bound Attachments 
Name  Current Value 

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

FHARefinanceInterestOnExistingLienAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHARefinanceInterestOnExistingLienAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHARefinanceInterestOnExistingLienAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHARefinanceInterestOnExistingLienAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHARefinanceOriginalExistingFHACaseIdentifier 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  FHARefinanceOriginalExistingFHACaseIdentifier 
Logical Rolename   
ColumnName  FHARefinanceOriginalExistingFHACaseIdentifier 
RoleName   
Domain  MISMOIdentifier 
Definition  Original FHA Case Number for refinance 
Note 
 

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

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

FHARefinanceOriginalExistingFHACaseIdentifier Bound Attachments 
Name  Current Value 

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

FHARefinanceOriginalExistingFHACaseIdentifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHARefinanceOriginalExistingFHACaseIdentifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHARefinanceOriginalExistingFHACaseIdentifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHARefinanceOriginalExistingFHACaseIdentifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHARefinanceOriginalExistingUpfrontMIPremiumAmount 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  FHARefinanceOriginalExistingUpfrontMIPremiumAmount 
Logical Rolename   
ColumnName  FHARefinanceOriginalExistingUpfrontMIPremiumAmount 
RoleName   
Domain  MISMOAmount 
Definition  Amount paid for Original Upfront MIP for refinance loan 
Note 
 

FHARefinanceOriginalExistingUpfrontMIPremiumAmount Logical Attribute Properties 
Logical Attribute Name  FHARefinanceOriginalExistingUpfrontMIPremiumAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

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

FHARefinanceOriginalExistingUpfrontMIPremiumAmount Bound Attachments 
Name  Current Value 

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

FHARefinanceOriginalExistingUpfrontMIPremiumAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHARefinanceOriginalExistingUpfrontMIPremiumAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHARefinanceOriginalExistingUpfrontMIPremiumAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHARefinanceOriginalExistingUpfrontMIPremiumAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHAUnderwriterComputerizedHomesUnderwritingSystemIdentifier 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  FHAUnderwriterComputerizedHomesUnderwritingSystemIdentifier 
Logical Rolename   
ColumnName  FHAUnderwriterComputerizedHomesUnderwritingSystemIdentifier 
RoleName   
Domain  MISMOIdentifier 
Definition  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.) 
Note 
 

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

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

FHAUnderwriterComputerizedHomesUnderwritingSystemIdentifier Bound Attachments 
Name  Current Value 

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

FHAUnderwriterComputerizedHomesUnderwritingSystemIdentifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHAUnderwriterComputerizedHomesUnderwritingSystemIdentifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHAUnderwriterComputerizedHomesUnderwritingSystemIdentifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHAUnderwriterComputerizedHomesUnderwritingSystemIdentifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHAUpfrontPremiumAmount 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  FHAUpfrontPremiumAmount 
Logical Rolename   
ColumnName  FHAUpfrontPremiumAmount 
RoleName   
Domain  MISMOAmount 
Definition  Amount of FHA mortgage insurance paid at closing 
Note 
 

FHAUpfrontPremiumAmount Logical Attribute Properties 
Logical Attribute Name  FHAUpfrontPremiumAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

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

FHAUpfrontPremiumAmount Bound Attachments 
Name  Current Value 

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

FHAUpfrontPremiumAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHAUpfrontPremiumAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHAUpfrontPremiumAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHAUpfrontPremiumAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHAUpfrontPremiumPercent 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  FHAUpfrontPremiumPercent 
Logical Rolename   
ColumnName  FHAUpfrontPremiumPercent 
RoleName   
Domain  MISMOPercent 
Definition  The percentage of upfront MIP, used for FHA loans. 
Note 
 

FHAUpfrontPremiumPercent Logical Attribute Properties 
Logical Attribute Name  FHAUpfrontPremiumPercent 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

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

FHAUpfrontPremiumPercent Bound Attachments 
Name  Current Value 

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

FHAUpfrontPremiumPercent Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHAUpfrontPremiumPercent Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FHAUpfrontPremiumPercent Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FHAUpfrontPremiumPercent Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

GovernmentLoanApplicationType 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  GovernmentLoanApplicationType 
Logical Rolename   
ColumnName  GovernmentLoanApplicationType 
RoleName   
Domain  GovernmentLoanApplicationEnum 
Definition  Specifies the type of government loan application. This information is referenced on VA forms 26-1802a and 26-1820, for example.  
Note 
 

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

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

GovernmentLoanApplicationType Reference Value (Bound to Domain) 
Name  ValidationRule192 
Description   
Type  By List 
Value  Value Description 
HomeLoanGuaranty  HomeLoanGuaranty 
NationalHousingAct  NationalHousingAct 

GovernmentLoanApplicationType Bound Attachments 
Name  Current Value 

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

GovernmentLoanApplicationType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

GovernmentLoanApplicationType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

GovernmentLoanApplicationType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

GovernmentLoanApplicationType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

GovernmentMortgageCreditCertificateAmount 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  GovernmentMortgageCreditCertificateAmount 
Logical Rolename   
ColumnName  GovernmentMortgageCreditCertificateAmount 
RoleName   
Domain  MISMOAmount 
Definition  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. 
Note 
 

GovernmentMortgageCreditCertificateAmount Logical Attribute Properties 
Logical Attribute Name  GovernmentMortgageCreditCertificateAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

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

GovernmentMortgageCreditCertificateAmount Bound Attachments 
Name  Current Value 

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

GovernmentMortgageCreditCertificateAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

GovernmentMortgageCreditCertificateAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

GovernmentMortgageCreditCertificateAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

GovernmentMortgageCreditCertificateAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

GovernmentRefinanceType 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  GovernmentRefinanceType 
Logical Rolename   
ColumnName  GovernmentRefinanceType 
RoleName   
Domain  GovernmentRefinanceEnum 
Definition  Indicates the amount of documentation for FHA/VA no cash out refinance loans.  
Note 
 

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

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

GovernmentRefinanceType Reference Value (Bound to Domain) 
Name  ValidationRule193 
Description   
Type  By List 
Value  Value Description 
FullDocumentation  FullDocumentation 
InterestRateReductionRefinanceLoan  InterestRateReductionRefinanceLoan 
Other  Other 
StreamlineWithAppraisal  StreamlineWithAppraisal 
StreamlineWithoutAppraisal  StreamlineWithoutAppraisal 

GovernmentRefinanceType Bound Attachments 
Name  Current Value 

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

GovernmentRefinanceType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

GovernmentRefinanceType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

GovernmentRefinanceType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

GovernmentRefinanceType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

GovernmentRefinanceTypeOtherDescription 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  GovernmentRefinanceTypeOtherDescription 
Logical Rolename   
ColumnName  GovernmentRefinanceTypeOtherDescription 
RoleName   
Domain  MISMOString 
Definition  A free form text field used to collect additional information when Other is selected for Government Refinance Type. 
Note 
 

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

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

GovernmentRefinanceTypeOtherDescription Bound Attachments 
Name  Current Value 

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

GovernmentRefinanceTypeOtherDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

GovernmentRefinanceTypeOtherDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

GovernmentRefinanceTypeOtherDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

GovernmentRefinanceTypeOtherDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

HUDAdequateAvailableAssetsIndicator 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  HUDAdequateAvailableAssetsIndicator 
Logical Rolename   
ColumnName  HUDAdequateAvailableAssetsIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates that borrower has adequate available assets for HUD approval 
Note 
 

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

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

HUDAdequateAvailableAssetsIndicator Bound Attachments 
Name  Current Value 

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

HUDAdequateAvailableAssetsIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

HUDAdequateAvailableAssetsIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

HUDAdequateAvailableAssetsIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

HUDAdequateAvailableAssetsIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

HUDAdequateEffectiveIncomeIndicator 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  HUDAdequateEffectiveIncomeIndicator 
Logical Rolename   
ColumnName  HUDAdequateEffectiveIncomeIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates borrower effective income is adequate for HUD approval 
Note 
 

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

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

HUDAdequateEffectiveIncomeIndicator Bound Attachments 
Name  Current Value 

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

HUDAdequateEffectiveIncomeIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

HUDAdequateEffectiveIncomeIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

HUDAdequateEffectiveIncomeIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

HUDAdequateEffectiveIncomeIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

HUDCreditCharacteristicsIndicator 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  HUDCreditCharacteristicsIndicator 
Logical Rolename   
ColumnName  HUDCreditCharacteristicsIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates borrower meets credit characteristics for HUD approval 
Note 
 

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

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

HUDCreditCharacteristicsIndicator Bound Attachments 
Name  Current Value 

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

HUDCreditCharacteristicsIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

HUDCreditCharacteristicsIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

HUDCreditCharacteristicsIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

HUDCreditCharacteristicsIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

HUDStableEffectiveIncomeIndicator 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  HUDStableEffectiveIncomeIndicator 
Logical Rolename   
ColumnName  HUDStableEffectiveIncomeIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates borrowers stable effective income meets HUD approval 
Note 
 

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

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

HUDStableEffectiveIncomeIndicator Bound Attachments 
Name  Current Value 

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

HUDStableEffectiveIncomeIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

HUDStableEffectiveIncomeIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

HUDStableEffectiveIncomeIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

HUDStableEffectiveIncomeIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

MasterCertificateOfReasonableValueIdentifier 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  MasterCertificateOfReasonableValueIdentifier 
Logical Rolename   
ColumnName  MasterCertificateOfReasonableValueIdentifier 
RoleName   
Domain  MISMOIdentifier 
Definition  Identifier for the MCRV associated with the property. 
Note 
 

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

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

MasterCertificateOfReasonableValueIdentifier Bound Attachments 
Name  Current Value 

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

MasterCertificateOfReasonableValueIdentifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MasterCertificateOfReasonableValueIdentifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MasterCertificateOfReasonableValueIdentifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MasterCertificateOfReasonableValueIdentifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

OtherPartyPaidFHA_VAClosingCostsAmount 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  OtherPartyPaidFHA_VAClosingCostsAmount 
Logical Rolename   
ColumnName  OtherPartyPaidFHA_VAClosingCostsAmount 
RoleName   
Domain  MISMOAmount 
Definition  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. 
Note 
 

OtherPartyPaidFHA_VAClosingCostsAmount Logical Attribute Properties 
Logical Attribute Name  OtherPartyPaidFHA_VAClosingCostsAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

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

OtherPartyPaidFHA_VAClosingCostsAmount Bound Attachments 
Name  Current Value 

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

OtherPartyPaidFHA_VAClosingCostsAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

OtherPartyPaidFHA_VAClosingCostsAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

OtherPartyPaidFHA_VAClosingCostsAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

OtherPartyPaidFHA_VAClosingCostsAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

OtherPartyPaidFHA_VAClosingCostsPercent 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  OtherPartyPaidFHA_VAClosingCostsPercent 
Logical Rolename   
ColumnName  OtherPartyPaidFHA_VAClosingCostsPercent 
RoleName   
Domain  MISMOPercent 
Definition  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. 
Note 
 

OtherPartyPaidFHA_VAClosingCostsPercent Logical Attribute Properties 
Logical Attribute Name  OtherPartyPaidFHA_VAClosingCostsPercent 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

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

OtherPartyPaidFHA_VAClosingCostsPercent Bound Attachments 
Name  Current Value 

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

OtherPartyPaidFHA_VAClosingCostsPercent Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

OtherPartyPaidFHA_VAClosingCostsPercent Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

OtherPartyPaidFHA_VAClosingCostsPercent Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

OtherPartyPaidFHA_VAClosingCostsPercent Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

PreviousVAHomeLoanIndicator 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  PreviousVAHomeLoanIndicator 
Logical Rolename   
ColumnName  PreviousVAHomeLoanIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  When true, indicates the borrower has previously had a VA home loan. 
Note 
 

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

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

PreviousVAHomeLoanIndicator Bound Attachments 
Name  Current Value 

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

PreviousVAHomeLoanIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

PreviousVAHomeLoanIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

PreviousVAHomeLoanIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

PreviousVAHomeLoanIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

PropertyEnergyEfficientHomeIndicator 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  PropertyEnergyEfficientHomeIndicator 
Logical Rolename   
ColumnName  PropertyEnergyEfficientHomeIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates that the appraiser states that the property meets FHA /VA Energy Efficient Home guidelines. Usually applies to new construction. 
Note 
 

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

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

PropertyEnergyEfficientHomeIndicator Bound Attachments 
Name  Current Value 

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

PropertyEnergyEfficientHomeIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

PropertyEnergyEfficientHomeIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

PropertyEnergyEfficientHomeIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

PropertyEnergyEfficientHomeIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

RuralHousingConditionalGuarantyExpirationDate 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  RuralHousingConditionalGuarantyExpirationDate 
Logical Rolename   
ColumnName  RuralHousingConditionalGuarantyExpirationDate 
RoleName   
Domain  MISMODate 
Definition  For Rural Housing loans, the expiration date of the guaranty. 
Note 
 

RuralHousingConditionalGuarantyExpirationDate Logical Attribute Properties 
Logical Attribute Name  RuralHousingConditionalGuarantyExpirationDate 
Datatype  DATE 
Nullable  NO 

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

RuralHousingConditionalGuarantyExpirationDate Bound Attachments 
Name  Current Value 

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

RuralHousingConditionalGuarantyExpirationDate Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

RuralHousingConditionalGuarantyExpirationDate Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

RuralHousingConditionalGuarantyExpirationDate Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

RuralHousingConditionalGuarantyExpirationDate Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

RuralHousingConditionalGuarantyInterestRatePercent 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  RuralHousingConditionalGuarantyInterestRatePercent 
Logical Rolename   
ColumnName  RuralHousingConditionalGuarantyInterestRatePercent 
RoleName   
Domain  MISMOPercent 
Definition  For Rural Housing loans, the interest rate included in the USDA guaranty. 
Note 
 

RuralHousingConditionalGuarantyInterestRatePercent Logical Attribute Properties 
Logical Attribute Name  RuralHousingConditionalGuarantyInterestRatePercent 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

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

RuralHousingConditionalGuarantyInterestRatePercent Bound Attachments 
Name  Current Value 

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

RuralHousingConditionalGuarantyInterestRatePercent Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

RuralHousingConditionalGuarantyInterestRatePercent Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

RuralHousingConditionalGuarantyInterestRatePercent Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

RuralHousingConditionalGuarantyInterestRatePercent Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

SectionOfActType 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  SectionOfActType 
Logical Rolename   
ColumnName  SectionOfActType 
RoleName   
Domain  SectionOfActEnum 
Definition  Identifies the section of the National Housing Act which defines underwriting guidelines for VA or FHA loan evaluations.  
Note 
 

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

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

SectionOfActType Reference Value (Bound to Domain) 
Name  ValidationRule443 
Description   
Type  By List 
Value  Value Description 
184  Section 184-Public and Indian Housing Loan Guarantees for Indian Housing guarantees mortgage loans to Indian families, IHAs, and Indian tribes that could not otherwise acquire housing financing because of the unique legal status of Indian lands. The loans guaranteed under the program are used to construct, acquire, refinance, or rehabilitate single family housing located on trust land or land located in an Indian or Alaska Native area. 
184A  Section 184-Public and Indian Housing Loan Guarantees for Indian Housing guarantees mortgage loans to Indian families, IHAs, and Indian tribes that could not otherwise acquire housing financing because of the unique legal status of Indian lands. The loans guaranteed under the program are used to construct, acquire, refinance, or rehabilitate single family housing located on trust land or land located in an Indian or Alaska Native area. 
201S  Referred to as 201(s) - Secured Title I - Direct Loan 
201SD  Referred to as 201(s)(d) - Secured Title II - Dealer Loan 
201U  Referred to as 201(u) - Unsecured Title I - Direct Loan 
201UD  Referred to as 201(u)(d) - Unsecured Title II - Dealer Loan 
203B  Section 203(b)-Federal mortgage insurance to finance homeownership and the construction and financing of housing. 
203B2  Referred to as 203(b)2. Purchase, Refinances - Veteran Status 
203B241  Referred to as 203(b)/241. Purchase, Refinances - Native American 
203B251  Referred to as 203(b)/251. Condominium/ARM 
203H  Section 203(h)-FHA Mortgage Insurance for Disaster Victims. Federal mortgage insurance for victims of a major disaster who have lost their homes and are in the process of rebuilding or buying another home. 
203I  Referred to as 203(I). Mortgage Insurance for Outlying Areas 
203K  Section 203(k)-FHA Rehabilitation Loan Insurance. Insures loans to finance the rehabilitation or purchase and rehabilitation of one- to four-family properties. 
203K241  Referred to as 203(k)/241. A first mortgage that covers the costs of rehabilitation and purchase or refinance of an eligible property -Native American 
203K251  Referred to as 203(k)/251. Purchase, Rehab/ARM 
204A  Section 204(a)-Helps homeowners with FHA-insured loans to effectively work with lenders to find creative solutions to avoid foreclosure. 
204GSingleFamilyPropertyDisposition  Section 204(g)-FHA Single Family Property Disposition Program. Disposes of one- to four-family FHA-owned properties in a manner targeted to expanding homeownership opportunities. 
204GFHAGoodNeighborNextDoor  Section 204(g)-FHA Good Neighbor Next Door Program. Provides law enforcement officers, teachers, firefighters, and emergency medical technicians with the opportunity to purchase homes located in revitalization areas at significant discount. 
213  Cooperative Mortgages (individual share loans only) (Inactive code. Deactivated on 10/26/09.) 
220  220: Mortgages in Urban Renewal Areas (individual share loans only) (Inactive code. Deactivated on 10/26/09.) 
221  Referred to as 221 - Low Cost and Moderate Income Mortgages (Inactive code. Deactivated on 10/26/09.) 
221D2  Referred to as 221(d)(2). Low and Moderate Income/ARM (Inactive code. Deactivated on 10/26/09.) 
221D2251  Referred to as 221(d)(2)/251. Low and Moderate Income/ARM (Inactive code. Deactivated on 10/26/09.) 
222  Defense Service Members Mortgage 
223E  Section 223(e) FHA Mortgage Insurance for older, declining areas. Federal insurance on mortgage loans to finance the purchase, rehabilitation, or construction of housing in older, declining, but still viable urban areas where conditions are such that normal requirements for mortgage insurance cannot be met. 
233  Experimental Housing Units (individual mortgages only) 
234C  Section 234(c)-FHA Mortgage Insurance for Condominium Units. Federal mortgage insurance to finance the purchase of individual housing units in proposed or existing condominiums. 
234C251  Referred to as 234(c)/251. Condominium/ARM 
235  Homeownership Assistance for Lower Income Families 
237  Special Credit Risks 
240  Fee Simple Title from Lessors 
245  Graduated Payment Mortgages (GPM) and Growing Equity Mortgages (GEM) 
245A  Section 245(a)-FHA Graduated Payment Mortgages (GPM) and Growing Equity Mortgages (GEM). Enables a household with a limited income that is expected to rise to buy a home sooner by making mortgage payments that start small and increase gradually over time. The GPM program offers five different plans varying in length of time and rate of increase of nominal interest rate. 
247  Section 247-FHA Mortgages on Hawaiian Home Lands. Provides opportunities to low- and moderate-income Native Hawaiians to purchase a home on Hawaiian home lands, where, because a mortgage is taken on a homestead lease granted by the Department of Hawaiian Homelands, home financing may be difficult to find. 
248  Section 248-FHA Insured Mortgages on Indian lands. Provides opportunities for low- and moderate-income Native Americans to purchase a home in their communities on Indianland, where, because of the complex title issues involved, financing may be difficult to find. 
251  Section 251-FHA Adjustable Rate Mortgages. Under this HUD-insured mortgage, the interest rate and monthly payment may change during the life of the loan. 
255  Section 255-FHA Home Equity Conversion Mortgage (HECM) Program. Allows borrowers, who are at least 62 years of age, to convert the equity in their homes into a monthly stream of income or a line of credit. 
256  Home Repair Services Grants For Older And Disabled Homeowners. (Inactive code. Deactivated on 10/26/09.) 
257  HOPE for Homeowners (Inactive code. Deactivated on 10/26/09.) 
26101  Federal Housing Administration (FHA) Graduated Payment Mortgage (GPM) Plan I, Section of the Act 203(b) 
26102  Federal Housing Administration (FHA) Graduated Payment Mortgage (GPM) Plan II, Section of the Act 203(b) 
26201  Federal Housing Administration (FHA) Graduated Payment Mortgage (GPM) Plan I, Section of the Act 234(c) 
26202  Federal Housing Administration (FHA) Graduated Payment Mortgage (GPM) Plan II, Section of the Act 234(c) 
27001  Federal Housing Administration (FHA) Graduated Payment Mortgage (GPM) Plan I, Section of the Act 203(b) 
27002  Federal Housing Administration (FHA) Graduated Payment Mortgage (GPM) Plan II, Section of the Act 203(b) 
27003  Federal Housing Administration (FHA) Graduated Payment Mortgage (GPM) Plan III, Section of the Act 203(b) 
3710  Department of Veterans Affairs (VA) Fixed Rate Mortgages (Formerly 1810) 
502USDARuralDevelopmentGuaranteedHousingLoan  Section 502-USDA Rural Development Direct Housing Loan. Loans to low-income individuals or households purchase homes in rural areas. Funds can be used to build, repair, renovate or relocate a home, or to purchase and prepare sites, including providing water and sewage facilities. 
513  FHA Energy Efficient Mortgage Insurance. Insures an FHA mortgage that exceeds the normal maximum loan limits if the mortgage includes an amount for the purchase of energy efficient improvements made or to be made to the property. 
729  Government Adjustable Rate Mortgages From Lenders With Housing and Urban Development (HUD) Direct Endorsement Authority, Section of the Act 203(b)/251 (Inactive code. Deactivated on 10/26/09.) 
8Y  Section 8(y)- Public and Indian Housing Homeownership Voucher Assistance Program Program enabling public housing agencies to provide monthly assistance in an amount that would otherwise have been provided as tenant-based voucher assistance to qualified Section 8 Housing Choice Voucher families who are purchasing homes. 
FHATitleIInsuranceForManufacturedHomes  Title II Section I-FHA Manufactured Home Loans Insurance. Insures loans to finance the purchase of manufactured homes or lots. 
FHATitleIInsuranceForPropertyImprovementLoans  Title II Section I-FHA Property Improvement Loan Insurance. Insures loans to finance improvements, alterations, and repairs of individual homes, apartment buildings, and nonresidential structures, as well as new construction of nonresidential buildings. 
Other  Other 

SectionOfActType Bound Attachments 
Name  Current Value 

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

SectionOfActType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SectionOfActType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SectionOfActType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SectionOfActType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

SectionOfActTypeOtherDescription 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  SectionOfActTypeOtherDescription 
Logical Rolename   
ColumnName  SectionOfActTypeOtherDescription 
RoleName   
Domain  MISMOString 
Definition  A free form text field used to collect additional information when Other is selected for Section of Act Type. 
Note 
 

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

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

SectionOfActTypeOtherDescription Bound Attachments 
Name  Current Value 

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

SectionOfActTypeOtherDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SectionOfActTypeOtherDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SectionOfActTypeOtherDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SectionOfActTypeOtherDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

SellerPaidFHA_VAClosingCostsPercent 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  SellerPaidFHA_VAClosingCostsPercent 
Logical Rolename   
ColumnName  SellerPaidFHA_VAClosingCostsPercent 
RoleName   
Domain  MISMOPercent 
Definition  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. 
Note 
 

SellerPaidFHA_VAClosingCostsPercent Logical Attribute Properties 
Logical Attribute Name  SellerPaidFHA_VAClosingCostsPercent 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

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

SellerPaidFHA_VAClosingCostsPercent Bound Attachments 
Name  Current Value 

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

SellerPaidFHA_VAClosingCostsPercent Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SellerPaidFHA_VAClosingCostsPercent Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SellerPaidFHA_VAClosingCostsPercent Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SellerPaidFHA_VAClosingCostsPercent Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

SoldUnderHUDSingleFamilyPropertyDispositionProgramIndicator 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  SoldUnderHUDSingleFamilyPropertyDispositionProgramIndicator 
Logical Rolename   
ColumnName  SoldUnderHUDSingleFamilyPropertyDispositionProgramIndicator 
RoleName   
Domain  MISMOIndicator 
Definition   
Note 
 

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

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

SoldUnderHUDSingleFamilyPropertyDispositionProgramIndicator Bound Attachments 
Name  Current Value 

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

SoldUnderHUDSingleFamilyPropertyDispositionProgramIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SoldUnderHUDSingleFamilyPropertyDispositionProgramIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SoldUnderHUDSingleFamilyPropertyDispositionProgramIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SoldUnderHUDSingleFamilyPropertyDispositionProgramIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

USDA198021RuralHousingAdjustedAnnualHouseholdIncomeAmount 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  USDA198021RuralHousingAdjustedAnnualHouseholdIncomeAmount 
Logical Rolename   
ColumnName  USDA198021RuralHousingAdjustedAnnualHouseholdIncomeAmount 
RoleName   
Domain  MISMOAmount 
Definition  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 
Note 
 

USDA198021RuralHousingAdjustedAnnualHouseholdIncomeAmount Logical Attribute Properties 
Logical Attribute Name  USDA198021RuralHousingAdjustedAnnualHouseholdIncomeAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

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

USDA198021RuralHousingAdjustedAnnualHouseholdIncomeAmount Bound Attachments 
Name  Current Value 

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

USDA198021RuralHousingAdjustedAnnualHouseholdIncomeAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

USDA198021RuralHousingAdjustedAnnualHouseholdIncomeAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

USDA198021RuralHousingAdjustedAnnualHouseholdIncomeAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

USDA198021RuralHousingAdjustedAnnualHouseholdIncomeAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

VAAppraisalType 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  VAAppraisalType 
Logical Rolename   
ColumnName  VAAppraisalType 
RoleName   
Domain  VAAppraisalEnum 
Definition  Specifies the property appraisal type used, as appears on VA Loan Summary Sheet (VA 26-0286), for example.  
Note 
 

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

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

VAAppraisalType Reference Value (Bound to Domain) 
Name  ValidationRule485 
Description   
Type  By List 
Value  Value Description 
HUDConversion  HUDConversion 
LenderAppraisal  LenderAppraisal 
ManufacturedHome  ManufacturedHome 
MasterCertificateOfReasonableValueCase  MasterCertificateOfReasonableValueCase 
Other  Other 
PropertyManagementCase  PropertyManagementCase 
SingleProperty  SingleProperty 

VAAppraisalType Bound Attachments 
Name  Current Value 

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

VAAppraisalType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

VAAppraisalType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

VAAppraisalType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

VAAppraisalType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

VAAppraisalTypeOtherDescription 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  VAAppraisalTypeOtherDescription 
Logical Rolename   
ColumnName  VAAppraisalTypeOtherDescription 
RoleName   
Domain  MISMOString 
Definition  A free-form text field which contains the description of the type of VA appraisal when Other is selected as the VA Appraisal Type. 
Note 
 

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

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

VAAppraisalTypeOtherDescription Bound Attachments 
Name  Current Value 

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

VAAppraisalTypeOtherDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

VAAppraisalTypeOtherDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

VAAppraisalTypeOtherDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

VAAppraisalTypeOtherDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

VABorrowerCoBorrowerMarriedIndicator 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  VABorrowerCoBorrowerMarriedIndicator 
Logical Rolename   
ColumnName  VABorrowerCoBorrowerMarriedIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates whether the co-borrower is married to the borrower. Used for VA loans only. 
Note 
 

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

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

VABorrowerCoBorrowerMarriedIndicator Bound Attachments 
Name  Current Value 

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

VABorrowerCoBorrowerMarriedIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

VABorrowerCoBorrowerMarriedIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

VABorrowerCoBorrowerMarriedIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

VABorrowerCoBorrowerMarriedIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

VAClaimFolderIdentifier 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  VAClaimFolderIdentifier 
Logical Rolename   
ColumnName  VAClaimFolderIdentifier 
RoleName   
Domain  MISMOIdentifier 
Definition  Identification number of the associated VA claim folder. 
Note 
 

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

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

VAClaimFolderIdentifier Bound Attachments 
Name  Current Value 

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

VAClaimFolderIdentifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

VAClaimFolderIdentifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

VAClaimFolderIdentifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

VAClaimFolderIdentifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

VAEntitlementAmount 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  VAEntitlementAmount 
Logical Rolename   
ColumnName  VAEntitlementAmount 
RoleName   
Domain  MISMOAmount 
Definition  The dollar amount of guarantee by the VA available to the veteran borrower. 
Note 
 

VAEntitlementAmount Logical Attribute Properties 
Logical Attribute Name  VAEntitlementAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

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

VAEntitlementAmount Bound Attachments 
Name  Current Value 

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

VAEntitlementAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

VAEntitlementAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

VAEntitlementAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

VAEntitlementAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

VAEntitlementIdentifier 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  VAEntitlementIdentifier 
Logical Rolename   
ColumnName  VAEntitlementIdentifier 
RoleName   
Domain  MISMOIdentifier 
Definition  VA entitlement identifier from Certificate of Eligibility for VA Loan Summary Sheet. 
Note 
 

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

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

VAEntitlementIdentifier Bound Attachments 
Name  Current Value 

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

VAEntitlementIdentifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

VAEntitlementIdentifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

VAEntitlementIdentifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

VAEntitlementIdentifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

VAFundingFeeExemptionType 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  VAFundingFeeExemptionType 
Logical Rolename   
ColumnName  VAFundingFeeExemptionType 
RoleName   
Domain  VAFundingFeeExemptionEnum 
Definition  The Exemption Status given by the VA Administration (exemption from VA Funding Fees).  
Note 
 

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

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

VAFundingFeeExemptionType Reference Value (Bound to Domain) 
Name  ValidationRule487 
Description   
Type  By List 
Value  Value Description 
CompletelyExempt  CompletelyExempt 
NotExempt  NotExempt 
Other  Other 
PartiallyExempt  The VA will give a percentage of exemption for Veterans that do have a disability, but the disability is not service related. 

VAFundingFeeExemptionType Bound Attachments 
Name  Current Value 

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

VAFundingFeeExemptionType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

VAFundingFeeExemptionType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

VAFundingFeeExemptionType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

VAFundingFeeExemptionType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

VAFundingFeeExemptionTypeOtherDescription 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  VAFundingFeeExemptionTypeOtherDescription 
Logical Rolename   
ColumnName  VAFundingFeeExemptionTypeOtherDescription 
RoleName   
Domain  MISMOString 
Definition  A free form text field used to collect additional information when Other is selected for VA Funding Fee Exemption Type. 
Note 
 

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

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

VAFundingFeeExemptionTypeOtherDescription Bound Attachments 
Name  Current Value 

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

VAFundingFeeExemptionTypeOtherDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

VAFundingFeeExemptionTypeOtherDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

VAFundingFeeExemptionTypeOtherDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

VAFundingFeeExemptionTypeOtherDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

VAHouseholdSizeCount 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  VAHouseholdSizeCount 
Logical Rolename   
ColumnName  VAHouseholdSizeCount 
RoleName   
Domain  MISMOCount 
Definition  Size of household at the loan level as defined by the VA. The lender must meet VA requirements for determining the size of household. 
Note 
 

VAHouseholdSizeCount Logical Attribute Properties 
Logical Attribute Name  VAHouseholdSizeCount 
Datatype  INTEGER 
Nullable  NO 

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

VAHouseholdSizeCount Bound Attachments 
Name  Current Value 

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

VAHouseholdSizeCount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

VAHouseholdSizeCount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

VAHouseholdSizeCount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

VAHouseholdSizeCount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

VALoanProcedureType 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  VALoanProcedureType 
Logical Rolename   
ColumnName  VALoanProcedureType 
RoleName   
Domain  VALoanProcedureEnum 
Definition  Specifies the procedure used to qualify the borrower(s).  
Note 
 

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

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

VALoanProcedureType Reference Value (Bound to Domain) 
Name  ValidationRule488 
Description   
Type  By List 
Value  Value Description 
Automatic  Automatic 
AutomaticInterestRateReductionRefinanceLoan  AutomaticInterestRateReductionRefinanceLoan 
Other  Other 
VAPriorApproval  VAPriorApproval 

VALoanProcedureType Bound Attachments 
Name  Current Value 

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

VALoanProcedureType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

VALoanProcedureType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

VALoanProcedureType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

VALoanProcedureType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

VALoanProcedureTypeOtherDescription 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  VALoanProcedureTypeOtherDescription 
Logical Rolename   
ColumnName  VALoanProcedureTypeOtherDescription 
RoleName   
Domain  MISMOString 
Definition  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. 
Note 
 

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

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

VALoanProcedureTypeOtherDescription Bound Attachments 
Name  Current Value 

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

VALoanProcedureTypeOtherDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

VALoanProcedureTypeOtherDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

VALoanProcedureTypeOtherDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

VALoanProcedureTypeOtherDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

VALoanProgramType 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  VALoanProgramType 
Logical Rolename   
ColumnName  VALoanProgramType 
RoleName   
Domain  VALoanProgramEnum 
Definition  Identifies the type of VA Loan Program established by Title 38 of the US Code.  
Note 
 

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

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

VALoanProgramType Reference Value (Bound to Domain) 
Name  ValidationRule489 
Description   
Type  By List 
Value  Value Description 
Other  Other 
VADirectHomeLoanProgramForNativeAmericans  Section 3711. VA Direct Home Loans for Native American Veterans Living on Trust Lands 
VAGuaranteedCondomiumUnit  Section 3710(a)(6). VA Guaranteed Condomium Unit 
VAGuaranteedFarmResidenceConstruction  Section 3710(a)(3). VA Guaranteed Farm Residence Construction 
VAGuaranteedFarmResidenceEnergyEfficiencyImprovements  Section 3710(a)(7). VA Guaranteed Farm Residence Energy Efficiency Improvements 
VAGuaranteedFarmResidencePurchase  Section 3710(a)(2). VA Guaranteed Farm Residence Purchase 
VAGuaranteedFarmResidenceRepairAlternationOrImprovement  Section 3710(a)(4). VA Guaranteed Farm Residence Repair, Alternation or Improvement 
VAGuaranteedHomePurchaseOrConstruction  Section 3710(a)(1). VA Guaranteed Single Family Home Purchase Or Construction 
VAGuaranteedHomePurchaseWithEnergyEfficiencyImprovements  Section 3710(10).VA Guaranteed Home Purchase with Energy Efficiency Improvements 
VAGuaranteedHomeRefinanceWithEnergyEfficiencyImprovements  Section 3710(11). VA Guarantee Home Refinance with Energy Efficiency Improvements 
VAGuaranteedManufacturedHomeOrLotPurchaseOrRefinance  Section 3712-VA Guaranteed Manufactured Home Or Lot Purchase Or Refinance 
VAGuaranteedRefinance  Section 3710(a)(8). VA Guaranteed Refinance 
VAGuaranteedRefinanceLiensSecuredByVADwelling  Section 3710(a)(5). VA Guaranteed Refinance Liens Secured by VA Dwelling 

VALoanProgramType Bound Attachments 
Name  Current Value 

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

VALoanProgramType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

VALoanProgramType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

VALoanProgramType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

VALoanProgramType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

VALoanProgramTypeOtherDescription 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  VALoanProgramTypeOtherDescription 
Logical Rolename   
ColumnName  VALoanProgramTypeOtherDescription 
RoleName   
Domain  MISMOString 
Definition  A free-form text field used to describe the VA Loan Program Type if Other is selected as the VA Loan Program Type. 
Note 
 

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

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

VALoanProgramTypeOtherDescription Bound Attachments 
Name  Current Value 

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

VALoanProgramTypeOtherDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

VALoanProgramTypeOtherDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

VALoanProgramTypeOtherDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

VALoanProgramTypeOtherDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

VAMaintenanceExpenseMonthlyAmount 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  VAMaintenanceExpenseMonthlyAmount 
Logical Rolename   
ColumnName  VAMaintenanceExpenseMonthlyAmount 
RoleName   
Domain  MISMOAmount 
Definition  The estimated dollar amount of monthly maintenance expense used for VA loans. 
Note 
 

VAMaintenanceExpenseMonthlyAmount Logical Attribute Properties 
Logical Attribute Name  VAMaintenanceExpenseMonthlyAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

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

VAMaintenanceExpenseMonthlyAmount Bound Attachments 
Name  Current Value 

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

VAMaintenanceExpenseMonthlyAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

VAMaintenanceExpenseMonthlyAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

VAMaintenanceExpenseMonthlyAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

VAMaintenanceExpenseMonthlyAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

VAReasonableValueImprovementsCompletionIndicator 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  VAReasonableValueImprovementsCompletionIndicator 
Logical Rolename   
ColumnName  VAReasonableValueImprovementsCompletionIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  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. 
Note 
 

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

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

VAReasonableValueImprovementsCompletionIndicator Bound Attachments 
Name  Current Value 

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

VAReasonableValueImprovementsCompletionIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

VAReasonableValueImprovementsCompletionIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

VAReasonableValueImprovementsCompletionIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

VAReasonableValueImprovementsCompletionIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

VAResidualIncomeAmount 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  VAResidualIncomeAmount 
Logical Rolename   
ColumnName  VAResidualIncomeAmount 
RoleName   
Domain  MISMOAmount 
Definition  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. 
Note 
 

VAResidualIncomeAmount Logical Attribute Properties 
Logical Attribute Name  VAResidualIncomeAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

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

VAResidualIncomeAmount Bound Attachments 
Name  Current Value 

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

VAResidualIncomeAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

VAResidualIncomeAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

VAResidualIncomeAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

VAResidualIncomeAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

VAResidualIncomeGuidelineAmount 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  VAResidualIncomeGuidelineAmount 
Logical Rolename   
ColumnName  VAResidualIncomeGuidelineAmount 
RoleName   
Domain  MISMOAmount 
Definition  Dollar amount used as a guideline for assessing residual income. 
Note 
 

VAResidualIncomeGuidelineAmount Logical Attribute Properties 
Logical Attribute Name  VAResidualIncomeGuidelineAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

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

VAResidualIncomeGuidelineAmount Bound Attachments 
Name  Current Value 

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

VAResidualIncomeGuidelineAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

VAResidualIncomeGuidelineAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

VAResidualIncomeGuidelineAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

VAResidualIncomeGuidelineAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

VATitleVestingType 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  VATitleVestingType 
Logical Rolename   
ColumnName  VATitleVestingType 
RoleName   
Domain  VATitleVestingEnum 
Definition  The VA specific vesting under which the property is, or will be, held.  
Note 
 

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

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

VATitleVestingType Reference Value (Bound to Domain) 
Name  ValidationRule490 
Description   
Type  By List 
Value  Value Description 
JointTwoOrMoreVeterans  JointTwoOrMoreVeterans 
JointVeteranAndNonVeteran  JointVeteranAndNonVeteran 
Other  Other 
Veteran  Veteran 
VeteranAndSpouse  VeteranAndSpouse 

VATitleVestingType Bound Attachments 
Name  Current Value 

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

VATitleVestingType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

VATitleVestingType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

VATitleVestingType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

VATitleVestingType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

VATitleVestingTypeOtherDescription 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  VATitleVestingTypeOtherDescription 
Logical Rolename   
ColumnName  VATitleVestingTypeOtherDescription 
RoleName   
Domain  MISMOString 
Definition  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. 
Note 
 

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

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

VATitleVestingTypeOtherDescription Bound Attachments 
Name  Current Value 

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

VATitleVestingTypeOtherDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

VATitleVestingTypeOtherDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

VATitleVestingTypeOtherDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

VATitleVestingTypeOtherDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

VAUtilityExpenseMonthlyAmount 
Base Entity  GOVERNMENT_LOAN 
Attribute Name  VAUtilityExpenseMonthlyAmount 
Logical Rolename   
ColumnName  VAUtilityExpenseMonthlyAmount 
RoleName   
Domain  MISMOAmount 
Definition  The estimated dollar amount of monthly utility expense used for VA loans. 
Note 
 

VAUtilityExpenseMonthlyAmount Logical Attribute Properties 
Logical Attribute Name  VAUtilityExpenseMonthlyAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

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

VAUtilityExpenseMonthlyAmount Bound Attachments 
Name  Current Value 

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

VAUtilityExpenseMonthlyAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

VAUtilityExpenseMonthlyAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

VAUtilityExpenseMonthlyAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

VAUtilityExpenseMonthlyAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description