Explanation of the Servicing Director Delinquencies Field
This is an explanation of the Servicing Director Delinquencies field, found in the Collections application, Contact screen, Statistics tab.
The Delinquencies field displays the number of delinquent payments made each month, January through December of the current year.
A value of 1 through 4 , or B or F is calculated and is stored in the LoanStatistics table (LoanStatistics.DelinquencyCounter(Month))
Each night, when the Daily Delinquency Counters Update event is ran the system calculates the value for the month of the TransPostDate (and only that month). For instance, if TransPostDate is May 10, 2016, only DelinquencyCounterMay is calculated that night.
The calculation is:
When DATEADD(DD,-30, + TransPostDate ) > Loan.DueDate a 1 is placed in the DelinquencyCounter(Month) field where field = the month of the Transpostdate.
When DATEADD(DD,-60, + TransPostDate ) > Loan.DueDate a 2 is placed in the DelinquencyCounter(Month) field where field = the month of the Transpostdate.
When DATEADD(DD,-90, + TransPostDate ) > Loan.DueDate a 3 is placed in the DelinquencyCounter(Month) field where field = the month of the Transpostdate.
When DATEADD(DD,-120, + TransPostDate ) > Loan.DueDate a 4 is placed in the DelinquencyCounter(Month) field where field = the month of the Transpostdate.
When there is a ForeclosureTracking record where the ForeclosureType is not NONE and the ForeclosureStatus is None or Active, an F is placed in the DelinquencyCounter(Month) field where field = the month of the Transpostdate.
When there is an active Bankruptcy record, a B is placed in the DelinquencyCounter(Month) field where field = the month of the Transpostdate.
Environment:
Delinquencies Field
ArticleNumber:
000054973
Related Articles
Explanation of Servicing Director Permanent Comments Feature
This is an explanation of the Permanent Comments feature: The data for Permanent Comments (either in Collections or Customer Service modules) is stored in the Contact table, Comment field (Contact.Comment) There is one to one record here, so ...
Explanation Of Monthly Delinquent Indicator And How It Is Used In Servicing Director Credit Bureau Reporting
This serves as an explanation of the Monthly Delinquent Indicator field, and about how it is used in the Servicing Director credit bureau reporting process. The Monthly Delinquent Indicator field is found in the Customer Service application, Payment, ...
Explanation of the Date Of 1st Delinquency (DOFD) in Servicing Director Credit Bureau Reporting
The Date of 1st Delinquency, often abbreviated to DOFD, is found in the Customer Service application > Payment > Credit screen, and is used for Credit Bureau Reporting. In the Servicing Director Credit Bureau Export file, the DOFD value can be ...
Servicing Director Field Maintenance Logging Reports
Servicing Director delivers two different field logging reports. The Field Logging Rpt Found in the Event Manager Available Events > System Administration > Reports category. This report is delivered with two predefined types of criteria; however, ...
Servicing Director Last File Maintenance Date
This is an explanation of the Servicing Director Last File Maintenance Date. This field is seen in the Customer Service application, in the Dates screen, displayed as Last Maintenance. It is stored in the Loan table (Loan.LastFileMainDate). The Loan ...