Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            PGEMPLOYEE FILE

                        Employee Group Employees

Contains the user-defined employee group name and the employee's who meet the
selection criteria defined for the group.

REFERENCED BY

AC190     AC541     AC741     GR741     BN100     BN101
BN102     BN103     BN105     BN145     BN150     BN231
BN232     BN238     BN242     BN245     BN246     BN285
BN31.1    BN31.2    BN32.1    BN32.2    BN32.3    BN321
BN325     BN331     BN340     BN345     BN350     BN45.1
BN531     BN65.1    BN71.1    BN72.1    BS09.1    BS10.1
BS11.1    BS12.1    BS13.1    BS14.1    BS15.1    BS32.1
HC01.1    HC02.1    HCEM.1    HCOP.1    HR125     HR170
HR211     HR213     HR217     HR220     HR255     HR70.1
PA113     PA125     PA149     PA212     PA213     PA214
PA215     PA216     PA217     PA218     PA219     PA220
PA221     PA222     PA224     PA225     PA249     PA290
PA296     PA300     PA305     PA310     PA311     PA313
PA315     PA320     PA325     PA330     PA335     PA340
PA345     PA350     PA355     PA360     PA370     PA490
PA66.2    TR113     TR120     TR121     TR20.1    TR20.2
TR20.3    HS20.1    HS21.1    HS34.1    HS35.1    HS535
PR128     PR131     PR134     PR136     PR139     PR195
PR197     PR212     PR214     PR226     PR247     PR260
PR276     PR277     PR293     PR297     PR298     PR300
PR33.2    PR33.3    PR85.1    UK102     UK110     UK210
UK330     TA125     TA180     TM240     TM245     TM250
TM255     TM470     UK120     UK270     PA49.1    PA49.3
PA549     HS22.1    HS36.1

UPDATED BY

AC721     HR15.1    HR155     HR511     HR54.1    HR55.2
HR55.1    HR55.3    HR650     HRS1.1    HRSC.1    PA16.1
PA502     PA513     PA54.1    TR22.1    TR500     PR13.1
PR13.5    PR13.6    PR13.8

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PGE-COMPANY          Numeric 4                                   AC190   AC541
Company              Contains the company number for which       AC721   AC741
                     the employee group is defined.              GR741   HR15.1
                                                                 HR155   HR511
                                                                 HR54.1  HR55.2
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA16.1
                                                                 PA502   PA513
                                                                 PA54.1  PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  TR22.1
                                                                 TR500

PGE-GROUP-NAME       Alpha 10                                    AC190   AC541
Group Name           Contains the name of the employee           AC721   AC741
                     group.                                      GR741   HR15.1
                                                                 HR155   HR511
                                                                 HR54.1  HR55.2
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA16.1
                                                                 PA502   PA513
                                                                 PA54.1  PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  TR22.1
                                                                 TR500

PGE-EMPLOYEE         Numeric 9                                   AC190   AC541
Employee             Contains the employee number of             AC721   AC741
                     employees who meet the selection            GR741   HR15.1
                     criteria for the group.                     HR155   HR511
                                                                 HR54.1  HR55.2
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA16.1
                                                                 PA502   PA513
                                                                 PA54.1  PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  TR22.1
                                                                 TR500

PGE-LAST-NAME        Alpha 30  (Lower Case)                      AC721   HR15.1
Last Name            Contains the employee's last name.          HR155   HR511
                                                                 HR54.1  HR55.2
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA16.1
                                                                 PA502   PA513
                                                                 PA54.1  PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  TR22.1
                                                                 TR500

PGE-FIRST-NAME       Alpha 15  (Lower Case)                      AC721   HR15.1
First Name           Contains the employee's first name.         HR155   HR511
                                                                 HR54.1  HR55.2
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA16.1
                                                                 PA502   PA513
                                                                 PA54.1  PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  TR22.1
                                                                 TR500

PGE-MIDDLE-INIT      Alpha 1                                     AC721   HR15.1
Middle Initial       Contains the employee's middle initial.     HR155   HR511
                                                                 HR54.1  HR55.2
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA16.1
                                                                 PA502   PA513
                                                                 PA54.1  PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  TR22.1
                                                                 TR500

PGE-FULL-NAME        Derived
Full Name

                         PGEMPLOYEE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PGESET1   COMPANY                                                AC190   AC541
          GROUP-NAME                                             AC721   AC741
          EMPLOYEE                                               GR741   BN100
                                                                 BN101   BN102
                                                                 BN103   BN105
                                                                 BN145   BN150
                                                                 BN231   BN232
                                                                 BN238   BN242
                                                                 BN245   BN246
                                                                 BN285   BN31.1
                                                                 BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN321   BN325
                                                                 BN331   BN340
                                                                 BN345   BN350
                                                                 ...

PGESET2   COMPANY                                                HR511   HR650
          EMPLOYEE                                               PA149   PA16.1
          GROUP-NAME                                             PA249   PA49.1
                                                                 PA49.3  PA502
                                                                 PA549   TR22.1
                                                                 TR500   HS22.1
                                                                 HS36.1  PR128
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PGESET3   COMPANY       KeyChange                                HR255   PR33.3
          GROUP-NAME
          LAST-NAME
          FIRST-NAME
          MIDDLE-INIT
          EMPLOYEE

                         PGEMPLOYEE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            PGE-COMPANY       -> PRS-COMPANY
                            Spaces            -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Not Required

                            PGE-COMPANY       -> EMP-COMPANY
                            PGE-EMPLOYEE      -> EMP-EMPLOYEE

Pa Employee    PAEMPLOYEE   Required

                            PGE-COMPANY       -> PEM-COMPANY
                            PGE-EMPLOYEE      -> PEM-EMPLOYEE

Pers Group     PERSGROUP    Required

                            PGE-COMPANY       -> PRG-COMPANY
                            PGE-GROUP-NAME    -> PRG-GROUP-NAME