Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PROVERTIME


                            PROVERTIME FILE

                           Overtime Pay Plan

This file contains information about pay plans, identifying pay and work week
periods and pay frequency. If the plan is an overtime plan, this file
identifies the number of hours worked after which point overtime is paid,
either weekly or daily, and if overtime is based on a fixed or fluctuating
work period.

REFERENCED BY

BN150     PR221     PA532     HS03.1    HS535     PR128
PR130     PR131     PR132     PR134     PR136     PR137
PR160     PR180     PR20.4    PR29.1    PR32.2    PR33.2
PR33.3    PR35.1    PR35.2    PR35.3    PR35.4    PR35.5
PR35.6    PR35.8    PR35.9    PR36.1    PR39.1    PR45.1
PR529     PR530     PR560     PR82.1    UK102     UK141
UK145     UK201     UK85.1    UK85.3    TA147     TP135
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    HPRO.1    HR11.1    HR11.2
HR211     HR511     PA02.1    PA100     PA102     PA103
PA202     PA502     PA52.1    PA52.3    PA52.4    PA52.5
HS20.1    HS21.1    HS22.1    HS22.2    HS22.3    HS36.1
PR110     PR113     PR120     PR13.1    PR13.5    PR13.6
PR13.8    PR22.1    PR289     PR999     PREN.1

UPDATED BY

PR21.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PRO-COMPANY            Numeric 4                                 PR21.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.

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

PRO-EFFECT-DATE        Numeric 8  (yyyymmdd)                     PR21.1
Element: Effective DateContains the effective date of the pay
                       plan.

PRO-DESCRIPTION        Alpha 30  (Lower Case)                    PR21.1
Element: Description   Contains the pay plan description.

PRO-OT-PLAN            Alpha 1                                   PR21.1
Element: Ot Plan       Contains the value that indicates if
                       the pay plan is an overtime pay plan.
                       Y = Yes
                       N = No

PRO-PER-END-DATE       Numeric 8  (yyyymmdd)                     PR21.1
Element: Period End DatContains the end date of the first pay
                       period.

PRO-PAY-FREQUENCY      Numeric 1                                 PR21.1
Element: Pay Frequency Contains the pay frequency defined for
                       the pay plan.
                       1 = Weekly
                       2 = Bi-Weekly
                       3 = Semi-Monthly
                       4 = Monthly
                       5 = UK Four-Weekly

PRO-WRK-END-DATE       Numeric 8  (yyyymmdd)                     PR21.1  PR289
Element: Wrk End Date  Contains the end date of the first work
                       period.

PRO-NBR-DAYS           Numeric 2                                 PR21.1
Element: Number of DaysContains the number of days in the work
                       period.
                       07
                       28

PRO-STD-HOURS          Signed 5.2                                PR21.1
Element: Std Hours     Contains the number of hours in the
                       work period after which point overtime
                       is paid.

PRO-MAX-HOURS-DAY      Signed 4.2                                PR21.1
Element: Max Hours Day Contains the number of hours in a day
                       after which point overtime is paid. This
                       value is used for plans that pay
                       overtime for hours worked in excess of a
                       daily limit.

PRO-OT-PREM-RATE       Signed 13.4                               PR21.1
Element: Ot Prem Rate  Contains the overtime premium rate. If
                       a premium rate is not defined for an
                       overtime plan, the premium rate defined
                       for the pay code defaults.

PRO-PAY-CODE           Alpha 4                                   PR21.1
Element: Payment Code  Contains the overtime pay code. If the
                       pay plan is an overtime plan, PR132
                       (FLSA Overtime Calculation)
                       automatically calculates the overtime
                       and creates a time record for the
                       overtime pay code.

PRO-WORK-PRD-FLAG      Alpha 1                                   PR21.1
Element: Work Prd Flag Contains the value that indicates if
                       overtime pay is based on a fixed or
                       fluctuating work period.
                       F = Fixed
                       L = Fluctuating

PRO-FIXED-HOURS        Numeric 3                                 PR21.1
Element: Fixed Hours   Contains the number of hours a salaried
                       employee's pay is intended to compensate
                       for the work period. The system uses
                       this field for fixed work week plans.

PRO-CALC-OT-HOURS      Alpha 1                                   PR21.1
Element: Calc Ot Hours Contains the option that indicates
                       whether or not the system calculates
                       overtime hours.
                       N = No
                       Y = Yes

PRO-PAY-PER-OVR        Alpha 1                                   PR21.1
Element: Pay Per Ovr   Indicates whether or not the pay periods
                       are overridden to be 27 or 53 instead of
                       26 or 52.
                       N = No
                       Y = Yes

PRO-DFLT-PAY-DATE      Numeric 8  (yyyymmdd)                     PR21.1
Element: Dflt Pay Date

                         PROVERTIME FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PROSET1   COMPANY                                                BN150   PR21.1
          PLAN-CODE                                              PR21.2  PR21.3
          EFFECT-DATE                                            PR221   PA532
                                                                 HS03.1  HS535
                                                                 PR128   PR130
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR137   PR160
                                                                 PR180   PR20.4
                                                                 PR29.1  PR32.2
                                                                 PR33.2  PR33.3
                                                                 PR35.1  PR35.2
                                                                 PR35.3  PR35.4
                                                                 PR35.5  PR35.6
                                                                 PR35.8  PR35.9
                                                                 ...

PROSET2   COMPANY                                                BN100   BN101
          PLAN-CODE                                              BN102   BN103
          EFFECT-DATE*                                           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  HPRO.1
                                                                 HR11.1  HR11.2
                                                                 HR211   HR511
                                                                 PA02.1  PA100
                                                                 PA102   PA103
                                                                 ...

                         PROVERTIME FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            PRO-COMPANY        -> PRS-COMPANY
                            Spaces             -> PRS-PROCESS-LEVEL

Pay Code       PRPAYCODE    Required

                            PRO-COMPANY        -> PCD-COMPANY
                            PRO-PAY-CODE       -> PCD-PAY-CODE
                            Spaces             -> PCD-PROCESS-LEVEL
                            Spaces             -> PCD-JOB-CODE

                         PROVERTIME FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Employees      PATHFIND     Delete Restricted

                            PRO-COMPANY        -> PTF-COMPANY
                            106                -> PTF-FLD-NBR
                            PRO-PLAN-CODE      -> PTF-FLD-VALUE
                                                  PTF-EMPLOYEE
                                                  PTF-POS-LEVEL

Pay Prd Sched  PROTPAYPRD   Delete Cascades

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

Wrk Prd Sched  PROTWRKPRD   Delete Cascades

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