Filters
Some packages include data filters as well as query subjects. This table lists all filters that are included in all packages.
Filter | Comments |
---|---|
Ad-Hoc Shifts | |
In Last 24 Hours | This is calculated by filtering Work Day > Work Date between the Yesterday and Current timestamp calculations in the model. |
In Last Month | This is calculated by filtering Work Day > Work Date between the 1 Month Ago and Current timestamp calculations in the model. |
In Last Week | This is calculated by filtering Work Day > Work Date between the 7 Days Ago and Current timestamp calculations in the model. |
In Last Year | This is calculated by filtering Work Day > Work Date between the 1 Year Ago and Current timestamp calculations in the model. |
Is Detail Record | This filter is based on the Work > Work Detail Type value of 'D', which denotes a detail work record. |
Is Premium Record | This filter is based on the Work > Work Detail Type value of 'P', which denotes a premium work record. |
Join for SecEmp Temp Team Assignments | |
Join for Temp Team Assignments | |
Master Rotation Shifts | |
One Time Schedule Shifts | |
Paid | |
Since Beginning of Calendar Year | This is calculated by filtering Work Day > Work Date between the Beginning of Year and Current timestamp calculations in the model. |
Since Start of Month | This is calculated by filtering Work Day > Work Date between the Start of Month and Current timestamp calculations in the model. |
Since Start of Week | This is calculated by filtering Work Day > Work Date between the Start of Week and Current timestamp calculations in the model. |
Unpaid |