Prev
Next
Forums Human Capital Management Lawson S3 HR/Payroll/Benefits

Time/Absence Entry Comments

 1 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
Matt Gordon
Basic Member
Posts: 12
Basic Member
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
    Basic Member
    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.