Converting Interval Register Data

Interval register data from Oracle Utilities Customer Care and Billing can be converted into Measurement data for use in Customer to Meter (and Customer Cloud Service).

Note: Refer to Maintaining Interval Data and Maintaining Interval Data in the Oracle Utilities Customer Care and Billing Administrative User Guide for more information about interval register data in Oracle Utilities Customer Care and Billing.

Interval Registers should have been migrated to Interval Measuring Components as part of the Initial Master Data Conversion process (see Initial Master Data Conversion) . Once the registers have been converted, register reads (also known as Register Data Sets) can be converted to measurement data.

A batch control (see below) is used to convert register read data from Interval Register reads to the Customer to Meter (Customer Cloud Service) Measurement table. Processing can be defined for a specified year and month range, and optionally for a range of Register IDs.

Processing Notes:

Only Register Data Sets with a status of "Complete" will be converted. Data sets that have 'No Data' will be excluded from the conversion.
No validation is performed on the interval data. All the interval data is assumed to be valid.
If the Data Set Type is not defined for the register data set, the converted measurements will have a Condition of "Regular".
Register data sets with a Data Set Type of "Estimated" will result in measurements with a Condition of "Estimated".
If overlapping register data sets are processed, the values from the data set with the latest Set Data Time are selected for the conversion.
The conversion process will not fill-in data for periods without interval data.

Creation of records in the Measurement table is be performed via an Insert Select of the Interval Register Data, for a month's worth of data at a time, which will be immediately committed.

Conversion should only be run for a given range of Register IDs for a given date range once. Attempting to convert the Register IDs for the same date range multiple times can result in errors.

Interval Register Data Conversion Batch Control

The Migrate Register Data Set (X1-MIGRD) batch control performs processing for interval register data conversion.

The registers to be converted for each batch run can be defined using the Register ID Low and Register ID High parameters. To process data for a single register, you can set both of these parameters to the same Register ID. If neither parameter is defined, the process will convert data for all registers.

The batch process can convert up to 1 year of data at a time, the specific year is designated by the Year parameter. The Start Month and End Month parameters can be used to further limit the time range for the conversion.

This batch control uses the following parameters:

Register ID Low: Optional. Used to specify an ID value to override the low ID in the thread ID range calculation. This, along with the Register ID High be used to limit the number of records processed by each batch run. If not specified, the process will convert data for all registers whose ID is lower than the Register ID High parameter (if defined).
Register ID High: Optional. Used to specify an ID value to override the high ID in the thread ID range calculation. This, along with the Register ID Low, can be used to limit the number of records processed by each batch run. If not specified, the process will convert data for all registers whose ID is higher than the Register ID Low parameter (if defined)
Year: The year for which data will be converted. (Required)
Start Month: The start month of the time range for which data will be converted. (Required)
End Month: The start month of the time range for which data will be converted. (Required)

Examples:

To convert data for all registers from the year 2020, you would set the parameters as follows:

Year: 2020
Start Month: 01
End Month: 12

To convert data for all registers for the months of January through May of 2020, you would set the parameters as follows:

Year: 2020
Start Month: 01
End Month: 05

To convert data for registers whose IDs range from 10001000 to 10009000 for from the year 2020, you would set the parameters as follows:

Register ID Low: 10001000
Register ID High: 10009000
Year: 2020
Start Month: 01
End Month: 12

To convert data for registers whose IDs range from 1001000 to 1009000 for the months of January through May of 2020, you would set the parameters as follows:

Register ID Low: 10001000
Register ID High: 10009000
Year: 2020
Start Month: 01
End Month: 05