Description of tables and views
The following section gives an overview of the tables used by the RDB Archive Manager and the default views created during installation.
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.
Column | Description | Type |
ELEMENT_ID | ID of the specific element. Calculated from the WinCC OA DP ID, the WinCC OA DP element ID, and the WinCC OA system ID. | NUMBER(20) |
SYS_ID | Reference to the Systems table | NUMBER(20) |
EVENT | 1 if it is an event element | NUMBER(1) |
ALERT | 1 if it is an alert element | NUMBER(1) |
ELEMENT_NAME |
Complete DPE name of an element e.g.: System1:ExampleDP1.val.LastLeaf |
VARCHAR2(4000) |
DPT_ID | Reference to the DPT table | NUMBER(20) |
DP_ID | Reference to the DP table | NUMBER(20) |
DPE_ID | Reference to the DPE table | NUMBER(20) |
UNIT | Unit of the DPE | VARCHAR2(4000) |
ALIAS | The WinCC OA alias of the specific data point element. | VARCHAR2(4000) |
GROUP_NAME | Group name of the DPE. | VARCHAR2(4000) |
COMMENT_ | You can specify a comment (maximum 4000 characters) using this column. | VARCHAR2(4000) |
TYPE_ | The type of element to which the alert handling is appended | NUMBER(20) |
Systems
This table contains all system names of the WinCC OA project.
Column | Description | Type |
SYS_ID | WinCC OA system ID | NUMBER(20) |
SYS_NAME | Name of the system | VARCHAR2(4000) |
DPT
This table contains all configured data point types of the WinCC OA project.
Column | Description | Type |
DPT_ID | WinCC OA data point ID | NUMBER(20) |
DPTNAME | Name of the data point type | VARCHAR2(4000) |
SYS_ID | Reference to the Systems table | NUMBER(20) |
DP
This table contains all data points of the WinCC OA project.
Column | Description | Type |
DP_ID | WinCC OA data point ID | NUMBER(20) |
SYS_ID | Reference to the Systems table | NUMBER(20) |
DPNAME | Name of the data point | VARCHAR2(4000) |
DPE
This table contains all data point elements (name of the data point elements) of the WinCC OA project.
Column | Description | Type |
SYS_ID | Reference to the Systems table | NUMBER(20) |
DPE_ID | WinCC OA DP ID | NUMBER(20) |
DP_ID | Reference to the DP table | NUMBER(20) |
DPENAME | Name of the DPE | VARCHAR2(4000) |
<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.
Column | Description | Type |
ELEMENT_ID | Reference to the Elements table | NUMBER(20) |
TS | Time when an alert was generated, for example, by a driver. | TIMESTAMP(9) |
VALUE_NUMBER |
The WinCC OA "_original.._value" attribute Used for the WinCC OA data types "integer", "float" and "bool |
NUMBER |
STATUS | The WinCC OA "_original.._status" attribute | NUMBER(20) |
MANAGER | The WinCC OA "_original.._manager" attribute | NUMBER(20) |
USER_ | The WinCC OA "_original.._user" attribute | VARCHAR2(4000) |
TEXT | The WinCC OA "_original.._text" attribute | VARCHAR2(4000) |
VALUE_STRING |
The WinCC OA "_original.._value" attribute Used for the WinCC OA "string" data type and as a default for all data types not supported by this table. |
VARCHAR2(4000) |
OLVALUE_STRING |
The WinCC OA "_online.._value" attribute Used for the WinCC OA "string" data type and as a default for all data types not supported by this table. |
VARCHAR2(4000) |
CORRVALUE_STRING |
The WinCC OA "_corr.._value" attribute Used for the WinCC OA "string" data type and as a default for all data types not supported by this table. |
VARCHAR2(4000) |
VALUE_TIMESTAMP |
The WinCC OA "_original.._value" attribute Used for the WinCC OA data type "time" |
TIMESTAMP(9) |
OLVALUE_TIMESTAMP |
The WinCC OA "_online.._value" attribute Used for the WinCC OA data type "time" |
TIMESTAMP(9) |
CORRVALUE_TIMESTAMP |
The WinCC OA "_corr.._value" attribute Used for the WinCC OA data type "time" |
TIMESTAMP(9) |
<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.
Column | Description | Type |
ELEMENT_ID | Reference to the Elements table | NUMBER(20) |
TS | Time when an alert was generated, for example, by a driver. | TIMESTAMP(9) |
BASE | Last value (dregs) from the last backed-up time range | NUMBER(1) |
The rest of the columns are the same as in the <group>LASTVAL table. |
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.
Column | Description | Type |
ELEMENT_ID | Reference to the Elements table | NUMBER(20) |
TS | Time when an alert was generated, for example, by a driver. | TIMESTAMP(9) |
POSITION | The position of the specific entry in the array; starts at 0 | NUMBER(20) |
VALUE_DYNSTRING |
The WinCC OA "_original.._value" attribute Used for the WinCC OA "dyn_string" data type and as a default for all data types not supported by this table. |
VARCHAR2(4000) |
OLVALUE_DYNSTRING |
The WinCC OA "_online.._value" attribute Used for the WinCC OA "dyn_string" data type and as a default for all data types not supported by this table. |
VARCHAR2(4000) |
CORRVALUE_DYNSTRING |
The WinCC OA "_corr.._value" attribute Used for the WinCC OA "dyn_string" data type and as a default for all data types not supported by this table. |
VARCHAR2(4000) |
VALUE_DYNNUMBER |
The WinCC OA "_original.._value" attribute Used for the WinCC OA data types "dyn_integer", "dyn_float" and "dyn_bool" |
NUMBER |
OLVALUE_DYNNUMBER |
The WinCC OA "_online.._value" attribute Used for the WinCC OA data types "dyn_integer", "dyn_float" and "dyn_bool" |
NUMBER |
CORRVALUE_DYNNUMBER |
The WinCC OA "_corr.._value" attribute Used for the WinCC OA data types "dyn_integer", "dyn_float" and "dyn_bool" |
NUMBER |
VALUE_DYNTIMESTAMP |
The WinCC OA "_original.._value" attribute Used for the WinCC OA data type "dyn_time" |
TIMESTAMP(9) |
OLVALUE_DYNTIMESTAMP |
The WinCC OA "_online.._value" attribute Used for the WinCC OA data type "dyn_time" |
TIMESTAMP(9) |
CORRVALUE_DYNTIMESTAMP |
The WinCC OA "_corr.._value" attribute Used for the WinCC OA data type "dyn_time" |
TIMESTAMP(9) |
<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.
Column | Description | Type |
ELEMENT_ID | Reference to the Elements table | NUMBER(20) |
TS | Time when an alert was generated, for example, by a driver. | TIMESTAMP(9) |
BASE | Last value (dregs) from the last backed-up time range | NUMBER(1) |
The rest of the columns are the same as in the <group>LASTVALVALUES table. |
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.
Column | Description | Type |
ELEMENT_ID | Reference to the Elements table | NUMBER(20) |
TS | Time when an alert was generated, for example, by a driver. | TIMESTAMP(9) |
ACK_STATE | The WinCC OA "_alert_hdl.._ack_state" attribute | NUMBER(20) |
ACK_TIME | The WinCC OA "_alert_hdl.._ack_time" attribute | TIMESTAMP(9) |
STATE | The WinCC OA "_alert_hdl.._single_state" attribute | NUMBER(20) |
VALUE_NUMBER |
The WinCC OA "_online.._value" attribute Used for the WinCC OA data types "integer", "float" and "bool" |
NUMBER |
ABBR | The WinCC OA "_alert_hdl.._abbr" attribute | VARCHAR2(4000) |
ACK_TYPE | The WinCC OA "_alert_hdl.._ack_type" attribute | NUMBER(20) |
ACK_USER | The WinCC OA "_alert_hdl.._ack_user" attribute | NUMBER(20) |
ACKABLE | The WinCC OA "_alert_hdl.._ackable" attribute | NUMBER(1) |
ALERT_COLOR | The WinCC OA "_alert_hdl.._alert_color" attribute | VARCHAR2(4000) |
CLASS | The WinCC OA "_alert_hdl.._class" attribute | VARCHAR2(4000) |
COMMENT | The WinCC OA "_alert_hdl.._comment" attribute | VARCHAR2(4000) |
DEST | The WinCC OA "_alert_hdl.._dest" attribute | NUMBER(20) |
DEST_TEXT | The WinCC OA "_alert_hdl.._dest_text" attribute | VARCHAR2(4000) |
DIRECTION | The WinCC OA "_alert_hdl.._direction" attribute | NUMBER(1) |
INACT_ACK | The WinCC OA "_alert_hdl.._inact_ack" attribute | NUMBER(1) |
PANEL | The WinCC OA "_alert_hdl.._panel" attribute | VARCHAR2(4000) |
PARTN_IDX | The WinCC OA "_alert_hdl.._partn_idx" attribute | NUMBER(20) |
PARTNER | The WinCC OA "_alert_hdl.._partner" attribute | TIMESTAMP(9) |
PRIO | The WinCC OA "_alert_hdl.._prior" attribute | VARCHAR2(4000) |
SINGLE_ACK | The WinCC OA "_alert_hdl.._single_ack" attribut | NUMBER(1) |
TEXT | The WinCC OA "_alert_hdl.._single_text" attribute | VARCHAR2(4000) |
TEXT0 | The WinCC OA "_alert_hdl.._single_text0" attribute | VARCHAR2(4000) |
TEXT1 | The WinCC OA "_alert_hdl.._single_text1" attribute | VARCHAR2(4000) |
VALUE_STRING | The WinCC OA "_online.._value" attribute. Used for the WinCC OA "string" data type and as a default for all data types not supported by this table. | VARCHAR2(4000) |
VALUE_TIMESTAMP |
The WinCC OA "_online.._value" attribute Used for the WinCC OA data type "time" |
TIMESTAMP(9) |
VISIBLE | The WinCC OA "_alert_hdl.._visible" attribute | NUMBER(1) |
ALERT_FORE_COLOR | The WinCC OA "_alert_hdl.._alert_fore_color" attribute | VARCHAR2(4000) |
ALERT_FONT_STYLE | The WinCC OA "_alert_hdl.._alert_font_style" attribute | VARCHAR2(4000) |
DETAIL | The WinCC OA "_alert_hdl.._detail" attribute | NUMBER(20) |
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
Column | Description | Type |
ELEMENT_ID | Reference to the Elements table | NUMBER(20) |
TS | Time when an alert was generated, for example, by a driver. | TIMESTAMP(9) |
BASE | Last value (dregs) from the last backed-up time range | NUMBER(1) |
The rest of the columns are the same as in the ALERTLASTVAL table |
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
Column | Description | Type |
Element_ID | Reference to the Elements table | NUMBER(20) |
TS | Time when an alert was generated, for example, by a driver. | TIMESTAMP(9) |
POSITION | The position of the specific entry in the array; starts at 0 | NUMBER(20) |
ACK_STATE | The WinCC OA "_alert_hdl.._ack_state" attribute | NUMBER(20) |
ACK_TIME | The WinCC OA "_alert_hdl.._ack_time" attribute | TIMESTAMP(9) |
STATE | The WinCC OA "_alert_hdl.._single_state" attribute | NUMBER(20) |
VALUE_DYNNUMBER |
The WinCC OA "_online.._value" attribute Used for the WinCC OA data types "dyn_integer", "dyn_float" and "dyn_bool" |
NUMBER |
VALUE_DYNSTRING |
The WinCC OA "_online.._value" attribute Used for the WinCC OA "dyn_string" data type and as a default for all data types not supported by this table. |
VARCHAR2(4000) |
VALUE_DYNTIMESTAMP |
The WinCC OA "_online.._value" attribute Used for the WinCC OA data type "dyn_time" |
TIMESTAMP(9) |
CORRVALUE_DYNTIMESTAMP | The WinCC OA "_corr_value" attribute is used for the WinCC OA data type "dyn_time". | TIMESTAMP(9) |
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
Column | Description | Type |
ELEMENT_ID | Reference to the Elements table | NUMBER(20) |
TS | Timestamp when the Manager received the value change from the Data Manager. | TIMESTAMP(9) |
BASE | Last value (dregs) from the last backed-up time range | NUMBER(1) |
The rest of the columns are the same as in the ALERTLASTVALVALUES table |
<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
Column | Description | Type |
ELEMENT_ID | ID of the respective element. It is calculated from the WinCC OA DP ID, the WinCC OA DP Element ID and the WinCC OA System ID. | NUMBER(25,0) |
TS | Time when an event was created e.g. by a driver. | TIMESTAMP(9) |
VALUE_NUMBER | TheWinCC OA "_original.._value" attribute is used for theWinCC OAdata types "integer", "float" and "bool". | NUMBER |
STATUS | The WinCC OA "_original.._status" attribute. | NUMBER(20,0) |
MANAGER NUMBER | The WinCC OA "_original.._manager" attribute. | NUMBER(20,0) |
USER_ NUMBER | The WinCC OA "_original.._user" attribute. | (5,0) |
SYS_ID | Reference to table Systems. | NUMBER(20,0) |
BASE NUMBER | Last value of the prior exported time range. | (1,0) |
TEXT | TheWinCC OA "_original.._text" attribute. | VARCHAR2 (4000 BYTE) |
VALUE_STRING |
The WinCC OA "_original.._value" attibute Is used if the data type of the DPE is string. |
VARCHAR2(4000 BYTE) |
VALUE_TIMESTAMP |
TheWinCC OA"_original.._value" attribute. Is used if the data type of the DPE is "time". |
TIMESTAMP(9) |
CORRVALUE_NUMBER |
The WinCC OA "_corr.._value" attribute. Is used when the data type of the DPE is numerical. |
NUMBER |
OLVALUE_NUMBER |
The WinCC OA "_online.._value" attribute. Is used when the data type of the DPE is numerical. |
NUMBER |
CORRVALUE_STRING VARCHAR2 |
The WinCC OA "_corr.._value" attribute. Is used when the data type of the DPE is "string". |
(4000 BYTE) |
CORRVALUE_TIMESTAMP |
The WinCC OA "_corr.._value" attribute. Is used if the data type of the DPE is "time". |
TIMESTAMP(9) |
OLVALUE_TIMESTAMP |
The WinCC OA "_online.._value" attribute. Is used if the data type of the DPE is "time". |
TIMESTAMP(9) |
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
Column | Description | Type |
ELEMENT_ID | ID of the respective element. It is calculated from the WinCC OA DP ID, the WinCC OA DP Element ID and the WinCC OA System ID. | (25,0) |
TS | Time when an event was generated e.g. by a driver. | TIMESTAMP(9) |
POSITION | Position within the dyn value. | NUMBER(20,0) |
VALUE_DYNNUMBER NUMBER |
The WinCC OA "_original.._value" attribute Is used if the data type of the DPE is a numerical array. |
NUMBER |
SYS_ID | Reference to the table "Systems". | NUMBER(20,0) |
BASE NUMBER(1,0) | Last value of the exported time range. | BASE NUMBER(1,0) |
VALUE_DYNSTRING |
The WinCC OA "_original.._value" attribute. Is used if the data type of the DPE is a "dyn_string" |
VARCHAR2(4000 BYTE) |
VALUE_DYNTIMESTAMP |
The WinCC OA "_original.._value" attribute. Is used if the data type of the DPE is "dyn_time" |
TIMESTAMP(9) |
CORRVALUE_DYNNUMBER |
The WinCC_OA "_corr.._value" attribute Is used when the data type of the DPE is a numerical array. |
NUMBER |
OLVALUE_DYNNUMBER |
The WinCC_OA "_online.._value" attribute Is used if the data type of the DPE is a numerical array |
NUMBER |
CORRVALUE_DYNSTRING |
The WinCC OA "_corr.._value"-attribute Is used if the data type of the DPE is "dyn_string" |
VARCHAR2(4000 BYTE) |
OLVALUE_DYNSTRING |
The WinCC OA "_online.._value" attribute Is used if the data type of the DPE is "dyn_string". |
VARCHAR2(4000 BYTE) |
CORRVALUE_DYNTIMESTAMP |
The WinCC OA "_corr.._value" attribute. Is used if the data type of the DPE is "dyn_time". |
TIMESTAMP(9) |
OLVALUE_DYNTIMESTAMP |
TheWinCC OA "_online.._value" attribute. Is used if the data type of the DPE is "dyn_time". |
TIMESTAMP(9) |
VALTYPE | Indicator whether an original value (null) or an online value (0) or a correction value (1) is set. | NUMBER(1,0) |
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.
Column | Description | Type |
ELEMENT_ID | Reference to the Elements table | NUMBER(25,0) |
TS | Time when an alert was generated, for example, by a driver. | TIMESTAMP(9) |
SYS_ID | Reference to the Systems table | NUMBER(20,0) |
BASE | Last value (dregs) from the last backed-up time range | NUMBER(1,0) |
POSITION | Specifies the position of a specific entry if the DPE data type is one of the above arrays. | NUMBER(20,0) |
STATUS | The WinCC OA "_original.._status" or _online_status attribute | NUMBER(20) |
TEXT | The WinCC OA "_original.._text" attribute | VARCHAR2(4000) |
USER_ | The WinCC OA "_original.._user" attribute | NUMBER(20) |
MANAGER | The WinCC OA "_original.._manager" attribute | NUMBER(20) |
VALUE_STRING |
The WinCC OA "_original.._value" attribute Used if the DPE data type is "string" |
VARCHAR2(4000) |
OLVALUE_STRING |
The WinCC OA "_online.._value" attribute Used if the DPE data type is "string" |
VARCHAR2(4000) |
CORRVALUE_STRING |
The WinCC OA "_corr.._value" attribute Used if the DPE data type is "string" |
VARCHAR2(4000) |
OFFVALUE_STRING |
The WinCC OA "_offline.._value" attribute Used if the DPE data type is "string" |
VARCHAR2(4000) |
VALUE_NUMBER |
The WinCC OA "_original.._value" attribute Used if the DPE data type is numeric |
NUMBER |
OLVALUE_NUMBER |
The WinCC OA "_online.._value" attribute Used if the DPE data type is numeric |
NUMBER |
CORRVALUE_NUMBER |
The WinCC OA "_corr.._value" attribute Used if the DPE data type is numeric |
NUMBER |
OFFVALUE_NUMBER |
The WinCC OA "_offline.._value" attribute Used if the DPE_offline data type is numeric |
NUMBER |
VALUE_TIMESTAMP |
The WinCC OA "_original.._value" attribute Used if the DPE data type is "time" |
TIMESTAMP(9) |
OLVALUE_TIMESTAMP |
The WinCC OA "_online.._value" attribute Used if the DPE data type is "time" |
TIMESTAMP(9) |
CORRVALUE_TIMESTAMP |
The WinCC OA "_corr.._value" attribute Used if the DPE data type is "time" |
TIMESTAMP(9) |
OFFVALUE_TIMESTAMP |
The WinCC OA "_offline.._value" attribute Used if the DPE data type is "time" |
TIMESTAMP(9) |
VALUE_DYNSTRING |
The WinCC OA "_original.._value" attribute Used if the DPE data type is "dyn_string" |
VARCHAR2(4000) |
OLVALUE_DYNSTRING |
The WinCC OA "_online.._value" attribute Used if the DPE data type is "dyn_string" |
VARCHAR2(4000) |
CORRVALUE_DYNSTRING |
The WinCC OA "_corr.._value" attribute Used if th_corre DPE data type is "dyn_string" |
VARCHAR2(4000) |
OFFVALUE_DYNSTRING |
The WinCC OA "_offline.._value" attribute Used if the DPE data type is "dyn_string" |
VARCHAR2(4000) |
VALUE_DYNNUMBER |
The WinCC OA "_original.._value" attribute Used if the DPE data type is numeric array |
NUMBER |
OLVALUE_DYNNUMBER |
The WinCC OA "_online.._value" attribute Used if the DPE data type is numeric array |
NUMBER |
CORRVALUE_DYNNUMBER |
The WinCC OA "_corr.._value" attribute Used if the DPE data type is numeric array |
NUMBER |
OFFVALUE_DYNNUMBER |
The WinCC OA "_offline.._value" attribute Used if the DPE data type is numeric array |
NUMBER |
VALUE_DYNTIMESTAMP |
The WinCC OA "_original.._value" attribute Used if the DPE data type is "dyn_time" |
TIMESTAMP(9) |
OLVALUE_DYNTIMESTAMP |
The WinCC OA "_online.._value" attribute Used if the DPE data type is "dyn_time" |
TIMESTAMP(9) |
CORRVALUE_DYNTIMESTAMP |
The WinCC OA "_corr.._value" attribute Used if the DPE data type is "dyn_time" |
TIMESTAMP(9) |
OFFVALUE_DYNTIMESTAMP |
The WinCC OA "_offline.._value" attribute Used if the DPE data type is "dyn_time" |
TIMESTAMP(9) |
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.
Column | Description | Type |
ELEMENT_ID | Reference to the Elements table | NUMBER(20) |
TS | Time when an alert was generated, for example, by a driver. | TIMESTAMP(9) |
ACK_STATE | The WinCC OA "_alert_hdl.._ack_state" attribute | NUMBER(20) |
ACK_TIME | The WinCC OA "_alert_hdl.._ack_time" attribute | TIMESTAMP(9) |
STATE | The WinCC OA "_alert_hdl.._single_state" attribute | NUMBER(20) |
VALUE_NUMBER |
The WinCC OA "_online.._value" attribute Used for the WinCC OA data types "integer", "float" and "bool" |
NUMBER |
CORRVALUE_NUMBER | The WinCC OA _corr.._value attribute. Is used for the WinCC OA data types "integer", "float" and "bool". | NUMBER |
ABBR | The WinCC OA "_alert_hdl.._abbr" attribute | VARCHAR2(4000) |
ACK_TYPE | The WinCC OA "_alert_hdl.._ack_type" attribute | NUMBER(20) |
ACK_USER | The WinCC OA "_alert_hdl.._ack_user" attribute | NUMBER(20) |
ACKABLE | The WinCC OA "_alert_hdl.._ackable" attribute | NUMBER(1) |
ALERT_COLOR | The WinCC OA "_alert_hdl.._alert_color" attribute | VARCHAR2(4000) |
CLASS | The WinCC OA "_alert_hdl.._class" attribute | VARCHAR2(4000) |
COMMENT | The WinCC OA "_alert_hdl.._comment" attribute | VARCHAR2(4000) |
DEST | The WinCC OA "_alert_hdl.._dest" attribute | NUMBER(20) |
DEST_TEXT | The WinCC OA "_alert_hdl.._dest_text" attribute | VARCHAR2(4000) |
DIRECTION | The WinCC OA "_alert_hdl.._direction" attribute | NUMBER(1) |
INACT_ACK | The WinCC OA "_alert_hdl.._inact_ack" attribute | NUMBER(1) |
PANEL | The WinCC OA "_alert_hdl.._panel" attribute | VARCHAR2(4000) |
PARTN_IDX | The WinCC OA "_alert_hdl.._partn_idx" attribute | NUMBER(20) |
PARTNER | The WinCC OA "_alert_hdl.._partner" attribute | TIMESTAMP(9) |
PRIO | The WinCC OA "_alert_hdl.._prior" attribute | VARCHAR2(4000) |
SINGLE_ACK | The WinCC OA "_alert_hdl.._single_ack" attribut | NUMBER(1) |
TEXT | The WinCC OA "_alert_hdl.._single_text" attribute | VARCHAR2(4000) |
TEXT0 | The WinCC OA "_alert_hdl.._single_text0" attribute | VARCHAR2(4000) |
TEXT1 | The WinCC OA "_alert_hdl.._single_text1" attribute | VARCHAR2(4000) |
VALUE_STRING |
The WinCC OA "_online_value" attribute Used for the WinCC OA "string" data type and as a default for all data types not supported by this table. |
VARCHAR2(4000) |
VALUE_TIMESTAMP |
The WinCC OA "_online.._value" attribute Used for the WinCC OA data type "time" |
TIMESTAMP(9) |
VISIBLE | The WinCC OA "_alert_hdl.._visible" attribute | NUMBER(1) |
ALERT_FORE_COLOR | The WinCC OA "_alert_hdl.._alert_fore_color" attribute | VARCHAR2(4000) |
ALERT_FONT_STYLE | The WinCC OA "_alert_hdl.._alert_font_style" attribute | VARCHAR2(4000) |
DETAIL | The WinCC OA "_alert_hdl.._detail" attribute | NUMBER(20) |
View VALERTSCREEN
This view contains the attributes of the alert screen.
Column | Description | Type |
VALUE_NUMBER |
The WinCC OA "_online.._value" attribute is used for WinCC OA data types "integer", "float" and "bool". |
NUMBER |
ARCHIVE | The WinCC OA attribute _archive. | NUMBER |
SINGLE_ACK | The WinCC OA "_alert_hdl.._single_ack" attribute | NUMBER(1) |
BASE | The last value of the period that was archived before. | NUMBER(1) |
INACT_ACK | The WinCC OA "_alert_hdl.._inact_ack" attribute | NUMBER(1) |
DIRECTION | The WinCC OA "_alert_hdl.._direction" attribute | NUMBER(1) |
VISIBLE | The WinCC OA "_alert_hdl.._visible" attribute | NUMBER(1) |
ACKABLE | The WinCC OA "_alert_hdl.._ackable" attribute | NUMBER(1) |
TYPE_ | Obsolete | NUMBER(20) |
DEST | The WinCC OA "_alert_hdl.._dest" attribute | NUMBER(20) |
DP_ID | Reference to the DP table. | NUMBER(20) |
STATE | The WinCC OA "_alert_hdl.._single_state" attribute | NUMBER(20) |
DPT_ID | Reference to the DPT table. | NUMBER(20) |
VALUE_STATUS | Status of the value that triggered the alert. | NUMBER(20) |
ACK_USER | The WinCC OA "_alert_hdl.._ack_user" attribute | NUMBER(20) |
ACK_TYPE | The WinCC OA "_alert_hdl.._ack_type" attribute | NUMBER(20) |
PARTN_IDX | The WinCC OA "_alert_hdl.._partn_idx" attribute | NUMBER(20) |
POSITION | The position of the specific entry in the array; starts at 0 | NUMBER(20) |
SYS_ID | Reference to the table systems. | NUMBER(20) |
DETAIL | The WinCC OA "_alert_hdl.._detail" attribute | NUMBER(20) |
ACK_STATE | The WinCC OA "_alert_hdl.._ack_state" attribute | NUMBER(20) |
PRIO | The WinCC OA "_alert_hdl.._prior" attribute | NUMBER(20) |
ELEMENT_ID | Reference to the Elements table. | NUMBER(25) |
PARTNER | The WinCC OA "_alert_hdl.._partner" attribute | TIMESTAMP(9) |
ACK_TIME | The WinCC OA "_alert_hdl.._ack_time" attribute | TIMESTAMP(9) |
TS | Time when an alert was generated, for example, by a driver. | TIMESTAMP(9) |
SYSTEM_TIME | Time when a value or an alert was received by the WinCC OA system. | TIMESTAMP(9) |
VALUE_TIMESTAMP |
The WinCC OA "_online.._value" attribute Used for the WinCC OA data type "time" |
TIMESTAMP(9) |
ALERT_ID | The WinCC OA "alert_hdl.._alert_id" attribute | VARCHAR2(4000) |
CLASS | The WinCC OA "_alert_hdl.._class" attribute | VARCHAR2(4000) |
ALERT_FONT_STYLE | The WinCC OA "_alert_hdl.._alert_font_style" attribute | VARCHAR2(4000) |
ALERT_FORE_COLOR | The WinCC OA "_alert_hdl.._alert_fore_color" attribute | VARCHAR2(4000) |
VALUE_STRING |
The WinCC OA "_online_value" attribute Used for the WinCC OA "string" data type. |
VARCHAR2(4000) |
TEXT1 | The WinCC OA "_alert_hdl..text1" attribute | VARCHAR2(4000) |
TEXT0 | The WinCC OA "_alert_hdl..text0" attribute | VARCHAR2(4000) |
TEXT | The WinCC OA "_alert_hdl.._text" attribute | VARCHAR2(4000) |
PANEL | The WinCC OA "_alert_hdl.._panel" attribute | VARCHAR2(4000) |
DEST_TEXT | The WinCC OA "_alert_hdl.._dest_text" attribute | VARCHAR2(4000) |
COMMENT_ | The WinCC OA "_alert_hdl.._comment" attribute | VARCHAR2(4000) |
ALERT_COLOR | The WinCC OA "_alert_hdl.._alert_color" attribute | VARCHAR2(4000) |
ABBR | The WinCC OA "_alert_hdl.._abbr" attribute | VARCHAR2(4000) |
ALIAS | The WinCC OA alias of the specific data point. | VARCHAR2(4000) |
ADD_VALUE | An "Additional value" of an alert. For information on the "additional values", see chapter Alert handling, basics. | VARCHAR2(4000) |
ELEMENT_NAME |
Complete DPE name of an element e.g.: System1:ExampleDP1.val.LastLeaf |
VARCHAR2(4000) |
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.
Column | Description | Type |
ADD_VALUE_1 bis ADD_VALUE_32 | The 32 "Additional values" of an alert. For information on the "additional values", see chapter Alert handling, basics. | VARCHAR2(4000) |
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.