Prev
Next
Forums Lawson S3 HR/Payroll/Benefits

Table for EEO-4 Functional Group description - HR11

Sort:
You are not authorized to post a reply.
Author
Messages
clb393
Basic Member
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
    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
      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
        You are not authorized to post a reply.