Display Formats

The GAM_DISPLAYFORMAT table is used to define the alarm levels for the measured parameters of an object.

We would like to know when the values stored in the GAM_MEASUREMENT table are too low or too high. This is what the alarms are for, an indication for a state of a parameter that they have an undesired value.

This table stores an alarm display format independent of the object, its type or class. For example, different cryostats can have different alarm display formats.

The table has an attribute called DF_ALARMLOW and an attribute called DF_ALARMHIGH. They represent the low and high thresholds for the corresponding parameter specified in the OC_MEASURETYPEx attributes of the GAM_OBJECTCLASS table, where x is a number from 1 to 5 that corresponds to one of 5 display format foreign keys in either the GAM_OBJECT, GAM_OBJECTTYPE or GAM_OBJECTCLASS tables. A display format is defined for one of the five possible measurements devices can have.

When the value of a parameter is measured and it is lower than DF_ALARMLOW, an alarm will be displayed. When the value is measured and it is higher than DF_ALARMHIGH, an alarm will be displayed. The alarms are specified in percentages. In the display format table, lower and upper limits for the possible values of a measurement are defined in DF_UPPERLIMIT and DF_LOWERLIMIT. Based on these limits, the alarm percentage is specified, which corresponds to a measurement value between the lower and upper limtis.

Between the GAM_DISPLAYFORMAT and GAM_OBJECTCLASS tables there are 5 optional one-to-many relationships. A display format can be applied to multiple objects classes, and each class can have up to 5 display formats.

Between the GAM_DISPLAYFORMAT and GAM_OBJECTTYPE tables there are 5 optional one-to-many relationships. A display format can be applied to multiple objects types, and each type can have up to 5 display formats.

Between the GAM_DISPLAYFORMAT and GAM_OBJECT tables there are 5 optional one-to-many relationships. A display format can be applied to multiple objects, and each object can have up to 5 display formats.

Display formats table

Attribute name	Attribute meaning	Data type	Mandatory	Notes
DF_ID	ID of display format	Number	Yes	It is the primary key.
DF_UPPERLIMIT	The maximum possible value of the measurement	Decimal number, with a precision of 10 and a scale of 4	No
DF_LOWERLIMIT	The minimum possible value of the measurement	Decimal number, with a precision of 10 and a scale of 4	No
DF_ALARMHIGH	The percentage corresponding to a value that, if the measurement is greater, means an alarm will be triggered	Decimal number, with a precision of 10 and a scale of 4	No
DF_ALARMLOW	The percentage corresponding to a value that, if the measurement is smaller, means an alarm will be triggered	Decimal number, with a precision of 10 and a scale of 4	No
DF_RATETYPE	The type of rate used for calculating flow rate	Integer from 0 to 9	No	Rate type can be per second, per hour, etc. It is only used for gas counters. The value is 0 for no rate, 1 for per second, 2 for per minute, 3 for per hour, 4 for per day, 5 for per month (30.5 days) and 6 for per year.
DF_DECIMALPLACES	How many decimal places are displayed for the corresponding measurement	Integer from 0 to 9	No