• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Infor / Lawson Platforms S3 Security

Employee Drill Around - Health, Safety Incidents

 2 Replies
 0 Subscribed to this topic
 16 Subscribed to this forum
Sort:
Author
Messages
KerriR
Advanced Member Send Private Message
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 Send Private Message
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 Send Private Message
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.