Prev
Next
Forums S3 Security

Employee Drill Around - Health, Safety Incidents

Sort:
You are not authorized to post a reply.
Author
Messages
KerriR
Advanced Member
Posts: 34
Advanced Member
10/5/2009 3:54 PM

    Can anyone tell me what tables I need to grant access to to allow a manager to see "Health, Safety Incidents" when drilling around on an employee?  I have granted access to OSHA, PACOMMENTS, PAFOLLOWUP, PAINCICOST, OSHESTAB, PCODES, PCODESDTL, PRSYSTEM, DEPTCODE, EMPLOYEE, HRSECLEV, HRSUPER, INSTCTRYCD, JOBCODE,  and PCODESDTL (all of the tables the Technical Text for PA document states that PA90 uses) but when I click on Health, Safety Incidents on the drill around, it states "no records meeting criteria".  We use COMPEMP element group security (user.isInChainOfCmdOfEmpInHR(COMPANY,EMPLOYEE) ) on the tables where it is applicable.  All of the other options on drill around seem to be working correctly, just can't get this one to work.

    Thanks!

    GregSl
    Veteran Member
    Posts: 38
    Veteran Member
    10/5/2009 4:02 PM
      Have you tried with the trim function ?

      if(user.isInChainOfCmdOfEmpInHR(lztrim(form.EMP_COMPANY),lztrim(form.EMP_EMPLOYEE)))
      'ALL_ACCESS,'
      else
      'NO_ACCESS,'

      Hope this helps !
      KerriR
      Advanced Member
      Posts: 34
      Advanced Member
      10/5/2009 5:44 PM
        Thanks for the suggestion but it didn't fix my problem. I still get "no records meeting criteria" when clicking on Health, Safety Incidents.
        You are not authorized to post a reply.