Home > Technical > Table Definitions > 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 |
||||||||||||||||
INT |
A unique number assigned by the system. |
|||||||||||||||||
STRTYPE |
VARCHAR(20) |
Indicates the type of alert.
|
||||||||||||||||
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.
|
||||||||||||||||
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.
|
||||||||||||||||
INT |
You can do a comparison on the alert data to see whether an alert message should be sent or not.
|
|||||||||||||||||
INTCHECKCOMPARISON |
INT |
Indicates the type of comparison to be made for the INTCHECKFIELD field.
|
||||||||||||||||
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.
|
||||||||||||||||
STRALERTTYPE |
VARCHAR(10) |
Indicates the type of alert.
|
||||||||||||||||
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
|
||||||||||||||||
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) |