DataSourceDescription |
Base Entity | RESIDENTIAL_RENTAL_DETAIL |
Attribute Name | DataSourceDescription |
Logical Rolename | |
ColumnName | DataSourceDescription |
RoleName | |
Domain | MISMOString |
Definition | A free form text field used to describe the source of the information. |
Note |
DataSourceDescription Logical Attribute Properties |
Logical Attribute Name | DataSourceDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
DataSourceDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
DataSourceDescription Bound Attachments |
Name | Current Value |
DataSourceDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
DataSourceDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DataSourceDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DataSourceDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DataSourceDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ExpenseAdjustedMonthlyRentAmount |
Base Entity | RESIDENTIAL_RENTAL_DETAIL |
Attribute Name | ExpenseAdjustedMonthlyRentAmount |
Logical Rolename | |
ColumnName | ExpenseAdjustedMonthlyRentAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The dollar amount paid monthly for rent less the amounts paid monthly for utilities and furniture. (CALCULATED RESULTS FIELD) |
Note |
ExpenseAdjustedMonthlyRentAmount Logical Attribute Properties |
Logical Attribute Name | ExpenseAdjustedMonthlyRentAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
ExpenseAdjustedMonthlyRentAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ExpenseAdjustedMonthlyRentAmount Bound Attachments |
Name | Current Value |
ExpenseAdjustedMonthlyRentAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ExpenseAdjustedMonthlyRentAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ExpenseAdjustedMonthlyRentAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ExpenseAdjustedMonthlyRentAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ExpenseAdjustedMonthlyRentAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
LeaseExpirationDate |
Base Entity | RESIDENTIAL_RENTAL_DETAIL |
Attribute Name | LeaseExpirationDate |
Logical Rolename | |
ColumnName | LeaseExpirationDate |
RoleName | |
Domain | MISMODate |
Definition | The date the lease expires. |
Note |
LeaseExpirationDate Logical Attribute Properties |
Logical Attribute Name | LeaseExpirationDate |
Datatype | DATE |
Nullable | NO |
LeaseExpirationDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
LeaseExpirationDate Bound Attachments |
Name | Current Value |
LeaseExpirationDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
LeaseExpirationDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
LeaseExpirationDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
LeaseExpirationDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
LeaseExpirationDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
LeaseStartDate |
Base Entity | RESIDENTIAL_RENTAL_DETAIL |
Attribute Name | LeaseStartDate |
Logical Rolename | |
ColumnName | LeaseStartDate |
RoleName | |
Domain | MISMODate |
Definition | The date the lease starts. |
Note |
LeaseStartDate Logical Attribute Properties |
Logical Attribute Name | LeaseStartDate |
Datatype | DATE |
Nullable | NO |
LeaseStartDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
LeaseStartDate Bound Attachments |
Name | Current Value |
LeaseStartDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
LeaseStartDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
LeaseStartDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
LeaseStartDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
LeaseStartDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MarketAdjustedMonthlyRentAmount |
Base Entity | RESIDENTIAL_RENTAL_DETAIL |
Attribute Name | MarketAdjustedMonthlyRentAmount |
Logical Rolename | |
ColumnName | MarketAdjustedMonthlyRentAmount |
RoleName | |
Domain | MISMOAmount |
Definition | 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) |
Note |
MarketAdjustedMonthlyRentAmount Logical Attribute Properties |
Logical Attribute Name | MarketAdjustedMonthlyRentAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
MarketAdjustedMonthlyRentAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MarketAdjustedMonthlyRentAmount Bound Attachments |
Name | Current Value |
MarketAdjustedMonthlyRentAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MarketAdjustedMonthlyRentAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MarketAdjustedMonthlyRentAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MarketAdjustedMonthlyRentAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MarketAdjustedMonthlyRentAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MonthlyFurnitureRentAmount |
Base Entity | RESIDENTIAL_RENTAL_DETAIL |
Attribute Name | MonthlyFurnitureRentAmount |
Logical Rolename | |
ColumnName | MonthlyFurnitureRentAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The dollar amount paid monthly for the rental of furniture. |
Note |
MonthlyFurnitureRentAmount Logical Attribute Properties |
Logical Attribute Name | MonthlyFurnitureRentAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
MonthlyFurnitureRentAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MonthlyFurnitureRentAmount Bound Attachments |
Name | Current Value |
MonthlyFurnitureRentAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MonthlyFurnitureRentAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MonthlyFurnitureRentAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MonthlyFurnitureRentAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MonthlyFurnitureRentAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MonthlyRentAmount |
Base Entity | RESIDENTIAL_RENTAL_DETAIL |
Attribute Name | MonthlyRentAmount |
Logical Rolename | |
ColumnName | MonthlyRentAmount |
RoleName | |
Domain | MISMOAmount |
Definition | 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 |
Note |
MonthlyRentAmount Logical Attribute Properties |
Logical Attribute Name | MonthlyRentAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
MonthlyRentAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MonthlyRentAmount Bound Attachments |
Name | Current Value |
MonthlyRentAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MonthlyRentAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MonthlyRentAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MonthlyRentAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MonthlyRentAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RentalMonthlyUtilitiesCostAmount |
Base Entity | RESIDENTIAL_RENTAL_DETAIL |
Attribute Name | RentalMonthlyUtilitiesCostAmount |
Logical Rolename | |
ColumnName | RentalMonthlyUtilitiesCostAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The dollar amount paid monthly for utilities associated with a rental property or unit. |
Note |
RentalMonthlyUtilitiesCostAmount Logical Attribute Properties |
Logical Attribute Name | RentalMonthlyUtilitiesCostAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
RentalMonthlyUtilitiesCostAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
RentalMonthlyUtilitiesCostAmount Bound Attachments |
Name | Current Value |
RentalMonthlyUtilitiesCostAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
RentalMonthlyUtilitiesCostAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RentalMonthlyUtilitiesCostAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RentalMonthlyUtilitiesCostAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RentalMonthlyUtilitiesCostAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RentTotalAdjustmentAmount |
Base Entity | RESIDENTIAL_RENTAL_DETAIL |
Attribute Name | RentTotalAdjustmentAmount |
Logical Rolename | |
ColumnName | RentTotalAdjustmentAmount |
RoleName | |
Domain | MISMOAmount |
Definition | 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) |
Note |
RentTotalAdjustmentAmount Logical Attribute Properties |
Logical Attribute Name | RentTotalAdjustmentAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
RentTotalAdjustmentAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
RentTotalAdjustmentAmount Bound Attachments |
Name | Current Value |
RentTotalAdjustmentAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
RentTotalAdjustmentAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RentTotalAdjustmentAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RentTotalAdjustmentAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RentTotalAdjustmentAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RentTotalAdjustmentGrossPercent |
Base Entity | RESIDENTIAL_RENTAL_DETAIL |
Attribute Name | RentTotalAdjustmentGrossPercent |
Logical Rolename | |
ColumnName | RentTotalAdjustmentGrossPercent |
RoleName | |
Domain | MISMOPercent |
Definition | 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. |
Note |
RentTotalAdjustmentGrossPercent Logical Attribute Properties |
Logical Attribute Name | RentTotalAdjustmentGrossPercent |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
RentTotalAdjustmentGrossPercent Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
RentTotalAdjustmentGrossPercent Bound Attachments |
Name | Current Value |
RentTotalAdjustmentGrossPercent User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
RentTotalAdjustmentGrossPercent Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RentTotalAdjustmentGrossPercent Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RentTotalAdjustmentGrossPercent Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RentTotalAdjustmentGrossPercent Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RentTotalAdjustmentNetPercent |
Base Entity | RESIDENTIAL_RENTAL_DETAIL |
Attribute Name | RentTotalAdjustmentNetPercent |
Logical Rolename | |
ColumnName | RentTotalAdjustmentNetPercent |
RoleName | |
Domain | MISMOPercent |
Definition | The percentage of the net rent adjustments to the Expense Adjusted Monthly Rent of a comparable rental property. |
Note |
RentTotalAdjustmentNetPercent Logical Attribute Properties |
Logical Attribute Name | RentTotalAdjustmentNetPercent |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
RentTotalAdjustmentNetPercent Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
RentTotalAdjustmentNetPercent Bound Attachments |
Name | Current Value |
RentTotalAdjustmentNetPercent User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
RentTotalAdjustmentNetPercent Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RentTotalAdjustmentNetPercent Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RentTotalAdjustmentNetPercent Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RentTotalAdjustmentNetPercent Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RentTotalAdjustmentPositiveIndicator |
Base Entity | RESIDENTIAL_RENTAL_DETAIL |
Attribute Name | RentTotalAdjustmentPositiveIndicator |
Logical Rolename | |
ColumnName | RentTotalAdjustmentPositiveIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | 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. |
Note |
RentTotalAdjustmentPositiveIndicator Logical Attribute Properties |
Logical Attribute Name | RentTotalAdjustmentPositiveIndicator |
Datatype | BIT |
Nullable | NO |
RentTotalAdjustmentPositiveIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
RentTotalAdjustmentPositiveIndicator Bound Attachments |
Name | Current Value |
RentTotalAdjustmentPositiveIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
RentTotalAdjustmentPositiveIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RentTotalAdjustmentPositiveIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RentTotalAdjustmentPositiveIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RentTotalAdjustmentPositiveIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |