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