|
Name |
|
|
Comment |
Provides a record of node tracking. |
|
Name |
|
EffectiveDate |
|
LocationId |
|
VersionDateTime |
|
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 |
|
|
|