Table: GSH_PIPELINE_SEGMENTS

GSH_PIPELINE_SEGMENTS

Name

GSH_PIPELINE_SEGMENTS

Comment

Pipeline Segments currently registered under Part 24 of the Rules for the capacity trading and day ahead auction.


Primary Key Columns

Name

CONNECTION_TYPE

EFFECTIVEDATE

FACILITY_ID

FROM_ID

SEGMENT_ID

TO_ID

VERSION_DATETIME


Content

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.