| FeeBorrowerChosenProviderIndicator |
| Base Entity | FEE_DETAIL |
| Attribute Name | FeeBorrowerChosenProviderIndicator |
| Logical Rolename | |
| ColumnName | FeeBorrowerChosenProviderIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | When true, indicates the provider of the service for which the particular fee is charged was selected by the borrower independent of the lender or lender-provided list. |
| Note |
| FeeBorrowerChosenProviderIndicator Logical Attribute Properties |
| Logical Attribute Name | FeeBorrowerChosenProviderIndicator |
| Datatype | BIT |
| Nullable | NO |
| FeeBorrowerChosenProviderIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FeeBorrowerChosenProviderIndicator Bound Attachments |
| Name | Current Value |
| FeeBorrowerChosenProviderIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FeeBorrowerChosenProviderIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeeBorrowerChosenProviderIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeeBorrowerChosenProviderIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeeBorrowerChosenProviderIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeeItemDescription |
| Base Entity | FEE_DETAIL |
| Attribute Name | FeeItemDescription |
| Logical Rolename | |
| ColumnName | FeeItemDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | The description of the Fee item. |
| Note |
| FeeItemDescription Logical Attribute Properties |
| Logical Attribute Name | FeeItemDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| FeeItemDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FeeItemDescription Bound Attachments |
| Name | Current Value |
| FeeItemDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FeeItemDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeeItemDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeeItemDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeeItemDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeePaidToType |
| Base Entity | FEE_DETAIL |
| Attribute Name | FeePaidToType |
| Logical Rolename | |
| ColumnName | FeePaidToType |
| RoleName | |
| Domain | FeePaidToEnum |
| Definition | Identifies the category or type of payee to which the fee will be paid |
| Note |
| FeePaidToType Logical Attribute Properties |
| Logical Attribute Name | FeePaidToType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| FeePaidToType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FeePaidToType Reference Value (Bound to Domain) |
| Name | ValidationRule168 |
| Description | |
| Type | By List |
| Value | Value Description |
| Affiliate | Affiliate |
| AffiliateProvider | Fee is being paid to a third party provider who is an affiliate of the Lender or Broker. |
| Broker | Broker |
| Investor | Investor |
| Lender | Lender |
| Other | Other |
| Provider | Fee is being paid to a third party provider. |
| FeePaidToType Bound Attachments |
| Name | Current Value |
| FeePaidToType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FeePaidToType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeePaidToType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeePaidToType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeePaidToType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeePaidToTypeOtherDescription |
| Base Entity | FEE_DETAIL |
| Attribute Name | FeePaidToTypeOtherDescription |
| Logical Rolename | |
| ColumnName | FeePaidToTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free-form text field to capture the description when Other is selected as Fee Paid To Type. |
| Note |
| FeePaidToTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | FeePaidToTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| FeePaidToTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FeePaidToTypeOtherDescription Bound Attachments |
| Name | Current Value |
| FeePaidToTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FeePaidToTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeePaidToTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeePaidToTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeePaidToTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeePercentBasisType |
| Base Entity | FEE_DETAIL |
| Attribute Name | FeePercentBasisType |
| Logical Rolename | |
| ColumnName | FeePercentBasisType |
| RoleName | |
| Domain | FeePercentBasisEnum |
| Definition | Defines the amount upon which the Fee Total Percent is calculated. |
| Note |
| FeePercentBasisType Logical Attribute Properties |
| Logical Attribute Name | FeePercentBasisType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| FeePercentBasisType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FeePercentBasisType Reference Value (Bound to Domain) |
| Name | ValidationRule172 |
| Description | |
| Type | By List |
| Value | Value Description |
| BaseLoanAmount | BaseLoanAmount |
| OriginalLoanAmount | OriginalLoanAmount |
| Other | Other |
| PropertyAppraisedValueAmount | PropertyAppraisedValueAmount |
| PurchasePriceAmount | PurchasePriceAmount |
| FeePercentBasisType Bound Attachments |
| Name | Current Value |
| FeePercentBasisType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FeePercentBasisType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeePercentBasisType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeePercentBasisType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeePercentBasisType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeePercentBasisTypeOtherDescription |
| Base Entity | FEE_DETAIL |
| Attribute Name | FeePercentBasisTypeOtherDescription |
| Logical Rolename | |
| ColumnName | FeePercentBasisTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free-form text field used to collect additional information when Other is selected for Fee Percent Basis Type. |
| Note |
| FeePercentBasisTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | FeePercentBasisTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| FeePercentBasisTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FeePercentBasisTypeOtherDescription Bound Attachments |
| Name | Current Value |
| FeePercentBasisTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FeePercentBasisTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeePercentBasisTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeePercentBasisTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeePercentBasisTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeeRequiredProviderOfServiceIndicator |
| Base Entity | FEE_DETAIL |
| Attribute Name | FeeRequiredProviderOfServiceIndicator |
| Logical Rolename | |
| ColumnName | FeeRequiredProviderOfServiceIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | When true, indicates a required Provider of Service is associated with this fee. |
| Note |
| FeeRequiredProviderOfServiceIndicator Logical Attribute Properties |
| Logical Attribute Name | FeeRequiredProviderOfServiceIndicator |
| Datatype | BIT |
| Nullable | NO |
| FeeRequiredProviderOfServiceIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FeeRequiredProviderOfServiceIndicator Bound Attachments |
| Name | Current Value |
| FeeRequiredProviderOfServiceIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FeeRequiredProviderOfServiceIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeeRequiredProviderOfServiceIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeeRequiredProviderOfServiceIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeeRequiredProviderOfServiceIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeeSpecifiedFixedAmount |
| Base Entity | FEE_DETAIL |
| Attribute Name | FeeSpecifiedFixedAmount |
| Logical Rolename | |
| ColumnName | FeeSpecifiedFixedAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The specified fixed dollar portion of the Fee Total Amount. This is used when the Fee Total Amount is made up of a percentage (stated in the Fee Total Percent) plus a specified fixed dollar amount. |
| Note |
| FeeSpecifiedFixedAmount Logical Attribute Properties |
| Logical Attribute Name | FeeSpecifiedFixedAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| FeeSpecifiedFixedAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FeeSpecifiedFixedAmount Bound Attachments |
| Name | Current Value |
| FeeSpecifiedFixedAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FeeSpecifiedFixedAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeeSpecifiedFixedAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeeSpecifiedFixedAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeeSpecifiedFixedAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeeSpecifiedHUD1LineNumberValue |
| Base Entity | FEE_DETAIL |
| Attribute Name | FeeSpecifiedHUD1LineNumberValue |
| Logical Rolename | |
| ColumnName | FeeSpecifiedHUD1LineNumberValue |
| RoleName | |
| Domain | MISMOValue |
| Definition | HUD Line Number for fee items that pertain to miscellaneous sections of the HUD form where there is not a one-to-one mapping between the line number and the line description. |
| Note |
| FeeSpecifiedHUD1LineNumberValue Logical Attribute Properties |
| Logical Attribute Name | FeeSpecifiedHUD1LineNumberValue |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| FeeSpecifiedHUD1LineNumberValue Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FeeSpecifiedHUD1LineNumberValue Bound Attachments |
| Name | Current Value |
| FeeSpecifiedHUD1LineNumberValue User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FeeSpecifiedHUD1LineNumberValue Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeeSpecifiedHUD1LineNumberValue Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeeSpecifiedHUD1LineNumberValue Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeeSpecifiedHUD1LineNumberValue Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeeTotalAmount |
| Base Entity | FEE_DETAIL |
| Attribute Name | FeeTotalAmount |
| Logical Rolename | |
| ColumnName | FeeTotalAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The total dollar amount paid by all parties for the specified Fee or Specified HUD Line Number. |
| Note |
| FeeTotalAmount Logical Attribute Properties |
| Logical Attribute Name | FeeTotalAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| FeeTotalAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FeeTotalAmount Bound Attachments |
| Name | Current Value |
| FeeTotalAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FeeTotalAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeeTotalAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeeTotalAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeeTotalAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeeTotalPercent |
| Base Entity | FEE_DETAIL |
| Attribute Name | FeeTotalPercent |
| Logical Rolename | |
| ColumnName | FeeTotalPercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The total percent paid by all parties for the specified Fee or Specified HUD Line Number. This is used in conjunction with the Fee Percent Basis Type to determine a dollar amount of the fee. May be used in conjunction with Specified Fixed Amount to determ |
| Note |
| FeeTotalPercent Logical Attribute Properties |
| Logical Attribute Name | FeeTotalPercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| FeeTotalPercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FeeTotalPercent Bound Attachments |
| Name | Current Value |
| FeeTotalPercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FeeTotalPercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeeTotalPercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeeTotalPercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeeTotalPercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeeType |
| Base Entity | FEE_DETAIL |
| Attribute Name | FeeType |
| Logical Rolename | |
| ColumnName | FeeType |
| RoleName | |
| Domain | FeeEnum |
| Definition | Specifies the general names (type) of fees associated with the Good Faith Estimate/HUD-1. |
| Note |
| FeeType Logical Attribute Properties |
| Logical Attribute Name | FeeType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| FeeType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FeeType Reference Value (Bound to Domain) |
| Name | ValidationRule167 |
| Description | |
| Type | By List |
| Value | Value Description |
| 203KArchitecturalAndEngineeringFee | 203KArchitecturalAndEngineeringFee |
| 203KConsultantFee | 203KConsultantFee |
| 203KDiscountOnRepairs | 203KDiscountOnRepairs |
| 203KInspectionFee | 203KInspectionFee |
| 203KPermits | 203KPermits |
| 203KSupplementalOriginationFee | 203KSupplementalOriginationFee |
| 203KTitleUpdate | 203KTitleUpdate |
| AbstractOrTitleSearchFee | AbstractOrTitleSearchFee |
| AmortizationFee | AmortizationFee |
| ApplicationFee | ApplicationFee |
| AppraisalFee | AppraisalFee |
| AppraisalDeskReviewFee | Fee charged for reviewing an appraisal report and performing some basic research on value without going out to the field to view the property or the comparable properties included in the appraisal report. |
| AppraisalFieldReviewFee | Fee charged for performing an appraisal review in the field – actually inspecting the property and comparable properties. |
| AssignmentFee | AssignmentFee |
| AssignmentRecordingFee | AssignmentRecordingFee |
| AssumptionFee | AssumptionFee |
| AttorneyFee | AttorneyFee |
| BankruptcyMonitoringFee | Monitoring or Proof of Claim Fee charged as a result of a bankruptcy filing by the Borrower. |
| BondFee | Fee paid to a state or local housing agency to participate in a special lending program. |
| BondReviewFee | BondReviewFee |
| CertificationFee | Fee charged to prepare and submit to the Home Owner’s, Condominium, or Co-Op Association Certification for the property securing the loan. |
| ChosenInterestRateCreditOrChargeTotal | ChosenInterestRateCreditOrChargeTotal |
| CityCountyDeedTaxStampFee | CityCountyDeedTaxStampFee |
| CityCountyMortgageTaxStampFee | CityCountyMortgageTaxStampFee |
| CLOAccessFee | CLOAccessFee |
| ClosingProtectionLetterFee | Fee charged for a statement or document issued by title insurance underwriters that sets forth the responsibility for negligence of an underwriter , fraud and errors in closings performed by the agents of the underwriter and approved attorneys. |
| CommitmentFee | CommitmentFee |
| CopyOrFaxFee | CopyOrFaxFee |
| CourierFee | CourierFee |
| CreditReportFee | CreditReportFee |
| DeedRecordingFee | DeedRecordingFee |
| DocumentaryStampFee | DocumentaryStampFee |
| DocumentPreparationFee | DocumentPreparationFee |
| ElectronicDocumentDeliveryFee | Fee for transmitting or receiving the loan documents through email or by some other electronic means. |
| EscrowServiceFee | Fee to set up and service the escrow account for the loan. |
| EscrowWaiverFee | EscrowWaiverFee |
| FloodCertification | FloodCertification |
| GeneralCounselFee | GeneralCounselFee |
| InspectionFee | InspectionFee |
| LoanDiscountPoints | LoanDiscountPoints |
| LoanOriginationFee | LoanOriginationFee |
| MERSRegistrationFee | Fee charged for registering/transferring the loan onto the Mortgage Electronic Registration System. |
| MIUpfrontPremium | The dollar amount of MI premium (PMI or FHA) charged to the borrower at time of closing. One time payment made at closing beyond the monthly or annual premiums. |
| MIInitialPremium | Amount of the first premium paid to MI. For monthly plans, one months premium; for all other plans, Initial Premium Rate times Base Loan Amount. |
| ModificationFee | ModificationFee |
| MortgageBrokerFee | MortgageBrokerFee |
| MortgageRecordingFee | MortgageRecordingFee |
| MunicipalLienCertificateFee | MunicipalLienCertificateFee |
| MunicipalLienCertificateRecordingFee | MunicipalLienCertificateRecordingFee |
| NewLoanAdministrationFee | NewLoanAdministrationFee |
| NotaryFee | NotaryFee |
| Other | Other |
| OurOriginationChargeTotal | OurOriginationChargeTotal |
| PayoffRequestFee | In refinances, fee paid to prior lender to prepare and provide a bookkeeping statement of how much is owed on the loan being refinanced. |
| PestInspectionFee | PestInspectionFee |
| ProcessingFee | ProcessingFee |
| RealEstateCommission | RealEstateCommission |
| RedrawFee | RedrawFee |
| ReinspectionFee | ReinspectionFee |
| ReleaseRecordingFee | ReleaseRecordingFee |
| USDARuralDevelopmentGuaranteeFee | A one-time financing fee the borrower pays at closing for USDA Rural Development loans in lieu of mortgage insurance. |
| SettlementOrClosingFee | SettlementOrClosingFee |
| SigningAgentFee | Fee charged for the services of a signing agent who, as an accommodation of the borrower, closes the loan at a specific time or at a location requested by the borrower. |
| StateDeedTaxStampFee | StateDeedTaxStampFee |
| StateMortgageTaxStampFee | StateMortgageTaxStampFee |
| SubordinationFee | Fee paid to a lien holder with an existing lien on the property to subordinate its lien position to the Lender in the current loan. |
| SurveyFee | SurveyFee |
| TaxRelatedServiceFee | TaxRelatedServiceFee |
| TitleEndorsementFee | Fee charged for obtaining a title endorsement (for which the original lender and/or borrower are the beneficiaries) that relates to the closing of the mortgage loan. |
| TitleExaminationFee | TitleExaminationFee |
| TitleInsuranceBinderFee | TitleInsuranceBinderFee |
| TitleInsuranceFee | TitleInsuranceFee |
| TitleServicesFeeTotal | TitleServicesFeeTotal |
| UnderwritingFee | UnderwritingFee |
| VAFundingFee | VAFundingFee |
| WireTransferFee | Fee for wiring funds in connection with the loan. |
| FeeType Bound Attachments |
| Name | Current Value |
| FeeType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FeeType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeeType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeeType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeeType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeeTypeOtherDescription |
| Base Entity | FEE_DETAIL |
| Attribute Name | FeeTypeOtherDescription |
| Logical Rolename | |
| ColumnName | FeeTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free-form test field used to capture the description of Other fee from Fee Type. |
| Note |
| FeeTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | FeeTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| FeeTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FeeTypeOtherDescription Bound Attachments |
| Name | Current Value |
| FeeTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FeeTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeeTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeeTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FeeTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| GFEAggregationType |
| Base Entity | FEE_DETAIL |
| Attribute Name | GFEAggregationType |
| Logical Rolename | |
| ColumnName | GFEAggregationType |
| RoleName | |
| Domain | GFEAggregationEnum |
| Definition | Specifies the fee or charges group, combined fee or charges category, or compensation category, to which the individual fee or charge should be associated, as reflected on a single instance of the GFE. |
| Note |
| GFEAggregationType Logical Attribute Properties |
| Logical Attribute Name | GFEAggregationType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| GFEAggregationType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| GFEAggregationType Reference Value (Bound to Domain) |
| Name | ValidationRule186 |
| Description | |
| Type | By List |
| Value | Value Description |
| ChosenInterestRateCreditOrCharge | ChosenInterestRateCreditOrCharge |
| CombinedOurOriginationAndInterestRateCreditOrCharge | CombinedOurOriginationAndInterestRateCreditOrCharge |
| GovernmentRecordingCharges | GovernmentRecordingCharges |
| HomeownersInsurance | HomeownersInsurance |
| None | None |
| Other | Other |
| OurOriginationCharge | OurOriginationCharge |
| OwnersTitleInsurance | OwnersTitleInsurance |
| RequiredServicesLenderSelected | RequiredServicesLenderSelected |
| RequiredServicesYouCanShopFor | RequiredServicesYouCanShopFor |
| TitleServices | TitleServices |
| TransferTaxes | TransferTaxes |
| GFEAggregationType Bound Attachments |
| Name | Current Value |
| GFEAggregationType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| GFEAggregationType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| GFEAggregationType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| GFEAggregationType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| GFEAggregationType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| GFEAggregationTypeOtherDescription |
| Base Entity | FEE_DETAIL |
| Attribute Name | GFEAggregationTypeOtherDescription |
| Logical Rolename | |
| ColumnName | GFEAggregationTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free form text field used to collect additional information when Other is selected for GFE Aggregation Type. |
| Note |
| GFEAggregationTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | GFEAggregationTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| GFEAggregationTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| GFEAggregationTypeOtherDescription Bound Attachments |
| Name | Current Value |
| GFEAggregationTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| GFEAggregationTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| GFEAggregationTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| GFEAggregationTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| GFEAggregationTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| GFEDisclosedFeeAmount |
| Base Entity | FEE_DETAIL |
| Attribute Name | GFEDisclosedFeeAmount |
| Logical Rolename | |
| ColumnName | GFEDisclosedFeeAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The dollar amount, as disclosed on a single instance of the GFE, for the specified RESPA Fee or Specified HUD Line Number. |
| Note |
| GFEDisclosedFeeAmount Logical Attribute Properties |
| Logical Attribute Name | GFEDisclosedFeeAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| GFEDisclosedFeeAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| GFEDisclosedFeeAmount Bound Attachments |
| Name | Current Value |
| GFEDisclosedFeeAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| GFEDisclosedFeeAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| GFEDisclosedFeeAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| GFEDisclosedFeeAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| GFEDisclosedFeeAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SectionClassificationType |
| Base Entity | FEE_DETAIL |
| Attribute Name | SectionClassificationType |
| Logical Rolename | |
| ColumnName | SectionClassificationType |
| RoleName | |
| Domain | SectionClassificationEnum |
| Definition | The section number on the Good Faith Estimate/HUD-1 associated with a fee type. |
| Note |
| SectionClassificationType Logical Attribute Properties |
| Logical Attribute Name | SectionClassificationType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| SectionClassificationType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SectionClassificationType Reference Value (Bound to Domain) |
| Name | ValidationRule442 |
| Description | |
| Type | By List |
| Value | Value Description |
| 100 | Gross Amount Due From Borrower |
| 1000 | Reserves Deposited With Lender |
| 1100 | Title Charges |
| 1200 | Recording And Transfer Charges |
| 1300 | Additional Settlement Charges |
| 200 | Amounts Paid By Or In Behalf Of Borrower |
| 300 | Cash At Settlement From To Borrower |
| 400 | Gross Amount Due To Seller |
| 500 | Reductions In Amount Due Seller |
| 600 | Cash At Settlement To From Seller |
| 700 | Division Of Commissions |
| 800 | Loan Fees |
| 900 | Lender Required Paid In Advance |
| SectionClassificationType Bound Attachments |
| Name | Current Value |
| SectionClassificationType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| SectionClassificationType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SectionClassificationType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SectionClassificationType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SectionClassificationType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |