Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PROTPAYPRD


                            PROTPAYPRD FILE

                          Overtime Pay Periods

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

REFERENCED BY

BN100     BN101     BN102     BN103     BN105     BN145
BN245     BN31.1    BN31.2    BN32.1    BN32.2    BN32.3
BN340     BN45.1    BN531     BN66.1    BN71.1    BN72.1
BS12.1    BS13.1    BS14.1    BS15.1    BS32.1    HS03.1
PR139     PR140     PR189     PR195     PR221     PR80.1
PR89.1    HR650     PR82.1    PR282     PR32.1    PR32.2
PREN.1

UPDATED BY

PR21.1    PR21.3    PR999

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

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

PRY-PAY-START-DATE     Numeric 8  (yyyymmdd)                     PR21.1  PR999
Element: Pay Start DateContains the pay period start date.

PRY-PAY-END-DATE       Numeric 8  (yyyymmdd)                     PR21.1  PR999
Element: Pay End Date  Contains the pay period end date.

PRY-STD-COST-HRS       Signed 7.2                                PR21.3
Element: Std Cost Hrs

                         PROTPAYPRD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PRYSET1   COMPANY                                                BN100   BN101
          PLAN-CODE                                              BN102   BN103
          EFFECT-DATE                                            BN105   BN145
          PAY-START-DATE                                         BN245   BN31.1
                                                                 BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN340   BN45.1
                                                                 BN531   BN66.1
                                                                 BN71.1  BN72.1
                                                                 BS12.1  BS13.1
                                                                 BS14.1  BS15.1
                                                                 BS32.1  HS03.1
                                                                 PR139   PR140
                                                                 PR189   PR195
                                                                 PR21.1  PR21.2
                                                                 ...

PRYSET2   COMPANY                                                HR650   PR82.1
          PLAN-CODE
          EFFECT-DATE*
          PAY-START-DATE*

PRYSET3   COMPANY       KeyChange                                PR21.2  PR282
          PLAN-CODE                                              PR32.1  PR32.2
          EFFECT-DATE                                            PR999   PREN.1
          PAY-START-DATE*

                         PROTPAYPRD FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            PRY-COMPANY        -> PRS-COMPANY
                            Spaces             -> PRS-PROCESS-LEVEL

Overtime Plan  PROVERTIME   Required

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