Table: GAS_LOCATION_OPSTATE

GAS_LOCATION_OPSTATE

Name

GAS_LOCATION_OPSTATE

Comment

The operating status of all locations over time.


Primary Key Columns

Name

EffectiveDate

LocationId

VersionDateTime


Content

Name

Data Type

Mandatory

Comment

LocationId

NUMBER(10,0)

X

Unique Location 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