SCOPE_OF_WORK_DETAIL |
EntityType | Independent |
Logical Entity Name | SCOPE_OF_WORK_DETAIL |
Default Table Name | DEAL/SERVICES/SERVICE/VALUATION/VALUATION_REQUEST/SCOPE_OF_WORK/SCOPE_OF_WORK_DETAIL |
Definition | |
Note |
SCOPE_OF_WORK_DETAIL Attributes |
Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
PropertyValuationInspectionType | PropertyValuationInspectionEnum | VARCHAR(0) | YES | Specifies the extent of the property inspection. |
PropertyValuationInspectionTypeOtherDescription | MISMOString | VARCHAR(0) | NO | A free form text field used to capture additional information when Other is selected for Property Valuation Inspection Type. |
PropertyValuationServiceType | PropertyValuationServiceEnum | VARCHAR(0) | YES | Provides a categorization for valuation products in terms of USPAP compliance and level of professional services required. |
PropertyValuationServiceTypeOtherDescription | MISMOString | VARCHAR(0) | NO | A free-form text field which contains the description of the categorization for valuation products when Other is selected as the Property Valuation Service Type. |
USPAPReportDescription | MISMOString | VARCHAR(0) | NO | A free-form text field used to describe the type of the appraisal report according to the Uniform Standard of Professional Appraisal Practice for appraisal report categories. |
ValuationAddendumText | MISMOString | VARCHAR(0) | NO | Used to hold the additional comments found on a Comment Addendum form within the valuation. |
ValuationAssignmentType | ValuationAssignmentEnum | VARCHAR(0) | YES | Specifies the business reason that motivated the order for a valuation. |
ValuationAssignmentTypeOtherDescription | MISMOString | VARCHAR(0) | NO | A free form text field used to collect additional information when other is selected for Valuation Assignment Type. |
ValuationIntendedUseDescription | MISMOString | VARCHAR(0) | NO | Describes the intended use of the valuation report. |
ValuationIntendedUserDescription | MISMOString | VARCHAR(0) | NO | Describes the intended user of the valuation report. |
ValuationScopeOfWorkDescription | MISMOString | VARCHAR(0) | NO | Describes the scope of work identified as necessary by the appraiser to determine a valuation with respect to its intended use and users. |
SCOPE_OF_WORK_DETAIL Keys |
Key Name | Key Type | Keys |
SCOPE_OF_WORK_DETAIL Relationships |
Parent Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
SCOPE_OF_WORK | Non-Identifying | Zero or One to Zero or One | NO |
Child Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
SCOPE_OF_WORK_DETAIL Check Constraints |
Check Constraint Name | CheckConstraint |
SCOPE_OF_WORK_DETAIL Bound Attachments |
Name | Current Value |
SCOPE_OF_WORK_DETAIL User-Defined Mappings |
Model | Name | Description |
SCOPE_OF_WORK_DETAIL Data Movement Rules |
Name | Type | Rule Text/Value |