|
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. |
|
|
|