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.


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.