Table: GSH_AUCTION_RESULTS

GSH_AUCTION_RESULTS

Name

GSH_AUCTION_RESULTS

Comment

Specifies the details of the capacity won at auction


Primary Key Columns

Name

AUCTION_TRANSACTION_ID


Content

Name

Data Type

Mandatory

Comment

AUCTION_TRANSACTION_ID

NUMBER(12,0)

X

The unique identifier of the auction transaction.

AUCTION_DATE

DATE

 

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

FACILITY_ID

NUMBER(8,0)

 

The unique facility identifier as defined in the Transportation Facility Register.

FACILITY_NAME

VARCHAR2(100)

 

The descriptive name of the facility as defined in the Transportation Facility Register.

PARTICIPANT_ID

VARCHAR2(20)

 

The unique AEMO defined GSH Participant identifier.

PARTICIPANT_CODE

VARCHAR2(20)

 

The unique identifier of the participant

PARTICIPANT_NAME

VARCHAR2(80)

 

The descriptive name of the participant.

SERVICE_REFERENCE

VARCHAR2(255)

 

The service reference issued by the facility operator.

RECEIPT_POINT_ID

NUMBER(8,0)

 

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)

 

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.

AUCTION_QUANTITY_WON

NUMBER(8,0)

 

The capacity quantity won at auction (GJ/day) by the participant.

GAS_DATE

DATE

 

The gas date for which capacity is assigned to the shipper, in ISO 8601 datetime format (yyyy-mm-ddThh:mm:ss).

PRODUCT_PRICE

NUMBER(18,8)

 

The price of the auction product won at auction ($/GJ) by the participant.

VERSION_DATETIME

DATE

 

The date and time that the auction was run.

LASTCHANGED

DATE

 

The date and time the report was generated.