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 Send Private Message
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 Send Private Message
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 Send Private Message
Posts: 4
New Member
THANK YOU! This is what i was looking for.
Shane Jones
Veteran Member Send Private Message
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 Send Private Message
Posts: 4
New Member

 

Thanks Shane I really appreciate the info!!

Cheers,

Robert

 

Joe O'Toole
Veteran Member Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
Posts: 314
Veteran Member
We still have not gotten CTRL-SHFT-O to work. Has anyone else run into this problem?