Database - Daily Maintenance Statistics (dm_stats_entity)

This table shows information about the running and completion of LoanPro's daily maintenance process for a specific tenant.

This table is useful for any LMS users who want to know when the daily maintenance process was completed for their tenant. Information on the completion of daily maintenance can also be pulled through the API or an event-based notification can be set up to send a notification upon completion.

Column

Data Type

Column Info

Value Notes

id

int(11)

The ID of the record. Each record represents one run of the daily maintenance process for a tenant.

date

date

The date on which the daily maintenance process was run for this record.

queued

datetime

The time the tenant was put into the queue to have the daily maintenance process run.

in_progress

datetime

The time the daily maintenance process started on the tenant.

completed

datetime

The time the daily maintenance process was completed for the tenant.

total_loans

int(11)

The number of loans that entered the daily maintenance process. This will only include loans that are not archived and that have been activated.

maintained_loans

int(11)

The number of loans on which the daily maintenance process was carried out successfully. Ideally, this should match the total_loans number.

deleted

tinyint(1)

This indicates that this record is marked as deleted in the database.

0 - Not Deleted

1 - Deleted


How did we do?


Powered by HelpDocs (opens in a new tab)