| AppraiserFileIdentifier |
| Base Entity | VALUATION_REQUEST_DETAIL |
| Attribute Name | AppraiserFileIdentifier |
| Logical Rolename | |
| ColumnName | AppraiserFileIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | This is an identifier or number used by the appraiser to identify their reports. It is generally specific to the appraiser. |
| Note |
| AppraiserFileIdentifier Logical Attribute Properties |
| Logical Attribute Name | AppraiserFileIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| AppraiserFileIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AppraiserFileIdentifier Bound Attachments |
| Name | Current Value |
| AppraiserFileIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AppraiserFileIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraiserFileIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraiserFileIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraiserFileIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OrderingSystemName |
| Base Entity | VALUATION_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 |
| PropertyValuationFormIdentifier |
| Base Entity | VALUATION_REQUEST_DETAIL |
| Attribute Name | PropertyValuationFormIdentifier |
| Logical Rolename | |
| ColumnName | PropertyValuationFormIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | The name or number assigned to a form by the form author. |
| Note |
| PropertyValuationFormIdentifier Logical Attribute Properties |
| Logical Attribute Name | PropertyValuationFormIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| PropertyValuationFormIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PropertyValuationFormIdentifier Bound Attachments |
| Name | Current Value |
| PropertyValuationFormIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PropertyValuationFormIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertyValuationFormIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertyValuationFormIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertyValuationFormIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertyValuationFormType |
| Base Entity | VALUATION_REQUEST_DETAIL |
| Attribute Name | PropertyValuationFormType |
| Logical Rolename | |
| ColumnName | PropertyValuationFormType |
| RoleName | |
| Domain | PropertyValuationFormEnum |
| Definition | Specifies the form used to provide the property valuation. |
| Note |
| PropertyValuationFormType Logical Attribute Properties |
| Logical Attribute Name | PropertyValuationFormType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| PropertyValuationFormType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PropertyValuationFormType Reference Value (Bound to Domain) |
| Name | ValidationRule401 |
| Description | |
| Type | By List |
| Value | Value Description |
| AppraisalUpdateAndOrCompletionReport | FNM 1004D FRE 442 |
| DefinitionsStatementOfLimitingConditionsAndAppraisersCertification | FNM 1004B |
| DesktopUnderwriterPropertyInspectionReport | FNM 2075 |
| EmployeeRelocationCouncil2001 | ERC2001 |
| ExteriorOnlyInspectionIndividualCondominiumUnitAppraisalReport | FNM 1075 FRE 466 |
| ExteriorOnlyInspectionIndividualCooperativeInterestAppraisalReport | FNM 2095 |
| ExteriorOnlyInspectionResidentialAppraisalReport | FNM 2055 FRE2055 |
| IndividualCondominiumUnitAppraisalReport | FNM 1073, FRE 465 |
| IndividualCooperativeInterestAppraisalReport | FNM 2090 |
| LoanProspectorConditionAndMarketability | FRE 2070 |
| ManufacturedHomeAppraisalReport | FNM 1004C FRE 70B |
| ManufacturedHomeAppraisalReportVA | VA Form 26-8712 |
| MarketConditionsAddendumToTheAppraisalReport | FNM 1004MC |
| OneUnitResidentialAppraisalFieldReviewReport | FNM 2000 FRE1032 |
| Other | Other |
| RequestForDeterminationOfReasonableValue | VA Form 26-1805 |
| SmallResidentialIncomePropertyAppraisalReport | FNM 1025, FRE 72 |
| TwoToFourUnitResidentialAppraisal | FNM 2000A, FRE 1072 |
| UniformResidentialAppraisalReport | FNM 1004, FRE 70 |
| PropertyValuationFormType Bound Attachments |
| Name | Current Value |
| PropertyValuationFormType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PropertyValuationFormType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertyValuationFormType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertyValuationFormType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertyValuationFormType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertyValuationFormTypeOtherDescription |
| Base Entity | VALUATION_REQUEST_DETAIL |
| Attribute Name | PropertyValuationFormTypeOtherDescription |
| Logical Rolename | |
| ColumnName | PropertyValuationFormTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free form text field used to collect additional information when Other is selected for Property Valuation Form Type. |
| Note |
| PropertyValuationFormTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | PropertyValuationFormTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| PropertyValuationFormTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PropertyValuationFormTypeOtherDescription Bound Attachments |
| Name | Current Value |
| PropertyValuationFormTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PropertyValuationFormTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertyValuationFormTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertyValuationFormTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertyValuationFormTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ValuationRequestActionType |
| Base Entity | VALUATION_REQUEST_DETAIL |
| Attribute Name | ValuationRequestActionType |
| Logical Rolename | |
| ColumnName | ValuationRequestActionType |
| RoleName | |
| Domain | ValuationRequestActionEnum |
| Definition | Defines the valuation service requested. |
| Note |
| ValuationRequestActionType Logical Attribute Properties |
| Logical Attribute Name | ValuationRequestActionType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| ValuationRequestActionType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ValuationRequestActionType Reference Value (Bound to Domain) |
| Name | ValidationRule492 |
| Description | |
| Type | By List |
| Value | Value Description |
| Cancellation | Request to permenantly cease work of an order in process. |
| Change | Modification of the original data that was submitted in the original service request. |
| Hold | Request to temporarilty cease work of an order in process. |
| Original | Initial service request. |
| Other | Other |
| PriceQuote | Request for cost estimate. |
| Reissue | Additional report copy. |
| Resume | Request to complete order on hold. |
| StatusQuery | Request for status of an order in process. |
| Update | An update to the original order with additional data that was not sent in the original service request. (i.e. If Legal Description was not sent previously, but is needed, then an Update would be used and that data would be passed). |
| Upgrade | Modification request to the original order with a higher and/or more expensive level of product or service. |
| ValuationRequestActionType Bound Attachments |
| Name | Current Value |
| ValuationRequestActionType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ValuationRequestActionType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ValuationRequestActionType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ValuationRequestActionType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ValuationRequestActionType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ValuationRequestActionTypeOtherDescription |
| Base Entity | VALUATION_REQUEST_DETAIL |
| Attribute Name | ValuationRequestActionTypeOtherDescription |
| Logical Rolename | |
| ColumnName | ValuationRequestActionTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free-form text field used to describe the Valuation Request Action Type if Other is selected. |
| Note |
| ValuationRequestActionTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | ValuationRequestActionTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| ValuationRequestActionTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ValuationRequestActionTypeOtherDescription Bound Attachments |
| Name | Current Value |
| ValuationRequestActionTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ValuationRequestActionTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ValuationRequestActionTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ValuationRequestActionTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ValuationRequestActionTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ValuationRequestCommentText |
| Base Entity | VALUATION_REQUEST_DETAIL |
| Attribute Name | ValuationRequestCommentText |
| Logical Rolename | |
| ColumnName | ValuationRequestCommentText |
| RoleName | |
| Domain | MISMOString |
| Definition | A free-form text field used for comments for the valuation request in question. |
| Note |
| ValuationRequestCommentText Logical Attribute Properties |
| Logical Attribute Name | ValuationRequestCommentText |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| ValuationRequestCommentText Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ValuationRequestCommentText Bound Attachments |
| Name | Current Value |
| ValuationRequestCommentText User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ValuationRequestCommentText Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ValuationRequestCommentText Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ValuationRequestCommentText Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ValuationRequestCommentText Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ValuationRequestRushIndicator |
| Base Entity | VALUATION_REQUEST_DETAIL |
| Attribute Name | ValuationRequestRushIndicator |
| Logical Rolename | |
| ColumnName | ValuationRequestRushIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates Valuation Request services be expedited. |
| Note |
| ValuationRequestRushIndicator Logical Attribute Properties |
| Logical Attribute Name | ValuationRequestRushIndicator |
| Datatype | BIT |
| Nullable | NO |
| ValuationRequestRushIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ValuationRequestRushIndicator Bound Attachments |
| Name | Current Value |
| ValuationRequestRushIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ValuationRequestRushIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ValuationRequestRushIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ValuationRequestRushIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ValuationRequestRushIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| VendorOrderIdentifier |
| Base Entity | VALUATION_REQUEST_DETAIL |
| Attribute Name | VendorOrderIdentifier |
| Logical Rolename | |
| ColumnName | VendorOrderIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | A string that uniquely identifies a specific order for a vendor set by the vendor. |
| Note |
| VendorOrderIdentifier Logical Attribute Properties |
| Logical Attribute Name | VendorOrderIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| VendorOrderIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| VendorOrderIdentifier Bound Attachments |
| Name | Current Value |
| VendorOrderIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| VendorOrderIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VendorOrderIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VendorOrderIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| VendorOrderIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |