Name |
|
Comment |
The operating status of all facility nodes over time |
Name |
EffectiveDate |
NodeId |
VersionDateTime |
Name |
Data Type |
Mandatory |
Comment |
NodeId |
NUMBER(10,0) |
X |
Unique Node 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 |
|
|
|