Enron email

Algorithmic Indexing

3 Apr 2001, 14:28 UTC

FW: Column Names for Historical Files

From
Matt Smith matt.smith@enron.com
To
Angela Hylton
Date
Tue, 3 Apr 2001 07:28:00 -0700 (PDT)
Angela,

This file contains the historicals for Socal in the specified format.  Can 
you please dump them into the database.  Thanks.

Mat
Quoted or forwarded from earlier messages
---------------------- Forwarded by Matt Smith/NA/Enron on 04/03/2001 02:25 
PM ---------------------------
   
	Enron North America Corp.
	
	From:  Tara Piazze                           04/03/2001 01:23 PM
	

To: Matt Smith/NA/Enron@ENRON
cc:  

Subject: FW: Column Names for Historical Files

Here are the headers:

1.  PIPELINE_ID
2.  EFFECTIVE_DTM
3.  DATA_REFERENCE_NUM
4.  FLOW_TYPE_CD
5.  MAXIMUM_CAPACITY_QTY
6.  UTILIZED_CAPACITY_QTY
7.  AVAILABLE_CAPACITY_QTY
8.  PIPELINE_CYCLE_ID

These are the column headings needed for the historical data Excel files 
(they do not have to be in any particular order, but initially a template 
should be created, and then used throughout).  This format makes it a simple 
process to load this information into the database.

Thanks for all of your hard work!!

Chris