Prev
Next
Forums Human Capital Management Lawson S3 HR/Payroll/Benefits

How do I identify the data in a particular field in the HREMPLOYEE table?

 1 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
Bev Edwards
Veteran Member
Posts: 366
Veteran Member
8/22/2011 3:37 PM
    I ran a query of the entire table and the field numbers are listed sequentially in a Field ID column. How can I go into the table to see data is in a particular field.
    For instance, field 20 is the Employee Status, but how do I go into Lawson and actually SEE the status IN field 20? I'm not sure where to look because I'm new to Lawson.:confused:
    John Henley
    Posts: 3353
    8/22/2011 7:07 PM
      Hi Bev,
      The field definitions are stored in data is stored in the PADICT table; the data that is stored in HRHISTORY is stored in either A_VALUE (for alpha fields), D_VALUE (for date fields), or N_VALUE (for numeric fields). So, for field id 20, look at the A_VALUE, since Employee Status is alpha.

      You can use the Excel addins to dump out the contents of the PADICT table; also I have a simple Crystal Report for sale in the store that reports the definitions:
      https://www.lawsonguru.co...duct&product=3612943
      Thanks for using the LawsonGuru.com forums!
      John