How to Report on Applicant's addresses

Description of Issue

User would like to report on addresses for applicants.

Context

All versions of Enterprise ERP
SSRS reports
Crystal reports
SaaS, Tyler-hosted clients
OnPrem, Self-hosted clients

Cause

Address fields in applicant module are derived.

Resolution

The addresses will be found in the pr_address view. To link it to an applicant, join pm_applicant_data on a_employee_number is equal to a_applicant_no. Please filter on projection 999.

Additional Information