MANUFACTURED_HOME_DETAIL 
EntityType  Dependent 
Logical Entity Name  MANUFACTURED_HOME_DETAIL 
Default Table Name  DEAL/SERVICES/SERVICE/TITLE/TITLE_RESPONSE/PROPERTY/MANUFACTURED_HOME/MANUFACTURED_HOME_DETAIL 
Definition   
Note 
 

MANUFACTURED_HOME_DETAIL Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
LengthFeetNumber  MISMONumeric  DECIMAL(0, 2)  NO  The length measured in linear feet. 
ManufacturedHomeAttachedToFoundationDescription  MISMOString  VARCHAR(0)  NO  A free-form text field descibing how the manufactured home is attached to a permanent foundation 
ManufacturedHomeAttachedToFoundationIndicator  MISMOIndicator  BIT  NO  Indicates that the manufactured home is attached to its foundation 
ManufacturedHomeConditionDescriptionType  ManufacturedHomeConditionDescriptionEnum  VARCHAR(0)  YES  The description of the condition of the manufactured home.
 
ManufacturedHomeConnectedToUtilitiesIndicator  MISMOIndicator  BIT  NO  Identifies the total area measured in square feet. 
ManufacturedHomeConnectionToUtilitiesDescription  MISMOString  VARCHAR(0)  NO  A free-form text field describing the nature of the attachments the manufactured home has to utilities (e.g. electricity, gas) 
ManufacturedHomeConstructionQualityRatingType  ManufacturedHomeConstructionQualityRatingEnum  VARCHAR(0)  YES  A rating of the quality of construction of the manufactured home based on objective criteria such as NADA Manufactured Housing Appraisal Guide, Marshall and Swift Residential Cost Handbook or other published cost source.
 
ManufacturedHomeConstructionQualitySourceDescription  MISMOString  VARCHAR(0)  NO  Identifies the source used for the Manufactured Home Construction Quality Rating Type 
ManufacturedHomeDeckDescription  MISMOString  VARCHAR(0)  NO  A free-form text field used to describe the deck of the Manufactured home 
ManufacturedHomeHUDCertificationLabelAttachedIndicator  MISMOIndicator  BIT  NO  Indicates that the manufactured home has a HUD certification label attached to every segment. 
ManufacturedHomeHUDCertificationLabelDataSourceDescription  MISMOString  VARCHAR(0)  NO  A free-form text field describing the source of the information about HUD certification label if it is not attached to the manufactured home. 
ManufacturedHomeHUDDataPlateAttachedIndicator  MISMOIndicator  BIT  NO  Indicates that the manufactured home has a HUD data plate attached. 
ManufacturedHomeHUDDataPlateDataSourceDescription  MISMOString  VARCHAR(0)  NO  A free-form text field describing the source of information about the HUD data plate if it is not attached to the manufactured home. 
ManufacturedHomeHUDDataPlateIdentifier  MISMOIdentifier  VARCHAR(0)  NO  An identifier that is assigned by the manufacturer to an individual manufactured home unit. It may be found on the HUD Data Plate, which is affixed to the interior of the manufactured home. 
ManufacturedHomeInstalledDate  MISMODate  DATE  NO  Reports the date a Certificate of Occupancy or its equivalent was issued for the development of a lot and placement of a manufactured home on a permanent foundation. 
ManufacturedHomeInstallerName  MISMOString  VARCHAR(0)  NO  A free-form text field holding the name of the installer. 
ManufacturedHomeInteriorSpaceAcceptabilityToMarketDescription  MISMOString  VARCHAR(0)  NO  A free-form text field describing the acceptability of the interior space of the manufactured home to the market 
ManufacturedHomeInteriorSpaceAcceptableToMarketIndicator  MISMOIndicator  BIT  NO  Indicates that the interior space of the manufactured home is acceptable to the market 
ManufacturedHomeInvoiceReviewDescription  MISMOString  VARCHAR(0)  NO  A free-form text field describing the result of the review and analysis of the invoice of the manufacturer of the manufactured home 
ManufacturedHomeInvoiceReviewedIndicator  MISMOIndicator  BIT  NO  Indicates that the appraiser reviewed and analyzed the invoice of the manufacturer for the manufactured home. 
ManufacturedHomeMakeName  MISMOString  VARCHAR(0)  NO  The name of the manufacturer (maker) of the Manufactured home. 
ManufacturedHomeManufacturerName  MISMOString  VARCHAR(0)  NO  The name of the manufacturer (maker) of the Manufactured home. 
ManufacturedHomeManufactureYear  MISMOYear  DATE  NO  Reports the year the manufactured home was built. 
ManufacturedHomeMeetsHUDRequirementsForLocationDescription  MISMOString  VARCHAR(0)  NO  A free-form text field describing how the manufactured home meets meet the HUD Wind Road Load and Thermal Zone requirements for its location. 
ManufacturedHomeMeetsHUDRequirementsForLocationIndicator  MISMOIndicator  BIT  NO  Indicates that the manufactured home meets meet the HUD Wind Road Load and Thermal Zone requirements for its location. 
ManufacturedHomeModelIdentifier  MISMOIdentifier  VARCHAR(0)  NO  The model designation of the Manufactured home (specific to the manufacturer). 
ManufacturedHomeModelYear  MISMOYear  DATE  NO  Reports the model year of the manufactured home. 
ManufacturedHomeModificationsDescription  MISMOString  VARCHAR(0)  NO  A free-form text field describing the modifications made to the manufactured home. 
ManufacturedHomePorchDescription  MISMOString  VARCHAR(0)  NO  A free-form text field used to describe the porch area of a Manufactured home. 
ManufacturedHomeRetailerName  MISMOString  VARCHAR(0)  NO  The name of the retailer seller of the manufactured home. 
ManufacturedHomeSectionCount  MISMOCount  INTEGER  NO  The number of sections of the manufactured home. 
ManufacturedHomeSerialNumberIdentifier  MISMOIdentifier  VARCHAR(0)  NO  The serial number of the manufactured home identifies the manufacturer and the state in which the manufactured home is manufactured. This may be also be called a VIN (Vehicle Identification Number). 
ManufacturedHomeTipOutDescription  MISMOString  VARCHAR(0)  NO  A free-form text field used to describe the tip out (extendable) portion of the Manufactured home. 
ManufacturedHomeWaniganDescription  MISMOString  VARCHAR(0)  NO  A free-form text field used to describe an addition built onto a trailer house for extra living or storage space. 
ManufacturedHomeWheelsDescription  MISMOString  VARCHAR(0)  NO  A free-form text field describing the status and usability of the wheels, axels, and tires of the manufactured home. This description can report on the immobility of the home for classification purposes. 
ManufacturedHomeWheelsRemovedIndicator  MISMOIndicator  BIT  NO  Indicates that the wheels, axels, and tires have been removed from the manufactured home . 
ManufacturedHomeWidthType  ManufacturedHomeWidthEnum  VARCHAR(0)  YES  Specifies the common size (width) designation of a Manufactured home.
 
MobileHomeParkIndicator  MISMOIndicator  BIT  NO  Indicates whether the manufactured home is part of a mobile home park. 
SquareFeetNumber  MISMONumeric  DECIMAL(0, 2)  NO  Identifies the total area measured in square feet. 
WidthFeetNumber  MISMONumeric  DECIMAL(0, 2)  NO  The width measured in linear feet. 

MANUFACTURED_HOME_DETAIL Keys 
Key Name  Key Type  Keys 

MANUFACTURED_HOME_DETAIL Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
MANUFACTURED_HOME  Identifying  One to Zero or One          NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 

MANUFACTURED_HOME_DETAIL Check Constraints 
Check Constraint Name  CheckConstraint 

MANUFACTURED_HOME_DETAIL Bound Attachments 
Name  Current Value 

MANUFACTURED_HOME_DETAIL User-Defined Mappings 
Model  Name  Description 

MANUFACTURED_HOME_DETAIL Data Movement Rules 
Name  Type  Rule Text/Value