Lawson Insight Technical Documentation |
|
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
AC541 AC542 BN150 PA532 HS03.1 HS535
PR128 PR130 PR131 PR132 PR134 PR136
PR137 PR139 PR160 PR180 PR189 PR20.4
PR221 PR29.1 PR32.2 PR33.2 PR33.3 PR35.1
PR35.2 PR35.3 PR35.4 PR35.5 PR35.6 PR35.8
PR36.1 PR39.1 PR45.1 PR529 PR530 PR560
PR80.1 PR80.2 PR82.1 UK102 UK13.1 UK141
UK145 UK201 UK560 UK85.1 UK85.3 TA147
UK120 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
HCPL.1 HPRO.1 HR11.1 HR11.2 HR211 HR511
HR650 PA02.1 PA100 PA102 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 PR140
PR195 PR22.1 PR289 PR89.1 PR999 PREN.1
UPDATED BY
PR21.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRO-COMPANY Numeric 4 PR21.1
Element: Company The company number represents an
established company and is entered on
all function codes.
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: Date Contains 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: Date Contains 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: Posting Day Contains 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 AC541 AC542
PLAN-CODE BN150 PA532
EFFECT-DATE HS03.1 HS535
PR128 PR130
PR131 PR132
PR134 PR136
PR137 PR139
PR160 PR180
PR189 PR20.4
PR21.1 PR21.2
PR21.3 PR221
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
...
PROSET2 COMPANY BN100 BN101
PLAN-CODE BN102 BN103
EFFECT-DATE* 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 HCPL.1
HPRO.1 HR11.1
HR11.2 HR211
HR511 HR650
...
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
|