Table: GAS_FACILITY_OPSTATE

GAS_FACILITY_OPSTATE

Name

GAS_FACILITY_OPSTATE

Comment

The operating status of all facilities over time


Primary Key Columns

Name

EFFECTIVEDATE

FACILITYID

VERSIONDATETIME


Content

Name

Data Type

Mandatory

Comment

FACILITYID

Number(10,0)

X

Unique Facility identifier

EFFECTIVEDATE

Date

X

Effective date for this operating state

VERSIONDATETIME

Date

X

Version date time for this operating state

OPERATINGSTATE

Varchar2 (20)

 

Operating status - active, inactive

AUTHORISEDDATE

Date

 

Date and time this operating state was authorised

AUTHORISEDBY

Varchar2 (30)

 

User which authorised the change

LASTCHANGED

DATE

 

Date and time record was last modified