Each night, LoanPro performs tasks and automations through a process called Daily Maintenance. This process is done automatically while most people are asleep. Some of the tasks performed include calculating accrued interest, updating the automation engine, adding automatic late fees, generating scheduled reports, sending automatic emails, etc. Daily Maintenance is an essential step in keeping loans up-to-date and automating the loan servicing process. 
 

The process

Before maintenance is performed, a blank event is triggered that begins the process. Once triggered, the LMS sifts through all of the tenants that need to be maintained and begins to prepare the loans within these tenants that meet the requirements for maintenance. In order for the loans to be pushed to the queue, they must not be maintained, temporary, archived or deleted. A notification is then sent to show that daily maintenance has started and these loans are pushed to a queue along with their basic data.

Each night at midnight (based on the company time zone setting), LMS will run the following processes on all live accounts:

1. Run LoanPro Calculator (updates values for the day & if applicable charges Late Fees)
2. Automation Engine
   1. Recurring Charges
   2. Based on the evaluation order set by the company, run an automation engine for the tenant.  Note: rules are evaluated consecutively. If a rule application makes a change to an account, that change will be considered when the next rule application is evaluated.
3. Stoplights
4. Warning Flags
5. Notification Engine
   1. Emails
   2. SMS
   3. Mail house
   4. Webhooks

The following are affected by daily maintenance:

• Loan Setup
• Fees (Late Fees)
• Flags
• Stoplights
• Notifications
• Restriction Groups
• Reverse Calculated Archive
• Audit trail
• Daily Maintenance Stats

Visibility

LoanPro offers some visibility into what happens during the daily maintenance process so clients know when the process has been completed and what occurred. There are multiple methods to view daily maintenance information: reports, event-based notifications, API, and database. Each of the options are outlined below.
 

Report

You can find the Daily Maintenance report for LMS by navigating to My Account > Billing & Statements > LMS Daily Maintenance.

This report shows:

• Day of the Month – The specific day of the month for which data is shown
• Queued Time – The time when Daily Maintenance was queued for execution
• In Progress Time – The time when Daily Maintenance began processing
• Completed Time – The time when Daily Maintenance finished processing
• Warning Flags Evaluation* - The time when the evaluation of Warning Flags completed
• Stoplight Evaluation* - The time when the evaluation of Stoplights completed
• Reverse Calc Completed* - The time when the Reverse Calc process finished
• Queued Loans – The total number of loans eligible for processing during Daily Maintenance (non-archived loans in the tenant)
• Loans Maintained – The total number of loans processed during Daily Maintenance
• *These evaluations occur outside the Daily Maintenance period.

You can filter results by month and year using the filter drop-downs at the top left of the report.

For line of credit, you can find the Daily Maintenance report by navigating to My Account > Billing & Statements > LOC Daily Maintenance.

[image here]

This report shows:

• Day of the Month: The specific day of the month for which data is shown
• Queued Time: The time when Daily Maintenance was queued for execution
• In Progress Time: The time when Daily Maintenance began processing
• Completed Time: The time when Daily Maintenance finished processing
• Queued Lines of Credit: The total number of lines of credit eligible for processing during Daily
• Maintenance (non-archived LOCs in the tenant)
• Lines of Credit Maintained: The total number of lines of credit processed during Daily Maintenance

Event-Based Notifications

There are three event-based notifications that can be used to notify you about Daily Maintenance. These include:

• Daily Maintenance Queued: Your tenant has been added to the queue so that Daily Maintenance can run on your tenant and accounts.
• Daily Maintenance In Progress: Daily Maintenance is running on your tenant and is updating your accounts.
• Daily Maintenance Completed: Your tenant and all of your accounts have been updated by Daily Maintenance.

API

Information about Daily Maintenance can be pulled through the API. To pull Daily Maintenance information, send a GET request to the following endpoint:

GET https://loanpro.simnang.com/api/public/api/1/odata.svc/TenantDMStats

This endpoint will return Daily Maintenance information for all of the days that have been recorded for the tenant. The information for each day will look like this:

{ "__metadata": 
   { "uri": "http://loanpro.simnang.com/api/public/api/1/odata.svc/TenantDMStats(id='14',date=datetime'2021-03-19')", "type": "Entity.TenantDMStats" 
   }, 
   "id": "14", 
   "date": "/Date(1616112000)/", 
   "queued": "/Date(1616133984)/", 
   "inProgress": "/Date(1616133988)/", 
   "completed": "/Date(1616139970)/", 
   "totalLoans": 447, 
   "maintainedLoans": 447 
}

This information includes:
 

• id – An ID for the record
• date – The date and time for this record
• queued – The date and time when Daily Maintenance was queued
• inProgress – The date and time when Daily Maintenance started processing the tenant
• completed – The date and time when Daily Maintenance finished processing the tenant
• totalLoans – The total number of loans eligible to be processed by Daily Maintenance (non-archived loans in the tenant)
• maintainedLoans – The total number of loans processed by Daily Maintenance

If you would like to get this information for a specific date, an OData filter or other parameters can be added to the endpoint URL.

For example:

https://loanpro.simnang.com/api/public/api/1/odata.svc/TenantDMStats?$filter=date%20ge%20datetime%272021-03-17%27%20and%20date%20le%20datetime%272021-03-17%27&$orderby=date

Using the $filter token and the $orderby token will let you specify a date range for which information will be returned and the property that will be used to sort the data.
 

Database

The information displayed in the Daily Maintenance Report (My Account > Billing & Statements > Daily Maintenance) comes from a database table called dm_stats_entity. This table can be queried to get completion times for daily maintenance.