RE: gas daily curves

Got it.

We will upload those gas daily curves and the index curves from egs-prod
to sitara. We will copy yesterdays prices into today.

NOTE: I can't find any curves called NGI-SOBDR-PGE
I assume it is a spelling error because the one
we have is spelled NGI-SOBDR-PG&E

Question
how long do you want to keep the prices in the database?
because We can add a date column so that it will the prices
everyday.

-----Original Message-----
From: Wolfe, Jason
Sent: Wednesday, September 19, 2001 11:43 AM
To: Lim, Francis S.
Subject: RE: gas daily curves

Highlighted curves are significant for the west.
The Index curves are listed at the bottom.
Jason << File: CURVES.xls <<

-----Original Message-----
From: Lim, Francis S.
Sent: Wednesday, September 19, 2001 11:11 AM
To: Wolfe, Jason
Subject: gas daily curves

We are waiting.

I have not heard from you yet so I had picked out the gas dailu curves
from yesterday. Are these the curves you need? This project will take
take several man hours to finish so I need your confirmation ASAP so
that we can start working on it. Otherwise we will not be able to deliver
it to you on time.

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

<< File: gd.xls <<