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
PA532 HS03.1 HS535 PR132 PR20.4 PR221
BN100 BN101 BN102 BN103 BN105 BN145
BN245 BN31.1 BN31.2 BN32.1 BN32.2 BN32.3
BN45.1 BN531 BN66.1 BN71.1 BN72.1 BS12.1
BS13.1 BS14.1 BS15.1 BS32.1 HCPL.1 HPRO.1
HR211 HR511 HR650 PA202 PA502 HS20.1
HS21.1 HS22.1 HS22.2 HS36.1 PR13.1 PR13.5
PR13.6 PR13.8 PR131 PR139 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
Company The company number represents an
established company and is entered on
all function codes.
PRO-PLAN-CODE Alpha 4 PR21.1
Plan Contains the user-defined code that
represents a pay plan.
PRO-EFFECT-DATE Numeric 8 (yyyymmdd) PR21.1
Effective Date Contains the effective date of the pay
plan.
PRO-DESCRIPTION Alpha 30 (Lower Case) PR21.1
Description Contains the pay plan description.
PRO-OT-PLAN Alpha 1 PR21.1
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
Period End Date Contains the end date of the first pay
period.
PRO-PAY-FREQUENCY Numeric 1 PR21.1
Pay Frequency Contains the pay frequency defined for
the pay plan.
1 = Weekly
2 = Bi-Weekly
3 = Semi-Monthly
4 = Monthly
PRO-WRK-END-DATE Numeric 8 (yyyymmdd) PR21.1 PR289
Wrk End Date Contains the end date of the first work
period.
PRO-NBR-DAYS Numeric 2 PR21.1
Number of Days Contains the number of days in the work
period.
07
28
PRO-STD-HOURS Signed 5.2 PR21.1
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
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
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
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
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
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
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
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
PROVERTIME FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PROSET1 COMPANY PA532 HS03.1
PLAN-CODE HS535 PR132
EFFECT-DATE PR20.4 PR21.1
PR21.2 PR21.3
PR221
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
BN66.1 BN71.1
BN72.1 BS12.1
BS13.1 BS14.1
BS15.1 BS32.1
HCPL.1 HPRO.1
HR211 HR511
HR650 PA202
PA502 HS20.1
...
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
|
