HRHISTORY

got it, thank you so much! The EMP FTE is field number 56.

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.

Thanks Woozy, will do!

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...