Message-ID: <27384296.1075858508947.JavaMail.evans@thyme>
Date: Thu, 19 Apr 2001 22:21:00 -0700 (PDT)
From: jim.reyes@enron.com
To: p..o'neil@enron.com, chris.stokley@enron.com
Subject: Status of Access Settlement Analysis Project
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-From: Reyes, Jim </O=ENRON/OU=NA/CN=RECIPIENTS/CN=JREYES4>
X-To: O'Neil, Murray P. </O=ENRON/OU=NA/CN=RECIPIENTS/CN=MONEIL>, Stokley, Chris </O=ENRON/OU=NA/CN=RECIPIENTS/CN=MSTOKLE>
X-cc: 
X-bcc: 
X-Folder: \Stokley, Chris (Non-Privileged)\Chris Stokley\Volume Mang.
X-Origin: Stokley-C
X-FileName: Stokley, Chris (Non-Privileged).pst

Murray and Chris,

Here is an update on what has been completed and what needs to be completed:

First, I moved the Excel "mock up" to P:\VolumeManagement\Settlement Stats

I added Murray's corrections and re-constructed the Mock Report.

In the same directory, you will find an Access Database, "Settlement Analysis DB"  I created a table and a report and a form to create a report.

There is a hard copy of the report at my desk.  

The various connections need to established, and I took a first shot at where the information is stored on the Oracle database.  The reports that I believe will populate the table are FSP_SETLMT_HISTORY_HDRS & FSP_SETLMT_HIST_DTL_QTY .  I have taken a shot at what fields I believe these come from relate to the table.

I need help in populating the tables and then some coaching on how to create a "program" feel to create a report based on selection criteria.

We can meet tomorrow to review where my work is.

Jim