Table: GAS_FACILITY_NODE_TRK

GAS_FACILITY_NODE_TRK

Name

GAS_FACILITY_NODE_TRK

Comment

A facility tracking record. A parent record relating to sets of child nodes linked to a facility. The set can be found in GAS_FACILITY_NODE.


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 of the record

VersionDateTime

DATE

X

Version timestamp of the record

AuthorisedDate

DATE

 

Any records without a date are ignored by AEMO systems.

AuthorisedBy

VARCHAR2(30)

 

User that authorised the change.

LastChanged

DATE

 

Date and time record was last modified