Account Data Version History

The following table lists updates to the account data specification by version number and date. The latest version number should be used in the file name that you send to Oracle Utilities. See Account Data File Name Conventions for more information.

Update	Specification Version Number	Date
Update description of business_name in Person Fields to more clearly explain what is required.	v2-0-9	09/05/2025
Update description of first_name and last_name in Person Fields to more clearly explain what is required. Update status_code in Service Agreement Fields to more clearly separate allowed values from definitions.	v2-0-8	08/26/2025
Update the description of the service_agreement_end_datetime field in Service Agreement Fields to better advise utilities on how to complete the field. Update the Service Agreement Service Points File to add a new allowed value to the usage_flag field.	v2-0-7	03/17/2025
Update Main Account File, Person Address File, and Service Agreement Service Points File to include a cross-reference to Account Data File Name Conventions. Remove redundant file naming conventions.	v2-0-6	10/01/2024
Delete redundant copy of account_id column from Service Agreement Fields.	v2-0-5	04/17/2023
Update locality in Person Address File from VARCHAR(64) to VARCHAR(90).	v2-0-4	01/04/2023
Update Person Fields to improve accuracy of phone number and email address examples. Update Service Agreement Fields to add new columns: service_agreement_type_code service_agreement_type_description special_role_flag_code special_role_flag_description Update Person Address File to clarify that only the latest address for a person_id is stored, and to remove legacy columns: is_seasonal_address seasonal_address_start_datetime seasonal_address_end_datetime	v2-0-3	08/02/2022
Update bill_cycle_code column in Account Fields to say it is no longer required but is preferred. Add person_type and business_name to Person Fields. Add business_classification_code to Service Agreement Fields. Update Account Data File Name Conventions to be clearer about file name length limit and what file name components are required.	v2-0-2	04/11/2022
Update examples in Account Data File Name Conventions to use incremented major version number and current year.	v2-0-1	12/06/2021
Increment to a major version number to designate Account Data Transfer as a core data standard for utilities. Clarify that zip files should only contain one file each.	v2-0-0	11/23/2021
Update supported version number for DataConnect extracts.	v1-2-0	07/28/2021
Update admin_area_x fields in the Person Address File to match the same fields in the Premise File. Update effective_datetime in Service Agreement Rate Fields to say it cannot be empty. Update usage_percent field in Service Agreement Service Points File to say it can be empty.	v1-1-0	10/09/2020
Update multiple field descriptions to improve clarity. Merge phone and email field descriptions into the Person Fields topic. Update introductory topics to simplify explanations and improve cross-references. Add new information about common data formats. For a more detailed list of changes, contact your Delivery Team.	v1-0-0	05/14/2020
Initial draft of account data file specification.	v0-9-0	11/12/2019