Database – Loan Delinquency (loan_delinquency_entity)
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 in which the current delinquency began—in other words, the first day in which a loan became more than 30 days past due. | |
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 in which the current delinquency began—in other words, the first day in which a loan became more than 30 days past due. |