DataConnect Data Extracts

Oracle Utilities DataConnect can be used to extract the following types of data:

  • Customer Data

    (see Customer and Premise Data Extracts for more information)

    • Account information (including service agreement, account, and person related information)

    • Service agreement’s service point information

    • Mailing address information

  • Premise Data

    (see Customer and Premise Data Extracts for more information)

    • Premise information

    • Service point information

    • Device installation information

    • Device information

    • Measuring component information

  • Billing Data

    (see Billing Data Extracts for more information)

    • Bill

    • Bill segment

    • Bill segment calculation lines

    • Bill segment service quantities

  • Measurement Data

    (see Consumption Data Extracts for more information)

The data extracted can be correlated in external systems using the service agreement and/or service point data that is included in each type of extract. All data extracts contain a combination of the following data elements that can be used for this correlation:

  • CCB Service Point ID: The service point ID in Oracle Utilities Customer to Meter and/or

  • MDM Service Point ID: The service point ID in Oracle Utilities Meter Data Management and/or

  • Service Agreement ID: The service agreement ID in Oracle Utilities Customer to Meter

External systems receiving data extracted from the Oracle Utilities DataConnect facilities can use these IDs to associate billing data and measurement data to extracted master data.

Note: There is a version 1 and version 1+ for the DataConnect extracts. In the following pages where a system object such as a batch control or data area is noted the objects are listed as (v1/v1+). When only a single object is noted it applies to both v1 and v1+.