Table: GAS_NODE_OPSTATE

GAS_NODE_OPSTATE

Name

GAS_NODE_OPSTATE

Comment

The operating status of all facility nodes over time


Primary Key Columns

Name

EffectiveDate

NodeId

VersionDateTime


Content

Name

Data Type

Mandatory

Comment

NodeId

NUMBER(10,0)

X

Unique Node Identifier

EffectiveDate

DATE

X

Effective date of the record

VersionDateTime

DATE

X

Version timestamp of the record

OperatingState

VARCHAR2(20)

 

Operating status - active, inactive.

AuthorisedDate

DATE

 

Date and time this operating state was authorised.

AuthorisedBy

VARCHAR2(30)

 

User that authorised the change.

LastChanged

DATE

 

Date and time record was last modified