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 | Other |
id | int(11) | The id of the entity | ||
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 before the changed_date | ||
new_date | date | New due date the changed_date was changed to | ||
changed_date | date | The due date 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 |