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 LP102 LP140 MR551 PR140 PR195
PR271 PR289 PR89.1 ZP551 HS03.1 UK85.1
UK85.3 HPRO.1 HS20.1 HS21.1 PR22.1 PR999
PREN.1


UPDATED BY
BN100 BN101 BN102 BN103 BN105 BN145
BN150 BN245 BN305 BN31.1 BN31.2 BN32.1
BN32.2 BN32.3 BN340 BN45.1 BN531 BN71.1
BN72.1 BS06.1 BS12.1 BS13.1 BS14.1 BS15.1
BS32.1 ZB10.1 ZB10.2 ZB31.1 ZB31.2 ZB32.1
ZB32.2 ZB32.3 HR11.1 HR11.2 HR211 HR28.1
HR511 LT101 PR21.1 PR21.2 PR21.3 PR221
PR521 ZH510 EXI2.1 EXI4.1 LP03.1 LP03.2
LP03.3 LP03.4 LP03.5 LP03.6 LP130 LP53.1
LP553 LP554 PA02.1 PA100 PA102 PA103
PA115 PA13.1 PA13.2 PA202 PA502 PA513
PA52.1 PA52.3 PA52.4 PA52.5 PA532 ZE531
HS18.1 HS22.1 HS22.2 HS36.1 HS535 HS536
PR110 PR113 PR12.6 PR120 PR128 PR13.1
PR13.5 PR13.6 PR13.8 PR13.9 PR130 PR131
PR132 PR134 PR135 PR136 PR137 PR139
PR160 PR180 PR189 PR192 PR20.4 PR274
PR282 PR29.1 PR30.2 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 ZP530
ZP580 TA147

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
LP53.1 LP553
LP554 PA532
HS03.1 HS18.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
BS06.1 BS12.1
BS13.1 BS14.1
BS15.1 BS32.1
ZB10.1 ZB10.2
ZB31.1 ZB31.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: Thu Jun 09 11:27:17 2016

Home
Contact Us



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