|
|
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 ET530 ETI2.1 PR221 LP03.1 LP03.2
LP03.3 LP03.4 LP03.5 LP03.6 LP130 LP53.1
LP553 LP554 PA532 HS03.1 HS535 PR128
PR130 PR131 PR132 PR134 PR136 PR137
PR139 PR160 PR180 PR189 PR20.4 PR274
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 PR539
PR560 PR80.1 PR80.2 PR82.1 UK102 UK13.1
UK141 UK145 UK201 UK560 UK85.1 UK85.3
TA147 BN100 BN101 BN102 BN103 BN105
BN145 BN245 BN305 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 HPRO.1 HR11.1 HR11.2 HR211 HR511
LP140 PA02.1 PA100 PA102 PA103 PA115
PA13.1 PA13.2 PA202 PA502 PA513 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 Hr
PRO-PLAN-CODE Alpha 4 PR21.1
Element: Plan Code Contains the user-defined code that
represents a pay plan.
PRO-EFFECT-DATE Numeric 8 (yyyymmdd) PR21.1
Element: Effect 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: Per End 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: Nbr Days 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: Pay 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 ET530
PLAN-CODE ETI2.1 PR21.1
EFFECT-DATE PR21.2 PR21.3
PR221 LP03.1
LP03.2 LP03.3
LP03.4 LP03.5
LP03.6 LP130
LP53.1 LP553
LP554 PA532
HS03.1 HS535
PR128 PR130
PR131 PR132
PR134 PR136
PR137 PR139
PR160 PR180
...
PROSET2 COMPANY BN100 BN101
PLAN-CODE BN102 BN103
EFFECT-DATE* BN105 BN145
BN150 BN245
BN305 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 HPRO.1
HR11.1 HR11.2
HR211 HR511
...
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
|
