Table: GSH_REVISED_AUCT_QUANTITIES

GSH_REVISED_AUCT_QUANTITIES

Name

GSH_REVISED_AUCT_QUANTITIES

Comment

The report lists the following items for each facility and service type:initial cleared quantity as determined by the Auction Solver;where there has been a curtailment of the initial cleared quantity, the revised auction quantity which must be the aggregate minimum quantity made available to auction participants on the gas day; final aggregated scheduled nominations.


Primary Key Columns

Name

AUCTION_DATE

FACILITY_ID

GAS_DATE

SERVICE_TYPE


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 effective gas date of the capacity won at auction 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.

SERVICE_TYPE

VARCHAR2(20)

X

The type of service, for example Forward Haul, Backhaul or Compression.

AGG_CLEARED_QUANTITY

NUMBER(10,0)

 

The aggregated initial cleared capacity quantity as determined by the auction (GJ/day).

AGG_REVISED_QUANTITY

NUMBER(10,0)

 

The aggregated revised auction capacity quantity (GJ/day).

LASTCHANGED

DATE

 

The date and time the report was generated.