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 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.


How did we do?


Powered by HelpDocs (opens in a new tab)