PropertyTitleTransferInspectionRequiredDescription |
Base Entity | PROPERTY_TITLE |
Attribute Name | PropertyTitleTransferInspectionRequiredDescription |
Logical Rolename | |
ColumnName | PropertyTitleTransferInspectionRequiredDescription |
RoleName | |
Domain | MISMOString |
Definition | A free-form text field used to comment on the title transfer inspections of the property. |
Note |
PropertyTitleTransferInspectionRequiredDescription Logical Attribute Properties |
Logical Attribute Name | PropertyTitleTransferInspectionRequiredDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
PropertyTitleTransferInspectionRequiredDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyTitleTransferInspectionRequiredDescription Bound Attachments |
Name | Current Value |
PropertyTitleTransferInspectionRequiredDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyTitleTransferInspectionRequiredDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTitleTransferInspectionRequiredDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTitleTransferInspectionRequiredDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTitleTransferInspectionRequiredDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTitleTransferInspectionRequiredIndicator |
Base Entity | PROPERTY_TITLE |
Attribute Name | PropertyTitleTransferInspectionRequiredIndicator |
Logical Rolename | |
ColumnName | PropertyTitleTransferInspectionRequiredIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates that an inspection of the property is required before the title can be transferred. |
Note |
PropertyTitleTransferInspectionRequiredIndicator Logical Attribute Properties |
Logical Attribute Name | PropertyTitleTransferInspectionRequiredIndicator |
Datatype | BIT |
Nullable | NO |
PropertyTitleTransferInspectionRequiredIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyTitleTransferInspectionRequiredIndicator Bound Attachments |
Name | Current Value |
PropertyTitleTransferInspectionRequiredIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyTitleTransferInspectionRequiredIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTitleTransferInspectionRequiredIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTitleTransferInspectionRequiredIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTitleTransferInspectionRequiredIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SellerPropertyAcquisitionDate |
Base Entity | PROPERTY_TITLE |
Attribute Name | SellerPropertyAcquisitionDate |
Logical Rolename | |
ColumnName | SellerPropertyAcquisitionDate |
RoleName | |
Domain | MISMODate |
Definition | Date seller acquired the proprerty as documented on the Title Report |
Note |
SellerPropertyAcquisitionDate Logical Attribute Properties |
Logical Attribute Name | SellerPropertyAcquisitionDate |
Datatype | DATE |
Nullable | NO |
SellerPropertyAcquisitionDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SellerPropertyAcquisitionDate Bound Attachments |
Name | Current Value |
SellerPropertyAcquisitionDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
SellerPropertyAcquisitionDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SellerPropertyAcquisitionDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SellerPropertyAcquisitionDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SellerPropertyAcquisitionDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TitleHolderCount |
Base Entity | PROPERTY_TITLE |
Attribute Name | TitleHolderCount |
Logical Rolename | |
ColumnName | TitleHolderCount |
RoleName | |
Domain | MISMOCount |
Definition | The total number of property sellers (excluding Company Owned Properties) from the Title Report. |
Note |
TitleHolderCount Logical Attribute Properties |
Logical Attribute Name | TitleHolderCount |
Datatype | INTEGER |
Nullable | NO |
TitleHolderCount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TitleHolderCount Bound Attachments |
Name | Current Value |
TitleHolderCount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
TitleHolderCount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TitleHolderCount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TitleHolderCount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TitleHolderCount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TitlePreliminaryReportDate |
Base Entity | PROPERTY_TITLE |
Attribute Name | TitlePreliminaryReportDate |
Logical Rolename | |
ColumnName | TitlePreliminaryReportDate |
RoleName | |
Domain | MISMODate |
Definition | The date on the preliminary title report. |
Note |
TitlePreliminaryReportDate Logical Attribute Properties |
Logical Attribute Name | TitlePreliminaryReportDate |
Datatype | DATE |
Nullable | NO |
TitlePreliminaryReportDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TitlePreliminaryReportDate Bound Attachments |
Name | Current Value |
TitlePreliminaryReportDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
TitlePreliminaryReportDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TitlePreliminaryReportDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TitlePreliminaryReportDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TitlePreliminaryReportDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TitleProcessInsuranceType |
Base Entity | PROPERTY_TITLE |
Attribute Name | TitleProcessInsuranceType |
Logical Rolename | |
ColumnName | TitleProcessInsuranceType |
RoleName | |
Domain | TitleProcessInsuranceEnum |
Definition | Identifies the level of insurance being requested or delivered for the Title Process Type. |
Note |
TitleProcessInsuranceType Logical Attribute Properties |
Logical Attribute Name | TitleProcessInsuranceType |
Datatype | VARCHAR(0) |
Nullable | YES |
TitleProcessInsuranceType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TitleProcessInsuranceType Reference Value (Bound to Domain) |
Name | ValidationRule472 |
Description | |
Type | By List |
Value | Value Description |
Insurance | Insurance |
LimitedInsurance | LimitedInsurance |
NonInsurance | NonInsurance |
TitleProcessInsuranceType Bound Attachments |
Name | Current Value |
TitleProcessInsuranceType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
TitleProcessInsuranceType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TitleProcessInsuranceType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TitleProcessInsuranceType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TitleProcessInsuranceType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TitleProcessType |
Base Entity | PROPERTY_TITLE |
Attribute Name | TitleProcessType |
Logical Rolename | |
ColumnName | TitleProcessType |
RoleName | |
Domain | TitleProcessEnum |
Definition | Specifies the means used to determine that there are no legal claims against the subject property that have a higher priority than the loan. |
Note |
TitleProcessType Logical Attribute Properties |
Logical Attribute Name | TitleProcessType |
Datatype | VARCHAR(0) |
Nullable | YES |
TitleProcessType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TitleProcessType Reference Value (Bound to Domain) |
Name | ValidationRule471 |
Description | |
Type | By List |
Value | Value Description |
DeedReport | DeedReport |
Other | Other |
TitleSearch | TitleSearch |
TitleProcessType Bound Attachments |
Name | Current Value |
TitleProcessType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
TitleProcessType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TitleProcessType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TitleProcessType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TitleProcessType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TitleProcessTypeOtherDescription |
Base Entity | PROPERTY_TITLE |
Attribute Name | TitleProcessTypeOtherDescription |
Logical Rolename | |
ColumnName | TitleProcessTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free-form text field used to capture additional information when Other is selected for Title Process Type. |
Note |
TitleProcessTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | TitleProcessTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
TitleProcessTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TitleProcessTypeOtherDescription Bound Attachments |
Name | Current Value |
TitleProcessTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
TitleProcessTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TitleProcessTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TitleProcessTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TitleProcessTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TitleReportItemsDescription |
Base Entity | PROPERTY_TITLE |
Attribute Name | TitleReportItemsDescription |
Logical Rolename | |
ColumnName | TitleReportItemsDescription |
RoleName | |
Domain | MISMOString |
Definition | A free form text field used to communicate remarks pertaining to items contained within the Title Report. |
Note |
TitleReportItemsDescription Logical Attribute Properties |
Logical Attribute Name | TitleReportItemsDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
TitleReportItemsDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TitleReportItemsDescription Bound Attachments |
Name | Current Value |
TitleReportItemsDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
TitleReportItemsDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TitleReportItemsDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TitleReportItemsDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TitleReportItemsDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TitleReportRequiredEndorsementsDescription |
Base Entity | PROPERTY_TITLE |
Attribute Name | TitleReportRequiredEndorsementsDescription |
Logical Rolename | |
ColumnName | TitleReportRequiredEndorsementsDescription |
RoleName | |
Domain | MISMOString |
Definition | A free form text field used to describe any required endorsements noted in the Title Report. |
Note |
TitleReportRequiredEndorsementsDescription Logical Attribute Properties |
Logical Attribute Name | TitleReportRequiredEndorsementsDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
TitleReportRequiredEndorsementsDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TitleReportRequiredEndorsementsDescription Bound Attachments |
Name | Current Value |
TitleReportRequiredEndorsementsDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
TitleReportRequiredEndorsementsDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TitleReportRequiredEndorsementsDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TitleReportRequiredEndorsementsDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TitleReportRequiredEndorsementsDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TitleTransferredPastSixMonthsIndicator |
Base Entity | PROPERTY_TITLE |
Attribute Name | TitleTransferredPastSixMonthsIndicator |
Logical Rolename | |
ColumnName | TitleTransferredPastSixMonthsIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates that the property has been transferred in the past 6 months. |
Note |
TitleTransferredPastSixMonthsIndicator Logical Attribute Properties |
Logical Attribute Name | TitleTransferredPastSixMonthsIndicator |
Datatype | BIT |
Nullable | NO |
TitleTransferredPastSixMonthsIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TitleTransferredPastSixMonthsIndicator Bound Attachments |
Name | Current Value |
TitleTransferredPastSixMonthsIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
TitleTransferredPastSixMonthsIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TitleTransferredPastSixMonthsIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TitleTransferredPastSixMonthsIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TitleTransferredPastSixMonthsIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |