Description of tables and views

Tables in the repository

A number of tables are created and used in addition to the tables presented in the description of functionality. They are responsible for proper operation of the archives, logging processes, and managing the various archive sets. Because these tables are really meant for internal use, they are not listed in the following breakdown. The main focus here is on the tables containing process values.

The primary keys of the various tables are highlighted. The tables that do not contain a screenshot, such as the table ALERTLASTVAL and EVENTLASTVAL are temporary tables and only used by the RDB manager.

Elements

This table contains all data point elements of the WinCC OA project including additional information.

Systems

This table contains all system names of the WinCC OA project.

DPT

This table contains all configured data point types of the WinCC OA project.

DP

This table contains all data points of the WinCC OA project.

DPE

This table contains all data point elements (name of the data point elements) of the WinCC OA project.

<group>LASTVAL

This table contains the last value change of the data point elements that are allocated to this archive group by the archive config. Because several archive groups may exist, there may also be multiple LASTVAL tables. Only WinCC OA data types, which are not of the type "Array", may be allocated to this table.

A table called EVENTLASTVAL is created by default.

The individual columns of the table below contain WinCC OA configs. The configs describe the value. In the table below the attributes of the WinCC OA configs _original, _online and _corr are described. The links of the individual columns of the following table refer to the description of the attributes of the corresponding config. You can find a general description of the configs _original as well as _online in the chapter _original (Originalattribute)_original (Original attributes) and a general description of the topic correction value in the chapter Basic information on correction values and laboratory values.

<group>HISTORY_<number>

This table / these tables contain all value changes of the <group>LASTVAL table. Thus, this is the actual archive. For information on archives and functionality of the RDB archiving, see chapter Functionality of the RDB archiving.

A table called EVENTHISTORY_<number> is created by default.

If no correction values or replacement values were set, the columns as shown above, are empty.

<group>LASTVALVALUES

This table contains the last value change of the data point elements that are allocated to this archive group by the archive config. These tables are used for all values that are of the "Array" type and thus contain the complete array of values of the data point element. The tables supplement the <group>LASTVAL tables. Since there can be multiple archive groups, there can also be multiple LASTVALVALUES tables.

A table called EVENTLASTVALVALUES is created by default.

The individual columns of the table below contain WinCC OA configs. The configs describe the value. In the table below the attributes of the WinCC OA configs _original, _online and _corr are described. The links of the individual columns of the following table refer to the description of the attributes of the corresponding config. You can find a general description of the configs _original as well as _online in the chapter _original (Originalattribute)_original (Original attributes) and a general description of the topic correction values in the chapter Basic information on correction values and laboratory values.

<group>HISTORYVALUES_<number>

This table / these tables contain all value changes of the <group>LASTVALVALUES table. Thus, this is the actual archive. These tables supplement the <group>HISTORY_<number> tables. For information on archives and functionality of the RDB archiving, see chapter Functionality of the RDB archiving.

A table called EVENTHISTORYVALUES_<number> is created by default.

If no correction values or replacement values were set, the columns as shown above, are empty.

ALERTLASTVAL

This table contains the last alert change of the data point elements in the WinCC OA project with an (activated) alert handling and alert class. Only WinCC OA data types, but not of the "Array" type, may be allocated to this table.

The individual columns of the table below contain the WinCC OA configs. The configs describe the alert change. In the table below the attributes of the WinCC OA configs _alert_hdl (alert handling), _online and _corr are described.

The links in the individual columns of the following table refer to the description of the configs. You can find the a general description of the config _alert_hdl in the chapter Alert handling, basics, a general description of the config _online in the chapter _original (Original attributes) and a general description of the topic correction values in the chapter Basic information on correction values and laboratory values.

ALERTHISTORY_<number>

This table / these tables contain all alert changes of the ALERTLASTVAL table. Thus, this is the actual alert archive. For information on archives and functionality of the RDB archiving, see chapter Functionality of the RDB archiving

ALERTLASTVALVALUES

This table contains the last alert change of the data point elements in the WinCC OA project with an (activated) alert handling and alert class. This table is used for all values that are of the "Array" type and thus contains the complete array of values of the data point element. This table supplements the ALERTLASTVAL table.

The individual columns of the table below contain the WinCC OA configs. The configs describe the alert change. In the table below the attributes of the WinCC OA config _alert_hdl (alert handling) are described. The links in the individual columns of the following table refer to the description of the attributes of the alert_hdl config. You can find the a general description of the config _alert_hdl in the chapter Alert handling, basics

ALERTHISTORYVALUES_<number>

This table / these tables contain all alert changes of the ALERTLASTVALVALUES table. Thus, this is the actual alert archive. These tables supplement the ALERTHISTORY_<number> tables. For information on archives and functionality of the RDB archiving, see chapter Functionality of the RDB archiving

<ARGROUP>HISTORY_xxxx

The database tables are created for each archive group as follows:

Each archive group has a table for single data types (int, float, string) and a table for dyn data types.

Single data is saved here:

<ARGROUP>HISTORY_xxxx e.g. EVENTHISTORY_xxxxx

If no correction values or replacement values were set, the columns as shown above, are empty.

and Dyn Data is saved in the following table (for the screenshot, see Screenshot).

<ARGROUP>HISTORYVALUES_xxxx e.g. EVENTHISTORYVALUES_xxxx

If the feature HDB/Raima -RDB Parallel is activated (the check box "Forward values to RDB" is checked), corresponding Oracle archive groups are created for the selected archives (except for ValueArchive0). These are called:

for ValueArchive_1: VA1HISTORY_xxxx and VA1HISTORYVALUES_xxxx

for ValueArchive_2: VA2HISTORY_xxxx and VA2HISTORYVALUES_xxxx

Views

The following default views are available for external access (e.g.: with Crystal Reports). They contain the WinCC OA attributes that are typically of interest for queries. You can, of course, create your own views that allow custom groups of attributes.

Correction values are not queried directly from WinCC OA, but are formed with the aid of the information in Oracle.

'alert_hdl.._add_value_x' and 'alert_hdl.._add_values' may not be used in a same SELECT-Statement of a SQL query.

View_Event_History View_Event_Last_Val

These two views are essentially the same in structure. The only difference is that the View_Event_History references history values while the View_Event_Last_Val references current values.

View_Alert_History View_Alert_Last_Val

These two views are also essentially the same in structure. The only difference is that the View_Alert_History references history values while the View_Alert_Last_Val references current values.

View VALERTSCREEN

This view contains the attributes of the alert screen.

View VALERTSCREENPIVOT

The view is used if an ADD_VALUE_x (x = number) column is queried in a SELECT statement. Otherwise the view VALERTSCREEN is used. The view contains all ADD_VALUE values per row.

Views <ARGROUP>HISTORY, <ARGROUP>HISTORYVALUES, ad V<ARGROUP>SCREEN

The are associated views per archive group available:

For each archive group there is:

• < ARGROUP>HISTORY

• <ARGROUP>HISTORYVALUES

• V<ARGROUP>SCREEN

The view <ARGROUP>HISTORY contains the single data of all ONLINE tablespaces of <ARGROUP>HISTORY_xxxx.

The view <ARGROUP>HISTORYVALUES contains the dyn data of all ONLINE tablespaces of <ARGROUP>HISTORYVALUES.

The view V<ARGROUP>SCREEN is a join of the HISTORY and HISTORYVALUES tables. The view contains all single and dyn data in chronologically ascending order. These are used, for example, for event screen queries.