PROPERTY_DETAIL 
EntityType  Independent 
Logical Entity Name  PROPERTY_DETAIL 
Default Table Name  DEAL/SERVICES/SERVICE/TITLE/TITLE_RESPONSE/PROPERTY/PROPERTY_DETAIL 
Definition   
Note 
 

PROPERTY_DETAIL Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
AttachmentType  AttachmentEnum  VARCHAR(0)  YES  Specifies the type of physical attachment, if any, between the dwelling unit and adjacent dwelling units.
 
BorrowerContinuesToOwnPropertyIndicator  MISMOIndicator  BIT  NO  When true, indicates that the property associated with the loan is still owned by the borrower(s). 
CommunityLandTrustIndicator  MISMOIndicator  BIT  NO  Indicates the the property is located in a community land trust. 
CommunityReinvestmentActDelineatedCommunityIndicator  MISMOIndicator  BIT  NO  Indicates that the property is in an area defined by the Community Reinvestment Act. 
ConstructionMethodType  ConstructionMethodEnum  VARCHAR(0)  YES  Describes the construction process for the main dwelling unit of the subject property.
 
ConstructionMethodTypeOtherDescription  MISMOString  VARCHAR(0)  NO  A free form text field used to collect additional information when Other is selected for Construction Method Type. 
ConstructionStatusType  ConstructionStatusEnum  VARCHAR(0)  YES  Specifies the physical status of the structure.
 
ConstructionStatusTypeOtherDescription  MISMOString  VARCHAR(0)  NO  A free form text field used to collect additional information when Other is selected for Construction Status Type. 
DeedRestrictionIndicator  MISMOIndicator  BIT  NO  If true, indicates that the deed has associated restrictions. 
EarthquakeInsuranceRequiredIndicator  MISMOIndicator  BIT  NO  Indicates that earthquake insurance coverage is required for the property. 
FinancedUnitCount  MISMOCount  INTEGER  NO  The number of individual family dwelling units being financed in the subject property. 
GrossLivingAreaSquareFeetNumber  MISMONumeric  DECIMAL(0, 2)  NO  The total area of all inhabitable rooms. 
GroupHomeIndicator  MISMOIndicator  BIT  NO  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 
InvestorREOPropertyIdentifier  MISMOIdentifier  VARCHAR(0)  NO  A unique identifier assigned by an investor to a property acquired as the result of delinquency. 
LandTrustType  LandTrustEnum  VARCHAR(0)  YES  Specifies the type of land trust associated with the title.
 
LandTrustTypeOtherDescription  MISMOString  VARCHAR(0)  NO  A free form text field used to collect additional information when Other is selected for Land Trust Type. 
LandUseDescription  MISMOString  VARCHAR(0)  NO  A free-form text field used to further describe the land use of the property as defined by Land Use Type. 
LandUseType  LandUseEnum  VARCHAR(0)  YES  Identifies the designation of land use by a governmental authority described by Land Used Description.
 
LandUseTypeOtherDescription  MISMOString  VARCHAR(0)  NO  A free-form text field used to describe the land use designation if Other is selected as the Property Land Use Type. 
LenderDesignatedDecliningMarketIdentifier  MISMOIdentifier  VARCHAR(0)  NO  Identifies the type of declining market based on lender anaylsis. 
NativeAmericanLandsType  NativeAmericanLandsEnum  VARCHAR(0)  YES  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.
 
NativeAmericanLandsTypeOtherDescription  MISMOString  VARCHAR(0)  NO  A free form text field used to collect additional information when Other is selected for Native American Lands Type. 
PriorSaleInLastTwelveMonthsIndicator  MISMOIndicator  BIT  NO  Indicates that property has been sold in the twelve months prior to origination of the delivery loan. 
PropertyAcquiredDate  MISMODate  DATE  NO  The date the property was acquired. 
PropertyAcquiredYear  MISMOYear  DATE  NO  The year in which the land and buildings of the property were acquired by the borrower. 
PropertyAcreageNumber  MISMONumeric  DECIMAL(0, 2)  NO  Number of acres of the subject property. 
PropertyConditionDescription  MISMOString  VARCHAR(0)  NO  A free-form text field describing the condition of the property 
PropertyCurrentOccupancyType  PropertyCurrentOccupancyEnum  VARCHAR(0)  YES  Specifies the property occupancy status of a subject property.
 
PropertyCurrentOccupantName  MISMOString  VARCHAR(0)  NO  The unparsed name of the current occupant of the property. 
PropertyEarthquakeInsuranceIndicator  MISMOIndicator  BIT  NO  An indicator denoting whether the property securing the mortgage has earthquake insurance. 
PropertyEstateType  PropertyEstateEnum  VARCHAR(0)  YES  Specifies the ownership interest in the property.
 
PropertyEstateTypeOtherDescription  MISMOString  VARCHAR(0)  NO  A free-form text field used to collect additional information when Other is selected for Property Estate Type. 
PropertyExistingLienAmount  MISMOAmount  DECIMAL(0, 2)  NO  The total amount of liens against the property at time of application for a loan. Used for Construction or Refinance loans. 
PropertyFloodInsuranceIndicator  MISMOIndicator  BIT  NO  An indicator denoting whether the property securing the mortgage has flood insurance. 
PropertyGroundLeaseExpirationDate  MISMODate  DATE  NO  The final expiration date of the ground lease. 
PropertyGroundLeasePerpetualIndicator  MISMOIndicator  BIT  NO  Indicates that the ground lease is renewable in perpetuity. 
PropertyInclusionaryZoningIndicator  MISMOIndicator  BIT  NO  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 
PropertyOccupancyStatusType  PropertyOccupancyStatusEnum  VARCHAR(0)  YES  Based on current property inspection result the occupancy status of the property
 
PropertyOriginalCostAmount  MISMOAmount  DECIMAL(0, 2)  NO  The original cost of acquiring the entire property - land and structure. This is used for refinance loans. 
PropertyPreviouslyOccupiedIndicator  MISMOIndicator  BIT  NO  Indicates that the property has been previously occupied. 
PropertyStructureBuiltYear  MISMOYear  DATE  NO  The year in which the dwelling on the property was completed. 
PropertyStructureBuiltYearEstimatedIndicator  MISMOIndicator  BIT  NO  Indicates that the structure year built referenced is an estimate. 
PropertyStructureHabitableYearRoundIndicator  MISMOIndicator  BIT  NO  Indicates that the structure or improvement is habitable year round. 
PropertyUsageType  PropertyUsageEnum  VARCHAR(0)  YES  Specifies the usage intention of the borrower for the property.
 
PropertyUsageTypeOtherDescription  MISMOString  VARCHAR(0)  NO  A free form text field used to collect additional information when Other is selected for Property Occupancy Type. 
PUDIndicator  MISMOIndicator  BIT  NO  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 
UniqueDwellingType  UniqueDwellingEnum  VARCHAR(0)  YES  A dwelling that does not conform to a conventional building structure type or method.
 
UniqueDwellingTypeOtherDescription  MISMOString  VARCHAR(0)  NO  A text field used to describe the Unique Dwelling when "Other" is selected from the enumerated list. 
WindstormInsuranceRequiredIndicator  MISMOIndicator  BIT  NO  Indicates that Windstorm Insurance coverage is required for the property 

PROPERTY_DETAIL Keys 
Key Name  Key Type  Keys 

PROPERTY_DETAIL Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
PROPERTY  Non-Identifying  Zero or One to Zero or One          NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 

PROPERTY_DETAIL Check Constraints 
Check Constraint Name  CheckConstraint 

PROPERTY_DETAIL Bound Attachments 
Name  Current Value 

PROPERTY_DETAIL User-Defined Mappings 
Model  Name  Description 

PROPERTY_DETAIL Data Movement Rules 
Name  Type  Rule Text/Value