HRHISTORY

Sort:
You are not authorized to post a reply.
Author
Messages
Chesca
Veteran Member
Posts: 490
Veteran Member
    I want to write to code to look at hrhistory to find out if the employee FTE changed. I need to know the field number from the data dictionary, where would I find the data dictionary?
    Chesca
    Veteran Member
    Posts: 490
    Veteran Member
      got it, thank you so much! The EMP FTE is field number 56.
      Woozy
      Veteran Member
      Posts: 709
      Veteran Member
        For others who may be looking for field numbers, these are found in table PADICT. You need to know the Topic value and the Item Name - in our case there are three "FTE" records - one each for E1- Employee (56), RO - PAREQOFFER (813), and SH - PRRATEHIST (989)

        Just as a suggestion, it's a good idea to look up the field number in PADICT in your code or query rather than hard-code a FLD-NBR value, just in case the field number changes between environments or with upgrades. This is less of a problem with delivered fields than with custom fields, but it's a good practice to use when you can.
        Kelly Meade
        J. R. Simplot Company
        Boise, ID
        Chesca
        Veteran Member
        Posts: 490
        Veteran Member
          Thanks Woozy, will do!
          jaherb
          Veteran Member
          Posts: 164
          Veteran Member
            When I need this info, I check it in PADICT2. Just a little easier to ready when you dump it out. I've also have a quick 4GL report for PADICT2, that lists this info. Keep it handy in my files...
            You are not authorized to post a reply.