Message-ID: <9842085.1075840444830.JavaMail.evans@thyme>
Date: Tue, 23 Apr 2002 09:42:00 -0700 (PDT)
From: david.miller@enron.com
Subject: Re: Antwort: SQL Database
Cc: hollis.kimbrough@enron.com, robert.grant@enron.com, jeff.marecic@enron.com, 
	mark.fisher@enron.com
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Bcc: hollis.kimbrough@enron.com, robert.grant@enron.com, jeff.marecic@enron.com, 
	mark.fisher@enron.com
X-From: David Miller
X-To: Clemens W"ste
X-cc: Hollis Kimbrough, Robert Grant, Jeff Marecic, Mark Fisher
X-bcc: 
X-Folder: \mark fischer 7-12-02\Notes Folders\All documents
X-Origin: FISCHER-M
X-FileName: mark fischer 7-12-02 LNotes.nsf

Attached pleas find the field definitions. I don't know how helpfull this 
will be because it does not map from the original VISUPRO fields. It does 
define the added fields, however.








Clemens W"ste@TWTDE
04/23/2002 06:58 AM
To: David Miller/EWC/Enron@ENRON
cc: Hollis Kimbrough/EWC/Enron@ENRON, Robert Grant/EWC/Enron@Enron, Jeff 
Marecic/EWC/Enron@Enron 

Subject: Antwort: SQL Database  

Hallo David,

in our actual development  I suppose I need only four tables of the database:

VISU_ERRDEV,
VISU_STATDATA,
VISU_MINANAMAIN,
VISU_MINANAEXT


The fields in the tables in VisuPro and in the SQL-Server are not the same.
Some fields are not described.
I really need an assignment from the VisuPro tables to the new tables.

As example I have written some comments / questions to the following table 
structures.
(The list is not complet, it is a subset)


VISU_STATDAT:

SITE_ID varchar   //  Source ?
ID  numeric   //  written by me, or automatically 
DTTM  datetime  
PLANT_NDX numeric   
TIMEOFFSET numeric   
KW_HRS numeric   // I suppose PROD field
CON  numeric   
OTT  numeric   
SOTT  numeric   
DTT  numeric   
LOTT  numeric   
WOTT  numeric   
ESTT  numeric   
MTT  numeric   
RTT  numeric   
PRODULM numeric   
CONULM numeric   
OTULM  numeric   
SOTULM numeric   
DTULM  numeric   
LOTULM numeric   
WOTULM numeric   
ESTULM numeric   
MTULM numeric   
RTULM  numeric   

VISU_MINANAMAIN:

SITE_ID   varchar  // Source ?
ID    numeric  // written by me or automatically ?
DTTM    datetime 
TRBN_ROW_OTM  varchar  // what's this, what is to do with this field
PLANT_NDX   numeric  
KW    numeric  // what's this, what is to do with this field
COS_PHI   numeric 
VOLT_PHASE_A  numeric 
VOLT_PHASE_B  numeric 
VOLT_PHASE_C  numeric 
CURRENT_PHASE_A  numeric 
CURRENT_PHASE_B  numeric 
CURRENT_PHASE_C  numeric 
GEN_RPM   numeric 
ROTOR_RPM   numeric 
ACTUAL_ANGLE_BLADE_1 numeric 
WIND_SPEED   numeric 
NACELLE_POSITION  numeric 
TRAN_OIL_PRSS  numeric 
ACTUAL_ANGLE_BLADE_2 numeric 
ACTUAL_ANGLE_BLADE_3 numeric 
SET_ANGLE_BLADE_1 numeric 
SET_ANGLE_COS_PH I numeric 
OPERATING_STATE  numeric 
WIND_DEVIATION  numeric 
GEN_1_TEMP   numeric 
GEN_2_TEMP   numeric 
BEARING_A_TEMP  numeric 
BEARING_B_TEMP  numeric 
TRAN_TEMP   numeric 
AMBIENT_TEMP  numeric 
TRAN_BEARING_A_TEMP numeric 
TRAN_BEARING_B_TEMP numeric 
TRAN_RETURN_TEMP numeric 
WIND_DEVIATION_ONE_SEC numeric 
APPARENT_KW  numeric  // what's this, what is to do with this field
ERROR_NUMBER  numeric  // what's this, what is to do with this field
CRE_USERID   varchar  // what's this, what is to do with this field
CRE_DATE   datetime  // what's this, what is to do with this field
MDFD_USERID  varchar  // what's this, what is to do with this field
MDFD_DATE   datetime // what's this, what is to do with this field
DEL_FLAG   varchar  // what's this, what is to do with this field



Best regards,


Clemens W"ste

ENRON Wind