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