Name |
|
Comment |
The operating status of all locations over time. |
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 |
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 |
|
|
|