When editing the status on a recurring gift after setting the status, the user is prompted to select a Reason code for status change. This Reason code does not have a corresponding field in the Revenue query view.
We are currently evaluating this issue for a fix in a future release.
Steps to Duplicate
1. Go to Analysis\Information Library\Add an ad-hoc query 2. Choose Revenue as the source view 3. Scroll down the available fields and see the Recurring Gift Payments\Recurring Gift Details\Recurring Gift Status 4. Note that there is no field for Reason code for status change