CounselingConfirmationIndicator 
Base Entity  COUNSELING_CONFIRMATION 
Attribute Name  CounselingConfirmationIndicator 
Logical Rolename   
ColumnName  CounselingConfirmationIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates whether or not the applicant has completed the Homebuyer Education program. 
Note 
 

CounselingConfirmationIndicator Logical Attribute Properties 
Logical Attribute Name  CounselingConfirmationIndicator 
Datatype  BIT 
Nullable  NO 

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

CounselingConfirmationIndicator Bound Attachments 
Name  Current Value 

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

CounselingConfirmationIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

CounselingConfirmationIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

CounselingConfirmationIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

CounselingConfirmationIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


CounselingConfirmationType 
Base Entity  COUNSELING_CONFIRMATION 
Attribute Name  CounselingConfirmationType 
Logical Rolename   
ColumnName  CounselingConfirmationType 
RoleName   
Domain  CounselingConfirmationEnum 
Definition  Specifies the type of mortgage counseling or education program attended by one or more of the borrowers.  
Note 
 

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

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

CounselingConfirmationType Reference Value (Bound to Domain) 
Name  ValidationRule84 
Description   
Type  By List 
Value  Value Description 
AmericanHomeownerEducationInstituteApprovedCounseling  AmericanHomeownerEducationInstituteApprovedCounseling 
GovernmentAgency  GovernmentAgency 
HUDApprovedCounselingAgency  HUDApprovedCounselingAgency 
LenderTrainedCounseling  LenderTrainedCounseling 
NoBorrowerCounseling  NoBorrowerCounseling 
Other  Other 
ThirdPartyCounseling  ThirdPartyCounseling 
Unknown  Unknown 

CounselingConfirmationType Bound Attachments 
Name  Current Value 

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

CounselingConfirmationType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

CounselingConfirmationType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

CounselingConfirmationType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

CounselingConfirmationType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


CounselingConfirmationTypeOtherDescription 
Base Entity  COUNSELING_CONFIRMATION 
Attribute Name  CounselingConfirmationTypeOtherDescription 
Logical Rolename   
ColumnName  CounselingConfirmationTypeOtherDescription 
RoleName   
Domain  MISMOString 
Definition  A free form text field used to collect additional information when Other is selected for Counseling Confirmation Type. 
Note 
 

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

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

CounselingConfirmationTypeOtherDescription Bound Attachments 
Name  Current Value 

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

CounselingConfirmationTypeOtherDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

CounselingConfirmationTypeOtherDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

CounselingConfirmationTypeOtherDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

CounselingConfirmationTypeOtherDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


CounselingFormatType 
Base Entity  COUNSELING_CONFIRMATION 
Attribute Name  CounselingFormatType 
Logical Rolename   
ColumnName  CounselingFormatType 
RoleName   
Domain  CounselingFormatEnum 
Definition  Identifies the educational setting of the formal borrower homeownership program in which the borrower participated as a requirement of a special mortgage program.  
Note 
 

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

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

CounselingFormatType Reference Value (Bound to Domain) 
Name  ValidationRule85 
Description   
Type  By List 
Value  Value Description 
BorrowerEducationNotRequired  BorrowerEducationNotRequired 
Classroom  Classroom 
HomeStudy  HomeStudy 
Individual  Individual 
Other  Other 

CounselingFormatType Bound Attachments 
Name  Current Value 

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

CounselingFormatType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

CounselingFormatType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

CounselingFormatType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

CounselingFormatType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


CounselingFormatTypeOtherDescription 
Base Entity  COUNSELING_CONFIRMATION 
Attribute Name  CounselingFormatTypeOtherDescription 
Logical Rolename   
ColumnName  CounselingFormatTypeOtherDescription 
RoleName   
Domain  MISMOString 
Definition  A free form text field used to collect additional information when Other is selected for Counseling Format Type. 
Note 
 

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

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

CounselingFormatTypeOtherDescription Bound Attachments 
Name  Current Value 

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

CounselingFormatTypeOtherDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

CounselingFormatTypeOtherDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

CounselingFormatTypeOtherDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

CounselingFormatTypeOtherDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description