Billable_usage_remittance records were being saved with status='pending' before the status success/failure message was implemented. In order to mark these records as no longer pending we need to create a liquibase script that updates all existing records to have status='unknown'.

After this change, we expect four different statuses:

• pending - initial state
• failed - when producer encounters an issue
• succeeded - when producer successfully sends
• unknown - old records that we cannot be sure were remitted without consulting the logs

AC:

• All existing billable_usage_remittance older than the release where we started populating the statuses ( Prior to October 1) where status='pending' or status is null records updated to have status='unknown'.
  • Look for better timestamp by looking for earliest failed/succeeded billable_usage_remittance.
• Testing: May use long-running tests to verify this in stage.