HomeGuidesRecipesAPI ReferenceChangelog
Log In

Provider Data Migrations

What is this page?

At times, providers may undergo system-wide migrations of their underlying data, like changing account number formats. This page details how we are accommodating each event in our data representation.

October 2023 – ConEd Account Number Migration

Summary

  • ConEd is replacing all of their 15-digit customer account numbers with an 11-digit number. Their IT systems will be unavailable from October 6-9, 2023 while this migration is occurring.
  • ConEd enrollment in Connect has been disabled as of 5pm on October 5, 2023 and will continue to be disabled until 10am EST on October 10, 2023.
  • No changes to your API integration will be required in order to accommodate the change. However, Arc will not be presenting the old account number in the API so, if you need to persist that data, you should do it before October 10th, 2023.
  • No new statement data will be fetched for enrolled customers while the ConEd systems are offline and for up to two weeks after that downtime while Arcadia manually migrates account numbers and accommodates new billing formats.

Enrollments

  • Connect will be disabled for ConEd starting at 5pm EST on October 5, 2023 and re-enabled at 10am EST on October 10, 2023. The Connect UI will report to users that ConEd is temporarily not available and it will not allow accounts numbers to be submitted.
  • Once Connect is re-enabled, Connect will accept both legacy 15-digit account numbers and the upcoming 11-digit account numbers so new users enrolling through Connect should have no problems authenticating with Arc or having their data retrieved after the ConEd system comes back online. At least 90 days after the migration, Arcadia will remove the ability to submit legacy 15-digit account numbers to enroll accounts and only the 11-digit account numbers will be accepted.

Data Delivery

  • Arcadia will be running a manual update on all existing ConEd accounts to replace the old 15-digit account number with the new 11-digit account number. This process is expected to take up to two weeks after when the ConEd IT systems come back online on October 10, 2023.
  • Arc UtilityAccount.ids (the unique ID assigned by Arc’s system) will not change across the migration.
  • Arc will emit a utility_account_updated webhook event that includes the new utility account number for each enrolled utility account. You will also be able to access the new account number via the UtilityAccount.account_number field.
    • If you don’t store the account number separately from the Arc database, then you don’t need to handle this webhook event.
    • The old account number will not be persisted within Arc so, if you need to persist that number for any reason, you should persist it prior to the end of the ConEd system maintenance on October 10th.