COUNSELING_CONFIRMATION Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
CounselingConfirmationIndicator	MISMOIndicator	BIT	NO	Indicates whether or not the applicant has completed the Homebuyer Education program.
CounselingConfirmationType	CounselingConfirmationEnum	VARCHAR(0)	YES	Specifies the type of mortgage counseling or education program attended by one or more of the borrowers.
CounselingConfirmationTypeOtherDescription	MISMOString	VARCHAR(0)	NO	A free form text field used to collect additional information when Other is selected for Counseling Confirmation Type.
CounselingFormatType	CounselingFormatEnum	VARCHAR(0)	YES	Identifies the educational setting of the formal borrower homeownership program in which the borrower participated as a requirement of a special mortgage program.
CounselingFormatTypeOtherDescription	MISMOString	VARCHAR(0)	NO	A free form text field used to collect additional information when Other is selected for Counseling Format Type.

COUNSELING_CONFIRMATION Keys

Key Name

Key Type

Keys

COUNSELING_CONFIRMATION Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
BORROWER	Identifying	One to Zero or One					NO

Child Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

COUNSELING_CONFIRMATION Check Constraints

Check Constraint Name

CheckConstraint

COUNSELING_CONFIRMATION Bound Attachments

Name	Current Value

COUNSELING_CONFIRMATION User-Defined Mappings

Model

Name

Description

COUNSELING_CONFIRMATION Data Movement Rules

Name

Type

Rule Text/Value