Extract Flat File Formats
This section outlines the format of output flat files created by master data, billing data, and consumption data extracts.
-
D2-IntervalDataExtRepoSnapshot (used for interval consumption extract for Legacy DataConnect)
-
D2-IntervalDataExtRepoTOUSnap (used for interval consumption extract mapped to TOU periods for Legacy DataConnect)
-
D2-IntervalDataExtRepoSnpstUTC (used for interval consumption extract)
-
D2-IntervalDataExtRepoTOUSnUTC (used for interval consumption extract mapped to TOU periods)
-
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.
C1-AcctMailingAddrDataSnapshot
C1-AcctMailingAddrDataSnapshot is used for mailing address data extracts, and includes the following information:
Field Name |
Schema Element |
Metadata Field |
---|---|---|
Account ID |
accountId |
ACCOUNT_ID |
Person Id |
personId |
PERSON_ID |
Is Seasonal Address |
isSeasonalAddress |
|
Seasonal Address Start Date/Time |
seasonStart |
IS_SEASONAL_ADDRESS |
Seasonal Address End Date/Time |
seasonEnd |
SEASONAL_ADDRESS_END_DTTM |
Mailing Address 1 |
address1 |
MAIL_ADDRESS_1 |
Mailing Address 2 |
address2 |
MAIL_ADDRESS_2 |
Mailing Address 3 |
address3 |
MAIL_ADDRESS_3 |
Mailing Address 4 |
address4 |
MAIL_ADDRESS_4 |
Locality |
city |
LOCALITY |
Postal Code |
postal |
MAIL_POSTAL_CODE |
Admin Area 1 |
state |
ADMIN_AREA_1 |
Admin Area 2 |
adminArea2 |
ADMIN_AREA_2 |
Admin Area 3 |
adminArea3 |
ADMIN_AREA_3 |
Country |
country |
COUNTRY |
Updated at |
personAddressUpdatedAt |
PERSON_ADDRESS_UPDATED_AT |
C1-BillDataSnapshot
C1-BillDataSnapshot is used for the bill-based data extracts, and includes the following information:
Field Name |
Schema Element |
Metadata Field |
---|---|---|
Bill ID |
billId |
BILL_ID |
Account ID |
accountId |
ACCOUNT_ID |
Bill Date |
billDate |
BILL_DATE |
Due Date |
dueDate |
DUE_DATE |
Currency Code |
currencyCode |
CURRENCY_CD |
Current Balance |
currentBalance |
CURRENT_BALANCE |
Payoff Balance |
payoffBalance |
PAYOFF_BALANCE |
Previous Period Balance |
previousPeriodBalance |
PREVIOUS_PERIOD_BALANCE |
Total Payments |
totalPayments |
TOTAL_PAYMENTS |
Total Adjustments |
totalAdjustments |
TOTAL_ADJUSTMENTS |
Total Bill Corrections |
totalBillCorrections |
TOTAL_BILL_CORRECTIONS |
Total Current Billing Charges |
totalCurrentBillingCharges |
TOTAL_CURRENT_BILLING_CHARGES |
Total Balance Current Period |
totalBalanceCurrentPeriod |
TOTAL_BALANCE_CURRENT_PERIOD |
Last Update Date/Time |
lastUpdateDateTime |
BILL_UPDATED_AT |
C1-BillSegmentDataSnapshot
C1-BillSegmentDataSnapshot is used for the bill segment-based data extracts, and includes the following information:
Field Name |
Schema Element |
Metadata Field |
---|---|---|
Bill ID |
billId |
BILL_ID |
Bill Segment ID |
billSegmentId |
BILL_SEGMENT_ID |
Service Agreement |
serviceAgreement |
SERVICE_AGREEMENT_ID |
Start Date |
startDate |
BILL_SEGMENT_START_DATE |
End Date |
endDate |
BILL_SEGMENT_END_DATE |
Usage Start Date/Time |
usageStartDateTime |
USAGE_PERIOD_START_DATE |
Usage End Date/Time |
usageEndDateTime |
USAGE_PERIOD_END_DATE |
Estimated |
isEstimate |
ESTIMATED |
Closing Billing Statement |
isClosingBillSegment |
CLOSING |
Bill Segment Status |
billSegmentStatus |
STATUS |
Bill Cycle |
billCycle |
BILL_CYCLE_CODE |
Bill Cycle Description |
billCycleDescr |
BILL_CYCLE_DESCRIPTION |
Premide ID |
premiseId |
PREMISE_ID |
Current Amount |
currentAmount |
CURRENT_AMOUNT |
Outstanding Amount |
outstandingAmount |
OUTSTANDING_AMOUNT |
Master Bill Segment ID |
masterBillSegmentId |
MASTER_BILL_SEGMENT_ID |
Last Update Date/Time |
lastUpdateDateTime |
BILL_SEGMENT_UPDATED_AT |
C1-CustomerDataSnapshot
C1-CustomerDataSnapshot is used for customer data extracts, and includes the following information:
Field Name |
Schema Element |
Metadata Field |
---|---|---|
Account ID |
accountId |
ACCOUNT_ID |
Account Name |
accountName |
ACCOUNT_NAME |
Account Setup Date/Time |
accountSetUpDateTime |
SETUP_DATETIME |
Customer Class |
customerClass |
CUSTOMER_CLASS |
Bill Cycle |
billCycle |
BILL_CYCLE_CODE |
Bill Cycle Description |
billCycleDescription |
BILL_CYCLE_DESCRIPTION |
Account Updated at |
accountUpdatedAt |
ACCOUNT_UPDATED_AT |
Person ID |
personId |
PERSON_ID |
Person Type |
personOrBusiness |
PERSON_TYPE |
First NamE |
firstName |
FIRST_NAME |
Last Name |
lastName |
LAST_NAME |
Business Name |
businessName |
BUSINESS_NAME |
Language Preference |
language |
LANGUAGE_PREFERENCE |
Is Main Customer |
isMainCustomer |
IS_MAIN_CUSTOMER |
Bill Route Typ |
billRouteType |
BILL_ROUTE_TYPE |
Person Updated at |
personUpdatedAt |
PERSON_UPDATED_AT |
Phone Type |
phoneType |
PHONE_TYPE_ |
Phone Number |
phoneNumber |
PHONE_NUMBER_ |
Phone Extension |
phoneExtension |
PHONE_EXTENSION_ |
|
|
EMAIL_ADDRESS_ |
Email Type |
emailType |
EMAIL_TYPE_ |
Service Agreement ID |
saId |
SERVICE_AGREEMENT_ID |
Service Agreement Name |
saName |
SERVICE_AGREEMENT_NAME |
Start Date/Time |
startDateTime |
SA_START_DATETIME |
End Date/Time |
endDateTime |
SA_END_DATETIME |
Service Type |
serviceType |
SERVICE_TYPE_CODE |
Service Type Description |
serviceTypeDescription |
SERVICE_TYPE_DESC |
SA Status |
saStatus |
STATUS_CODE |
SA Status Description |
saStatusDescription |
STATUS_DESCRIPTION |
SA Type |
saType |
SERVICE_AGREEMENT_TYPE_CODE |
SA Type Description |
saTypeDescription |
SA_TYPE_DESCRIPTION |
Special Role Flag |
specialRole |
SPECIAL_ROLE_FLAG_CODE |
Special Role Flag Description |
specialRoleDescription |
SPECIAL_ROLE_FLAG_DESCRIPTION |
CIS Division |
cisDivision |
CIS_DIVISION |
SIC |
sic |
BUSINESS_CLASSIFICATION_CODE |
SA Updated at |
saUpdatedAt |
SERVICE_AGREEMENT_UPDATED_AT |
SA Rate Code |
saRateCode |
SA_RATE_CODE |
SA Rate Effective Date/Time |
saRateEffectiveDateTime |
EFFECTIVE_DATETIME |
SA Rate Updated at |
saRateUpdatedAt |
SA_RATE_UPDATED_AT |
C1-ExternalRepoSABasedSnapshot
C1-ExternalRepoSABasedSnapshot is used for the service agreement-based master data extracts, and includes the following information:
For DataConnect v1+ please refer to data area C1-CustomerDataSnapshot in the application for the layout/schema.
Field Name | Schema Element | Metadata Field |
---|---|---|
Service Agreement Id |
saId |
SA_ID |
Account Id |
accountId |
ACCT_ID |
Person Id |
personId |
PER_ID |
Bill Cycle |
billCycle |
BILL_CYC_CD |
Bill Cycle Description |
billCycleDescription |
DESCR |
Collection Class |
collectionClass |
COLL_CL_CD |
Collection Class Description |
collectionClassDescription |
DESCR |
Account Information |
accountInformation |
ACCT_INFO |
Customer Class |
customerClass |
CUST_CL_CD |
Customer Class Description |
customerClassDescription |
DESCR |
Landlord Indicator |
landlordIndicator |
C1_LANDLORD_IND |
Mailing Address |
mailingAddress1 |
ADDRESS1 |
Mailing Address 2 |
mailingAddress2 |
ADDRESS2 |
Mailing Address 3 |
mailingAddress3 |
ADDRESS3 |
Mailing City |
mailingCity |
CITY |
Mailing State |
mailingState |
STATE |
Mailing Postal |
mailingPostal |
POSTAL |
First Name |
firstName |
ENTITY_NAME |
Last Name |
lastName |
ENTITY_NAME |
Phone Number 1 |
phone1 |
PHONE |
Phone Number 2 |
phone2 |
PHONE |
Email Address |
|
EMAILID |
Special Role |
specialRole |
SPECIAL_ROLE_FLG |
Special Role Description |
specialRoleDescription |
DESCR |
Service Type |
serviceType |
SVC_TYPE_CD |
Service Type Description |
serviceTypeDescription |
DESCR |
CIS Division |
cisDivision |
CIS_DIVISION |
CIS Division Description |
cisDivisionDescription |
DESCR |
SA Type |
saType |
SA_TYPE_CD |
SA Type Description |
saTypeDescription |
DESCR |
Revenue Class |
revenueClass |
REV_CL_CD |
Revenue Class Description |
revenueClassDescription |
DESCR |
SIC |
sic |
SIC_CD |
SIC Code Description |
sicDescription |
DESCR |
Deposit Class |
depositClass |
DEP_CL_CD |
Deposit Class Description |
depositClassDescription |
DESCR |
Campaign |
campaign |
CAMPAIGN_CD |
Campaign Description |
campaignDescription |
DESCR |
Debt Class |
debtClass |
DEBT_CL_CD |
Debt Class Description |
debtClassDescription |
DESCR |
SA Start Date |
startDate |
START_DT |
SA End Date |
endDate |
END_DT |
SA Status |
saStatus |
SA_STATUS_FLG |
SA Status Description |
saStatusDescription |
DESCR |
Rate Schedule |
rateSchedule |
RS_CD |
Rate Schedule Description |
rateScheduleDescription |
DESCR |
SA's Service Point(s) Id |
spId |
SP_ID |
SA's Service Point(s) Start Date/Time |
startDateTime |
START_DTTM |
SA's Service Point(s) End Date/Time |
stopDateTime |
STOP_DTTM |
D1-ExternalRepositorySPSnapsht
D1-ExternalRepositorySPSnapsht is used for service point-based master data extracts, and includes the following information:
Field Name | Schema Element | Metadata Field |
---|---|---|
Service Point ID |
spId |
D1_SP_ID |
CIS Service Point ID |
cisSpId |
CIS_EXT_SP_ID |
Address |
address1 |
DESCR254 |
City |
city |
CITY |
State |
state |
STATE |
Postal |
postal |
POSTAL |
Service Point Type Code |
spType |
D1_SP_TYPE_CD |
Service Point Type Description |
spTypeDescription |
DESCR100 |
Service Type Code |
serviceType |
D1_SVC_TYPE_CD |
Service Type Description |
serviceTypeDescription |
DESCR100 |
Market Code |
market |
MKT_CD |
Market Description |
marketDescription |
DESCR100 |
Service Point Status Code |
boStatus |
BO_STATUS_CD |
Service Point Status Description |
boStatusDescription |
DESCR100 |
Disconnect Location Flag |
disconnectLocation |
DISCONN_LOC_FLG |
Disconnect Location Description |
disconnectLocationDescription |
DESCR100 |
Measurement Cycle Code |
measurementCycle |
MSRMT_CYC_CD |
Measurement Cycle Description |
measurementCycleDescription |
DESCR100 |
Measurement Cycle Route Code |
measurementCycleRoute |
MSRMT_CYC_RTE_CD |
Measurement Cycle Route Description |
measurementCycleRouteDescription |
DESCR100 |
Geocode Latitude |
geocodeLatitude |
D1_GEO_LAT |
Geocode Longitude |
geocodeLongitude |
D1_GEO_LONG |
Facility Level 1 |
facilityLevel1 |
FACILITY_LEVEL1 |
Facility Level 2 |
facilityLevel2 |
FACILITY_LEVEL2 |
Facility Level 13 |
facilityLevel3 |
FACILITY_LEVEL3 |
D1–ExternalRepositorySPMtrSnap
D1-ExternalRepositorySPMtrSnap is used for service points, device configurations, and devices master data extracts, and includes the following information:
Field Name |
Schema Element |
Metadata Field |
---|---|---|
Premise ID |
premiseId |
D1_PREMISE_ID |
Premise Name |
premiseName |
PREMISE_NAME_LBL |
External Premise ID |
externalPremiseId |
D1_SP_EXT_PREMISE_ID |
Parent Premise ID |
parentPremiseId |
D1_PREMISE_ID |
Premise Type |
premiseType |
D1_PREMISE_TYPE |
Premise Type Description |
premiseTypeDescription |
PREMISE_TYPE_DESCR_LBL |
Address 1 |
address1 |
SP_ADDRESS1_LBL |
Address 2 |
address2 |
SP_ADDRESS2_LBL |
Address 3 |
address3 |
SP_ADDRESS3_LBL |
Address 4 |
address4 |
SP_ADDRESS4_LBL |
City |
city |
CITY |
County |
county |
DESCR50 |
Postal |
postal |
POSTAL |
State |
state |
STATE |
Country |
country |
COUNTRY |
Admin Area 3 |
adminArea3 |
D1_ADMIN_AREA_3 |
Division |
division |
DIVISION_CD |
Premise Time Zone |
premiseTimeZone |
PREMISE_TIME_ZONE_CD |
Geocode Latitude |
geocodeLatitude |
D1_GEO_LAT |
Geocode Longitude |
geocodeLongitude |
D1_GEO_LONG |
Landlord Agreement |
landlordAgreementId |
D1_LL_ID |
Premise Updated At |
premiseUpdatedAt |
D1_PREMISE_UPDATED_AT |
Service Point ID |
spId |
D1_SP_ID |
Service Point Name |
spName |
SP_NAME_LBL |
SP Type Description |
spTypeDescription |
SP_TYPE_DESCR_LBL |
Service Point Type Category |
spTypeCategory |
SP_CATEGORY_FLG |
SP Type |
spType |
D1_SP_TYPE_CD |
Most Recent SA ID |
mostRecentSAId |
US_ID |
Service Agreement Start Date/Time |
SAStartDateTime |
START_DTTM |
Service Agreement Stop Date/Time |
SAStopDateTime |
D2_STOP_DTTM |
Measurement Cycle |
measurementCycle |
MSRMT_CYC_CD |
Measurement Cycle Description |
measurementCycleDescription |
MSRMT_CYCLE_DESCR_LBL |
Measurement Cycle Route |
measurementCycleRoute |
MSRMT_CYC_RTE_CD |
Measurement Cycle Route Description |
measurementCycleRouteDescription |
MSRMT_CYCLE_RT_DESCR_LBL |
Facility Level 1 |
facilityLevel1 |
FACILITY_LEVEL1 |
Facility Level 2 |
facilityLevel2 |
FACILITY_LEVEL2 |
Facility Level 3 |
facilityLevel3 |
FACILITY_LEVEL3 |
Life Support / Senstive Load |
lifeSupportSensitiveLoad |
D1_LS_SL_FLG |
UTC Offset |
utcOffset |
UTC_OFFSET |
Business Object Status |
boStatus |
SP_BO_STATUS_LBL |
Business Object Status Description |
boStatusDescription |
SP_BO_STATUS_DESCR_LBL |
Service Source Status |
spSourceStatus |
SP_SRC_STAT_FLG |
Service Source Status Description |
spSourceStatusDescription |
SP_SOURCE_STATUS_DESCR_LBL |
Disconnect Location |
disconnectLocation |
DISCONN_LOC_FLG |
Disconnect Location Description |
disconnectLocationDescription |
DISCON_LOC_DESCR_LBL |
Service Point Time Zone |
spTimeZone |
SP_TIME_ZONE_CD |
Service Type |
erviceType |
D1_SVC_TYPE_CD |
Service Type Description |
serviceTypeDescription |
SERVICE_TYPE_DESCR_LBL |
Disconnect for NonPay |
disconnectForNonPay |
D1_DISCONNECT_NON_PAY |
Service Point Type Category Description |
spTypeCategoryDescription |
SP_TYPE_CAT_DESCR_LBL |
Remote Disconnect |
remoteDisconnect |
D1_SGG_DISC_CFG |
Install Event ID |
installEventId |
INSTALL_EVT_ID |
Install Event External ID |
deviceInstallationExternalId |
D1_DVC_INSTALL_EXT_ID |
Meter ID |
meterId |
D1_DEVICE_ID |
Meter Name |
meterName |
D1_DEVICE_NAME |
Install Date/Time |
installDateTime |
D1_INSTALL_DTTM |
Removal Date/Time |
removalDateTime |
D1_REMOVAL_DTTM |
Installation Event BO Status |
installationBoStatus |
IE_BO_STATUS_LBL |
Installation Event BO Status Description |
installationBoStatusDescription |
IE_BO_STATUS_DESCR_LBL |
Arming Status |
armingStatus |
ARMING_REQ_FLG |
Device On/Off Status |
deviceOnOffStatus |
ONOFF_HIST_FLG |
Installation Constant |
installationConstant |
INSTALLATION_CONST |
Meter External ID |
meterExternalId |
D1_DVC_EXTERNAL_ID |
Device Type |
deviceType |
DEVICE_TYPE_CD |
Device Type Description |
deviceTypeDescription |
DEVICE_TYPE_DESCR_LBL |
Manufacturer |
manufacturer |
MANUFACTURER_CD |
Manufacturer Description |
manufacturerDescription |
MANUFACTURER_DESCR_LBL |
Model |
model |
D1_MODEL_CD |
Model Description |
modelDescription |
MODEL_DESCR_LBL |
Device Manufacture Date |
deviceManufactureDate |
D1_DEVICE_MANUFACTURE_DATE |
Dial Count |
dialCount |
D1_DIAL_COUNT |
Sub Meter |
subMeter |
SUB_METER_SW |
Net Meter |
netMeter |
NET_METER_SW |
Device Business Object Status |
deviceBoStatus |
DEVICE_BO_STATUS_LBL |
Device BO Status Description |
deviceBoStatusDescription |
DVC_BO_STATUS_DESCR_LBL |
Device Service Type |
deviceServiceType |
DEVICE_SERVICE_TYPE_LBL |
Device Service Type Description |
deviceServiceTypeDescription |
DEVICE_SERVICE_TYPE_DESCR_LBL |
Head End System |
headEndSystem |
D1_SPR_CD |
Head End System Description |
eadEndSystemDescription |
HEAD_END_SYSTEM_DESCR_LBL |
Head End Registration Status |
headEndRegistrationStatus |
HEAD_END_REGISTR_STATUS_FLG |
Device Classification |
deviceClassification |
DVC_CLASS_FLG |
Measuring Component ID |
measuringComponentId |
MEASR_COMP_ID |
External ID |
externalId |
D1_MC_EXTERNAL_ID |
Channel ID |
channelId |
CHANNEL_ID |
Number of Digits Left |
numberOfDigitsLeft |
D1_NBR_OF_DGTS_LFT |
Number of Digits Right |
numberOfDigitsRight |
D1_NBR_OF_DGTS_RGT |
Channel Multiplier |
channelMultiplier |
CHANNEL_MULTIPLIER |
Measuring Component Type |
measuringComponentType |
MEASR_COMP_TYPE_CD |
Measuring Component Type Description |
measuringComponentTypeDescription |
MC_TYPE_DESCR_LBL |
Measuring Component Class |
measuringComponentClass |
MC_CLASS_FLG |
Seconds per Interval (SPI) |
secondsPerInterval |
SEC_PER_INTRVL |
Interval/Scalar |
intervalScalar |
INTERVAL_SCALAR_FLG |
UOM |
uom |
UNIT_OF_MEASR_CD |
TOU |
tou |
TIME_OF_USE_CD |
SQI |
sqi |
SVC_QTY_IDNTFR_CD |
Allow Negative Consumption |
allowNegativeConsumption |
ALLOW_NEG_CONSUMPTION_FLG |
CIS Service Point ID |
cisSPId |
CSI_EXT_SP_ID |
D1-ExternalRepositoryIESnapsht
D1-ExternalRepositoryIESnapsht used for install event-based master data extracts, and includes the following information:
Field Name | Schema Element | Metadata Field |
---|---|---|
Service Point ID |
spId |
D1_SP_ID |
CIS Service Point ID |
cisSpId |
CIS_EXT_SP_ID |
Meter ID |
meterId |
D1_DEVICE_ID |
Device Type Code |
deviceType |
DEVICE_TYPE_CD |
Device Type Description |
deviceTypeDescription |
DESCR100 |
Device Status Code |
deviceBoStatus |
BO_STATUS_CD |
Device Status Description |
deviceBoStatusDescription |
DESCR100 |
Manufacturer Code |
manufacturer |
MANUFACTURER_CD |
Manufacturer Description |
manufacturerDescription |
DESCR100 |
Model Code |
model |
D1_MODEL_CD |
Model Description |
modelDescription |
DESCR100 |
Head-End System Code |
headEndSystem |
D1_SPR_CD |
Head-End System Description |
headEndSystemDescription |
DESCR100 |
Badge Number |
badgeNumber |
D1_BADGE_NBR |
Serial Number |
serialNumber |
D1_SERIAL_NBR |
CIS Meter ID |
cisMeterId |
CIS_EXT_DEVICE_ID |
Install Date/Time |
installDateTime |
D1_INSTALL_DTTM |
Install Date/Time with UTC Offset |
installDttmUtcOffset |
D1_INSTALL_DTTM_UTC_OFFSET |
Removal Date/Time |
removalDateTime |
D1_REMOVAL_DTTM |
Removal Date/Time with UTC Offset |
removalDttmUtdOffset |
D1_REMOVAL_DTTM_UTC_OFFSET |
C1-ExternalRepoBillingSnapshot
C1-ExternalRepoBillingSnapshot is used for the billing-based extracts, and includes the following information:
Field Name | Schema Element | Metadata Field |
---|---|---|
Billable Service Quantity |
billSQ |
BILL_SQ |
Bill Segment End Date |
endDate |
END_DT |
Consumption Days |
duration |
CONSUMPTION_DAYS |
Bill Segment Estimate Indicator |
estimateIndicator |
C1_BS_ESTIMATE_IND |
Calculated Amount |
calculatedAmount |
CALC_AMT |
Unit of Measure |
uom |
UOM_CD |
Time of Use |
tou |
TOU_CD |
SQI |
sqi |
SQI_CD |
Service Agreement ID |
saId |
SA_ID |
Service Point ID |
spId |
SP_ID |
D2-IntervalDataExtRepoSnapshot
D2-IntervalDataExtRepoSnapshot is used for interval-based consumption data extracts for Legacy DataConnect, and includes the following information:
Field Name | Schema Element | Metadata Field |
---|---|---|
CIS Service Agreement ID |
cisSAId |
CIS_EXT_SA_ID |
Service Point ID |
spId |
D1_SP_ID |
CIS Service Point ID |
cisSPId |
CIS_EXT_SP_ID |
Unit of Measure |
uom |
D1_UOM_CD |
Service Quantity Identifier |
sqi |
SVC_QTY_IDNTFR_CD |
Seconds Per Interval |
secondsPerInterval |
SECONDS_PER_INTERVAL |
Measurement Value |
measurementValue |
MSRMT_VAL |
Measurement Date |
measurementDate |
MSRMT_DATE |
Measurement Time |
measurementTime |
MSRMT_TIME |
Estimate Indicator |
estimateIndicator |
ESTIMATION_IND_FLG |
Estimate Indicator Description |
estimateIndicatorDescription |
DESCR100 |
UTC Offset |
utcOffset |
UTC_OFFSET |
D2-IntervalDataExtRepoTOUSnap
D2-IntervalDataExtRepoTOUSnap is used for interval consumption data extracts mapped to TOU periods for Legacy DataConnect, and includes the following information:
Field Name | Schema Element | Metadata Field |
---|---|---|
CIS Service Agreement ID |
cisSAId |
CIS_EXT_SA_ID |
Service Point ID |
spId |
D1_SP_ID |
CIS Service Point ID |
cisSPId |
CIS_EXT_SP_ID |
Unit of Measure |
uom |
D1_UOM_CD |
Time of Use Period |
tou |
D1_TOU_CD |
Service Quantity Identifier |
sqi |
SVC_QTY_IDNTFR_CD |
Seconds Per Interval |
secondsPerInterval |
SECONDS_PER_INTERVAL |
Measurement Value |
measurementValue |
MSRMT_VAL |
Start Date |
startDate |
START_DT |
Start Time |
startTime |
START_TM |
Start Time UTC Offset |
startUtcOffset |
UTC_OFFSET |
End Date |
endDate |
END_DT |
End Time |
endTime |
D2_END_TIME |
End UTC Offset |
endUtcOffset |
UTC_OFFSET |
D2-IntervalDataExtRepoSnpstUTC
D2-IntervalDataExtRepoSnpstUTC is used for interval-based consumption data extracts, and includes the following information:
Field Name |
Schema Element |
Metadata Field |
---|---|---|
Service Point ID |
spId |
D1_¿SP_¿ID |
Measurement Value |
measurementValue |
MSRMT_¿VAL |
Measurement Date |
measurementDate |
MSRMT_¿DATE |
Measurement Time |
measurementTime |
MSRMT_¿TIME |
Unit of Measure |
uom |
D1_¿UOM_¿CD |
Estimate Indicator |
estimateIndicator |
ESTIMATION_¿IND_¿FLG |
UTC Offset |
utcOffset |
UTC_¿OFFSET |
Register ID |
mcId |
REGISTER_ID |
CIS Service Point ID |
cisSPId |
CIS_¿EXT_¿SP_¿ID |
Device ID |
deviceId |
D1_DEVICE_ID |
Service Type |
serviceType |
D1_SVC_TYPE_CD |
Service Quantity Identifier |
sqi |
SVC_¿QTY_¿IDNTFR_¿CD |
Time of Use |
tou |
D1_TOU_CD |
D2-IntervalDataExtRepoTOUSnUTC
D2-IntervalDataExtRepoTOUSnUTC is used for interval consumption data extracts mapped to TOU periods, and includes the following information:
Field Name |
Schema Element |
Metadata Field |
---|---|---|
Service Point ID |
spId |
D1_¿SP_¿ID |
Unit of Measure |
uom |
UNIT |
Seconds Per Interval |
secondsPerInterval |
SECONDS_¿PER_¿INTERVAL |
Measurement Value |
measurementValue |
MSRMT_¿VAL |
Start Date |
startDate |
START_¿DT |
Start Time |
startTime |
START_¿TM |
Start Time UTC Offset |
startUtcOffset |
UTC_¿OFFSET |
End Date |
endDate |
END_¿DT |
End Time |
endTime |
D2_¿END_¿TIME |
End UTC Offset |
endUtcOffset |
UTC_¿OFFSET |
Register ID |
mcId |
REGISTER_ID |
CIS Service Point ID |
cisSPId |
CIS_¿EXT_¿SP_¿ID |
Device ID |
deviceId |
D1_DEVICE_ID |
Service Type |
serviceType |
D1_SVC_TYPE_CD |
Service Quantity Identifier |
sqi |
SVC_¿QTY_¿IDNTFR_¿CD |
Time of Use |
tou |
D1_TOU_CD |
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