GFECreditOrChargeForChosenInterestRateType |
Base Entity | GFE_DETAIL |
Attribute Name | GFECreditOrChargeForChosenInterestRateType |
Logical Rolename | |
ColumnName | GFECreditOrChargeForChosenInterestRateType |
RoleName | |
Domain | GFECreditOrChargeForChosenInterestRateEnum |
Definition | Identifies the type of credit or charge to the Borrower associated with the Borrower chosen interest rate, as reflected on a single instance of the GFE. |
Note |
GFECreditOrChargeForChosenInterestRateType Logical Attribute Properties |
Logical Attribute Name | GFECreditOrChargeForChosenInterestRateType |
Datatype | VARCHAR(0) |
Nullable | YES |
GFECreditOrChargeForChosenInterestRateType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
GFECreditOrChargeForChosenInterestRateType Reference Value (Bound to Domain) |
Name | ValidationRule188 |
Description | |
Type | By List |
Value | Value Description |
BorrowerCharge | BorrowerCharge |
BorrowerCredit | BorrowerCredit |
CreditOrChargeIncludedInOriginationCharge | CreditOrChargeIncludedInOriginationCharge |
Other | Other |
GFECreditOrChargeForChosenInterestRateType Bound Attachments |
Name | Current Value |
GFECreditOrChargeForChosenInterestRateType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
GFECreditOrChargeForChosenInterestRateType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
GFECreditOrChargeForChosenInterestRateType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
GFECreditOrChargeForChosenInterestRateType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
GFECreditOrChargeForChosenInterestRateType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
GFECreditOrChargeForChosenInterestRateTypeOtherDescription |
Base Entity | GFE_DETAIL |
Attribute Name | GFECreditOrChargeForChosenInterestRateTypeOtherDescription |
Logical Rolename | |
ColumnName | GFECreditOrChargeForChosenInterestRateTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free-form text field which contains the description of the type of GFE credit or charge when Other is selected as the GFE Credit Or Charge For Chosen Interest Rate Type |
Note |
GFECreditOrChargeForChosenInterestRateTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | GFECreditOrChargeForChosenInterestRateTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
GFECreditOrChargeForChosenInterestRateTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
GFECreditOrChargeForChosenInterestRateTypeOtherDescription Bound Attachments |
Name | Current Value |
GFECreditOrChargeForChosenInterestRateTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
GFECreditOrChargeForChosenInterestRateTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
GFECreditOrChargeForChosenInterestRateTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
GFECreditOrChargeForChosenInterestRateTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
GFECreditOrChargeForChosenInterestRateTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
GFEDisclosureDate |
Base Entity | GFE_DETAIL |
Attribute Name | GFEDisclosureDate |
Logical Rolename | |
ColumnName | GFEDisclosureDate |
RoleName | |
Domain | MISMODate |
Definition | The date as reflected on a single instance of the Good Faith Estimate. |
Note |
GFEDisclosureDate Logical Attribute Properties |
Logical Attribute Name | GFEDisclosureDate |
Datatype | DATE |
Nullable | NO |
GFEDisclosureDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
GFEDisclosureDate Bound Attachments |
Name | Current Value |
GFEDisclosureDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
GFEDisclosureDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
GFEDisclosureDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
GFEDisclosureDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
GFEDisclosureDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
GFEInterestRateAvailableThroughDate |
Base Entity | GFE_DETAIL |
Attribute Name | GFEInterestRateAvailableThroughDate |
Logical Rolename | |
ColumnName | GFEInterestRateAvailableThroughDate |
RoleName | |
Domain | MISMODate |
Definition | Specifies the date through which the initial interest rate, as reflected on a single instance of the GFE, is available. |
Note |
GFEInterestRateAvailableThroughDate Logical Attribute Properties |
Logical Attribute Name | GFEInterestRateAvailableThroughDate |
Datatype | DATE |
Nullable | NO |
GFEInterestRateAvailableThroughDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
GFEInterestRateAvailableThroughDate Bound Attachments |
Name | Current Value |
GFEInterestRateAvailableThroughDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
GFEInterestRateAvailableThroughDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
GFEInterestRateAvailableThroughDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
GFEInterestRateAvailableThroughDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
GFEInterestRateAvailableThroughDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
GFELoanOriginatorFeePaymentCreditType |
Base Entity | GFE_DETAIL |
Attribute Name | GFELoanOriginatorFeePaymentCreditType |
Logical Rolename | |
ColumnName | GFELoanOriginatorFeePaymentCreditType |
RoleName | |
Domain | GFELoanOriginatorFeePaymentCreditEnum |
Definition | Identifies the type of application of loan originator credit(s) to be reflected on the GFE and the HUD1. |
Note |
GFELoanOriginatorFeePaymentCreditType Logical Attribute Properties |
Logical Attribute Name | GFELoanOriginatorFeePaymentCreditType |
Datatype | VARCHAR(0) |
Nullable | YES |
GFELoanOriginatorFeePaymentCreditType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
GFELoanOriginatorFeePaymentCreditType Reference Value (Bound to Domain) |
Name | ValidationRule189 |
Description | |
Type | By List |
Value | Value Description |
AmountsPaidByOrInBehalfOfBorrower | AmountsPaidByOrInBehalfOfBorrower |
ChosenInterestRateCreditOrCharge | ChosenInterestRateCreditOrCharge |
Other | Other |
GFELoanOriginatorFeePaymentCreditType Bound Attachments |
Name | Current Value |
GFELoanOriginatorFeePaymentCreditType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
GFELoanOriginatorFeePaymentCreditType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
GFELoanOriginatorFeePaymentCreditType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
GFELoanOriginatorFeePaymentCreditType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
GFELoanOriginatorFeePaymentCreditType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
GFELoanOriginatorFeePaymentCreditTypeOtherDescription |
Base Entity | GFE_DETAIL |
Attribute Name | GFELoanOriginatorFeePaymentCreditTypeOtherDescription |
Logical Rolename | |
ColumnName | GFELoanOriginatorFeePaymentCreditTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free-form text field which contains the description of the type of loan originator credit(s) when Other is selected as the GFE Loan Originator Fee Payment Credit Type. |
Note |
GFELoanOriginatorFeePaymentCreditTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | GFELoanOriginatorFeePaymentCreditTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
GFELoanOriginatorFeePaymentCreditTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
GFELoanOriginatorFeePaymentCreditTypeOtherDescription Bound Attachments |
Name | Current Value |
GFELoanOriginatorFeePaymentCreditTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
GFELoanOriginatorFeePaymentCreditTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
GFELoanOriginatorFeePaymentCreditTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
GFELoanOriginatorFeePaymentCreditTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
GFELoanOriginatorFeePaymentCreditTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
GFEMonthlyPaymentFirstIncreasePaymentAmount |
Base Entity | GFE_DETAIL |
Attribute Name | GFEMonthlyPaymentFirstIncreasePaymentAmount |
Logical Rolename | |
ColumnName | GFEMonthlyPaymentFirstIncreasePaymentAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The amount of the monthly loan payment (comprised of prinicpal and interest and monthly MI) after the first payment increase is in effect, as reflected on a single instance of the GFE. |
Note |
GFEMonthlyPaymentFirstIncreasePaymentAmount Logical Attribute Properties |
Logical Attribute Name | GFEMonthlyPaymentFirstIncreasePaymentAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
GFEMonthlyPaymentFirstIncreasePaymentAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
GFEMonthlyPaymentFirstIncreasePaymentAmount Bound Attachments |
Name | Current Value |
GFEMonthlyPaymentFirstIncreasePaymentAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
GFEMonthlyPaymentFirstIncreasePaymentAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
GFEMonthlyPaymentFirstIncreasePaymentAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
GFEMonthlyPaymentFirstIncreasePaymentAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
GFEMonthlyPaymentFirstIncreasePaymentAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
GFEMonthlyPaymentMaximumAmount |
Base Entity | GFE_DETAIL |
Attribute Name | GFEMonthlyPaymentMaximumAmount |
Logical Rolename | |
ColumnName | GFEMonthlyPaymentMaximumAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The maximum amount of the monthly loan payment (comprised of prinicpal and interest and monthly MI) that may be due, as reflected on a single instance of the GFE. |
Note |
GFEMonthlyPaymentMaximumAmount Logical Attribute Properties |
Logical Attribute Name | GFEMonthlyPaymentMaximumAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
GFEMonthlyPaymentMaximumAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
GFEMonthlyPaymentMaximumAmount Bound Attachments |
Name | Current Value |
GFEMonthlyPaymentMaximumAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
GFEMonthlyPaymentMaximumAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
GFEMonthlyPaymentMaximumAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
GFEMonthlyPaymentMaximumAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
GFEMonthlyPaymentMaximumAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
GFERateLockMinimumDaysPriorToSettlementCount |
Base Entity | GFE_DETAIL |
Attribute Name | GFERateLockMinimumDaysPriorToSettlementCount |
Logical Rolename | |
ColumnName | GFERateLockMinimumDaysPriorToSettlementCount |
RoleName | |
Domain | MISMOCount |
Definition | Specifies the minimum number of days before settlement by which the interest rate must be locked, as reflected on a single instance of the GFE. |
Note |
GFERateLockMinimumDaysPriorToSettlementCount Logical Attribute Properties |
Logical Attribute Name | GFERateLockMinimumDaysPriorToSettlementCount |
Datatype | INTEGER |
Nullable | NO |
GFERateLockMinimumDaysPriorToSettlementCount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
GFERateLockMinimumDaysPriorToSettlementCount Bound Attachments |
Name | Current Value |
GFERateLockMinimumDaysPriorToSettlementCount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
GFERateLockMinimumDaysPriorToSettlementCount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
GFERateLockMinimumDaysPriorToSettlementCount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
GFERateLockMinimumDaysPriorToSettlementCount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
GFERateLockMinimumDaysPriorToSettlementCount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
GFERateLockPeriodDaysCount |
Base Entity | GFE_DETAIL |
Attribute Name | GFERateLockPeriodDaysCount |
Logical Rolename | |
ColumnName | GFERateLockPeriodDaysCount |
RoleName | |
Domain | MISMOCount |
Definition | Specifies the length of the rate lock period, in terms of a number of days, as reflected on a single instance of the GFE. |
Note |
GFERateLockPeriodDaysCount Logical Attribute Properties |
Logical Attribute Name | GFERateLockPeriodDaysCount |
Datatype | INTEGER |
Nullable | NO |
GFERateLockPeriodDaysCount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
GFERateLockPeriodDaysCount Bound Attachments |
Name | Current Value |
GFERateLockPeriodDaysCount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
GFERateLockPeriodDaysCount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
GFERateLockPeriodDaysCount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
GFERateLockPeriodDaysCount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
GFERateLockPeriodDaysCount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
GFERedisclosureReasonDate |
Base Entity | GFE_DETAIL |
Attribute Name | GFERedisclosureReasonDate |
Logical Rolename | |
ColumnName | GFERedisclosureReasonDate |
RoleName | |
Domain | MISMODate |
Definition | The date of the occurrence of the circumstance(s) that have changed to warrant redisclosure. |
Note |
GFERedisclosureReasonDate Logical Attribute Properties |
Logical Attribute Name | GFERedisclosureReasonDate |
Datatype | DATE |
Nullable | NO |
GFERedisclosureReasonDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
GFERedisclosureReasonDate Bound Attachments |
Name | Current Value |
GFERedisclosureReasonDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
GFERedisclosureReasonDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
GFERedisclosureReasonDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
GFERedisclosureReasonDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
GFERedisclosureReasonDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
GFERedisclosureReasonDescription |
Base Entity | GFE_DETAIL |
Attribute Name | GFERedisclosureReasonDescription |
Logical Rolename | |
ColumnName | GFERedisclosureReasonDescription |
RoleName | |
Domain | MISMOString |
Definition | The description of the circumstance(s) that have changed to warrant redisclosure. |
Note |
GFERedisclosureReasonDescription Logical Attribute Properties |
Logical Attribute Name | GFERedisclosureReasonDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
GFERedisclosureReasonDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
GFERedisclosureReasonDescription Bound Attachments |
Name | Current Value |
GFERedisclosureReasonDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
GFERedisclosureReasonDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
GFERedisclosureReasonDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
GFERedisclosureReasonDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
GFERedisclosureReasonDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
GFESettlementChargesAvailableThroughDate |
Base Entity | GFE_DETAIL |
Attribute Name | GFESettlementChargesAvailableThroughDate |
Logical Rolename | |
ColumnName | GFESettlementChargesAvailableThroughDate |
RoleName | |
Domain | MISMODate |
Definition | Specifies the date through which the estimated amount for all other settlement charges, as reflected on a single instance of the GFE, is available. |
Note |
GFESettlementChargesAvailableThroughDate Logical Attribute Properties |
Logical Attribute Name | GFESettlementChargesAvailableThroughDate |
Datatype | DATE |
Nullable | NO |
GFESettlementChargesAvailableThroughDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
GFESettlementChargesAvailableThroughDate Bound Attachments |
Name | Current Value |
GFESettlementChargesAvailableThroughDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
GFESettlementChargesAvailableThroughDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
GFESettlementChargesAvailableThroughDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
GFESettlementChargesAvailableThroughDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
GFESettlementChargesAvailableThroughDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |