|
Name |
|
|
Comment |
Service Points currently registered under Part 24 of the Rules for the capacity trading and day ahead auction. |
|
Name |
|
AUCTION_PRODUCT_TYPE |
|
EFFECTIVEDATE |
|
FACILITY_ID |
|
SERVICE_POINT_ID |
|
SERVICE_POINT_TYPE |
|
VERSION_DATETIME |
|
Name |
Data Type |
Mandatory |
Comment |
|
FACILITY_ID |
NUMBER(8,0) |
X |
The unique identifier of the parent facility. |
|
EFFECTIVEDATE |
DATE |
X |
The effective date of the service point. |
|
VERSION_DATETIME |
DATE |
X |
The version timestamp of the record |
|
SERVICE_POINT_ID |
NUMBER(8,0) |
X |
The unique identifier of the service point. |
|
FACILITY_NAME |
VARCHAR2(100) |
|
The descriptive name of the parent facility. |
|
SERVICE_POINT_NAME |
VARCHAR2(100) |
|
The descriptive name of the service point. |
|
SERVICE_POINT_TYPE |
VARCHAR2(100) |
X |
The type of service point, for example forward haul receipt point, forward haul delivery point, backhaul receipt point, backhaul delivery point, compression receipt point or compression delivery point. |
|
SERVICE_POINT_DESCRIPTION |
VARCHAR2(255) |
|
The description of the service point. |
|
AUCTION_PRODUCT_TYPE |
VARCHAR2(20) |
X |
Auction Product Type for Service Point |
|
NOTIONAL_POINT |
VARCHAR2(3) |
|
Flag to indicate if the service point is a notional point, for example Yes or No. |
|
ZONE_ID |
NUMBER(8,0) |
|
The unique identifier of the zone in which the service point is located. |
|
ZONE_NAME |
VARCHAR2(100) |
|
The descriptive name of the zone. |
|
GBB_CONNECTION_POINT_ID |
NUMBER(8,0) |
|
The corresponding GBB connection point identifier. |
|
GBB_CONNECTION_POINT_NAME |
VARCHAR2(100) |
|
The descriptive name of the corresponding GBB connection point. |
|
FOR_AUCTION_PUBLICATION |
VARCHAR2(3) |
|
Flag to indicate if the product component can be published in the public auction reports, for example yes or no. |
|
LASTCHANGED |
DATE |
|
The date and time the report was generated. |
|
|
|