Applies to versions: 2.1, 2.2, 2.3, 2.4, 2.5, 3.0, 3.1, 3.2, 3.3

Audit Alert Expressions

This article explains the ability to customize when an Audit Alert is sent.

Purpose of Expressions

When TimeIPS processes audits, it will look for any alerts to trigger. With expressions you can apply custom logic for if the alert should be sent.

Defining Payroll Items With Expressions

To use custom logic you must define the expression in the "Expression" field for that Audit Alert. Expressions must start with an equals sign '='. They provide a single line of code that is evaluated and returns TRUE or FALSE.

Supported Functions

Audit Alert expressions utilize the same expression parser as Custom Reports. As such the same functions are available. The list of functions is available at this article.

Available Variables

The following information is available

Variable Name	Description
[usersID]	This is the unique database ID of the employee whose event was audited.
[divisionID]	This is the unique database ID of the division of the employee whose event was audited.
[eventLogID]	This is the unique database ID of the event that was audited.
[adjTimeIn]	This is the adjusted time in of the event after the audit has taken place.
[adjTimeOut]	This is the adjusted time out of the event after the audit has taken place.
[audit_time]	This is the Unix timestamp of when the audit was made. Convert this with the utcdate function.
[audit_part]	This is the part of the event that was audited, either 'in', 'out', or 'event'
[audit_eventAction]	This is the action on the event that was audited, either 'create', 'edit', or 'delete'

Examples

To send audit alerts in all cases:

To send audit alerts only for time events that are deleted:

=if([audit_eventAction]="delete",1,0)

To send audit alerts only for hourly employees:

=if(getUserSalaryTypeAtTime([usersID], [adjTimeIn])="Hourly",1,0)

©2004-2023 TimeIPS, Inc. All Rights Reserved - TimeIPS and the TimeIPS logo are registered trademarks of TimeIPS, Inc.
"Intelligent Personnel System" "Run your Business. We'll watch the clock." are trademarks of TimeIPS, Inc.
TimeIPS is protected by one or more patents. Patent No. US 7,114.684 B2.