To query for Local and permanent residents, you need to set up the query as follows:
Go to the Payroll module.
Click Query Setup, New and enter a query name, eg, LocalPR
Tick Use Custom Query checkbox, click on the three-dotted button.
Copy this script (Employee.ResidenceStatus in ( 'Local', 'PR1', 'PR2', 'PR3' ) AND Employee.CessationDate = '1899-12-30') OR (Employee.ResidenceStatus in ( 'Local', 'PR1', 'PR2', 'PR3' ) AND Employee.CessationDate >= '2024-01-01' )
Change the cessation from 2024-01-01 to the first of the current month accordingly, if you are querying for active employees of the current month.
Paste into the Query Window as seen in the picture below.
Click Save, close the window, and click Apply.