Message-ID: <12034922.1075852550902.JavaMail.evans@thyme>
Date: Wed, 26 Sep 2001 09:38:58 -0700 (PDT)
From: s..lim@enron.com
To: jason.wolfe@enron.com
Subject: Index curves
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-From: Lim, Francis S. </O=ENRON/OU=NA/CN=RECIPIENTS/CN=FLIM>
X-To: Wolfe, Jason </O=ENRON/OU=NA/CN=RECIPIENTS/CN=Jwolfe>
X-cc: 
X-bcc: 
X-Folder: \JWOLFE (Non-Privileged)\09-saved
X-Origin: Wolfe-J
X-FileName: JWOLFE (Non-Privileged).pst

Jason,

	The Gas Daily Curves are loaded into the system everyday at 6AM
	or something when they have problems, the curves are loaded at
	around 11AM. I can get these curves as soon as they get it.
	However, Index curves are loaded by GGREENA, CFRANK2, and CRABON
	at around 3PM or 4PM. I will not be able to get these curves.
	I can get Yesterdays Index curves.


select effective_dt,curve_cd, book_type_cd, curve_type_cd, ref_period_dt, curve_amt
 from egs_curves
where effective_dt = trunc(sysdate)
and curve_cd like 'GD%'
and book_type_cd = 'D'
and curve_type_cd = 'SP'

select effective_dt,curve_cd, book_type_cd, curve_type_cd, ref_period_dt, curve_amt
 from egs_curves
select * from egs_curve_def
where effective_dt = trunc(sysdate-1)
and book_type_cd = 'I'
and curve_type_cd = 'PR'
and curve_cd in (
'NGI-PGE/CG',
'NGI-SOCAL',
'IF-ELPO/SJ',
'IF-ELPO/PERMIAN',
'IF-WAHA-TX',
'NGI-MALIN',
'NGI-PGE/TOPOCK',
'NGI-SOBDR-SOCAL',
'NGI-SOBDR-PG&E',
'IF-NWPL_ROCKY_M',
'IF-NTHWST/CANBR'
)