Extract Flat File Formats
This section outlines the format of output flat files created by master and billing data extracts.
Data Areas:
• C1-CustomerDataSnapshot
• C1-ExternalRepoSABasedSnapshot
• C1-ExternalRepoSPBasedSnapshot
• C1-ExternalRepoSPMtrHtSnapshot
• C1-ExternalRepoBillingSnapshot
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
email
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
Top of Page
C1-ExternalRepoSABasedSnapshot
C1-ExternalRepoSABasedSnapshot is used for the SA-based 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
email
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
Top of Page
C1-ExternalRepoSPBasedSnapshot
C1-ExternalRepoSPBasedSnapshot is used for the SP-based extracts and includes the following:
For DataConnect v1+ please refer to data area C1-SPMeterDataSnapshot in the application for the layout/schema.
Field Name
Schema Element
Metadata Field
Service Point Id
spId
SP_​ID
Premise Id
premiseId
PREM_​ID
Address Line 1
addressLine1
ADDRESS1
City
city
CITY
State
state
STATE
Postal
postal
POSTAL
County
county
COUNTY
Country
country
COUNTRY
Premise Type
premiseType
PREM_​TYPE_​CD
Premise Type Description
premiseTypeDescription
DESCR
CIS Division
cisDivision
CIS_​DIVISION
CIS Division Description
cisDivisionDescription
DESCR
Life Support Sensitive Load
lifeSupportSensitiveLoad
LS_​SL_​FLG
Life Support Sensitive Load Description
lifeSupportSensitiveLoadDescription
LS_​SL_​DESCR
Trend Area
trendArea
TREND_​AREA_​CD
Trend Area Description
trendAreaDescription
DESCR
In City Limit
inCityLimit
IN_​CITY_​LIMIT
Address Line 2
addressLine2
ADDRESS2
Address Line 3
addressLine3
ADDRESS3
Number 1
number1
NUM1
Number 2
number2
NUM2
Landlord Id
landlord
LL_​ID
Landlord Description
landlordDescription
DESCR
SP Status
spStatus
SP_​STATUS_​FLG
SP Status Description
spStatusDescription
DESCR
Service Cycle
serviceCycle
MR_​CYC_​CD
Service Cycle Description
serviceCycleDescription
DESCR
Service Route
serviceRoute
MR_​RTE_​CD
Service Route Description
serviceRouteDescription
DESCR
Service Route Sequence
serviceRouteSequence
MR_​CYC_​RTE_​SEQ
Meter Location
location
MTR_​LOC_​CD
Meter Location Description
locationDescription
DESCR
Latitude
latitude
C1_​LATITUDE
Longitude
longitude
C1_​LONGITUDE
Facility Level 1
facilityLevel1
FAC_​LVL_​1_​CD
Facility Level 2
facilityLevel2
FAC_​LVL_​2_​CD
Facility Level 3
facilityLevel3
FAC_​LVL_​3_​CD
SP Disconnect Location
disconnectLocation
DISCON_​LOC_​CD
SP Disconnect Location Description
disconnectLocationDescription
DESCR
SP Source Status
spSourceStatus
SP_​SRC_​STATUS_​FLG
SP Source Status Description
spSourceStatusDescription
DESCR
Active Service Agreement ID
activeSaid
SA_​ID
Has No Active SA
noActiveSA
HAS_​NO_​ACTIVE_​SA_​SW
SA As Of Date/Time
saAsOfDttm
SA_​AS_​OF_​DTTM
Top of Page
C1-ExternalRepoSPMtrHtSnapshot
C1-ExternalRepoSPMtrHtSnapshot is used for the SP/Meter History based extracts and includes the following:
For DataConnect v1+ please refer to data area C1-SPMeterDataSnapshot in the application for the layout/schema.
Field Name
Schema Element
Metadata Field
Service Point Id
spId
SP_​ID
Meter Type
meterType
MTR_​TYPE_​CD
Meter Type Description
meterTypeDescription
DESCR
Meter Status
meterStatus
MTR_​STATUS_​FLG
Meter Status Description
meterStatusDescription
DESCR
Register Constant
registerMultiplier
REG_​CONST
Installation Constant
installationMultiplier
INSTALL_​CONST
Meter's Number of Dials
numberOfDials
C1_​NBR_​OF_​DIALS
Manufacturer
manufacturer
MFG_​CD
Manufacturer Description
manufacturerDescription
DESCR
Model
model
MODEL_​CD
Model Description
modelDescription
DESCR
Badge Number
badgeNumber
BADGE_​NBR
Serial Number
serialNumber
SERIAL_​NBR
Meter Id
meterId
MTR_​ID
Installation Date/Time
installDateTime
INSTALL_​DTTM
Removal Date/Time
removalDateTime
REMOVAL_​DTTM
SP Meter On/Off Status
meterOnOffStatus
MTR_​ON_​OFF_​FLG
Top of Page
C1-ExternalRepoBillingSnapshot
C1-ExternalRepoBillingSnapshot is used for the Billing-based extracts and includes the following:
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
Top of Page
Parent topic 
Defining DataConnect Options