@HAhmed-WMF in discussion we are altering the way chariot is recorded such that
- the gateway for all of them will now be 'chariot'
- the reporting @MDemosWMF asked for was on this field so it needs to be calculated now...
| Reporting category | Before | After |
| Chariot Digital Mailbox | gateway=Chariot Digital Mailbox | gateway=chariot and payment_instrument_id = 4 (Check) |
| Chariot DafPay | gateway=Chariot DAFPay | gateway=chariot and payment_instrument_id = 287 (DAFPay ) |
| Chariot Disbursements | gateway=Chariot Disbursements | gateway=chariot and payment_instrument_id not per above / in practice this means ACH (277) or EFT (5) |
Note that as of right now the payment instruments are correct per above but the gateway is not - I feel like it makes sense for you to update to the after but with LIKE 'chariot%' as a transitional step. Once you have updated to that we will update the gateway to be just chariot - slightly fiddly but will mean that the dashboard has no 'outage'