Enron email

Algorithmic Indexing

6 Dec 2000, 17:35 UTC

Re: FERC Data Warehouse

From
James Saunders james.saunders@enron.com
To
Rod Hayslett
Cc
Melissa Becker
Bcc
Melissa Becker
Date
Wed, 6 Dec 2000 09:35:00 -0800 (PST)
I don't think we can wait. We need FERC solutions in SAP (and perhaps the 
data warehouse) relatively quickly. 
We have an "enterprise" issue localized in ETS -if that helps getting any 
action.

Fundamentally, through my recent "investigation" I have become acquainted 
with numerous significant FERC module and FERC related issues -with little 
apparent solution to date. The items are being worked...

Composite depreciation is not correct  -millions of $
SAP natural accounts do not reconcile to the FERC module -the FERC trial 
balance does NOT balance
Labor distribution true-ups are not correct for FERC purposes -costs are 
being misallocated  (this was originally deemed a show stopper)
AFUDC is not calculating consistently with pre SAP methodologies
FERC ledgers are not available
FERC "Users" were ready to test out the FERC data warehouse but that 
opportunity was nixed by the decisions below
We are unable to obtain detailed benefit information for rate purposes
Benefits have been charged out incorrectly (nearly resolved)
Anxiety issue >We have little confidence we'll be able to efficiently prepare 
timely year end FERC Form2 reports* for Enron pipelines (submission deadlines 
for which are well before any Project Sunrise timetable.)

* there is voluminous revenue/volume, financial, property and tax related 
data required for this document, all of which has to be stated in FERC format.





Rod Hayslett

12/06/2000 04:18 PM
To: Melissa Becker/Corp/Enron@ENRON
cc: James Saunders/FGT/Enron@ENRON 

Subject: Re: FERC Data Warehouse  

Do you think it better that I wait and see what comes of this, or because I 
have a singular need that I cause a small group to come togehter and focus on 
this?     The fact that there is no solution is the issue and no solution 
merely means I have to find one, since I don't have the option of saying it's 
too hard or the system can't do it.    On the other hand I'm sure I don't 
know all the answers so I'm not sure of what the right process even is.
Quoted or forwarded from earlier messages
Mark Frank@ECT
12/04/2000 02:21 PM
To: Rod Hayslett/FGT/Enron@ENRON, James Saunders/FGT/Enron@ENRON, Melissa 
Becker/Corp/Enron@ENRON, David McEllin/FGT/Enron@ENRON, Ozlem 
Mahmood/HOU/EES@EES, Sheila Howard/Corp/Enron@ENRON
cc:  

Subject: Re: FERC Data Warehouse

To all:

Hope this clarifies--

We are currently collating needs data from our interview cycle.
Preliminarily, the interviews confirm our suspicions:
 1. Cost & P/L reporting is the most widely held concern.
 2. Cash flow reporting (treasury, direct & indirect) follows closely.
 3.  There is no easy, readily available solution to FERC reporting.
 4. People have lost ad hoc query functionality with the implementation of 
SAP.

Project Sunrise's reporting charter will be to address these needs in the 
most efficient, cost effective way possible.
That could be through a data warehouse, could be through the FERC SAP module, 
could be through another avenue.
None of us has the answer to the methodology question yet (although we all 
have ideas).

I would prefer to keep the Project Sunrise team focused on the task at hand 
-- sifting through the interview information and developing a work plan.
We have followup interviews to schedule & complete, a data model to build, 
etc. Basically a lot of work on our plates.

However, FERC reporting is clearly a significant need that will be at the 
forefront of any reporting solution.
If our goal is to discuss this need in detail tomorrow, I'm all for it! I 
need the education.
If our goal is to look at progress towards a solution, we should look to 
postpone.
I take responsibility for distracting efforts in progress, but believe the 
delay worthwhile.

One final issue: Sean, the Sensecorp consultant who has been working on the 
project, is in California.
We may want to wait on his participation.

I believe we are all on the same page.
mhf
---------------------- Forwarded by Mark Frank/HOU/ECT on 12/04/2000 02:04 PM 
---------------------------


Ozlem Mahmood@EES
12/04/2000 01:16 PM
To: Mark Frank/HOU/ECT@ECT
cc:  
Subject: Re: FERC Data Warehouse

FYI:
---------------------- Forwarded by Ozlem Mahmood/HOU/EES on 12/04/2000 01:14 
PM ---------------------------


Melissa Becker@ENRON
12/04/2000 11:16 AM
To: David McEllin/FGT/Enron@ENRON
cc: Ozlem Mahmood/HOU/EES@EES, Sheila Howard/Corp/Enron@ENRON 
Subject: Re: FERC Data Warehouse  

Why wouldn't we?  ETS has a specific gap that needs to be addressed, and we 
need to find the best way to fix it.  I would just be sure not to jump to the 
DW as the solution, unless the ISC has been given ample opportunity to 
propose a solution.  Be sure to go that route, too!



David McEllin
12/01/2000 05:37 PM
To: Melissa Becker/Corp/Enron@ENRON
cc: Ozlem Mahmood/HOU/EES@EES 

Subject: Re: FERC Data Warehouse

Will we be proceeding with the Dec 5 meeting? If so, Ozlem could you get 
notice out to the original distribution list concerning time and location. I 
will be out of the office on Monday, so I would appreciate your assistance in 
coordinating the meeting logistics. Thanks.

---------------------- Forwarded by David McEllin/FGT/Enron on 12/01/2000 
05:35 PM ---------------------------


David McEllin
11/30/2000 04:56 PM
To: Melissa Becker/Corp/Enron@ENRON
cc: Rod Hayslett/FGT/Enron@ENRON, James Saunders/FGT/Enron@ENRON, Sheila 
Howard/Corp/Enron@ENRON, Mark Frank/HOU/ECT@ECT 

Subject: Re: FERC Data Warehouse  

I feel we should proceed with the Dec 5 meeting, at least to get a better 
understanding of what the data warehouse can do for us related to FERC, and 
maybe determine just how far along it currently is.  The original reason we 
were asked to meet on this issue is that it was thought that a lot of work 
had already been completed and it wouldn't take much to deliver an end 
product. The other attendees, as well as myself, need to understand what this 
can do for us as opposed to a potential solution in SAP.




Melissa Becker
11/30/2000 04:28 PM
To: Rod Hayslett/FGT/Enron@ENRON, James Saunders/FGT/Enron@ENRON
cc: Sheila Howard/Corp/Enron@ENRON, Mark Frank/HOU/ECT@ECT, David 
McEllin/FGT/Enron@ENRON 

Subject: Re: FERC Data Warehouse  

I am not sure the statement below from Ozlem is entirely accurate.  In 
addtion to Project Sunrise, I have asked Sheila Howard, who is the lead for 
the financial team in the ISC, to work with the Project Sunrise team to 
understand what your issues are and help determine a solution.  

Let me assure you that whether through the Project Sunrise or the ISC, we are 
working on your issue and it has NOT dropped off the radar screen.  As a 
matter of fact, Project Sunrise had a status meeting today, and this came up 
several times.  I think the only question is "what's the best approach for 
solving it"? 

I will leave it to Dave, as the ETS representative to Project Sunrise, along 
with Sheila, Mark, and the others listed below, to continue to work on a 
solution for the FERC problems.  Dave  - is there any reason NOT to proceed 
with the December 5 meeting under these assumptions?  I would just ask that 
Sheila be included.

Thanks!





Rod Hayslett

11/30/2000 06:18 AM
To: Melissa Becker/Corp/Enron@ENRON
cc:  

Subject: Re: FERC Data Warehouse

If there is going to be no effort to fix my problem as a result  of the 
change in the effort, I am wondering why I should support the project at all?

---------------------- Forwarded by Rod Hayslett/FGT/Enron on 11/30/2000 
06:19 AM ---------------------------


James Saunders
11/29/2000 07:54 PM
To: Bob Chandler/ET&S/Enron@ENRON, Jennifer Lev/FGT/Enron@ENRON, Debbie 
Thompson/FGT/Enron@ENRON, John Cobb/FGT/Enron@ENRON
cc: David McEllin/FGT/Enron@ENRON, Rod Hayslett/FGT/Enron@ENRON 

Subject: Re: FERC Data Warehouse

Do we have any current Form 2 or other FERC related reporting 
requirements/concerns as a result of the "redirection" below?

---------------------- Forwarded by James Saunders/FGT/Enron on 11/29/2000 
07:54 PM ---------------------------


Ozlem Mahmood@EES
11/29/2000 05:47 PM
To: David McEllin/FGT/Enron@ENRON
cc: Jennifer Lev/FGT/Enron@ENRON, Debbie Thompson/FGT/Enron@ENRON, Harry 
Walters/ET&S/Enron@ENRON, Hoyt Ivey/ET&S/Enron@ENRON, Bob 
Chandler/ET&S/Enron@ENRON, James Saunders/FGT/Enron@ENRON 

Subject: Re: FERC Data Warehouse  


Dear FERC-interested representatives,

Due to the current redirection of the data warehouse project (which is now 
part of Project Sunrise), it has been determined that it is best to postpone 
a FERC discussion/analysis until after the  collection of business 
requirements and final scoping of the project.    However, I will be 
recommending that a focus group be designated for FERC.  Thank you for your 
help and patience and I apologize for the upheaval and postponements.

Tzlem




David McEllin@ENRON
11/28/2000 04:35 PM
To: Jennifer Lev/FGT/Enron@ENRON, Debbie Thompson/FGT/Enron@ENRON, Harry 
Walters/ET&S/Enron@ENRON, Hoyt Ivey/ET&S/Enron@ENRON, Bob 
Chandler/ET&S/Enron@ENRON
cc: Ozlem Mahmood/HOU/EES@EES, James Saunders/FGT/Enron@ENRON 
Subject: FERC Data Warehouse

The review by ETS of the FERC data warehouse information will be on Tuesday 
December 5th at 10:00am, location TBA. This initial review should last approx 
one hour and your input would be greatly appreciated. I will inform you of 
the location when this is established. Please feel free to contact me if you 
have any questions.