| BorrowerFloodAcknowledgementLetterIndicator |
| Base Entity | FLOOD_REQUEST_DETAIL |
| Attribute Name | BorrowerFloodAcknowledgementLetterIndicator |
| Logical Rolename | |
| ColumnName | BorrowerFloodAcknowledgementLetterIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates if a Borrower Acknowledgement Letter needs to be processed with the order. |
| Note |
| BorrowerFloodAcknowledgementLetterIndicator Logical Attribute Properties |
| Logical Attribute Name | BorrowerFloodAcknowledgementLetterIndicator |
| Datatype | BIT |
| Nullable | NO |
| BorrowerFloodAcknowledgementLetterIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BorrowerFloodAcknowledgementLetterIndicator Bound Attachments |
| Name | Current Value |
| BorrowerFloodAcknowledgementLetterIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| BorrowerFloodAcknowledgementLetterIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BorrowerFloodAcknowledgementLetterIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BorrowerFloodAcknowledgementLetterIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BorrowerFloodAcknowledgementLetterIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FEMAAdditionalLenderDescription |
| Base Entity | FLOOD_REQUEST_DETAIL |
| Attribute Name | FEMAAdditionalLenderDescription |
| Logical Rolename | |
| ColumnName | FEMAAdditionalLenderDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | Additional information for the lender in Box 1 of the FEMA form. FORM SPECIFIC FIELD |
| Note |
| FEMAAdditionalLenderDescription Logical Attribute Properties |
| Logical Attribute Name | FEMAAdditionalLenderDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| FEMAAdditionalLenderDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FEMAAdditionalLenderDescription Bound Attachments |
| Name | Current Value |
| FEMAAdditionalLenderDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FEMAAdditionalLenderDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FEMAAdditionalLenderDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FEMAAdditionalLenderDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FEMAAdditionalLenderDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodCertificationIdentifier |
| Base Entity | FLOOD_REQUEST_DETAIL |
| Attribute Name | FloodCertificationIdentifier |
| Logical Rolename | |
| ColumnName | FloodCertificationIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | The certification number assigned by the compliance company when an order is received from the submitting / requesting party. |
| Note |
| FloodCertificationIdentifier Logical Attribute Properties |
| Logical Attribute Name | FloodCertificationIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| FloodCertificationIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FloodCertificationIdentifier Bound Attachments |
| Name | Current Value |
| FloodCertificationIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FloodCertificationIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodCertificationIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodCertificationIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodCertificationIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodInsuranceAmount |
| Base Entity | FLOOD_REQUEST_DETAIL |
| Attribute Name | FloodInsuranceAmount |
| Logical Rolename | |
| ColumnName | FloodInsuranceAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The minimal Federal requirement for flood insurance coverage, the lesser of: the outstanding principal loan balance; the value of the improved property, mobile home and/or personal property used to secure the loan; or the maximum statutory limit of flood |
| Note |
| FloodInsuranceAmount Logical Attribute Properties |
| Logical Attribute Name | FloodInsuranceAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| FloodInsuranceAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FloodInsuranceAmount Bound Attachments |
| Name | Current Value |
| FloodInsuranceAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FloodInsuranceAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodInsuranceAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodInsuranceAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodInsuranceAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodRequestActionType |
| Base Entity | FLOOD_REQUEST_DETAIL |
| Attribute Name | FloodRequestActionType |
| Logical Rolename | |
| ColumnName | FloodRequestActionType |
| RoleName | |
| Domain | FloodRequestActionEnum |
| Definition | Describes the type of action to be performed for the request in question. |
| Note |
| FloodRequestActionType Logical Attribute Properties |
| Logical Attribute Name | FloodRequestActionType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| FloodRequestActionType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FloodRequestActionType Reference Value (Bound to Domain) |
| Name | ValidationRule175 |
| Description | |
| Type | By List |
| Value | Value Description |
| Cancellation | Cancellation |
| Change | Change |
| Dispute | Dispute |
| Original | Original |
| Reissue | Reissue |
| StatusQuery | StatusQuery |
| Transfer | Transfer |
| Upgrade | Upgrade |
| FloodRequestActionType Bound Attachments |
| Name | Current Value |
| FloodRequestActionType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FloodRequestActionType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodRequestActionType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodRequestActionType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodRequestActionType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodRequestCommentText |
| Base Entity | FLOOD_REQUEST_DETAIL |
| Attribute Name | FloodRequestCommentText |
| Logical Rolename | |
| ColumnName | FloodRequestCommentText |
| RoleName | |
| Domain | MISMOString |
| Definition | Comments for the flood request in question. |
| Note |
| FloodRequestCommentText Logical Attribute Properties |
| Logical Attribute Name | FloodRequestCommentText |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| FloodRequestCommentText Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FloodRequestCommentText Bound Attachments |
| Name | Current Value |
| FloodRequestCommentText User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FloodRequestCommentText Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodRequestCommentText Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodRequestCommentText Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodRequestCommentText Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodRequestRushIndicator |
| Base Entity | FLOOD_REQUEST_DETAIL |
| Attribute Name | FloodRequestRushIndicator |
| Logical Rolename | |
| ColumnName | FloodRequestRushIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates that this order has a high priority in need for completion. |
| Note |
| FloodRequestRushIndicator Logical Attribute Properties |
| Logical Attribute Name | FloodRequestRushIndicator |
| Datatype | BIT |
| Nullable | NO |
| FloodRequestRushIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FloodRequestRushIndicator Bound Attachments |
| Name | Current Value |
| FloodRequestRushIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FloodRequestRushIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodRequestRushIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodRequestRushIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodRequestRushIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodTransactionIdentifier |
| Base Entity | FLOOD_REQUEST_DETAIL |
| Attribute Name | FloodTransactionIdentifier |
| Logical Rolename | |
| ColumnName | FloodTransactionIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | A unique tracking identifier assigned by the sender which is typically returned to the sender in the resulting response. |
| Note |
| FloodTransactionIdentifier Logical Attribute Properties |
| Logical Attribute Name | FloodTransactionIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| FloodTransactionIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FloodTransactionIdentifier Bound Attachments |
| Name | Current Value |
| FloodTransactionIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FloodTransactionIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodTransactionIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodTransactionIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodTransactionIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NewServicerAccountIdentifier |
| Base Entity | FLOOD_REQUEST_DETAIL |
| Attribute Name | NewServicerAccountIdentifier |
| Logical Rolename | |
| ColumnName | NewServicerAccountIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | The vendor account code assigned to the Lender who receives the transfer. |
| Note |
| NewServicerAccountIdentifier Logical Attribute Properties |
| Logical Attribute Name | NewServicerAccountIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| NewServicerAccountIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| NewServicerAccountIdentifier Bound Attachments |
| Name | Current Value |
| NewServicerAccountIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| NewServicerAccountIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NewServicerAccountIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NewServicerAccountIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NewServicerAccountIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OrderingSystemName |
| Base Entity | FLOOD_REQUEST_DETAIL |
| Attribute Name | OrderingSystemName |
| Logical Rolename | |
| ColumnName | OrderingSystemName |
| RoleName | |
| Domain | MISMOString |
| Definition | The name of the system that originated the order. |
| Note |
| OrderingSystemName Logical Attribute Properties |
| Logical Attribute Name | OrderingSystemName |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| OrderingSystemName Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| OrderingSystemName Bound Attachments |
| Name | Current Value |
| OrderingSystemName User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| OrderingSystemName Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OrderingSystemName Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OrderingSystemName Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OrderingSystemName Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OrderingSystemVersionIdentifier |
| Base Entity | FLOOD_REQUEST_DETAIL |
| Attribute Name | OrderingSystemVersionIdentifier |
| Logical Rolename | |
| ColumnName | OrderingSystemVersionIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | The version of the system that originated the order. |
| Note |
| OrderingSystemVersionIdentifier Logical Attribute Properties |
| Logical Attribute Name | OrderingSystemVersionIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| OrderingSystemVersionIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| OrderingSystemVersionIdentifier Bound Attachments |
| Name | Current Value |
| OrderingSystemVersionIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| OrderingSystemVersionIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OrderingSystemVersionIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OrderingSystemVersionIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OrderingSystemVersionIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OriginalFloodDeterminationLoanIdentifier |
| Base Entity | FLOOD_REQUEST_DETAIL |
| Attribute Name | OriginalFloodDeterminationLoanIdentifier |
| Logical Rolename | |
| ColumnName | OriginalFloodDeterminationLoanIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | The loan number assigned to the original flood determination order. Used for identifying a loan that has been previously certified (e.g., refi, second, servicing transfer, etc.) |
| Note |
| OriginalFloodDeterminationLoanIdentifier Logical Attribute Properties |
| Logical Attribute Name | OriginalFloodDeterminationLoanIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| OriginalFloodDeterminationLoanIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| OriginalFloodDeterminationLoanIdentifier Bound Attachments |
| Name | Current Value |
| OriginalFloodDeterminationLoanIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| OriginalFloodDeterminationLoanIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OriginalFloodDeterminationLoanIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OriginalFloodDeterminationLoanIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OriginalFloodDeterminationLoanIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |