Summary

This makeup table records a summary of all employee appointments in an organisation.

Source entity

Employees - Appointments

Queries

Use a query to report on specific information. For example, all employee appointments for a department.

Formula

You can use a formula to test any value in an Employee Appointments record. You can use this formula in Daily View on the Quick Results tab or on an Award Rules | Qualifying Clauses tab.

Quick Results

This example uses the formula on the Quick Results tab to test the Employee Appointments | Full time equivalent (FTE) value.

1. In Daily View, create a customized employee column.
2. Customise Column Extensions for the new employee column.

   This example will create a result for all employees that have Employee Appointment FTE = 1.0.

3. In Results | Quick Results, right-click to see the menu and click Edit Formula.
4. Enter the following data:

   Display: Employee Appointment FTE is equal to 1.0

   Formula: oMEM(NIxEmplAppointmentField({‘FTE’}),{‘1.0’})

5. Set up the Results | Details tab to create a light green background for employees that have Employee Appointment FTE = 1.0.

In Daily View, the customized employee column now has a light green background for employees with FTE = 1.0

Award Rule Qualifying Clause

This example uses the formula on an Award Rule | Qualifying Clauses tab to test the Employee Appointments | Full time equivalent (FTE) value.

1. On the Award Rules | Qualifying Clauses tab, right-click to see the menu and click Edit Formula.
2. Enter the following data:

   Display: Employee Appointment FTE is equal to 1.0

   Formula: oMEM(NIxEmplAppointmentField({‘FTE’}),{‘1.0’})

3. On the Award Rules | Action Clauses tab, create the following clause:

   Create critical result Appointment FTE = 1.0 with legend FT

4. Attach the award to the required periods.
5. Process Actuals.

The award creates a critical result in the audit log for every employee with FTE = 1.0.

Extra functionality

The Customise Columns right-click menu option enables you to display additional columns in the grid.

The Generate GRID Report right-click menu option enables you to create a report based on information displayed in the grid.