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


How did we do?


Powered by HelpDocs (opens in a new tab)