POS Transaction Analyzer User and Installation Guide, SST Version 1.2

Appendix G 163
Field Name Field Type Description
PercentNetUnavailErrors Integer Percent net unavailable errors
PercentUnableToAuthErrors Integer Percent unable to authenticate errors
HighestResponseTime Integer Maximum response time
RepeatedDenials Integer Consecutive denials
Year Integer Year part of the current Stat time.
Month Integer Month part of the current Stat time.
Day Integer Day part of the current Stat time.
Hour Integer Hour part of the current Stat time.
Minute Integer Minute part of the current Stat time.
Operator Reference
The following operators can be used within expressions:
Operator Description
= Equal To
< Less Than
> Greater Than
<= Less Than Or Equal To
>= Greater Than Or Equal To
!= Not Equal To
and Logical And
or Logical Or
NOTE: The functions defined in the threshold expression should be placed within parenthesis [ ] and the field
should be placed within “% %”. The return value of the function should be an Integer, Float or a String only.
For example [getApproval(%TotalTransactions%)]>2000.
For creating threshold expressions, SQL functions can also be used along with the standard parameters.
For example
FN_UNEXPECTED_DOWNFLOW_OF_TRANS_COUNT(%EntityCode%,%TotalTransactions%) > 2000
The above function considers the EntityCode and TotalTransactions as parameters and check if, the difference
between TotalTransactions Count of the Last Interval and the Present Interval for an entity is > 2000.
All alert formatting parameters can be used as parameters for creating threshold expressions using SQL
functions.
Appendix G