Table: GSH_SHIPPER_CAP_XFR_NOTICE

GSH_SHIPPER_CAP_XFR_NOTICE

Name

GSH_SHIPPER_CAP_XFR_NOTICE

Comment

Provides the status of a trading participantís capacity transfer related to one or more capacity trades. This notice is issued each time a capacity transfer record has a status change because of capacity transfer in the facility operator system or AEMO system. For non-STTM and non-DWGM capacity products, the status is reported as received from the facility operator. For STTM and DWGM capacity products, the status is reported once the capacity transfer has been completed in the relevant market system (STTM or DWGM).


Primary Key Columns

Name

CAPACITY_TRANSFER_ID


Content

Name

Data Type

Mandatory

Comment

CAPACITY_TRANSFER_ID

VARCHAR2(20)

X

The unique AEMO defined Capacity Transfer transaction identifier.

GAS_DATE

DATE

 

The gas date for the capacity change. Disregard the time component as this is not applicable.

PARTICIPANT_CODE

VARCHAR2(20)

 

The participant code used in the ETS.

PARTICIPANT_NAME

VARCHAR2(80)

 

The descriptive name of the participant.

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.

SERVICE_REFERENCE

VARCHAR2(255)

 

The service reference issued by the facility operator.

STTM_CONTRACT_REFERENCE

VARCHAR2(255)

 

The STTM registered facility service identifier (CRN) associated with the service reference.

DWGM_REFERENCE

VARCHAR2(255)

 

The DWGM accreditation reference associated with the transfer.

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.

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.

DELIVERY_POINT_NAME

VARCHAR2(255)

 

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

RECEIPT_ZONE_ID

NUMBER(8,0)

 

The unique identifier of the Receipt Zone as defined in the Transportation Service Point Register.

RECEIPT_ZONE_NAME

VARCHAR2(255)

 

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

DELIVERY_ZONE_ID

NUMBER(8,0)

 

The unique identifier of the Delivery Zone as defined in the Transportation Service Point Register.

DELIVERY_ZONE_NAME

VARCHAR2(255)

 

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

STATUS

VARCHAR2(20)

 

The status of the capacity transfer, for example Transferred, Partial, Pending, Rejected or Cancelled.

SYSTEM

VARCHAR2(20)

 

The system that has processed the capacity transfer, for example Facility operator, AEMO, AEMO STTM or AEMO DWGM.

REASON

VARCHAR2(40)

 

The reason for a rejected or cancelled capacity transfer, for example Buyer delivery contract, Seller delivery fault, system issue or matching record not found.

TRANSACTION_COMPLETED_FLAG

VARCHAR2(3)

 

Flag to indicate whether the capacity transfer process is completed, for example yes or no.

OVERALL_QUANTITY_CHANGE

NUMBER(10,0)

 

The overall capacity quantity adjustment (GJ/day) applied to the relevant contracts for this transfer date and gas date. This is a signed value (+/-).

LASTCHANGED

DATE

 

The date and time the report was generated.