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