AttachmentType |
Base Entity | PROPERTY_DETAIL |
Attribute Name | AttachmentType |
Logical Rolename | |
ColumnName | AttachmentType |
RoleName | |
Domain | AttachmentEnum |
Definition | Specifies the type of physical attachment, if any, between the dwelling unit and adjacent dwelling units. |
Note |
AttachmentType Logical Attribute Properties |
Logical Attribute Name | AttachmentType |
Datatype | VARCHAR(0) |
Nullable | YES |
AttachmentType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
AttachmentType Reference Value (Bound to Domain) |
Name | ValidationRule33 |
Description | |
Type | By List |
Value | Value Description |
Attached | Residential dwelling unit that has common wall or other direct physical connection with another residential dwelling unit. |
Detached | Residential dwelling unit that has no common wall or other direct physical connection with another residential dwelling unit. |
SemiDetached | Residential dwellings that consist of pairs of houses built side by side sharing a common party wall. Sometimes called a duplex. |
AttachmentType Bound Attachments |
Name | Current Value |
AttachmentType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
AttachmentType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
AttachmentType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
AttachmentType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
AttachmentType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerContinuesToOwnPropertyIndicator |
Base Entity | PROPERTY_DETAIL |
Attribute Name | BorrowerContinuesToOwnPropertyIndicator |
Logical Rolename | |
ColumnName | BorrowerContinuesToOwnPropertyIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | When true, indicates that the property associated with the loan is still owned by the borrower(s). |
Note |
BorrowerContinuesToOwnPropertyIndicator Logical Attribute Properties |
Logical Attribute Name | BorrowerContinuesToOwnPropertyIndicator |
Datatype | BIT |
Nullable | NO |
BorrowerContinuesToOwnPropertyIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
BorrowerContinuesToOwnPropertyIndicator Bound Attachments |
Name | Current Value |
BorrowerContinuesToOwnPropertyIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
BorrowerContinuesToOwnPropertyIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerContinuesToOwnPropertyIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerContinuesToOwnPropertyIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerContinuesToOwnPropertyIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CommunityLandTrustIndicator |
Base Entity | PROPERTY_DETAIL |
Attribute Name | CommunityLandTrustIndicator |
Logical Rolename | |
ColumnName | CommunityLandTrustIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates the the property is located in a community land trust. |
Note |
CommunityLandTrustIndicator Logical Attribute Properties |
Logical Attribute Name | CommunityLandTrustIndicator |
Datatype | BIT |
Nullable | NO |
CommunityLandTrustIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CommunityLandTrustIndicator Bound Attachments |
Name | Current Value |
CommunityLandTrustIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
CommunityLandTrustIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CommunityLandTrustIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CommunityLandTrustIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CommunityLandTrustIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CommunityReinvestmentActDelineatedCommunityIndicator |
Base Entity | PROPERTY_DETAIL |
Attribute Name | CommunityReinvestmentActDelineatedCommunityIndicator |
Logical Rolename | |
ColumnName | CommunityReinvestmentActDelineatedCommunityIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates that the property is in an area defined by the Community Reinvestment Act. |
Note |
CommunityReinvestmentActDelineatedCommunityIndicator Logical Attribute Properties |
Logical Attribute Name | CommunityReinvestmentActDelineatedCommunityIndicator |
Datatype | BIT |
Nullable | NO |
CommunityReinvestmentActDelineatedCommunityIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CommunityReinvestmentActDelineatedCommunityIndicator Bound Attachments |
Name | Current Value |
CommunityReinvestmentActDelineatedCommunityIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
CommunityReinvestmentActDelineatedCommunityIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CommunityReinvestmentActDelineatedCommunityIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CommunityReinvestmentActDelineatedCommunityIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CommunityReinvestmentActDelineatedCommunityIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConstructionMethodType |
Base Entity | PROPERTY_DETAIL |
Attribute Name | ConstructionMethodType |
Logical Rolename | |
ColumnName | ConstructionMethodType |
RoleName | |
Domain | ConstructionMethodEnum |
Definition | Describes the construction process for the main dwelling unit of the subject property. |
Note |
ConstructionMethodType Logical Attribute Properties |
Logical Attribute Name | ConstructionMethodType |
Datatype | VARCHAR(0) |
Nullable | YES |
ConstructionMethodType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ConstructionMethodType Reference Value (Bound to Domain) |
Name | ValidationRule67 |
Description | |
Type | By List |
Value | Value Description |
Manufactured | A factory built dwelling built in compliance with the Federal Manufactured Home Construction and Safety Standards in effect at the time the home was manufactured as evidenced by the HUD label. (HUD Code Home) |
MobileHome | Dwelling unit constructed on a base frame which features wheels and axles to be used in transporting home from place to place, does not meet HUD code. |
Modular | A factory built dwelling not on a permanent chassis. |
OnFrameModular | A factory built dwelling on a permanent chassis which does not have a HUD label. |
Other | Other |
SiteBuilt | Describes construction process, indicating that most elements are created at the homes permanent site. May include some prefabricated components. |
ConstructionMethodType Bound Attachments |
Name | Current Value |
ConstructionMethodType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ConstructionMethodType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConstructionMethodType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConstructionMethodType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConstructionMethodType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConstructionMethodTypeOtherDescription |
Base Entity | PROPERTY_DETAIL |
Attribute Name | ConstructionMethodTypeOtherDescription |
Logical Rolename | |
ColumnName | ConstructionMethodTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free form text field used to collect additional information when Other is selected for Construction Method Type. |
Note |
ConstructionMethodTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | ConstructionMethodTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
ConstructionMethodTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ConstructionMethodTypeOtherDescription Bound Attachments |
Name | Current Value |
ConstructionMethodTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ConstructionMethodTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConstructionMethodTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConstructionMethodTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConstructionMethodTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConstructionStatusType |
Base Entity | PROPERTY_DETAIL |
Attribute Name | ConstructionStatusType |
Logical Rolename | |
ColumnName | ConstructionStatusType |
RoleName | |
Domain | ConstructionStatusEnum |
Definition | Specifies the physical status of the structure. |
Note |
ConstructionStatusType Logical Attribute Properties |
Logical Attribute Name | ConstructionStatusType |
Datatype | VARCHAR(0) |
Nullable | YES |
ConstructionStatusType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ConstructionStatusType Reference Value (Bound to Domain) |
Name | ValidationRule71 |
Description | |
Type | By List |
Value | Value Description |
Complete | The structure is newly completed and has never been occupied as a residence. |
Existing | The improvements are 100% complete. |
Incomplete | Construction of the improvements is not complete and not actively under construction. |
Other | Other |
Proposed | Construction of the improvements has not started and description is based on plans and specifications and/or substantially similar documentation. |
SubjectToAlteration | SubjectToAlteration |
SubjectToAlterationImprovementRepairAndRehabilitation | SubjectToAlterationImprovementRepairAndRehabilitation |
SubstantiallyRehabilitated | SubstantiallyRehabilitated |
UnderConstruction | Construction of the improvements has begun but is not complete. |
ConstructionStatusType Bound Attachments |
Name | Current Value |
ConstructionStatusType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ConstructionStatusType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConstructionStatusType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConstructionStatusType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConstructionStatusType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConstructionStatusTypeOtherDescription |
Base Entity | PROPERTY_DETAIL |
Attribute Name | ConstructionStatusTypeOtherDescription |
Logical Rolename | |
ColumnName | ConstructionStatusTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free form text field used to collect additional information when Other is selected for Construction Status Type. |
Note |
ConstructionStatusTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | ConstructionStatusTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
ConstructionStatusTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ConstructionStatusTypeOtherDescription Bound Attachments |
Name | Current Value |
ConstructionStatusTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ConstructionStatusTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConstructionStatusTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConstructionStatusTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConstructionStatusTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
DeedRestrictionIndicator |
Base Entity | PROPERTY_DETAIL |
Attribute Name | DeedRestrictionIndicator |
Logical Rolename | |
ColumnName | DeedRestrictionIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | If true, indicates that the deed has associated restrictions. |
Note |
DeedRestrictionIndicator Logical Attribute Properties |
Logical Attribute Name | DeedRestrictionIndicator |
Datatype | BIT |
Nullable | NO |
DeedRestrictionIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
DeedRestrictionIndicator Bound Attachments |
Name | Current Value |
DeedRestrictionIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
DeedRestrictionIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DeedRestrictionIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DeedRestrictionIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DeedRestrictionIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EarthquakeInsuranceRequiredIndicator |
Base Entity | PROPERTY_DETAIL |
Attribute Name | EarthquakeInsuranceRequiredIndicator |
Logical Rolename | |
ColumnName | EarthquakeInsuranceRequiredIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates that earthquake insurance coverage is required for the property. |
Note |
EarthquakeInsuranceRequiredIndicator Logical Attribute Properties |
Logical Attribute Name | EarthquakeInsuranceRequiredIndicator |
Datatype | BIT |
Nullable | NO |
EarthquakeInsuranceRequiredIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EarthquakeInsuranceRequiredIndicator Bound Attachments |
Name | Current Value |
EarthquakeInsuranceRequiredIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
EarthquakeInsuranceRequiredIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EarthquakeInsuranceRequiredIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EarthquakeInsuranceRequiredIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EarthquakeInsuranceRequiredIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
FinancedUnitCount |
Base Entity | PROPERTY_DETAIL |
Attribute Name | FinancedUnitCount |
Logical Rolename | |
ColumnName | FinancedUnitCount |
RoleName | |
Domain | MISMOCount |
Definition | The number of individual family dwelling units being financed in the subject property. |
Note |
FinancedUnitCount Logical Attribute Properties |
Logical Attribute Name | FinancedUnitCount |
Datatype | INTEGER |
Nullable | NO |
FinancedUnitCount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
FinancedUnitCount Bound Attachments |
Name | Current Value |
FinancedUnitCount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
FinancedUnitCount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
FinancedUnitCount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
FinancedUnitCount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
FinancedUnitCount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
GrossLivingAreaSquareFeetNumber |
Base Entity | PROPERTY_DETAIL |
Attribute Name | GrossLivingAreaSquareFeetNumber |
Logical Rolename | |
ColumnName | GrossLivingAreaSquareFeetNumber |
RoleName | |
Domain | MISMONumeric |
Definition | The total area of all inhabitable rooms. |
Note |
GrossLivingAreaSquareFeetNumber Logical Attribute Properties |
Logical Attribute Name | GrossLivingAreaSquareFeetNumber |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
GrossLivingAreaSquareFeetNumber Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
GrossLivingAreaSquareFeetNumber Bound Attachments |
Name | Current Value |
GrossLivingAreaSquareFeetNumber User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
GrossLivingAreaSquareFeetNumber Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
GrossLivingAreaSquareFeetNumber Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
GrossLivingAreaSquareFeetNumber Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
GrossLivingAreaSquareFeetNumber Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
GroupHomeIndicator |
Base Entity | PROPERTY_DETAIL |
Attribute Name | GroupHomeIndicator |
Logical Rolename | |
ColumnName | GroupHomeIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | When true, indicates the property will be used as a group home. A group home is used for individuals with special needs, including the frail elderly, developmentally and/or physically disabled |
Note |
GroupHomeIndicator Logical Attribute Properties |
Logical Attribute Name | GroupHomeIndicator |
Datatype | BIT |
Nullable | NO |
GroupHomeIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
GroupHomeIndicator Bound Attachments |
Name | Current Value |
GroupHomeIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
GroupHomeIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
GroupHomeIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
GroupHomeIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
GroupHomeIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
InvestorREOPropertyIdentifier |
Base Entity | PROPERTY_DETAIL |
Attribute Name | InvestorREOPropertyIdentifier |
Logical Rolename | |
ColumnName | InvestorREOPropertyIdentifier |
RoleName | |
Domain | MISMOIdentifier |
Definition | A unique identifier assigned by an investor to a property acquired as the result of delinquency. |
Note |
InvestorREOPropertyIdentifier Logical Attribute Properties |
Logical Attribute Name | InvestorREOPropertyIdentifier |
Datatype | VARCHAR(0) |
Nullable | NO |
InvestorREOPropertyIdentifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
InvestorREOPropertyIdentifier Bound Attachments |
Name | Current Value |
InvestorREOPropertyIdentifier User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
InvestorREOPropertyIdentifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
InvestorREOPropertyIdentifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
InvestorREOPropertyIdentifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
InvestorREOPropertyIdentifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
LandTrustType |
Base Entity | PROPERTY_DETAIL |
Attribute Name | LandTrustType |
Logical Rolename | |
ColumnName | LandTrustType |
RoleName | |
Domain | LandTrustEnum |
Definition | Specifies the type of land trust associated with the title. |
Note |
LandTrustType Logical Attribute Properties |
Logical Attribute Name | LandTrustType |
Datatype | VARCHAR(0) |
Nullable | YES |
LandTrustType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
LandTrustType Reference Value (Bound to Domain) |
Name | ValidationRule243 |
Description | |
Type | By List |
Value | Value Description |
IllinoisLandTrust | IllinoisLandTrust |
Other | Other |
LandTrustType Bound Attachments |
Name | Current Value |
LandTrustType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
LandTrustType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
LandTrustType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
LandTrustType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
LandTrustType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
LandTrustTypeOtherDescription |
Base Entity | PROPERTY_DETAIL |
Attribute Name | LandTrustTypeOtherDescription |
Logical Rolename | |
ColumnName | LandTrustTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free form text field used to collect additional information when Other is selected for Land Trust Type. |
Note |
LandTrustTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | LandTrustTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
LandTrustTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
LandTrustTypeOtherDescription Bound Attachments |
Name | Current Value |
LandTrustTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
LandTrustTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
LandTrustTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
LandTrustTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
LandTrustTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
LandUseDescription |
Base Entity | PROPERTY_DETAIL |
Attribute Name | LandUseDescription |
Logical Rolename | |
ColumnName | LandUseDescription |
RoleName | |
Domain | MISMOString |
Definition | A free-form text field used to further describe the land use of the property as defined by Land Use Type. |
Note |
LandUseDescription Logical Attribute Properties |
Logical Attribute Name | LandUseDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
LandUseDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
LandUseDescription Bound Attachments |
Name | Current Value |
LandUseDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
LandUseDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
LandUseDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
LandUseDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
LandUseDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
LandUseType |
Base Entity | PROPERTY_DETAIL |
Attribute Name | LandUseType |
Logical Rolename | |
ColumnName | LandUseType |
RoleName | |
Domain | LandUseEnum |
Definition | Identifies the designation of land use by a governmental authority described by Land Used Description. |
Note |
LandUseType Logical Attribute Properties |
Logical Attribute Name | LandUseType |
Datatype | VARCHAR(0) |
Nullable | YES |
LandUseType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
LandUseType Reference Value (Bound to Domain) |
Name | ValidationRule244 |
Description | |
Type | By List |
Value | Value Description |
Agricultural | Agricultural |
Commercial | Commercial |
Income | Income |
Industrial | Industrial |
Other | Other |
PublicAndSemipublic | PublicAndSemipublic |
Recreational | Recreational |
Residential | Residential |
TransportationAndUtility | TransportationAndUtility |
Vacant | Vacant |
LandUseType Bound Attachments |
Name | Current Value |
LandUseType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
LandUseType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
LandUseType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
LandUseType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
LandUseType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
LandUseTypeOtherDescription |
Base Entity | PROPERTY_DETAIL |
Attribute Name | LandUseTypeOtherDescription |
Logical Rolename | |
ColumnName | LandUseTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free-form text field used to describe the land use designation if Other is selected as the Property Land Use Type. |
Note |
LandUseTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | LandUseTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
LandUseTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
LandUseTypeOtherDescription Bound Attachments |
Name | Current Value |
LandUseTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
LandUseTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
LandUseTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
LandUseTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
LandUseTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
LenderDesignatedDecliningMarketIdentifier |
Base Entity | PROPERTY_DETAIL |
Attribute Name | LenderDesignatedDecliningMarketIdentifier |
Logical Rolename | |
ColumnName | LenderDesignatedDecliningMarketIdentifier |
RoleName | |
Domain | MISMOIdentifier |
Definition | Identifies the type of declining market based on lender anaylsis. |
Note |
LenderDesignatedDecliningMarketIdentifier Logical Attribute Properties |
Logical Attribute Name | LenderDesignatedDecliningMarketIdentifier |
Datatype | VARCHAR(0) |
Nullable | NO |
LenderDesignatedDecliningMarketIdentifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
LenderDesignatedDecliningMarketIdentifier Bound Attachments |
Name | Current Value |
LenderDesignatedDecliningMarketIdentifier User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
LenderDesignatedDecliningMarketIdentifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
LenderDesignatedDecliningMarketIdentifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
LenderDesignatedDecliningMarketIdentifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
LenderDesignatedDecliningMarketIdentifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
NativeAmericanLandsType |
Base Entity | PROPERTY_DETAIL |
Attribute Name | NativeAmericanLandsType |
Logical Rolename | |
ColumnName | NativeAmericanLandsType |
RoleName | |
Domain | NativeAmericanLandsEnum |
Definition | Any land granted to or acquired by a federally-recognized tribe. Title may be held in fee simple, or held by the federal government in trust through a leasehold for the benefit of the tribe. |
Note |
NativeAmericanLandsType Logical Attribute Properties |
Logical Attribute Name | NativeAmericanLandsType |
Datatype | VARCHAR(0) |
Nullable | YES |
NativeAmericanLandsType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
NativeAmericanLandsType Reference Value (Bound to Domain) |
Name | ValidationRule321 |
Description | |
Type | By List |
Value | Value Description |
AllottedTribalLand | Land allotted to eligible Native American Indian not living on a reservation or to a member of a tribe without reservation lands. |
HawaiianHomeLands | Public land held in trust by the State of Hawaii, Department of Hawaiian Home Lands for native Hawaiians. |
Other | Other |
NativeAmericanLandsType Bound Attachments |
Name | Current Value |
NativeAmericanLandsType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
NativeAmericanLandsType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
NativeAmericanLandsType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
NativeAmericanLandsType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
NativeAmericanLandsType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
NativeAmericanLandsTypeOtherDescription |
Base Entity | PROPERTY_DETAIL |
Attribute Name | NativeAmericanLandsTypeOtherDescription |
Logical Rolename | |
ColumnName | NativeAmericanLandsTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free form text field used to collect additional information when Other is selected for Native American Lands Type. |
Note |
NativeAmericanLandsTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | NativeAmericanLandsTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
NativeAmericanLandsTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
NativeAmericanLandsTypeOtherDescription Bound Attachments |
Name | Current Value |
NativeAmericanLandsTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
NativeAmericanLandsTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
NativeAmericanLandsTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
NativeAmericanLandsTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
NativeAmericanLandsTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PriorSaleInLastTwelveMonthsIndicator |
Base Entity | PROPERTY_DETAIL |
Attribute Name | PriorSaleInLastTwelveMonthsIndicator |
Logical Rolename | |
ColumnName | PriorSaleInLastTwelveMonthsIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates that property has been sold in the twelve months prior to origination of the delivery loan. |
Note |
PriorSaleInLastTwelveMonthsIndicator Logical Attribute Properties |
Logical Attribute Name | PriorSaleInLastTwelveMonthsIndicator |
Datatype | BIT |
Nullable | NO |
PriorSaleInLastTwelveMonthsIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PriorSaleInLastTwelveMonthsIndicator Bound Attachments |
Name | Current Value |
PriorSaleInLastTwelveMonthsIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PriorSaleInLastTwelveMonthsIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PriorSaleInLastTwelveMonthsIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PriorSaleInLastTwelveMonthsIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PriorSaleInLastTwelveMonthsIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyAcquiredDate |
Base Entity | PROPERTY_DETAIL |
Attribute Name | PropertyAcquiredDate |
Logical Rolename | |
ColumnName | PropertyAcquiredDate |
RoleName | |
Domain | MISMODate |
Definition | The date the property was acquired. |
Note |
PropertyAcquiredDate Logical Attribute Properties |
Logical Attribute Name | PropertyAcquiredDate |
Datatype | DATE |
Nullable | NO |
PropertyAcquiredDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyAcquiredDate Bound Attachments |
Name | Current Value |
PropertyAcquiredDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyAcquiredDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyAcquiredDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyAcquiredDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyAcquiredDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyAcquiredYear |
Base Entity | PROPERTY_DETAIL |
Attribute Name | PropertyAcquiredYear |
Logical Rolename | |
ColumnName | PropertyAcquiredYear |
RoleName | |
Domain | MISMOYear |
Definition | The year in which the land and buildings of the property were acquired by the borrower. |
Note |
PropertyAcquiredYear Logical Attribute Properties |
Logical Attribute Name | PropertyAcquiredYear |
Datatype | DATE |
Nullable | NO |
PropertyAcquiredYear Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyAcquiredYear Bound Attachments |
Name | Current Value |
PropertyAcquiredYear User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyAcquiredYear Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyAcquiredYear Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyAcquiredYear Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyAcquiredYear Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyAcreageNumber |
Base Entity | PROPERTY_DETAIL |
Attribute Name | PropertyAcreageNumber |
Logical Rolename | |
ColumnName | PropertyAcreageNumber |
RoleName | |
Domain | MISMONumeric |
Definition | Number of acres of the subject property. |
Note |
PropertyAcreageNumber Logical Attribute Properties |
Logical Attribute Name | PropertyAcreageNumber |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
PropertyAcreageNumber Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyAcreageNumber Bound Attachments |
Name | Current Value |
PropertyAcreageNumber User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyAcreageNumber Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyAcreageNumber Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyAcreageNumber Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyAcreageNumber Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyConditionDescription |
Base Entity | PROPERTY_DETAIL |
Attribute Name | PropertyConditionDescription |
Logical Rolename | |
ColumnName | PropertyConditionDescription |
RoleName | |
Domain | MISMOString |
Definition | A free-form text field describing the condition of the property |
Note |
PropertyConditionDescription Logical Attribute Properties |
Logical Attribute Name | PropertyConditionDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
PropertyConditionDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyConditionDescription Bound Attachments |
Name | Current Value |
PropertyConditionDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyConditionDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyConditionDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyConditionDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyConditionDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyCurrentOccupancyType |
Base Entity | PROPERTY_DETAIL |
Attribute Name | PropertyCurrentOccupancyType |
Logical Rolename | |
ColumnName | PropertyCurrentOccupancyType |
RoleName | |
Domain | PropertyCurrentOccupancyEnum |
Definition | Specifies the property occupancy status of a subject property. |
Note |
PropertyCurrentOccupancyType Logical Attribute Properties |
Logical Attribute Name | PropertyCurrentOccupancyType |
Datatype | VARCHAR(0) |
Nullable | YES |
PropertyCurrentOccupancyType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyCurrentOccupancyType Reference Value (Bound to Domain) |
Name | ValidationRule393 |
Description | |
Type | By List |
Value | Value Description |
Abandoned | Abandoned |
AdverseOccupied | AdverseOccupied |
OwnerOccupied | OwnerOccupied |
RemovedOrDestroyed | RemovedOrDestroyed |
TenantOccupied | TenantOccupied |
Unknown | Unknown |
Vacant | Vacant |
PropertyCurrentOccupancyType Bound Attachments |
Name | Current Value |
PropertyCurrentOccupancyType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyCurrentOccupancyType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyCurrentOccupancyType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyCurrentOccupancyType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyCurrentOccupancyType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyCurrentOccupantName |
Base Entity | PROPERTY_DETAIL |
Attribute Name | PropertyCurrentOccupantName |
Logical Rolename | |
ColumnName | PropertyCurrentOccupantName |
RoleName | |
Domain | MISMOString |
Definition | The unparsed name of the current occupant of the property. |
Note |
PropertyCurrentOccupantName Logical Attribute Properties |
Logical Attribute Name | PropertyCurrentOccupantName |
Datatype | VARCHAR(0) |
Nullable | NO |
PropertyCurrentOccupantName Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyCurrentOccupantName Bound Attachments |
Name | Current Value |
PropertyCurrentOccupantName User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyCurrentOccupantName Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyCurrentOccupantName Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyCurrentOccupantName Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyCurrentOccupantName Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyEarthquakeInsuranceIndicator |
Base Entity | PROPERTY_DETAIL |
Attribute Name | PropertyEarthquakeInsuranceIndicator |
Logical Rolename | |
ColumnName | PropertyEarthquakeInsuranceIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | An indicator denoting whether the property securing the mortgage has earthquake insurance. |
Note |
PropertyEarthquakeInsuranceIndicator Logical Attribute Properties |
Logical Attribute Name | PropertyEarthquakeInsuranceIndicator |
Datatype | BIT |
Nullable | NO |
PropertyEarthquakeInsuranceIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyEarthquakeInsuranceIndicator Bound Attachments |
Name | Current Value |
PropertyEarthquakeInsuranceIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyEarthquakeInsuranceIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyEarthquakeInsuranceIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyEarthquakeInsuranceIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyEarthquakeInsuranceIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyEstateType |
Base Entity | PROPERTY_DETAIL |
Attribute Name | PropertyEstateType |
Logical Rolename | |
ColumnName | PropertyEstateType |
RoleName | |
Domain | PropertyEstateEnum |
Definition | Specifies the ownership interest in the property. |
Note |
PropertyEstateType Logical Attribute Properties |
Logical Attribute Name | PropertyEstateType |
Datatype | VARCHAR(0) |
Nullable | YES |
PropertyEstateType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyEstateType Reference Value (Bound to Domain) |
Name | ValidationRule394 |
Description | |
Type | By List |
Value | Value Description |
FeeSimple | The greatest possible interest a person can have in real estate, including the right to dispose of the property or pass it on to their heirs. |
Fractional | An shared interest among multiple parties in the single title or deed associated with a property. Fractional ownership generally restricts the owners usage of the property. |
Leasehold | An estate or interest in real property held by virtue of a lease. |
Other | Other |
PropertyEstateType Bound Attachments |
Name | Current Value |
PropertyEstateType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyEstateType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyEstateType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyEstateType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyEstateType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyEstateTypeOtherDescription |
Base Entity | PROPERTY_DETAIL |
Attribute Name | PropertyEstateTypeOtherDescription |
Logical Rolename | |
ColumnName | PropertyEstateTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free-form text field used to collect additional information when Other is selected for Property Estate Type. |
Note |
PropertyEstateTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | PropertyEstateTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
PropertyEstateTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyEstateTypeOtherDescription Bound Attachments |
Name | Current Value |
PropertyEstateTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyEstateTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyEstateTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyEstateTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyEstateTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyExistingLienAmount |
Base Entity | PROPERTY_DETAIL |
Attribute Name | PropertyExistingLienAmount |
Logical Rolename | |
ColumnName | PropertyExistingLienAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The total amount of liens against the property at time of application for a loan. Used for Construction or Refinance loans. |
Note |
PropertyExistingLienAmount Logical Attribute Properties |
Logical Attribute Name | PropertyExistingLienAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
PropertyExistingLienAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyExistingLienAmount Bound Attachments |
Name | Current Value |
PropertyExistingLienAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyExistingLienAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyExistingLienAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyExistingLienAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyExistingLienAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyFloodInsuranceIndicator |
Base Entity | PROPERTY_DETAIL |
Attribute Name | PropertyFloodInsuranceIndicator |
Logical Rolename | |
ColumnName | PropertyFloodInsuranceIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | An indicator denoting whether the property securing the mortgage has flood insurance. |
Note |
PropertyFloodInsuranceIndicator Logical Attribute Properties |
Logical Attribute Name | PropertyFloodInsuranceIndicator |
Datatype | BIT |
Nullable | NO |
PropertyFloodInsuranceIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyFloodInsuranceIndicator Bound Attachments |
Name | Current Value |
PropertyFloodInsuranceIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyFloodInsuranceIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyFloodInsuranceIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyFloodInsuranceIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyFloodInsuranceIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyGroundLeaseExpirationDate |
Base Entity | PROPERTY_DETAIL |
Attribute Name | PropertyGroundLeaseExpirationDate |
Logical Rolename | |
ColumnName | PropertyGroundLeaseExpirationDate |
RoleName | |
Domain | MISMODate |
Definition | The final expiration date of the ground lease. |
Note |
PropertyGroundLeaseExpirationDate Logical Attribute Properties |
Logical Attribute Name | PropertyGroundLeaseExpirationDate |
Datatype | DATE |
Nullable | NO |
PropertyGroundLeaseExpirationDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyGroundLeaseExpirationDate Bound Attachments |
Name | Current Value |
PropertyGroundLeaseExpirationDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyGroundLeaseExpirationDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyGroundLeaseExpirationDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyGroundLeaseExpirationDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyGroundLeaseExpirationDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyGroundLeasePerpetualIndicator |
Base Entity | PROPERTY_DETAIL |
Attribute Name | PropertyGroundLeasePerpetualIndicator |
Logical Rolename | |
ColumnName | PropertyGroundLeasePerpetualIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates that the ground lease is renewable in perpetuity. |
Note |
PropertyGroundLeasePerpetualIndicator Logical Attribute Properties |
Logical Attribute Name | PropertyGroundLeasePerpetualIndicator |
Datatype | BIT |
Nullable | NO |
PropertyGroundLeasePerpetualIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyGroundLeasePerpetualIndicator Bound Attachments |
Name | Current Value |
PropertyGroundLeasePerpetualIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyGroundLeasePerpetualIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyGroundLeasePerpetualIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyGroundLeasePerpetualIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyGroundLeasePerpetualIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyInclusionaryZoningIndicator |
Base Entity | PROPERTY_DETAIL |
Attribute Name | PropertyInclusionaryZoningIndicator |
Logical Rolename | |
ColumnName | PropertyInclusionaryZoningIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates that the subject property is subject to Inclusionary zoning, a land-use concept in which builders include a certain amount of housing for eligible borrowers, usually low- and moderate-income households in exchange for considerations, such as low |
Note |
PropertyInclusionaryZoningIndicator Logical Attribute Properties |
Logical Attribute Name | PropertyInclusionaryZoningIndicator |
Datatype | BIT |
Nullable | NO |
PropertyInclusionaryZoningIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyInclusionaryZoningIndicator Bound Attachments |
Name | Current Value |
PropertyInclusionaryZoningIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyInclusionaryZoningIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyInclusionaryZoningIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyInclusionaryZoningIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyInclusionaryZoningIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyOccupancyStatusType |
Base Entity | PROPERTY_DETAIL |
Attribute Name | PropertyOccupancyStatusType |
Logical Rolename | |
ColumnName | PropertyOccupancyStatusType |
RoleName | |
Domain | PropertyOccupancyStatusEnum |
Definition | Based on current property inspection result the occupancy status of the property |
Note |
PropertyOccupancyStatusType Logical Attribute Properties |
Logical Attribute Name | PropertyOccupancyStatusType |
Datatype | VARCHAR(0) |
Nullable | YES |
PropertyOccupancyStatusType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyOccupancyStatusType Reference Value (Bound to Domain) |
Name | ValidationRule396 |
Description | |
Type | By List |
Value | Value Description |
Abandoned | Real property to which the owner has voluntarily and intentionally relinquished ownership, possession, claim and control. |
Occupied | Occupied |
Unknown | Unknown |
Vacant | Vacant |
PropertyOccupancyStatusType Bound Attachments |
Name | Current Value |
PropertyOccupancyStatusType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyOccupancyStatusType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyOccupancyStatusType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyOccupancyStatusType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyOccupancyStatusType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyOriginalCostAmount |
Base Entity | PROPERTY_DETAIL |
Attribute Name | PropertyOriginalCostAmount |
Logical Rolename | |
ColumnName | PropertyOriginalCostAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The original cost of acquiring the entire property - land and structure. This is used for refinance loans. |
Note |
PropertyOriginalCostAmount Logical Attribute Properties |
Logical Attribute Name | PropertyOriginalCostAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
PropertyOriginalCostAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyOriginalCostAmount Bound Attachments |
Name | Current Value |
PropertyOriginalCostAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyOriginalCostAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyOriginalCostAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyOriginalCostAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyOriginalCostAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyPreviouslyOccupiedIndicator |
Base Entity | PROPERTY_DETAIL |
Attribute Name | PropertyPreviouslyOccupiedIndicator |
Logical Rolename | |
ColumnName | PropertyPreviouslyOccupiedIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates that the property has been previously occupied. |
Note |
PropertyPreviouslyOccupiedIndicator Logical Attribute Properties |
Logical Attribute Name | PropertyPreviouslyOccupiedIndicator |
Datatype | BIT |
Nullable | NO |
PropertyPreviouslyOccupiedIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyPreviouslyOccupiedIndicator Bound Attachments |
Name | Current Value |
PropertyPreviouslyOccupiedIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyPreviouslyOccupiedIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyPreviouslyOccupiedIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyPreviouslyOccupiedIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyPreviouslyOccupiedIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyStructureBuiltYear |
Base Entity | PROPERTY_DETAIL |
Attribute Name | PropertyStructureBuiltYear |
Logical Rolename | |
ColumnName | PropertyStructureBuiltYear |
RoleName | |
Domain | MISMOYear |
Definition | The year in which the dwelling on the property was completed. |
Note |
PropertyStructureBuiltYear Logical Attribute Properties |
Logical Attribute Name | PropertyStructureBuiltYear |
Datatype | DATE |
Nullable | NO |
PropertyStructureBuiltYear Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyStructureBuiltYear Bound Attachments |
Name | Current Value |
PropertyStructureBuiltYear User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyStructureBuiltYear Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyStructureBuiltYear Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyStructureBuiltYear Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyStructureBuiltYear Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyStructureBuiltYearEstimatedIndicator |
Base Entity | PROPERTY_DETAIL |
Attribute Name | PropertyStructureBuiltYearEstimatedIndicator |
Logical Rolename | |
ColumnName | PropertyStructureBuiltYearEstimatedIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates that the structure year built referenced is an estimate. |
Note |
PropertyStructureBuiltYearEstimatedIndicator Logical Attribute Properties |
Logical Attribute Name | PropertyStructureBuiltYearEstimatedIndicator |
Datatype | BIT |
Nullable | NO |
PropertyStructureBuiltYearEstimatedIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyStructureBuiltYearEstimatedIndicator Bound Attachments |
Name | Current Value |
PropertyStructureBuiltYearEstimatedIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyStructureBuiltYearEstimatedIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyStructureBuiltYearEstimatedIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyStructureBuiltYearEstimatedIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyStructureBuiltYearEstimatedIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyStructureHabitableYearRoundIndicator |
Base Entity | PROPERTY_DETAIL |
Attribute Name | PropertyStructureHabitableYearRoundIndicator |
Logical Rolename | |
ColumnName | PropertyStructureHabitableYearRoundIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates that the structure or improvement is habitable year round. |
Note |
PropertyStructureHabitableYearRoundIndicator Logical Attribute Properties |
Logical Attribute Name | PropertyStructureHabitableYearRoundIndicator |
Datatype | BIT |
Nullable | NO |
PropertyStructureHabitableYearRoundIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyStructureHabitableYearRoundIndicator Bound Attachments |
Name | Current Value |
PropertyStructureHabitableYearRoundIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyStructureHabitableYearRoundIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyStructureHabitableYearRoundIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyStructureHabitableYearRoundIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyStructureHabitableYearRoundIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyUsageType |
Base Entity | PROPERTY_DETAIL |
Attribute Name | PropertyUsageType |
Logical Rolename | |
ColumnName | PropertyUsageType |
RoleName | |
Domain | PropertyUsageEnum |
Definition | Specifies the usage intention of the borrower for the property. |
Note |
PropertyUsageType Logical Attribute Properties |
Logical Attribute Name | PropertyUsageType |
Datatype | VARCHAR(0) |
Nullable | YES |
PropertyUsageType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyUsageType Reference Value (Bound to Domain) |
Name | ValidationRule399 |
Description | |
Type | By List |
Value | Value Description |
Investment | A home owned for the purpose of generating income by renting the property. |
Other | Other |
PrimaryResidence | Residence that the owner physically occupies and uses as his or her principal residence. |
SecondHome | A property occupied by the owner for a portion of the year and is not the primary residence. |
PropertyUsageType Bound Attachments |
Name | Current Value |
PropertyUsageType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyUsageType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyUsageType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyUsageType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyUsageType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyUsageTypeOtherDescription |
Base Entity | PROPERTY_DETAIL |
Attribute Name | PropertyUsageTypeOtherDescription |
Logical Rolename | |
ColumnName | PropertyUsageTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free form text field used to collect additional information when Other is selected for Property Occupancy Type. |
Note |
PropertyUsageTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | PropertyUsageTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
PropertyUsageTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyUsageTypeOtherDescription Bound Attachments |
Name | Current Value |
PropertyUsageTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyUsageTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyUsageTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyUsageTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyUsageTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PUDIndicator |
Base Entity | PROPERTY_DETAIL |
Attribute Name | PUDIndicator |
Logical Rolename | |
ColumnName | PUDIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates that the project in which the subject property is located is a Planned Unit Development (PUD). A comprehensive development plan for a large land area. A PUD usually includes residences, roads, schools, recreational facilities, commercial, office |
Note |
PUDIndicator Logical Attribute Properties |
Logical Attribute Name | PUDIndicator |
Datatype | BIT |
Nullable | NO |
PUDIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PUDIndicator Bound Attachments |
Name | Current Value |
PUDIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PUDIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUDIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUDIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PUDIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
UniqueDwellingType |
Base Entity | PROPERTY_DETAIL |
Attribute Name | UniqueDwellingType |
Logical Rolename | |
ColumnName | UniqueDwellingType |
RoleName | |
Domain | UniqueDwellingEnum |
Definition | A dwelling that does not conform to a conventional building structure type or method. |
Note |
UniqueDwellingType Logical Attribute Properties |
Logical Attribute Name | UniqueDwellingType |
Datatype | VARCHAR(0) |
Nullable | YES |
UniqueDwellingType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
UniqueDwellingType Reference Value (Bound to Domain) |
Name | ValidationRule477 |
Description | |
Type | By List |
Value | Value Description |
EarthShelterHome | A dwelling built with mounds of dirt (earth) covering one or more exterior walls and/or roof. |
GeodesicDome | A spherical structure designed as a dwelling unit. |
Houseboat | A boat that has been designed or modified to be used primarily as a dwelling unit. |
LogHome | A dwelling made from logs that have not been milled in to conventional lumber. |
Other | Other |
UniqueDwellingType Bound Attachments |
Name | Current Value |
UniqueDwellingType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
UniqueDwellingType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
UniqueDwellingType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
UniqueDwellingType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
UniqueDwellingType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
UniqueDwellingTypeOtherDescription |
Base Entity | PROPERTY_DETAIL |
Attribute Name | UniqueDwellingTypeOtherDescription |
Logical Rolename | |
ColumnName | UniqueDwellingTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A text field used to describe the Unique Dwelling when "Other" is selected from the enumerated list. |
Note |
UniqueDwellingTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | UniqueDwellingTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
UniqueDwellingTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
UniqueDwellingTypeOtherDescription Bound Attachments |
Name | Current Value |
UniqueDwellingTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
UniqueDwellingTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
UniqueDwellingTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
UniqueDwellingTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
UniqueDwellingTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
WindstormInsuranceRequiredIndicator |
Base Entity | PROPERTY_DETAIL |
Attribute Name | WindstormInsuranceRequiredIndicator |
Logical Rolename | |
ColumnName | WindstormInsuranceRequiredIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates that Windstorm Insurance coverage is required for the property |
Note |
WindstormInsuranceRequiredIndicator Logical Attribute Properties |
Logical Attribute Name | WindstormInsuranceRequiredIndicator |
Datatype | BIT |
Nullable | NO |
WindstormInsuranceRequiredIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
WindstormInsuranceRequiredIndicator Bound Attachments |
Name | Current Value |
WindstormInsuranceRequiredIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
WindstormInsuranceRequiredIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
WindstormInsuranceRequiredIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
WindstormInsuranceRequiredIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
WindstormInsuranceRequiredIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |