Database – Loan Reverse Status Archive (loan_reverse_status_archive)
Description
Holds archived status change information for reverse calculation of history.
Column | Data Type | Column Info | Value Notes | Other |
loan_id | int(11) | The id of the associated loan account | ||
date | date | Reversal date | ||
mod_id | int(11) | The id of the associated loan modification | ||
principal_balance | decimal(11,2) | principal balance | ||
payoff_fees | decimal(11,2) | Payoff fees | ||
delinquent_bucket | smallint(5) | This is the highest delinquency bucket that loan is in. Delinquency buckets show how many payments have been missed on the loan | ||
delinquent_bucket_balance | text | Detailed information about the delinquent bucket balance in JSON format | ||
loan_age | int(11) | loan age | ||
amount_past_due_30 | decimal(11,2) | amount past due (for 30 days) | ||
days_past_due | int(11) | days past due | ||
daily_accrued_interest | decimal(16,7) | daily accrued interest | ||
due_discount | decimal(11,2) | due discount | ||
due_interest | decimal(11,2) | due interest | ||
due_fees | decimal(11,2) | due fees | ||
due_principal | decimal(11,2) | due principal | ||
due_escrows | text | due escrow amount | ||
net_charge_off | decimal(11,2) | net charge off | ||
deleted | tinyint(1) | Whether or not the entity was deleted | 1 - yes, 0 - no | |
lastUpdated | timestamp | Timestamp of when the entity was last updated |