Time/Absence Entry Comments

Sort:
You are not authorized to post a reply.
Author
Messages
Matt Gordon
Basic Member
Posts: 12
Basic Member
    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
      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.
      You are not authorized to post a reply.