|
Name |
|
|
Comment |
Pipeline Segments currently registered under Part 24 of the Rules for the capacity trading and day ahead auction. |
|
Name |
|
CONNECTION_TYPE |
|
EFFECTIVEDATE |
|
FACILITY_ID |
|
FROM_ID |
|
SEGMENT_ID |
|
TO_ID |
|
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 segment. |
|
VERSION_DATETIME |
DATE |
X |
The version timestamp of the record |
|
SEGMENT_ID |
NUMBER(8,0) |
X |
The unique identifier of the pipeline segment or compression service. |
|
FACILITY_NAME |
VARCHAR2(100) |
|
The descriptive name of the parent facility. |
|
SEGMENT_NAME |
VARCHAR2(100) |
|
The descriptive name of the pipeline segment or compression service. |
|
SEGMENT_TYPE |
VARCHAR2 (20) |
|
The segment type, for example Forward Haul, Backhaul or Compression Service |
|
FROM_ID |
NUMBER(8,0) |
X |
The unique identifier of the zone for forward haul pipeline segments and compression services or the service point for backhaul pipeline segments. |
|
FROM_NAME |
VARCHAR2(100) |
|
The descriptive name of the zone or service point. |
|
TO_ID |
NUMBER(8,0) |
X |
The unique identifier of the zone for forward haul pipeline segments and compression services or the service point for backhaul pipeline segments. |
|
TO_NAME |
VARCHAR2 (100) |
|
The descriptive name of the zone or service point. |
|
CONNECTION_TYPE |
VARCHAR2(20) |
X |
Type of connection (eg. SERVICE_POINT, ZONE) |
|
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. |
|
|
|