Extract Flat File Formats
The data included in each file is based on a specific Data Area. For each Data Area, this section provides a table that lists the name and corresponding schema element and metadata field for each data element extracted by the Data Area. Reference the
Data Areas below to see the details for the fields included in each output.
Process | Description | Data Area |
Consumption Extract Snapshot (with UTC Offset) | The Consumption Extract Snapshot data area is used for interval consumption extract, with UTC offset. | D2-IntervalDataExtRepoSnpstUTC |
Consumption Extract Snapshot (TOU Mapping) | The Consumption Extract Snapshot (TOU Mapping) data area is used for interval consumption extract mapped to TOU periods. | D2-IntervalDataExtRepoTOUSnap |
Consumption Extract Snapshot (TOU Mapping with UTC Offset) | The Consumption Extract Snapshot (TOU Mapping) data area is used for interval consumption extract mapped to TOU periods, with UTC offset. | D2-IntervalDataExtRepoTOUSnUTC |
Consumption Extract Snapshot with Measurement Condition | The Consumption Extract Snapshot data area is used for interval consumption extract, with measurement conditions. | D2-IntDataExtSnapshotMsrmtCond |
Service Point Snapshot for DataConnect | The Service Point Snapshot for DataConnect data area is used for service point master data extract. | D1-ExternalRepositorySPSnapsht |
SP Meter Snapshot for DataConnect v1+ | The Service Point and Meter Snapshot for DataConnect v1+ data area is used for service point and meter master data extract. | D1-ExternalRepositorySPMtrSnap |
Install Event Snapshot for DataConnect | The Install Event Snapshot for DataConnect data area is used for install event master data extract. | D1-ExternalRepositoryIESnapsht |
Specifics for how the flat files are created are defined on batch controls and algorithms used by the extract process.
• File Name and Path: Parameters on batch controls define the file name, path, and other details about the output file.
• File Size and Contents: Batch controls for initial load/ongoing consumption requests include a parameter to specify the number of service points to be included in each file.
• Character Encoding and File Delimiter: Parameters on the Prepare Delimited Extract Data (D1-PRPEXTDTA) algorithm are used to specify the character encoding and delimiter used in the flat files for master data extracts.
Example Extract File
The following example illustrates comma-separated interval data extracts based on the Consumption Extract Snapshot data area:
19502793-60E-KMUS,714532246966,19502793-60E-KMSP,KWH, ,3,600,1.366,2015-01-01,07.00.00,No
19502793-60E-KMUS,714532246966,19502793-60E-KMSP,KWH, ,3,600,1.366,2015-01-01,08.00.0,No
19502793-60E-KMUS,714532246966,19502793-60E-KMSP,KWH, ,3,600,1.366.2015-01-01,09.00.0,No
19502793-60E-KMUS,714532246966,19502793-60E-KMSP,KWH, ,3,600,1.366,2015-01-01,10.00.00,No
19502793-60E-KMUS,714532246966,19502793-60E-KMSP,KWH, ,3,600,1.366,2015-01-01,11.00.00,No
19502793-60E-KMUS,714532246966,19502793-60E-KMSP,KWH, ,3,600,1.366,2015-01-01,12.00.00,No
19502793-60E-KMUS,714532246966,19502793-60E-KMSP,KWH, ,3,600,1.366,2015-01-01,13.00.00,No
Parent topic