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