PROVERTIME

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
BN66.1 PR140 PR195 PR271 PR289 PR89.1
PREN.1


UPDATED BY
PR21.1 PR21.2 PR21.3 BN150 PR221 PR521
EXI2.1 EXI4.1 LP03.1 LP03.2 LP03.3 LP03.4
LP03.5 LP03.6 LP130 LP140 LP53.1 LP553
LP554 PA532 HS03.1 HS535 HS536 PR128
PR130 PR131 PR132 PR134 PR135 PR136
PR137 PR139 PR160 PR180 PR189 PR192
PR20.4 PR274 PR29.1 PR32.1 PR32.2 PR33.1
PR33.2 PR33.3 PR35.1 PR35.2 PR35.3 PR35.4
PR35.5 PR35.6 PR35.8 PR35.9 PR36.1 PR37.1
PR39.1 PR45.1 PR529 PR530 PR539 PR560
PR582 PR80.1 PR80.2 PR80.4 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
BN71.1 BN72.1 BN729 BS06.1 BS12.1 BS13.1
BS14.1 BS15.1 BS32.1 HPRO.1 HR11.1 HR11.2
HR211 HR51.2 HR51.8 HR511 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 HS36.1 PR110
PR113 PR120 PR13.1 PR13.5 PR13.6 PR13.8
PR13.9 PR22.1 PR282 PR999

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRO-COMPANY
Element: Company Hr		Numeric 4
PR21.1
PRO-PLAN-CODE
Element: Plan Code		Alpha 4
Contains the user-defined code that represents a pay plan.
PR21.1
PRO-EFFECT-DATE
Element: Effect Date		Numeric 8 (yyyymmdd)
Contains the effective date of the pay plan.
PR21.1
PRO-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
Contains the pay plan description.
PR21.1
PRO-OT-PLAN
Element: Ot Plan		Alpha 1
Contains the value that indicates if the pay plan is an overtime pay plan.
Y = Yes
N = No
PR21.1
PRO-PER-END-DATE
Element: Per End Date		Numeric 8 (yyyymmdd)
Contains the end date of the first pay period.
PR21.1
PRO-PAY-FREQUENCY
Element: Pay Frequency		Numeric 1
Contains the pay frequency defined for the pay plan.
1 = Weekly
2 = Bi-Weekly
3 = Semi-Monthly
4 = Monthly
5 = UK Four-Weekly
6 = Nonstandard Semi-Monthly
7 = Nonstandard Monthly
PR21.1
PRO-WRK-END-DATE
Element: Wrk End Date		Numeric 8 (yyyymmdd)
Contains the end date of the first work period.
PR21.1 PR289
PRO-NBR-DAYS
Element: Nbr Days		Numeric 2
Contains the number of days in the work period.
07
28
PR21.1
PRO-STD-HOURS
Element: Std Hours		Signed 5.2
Contains the number of hours in the work period after which point overtime is paid.
PR21.1
PRO-MAX-HOURS-DAY
Element: Max Hours Day		Signed 4.2
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.
PR21.1
PRO-OT-PREM-RATE
Element: Ot Prem Rate		Signed 13.4
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.
PR21.1
PRO-PAY-CODE
Element: Pay Code		Alpha 4
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.
PR21.1
PRO-WORK-PRD-FLAG
Element: Work Prd Flag		Alpha 1
Contains the value that indicates if overtime pay is based on a fixed or fluctuating work period.
F = Fixed
L = Fluctuating
PR21.1
PRO-FIXED-HOURS
Element: Fixed Hours		Numeric 3
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.
PR21.1
PRO-CALC-OT-HOURS
Element: Calc Ot Hours		Alpha 1
Contains the option that indicates whether or not the system calculates overtime hours.
N = No
Y = Yes
PR21.1
PRO-PAY-PER-OVR
Element: Pay Per Ovr		Alpha 1
Indicates whether or not the pay periods are overridden to be 27 or 53 instead of 26 or 52.
N = No
Y = Yes
PR21.1
PRO-DFLT-PAY-DATE
Element: Dflt Pay Date		Numeric 8 (yyyymmdd)
PR21.1


PROVERTIME FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PROSET1 COMPANY
PLAN-CODE
EFFECT-DATE
...
BN150 PR21.1
PR21.2 PR21.3
PR21.4 PR221
PR521 EXI2.1
EXI4.1 LP03.1
LP03.2 LP03.3
LP03.4 LP03.5
LP03.6 LP130
LP140 LP53.1
LP553 LP554
PA532 HS03.1
HS535 HS536
PR128 PR130
PR131 PR132
PR134 PR135
PROSET2 COMPANY
PLAN-CODE
EFFECT-DATE*
...
BN100 BN101
BN102 BN103
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
BN729 BS06.1
BS12.1 BS13.1
BS14.1 BS15.1
BS32.1 HPRO.1
HR11.1 HR11.2


PROVERTIME FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED 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

File created: Wed Jun 08 20:51:11 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.