PA10 Service Date

 3 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
Rirruto
New Member
Posts: 4
New Member
    Good Afternoon,

    I am trying to get the date in which an employee entered their current position, whether it be through a transfer or if they were hired into the position. The date can be seen in PA10.1 Length of Service and is called Service Date. I cannot click on it to find out what table and field I can find it in through Crystal. Can anyone help?

    Bob Canham
    Veteran Member
    Posts: 217
    Veteran Member
      I think that is a calculated field. From what I could see, it is the last time the position code changed. So the most direct place to get it would be from hrhistory field number 126 pos level 1. If you pull the max beg date, you should get that value.
      Ragu Raghavan
      Veteran Member
      Posts: 476
      Veteran Member
        Looking  at the PA10 code, looks like it is coming from PAEMPPOS.beg_date.
        Rirruto
        New Member
        Posts: 4
        New Member
          Posted By Bob Canham on 03/15/2013 01:02 PM
          I think that is a calculated field. From what I could see, it is the last time the position code changed. So the most direct place to get it would be from hrhistory field number 126 pos level 1. If you pull the max beg date, you should get that value.


          This is correct!! Thanks for fast responses!