---
title: "Standard filters"
id: "standard-filters"
project: "EHR User Guide"
url: "https://help.cloud5.com.au/articles/ehr-user-guide/standard-filters"
updated: 2026-10-19T00:53:25Z
---

# Standard filters

Here is a list of some of the standard filters EmpowerHR provides. The list is not exhaustive. A complete and current set of filters is only available from within Query Manager itself.

| **Code** | **Filter name** | **Filter type** | **Purpose** |
| --- | --- | --- | --- |
| 0001 | Current Tax Records | Frequently used | Restrict the employee tax records to the current details only |
| 0002 | Current Regular Transactions | Frequently used | Restrict the employee regular transaction records to the current details only |
| 0003 | Current Regular Allowances | Frequently used | Restrict the employee regular allowance records to the current details only |
| 0004 | Current Superannuation Records | Frequently used | Restrict the employee superannuation records to the current details only |
| 0005 | Current Employment Records | Frequently used | Restrict the employment records to the current details only |
| 0006 | Current Position Records | Frequently used | Restrict the position records to the current details only |
| 0007 | Last Pay Date | Frequently used | Return payroll information as at the last completed pay date |
| 0008 | Currently Employed | Frequently used | Restrict people to those who are currently employed (status code beginning with **e**) |
| 0009 | Terminated Employees | Frequently used | Restrict people to those who are terminated (status code beginning with **t** or **g**) |
| 0010 | Vacant Positions | Match | Return positions that are vacant as at the selected date |
| 0011 | Filled Positions | Frequently used | Exclude positions that are vacant as at the selected date |
| 0012 | Exclude Abolished Positions | Frequently used | Exclude positions that are abolished as at the selected date |
| 0013 | Abolished Positions Only | Frequently used | Exclude positions that are not abolished as at the selected date |
| 0014 | Bookings Only | Frequently used | Return leave bookings only |
| 0015 | Accruals Only | Frequently used | Return leave accruals only |
| 0016 | Bookings Only | Frequently used | Return LSL ![](/resources/Storage/ehr-user-guide/icons/info%20icon%20-%20small.png) bookings onlyLSL = Long Service Leave |
| 0017 | Accruals Only | Frequently used | Return LSL accruals only |
| 0018 | Substantive Employment Records | Frequently used | Restrict the employment records to the substantive details only |
| 0019 | Acting Employment Records | Frequently used | Restrict the employment records to the acting details only |
| 0020 | Date Effective Employment Records | Match | Restrict the employment records to the entered effective date |
| 0021 | Employee Code | Match | Return records associated with the employee code entered |
| 0022 | Position Number | Match | Return records associated with the position number entered |
| 0023 | Date Effective Tax Records | Match | Restrict the employee tax records to the effective date entered |
| 0024 | Date Effective Regular Transactions | Match | Restrict the employee regular transaction records to the effective date entered |
| 0025 | Date Effective Regular Allowances | Match | Restrict the employee regular allowance records to the effective date entered |
| 0026 | Date Effective Superannuation Records | Match | Restrict the employee superannuation records to the effective date entered |
| 0027 | Date Effective Position Records | Match | Restrict the position records to the effective date entered |
| 0028 | Employee Name | Match | Return records associated with the employee name entered |
| 0029 | Position Title | Match | Return records associated with the position title entered |
| 0030 | Leave Type & Code | Match | Return details for the leave type and code entered |
| 0031 | LSL Type & Code | Match | Return details for the LSL type and code entered |
| 0032 | Payroll Code & Pay Date | Match | Return payroll information for the entered payroll code and pay date |
| 0033 | Last Pay Date | Frequently used | Return payment information as at the last completed pay date |
| 0034 | Payroll Code & Pay Date | Match | Return payment information for the entered payroll code and pay date |
| 0035 | Sick Leave Only | Frequently used | Return sick leave transactions only |
| 0036 | Recreation Leave Only | Frequently used | Return recreation leave transactions only |
| 0037 | LWOP Only | Frequently used | Return LWOP transactions only |
| 0038 | Tax Year & Pay Period No. | Match | Return payroll information for the entered tax year and pay period number |
| 0039 | Payments Made Between Two Dates | Match | Return payroll information for payments made between two entered pay dates |
| 0040 | Tax Year & Pay Period No. | Match | Return payment information for the entered tax year and pay period number |
| 0041 | Payments Between Two Dates | Match | Return payment information for payments made between two entered dates |
| 0042 | External Trainees | Frequently used | Restrict people to external trainees |
| 0043 | Non-Employees | Frequently used | Restrict people to non-employees (paid and unpaid) |
| 0044 | Non-Employees (Paid) | Frequently used | Restrict people to paid non-employees |
| 0045 | Non-Employees (Unpaid) | Frequently used | Restrict people to unpaid non-employees |
| 0046 | Payments Effective Between Two Dates | Match | Return payroll information where the relevant pay period is between two entered dates |
| 0047 | Payments Effective Between Two Dates | Match | Return payment information where the relevant pay period is between two entered dates |
| 0048 | Tax Year | Match | Return payroll information for the entered tax year |
| 0049 | Tax Year | Match | Return payment information for the entered tax year |
| 0050 | Payments Only | Frequently used | Return payroll information where pay type is **p** |
| 0051 | Allowances Only | Frequently used | Return payroll information where pay type is **a** |
| 0052 | Deductions Only | Frequently used | Return payroll information where pay type is **d** |
| 0053 | Tax Only | Frequently used | Return payroll information where pay type is**t** |
| 0054 | Benefits Only | Frequently used | Return payroll information where pay type is**x** |
| 0055 | Gross Pay (Including Benefits) | Frequently used | Return payroll information where pay type is **p**, **a**, or **x** |
| 0056 | Gross Pay (Excluding Benefits) | Frequently used | Return payroll information where pay type is **p**, or **a** |
| 0057 | Before Tax Payments | Frequently used | Return payroll information where the **After Tax** flag is set to **n** |
| 0058 | After Tax Payments | Frequently used | Return payroll information where the **After Tax** flag is set to **y** |
| 0059 | Cost Centre Code | Match | Return details of payments made against the entered cost centre code |
| 0060 | Payments Only | Frequently used | Return payroll information where pay type is **p** |
| 0061 | Allowances Only | Frequently used | Return payroll information where pay type is **a** |
| 0062 | Deductions Only | Frequently used | Return payroll information where pay type is **d** |
| 0063 | Tax Only | Frequently used | Return payroll information where pay type is **t** |
| 0064 | Benefits Only | Frequently used | Return payroll information where pay type is **x** |
| 0065 | Gross Pay (Including Benefits) | Frequently used | Return payroll information where pay type is **p**, **a**, or **x** |
| 0066 | Gross Pay (Excluding Benefits) | Frequently used | Return payroll information where pay type is **p**, or **a** |
| 0067 | Before Tax Payments | Frequently used | Return payroll information where the **After Tax** flag is set to **n** |
| 0068 | After Tax Payments | Frequently used | Return payroll information where the **After Tax** flag is set to **y** |
| 0069 | Cost Centre Code | Match | Return details of payments made against the entered cost centre code |
| 0070 | Payments Made This Financial Year | Frequently used | Return payroll information where the pay day is in the current financial year |
| 0071 | Payments Made This Calendar Year | Frequently used | Return payroll information where the pay day is in the current calendar year |
| 0072 | Payments This Financial Year | Frequently used | Return payment information where the pay day is in the current financial year |
| 0073 | Payments This Calendar Year | Frequently used | Return payment information where the pay day is in the current calendar year |
| 0074 | Payments Effective This Financial Year | Frequently used | Return payroll information where the relevant pay period is in the current financial year |
| 0075 | Payments Effective This Calendar Year | Frequently used | Return payroll information where the relevant pay period is in the current calendar year |
| 0076 | Payments Effective This Financial Year | Frequently used | Return payment information where the relevant pay period is in the current financial year |
| 0077 | Payments Effective This Calendar Year | Frequently used | Return payment information where the relevant pay period is in the current calendar year |
| 0078 | Employment Records 12 Months Ago | Frequently used | Restrict the employment records to those effective 1 year ago today |
| 0079 | Employment Records - 31st December | Frequently used | Restrict the employment records to those effective at 31 December last year |
| 0080 | Employment Records - 30th June | Frequently used | Restrict the employment records to those effective at the previous 30 June |
| 0081 | Employment Records - 1st January | Frequently used | Restrict the employment records to those effective at 1 January this year |
| 0082 | Position Records 12 Months Ago | Frequently used | Restrict the position records to those effective 1 year ago today |
| 0083 | Position Records - 31st December | Frequently used | Restrict the position records to those effective at 31 December last year |
| 0084 | Position Records - 30th June | Frequently used | Restrict the position records to those effective at the previous 30 June |
| 0085 | Position Records - 1st January | Frequently used | Restrict the position records to those effective at 1 January this year |
| 0086 | Payments Made Last Financial Year | Frequently used | Return payroll information where the pay day is in the previous financial year |
| 0087 | Payments Made Last Calendar Year | Frequently used | Return payroll information where the pay day is in the previous calendar year |
| 0088 | Payments Effective Last Financial Year | Frequently used | Return payroll information where the relevant pay period is in the previous financial year |
| 0089 | Payments Effective Last Calendar Year | Frequently used | Return payroll information where the relevant pay period is in the previous calendar year |
| 0090 | Payments Last Financial Year | Frequently used | Return payment information where the pay day is in the previous financial year |
| 0091 | Payments Previous Calendar Year | Frequently used | Return payment information where the pay day is in the previous calendar year |
| 0092 | Payments Effective Last Financial Year | Frequently used | Return payment information where the relevant pay period is in the previous financial year |
| 0093 | Payments Effective Last Calendar Year | Frequently used | Return payment information where the relevant pay period is in the previous calendar year |
| 0094 | Exclude Future Transactions | Frequently used | Exclude any leave bookings and accruals that have not yet occurred |
| 0095 | Transactions This Calendar Year | Frequently used | Return leave bookings and accruals that commenced during the current year |
| 0096 | Exclude Future Transactions | Frequently used | Exclude any LSL bookings and accruals that have not yet occurred |
| 0097 | Transactions This Calendar Year | Frequently used | Return LSL bookings and accruals that commenced during the current year |
| 0098 | Course Code | Match | Return details for the entered training course |
| 0099 | Course Name | Match | Return details for the entered training course |
| 0100 | Course Code & Number | Match | Return details for the entered training course |
| 0101 | Future Courses | Frequently used | Return details for training courses that commence in the future |
| 0102 | Course Status | Match | Return details for training courses with the entered status code |
| 0103 | Incident Number | Match | Return details for the entered incident number |
| 0104 | Incidents This Year | Frequently used | Return details for all OH&S ![](/resources/Storage/ehr-user-guide/icons/info%20icon%20-%20small.png)incidents that occurred this yearOH&S = Occupational Health and Safety |
| 0105 | Incidents This Financial Year | Frequently used | Return details for all OH&S incidents that occurred this financial year |
| 0106 | Incidents Last Year | Frequently used | Return details for all OH&S incidents that occurred last year |
| 0107 | Incidents Last Financial Year | Frequently used | Return details for all OH&S incidents that occurred last financial year |
| 0108 | Cause of Incident | Match | Return details for all OH&S incidents that match the entered cause code |
| 0109 | Recruitment Code | Match | Return details for all vacancies that match the entered recruitment code |
| 0110 | Position Number | Match | Return details for all vacancies for the entered position number |
| 0111 | Recruitment Status | Match | Return details for all vacancies that match the entered recruitment status |
| 0112 | Vacancies in Past 12 Months | Frequently used | Return details for all vacancies for the previous 12 months |
| 0113 | Vacancies in Past Month | Frequently used | Return details for all vacancies for the previous month |
| 0114 | Vacancies in Past 3 Months | Frequently used | Return details for all vacancies for the past 3 months |
| 0115 | Vacancies in Past 6 Months | Frequently used | Return details for all vacancies for the past 6 months |
| 0116 | Incidents in Past Month | Frequently used | Return details for all OH&S incidents that occurred in the past month |
| 0117 | Incidents in Past 3 Months | Frequently used | Return details for all OH&S incidents that occurred in the past 3 months |
| 0118 | Incidents in Past 6 Months | Frequently used | Return details for all OH&S incidents that occurred in the past 6 months |
| 0119 | Incidents in Past 12 Months | Frequently used | Return details for all OH&S incidents that occurred in the past 12 months |
| 0120 | Normal Leave Only | Frequently used | Restrict the leave balance information to the **normal** (non LSL) leave types. By default all leave types will be returned. |
| 0121 | Long Service Leave Only | Frequently used | Restrict the leave balance information to LSL. By default all leave types will be returned. |
| 0122 | Recreation Leave Only | Frequently used | Restrict the leave balance information to Recreation Leave. By default all leave types will be returned. |
| 0123 | Sick Leave Only | Frequently used | Restrict the leave balance information to Sick Leave. By default all leave types will be returned. |
| 0124 | LWOP Only | Frequently used | Restrict the leave balance information to Leave Without Pay. By default, all leave types will be returned. |
| 0125 | Leave Loading Only | Frequently used | Restrict the leave balance information to Leave Loading. By default all leave types will be returned. |
| 0126 | Recreation Leave + Leave Loading | Frequently used | Restrict the leave balance information to Recreation Leave & Leave Loading. By default all leave types will be returned. |
| 0127 | Transactions Last Calendar Year | Frequently used | Return leave bookings and accruals that commenced during the previous year |
| 0128 | Transactions Last Calendar Year | Frequently used | Return leave bookings and accruals that commenced during the previous year |
| 0129 | Personal Leave Only | Frequently used | Return personal leave transactions only |
| 0130 | Personal Leave | Frequently used | Restrict the leave balance information to Personal Leave. By default all leave types will be returned. |
| 0131 | Date Range | Match | Restrict the roster details to a date range. |
| 0132 | Sick Leave | Frequently used | Return sick leave absences only |
| 0133 | Recreation Leave | Frequently used | Return recreation leave absences only |
| 0134 | LWOP | Frequently used | Return LWOP ![](/resources/Storage/ehr-user-guide/icons/info%20icon%20-%20small.png) absences onlyLWOP = Leave Without Pay |
| 0135 | Personal Leave | Frequently used | Return personal leave absences only |
| 0136 | Long Service Leave | Frequently used | Return LSL absences only. |
| 0137 | Last Year | Frequently used | Return roster details for the previous year |
| 0138 | This Year | Frequently used | Return roster details for the current year |
| 0139 | Past 3 Months | Frequently used | Return roster details for the past 3 months |
| 0140 | Past Month | Frequently used | Return roster details for the past month |
| 0141 | Past 6 Months | Frequently used | Return roster details for the past 6 months |
| 0142 | Past 12 Months | Frequently used | Return roster details for the past 12 months |
| 0143 | Rostered On | Frequently used | Return details where the employee is rostered to work |
| 0144 | Rostered Off | Frequently used | Return details where the employee is not rostered to work |
| 0145 | On Leave | Frequently used | Return details where the employee is on leave |
| 0146 | Training | Frequently used | Return details where the employee is on a training course |
| 0147 | Public Holiday | Frequently used | Return details where the employee is not at work due to a public holiday |
| 0148 | Day of the Week | Match | Return roster details for the day of the week entered |
| 0149 | Mondays Only | Frequently used | Return roster details for Mondays only |
| 0150 | Fridays Only | Frequently used | Return roster details for Fridays only |
| 0151 | Mondays & Fridays | Frequently used | Return roster details for Mondays and Fridays only |
| 0152 | 'n' Weeks | Match | Return roster details for the number of weeks specified, starting from the date entered |
| 0153 | This Week | Frequently used | Return roster details for the current week |
| 0154 | Cost Centre | Match | Return employee records associated with the Cost Centre entered |
| 0155 | Org Unit 1 | Match | Return employee records associated with the Org Unit 1 code entered |
| 0156 | Org Unit 2 | Match | Return employee records associated with the Org Unit 2 code entered |
| 0157 | Org Unit 3 | Match | Return employee records associated with the Org Unit 3 code entered |
| 0158 | Department | Match | Return employee records associated with the Department code entered |
| 0160 | Branch | Match | Return employee records associated with the Branch code entered |
| 0161 | Section | Match | Return employee records associated with the Section code entered |
| 0162 | Location | Match | Return employee records associated with the Location code entered |
| 0163 | Employee Type | Match | Return employee records associated with the Employee type entered |
| 0164 | Employment Condition | Match | Return employee records associated with the Employment Condition entered |
| 0165 | Payroll Code | Match | Return employee records associated with the Payroll Code entered |
| 0166 | Pay Location | Match | Return employee records associated with the Pay Location code entered |
| 0167 | Award | Match | Return employee records associated with the Award code entered |
| 0168 | Classification | Match | Return employee records associated with the Classification and Level entered |
| 0169 | Salary Range | Match | Return employee records within the salary range entered |
| 0170 | Cost Centre | Match | Return position records associated with the Cost Centre entered |
| 0171 | Org Unit 1 | Match | Return position records associated with the Org Unit 1 code entered |
| 0172 | Org Unit 2 | Match | Return position records associated with the Org Unit 2 code entered |
| 0173 | Org Unit 3 | Match | Return position records associated with the Org Unit 3 code entered |
| 0174 | Department | Match | Return position records associated with the Department code entered |
| 0175 | Branch | Match | Return position records associated with the Branch code entered |
| 0176 | Section | Match | Return position records associated with the Section code entered |
| 0177 | Location | Match | Return position records associated with the Location code entered |
| 0178 | Position Type | Match | Return position records associated with the Position type entered |
| 0179 | Employment Condition | Match | Return position records associated with the Employment Condition entered |
| 0180 | Payroll Code | Match | Return position records associated with the Payroll Code entered |
| 0181 | Award | Match | Return position records associated with the Award code entered |
| 0182 | Classification | Match | Return position records associated with the Classification and Level entered |
| 0183 | Date Range | Match | Restrict the leave details to a date range |
| 0184 | Date Range | Match | Restrict the lsl details to a date range |
| 0185 | Mondays Only | Frequently used | Return leave booked on a Monday only |
| 0186 | Fridays Only | Frequently used | Return leave booked on a Friday only |
| 0187 | Last Employment Record | Frequently used | Restrict the employment records to the last one entered. Useful filter for terminated employees |
| 0188 | Pay Element | Match | Return payments where the payment code is contained in the selected pay element |
| 0189 | Normal Leave Only | Frequently used | Restrict the leave provisions information to the **normal** (non LSL) leave types. By default all leave types will be returned. |
| 0190 | Long Service Leave Only | Frequently used | Restrict the leave provisions information to LSL. By default all leave types will be returned. |
| 0191 | Recreation Leave Only | Frequently used | Restrict the leave provisions information to Recreation Leave. By default all leave types will be returned. |
| 0192 | Sick Leave Only | Frequently used | Restrict the leave provisions information to Sick Leave. By default all leave types will be returned. |
| 0193 | Leave Loading Only | Frequently used | Restrict the leave provisions information to Leave Loading. By default all leave types will be returned. |
| 0194 | Recreation Leave + Leave Loading | Frequently used | Restrict the leave provisions information to Recreation Leave and Leave Loading. By default all leave types will be returned. |
| 0195 | Exclude Sick Leave | Frequently used | Exclude Sick Leave from the leave provisions information. By default all leave types will be returned. |
| 0196 | Leave Element | Match | Return records where the leave type and code are contained in the selected leave element |
| 0197 | Leave Element | Match | Return records where the leave type and code are contained in the selected leave element |
| 0198 | Leave Element | Match | Return records where the LSL type and code are contained in the selected leave element |
| 0199 | Leave Element | Match | Return records where the leave type and code are contained in the selected leave element |
| 0200 | Project Code | Match |  |
| 0201 | Project Name | Match |  |
| 0202 | Customer | Match |  |
| 0203 | Invoice Number | Frequently used |  |
| 0204 | Invoice Date | Frequently used |  |
| 0205 | Billing Period From | Frequently used |  |
| 0206 | Billing Period To | Frequently used |  |
| 0207 | Current Resources | Frequently used |  |
| 0208 | Pay Element | Match |  |
| 0209 | Pay Element | Match |  |
| 0210 | Current Mark Up Details | Frequently used |  |
| 0211 | Date Effective Mark Up Details | Frequently used |  |
| 0212 | Leave Type & Code | Match | Return details for the leave type and code entered |
| 0213 | Sick Leave Only | Frequently used | Return sick leave transactions only |
| 0214 | Recreation Leave Only | Frequently used | Return recreation leave transactions only |
| 0215 | LWOP Only | Frequently used | Return LWOP transactions only |
| 0216 | Personal Leave Only | Frequently used | Return personal leave transactions only |
| 0217 | Leave Element | Match | Return records where the leave type and code are contained in the selected leave element |
| 0218 | LSL Type & Code | Match | Return details for the LSL type and code entered |
| 0219 | Leave Element | Match | Return records where the LSL type and code are contained in the selected leave element |
| 0220 | Transactions This Financial Year | Frequently used | Return leave bookings and accruals that commenced during the current financial year |
| 0221 | Transactions Last Financial Year | Frequently used | Return leave bookings and accruals that commenced during the previous financial year |
| 0222 | Transactions This Financial Year | Frequently used | Return LSL bookings and accruals that commenced during the current financial year |
| 0223 | Transactions Last Financial Year | Frequently used | Return leave bookings and accruals that commenced during the previous financial year |
| 0224 | Current Project Resources Only | Frequently used | Restrict the project resources to the ones that are currently active. |
| 0225 | Currently Employed (Incl. Non-Employees) | Frequently used | Restrict people to those who are currently employed (status code beginning with **e**) |
| 0227 | Last Provision Date | Frequently used | Return the Leave Provisions with the latest (Maximum) date for each employee |
| 0228 | Org Unit 1 | Match | Return records associated with the Org Unit 1 at the time of the transaction |
| 0229 | Org Unit 2 | Match | Return records associated with the Org Unit 2 at the time of the transaction |
| 0230 | Org Unit 3 | Match | Return records associated with the Org Unit 3 at the time of the transaction |
| 0231 | Department | Match | Return records associated with the Department at the time of the transaction |
| 0232 | Branch | Match | Return records associated with the Branch at the time of the transaction |
| 0233 | Section | Match | Return records associated with the Section at the time of the transaction |
| 0234 | Org Unit 1 | Match | Return records associated with the Org Unit 1 at the time of the transaction |
| 0235 | Org Unit 2 | Match | Return records associated with the Org Unit 2 at the time of the transaction |
| 0236 | Org Unit 3 | Match | Return records associated with the Org Unit 3 at the time of the transaction |
| 0237 | Department | Match | Return records associated with the Department at the time of the transaction |
| 0238 | Branch | Match | Return records associated with the Branch at the time of the transaction |
| 0239 | Section | Match | Return records associated with the Section at the time of the transaction |
| 0240 | Exclude Competencies | Frequently used | Exclude Competencies from the All Attributes selection |
| 0241 | Exclude Skills | Frequently used | Exclude Skills from the All Attributes selection |
| 0242 | Exclude Qualifications | Frequently used | Exclude Qualifications from the All Attributes selection |
| 0243 | Exclude Training | Frequently used | Exclude Training from the All Attributes selection |
| 0244 | Exclude Languages | Frequently used | Exclude Languages from the All Attributes selection |
| 0245 | Exclude Miscellaneous Attributes | Frequently used | Exclude Miscellaneous Attributes from the All Attributes selection |
| 0246 | Exclude Leave Loading | Frequently used | Exclude Leave Loading details |

| Next topic<br><br>[Standard parameters](/articles/ehr-user-guide/standard-parameters) |
| --- |

© 2023 Fusion5. All rights reserved.