Name |
|
Comment |
The tracking of Facility ownership over time |
Name |
COMPANYID |
EFFECTIVEDATE |
VERSIONDATETIME |
Name |
Data Type |
Mandatory |
Comment |
COMPANYID |
Number(10,0) |
X |
Unique company identifier |
EFFECTIVEDATE |
Date |
X |
Effective date for this operating state |
VERSIONDATETIME |
Date |
X |
Version date time for this operating state |
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 |
|
|
|