Message-ID: <26334411.1075853052082.JavaMail.evans@thyme>
Date: Sun, 24 Jun 2001 17:55:00 -0700 (PDT)
From: lynn.blair@enron.com
To: michael.bodnar@enron.com, john.buchanan@enron.com, terry.kowalke@enron.com
Subject: RE: Modification to the new daily SCADA Report
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-From: Lynn Blair
X-To: Michael Bodnar <Michael Bodnar/ET&S/Enron@ENRON>, John Buchanan <John Buchanan/ET&S/Enron@ENRON>, Terry Kowalke <Terry Kowalke/ET&S/Enron@ENRON>
X-cc: 
X-bcc: 
X-Folder: \LBLAIR (Non-Privileged)\Blair, Lynn\'Sent Mail
X-Origin: Blair-L
X-FileName: LBLAIR (Non-Privileged).pst

Mike, since Terry is out this week, can you take the lead to find out
status of this report as you are checking to consistency with this report
and the automation of the storage report.  Let's discuss on Tuesday.  Thanks. Lynn
---------------------- Forwarded by Lynn Blair/ET&S/Enron on 06/24/2001 02:51 PM ---------------------------
From:	Don Powell/ENRON@enronxgate on 06/12/2001 08:52 AM
To:	Don Powell/ENRON@enronxgate, Lynn Blair/ET&S/Enron@ENRON, John Buchanan/ET&S/Enron@ENRON, Alice Johnson/ET&S/Enron@ENRON, Gary Spraggins/ET&S/Enron@ENRON, Dale Ratliff/ENRON@enronXgate, Steven January/ET&S/Enron@ENRON, Kent Miller/ET&S/Enron@ENRON, Bill Fowler/ENRON@enronXgate, Angela Sayegh/ENRON@enronXgate
cc:	Ken Powers/ENRON@enronxgate, Steve Gilbert/ENRON@enronxgate, Lisa Sawyer/ENRON@enronXgate 

Subject:	RE: Modification to the new daily SCADA Report

Here are the stored procedures with their parameters in parenthesis.  Most of them are single selects and could be incorporated into SQL in the Excel add-in if desired.  I thought stored procedures would make it easier to separate support for the add-in from support for the code.  The stored procedures are all on the server ETSADHOC, database adhoctest, under my id (dpowell).  I think we want to get the DBA's to move these into a production environment so they are protected (ie: dbo in the etsadhoc database)?

 1. NNG Storage FDD/IDD, SBA, & Swing
	FDD:	ETSMorningReportFDD (date)
	IDD:	ETSMorningReportIDD (date)
	SBA:	ETSMorningReportSBA (date)
	Swing:	above (+/-)
		ETSMorningReportSales (date)
		ETSMorningReportPurchases (date)

 2. NNG Point Specific Operational Capacity
	ETSMorningReportOperCapacity (date, poi, role)

 3. NNG Point Specific Current Month Imbalance
	ETSMorningReportSchdImbalance (date, poi)

 4. NNG Point Specific Imbalance Prior to Current Month
	No yet available