Table: GSH_BENCHMARK_PRICE

GSH_BENCHMARK_PRICE

Name

GSH_BENCHMARK_PRICE

Comment

The report contains the benchmark prices for the day ahead (non-firm price) PLUS the last two years of daily benchmark prices (firm price)


Primary Key Columns

Name

GAS_DATE

PRODUCT_LOCATION

PRODUCT_TYPE


Content

Name

Data Type

Mandatory

Comment

GAS_DATE

DATE

X

The gas date that the Wallumbilla benchmark price applies to

PRODUCT_LOCATION

VARCHAR2(80)

X

The product location that the benchmark price applies to. Can be one of the following: WALLUMBILLA, RBP, SWQP, QGP.

PRODUCT_TYPE

VARCHAR2(80)

X

The type of the product that the Wallumbilla benchmark price is calculated for

BENCHMARK_PRICE

NUMBER(18,8)

 

The calculated Wallumbilla benchmark price for the specified product type for the specified gas date

IS_FIRM

VARCHAR2(1)

 

Flag to determine if the Wallumbilla benchmark price is firm or not. Can be either: Y or N

LASTCHANGED

DATE

 

The date and time the report was generated