• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Human Capital Management Lawson S3 HR/Payroll/Benefits

Job Code User Fields

 6 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
Kelly H
Veteran Member Send Private Message
Posts: 167
Veteran Member
12/4/2013 7:13 PM

Any clue how to tie the job code user fields back to the actual job code?  I was able to find the user fields and the descriptions on the HRPOSFLDS and HRPSVAL tables, but I can’t get the job code tied to its user field on the user field button at the bottom of the HR06.

Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
12/4/2013 7:42 PM
According to my SchemaSpy diagrams.... the only two tables that are common to HRPOSFLDS and HRPSVAL tables are HRUSERFLDS and PCODESTYPE. Other than that, I'm afraid I can't help much.
Mary Porter
Veteran Member Send Private Message
Posts: 337
Veteran Member
12/4/2013 8:02 PM
Link HRPOSUSD and JOBCODE by OBJ_ID and filter HRPOSUSD.R_TYPE = 2

Jeff White
Veteran Member Send Private Message
Posts: 83
Veteran Member
12/4/2013 8:11 PM
Try HRPOSUSD.  You then tie the JOBCODE and HRPOSUSD via the OBJ-ID field.  The TYPE and FIELD-KEY also play a part.  I believe TYPE=1 is for position user fields, and TYPE=2 is for jobcode user fields.

I hope that helps some.

Jeff
Kelly H
Veteran Member Send Private Message
Posts: 167
Veteran Member
12/5/2013 2:04 PM
Thanks Jeff and Mary that did help!!

however when I add the HRPOSVAL table, it gives me multiple returns tying each job code to each jobgroup rather than just identifying the single job group that was attached to the job code. I am trying to pull in this table to get the description of the user field (jobgroup).
Kelly H
Veteran Member Send Private Message
Posts: 167
Veteran Member
12/5/2013 2:35 PM
Figured it out Thanks everyone for your help.
Kelly H
Veteran Member Send Private Message
Posts: 167
Veteran Member
12/5/2013 2:35 PM
Figured it out Thanks everyone for your help.