Table: Loan Status Archive

Table: Loan Status Archive

An archive of loan statuses.

Column Data Type Column Info Value Notes Other
loan_idint(11)The id of the associated loan account
datedateArchive date
amount_duedecimal(11,2)amount due
due_interestdecimal(11,2)due interest
due_principaldecimal(11,2)due principal
due_discountdecimal(11,2)due discount
due_escrowdecimal(11,2)due escrow
due_escrow_breakdownvarchar(255)due escrow breakdown
due_feesdecimal(11,2)due fees
due_pnidecimal(11,2)due P & I
payoff_feesdecimal(11,2)Payoff fees
next_payment_datedatenext payment date
next_payment_amountdecimal(11,2)next payment amount
last_payment_datedatelast payment date
last_payment_amountdecimal(11,2)last payment amount
principal_balancedecimal(11,2)principal balance
amount_past_due_30decimal(11,2)amount past due (for 30 days)
days_past_dueint(11)days past due
date_last_currentdatedate last current
date_last_current_30datedate last current (for 30 days)
payoffdecimal(11,2)Archived payoff amount
perdiemdecimal(11,2)Perdiem
interest_accrued_todaydecimal(11,2)Interest accrued today
available_creditdecimal(11,2)available credit
credit_limitdecimal(11,2)credit limit
period_startdateTransaction period start
period_enddateTransaction period end
periods_remainingint(11)periods remaining
escrow_balancedecimal(11,2)escrow balance
escrow_balance_breakdownvarchar(255)escrow balance breakdown
discount_remainingdecimal(11,2)discount remaining
loan_status_idint(11)Associated loan status id
loan_status_textvarchar(255)loan status text
loan_sub_status_idint(11)Associeated loan sub status id
loan_sub_status_textvarchar(255)loan sub status text
credit_statuschar(30)credit statusloan.creditstatus.*
loan_ageint(11)loan age
loan_recencyint(11)loan recensy
last_human_activitydatelast human activity
stoplightchar(30)stoplight statusstoplight.display.*
final_payment_datedatefinal payment date
final_payment_amountdecimal(11,2)final payment amount
net_charge_offdecimal(11,2)net charge off
first_delinquency_datedatefirst delinquency date
unique_delinquenciesint(11)number of unique delinquencies
delinquency_percentdecimal(11,2)Loan delinquency lifetime percentage
delinquent_daysint(11)days delinquent
calced_ecoachar(20)Calculated ECOA code for co-borrower for borrowerloan.ecoacodes.*
calced_ecoa_cobuyerchar(20)Calculated ECOA Code for co-borrowerloan.ecoacodes.*
deletedtinyint(1)Whether or not the entity was deleted1 - yes, 0 - no
custom_fields_breakdownvarchar(4000)Custom fields breakdown
portfolio_breakdownvarchar(4000)Encoded portfolio breakdown
sub_portfolio_breakdownvarchar(4000)Encoded sub-portfolio breakdown
lastUpdatedtimestampTimestamp of when the entity was last updated

< Back to List