BORROWER_DETAIL Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
BorrowerAgeAtApplicationYearsCount	MISMOCount	INTEGER	NO	The age of the borrower at the time of application in years.
BorrowerApplicationSignedDate	MISMODate	DATE	NO	The date that the borrower signed the loan application. Collected on the URLA in Section IX (Borrowers Signature Date).
BorrowerBirthDate	MISMODate	DATE	NO	Borrowers date of birth.
BorrowerCanadianSocialInsuranceNumberIdentifier	MISMOIdentifier	VARCHAR(0)	NO	The Canadian Social Insurance Number associated with the borrower.
BorrowerCharacteristicType	BorrowerCharacteristicEnum	VARCHAR(0)	YES	Specifies the classification applied to a borrower for the purposes of processing or reporting.
BorrowerCharacteristicTypeOtherDescription	MISMOString	VARCHAR(0)	NO	The description of the Borrower Characteristic Type when Other is selected as the option from the enumerated list.
BorrowerClassificationType	BorrowerClassificationEnum	VARCHAR(0)	YES	Indicates whether the borrower is the primary or a secondary borrower.
BorrowerMailToAddressSameAsPropertyIndicator	MISMOIndicator	BIT	NO	When true, indicates that the mailing address for the borrower is the same as the property address.
BorrowerQualifyingIncomeAmount	MISMOAmount	DECIMAL(0, 2)	NO	The total monthly borrower income per lender or investor guidelines.
BorrowerRelationshipTitleType	BorrowerRelationshipTitleEnum	VARCHAR(0)	YES	The description of the relationship of a borrower to (an) other borrower(s), if any, for Title purposes.
BorrowerRelationshipTitleTypeOtherDescription	MISMOString	VARCHAR(0)	NO	When Other is specified in Borrower Relationship Title Type, this element contains the description.
BorrowerSameAsBuilderIndicator	MISMOIndicator	BIT	NO	When true, indicates that the Borrower is also the Builder on the loan transaction.
BorrowerTotalMortgagedPropertiesCount	MISMOCount	INTEGER	NO	The number of 1-4 unit properties that are financed and owned and/or obligated on by an individual borrower.
CreditFileBorrowerAgeYearsCount	MISMOCount	INTEGER	NO	The age of the borrower reported in the credit file returned from the repository bureau. The age is sometimes reported in lieu of the date of birth.
CreditReportAuthorizationIndicator	MISMOIndicator	BIT	NO	Indicates that the borrower gave the lender consent to pull credit report.
CreditReportIdentifier	MISMOIdentifier	VARCHAR(0)	NO	A reference number assigned by the credit bureau to a specific credit report. This report number is also referenced when a Reissue, Upgrade, or Status Query of an existing report is requested.
DependentCount	MISMOCount	INTEGER	NO	The number of dependents disclosed by the borrower. Collected on the URLA in Section III (Dependents No.).
JointAssetLiabilityReportingType	JointAssetLiabilityReportingEnum	VARCHAR(0)	YES	A statement made by two borrowers on a single loan application indicating whether their reporting of assets and liabilities is being completed jointly or not jointly. Collected on the URLA in Section VI (Completed Jointly / Not Jointly - Check Box).
MaritalStatusType	MaritalStatusEnum	VARCHAR(0)	YES	The marital status of the party as disclosed by the party.
SchoolingYearsCount	MISMOCount	INTEGER	NO	The number of years the borrower has attended school. Collected on the URLA in Section III (Yrs. School).
SignedAuthorizationToRequestTaxRecordsIndicator	MISMOIndicator	BIT	NO	Indicates that the IRS form (4506 or 4506T) that gives the lender the authority to request copies of tax records is present.
SSNCertificationIndicator	MISMOIndicator	BIT	NO	Indicates whether the Social Security # has been certified.
TaxRecordsObtainedIndicator	MISMOIndicator	BIT	NO	Indicates that the IRS form (4506 or 4506T) that gives the lender the authority to request copies of tax records has been executed by the lender.

BORROWER_DETAIL Keys

Key Name

Key Type

Keys

BORROWER_DETAIL 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

BORROWER_DETAIL Check Constraints

Check Constraint Name

CheckConstraint

BORROWER_DETAIL Bound Attachments

Name	Current Value

BORROWER_DETAIL User-Defined Mappings

Model

Name

Description

BORROWER_DETAIL Data Movement Rules

Name

Type

Rule Text/Value