Crystal Report linking ESS and HRMS

I am trying to write a crystal report to pull answers to open enrollment questions from ESS.  I am using the ESS table employee_open_enrollment_benefit_plan_answers to get the information, but how do I get the employee number and name from HRMS.  I can't find any fields that will link.

  • 0

    the answers to open enrollment questions are not stored in the ESS database by EE and Company. They are linked to open enrollment and the ESS user id. Finding a way to link to the HRMS EE and Co id fields would be complicated but might be possible. You might want to turn to your certified HRMS partner or Sage professional services group if you have not yet found a way to get the name and id. Sorry I could not be more help!