Enron Mail

From:james.saunders@enron.com
To:rod.hayslett@enron.com
Subject:Re: FERC Data Warehouse
Cc:melissa.becker@enron.com
Bcc:melissa.becker@enron.com
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.




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.