Author Topic: Status date discovery  (Read 2029 times)


  • Sr. Member
  • ****
  • Posts: 401
    • View Profile
    • Email
Status date discovery
« on: February 14, 2015, 11:54:03 AM »
Maybe everyone already knows this and I have just been thick, but I have looked for a long time for a way to identify Current notes I hold that have had a problem payment some time in the past without having to open and/or screen scrape every loans payment history. I just got it. The "LoanStatusDate" shows the last time the loan status CHANGED. It is usually about one month after the "Note Issue Date" when the status changes from Issued to Current.

If you create a new field Change Days = (LoanStatusDate - Note Issue Date) as a integer you can easily pick out Status changes after the initial 30 days. These of course include Fully Paid, Charged off and other status changes but also thankfully flags Current notes that at one time where something other than Current.