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