Premise Data Version History

The following table lists updates to the premise 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 Premise Data File Name Conventions for more information.

Update Specification Version Number Date
Update status_code allowed values in Service Point Fields to be all caps. Update device_status allowed values in Device Fields to be all caps. v2-0-7 08/26/2025
Remove service_agreement_id from Service Point Fields since it is a redundant column. Add 300 as an allowed value in interval_size in Measure Component Fields. v2-0-6 08/07/2025
Update service_quantity_identifier column in Measure Component Fields to include NET_USAGE as an example value. v2-0-5 06/27/2025
Remove register_id reference from Measuring Component Fields. This column has been replaced by other columns in the Interval Data Transfer specification, and so it no longer applies. v2-0-4 07/20/2023
Update service_point_type_code column description in Service Point Fields to specify VARCHAR(2) instead of VARCHAR(30). Update interval_size column description in Measuring Component Fields to specify that the column cannot be empty. v2-0-3 08/01/2022
Expand the list of allowable values for the unit_of_measure field in Measuring Components. Update Premise 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 Premise 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 Premise 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 measuring_component_id description in Measuring Component Fields to explain how it maps to another field in the Oracle Utilities interval data file. Rename updated_at to premise_updated_at in Premise Fields. Update install_event_id in Device Installation Fields to accept VARCHAR(80).

A variety of additional updates were made to improve clarity and meaning. Contact your Delivery Team for a more detailed list of changes.

v1-1-0 10/09/2020
Update multiple field descriptions to improve clarity. 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 premise data file specification. v0-9-0 11/12/2019