Lawson Insight Technical Documentation

                            PROTWRKPRD FILE

                         Overtime Work Periods

This file contains the pay plans with the start and end dates of the work
periods within the plans.

REFERENCED BY

BN100     BN101     BN102     BN103     BN105     BN145
BN245     BN31.1    BN31.2    BN32.1    BN32.2    BN32.3
BN45.1    BN531     BN71.1    BN72.1    BS12.1    BS13.1
BS14.1    BS15.1    BS32.1    PR131     PR221     PR132
PR32.1    PR32.2    PREN.1

UPDATED BY

PR21.1    PR999

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PRW-COMPANY          Numeric 4                                   PR21.1  PR999
Company              The company number represents an
                     established company and is entered on
                     all function codes.


PRW-PLAN-CODE        Alpha 4                                     PR21.1  PR999
Plan                 Contains the user-defined code that
                     represents a pay plan.

PRW-EFFECT-DATE      Numeric 8  (yyyymmdd)                       PR21.1  PR999
Effective Date       Contains the effective date of the pay
                     plan.

PRW-WRK-START-DATE   Numeric 8  (yyyymmdd)                       PR21.1  PR999
Wrk Start Date       Contains the work period start date.

PRW-WRK-END-DATE     Numeric 8  (yyyymmdd)                       PR21.1  PR999
Wrk End Date         Contains the work period end date.

                         PROTWRKPRD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PRWSET1   COMPANY                                                BN100   BN101
          PLAN-CODE                                              BN102   BN103
          EFFECT-DATE                                            BN105   BN145
          WRK-START-DATE                                         BN245   BN31.1
                                                                 BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN45.1  BN531
                                                                 BN71.1  BN72.1
                                                                 BS12.1  BS13.1
                                                                 BS14.1  BS15.1
                                                                 BS32.1  PR131
                                                                 PR21.1  PR21.2
                                                                 PR221

PRWSET2   COMPANY       KeyChange                                PR131   PR132
          PLAN-CODE                                              PR32.1  PR32.2
          WRK-END-DATE
          EFFECT-DATE*

PRWSET3   COMPANY       KeyChange                                PR21.2  PR221
          PLAN-CODE                                              PR999   PREN.1
          EFFECT-DATE
          WRK-START-DATE*

                         PROTWRKPRD FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            PRW-COMPANY        -> PRS-COMPANY
                            Spaces             -> PRS-PROCESS-LEVEL

Overtime Plan  PROVERTIME   Required

                            PRW-COMPANY        -> PRO-COMPANY
                            PRW-PLAN-CODE      -> PRO-PLAN-CODE
                            PRW-EFFECT-DATE    -> PRO-EFFECT-DATE