Historical structure
- Last UpdatedApr 24, 2025
- 1 minute read
The Historical database consists of a number of databases, which are shown below.
Entries in some tables may be viewed through summaries in the easy eXtended Operator Station (ezXOS):
-
Hour table (Accumulator database)
-
Connect Statistics table (Communications Statistics database)
-
Remote statistics table (Communications Statistics database)
-
Collect table (Timeline/TimeSeries database)
For more information, refer to the AVEVA Enterprise SCADA HMI Controller documentation.
Historical Database Tables and Views
|
Database |
Table |
View |
|---|---|---|
|
Accum |
hour |
hourView |
|
day |
dayView |
|
|
month |
monthView |
|
|
year |
yearView |
|
|
CommStats |
RemPeriodStats |
RemStatsViews |
|
editRemPeriodView |
||
|
ConnPeriodStats |
ConnStatsView |
|
|
editConnPeriodView |
||
|
Event |
ConfigModSummary |
EventView |
|
SummaryView |
||
|
ConfigModSummaryView |
||
|
DataModSummary |
EventView |
|
|
SummaryView |
||
|
DataModSummaryView |
||
|
OperActivitySummary |
EventView |
|
|
SummaryView |
||
|
OperActivitySummaryView |
||
|
OperatorNotes |
categoryDefine |
categoryView |
|
note |
noteView |
|
|
noteAuditTrail |
||
|
noteCounter |
||
|
noteObjectRefer |
||
|
noteRanges |
||
|
referenceTypeDefine |
||
|
Timeline |
collect |
|
|
hour |
||
|
month |
||
|
tag |
||
|
tagRanges |
||
|
year |
||
|
TimeSeries |
collect |
collectView |
|
collectAuditTrail |
||
|
collectPeriods |
||
|
day |
dayView |
|
|
hour |
hourView |
|
|
month |
monthView |
|
|
partitionConfig |
||
|
tag |
||
|
year |
yearView |
|
|
xosApp |
doas_dataset |
|
|
doas_mode_history |
||
|
doas_privilege |
||
|
notepad |
notepadView |
Note: The EventView and SummaryView provide joined information from the ConfigModSummary, DataModSummary and OperActivitySummary tables.