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

Table for EEO-4 Functional Group description - HR11

 2 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
clb393
Basic Member Send Private Message
Posts: 24
Basic Member
12/9/2013 6:56 PM
Hello! On the HR11 screen in the Work tab i am able to see that the EEO-4 Functional Group code is linked to the paemployee table. Where can i find the table that supplies the Description for that code?

For example, EEO-4 Functional Group code 01 is Finance Admin/General Control. I am able to cntrl-shift-O and see that the code is linked to the PEM (paemployee) table.  How do i find where the description attached to that code resides?

Thanks,
Chris
Marsha DeMaria
Basic Member Send Private Message
Posts: 6
Basic Member
12/9/2013 8:09 PM
The descriptions are hard-coded in the HR11 screen form (HR11.scr) in the $EDITS section of the code. Search for PEM-FNCTN-GROUP till you find it at the end of the code. Sometimes in these cases they are also defined at the database level (dbdfef) where if you highlight the field, F6-Define, B-Value List, then F6-A Translation you can see the translations for the field values, but in this case the values are defined as a range and there are no translations. So HR11.scr is probably the only place you are going to find them; unfortunately it does not look like they are stored in a table anywhere. If you're simply looking for the descriptions you can view the drop-down on the field from HR11, but if you're looking to programmatically join them with the field value then you won't be able to do that; I think you'll have to manually copy the hard-coded values from HR11.scr.
jaherb
Veteran Member Send Private Message
Posts: 164
Veteran Member
12/9/2013 8:12 PM
Chris... those drop down values do not come from a particular table. They are defined in the HR11.scr in the EDITS section for the actual form..
PEM-FNCTN-GROUP
01=Finance Admin/General Control
02=Streets and Highways
03=Public Welfare
04=Police Protection
05=Fire Protection
06=Natural Resources/Park and Rec
07=Hospitals and Sanatoriums
08=Health
09=Housing
10=Community Development
11=Corrections
12=Utilities and Transportation
13=Sanitation and Sewage
14=Employment Security
15=Other
99=Not Applicable