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
BN150 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 PR131 PR132 PR134
PR135 PR136 PR137 PR139 PR189 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 PR36.4 PR37.1
PR45.1 PR529 PR530 PR560 PR582 PR80.1
PR80.4 PR82.1 UK102 TA147 BN100 BN101
BN102 BN103 BN105 BN145 BN245 BN260
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 ZB32.1 ZB32.2
ZB32.3 HPRO.1 HR11.1 HR11.2 HR11.4 HR211
HR28.1 HR51.2 HR51.8 HR511 HR52.2 LT101
LT111 ZH510 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
PR12.6 PR120 PR13.1 PR13.5 PR13.6 PR13.8
PR13.9 PR140 PR195 PR22.1 PR271 PR282
PR289 PR30.2 PR512 PR89.1 PR999 PRAT.1
PREN.1 ZP551 ZP580


UPDATED BY
PR21.1 PR192 LP102 LP140

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
PRO-DBL-MAX-HRS
Element: Max Hours Day		Signed 4.2
PR21.1
PRO-DBL-PREM-RATE
Element: Ot Prem Rate		Signed 13.4
PR21.1
PRO-DBL-PAY-CODE
Element: Pay Code		Alpha 4
PR21.1
PRO-DAY7-MAX-HRS
Element: Max Hours Day		Signed 4.2
PR21.1
PRO-DAY7-PREM-RATE
Element: Ot Prem Rate		Signed 13.4
PR21.1
PRO-DAY7-PAY-CODE
Element: Pay Code		Alpha 4
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 PR131
PR132 PR134
PR135 PR136
PROSET2 COMPANY
PLAN-CODE
EFFECT-DATE*
...
BN100 BN101
BN102 BN103
BN105 BN145
BN150 BN245
BN260 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


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 02:30:37 2016

Home
Contact Us



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