Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PWEMPLY


                              PWEMPLY FILE

UPDATED BY

HR07.1    HR11.1    HR11.2    HR507     HR511     HR650
PA02.1    PA100     PA102     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                                 HR07.1  HR11.1
Element: Company       The company number represents an          HR11.2  HR507
                       established company and is entered on     HR511   HR650
                       all function codes.                       PA02.1  PA100
                                                                 PA102   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                                   HR07.1  HR11.1
Element: Process Level This field contains the process level,    HR11.2  HR507
                       which is the reporting hierarchy below    HR511   HR650
                       company.                                  PA02.1  PA100
                                                                 PA102   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                                   HR07.1  HR11.1
Element: Department    Contains the department.                  HR11.2  HR507
                                                                 HR511   HR650
                                                                 PA02.1  PA100
                                                                 PA102   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                                 HR07.1  HR11.1
Element: Employee      Contains the employee number. Each        HR11.2  HR507
                       person employed by the company is         HR511   HR650
                       assigned a unique number. The system      PA02.1  PA100
                       uses the employee number to correlate     PA102   PA13.1
                       all of the information related to that    PA13.2  PA502
                       person.                                   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                                  HR07.1  HR11.1
Element: Employee Name                                           HR11.2  HR507
                                                                 HR511   HR650
                                                                 PA02.1  PA100
                                                                 PA102   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                                  HR07.1  HR11.1
Element: Loc Code Desc                                           HR11.2  HR507
                                                                 HR511   HR650
                                                                 PA02.1  PA100
                                                                 PA102   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                                   HR07.1  HR11.1
Work Telephone                                                   HR11.2  HR507
Extension                                                        HR511   HR650
                                                                 PA02.1  PA100
                                                                 PA102   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)                    HR07.1  HR11.1
Element: Email Address                                           HR11.2  HR507
                                                                 HR511   HR650
                                                                 PA02.1  PA100
                                                                 PA102   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)                     HR07.1  HR11.1
Element: Hire Date                                               HR11.2  HR507
                                                                 HR511   HR650
                                                                 PA02.1  PA100
                                                                 PA102   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)                     HR07.1  HR11.1
Element: Termination Date                                        HR11.2  HR507
                                                                 HR511   HR650
                                                                 PA02.1  PA100
                                                                 PA102   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                                  HR07.1  HR11.1
Element: Concat Cmp Au                                           HR11.2  HR507
                                                                 HR511   HR650
                                                                 PA02.1  PA100
                                                                 PA102   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                                   HR07.1  HR11.1
Element: Job Code      Contains a user-defined code that         HR11.2  HR507
                       represents a type of job.                 HR511   HR650
                                                                 PA02.1  PA100
                                                                 PA102   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)                    HR07.1  HR11.1
Element: Job Code Desc                                           HR11.2  HR507
                                                                 HR511   HR650
                                                                 PA02.1  PA100
                                                                 PA102   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                                  HR07.1  HR11.1
Element: Supervisor                                              HR11.2  HR507
                                                                 HR511   HR650
                                                                 PA02.1  PA100
                                                                 PA102   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                                 HR07.1  HR11.1
Element: Supervisor Emp                                          HR11.2  HR507
                                                                 HR511   HR650
                                                                 PA02.1  PA100
                                                                 PA102   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: Standard 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                               HR07.1  HR11.1
Element: Rate of Pay                                             HR11.2  HR507
                                                                 HR511   HR650
                                                                 PA02.1  PA100
                                                                 PA102   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 4.3                                HR07.1  HR11.1
Full Time                                                        HR11.2  HR507
Equivalent Number                                                HR511   HR650
                                                                 PA02.1  PA100
                                                                 PA102   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                                 HR07.1  HR11.1
Element: Annual Hours                                            HR11.2  HR507
                                                                 HR511   HR650
                                                                 PA02.1  PA100
                                                                 PA102   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                                   HR07.1  HR11.1
Element: Salary Class  H = Hourly                                HR11.2  HR507
                       S = Salary                                HR511   HR650
                                                                 PA02.1  PA100
                                                                 PA102   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                                HR07.1  HR11.1
Element: Numeric 1                                               HR11.2  HR507
                                                                 HR511   HR650
                                                                 PA02.1  PA100
                                                                 PA102   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                                  HR07.1  HR11.1
Element: Supervisor    This field contains a valid stocking      HR11.2  HR507
                       location within the company inventory.    HR511   HR650
                                                                 PA02.1  PA100
                                                                 PA102   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                                 HR07.1  HR11.1
Element: Shift         Contains the shift number associated      HR11.2  HR507
                       with the pay.                             HR511   HR650
                                                                 PA02.1  PA100
                                                                 PA102   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                                  HR07.1  HR11.1
Element: Position      Contains the user-defined code that       HR11.2  HR507
                       represents a position in the company.     HR511   HR650
                                                                 PA02.1  PA100
                                                                 PA102   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                                   HR07.1  HR11.1
Element: Grade                                                   HR11.2  HR507
                                                                 HR511   HR650
                                                                 PA02.1  PA100
                                                                 PA102   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                                   HR07.1  HR11.1
Automatic Time                                                   HR11.2  HR507
Record                                                           HR511   HR650
                                                                 PA02.1  PA100
                                                                 PA102   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                                  HR07.1  HR11.1
Element: Bargaining Unit                                         HR11.2  HR507
                                                                 HR511   HR650
                                                                 PA02.1  PA100
                                                                 PA102   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                                  HR07.1  HR11.1
Element: Union Code                                              HR11.2  HR507
                                                                 HR511   HR650
                                                                 PA02.1  PA100
                                                                 PA102   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                                 HR07.1  HR11.1
Element: Step                                                    HR11.2  HR507
                                                                 HR511   HR650
                                                                 PA02.1  PA100
                                                                 PA102   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                                   HR07.1  HR11.1
Element: Currency Code This field contains the company base      HR11.2  HR507
                       currency code established in Company      HR511   HR650
                       (GL10.1 ).                                PA02.1  PA100
                                                                 PA102   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)                    HR07.1  HR11.1
Element: First Name    Contains the first name of the manager    HR11.2  HR507
                       in charge.                                HR511   HR650
                                                                 PA02.1  PA100
                                                                 PA102   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)                    HR07.1  HR11.1
Element: Name                                                    HR11.2  HR507
                                                                 HR511   HR650
                                                                 PA02.1  PA100
                                                                 PA102   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                                   HR07.1  HR11.1
Element: Middle InitialContains the middle initial of the        HR11.2  HR507
                       manager in charge.                        HR511   HR650
                                                                 PA02.1  PA100
                                                                 PA102   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                                   HR07.1  HR11.1
Element: Country Code  The country code.  Required for VAT and   HR11.2  HR507
                       intrastat reporting.  Must be defined in  HR511   HR650
                        IN01.1 (Country Maintenance).            PA02.1  PA100
                                                                 PA102   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                                   HR07.1  HR11.1
Element: Status        The Active flag of the credit card        HR11.2  HR507
                       type.                                     HR511   HR650
                                                                 PA02.1  PA100
                                                                 PA102   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)                     HR07.1  HR11.1
Element: Date                                                    HR11.2  HR507
                                                                 HR511   HR650
                                                                 PA02.1  PA100
                                                                 PA102   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                                   HR07.1  HR11.1
Element: Schedule                                                HR11.2  HR507
                                                                 HR511   HR650
                                                                 PA02.1  PA100
                                                                 PA102   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                                   HR07.1  HR11.1
Element: Employee StatuThis field displays the status of the     HR11.2  HR507
                       transaction.                              HR511   HR650
                                                                 PA02.1  PA100
                                                                 PA102   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                                                HR07.1  HR11.1
          EMPLOYEE                                               HR11.2  HR507
                                                                 HR511   HR650
                                                                 PA02.1  PA100
                                                                 PA102   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