Table: GSH_ZONES

GSH_ZONES

Name

GSH_ZONES

Comment

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


Primary Key Columns

Name

EFFECTIVEDATE

VERSION_DATETIME

ZONE_ID


Content

Name

Data Type

Mandatory

Comment

ZONE_ID

NUMBER(8,0)

X

The unique identifier of the zone.

EFFECTIVEDATE

DATE

X

Effective date of the record

VERSION_DATETIME

DATE

X

Version timestamp of the record

ZONE_NAME

VARCHAR2(100)

 

The descriptive name of the zone.

ZONE_TYPE

VARCHAR2(20)

 

The type of zone, for example pipeline receipt, pipeline delivery, compression receipt or compression delivery.

ZONE_DESCRIPTION

VARCHAR2(400)

 

The description of the 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.