| AntiSteeringComparisonType |
| Base Entity | LOAN_PRODUCT_DETAIL |
| Attribute Name | AntiSteeringComparisonType |
| Logical Rolename | |
| ColumnName | AntiSteeringComparisonType |
| RoleName | |
| Domain | AntiSteeringComparisonEnum |
| Definition | Specifies how the loan conditions have been changed for this comparison instance for the purposes of anti steering (safe harbor) regulatory requirements. |
| Note |
| AntiSteeringComparisonType Logical Attribute Properties |
| Logical Attribute Name | AntiSteeringComparisonType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| AntiSteeringComparisonType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AntiSteeringComparisonType Reference Value (Bound to Domain) |
| Name | ValidationRule16 |
| Description | |
| Type | By List |
| Value | Value Description |
| LowestInterestRate | LowestInterestRate |
| LowestInterestRateWithoutCertainFeatures | LowestInterestRateWithoutCertainFeatures |
| LowestTotalAmountForOriginationPointsOrFeesAndDiscountPoints | LowestTotalAmountForOriginationPointsOrFeesAndDiscountPoints |
| NotApplicable | NotApplicable |
| Other | Other |
| AntiSteeringComparisonType Bound Attachments |
| Name | Current Value |
| AntiSteeringComparisonType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AntiSteeringComparisonType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AntiSteeringComparisonType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AntiSteeringComparisonType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AntiSteeringComparisonType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AntiSteeringComparisonTypeOtherDescription |
| Base Entity | LOAN_PRODUCT_DETAIL |
| Attribute Name | AntiSteeringComparisonTypeOtherDescription |
| Logical Rolename | |
| ColumnName | AntiSteeringComparisonTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free-form text field which contains the description of the Anti-Steering comparison type when Other is selected as the Anti-Steering Comparison Type. |
| Note |
| AntiSteeringComparisonTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | AntiSteeringComparisonTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| AntiSteeringComparisonTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AntiSteeringComparisonTypeOtherDescription Bound Attachments |
| Name | Current Value |
| AntiSteeringComparisonTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AntiSteeringComparisonTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AntiSteeringComparisonTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AntiSteeringComparisonTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AntiSteeringComparisonTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BorrowerSelectedAntiSteeringComparisonType |
| Base Entity | LOAN_PRODUCT_DETAIL |
| Attribute Name | BorrowerSelectedAntiSteeringComparisonType |
| Logical Rolename | |
| ColumnName | BorrowerSelectedAntiSteeringComparisonType |
| RoleName | |
| Domain | AntiSteeringComparisonEnum |
| Definition | Specifies the loan characteristic(s) used as the basis for the comparison loan chosen by the Borrower. |
| Note |
| BorrowerSelectedAntiSteeringComparisonType Logical Attribute Properties |
| Logical Attribute Name | BorrowerSelectedAntiSteeringComparisonType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| BorrowerSelectedAntiSteeringComparisonType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BorrowerSelectedAntiSteeringComparisonType Reference Value (Bound to Domain) |
| Name | ValidationRule16 |
| Description | |
| Type | By List |
| Value | Value Description |
| LowestInterestRate | LowestInterestRate |
| LowestInterestRateWithoutCertainFeatures | LowestInterestRateWithoutCertainFeatures |
| LowestTotalAmountForOriginationPointsOrFeesAndDiscountPoints | LowestTotalAmountForOriginationPointsOrFeesAndDiscountPoints |
| NotApplicable | NotApplicable |
| Other | Other |
| BorrowerSelectedAntiSteeringComparisonType Bound Attachments |
| Name | Current Value |
| BorrowerSelectedAntiSteeringComparisonType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| BorrowerSelectedAntiSteeringComparisonType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BorrowerSelectedAntiSteeringComparisonType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BorrowerSelectedAntiSteeringComparisonType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BorrowerSelectedAntiSteeringComparisonType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BorrowerSelectedAntiSteeringComparisonTypeOtherDescription |
| Base Entity | LOAN_PRODUCT_DETAIL |
| Attribute Name | BorrowerSelectedAntiSteeringComparisonTypeOtherDescription |
| Logical Rolename | |
| ColumnName | BorrowerSelectedAntiSteeringComparisonTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free-form text field which contains the description of the Anti-Steering comparison type when Other is selected as the Borrower Selected Anti-Steering Comparison Type. |
| Note |
| BorrowerSelectedAntiSteeringComparisonTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | BorrowerSelectedAntiSteeringComparisonTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| BorrowerSelectedAntiSteeringComparisonTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BorrowerSelectedAntiSteeringComparisonTypeOtherDescription Bound Attachments |
| Name | Current Value |
| BorrowerSelectedAntiSteeringComparisonTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| BorrowerSelectedAntiSteeringComparisonTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BorrowerSelectedAntiSteeringComparisonTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BorrowerSelectedAntiSteeringComparisonTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BorrowerSelectedAntiSteeringComparisonTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DiscountPointsTotalAmount |
| Base Entity | LOAN_PRODUCT_DETAIL |
| Attribute Name | DiscountPointsTotalAmount |
| Logical Rolename | |
| ColumnName | DiscountPointsTotalAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The total dollar amount estimated or paid as discount points for this loan product |
| Note |
| DiscountPointsTotalAmount Logical Attribute Properties |
| Logical Attribute Name | DiscountPointsTotalAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| DiscountPointsTotalAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DiscountPointsTotalAmount Bound Attachments |
| Name | Current Value |
| DiscountPointsTotalAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| DiscountPointsTotalAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DiscountPointsTotalAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DiscountPointsTotalAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DiscountPointsTotalAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FNMHomeImprovementProductType |
| Base Entity | LOAN_PRODUCT_DETAIL |
| Attribute Name | FNMHomeImprovementProductType |
| Logical Rolename | |
| ColumnName | FNMHomeImprovementProductType |
| RoleName | |
| Domain | FNMHomeImprovementProductEnum |
| Definition | Denotes the Fannie Mae specific home improvement product. |
| Note |
| FNMHomeImprovementProductType Logical Attribute Properties |
| Logical Attribute Name | FNMHomeImprovementProductType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| FNMHomeImprovementProductType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FNMHomeImprovementProductType Reference Value (Bound to Domain) |
| Name | ValidationRule165 |
| Description | |
| Type | By List |
| Value | Value Description |
| ActualActualBiweekly | ActualActualBiweekly |
| ConstructionToPermanent | ConstructionToPermanent |
| DailySimpleInterestCashConventional | DailySimpleInterestCashConventional |
| DailySimpleInterestMBS | DailySimpleInterestMBS |
| GovernmentTitleI | GovernmentTitleI |
| Universal | Universal |
| FNMHomeImprovementProductType Bound Attachments |
| Name | Current Value |
| FNMHomeImprovementProductType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FNMHomeImprovementProductType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FNMHomeImprovementProductType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FNMHomeImprovementProductType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FNMHomeImprovementProductType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| GFEComparisonType |
| Base Entity | LOAN_PRODUCT_DETAIL |
| Attribute Name | GFEComparisonType |
| Logical Rolename | |
| ColumnName | GFEComparisonType |
| RoleName | |
| Domain | GFEComparisonEnum |
| Definition | Specifies how the loan conditions have been changed for this comparison instance for the purposes of GFE requirements. |
| Note |
| GFEComparisonType Logical Attribute Properties |
| Logical Attribute Name | GFEComparisonType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| GFEComparisonType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| GFEComparisonType Reference Value (Bound to Domain) |
| Name | ValidationRule187 |
| Description | |
| Type | By List |
| Value | Value Description |
| NotApplicable | NotApplicable |
| Other | Other |
| SameLoanWithLowerInterestRate | SameLoanWithLowerInterestRate |
| SameLoanWithLowerSettlementCharges | SameLoanWithLowerSettlementCharges |
| GFEComparisonType Bound Attachments |
| Name | Current Value |
| GFEComparisonType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| GFEComparisonType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| GFEComparisonType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| GFEComparisonType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| GFEComparisonType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| GFEComparisonTypeOtherDescription |
| Base Entity | LOAN_PRODUCT_DETAIL |
| Attribute Name | GFEComparisonTypeOtherDescription |
| Logical Rolename | |
| ColumnName | GFEComparisonTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free-form text field which contains the description of the GFE comparison type when Other is selected as the GFE Comparison Type. |
| Note |
| GFEComparisonTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | GFEComparisonTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| GFEComparisonTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| GFEComparisonTypeOtherDescription Bound Attachments |
| Name | Current Value |
| GFEComparisonTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| GFEComparisonTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| GFEComparisonTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| GFEComparisonTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| GFEComparisonTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanProductStatusType |
| Base Entity | LOAN_PRODUCT_DETAIL |
| Attribute Name | LoanProductStatusType |
| Logical Rolename | |
| ColumnName | LoanProductStatusType |
| RoleName | |
| Domain | LoanProductStatusEnum |
| Definition | The status of the particular loan product. |
| Note |
| LoanProductStatusType Logical Attribute Properties |
| Logical Attribute Name | LoanProductStatusType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| LoanProductStatusType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LoanProductStatusType Reference Value (Bound to Domain) |
| Name | ValidationRule269 |
| Description | |
| Type | By List |
| Value | Value Description |
| Available | Available |
| Eligible | Eligible |
| Ineligible | Ineligible |
| Offered | Offered |
| Requested | Requested |
| Selected | Selected |
| LoanProductStatusType Bound Attachments |
| Name | Current Value |
| LoanProductStatusType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LoanProductStatusType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanProductStatusType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanProductStatusType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanProductStatusType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NegotiatedRequirementDescription |
| Base Entity | LOAN_PRODUCT_DETAIL |
| Attribute Name | NegotiatedRequirementDescription |
| Logical Rolename | |
| ColumnName | NegotiatedRequirementDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | Describes an addition or exception to standard requirements. |
| Note |
| NegotiatedRequirementDescription Logical Attribute Properties |
| Logical Attribute Name | NegotiatedRequirementDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| NegotiatedRequirementDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| NegotiatedRequirementDescription Bound Attachments |
| Name | Current Value |
| NegotiatedRequirementDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| NegotiatedRequirementDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NegotiatedRequirementDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NegotiatedRequirementDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NegotiatedRequirementDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OriginationPointsOrFeesTotalAmount |
| Base Entity | LOAN_PRODUCT_DETAIL |
| Attribute Name | OriginationPointsOrFeesTotalAmount |
| Logical Rolename | |
| ColumnName | OriginationPointsOrFeesTotalAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The total dollar amount estimated or paid as origination points or fees for this loan product at the selected rate. |
| Note |
| OriginationPointsOrFeesTotalAmount Logical Attribute Properties |
| Logical Attribute Name | OriginationPointsOrFeesTotalAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| OriginationPointsOrFeesTotalAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| OriginationPointsOrFeesTotalAmount Bound Attachments |
| Name | Current Value |
| OriginationPointsOrFeesTotalAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| OriginationPointsOrFeesTotalAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OriginationPointsOrFeesTotalAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OriginationPointsOrFeesTotalAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OriginationPointsOrFeesTotalAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OriginationPointsOrFeesTotalRatePercent |
| Base Entity | LOAN_PRODUCT_DETAIL |
| Attribute Name | OriginationPointsOrFeesTotalRatePercent |
| Logical Rolename | |
| ColumnName | OriginationPointsOrFeesTotalRatePercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The total dollar amount estimated or paid as origination points or fees for this loan product, reflected as a percentage of the loan amount. |
| Note |
| OriginationPointsOrFeesTotalRatePercent Logical Attribute Properties |
| Logical Attribute Name | OriginationPointsOrFeesTotalRatePercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| OriginationPointsOrFeesTotalRatePercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| OriginationPointsOrFeesTotalRatePercent Bound Attachments |
| Name | Current Value |
| OriginationPointsOrFeesTotalRatePercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| OriginationPointsOrFeesTotalRatePercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OriginationPointsOrFeesTotalRatePercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OriginationPointsOrFeesTotalRatePercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OriginationPointsOrFeesTotalRatePercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProductDescription |
| Base Entity | LOAN_PRODUCT_DETAIL |
| Attribute Name | ProductDescription |
| Logical Rolename | |
| ColumnName | ProductDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free-form text description of a Product, which is a provider-defined offering of goods or services, including mortgage loans. |
| Note |
| ProductDescription Logical Attribute Properties |
| Logical Attribute Name | ProductDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| ProductDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ProductDescription Bound Attachments |
| Name | Current Value |
| ProductDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ProductDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProductDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProductDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProductDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProductIdentifier |
| Base Entity | LOAN_PRODUCT_DETAIL |
| Attribute Name | ProductIdentifier |
| Logical Rolename | |
| ColumnName | ProductIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | The providers unique identifier of a product, which is a provider-defined offering of goods or services, including mortgage loans. |
| Note |
| ProductIdentifier Logical Attribute Properties |
| Logical Attribute Name | ProductIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| ProductIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ProductIdentifier Bound Attachments |
| Name | Current Value |
| ProductIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ProductIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProductIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProductIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProductIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProductName |
| Base Entity | LOAN_PRODUCT_DETAIL |
| Attribute Name | ProductName |
| Logical Rolename | |
| ColumnName | ProductName |
| RoleName | |
| Domain | MISMOString |
| Definition | The business name of a product, which is a provider defined offering of goods or services, including mortgage loans. |
| Note |
| ProductName Logical Attribute Properties |
| Logical Attribute Name | ProductName |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| ProductName Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ProductName Bound Attachments |
| Name | Current Value |
| ProductName User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ProductName Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProductName Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProductName Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProductName Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProductProviderName |
| Base Entity | LOAN_PRODUCT_DETAIL |
| Attribute Name | ProductProviderName |
| Logical Rolename | |
| ColumnName | ProductProviderName |
| RoleName | |
| Domain | MISMOString |
| Definition | The name of the provider of the defined offering of goods or services. |
| Note |
| ProductProviderName Logical Attribute Properties |
| Logical Attribute Name | ProductProviderName |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| ProductProviderName Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ProductProviderName Bound Attachments |
| Name | Current Value |
| ProductProviderName User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ProductProviderName Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProductProviderName Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProductProviderName Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProductProviderName Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProductProviderType |
| Base Entity | LOAN_PRODUCT_DETAIL |
| Attribute Name | ProductProviderType |
| Logical Rolename | |
| ColumnName | ProductProviderType |
| RoleName | |
| Domain | ProductProviderEnum |
| Definition | Specifies the role of the provider of the defined offering of goods or services. |
| Note |
| ProductProviderType Logical Attribute Properties |
| Logical Attribute Name | ProductProviderType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| ProductProviderType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ProductProviderType Reference Value (Bound to Domain) |
| Name | ValidationRule276 |
| Description | |
| Type | By List |
| Value | Value Description |
| Investor | Investor |
| Lender | Lender |
| Other | Other |
| ProductProviderType Bound Attachments |
| Name | Current Value |
| ProductProviderType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ProductProviderType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProductProviderType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProductProviderType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProductProviderType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProductProviderTypeOtherDescription |
| Base Entity | LOAN_PRODUCT_DETAIL |
| Attribute Name | ProductProviderTypeOtherDescription |
| Logical Rolename | |
| ColumnName | ProductProviderTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free form text field used to collect additional information when Other is selected for Product Provider Type. |
| Note |
| ProductProviderTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | ProductProviderTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| ProductProviderTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ProductProviderTypeOtherDescription Bound Attachments |
| Name | Current Value |
| ProductProviderTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ProductProviderTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProductProviderTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProductProviderTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProductProviderTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RefinanceProgramIdentifier |
| Base Entity | LOAN_PRODUCT_DETAIL |
| Attribute Name | RefinanceProgramIdentifier |
| Logical Rolename | |
| ColumnName | RefinanceProgramIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | Identifies the refinance program associated with the loan as identified by a specific entity. |
| Note |
| RefinanceProgramIdentifier Logical Attribute Properties |
| Logical Attribute Name | RefinanceProgramIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| RefinanceProgramIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RefinanceProgramIdentifier Bound Attachments |
| Name | Current Value |
| RefinanceProgramIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| RefinanceProgramIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RefinanceProgramIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RefinanceProgramIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RefinanceProgramIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SettlementChargesAmount |
| Base Entity | LOAN_PRODUCT_DETAIL |
| Attribute Name | SettlementChargesAmount |
| Logical Rolename | |
| ColumnName | SettlementChargesAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The total dollar amount estimated or paid as settlement charges for this loan product. |
| Note |
| SettlementChargesAmount Logical Attribute Properties |
| Logical Attribute Name | SettlementChargesAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| SettlementChargesAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SettlementChargesAmount Bound Attachments |
| Name | Current Value |
| SettlementChargesAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| SettlementChargesAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SettlementChargesAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SettlementChargesAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SettlementChargesAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |