Table: GSH_CONTRACT_REFERENCES

GSH_CONTRACT_REFERENCES

Name

GSH_CONTRACT_REFERENCES

Comment

This report is available to participants as an audit trail of the entries in the Contract References markets portal application.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

BUY_SELL_POSITION

FROM_GAS_DATE

PARTICIPANT_CODE

PRODUCT_NAME

STEP_NUMBER

TO_GAS_DATE

VERSION_DATETIME


Content

Name

Data Type

Mandatory

Comment

PARTICIPANT_CODE

VARCHAR2(20)

X

The participant code used in the ETS.

PRODUCT_NAME

VARCHAR2(80)

X

The capacity product name.

BUY_SELL_POSITION

VARCHAR2(4)

X

Specifies the position that the contract reference must be used for, for example Buy, Sell or Both.

FROM_GAS_DATE

DATE

X

The first gas date that the contract reference takes effect from. Disregard the time component as this is not applicable.

TO_GAS_DATE

DATE

X

The last gas date that the contract reference takes effect until. Disregard the time component as this is not applicable.

STEP_NUMBER

NUMBER(6,0)

X

The step number for the corresponding capacity quantity.

SERVICE_REFERENCE

VARCHAR2(255)

 

The service reference issued by the facility operator.

SERVICE_REFERENCE_STATUS

VARCHAR2(20)

 

The status of the service reference, for example Valid, Missing or Expired.

STTM_CONTRACT_REFERENCE

VARCHAR2(255)

 

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

STTM_CONTRACT_REFERENCE_STATUS

VARCHAR2(20)

 

The status of the STTM contract reference, for example Valid, Missing or Expired.

DWGM_REFERENCE

VARCHAR2(255)

 

The DWGM accreditation reference associated with the transfer.

DWGM_REFERENCE_STATUS

VARCHAR2(20)

 

The status of the DWGM accreditation reference, for example Valid, Missing or Expired.

STEP_QUANTITY

NUMBER(10,0)

 

The step quantity to applied to the contract reference (GJ/day).

VERSION_DATETIME

DATE

X

The date and time the preference was updated.

LAST_UPDATED

DATE

 

The date and time the preference was updated.

LAST_UPDATED_BY

VARCHAR2(20)

 

The user name who updated the preference.

LASTCHANGED

DATE

 

The date and time the report was generated.