cal-itp/data-infra

Backfill `settlement_status` for CCJPA aggregations in November

Closed this issue · 0 comments

After manually backfilling aggregations for the month of October whose settlement_status should have been REJECTED in #3186, we discovered similar cases that occurred in November.

As a Payments data analyst, I want the relevant settlement_status fields backfilled for CCJPA for the month of November as well, so that I can fully replicate the historical reporting received from Littlepay.

See this thread in Slack for details

Aggregations = CREDIT whose settlement_status should be updated to REJECTED:

  • cabeed80-b77e-4d59-a81c-cb65261ddacf
  • c085d11c-5a7d-4e22-a4b5-16ecca1ed258
  • 40ab2100-89e7-41dc-9504-36bde373044f
  • eff828d8-e3c3-4df3-a390-7dd86505753e