Enron email

Algorithmic Indexing

26 Sep 2001, 16:38 UTC

Index curves

From
Francis S. Lim s..lim@enron.com
To
Jason Wolfe
Date
Wed, 26 Sep 2001 09:38:58 -0700 (PDT)
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'
)