Home > Technical > Table Definitions > ALERTMSGDATA

ALERTMSGDATA

Superceded by MICROS Alerts Engine.

This table stores a record for each alert used by the Alert Service. The contacts to which the alert message will be sent are stored in ALERTMSGCONTACT.

Column

Type

Description

INTMSGNUM

INT

A unique number assigned by the system.

STRTYPE

VARCHAR(20)

Indicates the type of alert.

SQL  

An SQL statement.

SYSTEMCHECK  

Indicates we want to run the System Check process.

RESULT PROCEDURE  

A stored procedure that will return a result set.

COMMAND PROCEDURE  

A stored procedure that executes a command and does not return a result set.

MEMSQL

TEXT

 The SQL statement to be performed.
STRDESCRIPTION VARCHAR(50) A description about the alert.
INTHOUR INT Not currently used.
STRPARAM1 VARCHAR(20) A parameter to be used when running the query. This can be something like $END_NEXT_WEEK, $TODAY, and so on.
STRPARAM2 VARCHAR(20) A parameter to be used when running the query.
STRPARAM3 VARCHAR(20) A parameter to be used when running the query.
STRPARAM4 VARCHAR(20) A parameter to be used when running the query.
STRPARAM5 VARCHAR(20) A parameter to be used when running the query.
STRPARAM6 VARCHAR(20) A parameter to be used when running the query.
STRPARAM7 VARCHAR(20) A parameter to be used when running the query.
STRPARAM8 VARCHAR(20) A parameter to be used when running the query.
STRPARAM9 VARCHAR(20) A parameter to be used when running the query.
STRPARAM10 VARCHAR(20) A parameter to be used when running the query.
STRPARAM11 VARCHAR(20) A parameter to be used when running the query.
STRPARAM12 VARCHAR(20) A parameter to be used when running the query.
STRPARAM13 VARCHAR(20) A parameter to be used when running the query.
STRPARAM14 VARCHAR(20) A parameter to be used when running the query.
STRPARAM15 VARCHAR(20) A parameter to be used when running the query.
YSNDAY1 VARCHAR(1) 'T' if the alert should be run on Sunday.
YSNDAY2 VARCHAR(1) 'T' if the alert should be run on Monday.
YSNDAY3 VARCHAR(1) 'T' if the alert should be run on Tuesday.
YSNDAY4 VARCHAR(1) 'T' if the alert should be run on Wednesday.
YSNDAY5 VARCHAR(1) 'T' if the alert should be run on Thursday.
YSNDAY6 VARCHAR(1) 'T' if the alert should be run on Friday.
YSNDAY7 VARCHAR(1) 'T' if the alert should be run on Saturday.
INTSCHEDTYPE INT Indicates how often the alert should be run.
0   Every x Minutes
1   Every x Hours
2   Specified Minutes
3   Specified Hours
4   Specified Times

INTINTERVAL

INT

If INTSCHEDTYPE = 0, this is the number of minutes. If INTSCHEDTYPE = 1, this is the number of hours.

STRINTERVALS

VARCHAR(100)

This is a comma-delimited list of values. Its list depends on the value of INTSCHEDTYPE. If 2, then a list of minutes, for example 0,20,40. If 3, then a list of hours, for example 0, 3, 6, 9, 12, 15, 18, 21. If 4, then a list of specific times (in 24 hour format), for example 11:30, 14:30.

STRHEADERMESSAGE

VARCHAR(500)

The text which will be displayed as the start of the message sent to the user. Usually describes what the alert data represents.

INTPRIORITY

INT

The priority of the alert. This effects the email priority, not the actual running of the alert.

0  

Normal

1  

High

INTCHECKFIELD

INT

You can do a comparison on the alert data to see whether an alert message should be sent or not.

0  

If the results data has more than 0 rows, an alert message should be sent. This is the default behaviour.

1  

Compare the 1st query field to a value. If the comparison passes, an alert message will be sent.

2  

Compare the 2nd query field to a value. If the comparison passes, an alert message will be sent.

3  

Compare the 3rd query field to a value. If the comparison passes, an alert message will be sent.

4  

Compare the 4th query field to a value. If the comparison passes, an alert message will be sent.

INTCHECKCOMPARISON

INT

Indicates the type of comparison to be made for the INTCHECKFIELD field.

0  

=

1  

<>

2  

<

3  

<=

4  

>

5  

>=

STRCOMPARISONVALUE

VARCHAR(50)

The value to which the data from INTCHECKFIELD data needs to be compared.

STRFORMAT

VARCHAR(5)

Indicates how the alert results should be formatted.

EMAIL  

Plain Email. Creates a plain text email.

HTML  

HTML Email. Creates a HTML email.

POS BE

POS BE Messaging. Creates a message which will be sent via POS BE messaging.

SMS  

SMS. Sends alert as an SMS.

BLACK  

Blackberry. Creates an email suitable for reading on a limited Blackberry screen.

STAT  

Status Message. Generates a status which can appear in the status area of Main Menu.

XML  

XML. Generates an XML file which can be used by the digital dashboard.

GRAPH  

Graph. Generates the data as a graph which can be used by the digital dashboard.

STRALERTTYPE

VARCHAR(10)

Indicates the type of alert.

INFO  

Information

WARN  

Warning

URGENT  

Urgent
INTHEIGHT INT The height (in pixels) of the picture that will be generated for a graph.
INTWIDTH INT The width (in pixels) of the picture that will be generated for a graph.
STRFONTNAME VARCHAR(50) The name of the font for the graph.
INTFONTSIZE INT The size of the font for the graph.
YSNFONTBOLD VARCHAR(1) 'T' if the font should be bold.
YSNFONTITALIC VARCHAR(1) 'T' if the font should be italic.
YSNFONTUNDERLINE VARCHAR(1) 'T' if the font should be underlined.
INTFONTCOLOUR INT The colour of the font.
INTBACKGROUNDCOLOUR INT The colour of the background of the graph.
YSNTRANSPARENT VARCHAR(1) 'T' if the background of the graph should be transparent.
STRSERIESCOLOUR VARCHAR(250) A comma-delimited list of numbers. Each number is the colour in which a series should be displayed. A series is each data in a bar chart, for example SUM(CURSALES), SUM(CURCOGS) would be two series.
INTGRAPHTYPE INT Type of graph
0   Bar Chart
1   Pie Chart
YSNACTIVE VARCHAR(1) 'T' if the alert is active and can be used by the Alert Service.

 

Primary Key: INTMSGNUM

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)