Linking PCards to employee master

Client wants to create a report on employees that have purchase cards.

• All versions of Munis

• SSRS reports

• Crystal reports

• SaaS, Tyler-hosted clients

• OnPrem, Self-hosted clients

• Accounts Payable

• Purchase Cards

Employees that are no longer active still appear in the pcards. We need to fetch employee status from the employee master.

The following sample query will fetch pcards that are attached to an employee:

SELECT *

FROM ap_pcard

JOIN pr_employee_master

ON apcd_holder_emplno = a_employee_number