Account Data Version History

Delete redundant copy of account_id column from Service Agreement Fields.

v2-0-5

Update locality in Person Address File from VARCHAR(64) to VARCHAR(90).

v2-0-4

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

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 File Naming Conventions to be clearer about file name length limit and what file name components are required.

v2-0-2

Update examples in File Name Conventions to use incremented major version number and current year.

v2-0-1

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

Update supported version number for DataConnect extracts.

v1-2-0

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

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