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
Company              The company number represents an
                     established company and is entered on
                     all function codes.

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

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

PWK-EMPLOYEE         Numeric 9                                   PR289   PR83.1
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
Process Level        Contains 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
Work State           Contains the work state on the employee
                     record at the time of payment.

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

                         PRWEEKS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

PWKSET2   COMPANY       KeyChange                                HR170   HR70.1
          EMPLOYEE
          PAYROLL-YEAR
          QUARTER
          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