| FNMCommunityLendingProductType |
| Base Entity | AFFORDABLE_LENDING |
| Attribute Name | FNMCommunityLendingProductType |
| Logical Rolename | |
| ColumnName | FNMCommunityLendingProductType |
| RoleName | |
| Domain | FNMCommunityLendingProductEnum |
| Definition | Specifies the type of the Fannie Mae community lending product that is associated with the loan. |
| Note |
| FNMCommunityLendingProductType Logical Attribute Properties |
| Logical Attribute Name | FNMCommunityLendingProductType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| FNMCommunityLendingProductType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FNMCommunityLendingProductType Reference Value (Bound to Domain) |
| Name | ValidationRule164 |
| Description | |
| Type | By List |
| Value | Value Description |
| CommunityHomeBuyersProgram | CommunityHomeBuyersProgram |
| Fannie32 | Fannie32 |
| Fannie97 | Fannie97 |
| MyCommunityMortgage | MyCommunityMortgage |
| Other | Other |
| FNMCommunityLendingProductType Bound Attachments |
| Name | Current Value |
| FNMCommunityLendingProductType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FNMCommunityLendingProductType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FNMCommunityLendingProductType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FNMCommunityLendingProductType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FNMCommunityLendingProductType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FNMCommunityLendingProductTypeOtherDescription |
| Base Entity | AFFORDABLE_LENDING |
| Attribute Name | FNMCommunityLendingProductTypeOtherDescription |
| Logical Rolename | |
| ColumnName | FNMCommunityLendingProductTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free form text field used to capture a description of the FNM Community Lending Product Type when Other is selected. |
| Note |
| FNMCommunityLendingProductTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | FNMCommunityLendingProductTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| FNMCommunityLendingProductTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FNMCommunityLendingProductTypeOtherDescription Bound Attachments |
| Name | Current Value |
| FNMCommunityLendingProductTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FNMCommunityLendingProductTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FNMCommunityLendingProductTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FNMCommunityLendingProductTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FNMCommunityLendingProductTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FNMCommunitySecondsIndicator |
| Base Entity | AFFORDABLE_LENDING |
| Attribute Name | FNMCommunitySecondsIndicator |
| Logical Rolename | |
| ColumnName | FNMCommunitySecondsIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates whether the loan is a Fannie Mae Community Seconds. |
| Note |
| FNMCommunitySecondsIndicator Logical Attribute Properties |
| Logical Attribute Name | FNMCommunitySecondsIndicator |
| Datatype | BIT |
| Nullable | NO |
| FNMCommunitySecondsIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FNMCommunitySecondsIndicator Bound Attachments |
| Name | Current Value |
| FNMCommunitySecondsIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FNMCommunitySecondsIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FNMCommunitySecondsIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FNMCommunitySecondsIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FNMCommunitySecondsIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FNMNeighborsMortgageEligibilityIndicator |
| Base Entity | AFFORDABLE_LENDING |
| Attribute Name | FNMNeighborsMortgageEligibilityIndicator |
| Logical Rolename | |
| ColumnName | FNMNeighborsMortgageEligibilityIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates whether the loan is eligible to be a Fannie Mae Neighbors mortgage. |
| Note |
| FNMNeighborsMortgageEligibilityIndicator Logical Attribute Properties |
| Logical Attribute Name | FNMNeighborsMortgageEligibilityIndicator |
| Datatype | BIT |
| Nullable | NO |
| FNMNeighborsMortgageEligibilityIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FNMNeighborsMortgageEligibilityIndicator Bound Attachments |
| Name | Current Value |
| FNMNeighborsMortgageEligibilityIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FNMNeighborsMortgageEligibilityIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FNMNeighborsMortgageEligibilityIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FNMNeighborsMortgageEligibilityIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FNMNeighborsMortgageEligibilityIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HUDIncomeLimitAdjustmentPercent |
| Base Entity | AFFORDABLE_LENDING |
| Attribute Name | HUDIncomeLimitAdjustmentPercent |
| Logical Rolename | |
| ColumnName | HUDIncomeLimitAdjustmentPercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The percentage by which the HUD Median Income can be exceeded in certain high cost areas. |
| Note |
| HUDIncomeLimitAdjustmentPercent Logical Attribute Properties |
| Logical Attribute Name | HUDIncomeLimitAdjustmentPercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| HUDIncomeLimitAdjustmentPercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| HUDIncomeLimitAdjustmentPercent Bound Attachments |
| Name | Current Value |
| HUDIncomeLimitAdjustmentPercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| HUDIncomeLimitAdjustmentPercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HUDIncomeLimitAdjustmentPercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HUDIncomeLimitAdjustmentPercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HUDIncomeLimitAdjustmentPercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HUDLendingIncomeLimitAmount |
| Base Entity | AFFORDABLE_LENDING |
| Attribute Name | HUDLendingIncomeLimitAmount |
| Logical Rolename | |
| ColumnName | HUDLendingIncomeLimitAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The total dollar amount for HUD based on the median income and adjustment factors. |
| Note |
| HUDLendingIncomeLimitAmount Logical Attribute Properties |
| Logical Attribute Name | HUDLendingIncomeLimitAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| HUDLendingIncomeLimitAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| HUDLendingIncomeLimitAmount Bound Attachments |
| Name | Current Value |
| HUDLendingIncomeLimitAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| HUDLendingIncomeLimitAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HUDLendingIncomeLimitAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HUDLendingIncomeLimitAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HUDLendingIncomeLimitAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HUDMedianIncomeAmount |
| Base Entity | AFFORDABLE_LENDING |
| Attribute Name | HUDMedianIncomeAmount |
| Logical Rolename | |
| ColumnName | HUDMedianIncomeAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The HUD estimated median family incomes to determine borrower eligibility for all applications related to affordable lending products. |
| Note |
| HUDMedianIncomeAmount Logical Attribute Properties |
| Logical Attribute Name | HUDMedianIncomeAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| HUDMedianIncomeAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| HUDMedianIncomeAmount Bound Attachments |
| Name | Current Value |
| HUDMedianIncomeAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| HUDMedianIncomeAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HUDMedianIncomeAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HUDMedianIncomeAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HUDMedianIncomeAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |