Table: GSH_TRADES_STAGING

GSH_TRADES_STAGING

Name

GSH_TRADES_STAGING

Comment

Provides trading participants a confirmation whenever an EFP trade is submitted to AEMO


Primary Key Columns

Name

RECORD_ID


Content

Name

Data Type

Mandatory

Comment

RECORD_ID

VARCHAR2(20)

X

The unique identifier of the record

MARKET_ID

VARCHAR2(20)

 

The unique Market ID

PARTICIPANT_ID

VARCHAR2(20)

 

The unique identifier of the participant

GAS_FUTURE_ID

VARCHAR2(20)

 

The EFP Trade ID for matching trades

PRODUCT_GROUP_CODE

VARCHAR2(20)

 

AEMO uses a default value only: GAS-WAL. Data submitted by participants is not stored

PRODUCT_TYPE_CODE

VARCHAR2(20)

 

AEMO uses a default value only: NG Months. Data submitted by participants is not stored

DELIVERY_POINT

VARCHAR2(40)

 

AEMO uses a default value only: WAL HP Trade Point. Data submitted by participants is not stored

START_DATE

DATE

 

The gas start day for the EFP trade period

END_DATE

DATE

 

The gas end day for the EFP trade period

TRADE_TYPE

VARCHAR2(20)

 

Buy or Sell

VOLUME

NUMBER(18,8)

 

Trade quantities measured in GJ for each Gas Day in the Delivery Period

PRICE

NUMBER(18,8)

 

Trade price

STATUS

VARCHAR2(20)

 

Submission Status: PENDING, FAIL, MATCH, OVERRIDE

VALIDATION_MSG

VARCHAR2(255)

 

Submission validation message

SUBMITTED_TIME

DATE

 

Data submission time

LASTCHANGED

DATE

 

The date and time the report is generated