PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 10/26/2017 3:45 PM by  Matt Gordon
Time/Absence Entry Comments
 1 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Matt Gordon
Business Information Systems Analyst
School District
Basic Member
(27 points)
Basic Member
Posts:11


Send Message:

--
10/19/2017 9:59 AM
    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
    Business Information Systems Analyst
    School District
    Basic Member
    (27 points)
    Basic Member
    Posts:11


    Send Message:

    --
    10/26/2017 3: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.
    You are not authorized to post a reply.