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
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
    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
      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
        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
          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
            Posts: 167
            Veteran Member
            12/5/2013 2:35 PM
              Figured it out Thanks everyone for your help.
              Kelly H
              Veteran Member
              Posts: 167
              Veteran Member
              12/5/2013 2:35 PM
                Figured it out Thanks everyone for your help.