Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PWEMPLY


                              PWEMPLY FILE

UPDATED BY

BN305     ET700     HR07.1    HR11.1    HR11.2    HR507
HR511     PA02.1    PA100     PA102     PA115     PA13.1
PA13.2    PA502     PA513     PA52.1    PA52.3    PA52.4
PA52.5    PR110     PR113     PR120     PR13.1    PR13.5
PR13.6    PR13.8

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PW4-COMPANY            Numeric 4                                 BN305   ET700
Element: Company                                                 HR07.1  HR11.1
                                                                 HR11.2  HR507
                                                                 HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PW4-PROCESS-LEVEL      Alpha 5                                   BN305   ET700
Element: Process Level                                           HR07.1  HR11.1
                                                                 HR11.2  HR507
                                                                 HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PW4-DEPARTMENT         Alpha 5                                   BN305   ET700
Element: Department                                              HR07.1  HR11.1
                                                                 HR11.2  HR507
                                                                 HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PW4-EMPLOYEE           Numeric 9                                 BN305   ET700
Element: Employee                                                HR07.1  HR11.1
                                                                 HR11.2  HR507
                                                                 HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PW4-EMPLOYEE-NAME      Alpha 49                                  BN305   ET700
Element: Employee Name                                           HR07.1  HR11.1
                                                                 HR11.2  HR507
                                                                 HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PW4-LOC-CODE-DESC      Alpha 40                                  BN305   ET700
Element: Loc Code Desc                                           HR07.1  HR11.1
                                                                 HR11.2  HR507
                                                                 HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PW4-WK-PHONE-EXT       Alpha 5                                   BN305   ET700
Element: Wk Phone Ext                                            HR07.1  HR11.1
                                                                 HR11.2  HR507
                                                                 HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PW4-EMAIL-ADDRESS      Alpha 60  (Lower Case)                    BN305   ET700
Element: Email Address                                           HR07.1  HR11.1
                                                                 HR11.2  HR507
                                                                 HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PW4-DATE-HIRED         Numeric 8  (yyyymmdd)                     BN305   ET700
Element: Date Hired                                              HR07.1  HR11.1
                                                                 HR11.2  HR507
                                                                 HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PW4-TERM-DATE          Numeric 8  (yyyymmdd)                     BN305   ET700
Element: Term Date                                               HR07.1  HR11.1
                                                                 HR11.2  HR507
                                                                 HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PW4-CONCAT-CMP-AU      Alpha 20                                  BN305   ET700
Element: Concat Cmp Au                                           HR07.1  HR11.1
                                                                 HR11.2  HR507
                                                                 HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PW4-JOB-CODE           Alpha 9                                   BN305   ET700
Element: Job Code                                                HR07.1  HR11.1
                                                                 HR11.2  HR507
                                                                 HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PW4-JOB-CODE-DESC      Alpha 30  (Lower Case)                    BN305   ET700
Element: Job Code Desc                                           HR07.1  HR11.1
                                                                 HR11.2  HR507
                                                                 HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PW4-SUPERVISOR         Alpha 10                                  BN305   ET700
Element: Supervisor                                              HR07.1  HR11.1
                                                                 HR11.2  HR507
                                                                 HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PW4-SUPERVISOR-EMP     Numeric 9                                 BN305   ET700
Element: Supervisor Emp                                          HR07.1  HR11.1
                                                                 HR11.2  HR507
                                                                 HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PW4-STAND-HOURS        Signed 7.2                                HR11.1  HR11.2
Element: Stand Hours                                             PA02.1  PA13.1
                                                                 PA13.2  PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PW4-PAY-RATE           Signed 13.4                               BN305   HR07.1
Element: Pay Rate                                                HR11.1  HR11.2
                                                                 HR507   HR511
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PW4-NBR-FTE            Signed 7.6                                BN305   ET700
Element: Nbr Fte                                                 HR07.1  HR11.1
                                                                 HR11.2  HR507
                                                                 HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PW4-ANNUAL-HOURS       Numeric 4                                 BN305   ET700
Element: Annual Hours                                            HR07.1  HR11.1
                                                                 HR11.2  HR507
                                                                 HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PW4-SALARY-CLASS       Alpha 1                                   BN305   HR07.1
Element: Salary Class  H = Hourly                                HR11.1  HR11.2
                       S = Salary                                HR507   HR511
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PW4-GROUP-ID           Numeric 10                                BN305   ET700
Element: Numeric 1                                               HR07.1  HR11.1
                                                                 HR11.2  HR507
                                                                 HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PW4-LOCATION           Alpha 10                                  BN305   ET700
Element: Supervisor                                              HR07.1  HR11.1
                                                                 HR11.2  HR507
                                                                 HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PW4-SHIFT              Numeric 1                                 BN305   ET700
Element: Shift                                                   HR07.1  HR11.1
                                                                 HR11.2  HR507
                                                                 HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PW4-POSITION           Alpha 12                                  BN305   ET700
Element: Position                                                HR07.1  HR11.1
                                                                 HR11.2  HR507
                                                                 HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PW4-PAY-GRADE          Alpha 3                                   BN305   ET700
Element: Pay Grade                                               HR07.1  HR11.1
                                                                 HR11.2  HR507
                                                                 HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PW4-AUTO-TIME-REC      Alpha 1                                   BN305   ET700
Element: Auto Time Rec                                           HR07.1  HR11.1
                                                                 HR11.2  HR507
                                                                 HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PW4-BARGAIN-UNIT       Alpha 10                                  BN305   ET700
Element: Bargain Unit                                            HR07.1  HR11.1
                                                                 HR11.2  HR507
                                                                 HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PW4-UNION-CODE         Alpha 10                                  BN305   ET700
Element: Union Code                                              HR07.1  HR11.1
                                                                 HR11.2  HR507
                                                                 HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PW4-PAY-STEP           Numeric 2                                 BN305   ET700
Element: Pay Step                                                HR07.1  HR11.1
                                                                 HR11.2  HR507
                                                                 HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PW4-CURRENCY-CODE      Alpha 5                                   BN305   ET700
Element: Currency Code                                           HR07.1  HR11.1
                                                                 HR11.2  HR507
                                                                 HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PW4-FIRST-NAME         Alpha 15  (Lower Case)                    BN305   ET700
Element: First Name                                              HR07.1  HR11.1
                                                                 HR11.2  HR507
                                                                 HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PW4-LAST-NAME          Alpha 30  (Lower Case)                    BN305   ET700
Element: Name                                                    HR07.1  HR11.1
                                                                 HR11.2  HR507
                                                                 HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PW4-MIDDLE-INIT        Alpha 1                                   BN305   ET700
Element: Middle Init                                             HR07.1  HR11.1
                                                                 HR11.2  HR507
                                                                 HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PW4-COUNTRY-CODE       Alpha 2                                   BN305   ET700
Element: Country Code                                            HR07.1  HR11.1
                                                                 HR11.2  HR507
                                                                 HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PW4-ACTIVE-FLAG        Alpha 1                                   BN305   HR07.1
Element: Active Flag                                             HR11.1  HR11.2
                                                                 HR507   HR511
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PW4-ADJ-HIRE-DATE      Numeric 8  (yyyymmdd)                     BN305   ET700
Element: Date                                                    HR07.1  HR11.1
                                                                 HR11.2  HR507
                                                                 HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PW4-SCHEDULE           Alpha 9                                   BN305   ET700
Element: Schedule                                                HR07.1  HR11.1
                                                                 HR11.2  HR507
                                                                 HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PW4-STATUS             Alpha 2                                   BN305   ET700
Element: Emp Status                                              HR07.1  HR11.1
                                                                 HR11.2  HR507
                                                                 HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

                         PWEMPLY FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PW4SET1   COMPANY                                                BN305   ET700
          EMPLOYEE                                               HR07.1  HR11.1
                                                                 HR11.2  HR507
                                                                 HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8