Table: Loan Reverse Status Archive

Table: Loan Reverse Status Archive

Holds archived status change information for reverse calculation of history.

Column Data Type Column Info Value Notes Other
loan_idint(11)The id of the associated loan account
datedateReversal date
mod_idint(11)The id of the associated loan modification
principal_balancedecimal(11,2)principal balance
payoff_feesdecimal(11,2)Payoff fees
loan_ageint(11)loan age
amount_past_due_30decimal(11,2)amount past due (for 30 days)
days_past_dueint(11)days past due
daily_accrued_interestdecimal(16,7)daily accrued interest
due_discountdecimal(11,2)due discount
due_interestdecimal(11,2)due interest
due_feesdecimal(11,2)due fees
due_principaldecimal(11,2)due principal
due_escrowstextdue escrow amount
net_charge_offdecimal(11,2)net charge off
deletedtinyint(1)Whether or not the entity was deleted1 - yes, 0 - no
lastUpdatedtimestampTimestamp of when the entity was last updated

< Back to List