RESIDENTIAL_RENTAL

RESIDENTIAL_RENTAL_DETAIL

EntityType	Dependent
Logical Entity Name	RESIDENTIAL_RENTAL_DETAIL
Default Table Name	DEAL/SERVICES/SERVICE/VALUATION/VALUATION_RESPONSE/VALUATION_REPORT/APPROACH_TO_VALUE/INCOME_ANALYSIS/RESIDENTIAL_RENT_SCHEDULE/RESIDENTIAL_RENTAL/RESIDENTIAL_RENTAL_DETAIL
Definition
Note

RESIDENTIAL_RENTAL_DETAIL Attributes

Attribute/Logical Rolename Domain Datatype NULL Definition

DataSourceDescription MISMOString VARCHAR(0) NO A free form text field used to describe the source of the information.

ExpenseAdjustedMonthlyRentAmount MISMOAmount DECIMAL(0, 2) NO The dollar amount paid monthly for rent less the amounts paid monthly for utilities and furniture. (CALCULATED RESULTS FIELD)

LeaseExpirationDate MISMODate DATE NO The date the lease expires.

LeaseStartDate MISMODate DATE NO The date the lease starts.

MarketAdjustedMonthlyRentAmount MISMOAmount DECIMAL(0, 2) NO The dollar value of the estimated market rent of a comparable rental property determined by applying market driven rent adjustments during the application of a Rent Schedule Comparison. (CALCULATED RESULTS FIELD)

MonthlyFurnitureRentAmount MISMOAmount DECIMAL(0, 2) NO The dollar amount paid monthly for the rental of furniture.

MonthlyRentAmount MISMOAmount DECIMAL(0, 2) NO The amount paid by the borrower or coborrower for the rental of a residence property. This information is normally provided during interview with the borrower or obtained from a loan application, and is sometimes verified with the residence property landl

RentalMonthlyUtilitiesCostAmount MISMOAmount DECIMAL(0, 2) NO The dollar amount paid monthly for utilities associated with a rental property or unit.

RentTotalAdjustmentAmount MISMOAmount DECIMAL(0, 2) NO The dollar value of the total adjustments made to a comparable rental during the application of a Rent Schedule Comparison in the process of determining the monthly market rent of the comparable. (CALCULATED RESULTS FIELD)

RentTotalAdjustmentGrossPercent MISMOPercent DECIMAL(0, 2) NO The percentage of the gross rent adjustments (i.e. sum of the absolute adjustment values) to the Expense Adjusted Monthly Rent of a comparable rental property.

RentTotalAdjustmentNetPercent MISMOPercent DECIMAL(0, 2) NO The percentage of the net rent adjustments to the Expense Adjusted Monthly Rent of a comparable rental property.

RentTotalAdjustmentPositiveIndicator MISMOIndicator BIT NO Indicates whether the total market rent adjustments made to a comparable property during the application of the Rent Schedule Comparison were positive. This field is specifc to the appraisal forms.

RESIDENTIAL_RENTAL_DETAIL Keys

Key Name Key Type Keys

RESIDENTIAL_RENTAL_DETAIL Relationships

Parent Relationships:

Entity Name Type Cardinality Business Name VerbPhrase InversePhrase Foreign Keys Is Supertype

RESIDENTIAL_RENTAL Identifying One to Zero or One NO

Child Relationships:

Entity Name Type Cardinality Business Name VerbPhrase InversePhrase Foreign Keys Is Subtype

RESIDENTIAL_RENTAL_DETAIL Check Constraints

Check Constraint Name CheckConstraint

RESIDENTIAL_RENTAL_DETAIL Bound Attachments

Name Current Value

RESIDENTIAL_RENTAL_DETAIL User-Defined Mappings

Model Name Description

RESIDENTIAL_RENTAL_DETAIL Data Movement Rules

Name Type Rule Text/Value

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
DataSourceDescription	MISMOString	VARCHAR(0)	NO	A free form text field used to describe the source of the information.
ExpenseAdjustedMonthlyRentAmount	MISMOAmount	DECIMAL(0, 2)	NO	The dollar amount paid monthly for rent less the amounts paid monthly for utilities and furniture. (CALCULATED RESULTS FIELD)
LeaseExpirationDate	MISMODate	DATE	NO	The date the lease expires.
LeaseStartDate	MISMODate	DATE	NO	The date the lease starts.
MarketAdjustedMonthlyRentAmount	MISMOAmount	DECIMAL(0, 2)	NO	The dollar value of the estimated market rent of a comparable rental property determined by applying market driven rent adjustments during the application of a Rent Schedule Comparison. (CALCULATED RESULTS FIELD)
MonthlyFurnitureRentAmount	MISMOAmount	DECIMAL(0, 2)	NO	The dollar amount paid monthly for the rental of furniture.
MonthlyRentAmount	MISMOAmount	DECIMAL(0, 2)	NO	The amount paid by the borrower or coborrower for the rental of a residence property. This information is normally provided during interview with the borrower or obtained from a loan application, and is sometimes verified with the residence property landl
RentalMonthlyUtilitiesCostAmount	MISMOAmount	DECIMAL(0, 2)	NO	The dollar amount paid monthly for utilities associated with a rental property or unit.
RentTotalAdjustmentAmount	MISMOAmount	DECIMAL(0, 2)	NO	The dollar value of the total adjustments made to a comparable rental during the application of a Rent Schedule Comparison in the process of determining the monthly market rent of the comparable. (CALCULATED RESULTS FIELD)
RentTotalAdjustmentGrossPercent	MISMOPercent	DECIMAL(0, 2)	NO	The percentage of the gross rent adjustments (i.e. sum of the absolute adjustment values) to the Expense Adjusted Monthly Rent of a comparable rental property.
RentTotalAdjustmentNetPercent	MISMOPercent	DECIMAL(0, 2)	NO	The percentage of the net rent adjustments to the Expense Adjusted Monthly Rent of a comparable rental property.
RentTotalAdjustmentPositiveIndicator	MISMOIndicator	BIT	NO	Indicates whether the total market rent adjustments made to a comparable property during the application of the Rent Schedule Comparison were positive. This field is specifc to the appraisal forms.

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
RESIDENTIAL_RENTAL	Identifying	One to Zero or One					NO