Table: GSH_AUCTION_PRICE_VOLUME

GSH_AUCTION_PRICE_VOLUME

Name

GSH_AUCTION_PRICE_VOLUME

Comment

The cleared quantity, cleared price and price sensitivity for each auction product component following each auction run


Primary Key Columns

Name

AUCTION_DATE

FACILITY_ID

GAS_DATE

LIMIT_ID


Content

Name

Data Type

Mandatory

Comment

AUCTION_DATE

DATE

X

The date of the auction run. Disregard the time component as this is not applicable.

GAS_DATE

DATE

X

The gas date that the auction quantities and prices are valid for. Disregard the time component as this is not applicable.

FACILITY_ID

NUMBER(8,0)

X

The unique identifier of the facility.

FACILITY_NAME

VARCHAR2(100)

 

The descriptive name of the facility.

LIMIT_ID

NUMBER(8,0)

X

The unique identifier of the auction limit.

LIMIT_NAME

VARCHAR2(100)

 

The descriptive name of the auction limit.

LIMIT_TYPE

VARCHAR2(100)

 

The type of auction limit

CLEARED_QUANTITY

NUMBER(12,4)

 

The capacity quantity cleared at auction (GJ/day).

CLEARED_PRICE

NUMBER(12,4)

 

The cleared auction price ($/GJ).

HIGH_PRICE_SENSITIVITY

NUMBER(12,4)

 

The high price sensitivity factor applied to the price.

LOW_PRICE_SENSITIVITY

NUMBER(12,4)

 

The low price sensitivity factor applied to the price.

LASTCHANGED

DATE

 

The date and time the report was generated.