Unsubscribes Extract (Incremental)

The Unsubscribes extract contains details about the digital channels from which customers have unsubscribed. It is available on request from your Delivery Team.

Column	Description
utility_customer_id	The customer identifier that is used on customer communications. This is usually the same value as the `customer_id` column sent by the utility in other data files, but not always. Additional identifiers may need to be added to the extract. Discuss this modification with your Delivery Team, if necessary. Example: 1234-1234-1234-1234 Field Size: 40. Can Be Empty?: No.
channel	Communication channel where the unsubscribe occurred. Allowed Values: EMAIL IVR SMS Field Size: 5. Can Be Empty?: No.
address	Email address or phone number that was unsubscribed. Examples: example@utilco.com (123) 123-1234 Field Size: 255. Can Be Empty?: No.
date_unsubscribed	The date when the unsubscribe record was created. This is the date when Oracle Utilities received the unsubscribe event. This conforms with the ISO 8601 date and time standard in the UTC time zone. Example: 2015-07-05T22:16:18+00:00 Field Size: 32. Can Be Empty?: No.