Forums
Lawson S3 HR/Payroll/Benefits
Time/Absence Entry Comments
Author
Messages
Matt Gordon
Basic Member
Posts: 12
10/19/2017 1:59 PM
I have an administrator that would like to have a report of approved absence entries including the comments each pay period. Does anyone know where the comment is stored? There is a 'comment' field in PRPENDTIME but no entries that I make show up there. I'm also not seeing your typical cross reference fields to link to another table. Any ideas?
Matt Gordon
Basic Member
Posts: 12
10/26/2017 7:45 PM
I dug around and finally found them. The comments are stored in EMPCOMMENT with a CMT_TYPE of 'TR'. They can be linked by COMPANY, EMPLOYEE, and R_DATE.