FYI.  Thanks. Lynn
---------------------- Forwarded by Lynn Blair/ET&S/Enron on 06/05/2001 07:16 AM ---------------------------
From:	Don Powell/ENRON@enronxgate on 06/04/2001 06:46 PM
To:	Jennifer Lowry/ENRON@enronXgate, Alice Johnson/ET&S/Enron@ENRON
cc:	Hasan Kedwaii/ENRON@enronXgate, Lynn Blair/ET&S/Enron@ENRON 

Subject:	RE: Location of Adhoc Data

Alice, would you get with Jennifer and see if this is what we need and then let everyone know.  Call me if you need help.  Thanks.

 -----Original Message-----
From: 	Lowry, Jennifer   
Sent:	Monday, June 04, 2001 5:54 PM
To:	Johnson, Alice
Cc:	Powell, Don; Kedwaii, Hasan
Subject:	RE: Location of Adhoc Data


I put a stored procedure on etsadhoc...adhoctest.  It is called jlowry.storage_report.  It expects two parameters, 1. the gas date and 2. the service type (FDD, IDD, or SBA).

I believe the calculations are what you requested in your document.  I have not worked on the swing calculation because I'm not sure I have access to all the required data.  Also, I think you probably want the scheduled withdrawal to be a negative number so you'll get the net when you add injection and withdrawal together.  I essentially changed your net calculation to be injection - withdrawal, rather than adding the two together.  If this is wrong, let me know and I'll correct it.

Let me know if you need anything else.

Jennifer
 -----Original Message-----
From: 	Johnson, Alice  
Sent:	Friday, June 01, 2001 4:28 PM
To:	Lowry, Jennifer 
Subject:	FW: Location of Adhoc Data

Jennifer,

The report with the storage criteria is attached at the bottom of this email.

Thanks,
Alice
---------------------- Forwarded by Alice Johnson/ET&S/Enron on 06/01/2001 04:26 PM ---------------------------
From:	Hasan Kedwaii/ENRON@enronXgate on 05/29/2001 07:34 AM
To:	Alice Johnson/ET&S/Enron@ENRON
cc:	Robert Fugel/ENRON@enronXgate, Esther Dasilva/ET&S/Enron@ENRON 

Subject:	FW: Location of Adhoc Data

Alice,
the information you need from TMS can be found in the etsadhoc database of ETSADHOC server (ETSADHOC.ets.enron.com; ip address: 172.30.10.144).
Depending on whether you need nomination or scheduled information, you will need to query against either the Nom or Sched table.

Let me know if you need more information

Thanx

 -----Original Message-----
From: 	Fugel, Robert  
Sent:	Tuesday, May 29, 2001 6:28 AM
To:	Kedwaii, Hasan
Subject:	FW: Location of Adhoc Data

I think this is you area of expertise.

 -----Original Message-----
From: 	Johnson, Alice  
Sent:	Friday, May 25, 2001 5:11 PM
To:	Fugel, Robert
Cc:	Dasilva, Esther
Subject:	Location of Adhoc Data

I need to identify where certain storage and imbalance information reside on the  adhoc server. The attached document lists the data that is needed and where the data is in TMS. The next step is to identify which database stores the required information. 

Esther Dasilva has done some research and  found that part of this information is on the NNG adhoc database. We need your assistance to complete the mapping of this data to the adhoc tables. Can you meet with me and Esther on Tuesday to direct us to the correct path on mapping this data (see attached)?

Thanks,
Alice


					 << File: BO Critical Points.doc >>