I'm trying to find a table in Lawson that (hopefully) holds the field name for the numeric values in other tables. For instance, in HRHISTORY, I know that a value of 20 in FLD_NBR equates to EMP_STATUS in the EMPLOYEE table. Also in PGSELECT, FLD_NBR is used in reference to the entry rules for employee eligibility groups . :nix:

Check PADICT and PADICT2.

Bada Bing, Bada Boom. Perfect!!! Thanks Chris!!! :thumb:

PCODES is another reference table you can use, like if you're trying find the description of a location or a user field.

It's been a good year or more since I worked with HR data, but as I recall...

Your user field values will be in PCODES, but your fld_nbr references for user fields will still be in PADICT/PADICT2 (ie trying to tie to HRHISTORY fld_nbr) with a DELIVERED flag of "N".