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 nameFilter type
Purpose
0001Current Tax RecordsFrequently used
Restrict the employee tax records to the current details only
0002Current Regular TransactionsFrequently used
Restrict the employee regular transaction records to the current details only
0003Current Regular Allowances Frequently used
Restrict the employee regular allowance records to the current details only
0004Current Superannuation RecordsFrequently used
Restrict the employee superannuation records to the current details only
0005Current Employment Records Frequently used
Restrict the employment records to the current details only
0006Current Position RecordsFrequently used
Restrict the position records to the current details only
0007Last Pay DateFrequently used
Return payroll information as at the last completed pay date
0008Currently EmployedFrequently used
Restrict people to those who are currently employed (status code beginning with e)
0009Terminated Employees Frequently used
Restrict people to those who are terminated (status code beginning with t or g)
0010Vacant Positions Match
Return positions that are vacant as at the selected date
0011Filled Positions Frequently used
Exclude positions that are vacant as at the selected date
0012Exclude Abolished PositionsFrequently used
Exclude positions that are abolished as at the selected date
0013Abolished Positions OnlyFrequently used
Exclude positions that are not abolished as at the selected date
0014Bookings OnlyFrequently used
Return leave bookings only
0015Accruals OnlyFrequently used
Return leave accruals only
0016Bookings OnlyFrequently used
Return LSL  bookings only

LSL = Long Service Leave

0017Accruals OnlyFrequently used
Return LSL accruals only
0018Substantive Employment RecordsFrequently used
Restrict the employment records to the substantive details only
0019Acting Employment RecordsFrequently used
Restrict the employment records to the acting details only
0020Date Effective Employment RecordsMatch
Restrict the employment records to the entered effective date
0021Employee CodeMatch
Return records associated with the employee code entered
0022Position NumberMatch
Return records associated with the position number entered
0023Date Effective Tax Records Match

Restrict the employee tax records to the effective date entered
0024Date Effective Regular TransactionsMatch

Restrict the employee regular transaction records to the effective date entered
0025Date Effective Regular AllowancesMatch

Restrict the employee regular allowance records to the effective date entered
0026Date Effective Superannuation Records Match

Restrict the employee superannuation records to the effective date entered
0027Date Effective Position Records Match
Restrict the position records to the effective date entered
0028Employee NameMatch
Return records associated with the employee name entered
0029Position TitleMatch
Return records associated with the position title entered
0030Leave Type & CodeMatch
Return details for the leave type and code entered
0031LSL Type & CodeMatch

Return details for the LSL type and code entered
0032Payroll Code & Pay DateMatch
Return payroll information for the entered payroll code and pay date
0033Last Pay DateFrequently used
Return payment information as at the last completed pay date
0034Payroll Code & Pay DateMatch
Return payment information for the entered payroll code and pay date
0035Sick Leave OnlyFrequently used
Return sick leave transactions only
0036Recreation Leave OnlyFrequently used
Return recreation leave transactions only
0037LWOP OnlyFrequently used
Return LWOP transactions only
0038Tax Year & Pay Period No.Match
Return payroll information for the entered tax year and pay period number
0039Payments Made Between Two Dates Match
Return payroll information for payments made between two entered pay dates
0040Tax Year & Pay Period No.Match
Return payment information for the entered tax year and pay period number
0041Payments Between Two Dates Match
Return payment information for payments made between two entered dates
0042External TraineesFrequently used
Restrict people to external trainees
0043Non-EmployeesFrequently used
Restrict people to non-employees (paid and unpaid)
0044Non-Employees (Paid) Frequently used
Restrict people to paid non-employees
0045Non-Employees (Unpaid)Frequently used
Restrict people to unpaid non-employees
0046Payments Effective Between Two DatesMatch
Return payroll information where the relevant pay period is between two entered dates
0047Payments Effective Between Two DatesMatch
Return payment information where the relevant pay period is between two entered dates
0048Tax YearMatch
Return payroll information for the entered tax year
0049Tax YearMatch
Return payment information for the entered tax year
0050Payments OnlyFrequently used
Return payroll information where pay type is p
0051Allowances OnlyFrequently used
Return payroll information where pay type is a
0052Deductions OnlyFrequently used
Return payroll information where pay type is d
0053Tax OnlyFrequently used
Return payroll information where pay type is t
0054Benefits OnlyFrequently used
Return payroll information where pay type is x
0055Gross Pay (Including Benefits)Frequently used
Return payroll information where pay type is p, a, or x
0056Gross Pay (Excluding Benefits)Frequently used
Return payroll information where pay type is p, or a
0057Before Tax PaymentsFrequently used
Return payroll information where the After Tax flag is set to n
0058After Tax PaymentsFrequently used
Return payroll information where the After Tax flag is set to y
0059Cost Centre Code Match
Return details of payments made against the entered cost centre code
0060Payments OnlyFrequently used
Return payroll information where pay type is p
0061Allowances OnlyFrequently used
Return payroll information where pay type is a
0062Deductions OnlyFrequently used
Return payroll information where pay type is d
0063Tax OnlyFrequently used
Return payroll information where pay type is t
0064Benefits OnlyFrequently used
Return payroll information where pay type is x
0065Gross Pay (Including Benefits)Frequently used
Return payroll information where pay type is p, a, or x
0066Gross Pay (Excluding Benefits)Frequently used
Return payroll information where pay type is p, or a
0067Before Tax PaymentsFrequently used
Return payroll information where the After Tax flag is set to n
0068After Tax PaymentsFrequently used
Return payroll information where the After Tax flag is set to y
0069Cost Centre Code Match
Return details of payments made against the entered cost centre code
0070Payments Made This Financial YearFrequently used
Return payroll information where the pay day is in the current financial year
0071Payments Made This Calendar YearFrequently used
Return payroll information where the pay day is in the current calendar year
0072Payments This Financial YearFrequently used
Return payment information where the pay day is in the current financial year
0073Payments This Calendar YearFrequently used
Return payment information where the pay day is in the current calendar year
0074Payments Effective This Financial YearFrequently used
Return payroll information where the relevant pay period is in the current financial year
0075Payments Effective This Calendar Year Frequently used
Return payroll information where the relevant pay period is in the current calendar year
0076Payments Effective This Financial YearFrequently used
Return payment information where the relevant pay period is in the current financial year
0077Payments Effective This Calendar Year Frequently used
Return payment information where the relevant pay period is in the current calendar year
0078Employment Records 12 Months AgoFrequently used
Restrict the employment records to those effective 1 year ago today
0079Employment Records - 31st DecemberFrequently used
Restrict the employment records to those effective at 31 December last year
0080Employment Records - 30th JuneFrequently used
Restrict the employment records to those effective at the previous 30 June
0081Employment Records - 1st JanuaryFrequently used
Restrict the employment records to those effective at 1 January this year
0082Position Records 12 Months AgoFrequently used
Restrict the position records to those effective 1 year ago today
0083Position Records - 31st DecemberFrequently used
Restrict the position records to those effective at 31 December last year
0084Position Records - 30th JuneFrequently used
Restrict the position records to those effective at the previous 30 June
0085Position Records - 1st JanuaryFrequently used
Restrict the position records to those effective at 1 January this year
0086Payments Made Last Financial YearFrequently used
Return payroll information where the pay day is in the previous financial year
0087Payments Made Last Calendar YearFrequently used
Return payroll information where the pay day is in the previous calendar year
0088Payments Effective Last Financial YearFrequently used
Return payroll information where the relevant pay period is in the previous financial year
0089Payments Effective Last Calendar Year Frequently used
Return payroll information where the relevant pay period is in the previous calendar year
0090Payments Last Financial YearFrequently used
Return payment information where the pay day is in the previous financial year
0091Payments Previous Calendar Year Frequently used
Return payment information where the pay day is in the previous calendar year
0092Payments Effective Last Financial YearFrequently used
Return payment information where the relevant pay period is in the previous financial year
0093Payments Effective Last Calendar Year Frequently used
Return payment information where the relevant pay period is in the previous calendar year
0094Exclude Future TransactionsFrequently used
Exclude any leave bookings and accruals that have not yet occurred
0095Transactions This Calendar Year Frequently used
Return leave bookings and accruals that commenced during the current year
0096Exclude Future TransactionsFrequently used
Exclude any LSL bookings and accruals that have not yet occurred
0097Transactions This Calendar Year Frequently used
Return LSL bookings and accruals that commenced during the current year
0098Course CodeMatch
Return details for the entered training course
0099Course NameMatch
Return details for the entered training course
0100Course Code & Number Match
Return details for the entered training course
0101Future CoursesFrequently used
Return details for training courses that commence in the future
0102Course StatusMatch
Return details for training courses with the entered status code
0103Incident NumberMatch
Return details for the entered incident number
0104Incidents This YearFrequently used
Return details for all OH&S  incidents that occurred this year

OH&S = Occupational Health and Safety

0105Incidents This Financial YearFrequently used
Return details for all OH&S incidents that occurred this financial year
0106Incidents Last YearFrequently used
Return details for all OH&S incidents that occurred last year
0107Incidents Last Financial YearFrequently used
Return details for all OH&S incidents that occurred last financial year
0108Cause of IncidentMatch
Return details for all OH&S incidents that match the entered cause code
0109Recruitment Code Match
Return details for all vacancies that match the entered recruitment code
0110Position NumberMatch
Return details for all vacancies for the entered position number
0111Recruitment StatusMatch
Return details for all vacancies that match the entered recruitment status
0112Vacancies in Past 12 MonthsFrequently used
Return details for all vacancies for the previous 12 months
0113Vacancies in Past MonthFrequently used
Return details for all vacancies for the previous month
0114Vacancies in Past 3 Months Frequently used
Return details for all vacancies for the past 3 months
0115Vacancies in Past 6 Months Frequently used
Return details for all vacancies for the past 6 months
0116Incidents in Past MonthFrequently used
Return details for all OH&S incidents that occurred in the past month
0117Incidents in Past 3 Months Frequently used
Return details for all OH&S incidents that occurred in the past 3 months
0118Incidents in Past 6 Months Frequently used
Return details for all OH&S incidents that occurred in the past 6 months
0119Incidents in Past 12 MonthsFrequently used
Return details for all OH&S incidents that occurred in the past 12 months
0120Normal Leave OnlyFrequently used
Restrict the leave balance information to the normal (non LSL) leave types. By default all leave types will be returned.
0121Long Service Leave OnlyFrequently used
Restrict the leave balance information to LSL. By default all leave types will be returned.
0122Recreation Leave OnlyFrequently used
Restrict the leave balance information to Recreation Leave. By default all leave types will be returned.
0123Sick Leave OnlyFrequently used
Restrict the leave balance information to Sick Leave. By default all leave types will be returned.
0124LWOP OnlyFrequently used
Restrict the leave balance information to Leave Without Pay. By default, all leave types will be returned.
0125Leave Loading OnlyFrequently used
Restrict the leave balance information to Leave Loading. By default all leave types will be returned.
0126Recreation Leave + Leave LoadingFrequently used
Restrict the leave balance information to Recreation Leave & Leave Loading. By default all leave types will be returned.
0127Transactions Last Calendar Year Frequently used
Return leave bookings and accruals that commenced during the previous year
0128Transactions Last Calendar Year Frequently used
Return leave bookings and accruals that commenced during the previous year
0129Personal Leave OnlyFrequently used
Return personal leave transactions only
0130Personal LeaveFrequently used
Restrict the leave balance information to Personal Leave. By default all leave types will be returned.
0131Date Range Match
Restrict the roster details to a date range.
0132Sick Leave Frequently used
Return sick leave absences only
0133Recreation Leave Frequently used
Return recreation leave absences only
0134LWOPFrequently used
Return LWOP  absences only

LWOP = Leave Without Pay

0135Personal LeaveFrequently used
Return personal leave absences only
0136Long Service LeaveFrequently used
Return LSL absences only.
0137Last YearFrequently used
Return roster details for the previous year
0138This YearFrequently used
Return roster details for the current year
0139Past 3 MonthsFrequently used
Return roster details for the past 3 months
0140Past Month Frequently used
Return roster details for the past month
0141Past 6 MonthsFrequently used
Return roster details for the past 6 months
0142Past 12 MonthsFrequently used
Return roster details for the past 12 months
0143Rostered OnFrequently used
Return details where the employee is rostered to work
0144Rostered OffFrequently used
Return details where the employee is not rostered to work
0145On LeaveFrequently used
Return details where the employee is on leave
0146TrainingFrequently used
Return details where the employee is on a training course
0147Public HolidayFrequently used
Return details where the employee is not at work due to a public holiday
0148Day of the WeekMatch
Return roster details for the day of the week entered
0149Mondays OnlyFrequently used
Return roster details for Mondays only
0150Fridays OnlyFrequently used
Return roster details for Fridays only
0151Mondays & FridaysFrequently used
Return roster details for Mondays and Fridays only
0152'n' WeeksMatch
Return roster details for the number of weeks specified, starting from the date entered
0153This WeekFrequently used
Return roster details for the current week
0154Cost CentreMatch
Return employee records associated with the Cost Centre entered
0155Org Unit 1 Match
Return employee records associated with the Org Unit 1 code entered
0156Org Unit 2 Match
Return employee records associated with the Org Unit 2 code entered
0157Org Unit 3 Match
Return employee records associated with the Org Unit 3 code entered
0158Department MatchReturn employee records associated with the Department code entered
0160BranchMatchReturn employee records associated with the Branch code entered
0161Section MatchReturn employee records associated with the Section code entered
0162LocationMatchReturn employee records associated with the Location code entered
0163Employee TypeMatch
Return employee records associated with the Employee type entered
0164Employment Condition MatchReturn employee records associated with the Employment Condition entered
0165Payroll CodeMatchReturn employee records associated with the Payroll Code entered
0166Pay LocationMatchReturn employee records associated with the Pay Location code entered
0167AwardMatchReturn employee records associated with the Award code entered
0168ClassificationMatchReturn employee records associated with the Classification and Level entered
0169Salary RangeMatch
Return employee records within the salary range entered
0170Cost CentreMatch
Return position records associated with the Cost Centre entered
0171Org Unit 1 Match
Return position records associated with the Org Unit 1 code entered
0172Org Unit 2 Match
Return position records associated with the Org Unit 2 code entered
0173Org Unit 3 Match
Return position records associated with the Org Unit 3 code entered
0174Department Match
Return position records associated with the Department code entered
0175BranchMatch
Return position records associated with the Branch code entered
0176Section Match
Return position records associated with the Section code entered
0177LocationMatch
Return position records associated with the Location code entered
0178Position TypeMatch
Return position records associated with the Position type entered
0179Employment Condition Match
Return position records associated with the Employment Condition entered
0180Payroll CodeMatch
Return position records associated with the Payroll Code entered
0181AwardMatch
Return position records associated with the Award code entered
0182ClassificationMatch
Return position records associated with the Classification and Level entered
0183Date Range Match
Restrict the leave details to a date range
0184Date Range Match
Restrict the lsl details to a date range
0185Mondays OnlyFrequently used
Return leave booked on a Monday only
0186Fridays OnlyFrequently used
Return leave booked on a Friday only
0187Last Employment RecordFrequently used
Restrict the employment records to the last one entered. Useful filter for terminated employees
0188Pay ElementMatch
Return payments where the payment code is contained in the selected pay element
0189Normal Leave OnlyFrequently used
Restrict the leave provisions information to the normal (non LSL) leave types.  By default all leave types will be returned.
0190Long Service Leave OnlyFrequently used
Restrict the leave provisions information to LSL.  By default all leave types will be returned.
0191Recreation Leave OnlyFrequently used
Restrict the leave provisions information to Recreation Leave.  By default all leave types will be returned.
0192Sick Leave OnlyFrequently used
Restrict the leave provisions information to Sick Leave.  By default all leave types will be returned.
0193Leave Loading OnlyFrequently used
Restrict the leave provisions information to Leave Loading.  By default all leave types will be returned.
0194Recreation Leave + Leave LoadingFrequently used
Restrict the leave provisions information to Recreation Leave and Leave Loading.  By default all leave types will be returned.
0195Exclude Sick LeaveFrequently used
Exclude Sick Leave from the leave provisions information.  By default all leave types will be returned.
0196Leave ElementMatch
Return records where the leave type and code are contained in the selected leave element
0197Leave ElementMatch
Return records where the leave type and code are contained in the selected leave element
0198Leave ElementMatch
Return records where the LSL type and code are contained in the selected leave element
0199Leave ElementMatch
Return records where the leave type and code are contained in the selected leave element
0200Project CodeMatch
 
0201Project NameMatch
 
0202CustomerMatch
 
0203Invoice NumberFrequently used
 
0204Invoice DateFrequently used
 
0205Billing Period FromFrequently used
 
0206Billing Period ToFrequently used
 
0207Current ResourcesFrequently used
 
0208Pay ElementMatch
 
0209Pay ElementMatch
 
0210Current Mark Up DetailsFrequently used
 
0211Date Effective Mark Up DetailsFrequently used
 
0212Leave Type & CodeMatch
Return details for the leave type and code entered
0213Sick Leave OnlyFrequently used
Return sick leave transactions only
0214Recreation Leave OnlyFrequently used
Return recreation leave transactions only
0215LWOP OnlyFrequently used
Return LWOP transactions only
0216Personal Leave OnlyFrequently used
Return personal leave transactions only
0217Leave ElementMatch
Return records where the leave type and code are contained in the selected leave element
0218LSL Type & CodeMatch
Return details for the LSL type and code entered
0219Leave ElementMatch
Return records where the LSL type and code are contained in the selected leave element
0220Transactions This Financial YearFrequently used
Return leave bookings and accruals that commenced during the current financial year
0221Transactions Last Financial YearFrequently used
Return leave bookings and accruals that commenced during the previous financial year
0222Transactions This Financial YearFrequently used
Return LSL bookings and accruals that commenced during the current financial year
0223Transactions Last Financial YearFrequently used
Return leave bookings and accruals that commenced during the previous financial year
0224Current Project Resources OnlyFrequently used
Restrict the project resources to the ones that are currently active.
0225Currently Employed (Incl. Non-Employees)Frequently used
Restrict people to those who are currently employed (status code beginning with e)
0227Last Provision DateFrequently used
Return the Leave Provisions with the latest (Maximum) date for each employee
0228Org Unit 1Match
Return records associated with the Org Unit 1 at the time of the transaction
0229Org Unit 2Match
Return records associated with the Org Unit 2 at the time of the transaction
0230Org Unit 3Match
Return records associated with the Org Unit 3 at the time of the transaction
0231DepartmentMatch
Return records associated with the Department at the time of the transaction
0232BranchMatch
Return records associated with the Branch at the time of the transaction
0233SectionMatch
Return records associated with the Section at the time of the transaction
0234Org Unit 1Match
Return records associated with the Org Unit 1 at the time of the transaction
0235Org Unit 2Match
Return records associated with the Org Unit 2 at the time of the transaction
0236Org Unit 3Match
Return records associated with the Org Unit 3 at the time of the transaction
0237DepartmentMatch
Return records associated with the Department at the time of the transaction
0238BranchMatch
Return records associated with the Branch at the time of the transaction
0239SectionMatch
Return records associated with the Section at the time of the transaction
0240Exclude CompetenciesFrequently used
Exclude Competencies from the All Attributes selection
0241Exclude SkillsFrequently used
Exclude Skills from the All Attributes selection
0242Exclude QualificationsFrequently used
Exclude Qualifications from the All Attributes selection
0243Exclude TrainingFrequently used
Exclude Training from the All Attributes selection
0244Exclude LanguagesFrequently used
Exclude Languages from the All Attributes selection
0245Exclude Miscellaneous AttributesFrequently used
Exclude Miscellaneous Attributes from the All Attributes selection
0246Exclude Leave LoadingFrequently used
Exclude Leave Loading details

 



Next topic

Standard parameters




 

 

 

 

 

 

 

 

 

© 2023 Fusion5. All rights reserved.