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 |
|---|---|---|
|
Install Event Snapshot for Legacy DataConnect |
The Install Event Snapshot for DataConnect data area is used for install event master data extract. |
D1-ExternalRepositoryIESnapsht |
|
SP Meter Snapshot for DataConnect |
The Service Point and Meter Snapshot for DataConnect v1+ data area is used for service point and meter master data extract. |
D1-ExternalRepositorySPMtrSnap |
|
Service Point Snapshot for Legacy DataConnect |
The Service Point Snapshot for DataConnect data area is used for service point master data extract. |
D1-ExternalRepositorySPSnapsht |
|
Extract Snapshot for DataConnect (Condition) |
The Consumption Extract Snapshot data area is used for interval consumption extract, with measurement conditions. |
D2-IntDataExtSnapshotMsrmtCond |
|
Extract Snapshot for Legacy DataConnect |
The Consumption Extract Snapshot data area is used for interval consumption extract. |
D2-IntervalDataExtRepoSnapshot |
|
Extract Snapshot for Legacy DataConnect (TOU Mapping) |
The Consumption Extract Snapshot (TOU Mapping) data area is used for interval consumption extract mapped to TOU periods. |
D2-IntervalDataExtRepoTOUSnap |
|
Extract Snapshot for DataConnect |
The Consumption Extract Snapshot data area is used for interval consumption extract, with UTC offset. |
D2-IntervalDataExtRepoSnpstUTC |
|
Extract Snapshot for DataConnect (TOU Mapping) |
The Consumption Extract Snapshot (TOU Mapping) data area is used for interval consumption extract mapped to TOU periods, with UTC offset. |
D2-IntervalDataExtRepoTOUSnUTC |
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