Contents

Rehabilitation

Rehabilitation conditions allow you to query accounts based on loan rehabilitation criteria.

Condition	Table	Column	Description
Setup Date	Rehab	SetupDate	Date the user set up the loan rehabilitation.
Account Owned by Desk Code	Rehab	AccountOwner	Code that identifies the desk assigned to the primary account when the first qualifying rehabilitation payment posts.
Account Owner	Rehab	AccountOwner	Desk assigned to the primary account when the first qualifying rehabilitation payment posts.
Account Rehab Add In?	Rehab	RehabAddIn	Account is or isn't an add-in rehabilitation account.
Account Rehab Driver?	Rehab	RehabDriver	Account is or isn't the rehabilitation driver account.
Account Rehab Program	RehabProgramType	RehabProgramTypeID	Type of rehabilitation program.
Account Setup Balance	Rehab	SetupBalance	Combined total of the affected money buckets of all the associated eligible accounts on the rehabilitation setup date.
Active Accounts	Rehab	Active	Account is or isn't active.
Active Rehab Accounts	Rehab	Active	Account is or isn't in rehabilitation.
Days Late	Rehab	DaysLate	Number of days after the due date that you received the last scheduled qualifying rehabilitation payment.
DaysEarly	Rehab	DaysEarly	Number of days before the due date that you received the last scheduled qualifying rehabilitation payment.
DownPayment	Rehab	DownPayment	Loan rehabilitation down payment amount.
Eligible for Tax Offset	Rehab	TaxOffsetEligible	Account is or isn't eligible for a tax offset.
Funding Requirements Met	Rehab	FundingRequirementsMet	Rehabilitation did or didn't meet the requirements for funding.
Is Rehab Add In Account	Rehab	RehabAddIn	Account is or isn't an add-in rehabilitation account.
Is Rehab Driver Account	Rehab	RehabDriver	Account is or isn't the rehabilitation driver account.
Minimum Qualifying Amt	Rehab	MinQualifyingAmt	Minimum balanced required for rehabilitation eligibility.
Number Of Payments	Rehab	NumberOfPayments	Number of qualifying rehabilitation payments to date.
Payment Dollar Amount	Rehab	PaymentDollarAmount	Monthly rehabilitation payment amount.
Payment Effective Date	Rehab	PaymentEffectiveDate	Date the borrower paid on the account.
Projected Buyback Date	Rehab	ProjectedBuybackDate	Due date after the third consecutive qualifying rehabilitation payment.
Projected Funding Month	Rehab	ProjectedFundingMonth	Projected month and year (MM/YYYY) the account funds after the ninth qualifying rehabilitation payment.
Projected Funding Revenue Amount	Rehab	ProjectedFundingRevenueAmount	Projected funding amount after the ninth qualifying payment in the rehabilitation payment arrangement posts.
Rehab Fallout Balance	Rehab	RehabFalloutBalance	Current balance at the time of the fallout from loan rehabilitation.
Rehab ID	Rehab	RehabID	Code that identifies the loan rehabilitation.
Rehab Letter Received From Debtor Date	Rehab	RehabLetterReceivedFromDebtorDate	Date your organization received the loan rehabilitation letter from the borrower.
Rehab Letter Sent to Customer Date	Rehab	RehabLetterSentToCustomerDate	Date your organization sent the loan rehabilitation letter to the client.
Rehab Letter Sent to Debtor Date	Rehab	RehabLetterSentToDebtorDate	Date your organization sent the loan rehabilitation letter to the borrower.
Rehab Projected Funding Revenue Amount	Rehab	RehabProjectedFundingRevenueAmount	Projected funding amount after the ninth qualifying payment in the rehabilitation payment arrangement posts.
RehabDueDay	Rehab	RehabDueDay	Day of the month the payments are due (days 1-28 only).
Reinsurance Rate	Rehab	ReinsuranceRate	Percentage rate the customer provides for use as rehabilitation qualification point.
Reported Due Day	Rehab	ReportedDueDay	Rehabilitation due day reported to the client in the export.
Reported Payment Amount	Rehab	ReportedPaymentAmount	Rehabilitation payment amount reported to the client in the export.
ReportedDueDay	Rehab	ReportedDueDay	Rehabilitation due day reported to the client in the export.
Reporting Date	Rehab	ReportingDate	Date the client received notification of the rehabilitation start date.
Sale Funding Requirements Met	Rehab	FundingRequirementsMet	Rehabilitation met the requirements for funding.
Sale Submission Date	Rehab	SaleSubmissionDate	Date the customer submitted the loan rehabilitation for sale.
Setup Balance	Rehab	SetupBalance	Combined total of the affected money buckets of all the associated eligible accounts on the rehabilitation setup date.
Setup Collector	Rehab	SetupCollector	Desk assigned to the account when you created the rehabilitation payment arrangement.
SetupBalance	Rehab	SetupBalance	Combined total of the affected money buckets of all the associated eligible accounts on the rehabilitation setup date.
Skip Month Used	Rehab	SkipMonthUsed	Number of allowed months the borrower used to skip a rehabilitation payment.
Start Date	Rehab	StartDate	Effective date of the first eligible rehabilitation payment.
Stop Date	Rehab	StopDate	Date your organization stopped the loan rehabilitation process.
Title IV Eligible	Rehab	TitleIVEligible	Account is or isn't eligible for Title IV.
WDF App Signed Date	Rehab	WDFAppSignedDate	Date the borrower signed the William D. Ford application.
WDF Letter Received From Debtor Date	Rehab	WDFLetterReceivedFromDebtorDate	Date your organization received the William D. Ford letter from the borrower.
WDF Letter Sent to Customer Date	Rehab	WDFLetterSentToCustomerDate	Date your organization sent the William D. Ford letter to the customer.
WDF Letter Sent to Debtor Date	Rehab	WDFLetterSentToDebtorDate	Date your organization sent the William D. Ford letter to the borrower.