Database – Loan Due Date Change (loan_duedate_change_entity)
Updated 4 months ago
Description
Holds information for due-date changes on a loan
|
Column |
Data Type |
Column Info |
Value Notes |
|
id |
int(11) |
The ID of the due date change record |
|
|
entity_id |
int(11) |
ID of the associated entity |
|
|
entity_type |
varchar(100) |
Type of the associated entity |
|
|
mod_id |
int(11) |
The ID of the associated loan modification |
|
|
original_date |
date |
The due date prior to the changed_date in the schedule. This is for tracking purposes and isn't found in the LMS UI. |
|
|
new_date |
date |
The date that the changed_date was changed to |
|
|
changed_date |
date |
The due date from the schedule that was changed |
|
|
due_date_on_last_dom |
tinyint(1) |
Due date on last day of month |
1 - yes 0 - no |
|
deleted |
tinyint(1) |
Whether or not the entity was deleted |
1 - yes 0 - no |
|
lastUpdated |
timestamp |
Timestamp of when the entity was last updated |