| PROPERTY_TITLE |
| EntityType | Independent |
| Logical Entity Name | PROPERTY_TITLE |
| Default Table Name | DEAL/SERVICES/SERVICE/TITLE/TITLE_RESPONSE/PROPERTY/PROPERTY_TITLE |
| Definition | Included Title related information necesary in Secondary Loan Delivery. This is not information captured or reported during the Title Request/Response interaction. |
| Note |
| PROPERTY_TITLE Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| PropertyTitleTransferInspectionRequiredDescription | MISMOString | VARCHAR(0) | NO | A free-form text field used to comment on the title transfer inspections of the property. |
| PropertyTitleTransferInspectionRequiredIndicator | MISMOIndicator | BIT | NO | Indicates that an inspection of the property is required before the title can be transferred. |
| SellerPropertyAcquisitionDate | MISMODate | DATE | NO | Date seller acquired the proprerty as documented on the Title Report |
| TitleHolderCount | MISMOCount | INTEGER | NO | The total number of property sellers (excluding Company Owned Properties) from the Title Report. |
| TitlePreliminaryReportDate | MISMODate | DATE | NO | The date on the preliminary title report. |
| TitleProcessInsuranceType | TitleProcessInsuranceEnum | VARCHAR(0) | YES | Identifies the level of insurance being requested or delivered for the Title Process Type. |
| TitleProcessType | TitleProcessEnum | VARCHAR(0) | YES | Specifies the means used to determine that there are no legal claims against the subject property that have a higher priority than the loan. |
| TitleProcessTypeOtherDescription | MISMOString | VARCHAR(0) | NO | A free-form text field used to capture additional information when Other is selected for Title Process Type. |
| TitleReportItemsDescription | MISMOString | VARCHAR(0) | NO | A free form text field used to communicate remarks pertaining to items contained within the Title Report. |
| TitleReportRequiredEndorsementsDescription | MISMOString | VARCHAR(0) | NO | A free form text field used to describe any required endorsements noted in the Title Report. |
| TitleTransferredPastSixMonthsIndicator | MISMOIndicator | BIT | NO | Indicates that the property has been transferred in the past 6 months. |
| PROPERTY_TITLE Keys |
| Key Name | Key Type | Keys |
| PROPERTY_TITLE 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_TITLE Check Constraints |
| Check Constraint Name | CheckConstraint |
| PROPERTY_TITLE Bound Attachments |
| Name | Current Value |
| PROPERTY_TITLE User-Defined Mappings |
| Model | Name | Description |
| PROPERTY_TITLE Data Movement Rules |
| Name | Type | Rule Text/Value |