Database – Loan Delinquency (loan_delinquency_entity)
Updated 5 days ago
Description
This table lists all the database columns for Loan Delinquencies. This lets you find information about delinquency on a loan — typically used to pull data on large quantities of loans.
Table Fields
Column | Data Type | Column Info | Value Notes |
loan_id | int(11) | This is the id of the loan in question. | |
date_of_first_delinquency | date | The date when the current delinquency began | |
unique_delinquencies | int(11) | Number of times the borrower has been delinquent but subsequently come current. | |
delinquency_percent | decimal(11,2) | Ratio of delinquent days to active days expressed as a percentage. | |
delinquent_days | int(11) | Number of days the loan has been delinquent. | |
deleted | tinyint(1) | This determines whether the delinquency is deleted. | 1 – yes 2 – no |
lastUpdated | timestamp | Timestamp of the last time the record was updated | |
payment_history | varchar(255) |
| '308', '2020-04-13', '2', '84.57', '729', '0', '2022-01-06 14:17:42', '666666666666666654321000', '2019-10-28' |
first_delinquency_date | date | The date when the loan was first delinquent. |