DSC_ALMLISTCOLS table

 images\btn_mini.gif  Notation

Summary

This table contains properties for the columns in the alarm list descriptors.

Field name

SQL type

Description

DESCINDEX

INTEGER

Unique number of the descriptor.

IDX

INTEGER

Index of this column (0-based). Defines also the column order shown in the alarm list.

COLTYPE

INTEGER

The type of this column. Each column type from 1 to 19 appears exactly once for each alarm list.

1 = Begin date
2 = Begin time
3 = Ack time
4 = End time
5 = Object name
6 = Worst value
7 = Alarm text
8 = Area name
9 = Object description
10 = Value
11 = Priority
12 = Alarm number
13 = Ack date
14 = End date
15 = Alarm state
16 = Driver
17 = Node number
18 = Serial number
19 = User

SORTSEQUENCE

INTEGER

A value between 1 and 19 specifying the columns number in the sort sequence. Records are first sorted by column “1”, then by column “2”, and so on. A positive value specifies ascending sort order, a negative value specifies descending sort order for that column.

WIDTH

INTEGER

The width in pixels of the column.

TEXT

CHAR (256)

The title of the column.

ACTIVE

INTEGER

1 if the column is shown, 0 if not.


 
See Also