Guides & Tools
Though electronic data interchange (EDI) format is preferred, comma separated value (CSV or CMEP) is acceptable for billing and DASR data exchange.
SCE has provided Excel tools to assist with CMEP format exchange. Please refer to the ESP Handbook for complete data exchange protocol. SCE guides are UIG compliant and conform to ANSI X12 standards. Visit the UIG Web site to obtain mapping guides for each EDI transaction set.
Guidelines
Billing Data Exchange (PDFs)
- EDI Transaction Set Guide 810 Version 3070 Implementation Guide (PDF)
- EDI Transaction Set Guide 810 Version 4010 Implementation Guide (PDF)
DASR Processing
- DASR Business Process (v2.0) & EDI Transaction Set 814 Version 4010 Implementation Guide (PDF)
- CMEP (CSV) DASR Asst for WinXP*
- CMEP (CSV) DASR Asst for Win95/NT Instructions* (PDF)
- CMEP (CSV) DASR Asst for Win95/NT* (ZIP)
Note: You will need the WinZip application to unzip and access this EXE file. You can obtain WinZip for free.
Meter Usage Data
Beginning April 1, 2000, in accordance with the California Public Utilities Commission Decision (D.) 98-12-080 mandating the migration of meter usage data to Electronic Data Interchange (EDI), SCE will continue to provide monthly usage data for interval meters and reads/usage data for non-interval meters in EDI format. As of May 15, 2000, SCE will begin providing historical usage data to Electric Service Providers (ESPs) in EDI format.
Account Maintenance
Monthly Meter Data
Southern California Edison follows the California Transaction Set 867 mapping guide (PDF) in its entirety except where indicated.
For monthly usage data, the separate CMEP and EDI files can be identified by filename. CMEP files will continue to be named "FILENAME.CMEP" EDI formatted files will be named "FILENAME.EDI". If you currently retrieve your files by logging onto the MDMA server using a browser, you can choose to retrieve the CMEP file, the EDI file, or both. If you are currently using the "Getfilenames" CGI script, you can continue to do so. However, the scripts will continue to retrieve the CMEP formatted filenames only. You can retrieve EDI filenames with this script by changing "Getfilenames" to "GetEDIfilenames."
Historical Meter Data
The historical data will be posted to SCE's MDMA server in compliance with the EDI 867 (v.4010) UIG transaction set. This data will be posted at acceptance, and again at completion, of the Direct Access Service Request (DASR). Files containing historical data will end with a ".hst" suffix.
Please note: SCE no longer provides historical data according to California Metering Exchange Protocol (CMEP).
*Note: Software offered above will only work on PC's running Windows 95 or the Windows NT Operating System. Win95/NT users may have to hold down the SHIFT key before clicking on the link to download and save the files to their computers. Other PC and Macintosh users should use the DASR Assistant.xls file and instructions.
Get Adobe® Reader
Print