Database – Loan Delinquency History (loan_delinquency_history_entity)
Holds delinquency history for 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 | ||
date | date | curtailment date | ||
dpd | int(11) | Number or Days Past Due | ||
code | char(5) | Delinquency code | ||
first_delinquency_date | date | first delinquency date | ||
deleted | tinyint(1) | Whether or not the entity was deleted | 1 - yes, 0 - no | |
lastUpdated | timestamp | Timestamp of when the entity was last updated |