Name |
|
Comment |
This report is available to participants as an audit trail of the entries in the Contract References markets portal application. |
Name |
BUY_SELL_POSITION |
FROM_GAS_DATE |
PARTICIPANT_CODE |
PRODUCT_NAME |
STEP_NUMBER |
TO_GAS_DATE |
VERSION_DATETIME |
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. |
|
|
|