Process level changes

 2 Replies
 0 Subscribed to this topic
 17 Subscribed to this forum
Sort:
Author
Messages
Chesca
Veteran Member
Posts: 490
Veteran Member
    I am writing custom code and we have encountered an issue. when employee switch process levels, it reports the new process level, I want to be able to look in history and get the previous process level. Where can I get this data from? Would that be in HRHISTORY?
    Carl.Seay
    Veteran Member
    Posts: 109
    Veteran Member
      Hi, it will be in HRHISTORY if you have History enabled on HR10. It will be listed by Field Number, which is 14 for Process-Level. If you're using COBOL, I would recommend looking through all the indexes to find the best fit, since HRHISTORY can be quite massive.
      jaherb
      Veteran Member
      Posts: 164
      Veteran Member
        HRHISTORY is the correct table to look at for this. However due to the size of this table, you should incorporate index filtering to help the processing time.