Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PRWEEKS


                              PRWEEKS FILE

                         Employee Weeks Worked

This file contains the number of weeks an employee worked during the defined
payroll year and quarter. This includes the process level and work state on
the employee record at the time of payment.

REFERENCED BY

PR291     PR292     HR170     HR70.1

UPDATED BY

PR289     PR83.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PWK-COMPANY            Numeric 4                                 PR289   PR83.1
Element: Company Hr    Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

PWK-PAYROLL-YEAR       Numeric 4                                 PR289   PR83.1
Element: Current PayrolContains the payroll year for which you
                       want to display or adjust weeks worked.

PWK-QUARTER            Numeric 1                                 PR289   PR83.1
Element: Quarter       Contains the fiscal quarter for the
                       data stored in this record.
                       1
                       2
                       3
                       4

PWK-EMPLOYEE           Numeric 9                                 PR289   PR83.1
Element: Employee      Contains the employee number. Each
                       person employed by the company is
                       assigned a unique number. The system
                       uses the employee number to correlate
                       all of the information related to that
                       person.

PWK-PROCESS-LEVEL      Alpha 5                                   PR289   PR83.1
Element: Process Lev HrContains the process level of employees
                       who worked in weeks associated with the
                       payroll year and quarter defined.

PWK-WORK-STATE         Alpha 2                                   PR289   PR83.1
Element: Work State    Contains the work state on the employee
                       record at the time of payment.

PWK-NBR-WEEKS          Signed 2.0                                PR289   PR83.1
Element: Nbr Weeks     Contains the number of weeks the
                       employee worked during the defined
                       payroll year and quarter.

PWK-REPORT-ENTITY      Alpha 5
Element: Report Entity

                         PRWEEKS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PWKSET1   COMPANY                                                PR289   PR291
          PAYROLL-YEAR                                           PR292   PR83.1
          QUARTER
          EMPLOYEE
          REPORT-ENTITY
          PROCESS-LEVEL
          WORK-STATE

PWKSET2   COMPANY                                                HR170   HR70.1
          EMPLOYEE
          PAYROLL-YEAR
          QUARTER
          REPORT-ENTITY
          PROCESS-LEVEL
          WORK-STATE

                         PRWEEKS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            PWK-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required

                            PWK-COMPANY          -> EMP-COMPANY
                            PWK-EMPLOYEE         -> EMP-EMPLOYEE

Process Level  PRSYSTEM     Required

                            PWK-COMPANY          -> PRS-COMPANY
                            PWK-PROCESS-LEVEL    -> PRS-PROCESS-LEVEL

Work State     PRSTATE      Required

                            PWK-WORK-STATE       -> PSA-STATE