DELINQUENCY_NOTIFICATION_DETAIL Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
BankruptcySuspenseBalanceAmount	MISMOAmount	DECIMAL(0, 2)	NO	Unapplied funds related to a loan that is in bankruptcy
DelinquencyEffectiveDate	MISMODate	DATE	NO	The date that the delinquency of the loan started, could be at day 16 or day 30 depending on the Investor requirements.
DelinquencyReportingPropertyOverallConditionType	DelinquencyReportingPropertyOverallConditionEnum	VARCHAR(0)	YES	Used to report the overall condition of the property associated with this loan as identified through a property inspector or through direct contact with Borrower, Neighbors, Real Estate Agent, etc.
DelinquencyReportingPropertyOverallConditionTypeOtherDescription	MISMOString	VARCHAR(0)	NO	A free-form text field used to describe the data source type if Other is selected as the Delinquency Reporting Property Overall Condition Type.
LoanDelinquencyReasonType	LoanDelinquencyReasonEnum	VARCHAR(0)	YES	The reason why the Borrower has become delinquent on the loan.
LoanDelinquencyReasonTypeOtherDescription	MISMOString	VARCHAR(0)	NO	A free-form text field used to capture the Loan Delinquency Reason type if Other is selected.
PropertyCurrentOccupancyType	PropertyCurrentOccupancyEnum	VARCHAR(0)	YES	Specifies the property occupancy status of a subject property.
RepaymentPlanDownPaymentAmount	MISMOAmount	DECIMAL(0, 2)	NO	The initial lump sum amount paid prior to the first monthly payment for the Repayment Plan.
RepaymentPlanMonthlyDueAmount	MISMOAmount	DECIMAL(0, 2)	NO	The Repayment Plan monthly payment amount. The amount of repayment scheduled to be paid each month under the Repayment Plan.
RepaymentPlanTermMonthsCount	MISMOCount	INTEGER	NO	The duration in months of a repayment plan agreement established with the borrower
TaxAdvancesOnAccountsNotEscrowedIndicator	MISMOIndicator	BIT	NO	Indicates that the Servicer has incurred advances to pay delinquent taxes on a non-escrowed account.

DELINQUENCY_NOTIFICATION_DETAIL Keys

Key Name

Key Type

Keys

DELINQUENCY_NOTIFICATION_DETAIL Relationships

Parent Relationships:

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

Child Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

DELINQUENCY_NOTIFICATION_DETAIL Check Constraints

Check Constraint Name

CheckConstraint

DELINQUENCY_NOTIFICATION_DETAIL Bound Attachments

Name	Current Value

DELINQUENCY_NOTIFICATION_DETAIL User-Defined Mappings

Model

Name

Description

DELINQUENCY_NOTIFICATION_DETAIL Data Movement Rules

Name

Type

Rule Text/Value