Table: GSH_AUCTION_BID_PRODUCT

GSH_AUCTION_BID_PRODUCT

Name

GSH_AUCTION_BID_PRODUCT

Comment

Information for a single auction product contained within a bid


Primary Key Columns

Name

AUCTION_PRODUCT_TYPE

BID_ID

DELIVERY_POINT_ID

GAS_DATE

PARTICIPANT_CODE

RECEIPT_POINT_ID

SUBMISSION_TIME


Content

Name

Data Type

Mandatory

Comment

GAS_DATE

DATE

X

Single Gas Date of Submission

PARTICIPANT_CODE

VARCHAR2(20)

X

Unique Participant Code

SUBMISSION_TIME

DATE

X

Date and Time of the submission

BID_ID

NUMBER(8,0)

X

Unique Bid ID within Bid Profile

AUCTION_PRODUCT_TYPE

VARCHAR2(20)

X

The product type, for example Forward Haul, Backhaul, Compression

RECEIPT_POINT_ID

NUMBER(8,0)

X

The unique identifier of the Receipt Point as defined in the Transportation Service Point Register. This is the point where gas is injected into the pipeline

RECEIPT_POINT_NAME

VARCHAR2(255)

 

The descriptive name of the Receipt Point as defined in the Transportation Service Point Register.

RP_DWGM_REFERENCE

VARCHAR2(255)

 

The DWGM accreditation reference associated with the Receipt Point.

DELIVERY_POINT_ID

NUMBER(8,0)

X

The unique identifier of the Delivery Point as defined in the Transportation Service Point Register. This is the point where gas is withdrawn from the pipeline. Mandatory for service points registered under Part 24 of the rules.

DELIVERY_POINT_NAME

VARCHAR2(255)

 

The descriptive name of the Delivery Point as defined in the Transportation Service Point Register.

DP_DWGM_REFERENCE

VARCHAR2(255)

 

The DWGM accreditation reference associated with the Delivery Point.

SERVICE_REFERENCE

VARCHAR2(255)

 

The service reference issued by the facility operator.

LASTCHANGED

DATE

 

The date and time the report was generated.