DataConnect Data Extracts
-
Master Data
(see Customer and Premise Data Extracts for more information)-
Service agreement, account, and person related information
-
Service point and premise related information
-
Service point / meter history related information
-
-
Billing Data
(see Billing Data Extracts for more information)
The extraction processes used for each type of data can be run to produce separate extracts or combined into one.
-
Service Point ID: The service point ID in Oracle Utilities Customer Care and Billing and/or
-
Service Agreement ID: The service agreement ID in Oracle Utilities Customer Care and Billing
External systems receiving data extracted from the Oracle Utilities DataConnect facilities can use these IDs to associate billing data to extracted master data.
If a single flat file is preferred, meaning an extract that contains billing data and master data in one export file, the Billing Data extraction process can be configured to retrieve the associated master data of the bills and place the information in the same row as the billing data.