Enron email

Algorithmic Indexing

30 Mar 2001, 02:14 UTC

Portland Database

From
Matt Smith matt.smith@enron.com
To
David Woodstrom
Date
Thu, 29 Mar 2001 18: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