Enron email

Algorithmic Indexing

4 Apr 2001, 00:28 UTC

FW: Column Names for Historical Files

From
Matt Smith matt.smith@enron.com
To
Angela Hylton
Date
Tue, 3 Apr 2001 17: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