|
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 |
|
|
|