Ability to query Status Date Change for Recurring Gifts

In order to create correspondence to Constituents based off a change to their Recurring Gift, it would be good to be able to query the REVENUESCHEDULE table - in particular the change date, in a revenue query.
  • Guest
  • Jun 29 2015
  • Reviewed: Voting Open
  • Attach files
  • Guest commented
    16 Feb, 2017 06:43am

    This node should also include the 'Details' field as displayed on the Activity tab of the recurring gift, so that we can query on what changed the status.

  • Tony Graddon commented
    25 Jan, 2017 05:52am

    This node should include all the standard System fields.  Without Date Added and Date Changed this node is difficult or impossible to use.  Surely this was just an oversight by the development team?

  • Guest commented
    25 Jan, 2017 05:41am

    Without the date, this new node is essentially useless.  Please provide a date.  That way we will be able to use it in query and export definitions to get the latest status change (and reason for it).

  • Guest commented
    13 Jun, 2016 06:52pm

    The 'Recurring Gift Amendments' node in the Revenue query doesn't include the date the recurring gift status was changed. The date is important esp as the RG Amendment returns multiple rows from the entire history of the gift.

  • +18