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.


How did we do?


Powered by HelpDocs (opens in a new tab)