4 Sep 2001, 16:30 UTC
CSC Power Data Extract - Summary
- From
- Joshua P Galvan jgalvan@kpmg.com
- Cc
- leung@enron.com, Annie Leung, easton@enron.com, measton@kpmg.com, Shona Wilson, Wilson, Randy D" @ENRON
- Bcc
- leung@enron.com, Annie Leung, easton@enron.com, measton@kpmg.com, Shona Wilson, Wilson, Randy D" @ENRON
- Date
- Tue, 4 Sep 2001 09:30:49 -0700 (PDT)
Murray/Chris - Attached is an Excel spreadsheet with the breakdown of the CSC-extracted power data. You will find that the majority (~70%) of the contracts are PG&E or Southern California Edison Co. Additionally, we noted that 144 of the deals have repeats, with varying numbers of repeats by each account, and resulting in 305 records with non-distinct account numbers. These numbers are listed in the last four pages of the report. We have not determined the reason some of the account numbers are repeated. The data extracted from CSC includes the following fields: ENTITY (LoadStar, EESI, etc.) POWERLINE_CUSTOMER_NAME ENRON_ACCT_NUMBER POWERLINE_DEAL_NAME CUSTOMER_TYPE (Residential, Commercial) OPCO_CODE (Operating Company Code?) PES_INVOICE_DATE SERVICE_PERIOD_START SERVICE_PERIOD_STOP TOTAL_CHARGES TOTAL_USAGE UOM (?) FLAG (?) SERVICE_CODE (Status) We are in the process of identifying the main contact at CSC to describe the data to us, as some of the fields (e.g., those with ?'s above) contain values that we are not familiar with or that exhibit some non-clarity. For example, in the Status section of the summary report, you will notice some "DE-ACTIVE", "CANCELLED", and "CLOSED" types, which seem all to be the same or quite similar in nature. We want to make sure that we understand these values and where they come from in order to work with the data. Please review my report, and let me know if you have any questions. As I continue to work with the data, I will be able to speak to these. Thanks. <<Enron-CSCPwrDataExtractSumm-Sep2001-IRM.xls>>
Quoted or forwarded from earlier messages
> kpmg LLP Information Risk Management Joshua P. Galv?n Senior Associate 700 Louisiana, Ste. 3200 Houston, Texas 77002 713/319-2082 (wrk) 713/256-8499 (mob) jgalvan@kpmg.com ***************************************************************************** The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this email are subject to the terms and conditions expressed in the governing KPMG client engagement letter. *****************************************************************************