Table: GSH_FACILITIES

GSH_FACILITIES

Name

GSH_FACILITIES

Comment

Facilities currently registered, for capacity trading and day ahead auction.


Primary Key Columns

Name

EFFECTIVEDATE

FACILITY_ID

VERSION_DATETIME


Content

Name

Data Type

Mandatory

Comment

FACILITY_ID

NUMBER(8,0)

X

The unique identifier of the facility.

EFFECTIVEDATE

DATE

X

Effective date of the record

VERSION_DATETIME

DATE

X

Version timestamp of the record

FACILITY_NAME

VARCHAR2(100)

 

The name of the facility.

FACILITY_DESCRIPTION

VARCHAR2(400)

 

The descriptive name of the facility.

FACILITY_TYPE

VARCHAR2(20)

 

The type of facility, for example pipe or compressor.

OPERATOR_ID

VARCHAR2(20)

 

The unique identifier of the Facility Operator that operates the facility.

OPERATOR_NAME

VARCHAR2(100)

 

The descriptive name of the participant.

LASTCHANGED

DATE

 

The date and time the report was generated.