Table: GAS_LOCATION_OPSTATE

GAS_LOCATION_OPSTATE

Name

GAS_LOCATION_OPSTATE

Comment

The operating status of all locations over time.


Notes

Name

Comment

Value

Visibility

Data confidentiality of this table

Public


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)

 

AEMO internal

LastChanged

DATE

 

Date and time record was last modified