Table: GSH_AUCTION_QUANTITIES

GSH_AUCTION_QUANTITIES

Name

GSH_AUCTION_QUANTITIES

Comment

Auction limit quantities for each product component available for the day ahead auction


Primary Key Columns

Name

AUCTION_DATE

FACILITY_ID

GAS_DATE

LIMIT_ID

LIMIT_TYPE


Content

Name

Data Type

Mandatory

Comment

AUCTION_DATE

DATE

X

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

GAS_DATE

DATE

X

The gas date that the auction quantities and transitional rights 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)

X

The type of auction limit

LIMIT_QUANTITY

NUMBER(10,0)

 

The available auction quantity of the limit in GJ.

TRANSITIONAL_RIGHTS_QUANTITY

NUMBER(10,0)

 

The quantity of nominations against grandfathered rights in GJ, for the previous gas day.

OPERATIONAL_OVERRIDE

VARCHAR2(3)

 

Flag to indicate whether the facility operator has applied an operational override to the limit quantity, for example Yes or No.

VERSION_DATETIME

DATE

 

The date and time that the auction was run.

LASTCHANGED

DATE

 

The date and time the report was generated.