PROPOSED_HOUSING_EXPENSE Attribute Details

SequenceNumber

Base Entity	PROPOSED_HOUSING_EXPENSE
Attribute Name	SequenceNumber
Logical Rolename
ColumnName	SequenceNumber
RoleName
Domain	XSD:Integer
Definition	An integer value used to provide an order to multi-instance sibling elements. The value must be unique for each sibling element.
Note

SequenceNumber Logical Attribute Properties

Logical Attribute Name SequenceNumber

Datatype INTEGER

Nullable YES

SequenceNumber Domain Restrictions

CheckConstraint

Check Constraint Name

Bound Rule

Declared Default

Bound Default

SequenceNumber Bound Attachments

Name Current Value

SequenceNumber User-Defined Mappings

Model Name RoleName Parent Entity Datatype Domain Description

SequenceNumber Direct Source Mappings

Columns Transformation Logic Transformation Description

SequenceNumber Secondary Source Mappings

Columns Transformation Logic Transformation Description

SequenceNumber Direct Target Mappings

Columns Transformation Logic Transformation Description

SequenceNumber Secondary Target Mappings

Columns Transformation Logic Transformation Description

HousingExpenseType

Base Entity	PROPOSED_HOUSING_EXPENSE
Attribute Name	HousingExpenseType
Logical Rolename
ColumnName	HousingExpenseType
RoleName
Domain	HousingExpenseEnum
Definition	Specifies the general names (types) of housing expense items commonly listed as by the borrower(s) in a mortgage loan transaction. This may be collected on the URLA in Section V.
Note

HousingExpenseType Logical Attribute Properties

Logical Attribute Name HousingExpenseType

Datatype VARCHAR(0)

Nullable YES

HousingExpenseType Domain Restrictions

CheckConstraint

Check Constraint Name

Bound Rule

Declared Default

Bound Default

HousingExpenseType Reference Value (Bound to Domain)

Name ValidationRule205

Description

Type By List

Value Value Description

FirstMortgagePITI Amount of periodic principal and interest payment on a first mortgage on real estate plus annual pro-rata share of property taxes and hazard insurance on the property. Principal refers to the monthly payment that reduces the remaining balance of the mortg

FirstMortgagePrincipalAndInterest Amount of periodic principal and interest payment on a first mortgage on real estate. Could be present or proposed housing expense. Principal refers to the monthly payment that reduces the remaining balance of the mortgage. Interest is the fee charged for

GroundRent GroundRent

HazardInsurance Insurance coverage that provides compensation to insured in case of property damage or loss. (e.g., renters, homeowners, fire, earthquake, flood, etc.) Collected on URLA in Section V (Present / Proposed Housing Expense) and/or Section VI (Schedule of Real

HomeownersAssociationDuesAndCondominiumFees Association to pay the cost of maintaining areas owned in common by all homeowners within a planned unit development. Collected on URLA in Section V (Present / Proposed Housing Expense) and/or Section VI (Schedule of Real Estate).

LeaseholdPayments When land under improvements is leased rather than owned, this is the periodic rent. A form of other housing expense.

MaintenanceAndMiscellaneous Ongoing expenses incurred by borrower to maintain real estate owned. Collected on the URLA in Section VI (Schedule of Real Estate).

MI Insurance which protects mortgage lenders against loss in the event of default by the borrower. Collected on URLA in Section V (Present / Proposed Housing Expense) and/or Section VI (Schedule of Real Estate).

Other Other expenses related to housing which are not included in the listed values. Typically linked to FREE TEXT description. Collected on URLA in Section V (Present / Proposed Housing Expense).

OtherMortgageLoanPrincipalAndInterest Amount of periodic principal and interest payment on a subordinate mortgage on real estate. Could be present or proposed housing expense. Principal refers to the monthly payment that reduces the remaining balance of the mortgage. Interest is the fee charg

OtherMortgageLoanPrincipalInterestTaxesAndInsurance Amount of periodic principal and interest payment on a subordinate mortgage on real estate plus annual pro-rata share of property taxes and hazard insurance on the property. Principal refers to the monthly payment that reduces the remaining balance of the

RealEstateTax Local government taxes levied on the ownership of real property. Also know as Real Estate Property Tax. Collected on URLA in Section V (Present / Proposed Housing Expense) and/or Section VI (Schedule of Real Estate).

Rent Periodic amount a tenant pays to a landlord for occupancy of a property. Expense if borrower pays. Collected on URLA in Section V (Present Expense - Rent).

Utilities Basic services associated with developed areas that include provisions for electricity, telephone, gas, water, and garbage collection. Collected on the URLA in Section VI (Schedule of Real Estate).

HousingExpenseType Bound Attachments

Name Current Value

HousingExpenseType User-Defined Mappings

Model Name RoleName Parent Entity Datatype Domain Description

HousingExpenseType Direct Source Mappings

Columns Transformation Logic Transformation Description

HousingExpenseType Secondary Source Mappings

Columns Transformation Logic Transformation Description

HousingExpenseType Direct Target Mappings

Columns Transformation Logic Transformation Description

HousingExpenseType Secondary Target Mappings

Columns Transformation Logic Transformation Description

HousingExpenseTypeOtherDescription

Base Entity	PROPOSED_HOUSING_EXPENSE
Attribute Name	HousingExpenseTypeOtherDescription
Logical Rolename
ColumnName	HousingExpenseTypeOtherDescription
RoleName
Domain	MISMOString
Definition	A free form text field used to collect additional information when Other is selected for Housing Expense Type.
Note

HousingExpenseTypeOtherDescription Logical Attribute Properties

Logical Attribute Name HousingExpenseTypeOtherDescription

Datatype VARCHAR(0)

Nullable NO

HousingExpenseTypeOtherDescription Domain Restrictions

CheckConstraint

Check Constraint Name

Bound Rule

Declared Default

Bound Default

HousingExpenseTypeOtherDescription Bound Attachments

Name Current Value

HousingExpenseTypeOtherDescription User-Defined Mappings

Model Name RoleName Parent Entity Datatype Domain Description

HousingExpenseTypeOtherDescription Direct Source Mappings

Columns Transformation Logic Transformation Description

HousingExpenseTypeOtherDescription Secondary Source Mappings

Columns Transformation Logic Transformation Description

HousingExpenseTypeOtherDescription Direct Target Mappings

Columns Transformation Logic Transformation Description

HousingExpenseTypeOtherDescription Secondary Target Mappings

Columns Transformation Logic Transformation Description

ProposedHousingExpensePaymentAmount

Base Entity	PROPOSED_HOUSING_EXPENSE
Attribute Name	ProposedHousingExpensePaymentAmount
Logical Rolename
ColumnName	ProposedHousingExpensePaymentAmount
RoleName
Domain	MISMOAmount
Definition	The dollar amount per month of the borrowers proposed housing expense type.
Note

ProposedHousingExpensePaymentAmount Logical Attribute Properties

Logical Attribute Name ProposedHousingExpensePaymentAmount

Datatype DECIMAL(0, 2)

Nullable NO

ProposedHousingExpensePaymentAmount Domain Restrictions

CheckConstraint

Check Constraint Name

Bound Rule

Declared Default

Bound Default

ProposedHousingExpensePaymentAmount Bound Attachments

Name Current Value

ProposedHousingExpensePaymentAmount User-Defined Mappings

Model Name RoleName Parent Entity Datatype Domain Description

ProposedHousingExpensePaymentAmount Direct Source Mappings

Columns Transformation Logic Transformation Description

ProposedHousingExpensePaymentAmount Secondary Source Mappings

Columns Transformation Logic Transformation Description

ProposedHousingExpensePaymentAmount Direct Target Mappings

Columns Transformation Logic Transformation Description

ProposedHousingExpensePaymentAmount Secondary Target Mappings

Columns Transformation Logic Transformation Description

Logical Attribute Name	SequenceNumber
Datatype	INTEGER
Nullable	YES

CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Value	Value Description
FirstMortgagePITI	Amount of periodic principal and interest payment on a first mortgage on real estate plus annual pro-rata share of property taxes and hazard insurance on the property. Principal refers to the monthly payment that reduces the remaining balance of the mortg
FirstMortgagePrincipalAndInterest	Amount of periodic principal and interest payment on a first mortgage on real estate. Could be present or proposed housing expense. Principal refers to the monthly payment that reduces the remaining balance of the mortgage. Interest is the fee charged for
GroundRent	GroundRent
HazardInsurance	Insurance coverage that provides compensation to insured in case of property damage or loss. (e.g., renters, homeowners, fire, earthquake, flood, etc.) Collected on URLA in Section V (Present / Proposed Housing Expense) and/or Section VI (Schedule of Real
HomeownersAssociationDuesAndCondominiumFees	Association to pay the cost of maintaining areas owned in common by all homeowners within a planned unit development. Collected on URLA in Section V (Present / Proposed Housing Expense) and/or Section VI (Schedule of Real Estate).
LeaseholdPayments	When land under improvements is leased rather than owned, this is the periodic rent. A form of other housing expense.
MaintenanceAndMiscellaneous	Ongoing expenses incurred by borrower to maintain real estate owned. Collected on the URLA in Section VI (Schedule of Real Estate).
MI	Insurance which protects mortgage lenders against loss in the event of default by the borrower. Collected on URLA in Section V (Present / Proposed Housing Expense) and/or Section VI (Schedule of Real Estate).
Other	Other expenses related to housing which are not included in the listed values. Typically linked to FREE TEXT description. Collected on URLA in Section V (Present / Proposed Housing Expense).
OtherMortgageLoanPrincipalAndInterest	Amount of periodic principal and interest payment on a subordinate mortgage on real estate. Could be present or proposed housing expense. Principal refers to the monthly payment that reduces the remaining balance of the mortgage. Interest is the fee charg
OtherMortgageLoanPrincipalInterestTaxesAndInsurance	Amount of periodic principal and interest payment on a subordinate mortgage on real estate plus annual pro-rata share of property taxes and hazard insurance on the property. Principal refers to the monthly payment that reduces the remaining balance of the
RealEstateTax	Local government taxes levied on the ownership of real property. Also know as Real Estate Property Tax. Collected on URLA in Section V (Present / Proposed Housing Expense) and/or Section VI (Schedule of Real Estate).
Rent	Periodic amount a tenant pays to a landlord for occupancy of a property. Expense if borrower pays. Collected on URLA in Section V (Present Expense - Rent).
Utilities	Basic services associated with developed areas that include provisions for electricity, telephone, gas, water, and garbage collection. Collected on the URLA in Section VI (Schedule of Real Estate).