Table: GAS_LOCATION_NODE_TRK

GAS_LOCATION_NODE_TRK

Name

GAS_LOCATION_NODE_TRK

Comment

Provides a record of node tracking.


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

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