| STRUCTURE_ANALYSIS_DETAIL |
| EntityType | Dependent |
| Logical Entity Name | STRUCTURE_ANALYSIS_DETAIL |
| Default Table Name | DEAL/SERVICES/SERVICE/TITLE/TITLE_RESPONSE/PROPERTY/IMPROVEMENT/STRUCTURE/STRUCTURE_ANALYSES/STRUCTURE_ANALYSIS/STRUCTURE_ANALYSIS_DETAIL |
| Definition | |
| Note |
| STRUCTURE_ANALYSIS_DETAIL Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| EffectiveAgeRangeHighYearsCount | MISMOCount | INTEGER | NO | High end of the range of the estimated effective age reflecting condition and deterioration |
| EffectiveAgeRangeLowYearsCount | MISMOCount | INTEGER | NO | Low end of the range of the estimated effective age reflecting condition and deterioration |
| EffectiveAgeYearsCount | MISMOCount | INTEGER | NO | The estimated effective age reflecting condition and deterioration |
| RemainingEconomicLifeRangeHighYearsCount | MISMOCount | INTEGER | NO | High end of the range of the estimated remaining economic life. |
| RemainingEconomicLifeRangeLowYearsCount | MISMOCount | INTEGER | NO | Low end of the range of the estimated remaining economic life. |
| StructureAppealDescription | MISMOString | VARCHAR(0) | NO | A free-form text field used to describe aspects of the structure that add or detract from its appeal. |
| STRUCTURE_ANALYSIS_DETAIL Keys |
| Key Name | Key Type | Keys |
| STRUCTURE_ANALYSIS_DETAIL Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| STRUCTURE_ANALYSIS | Identifying | One to Zero or One | NO |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| STRUCTURE_ANALYSIS_DETAIL Check Constraints |
| Check Constraint Name | CheckConstraint |
| STRUCTURE_ANALYSIS_DETAIL Bound Attachments |
| Name | Current Value |
| STRUCTURE_ANALYSIS_DETAIL User-Defined Mappings |
| Model | Name | Description |
| STRUCTURE_ANALYSIS_DETAIL Data Movement Rules |
| Name | Type | Rule Text/Value |