Author Topic: Description of Payment History File  (Read 379 times)

Jogi

  • Newbie
  • *
  • Posts: 17
    • View Profile
Description of Payment History File
« on: September 24, 2017, 12:12:41 PM »
Dear Community,

I do have problems to understand the payment history, which is provided under: https://www.lendingclub.com/company/additional-statistics
What I do miss, is a proper description as for the application file.
So my first question is:

Do you have such a file?

In case that such a proper description is not available, I'm concerned with the following fields: RECEIVED_AMT, PCO_RECOVERY, PCO_COLLECTION_FEE.
What's the meaning of these fields?
Why is in case of a "Charge Off" the value of PCO_RECOVERY so different from RECEIVED_AMT?
(In my understanding, the PCO_RECOVERY is the amount recovered - but why is then this amount so different from the RECEIVED_AMT?

Many thanks in advance!

Pinglory

  • Newbie
  • *
  • Posts: 1
    • View Profile
Re: Description of Payment History File
« Reply #1 on: October 04, 2017, 06:04:02 AM »
I'm sure the information you give is really valuable.

bkcarp00

  • Newbie
  • *
  • Posts: 3
    • View Profile
Re: Description of Payment History File
« Reply #2 on: October 04, 2017, 12:12:11 PM »
Look at the Data Dictionary. It list all the columns and details of what they mean.

https://www.lendingclub.com/info/download-data.action

Jogi

  • Newbie
  • *
  • Posts: 17
    • View Profile
Re: Description of Payment History File
« Reply #3 on: October 12, 2017, 06:47:42 AM »
@ bkcarp00 This file only contains the description of the application file. Not the payment history. The payment history has the following fileds: LOAN_ID ,BAL_BEG_PERIOD, PRNCP_PAID,INT_PAID,FEE_PAID,DUE_AMT... They're not in this file however!

Fred93

  • Hero Member
  • *****
  • Posts: 1869
    • View Profile
Re: Description of Payment History File
« Reply #4 on: October 12, 2017, 01:44:05 PM »
We've all had to deal with this relatively poor and missing documentation.

Most of us ran out of energy re bugging LC to get better doc a long time ago.  If you have energy, please do us all a favor and direct your energy at them to try to get improved doc for all of us.  I don't think you'll succeed, but we're behind you 100%.

Jogi

  • Newbie
  • *
  • Posts: 17
    • View Profile
Re: Description of Payment History File
« Reply #5 on: October 12, 2017, 05:54:28 PM »
@Fred93: Very sad ...LC claims to be to be 100% transparent... Data  > Context Information > Insight . No Content Info no Insight...

nevermore

  • Newbie
  • *
  • Posts: 12
    • View Profile
Re: Description of Payment History File
« Reply #6 on: October 14, 2017, 06:12:40 AM »
I've used this file extensively. If I recall correctly, received_amt is defined as prncp_paid + int_paid + fee_paid (with a few exceptions).