PROVERTIME – Overtime Pay Plan

System: Payroll (PR)
Prefix: PRO
Primary key: COMPANY, PLAN-CODE, EFFECT-DATE
Fields: 24
Updated by: 4 programs
Referenced by: 147 programs

PROVERTIME is the Overtime Pay Plan table in Lawson Payroll (prefix PRO). It is indexed by COMPANY, PLAN-CODE, EFFECT-DATE (PROSET1); alternate indexes: PROSET2. It is related 1:1 to PRSYSTEM and PRPAYCODE and 1:M to PATHFIND, PROTPAYPRD and PROTWRKPRD. It is updated by LP102, LP140, PR192 and PR21.1 and referenced by BN100, BN101, BN102, BN103, BN105, BN145, BN150, BN245 and 139 more. The table has 24 fields, 2 indexes and 5 documented relations.

About PROVERTIME

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.

Fields (24)

Column = COBOL field name without the PRO- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`PRO-COMPANY` PK COMPANY	Numeric 4	—	PR21.1
`PRO-PLAN-CODE` PK PLAN_CODE	Alpha 4	Contains the user-defined code that represents a pay plan.	PR21.1
`PRO-EFFECT-DATE` PK EFFECT_DATE	Numeric 8 (yyyymmdd)	Contains the effective date of the pay plan.	PR21.1
`PRO-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	Contains the pay plan description.	PR21.1
`PRO-OT-PLAN` 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` PER_END_DATE	Numeric 8 (yyyymmdd)	Contains the end date of the first pay period.	PR21.1
`PRO-PAY-FREQUENCY` 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` WRK_END_DATE	Numeric 8 (yyyymmdd)	Contains the end date of the first work period.	PR21.1, PR289
`PRO-NBR-DAYS` NBR_DAYS	Numeric 2	Contains the number of days in the work period. 07 28	PR21.1
`PRO-STD-HOURS` 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` 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` 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` 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` 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` 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` 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` 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` DFLT_PAY_DATE	Numeric 8 (yyyymmdd)	—	PR21.1
`PRO-DBL-MAX-HRS` DBL_MAX_HRS	Signed 4.2	—	PR21.1
`PRO-DBL-PREM-RATE` DBL_PREM_RATE	Signed 13.4	—	PR21.1
`PRO-DBL-PAY-CODE` DBL_PAY_CODE	Alpha 4	—	PR21.1
`PRO-DAY7-MAX-HRS` DAY7_MAX_HRS	Signed 4.2	—	PR21.1
`PRO-DAY7-PREM-RATE` DAY7_PREM_RATE	Signed 13.4	—	PR21.1
`PRO-DAY7-PAY-CODE` DAY7_PAY_CODE	Alpha 4	—	PR21.1

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`PROSET1`	`COMPANY`, `PLAN-CODE`, `EFFECT-DATE`	Primary		BN150, PR21.1, PR21.2, PR21.3, PR21.4, PR221, PR521, EXI2.1 +22 more (list truncated in source)
`PROSET2`	`COMPANY`, `PLAN-CODE`, `EFFECT-DATE*`			BN100, BN101, BN102, BN103, BN105, BN145, BN150, BN245 +22 more (list truncated in source)

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
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`

One to many (3) — child tables

Relation	Table	Rules	Field map
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`

Programs

Updated by (4)

LP102 Employee Master Update
LP140 Employee Absence Plan Calculation
PR192 Nonstandard 12th of Month Calculation
PR21.1 Pay Plan

Referenced by (147)

BN100 Employee Change Benefit Update
BN101 Mass Benefit Add
BN102 Plan Employee Update
BN103 Mass Benefit Termination
BN105 Plan Update
BN145 Flex Dollars Calculation
BN150 Life Insurance Reportable Income
BN245 Benefit Election Form
BN260 Employee Benefit Extract
BN305 Highly Compensated Employees
BN31.1 Speed Benefit Entry
BN31.2 Employee Benefit Entry
BN32.1 Employee Benefit Changes
BN32.2 Employee Benefit Detail Changes
BN32.3 Benefit Add
BN340 ADP and ACP Tests
BN45.1 Employee Flex Credits
BN531 Batch Benefit Enrollment
BN66.1 Estimated Pay Calculation
BN71.1 COBRA Benefit Entry
BN72.1 Retiree Benefit Entry
BS06.1 Benefits Cycle Rules
BS12.1 Web Enrollment Eligible New Plans
BS13.1 Web Enrollment Coverage Options
BS14.1 Web Enrollment Coverage Amounts
BS15.1 Web Enrollment Contribution Limits
BS32.1 Web Enrollment Stop Benefits Update
EXI2.1 Invoke for PRTRDPD
EXI4.1 Invoke for PRPRBPD
HPRO.1 Activity Selection Invoke
HR11.1 Employee
HR11.2 Compensation Analysis
HR11.4 Employee Assignment Inquiry
HR211 Employee Listing
HR28.1 Employee Ethnicity
HR51.2 Employee Interface Data
HR51.8 WFM Interface Data
HR511 Employee Conversion
HR52.2 Talent Management Interface Data
HS03.1 Time Entry Pay Period Dates
HS18.1 Payroll Lock Out Rules
HS20.1 Time Form Inquiry
HS21.1 Time Form Inquiry
HS22.1 Pending Time Summary
HS22.2 Direct Reports Pay Plans
HS22.3 Reporting Pay Plans With Dates
HS36.1 Pending Time Records
HS535 Pending Time Record Extract
HS536 Pending Time Record Purge
LP03.1 Service Rule
LP03.2 Accrual Rule
LP03.3 Eligibility Rule
LP03.4 Limit Rule
LP03.5 Payroll Rule
LP03.6 General Ledger Rule
LP130 Absence Plan Payout
LP53.1 Employee Service Entry
LP553 Employee Service and Event Conversion
LP554 Employee Service and Event History Conversion
LT101 HRM Receiver Update
LT111 HRM Receiver Update
PA02.1 Position
PA100 Action Update
PA102 Position Update
PA103 Mass Position Changes
PA115 Employee Purge
PA13.1 Multiple Positions and Jobs
PA13.2 Multiple Position and Job History
PA202 Position Listing
PA502 Position Conversion
PA513 Position and Job Conversion
PA52.1 Individual Action
PA52.3 Mass Action
PA52.4 Hire an Applicant
PA52.5 Position and Job Action
PA532 Code, Requisitions Exports
PR110 Step And Grade Audit
PR113 United States Tax Deduction Update
PR12.6 Employee Automatic Deposit
PR120 Mass Pay Update
PR128 Offset Time Record Creation
PR13.1 Employee United States Taxes
PR13.5 Employee Canada Taxes
PR13.6 Employee Canada Taxes
PR13.8 U.S. Tax Deduction Errors
PR13.9 Employee Additional Tax Details
PR131 Retroactive Pay Calculation
PR132 FLSA Overtime Calculation
PR134 Automatic Time Records
PR135 Time Record Edit
PR136 Missing Time Records
PR137 Batch Time Record Update
PR139 Arrears Automation
PR140 Earnings and Deductions Calculation
PR189 Gross Up Calculation
PR195 Accrual Program
PR20.4 Pay Code
PR22.1 Pay Plan Schedules
PR221 Pay Plan Listing
PR271 US Affordable Care Act
PR274 Statistics Canada
PR282 Canada Record of Employment
PR289 Weeks Worked Calculation
PR29.1 Pension Payment Maintenance
PR30.2 Employee Automatic Time Record
PR32.1 Employee Daily Time Entry
PR32.2 Employee Daily Time Entry
PR33.1 Speed Entry Setup
PR33.2 Speed Entry by Number
PR33.3 Speed Entry by Name
PR35.1 Time Entry
PR35.2 Detail Time Entry
PR35.3 Speed Time Entry
PR35.4 Step and Grade, Grade Range Time Entry
PR35.5 Attendance Time Entry
PR35.6 Activity Time Entry
PR35.8 Position Time Entry
PR35.9 Reason Code Time Entry
PR36.1 Time Record Entry
PR36.4 Manual Time Record Maintenance
PR37.1 Batch Time Control
PR45.1 Error Processing
PR512 Employee ACH Distribution Interface
PR521 Nonstandard Pay and Work Period CSV Load
PR529 Pension Payroll Conversion
PR530 Time Record Interface CSV
PR560 Payroll History Load CSV
PR582 Mass Adjustment Load
PR80.1 Manual Check
PR80.4 Manual Payment
PR82.1 Adjustment
PR89.1 Payment Modeling
PR999 Payroll Year End Close
PRAT.1 Alltax connection test
PREN.1 Retrieve Period End Dates
TA147 Canada Vacation Audit
UK102 Bonus Pay Update
ZB10.1 Coverage Options Calculator
ZB10.2 Get Benefit Eligibility Dates
ZB31.1 Speed Benefit Entry
ZB31.2 Employee Benefit Entry
ZB32.1 Employee Benefit Changes
ZB32.2 Employee Benefit Detail Changes
ZB32.3 Benefit Add
ZH510 Update PCP from ZPENDPCP
ZP551 Triad FSA Export Interface
ZP580 Foundation Contributions Iface