AppraiserLicenseType 
Base Entity  APPRAISER_LICENSE 
Attribute Name  AppraiserLicenseType 
Logical Rolename   
ColumnName  AppraiserLicenseType 
RoleName   
Domain  AppraiserLicenseEnum 
Definition  Used to specify the different types of appraisal licenses that can be held by an appraiser.  
Note 
 

AppraiserLicenseType Logical Attribute Properties 
Logical Attribute Name  AppraiserLicenseType 
Datatype  VARCHAR(0) 
Nullable  YES 

AppraiserLicenseType Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

AppraiserLicenseType Reference Value (Bound to Domain) 
Name  ValidationRule25 
Description   
Type  By List 
Value  Value Description 
CertifiedGeneral  May appraise all types of real property (subject to to the COMPETENCY RULE) in USPAP. 
CertifiedResidential  May appraise 1-4 family residential properties without regard to value or complexity, and all other properties with transaction values up to $250,000 (subject to the COMPETENCY RULE in USPAP and applicable state laws). 
LicensedResidentialAppraiser  May appraise non-complex 1-4 unit residential properties with transaction values up to $1million and all other properties with transaction values up to $250,000 (subject to the COMPETENCY RULE is USPAP and applicable state laws). 
Other  Other 
RegisteredTraineeApprentice  Aappraisal work completed by this level of license must be accompanied the signature of a valid licensed supervisory appraiser. 

AppraiserLicenseType Bound Attachments 
Name  Current Value 

AppraiserLicenseType User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

AppraiserLicenseType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

AppraiserLicenseType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

AppraiserLicenseType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

AppraiserLicenseType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


AppraiserLicenseTypeOtherDescription 
Base Entity  APPRAISER_LICENSE 
Attribute Name  AppraiserLicenseTypeOtherDescription 
Logical Rolename   
ColumnName  AppraiserLicenseTypeOtherDescription 
RoleName   
Domain  MISMOString 
Definition  A free form text field used to capture additional information when Other is selected for Appraisal License Type. 
Note 
 

AppraiserLicenseTypeOtherDescription Logical Attribute Properties 
Logical Attribute Name  AppraiserLicenseTypeOtherDescription 
Datatype  VARCHAR(0) 
Nullable  NO 

AppraiserLicenseTypeOtherDescription Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

AppraiserLicenseTypeOtherDescription Bound Attachments 
Name  Current Value 

AppraiserLicenseTypeOtherDescription User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

AppraiserLicenseTypeOtherDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

AppraiserLicenseTypeOtherDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

AppraiserLicenseTypeOtherDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

AppraiserLicenseTypeOtherDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description