HOUSING 
EntityType  Dependent 
Logical Entity Name  HOUSING 
Default Table Name  DEAL/SERVICES/SERVICE/TITLE/TITLE_RESPONSE/PROPERTY/NEIGHBORHOOD/HOUSINGS/HOUSING 
Definition   
Note 
 

HOUSING Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
SequenceNumber  XSD:Integer  INTEGER  YES  An integer value used to provide an order to multi-instance sibling elements. The value must be unique for each sibling element. 
NeighborhoodBuiltUpRangeType  NeighborhoodBuiltUpRangeEnum  VARCHAR(0)  YES  Specifies an estimated percentage range of available land in the neighborhood that has been improved.
 
NeighborhoodDemandSupplyType  NeighborhoodDemandSupplyEnum  VARCHAR(0)  YES  Specifies the state of market demand versus the supply of properties in the neighborhood.
 
NeighborhoodHousingHighPriceAmount  MISMOAmount  DECIMAL(0, 2)  NO  The high price of the neighborhood housing specified in Neighborhood Housing Type. 
NeighborhoodHousingLowPriceAmount  MISMOAmount  DECIMAL(0, 2)  NO  The low price of the neighborhood housing specified in Neighborhood Housing Type. 
NeighborhoodHousingNewestYearsCount  MISMOCount  INTEGER  NO  The age, in years, of the newest neighborhood housing specified in Neighborhood Housing Type. 
NeighborhoodHousingOldestYearsCount  MISMOCount  INTEGER  NO  The age, in years, of the oldest neighborhood housing specified in Neighborhood Housing Type. 
NeighborhoodHousingPredominantAgeYearsCount  MISMOCount  INTEGER  NO  The predominate age, in years, of the neighborhood housing specified by Neighborhood Housing Type. 
NeighborhoodHousingPredominantOccupancyType  NeighborhoodHousingPredominantOccupancyEnum  VARCHAR(0)  YES  The predominant occupancy for the specified Neighborhood Housing Type
 
NeighborhoodHousingPredominantPriceAmount  MISMOAmount  DECIMAL(0, 2)  NO  The predominate price of the neighborhood housing specified by Neighborhood Housing Type. 
NeighborhoodHousingType  NeighborhoodHousingEnum  VARCHAR(0)  YES  Specifies a type of housing found in the neighborhood.
 
NeighborhoodHousingTypeOtherDescription  MISMOString  VARCHAR(0)  NO  A free-form text field used to describe the neighborhood housing type if Other is selected as the Neighborhood Housing Type. 
NeighborhoodOwnerOccupancyPercent  MISMOPercent  DECIMAL(0, 2)  NO  The percentage of owner occupied in the specified neighborhood. 
NeighborhoodPropertyValueTrendType  NeighborhoodPropertyValueTrendEnum  VARCHAR(0)  YES  Specifies the current trend of property values in the neighborhood.
 
NeighborhoodTypicalMarketingDaysDurationCount  MISMOCount  INTEGER  NO  Specifies the length of time in terms of days that a property typical to the neighborhood would stay on the market before being sold. 
NeighborhoodTypicalMarketingMonthsDurationType  NeighborhoodTypicalMarketingMonthsDurationEnum  VARCHAR(0)  YES  Specifies the length of time in terms of months that a property typical to the neighborhood would stay on the market before being sold.
 

HOUSING Keys 
Key Name  Key Type  Keys 

HOUSING Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
HOUSINGS  Identifying  One To Zero or More          NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 

HOUSING Check Constraints 
Check Constraint Name  CheckConstraint 

HOUSING Bound Attachments 
Name  Current Value 

HOUSING User-Defined Mappings 
Model  Name  Description 

HOUSING Data Movement Rules 
Name  Type  Rule Text/Value