8.0.3 sp11 HR04.4 / hr04.1

 8 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
thestripe
New Member
Posts: 4
New Member

    I know this may be a blast from the past for most, and apparently Lawson support, but I am still on 8.0.3 :-<

    I have a question hopefully someone would know. What is the related sql table/column(s) for the alphanumeric user fields (HR04.1)? We are using sql server.

    Thank You,

    Robert

    M.J.
    Veteran Member
    Posts: 38
    Veteran Member
      I'm not sure if this is what you are talking about but the table is PCODES and you will also want PCODESTYPE to get the type - like CE, ED etc.
      thestripe
      New Member
      Posts: 4
      New Member
        THANK YOU! This is what i was looking for.
        Shane Jones
        Veteran Member
        Posts: 460
        Veteran Member

          Robert,
          If you are using portal you can click "crtl+shift+o" and it gives you the table and field - I seem to remember that this worked back in your version. Might help in the future when you need something like this quickly.

          Another self-service option is the Data Dictionary on this site: https://www.lawsonguru.co.../DataDictionary.aspx
          (Tech -> Data Dictionary -> Forms -> 8.0.3 -> scroll down to the form) This option is great because it will give you the tables and relationships.

          https://www.lawsonguru.co...3/programs/HR04.html
          (this is the link to HR04 data dictionary - only works when logged into "lawsonguru")

          Shane Jones
          Tools: HR, Payroll, Benefits, PFI, Smart Office, BSI, Portal and Self-Service
          Systems: Lawson, Open Hire, Kronos, Crystal Reporting, SumTotal Learning
          ** Teach others to fish...
          thestripe
          New Member
          Posts: 4
          New Member

             

            Thanks Shane I really appreciate the info!!

            Cheers,

            Robert

             

            Joe O'Toole
            Veteran Member
            Posts: 314
            Veteran Member
              Has anyone had ctrl-shift-o stop working? I have a feeling it's some browser security change that was pushed out by our network admins but have not been able to pinpoint it. We are on LSF 9.004 and 8.03 apps. Thanks.
              spatterson
              Basic Member
              Posts: 16
              Basic Member

                Joe, Yes we have had that happen and its either because your on Version 6 of internet explorer (which you should at least be version 7) or the script bar updates in the internet explorer options are disabled instead of enabled. if you go to Tools-->InternetOptions--> click on Custom Levels under security. Go almost to the bottom and you will see "scripiting". Make sure the "allow status bar updates via script" is enabled.

                Joe O'Toole
                Veteran Member
                Posts: 314
                Veteran Member
                  We've been bitten by that setting in the past, however in this case the status bar updates option is enabled yet ctrl-shift-o does not work.
                  Joe O'Toole
                  Veteran Member
                  Posts: 314
                  Veteran Member
                    We still have not gotten CTRL-SHFT-O to work. Has anyone else run into this problem?