Database – Loan Due Date Change (loan_duedate_change_entity)
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 |