Page Comparison

Snap 1

Add and configure an Exact Online Read Snap to query Payroll - Employments data. 

Select EndDate, Employee, EmployeeHID and ID fields under the Output Field Selection field set.

All records of Employments data from the ExactOnline API.

Snap 2, 3

Add two Filter Snaps to filter employees that are no longer active and employees that need to be excluded (based on requirements). 

Filter expression for non-active members:
$EndDate == null || (($EndDate.replace("/Date(","").replace(")/","")) > Date.now().getTime())

Filter expression for excluded members:
_EmployeesExcluded.indexOf($EmployeeHID) == -1

All records of active Employees.

Snap 4

Add and configure an Exact Online Read Snap to query Payroll - Employees data. 

Filter EmployeeHID using the Filter Records field set.
Select ID and EmployeeHID fields using the Output Field Selection field set.

All records of active Employees data from the ExactOnline API.

Snap 5

Add a Mapper Snap to map the ID as $Employee.

Map the $ID with $Employee.

Data of all IDs of active employees.

Snap 6

Add and configure an Exact Online Read Snap to query Project - TimeTransactions data. 

Filter Employee field using the Filter Records field set and filter the Date field to only return data for the last 5 weeks. Select Employee, Quantity, HourStatus, Date, Created, and Project fields using Output Field Selection field set.

TimeTransactions data of active employees from ExactOnline API.

Snap 7

Add a Router Snap to route the hours based on their status. 

Add four output views in the Router Snap.

Routes the output from the upstream Snap to four output views.

Snap 8,17, 18, 19

Add three Aggregate Snaps and one Mapper Snap for each status of the hours, summing up the number of hours grouped per employee.

• Booked hours (status 10 & 20)

• Rejected Hours (status 2)

• Drafted Hours (status 1)

• No Hours (no status)

For the three Aggregate Snaps configure the settings as follows:

• Function: SUM

• Field: $Quantity

• Result field:

  • HoursBooked(10 --and 20)

  • HoursRejected(2)

  • HoursDrafted(1)

GROUP-BY fields

• Field

  • $Employee

  • $original.EmployeeHID

• Output field

  • Employee

  • EmployeeHID

For the output3 (an employee has booked no hours at all), add the child pipeline (Snap 20) to process the no hours notification.

Image Modified

Learn more, Send email notifications to employees and their managers who do not book any hour.

Employee and EmployeeHID data based on the group by result.

Snap 9, 10, 11, 12, 13

Add a Union Snap, Group by N Snap, JSON Splitter snap, Sort Snap and Group by Fields Snap.

Combine the output from the different routes (HourStatuses) and create an overview per employee.

Combined data of Employee and EmployeeHID with fields of HoursBooked(10 --and 20), HoursRejected(2), HoursDrafted(1).

Snap 14

Add the child Pipeline Booked Hours Notifications - Check Hours to check the scheduled hours. Learn more, Check the scheduled hours.

The data of employeeID with fields of different hour types (HoursBooked, HoursDrafted, HoursRejected, AverageHours, ContractHours).

Snap 15

Add the child Pipeline Booked Hours Notifications - Send Email to send notifications via email. Learn more,Send emails to employees who don't book enough hours and their managers.

Response Data of email sending result from Pipeline 

Learn more, Send emails to employees who don't book enough hours and their managers.

Snap 16

Finally add a join snap to merge the response from email sending child Pipelines.

Joined result data of child Pipelines Send emails to employees and their managers who do not book any hours.

Send emails to employees and their managers who do not book enough hours .