| MERS_IRegistrationIndicator |
| Base Entity | MERS_REGISTRATION |
| Attribute Name | MERS_IRegistrationIndicator |
| Logical Rolename | |
| ColumnName | MERS_IRegistrationIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates the loan is registered on the MERS System for information only. MERS is not the mortgagee. |
| Note |
| MERS_IRegistrationIndicator Logical Attribute Properties |
| Logical Attribute Name | MERS_IRegistrationIndicator |
| Datatype | BIT |
| Nullable | NO |
| MERS_IRegistrationIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| MERS_IRegistrationIndicator Bound Attachments |
| Name | Current Value |
| MERS_IRegistrationIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| MERS_IRegistrationIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MERS_IRegistrationIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MERS_IRegistrationIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MERS_IRegistrationIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SequenceNumber |
| Base Entity | MERS_REGISTRATION |
| Attribute Name | SequenceNumber |
| Logical Rolename | |
| ColumnName | SequenceNumber |
| RoleName | |
| Domain | XSD:Integer |
| Definition | An integer value used to provide an order to multi-instance sibling elements. The value must be unique for each sibling element. |
| Note |
| SequenceNumber Logical Attribute Properties |
| Logical Attribute Name | SequenceNumber |
| Datatype | INTEGER |
| Nullable | YES |
| SequenceNumber Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SequenceNumber Bound Attachments |
| Name | Current Value |
| SequenceNumber User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| SequenceNumber Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SequenceNumber Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SequenceNumber Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SequenceNumber Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MERSOriginalMortgageeOfRecordIndicator |
| Base Entity | MERS_REGISTRATION |
| Attribute Name | MERSOriginalMortgageeOfRecordIndicator |
| Logical Rolename | |
| ColumnName | MERSOriginalMortgageeOfRecordIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates whether the loan was originated with MERS as the original mortgagee of record (MOM). |
| Note |
| MERSOriginalMortgageeOfRecordIndicator Logical Attribute Properties |
| Logical Attribute Name | MERSOriginalMortgageeOfRecordIndicator |
| Datatype | BIT |
| Nullable | NO |
| MERSOriginalMortgageeOfRecordIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| MERSOriginalMortgageeOfRecordIndicator Bound Attachments |
| Name | Current Value |
| MERSOriginalMortgageeOfRecordIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| MERSOriginalMortgageeOfRecordIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MERSOriginalMortgageeOfRecordIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MERSOriginalMortgageeOfRecordIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MERSOriginalMortgageeOfRecordIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MERSRegistrationDate |
| Base Entity | MERS_REGISTRATION |
| Attribute Name | MERSRegistrationDate |
| Logical Rolename | |
| ColumnName | MERSRegistrationDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The date the loan was registered with MERS. |
| Note |
| MERSRegistrationDate Logical Attribute Properties |
| Logical Attribute Name | MERSRegistrationDate |
| Datatype | DATE |
| Nullable | NO |
| MERSRegistrationDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| MERSRegistrationDate Bound Attachments |
| Name | Current Value |
| MERSRegistrationDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| MERSRegistrationDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MERSRegistrationDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MERSRegistrationDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MERSRegistrationDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MERSRegistrationStatusType |
| Base Entity | MERS_REGISTRATION |
| Attribute Name | MERSRegistrationStatusType |
| Logical Rolename | |
| ColumnName | MERSRegistrationStatusType |
| RoleName | |
| Domain | MERSRegistrationStatusEnum |
| Definition | The status of the loans registration with MERS. A loan is registered one time with MERS with its Mortgage Identification Number (MIN). Various life of loan activities may alter the registration status such as a deactivation transaction. |
| Note |
| MERSRegistrationStatusType Logical Attribute Properties |
| Logical Attribute Name | MERSRegistrationStatusType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| MERSRegistrationStatusType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| MERSRegistrationStatusType Reference Value (Bound to Domain) |
| Name | ValidationRule278 |
| Description | |
| Type | By List |
| Value | Value Description |
| Active | Active |
| Inactive | Inactive |
| Other | Other |
| MERSRegistrationStatusType Bound Attachments |
| Name | Current Value |
| MERSRegistrationStatusType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| MERSRegistrationStatusType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MERSRegistrationStatusType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MERSRegistrationStatusType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MERSRegistrationStatusType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MERSRegistrationStatusTypeOtherDescription |
| Base Entity | MERS_REGISTRATION |
| Attribute Name | MERSRegistrationStatusTypeOtherDescription |
| Logical Rolename | |
| ColumnName | MERSRegistrationStatusTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free-form text field used to capture the MERS Registration Status Type name if Other is selected as the MERS Registration Status Type. |
| Note |
| MERSRegistrationStatusTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | MERSRegistrationStatusTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| MERSRegistrationStatusTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| MERSRegistrationStatusTypeOtherDescription Bound Attachments |
| Name | Current Value |
| MERSRegistrationStatusTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| MERSRegistrationStatusTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MERSRegistrationStatusTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MERSRegistrationStatusTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MERSRegistrationStatusTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MERSRegistrationType |
| Base Entity | MERS_REGISTRATION |
| Attribute Name | MERSRegistrationType |
| Logical Rolename | |
| ColumnName | MERSRegistrationType |
| RoleName | |
| Domain | MERSRegistrationEnum |
| Definition | The system at MERS that the loan is registered on. |
| Note |
| MERSRegistrationType Logical Attribute Properties |
| Logical Attribute Name | MERSRegistrationType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| MERSRegistrationType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| MERSRegistrationType Reference Value (Bound to Domain) |
| Name | ValidationRule277 |
| Description | |
| Type | By List |
| Value | Value Description |
| MERS_ERegistry | MERS_ERegistry |
| MERSSystem | MERSSystem |
| Other | Other |
| MERSRegistrationType Bound Attachments |
| Name | Current Value |
| MERSRegistrationType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| MERSRegistrationType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MERSRegistrationType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MERSRegistrationType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MERSRegistrationType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MERSRegistrationTypeOtherDescription |
| Base Entity | MERS_REGISTRATION |
| Attribute Name | MERSRegistrationTypeOtherDescription |
| Logical Rolename | |
| ColumnName | MERSRegistrationTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free form text field used to capture additional information if Other is selected as MERS Registration Type. |
| Note |
| MERSRegistrationTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | MERSRegistrationTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| MERSRegistrationTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| MERSRegistrationTypeOtherDescription Bound Attachments |
| Name | Current Value |
| MERSRegistrationTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| MERSRegistrationTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MERSRegistrationTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MERSRegistrationTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MERSRegistrationTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |