Enron email

Algorithmic Indexing

29 Mar 2001, 15:14 UTC

Portland Database

From
Matt Smith matt.smith@enron.com
To
David Woodstrom
Date
Thu, 29 Mar 2001 07:14:00 -0800 (PST)
David,

Here's the information for the Portland database:

Machine name:  napdx-sql1
user id:  gasintranet
password:  fundamentals

The Access database I created is located at:  O:\\fundy_ops\west 
desk\generation database\power_link_database.mdb

The qry_curtailments is the query i'm currently using (although it only has 
fields for today and yesterday, and i think i need more).  The tables for the 
query are dbo_LkpOUT_PlantCharacteristics and dbo_LkpOUT_PlantOutage.

In general, I think I need two tables.  One needs to show each plant and the 
other needs to summarize the outages by region and fuel type (both in the 
Plant table).  I don't really have a query that prepares the data for the 
summary table.  the other two queries in the Access database are a start.  
The attached Excel file has two sheets with what I would ideally like the 
report to look like.  It might be good to group the first table by region and 
then fuel type as well.  When you have a chance to look this stuff over, I'd 
be happy to discuss it further.  Thanks.

Mat