Table: GAS_FACILITY

GAS_FACILITY

Name

GAS_FACILITY

Comment

Provides details of all facilities


Primary Key Columns

Name

FacilityId


Content

Name

Data Type

Mandatory

Comment

FacilityId

NUMBER(10,0)

X

Unique Facility Identifier

FacilityName

VARCHAR2(100)

 

Name of the Facility

FacilityType

VARCHAR2(40)

 

Describes type of Facility.Valid entries are: PIPE, PROD or STOR

LastChanged

DATE

 

Date and time record was last modified

FACILITYSHORTNAME

VARCHAR2(30)

 

An abbreviation of the facility name