Database – Loan Delinquency (loan_delinquency_entity)
Description
This table lists all the database columns for Loan Delinquencies.
Common Uses
Used to get information about delinquency of loans. Typically used to pull data on a large quantity 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) | ||
first_delinquency_date | date | The date when the loan was first delinquent. |