Please follow the steps below to query for an active employee:
Go to the Core module, Leave, or Payroll module.
Click Query Setup.
Click New and enter Query Name eg, Active Employee.
Enable the checkbox to Use Custom Query.
Click on the 3 dotted button.
Enter the Query as Employee.CessationDate = '1899-12-30'
Click Apply.
Print the report, or assign the credit leave/ recurring setup.