PROTPAYPRD – Overtime Pay Periods
- System
- Payroll (PR)
- Prefix
PRY- Primary key
COMPANY,PLAN-CODE,EFFECT-DATE,PAY-START-DATE- Fields
- 6
- Updated by
- 6 programs
- Referenced by
- 55 programs
PROTPAYPRD is the Overtime Pay Periods table in Lawson Payroll (prefix PRY). It is indexed by COMPANY, PLAN-CODE, EFFECT-DATE, PAY-START-DATE (PRYSET1); alternate indexes: PRYSET2 and PRYSET3. It is related 1:1 to PRSYSTEM and PROVERTIME. It is updated by PR192, PR21.1, PR21.3, PR21.4, PR521 and PR999 and referenced by BN100, BN101, BN102, BN103, BN105, BN145, BN150, BN245 and 47 more. The table has 6 fields, 3 indexes and 2 documented relations.
About PROTPAYPRD
This file contains the pay plans with the start and end dates of the pay periods within the plans.
Fields (6)
Column = COBOL field name without the PRY- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#PRY-COMPANY PKCOMPANY | Numeric 4 | — | PR21.1, PR21.4, PR521, PR999 |
#PRY-PLAN-CODE PKPLAN_CODE | Alpha 4 | Contains the user-defined code that represents a pay plan. | PR21.1, PR21.4, PR521, PR999 |
#PRY-EFFECT-DATE PKEFFECT_DATE | Numeric 8 (yyyymmdd) | Contains the effective date of the pay plan. | PR21.1, PR21.4, PR521, PR999 |
#PRY-PAY-START-DATE PKPAY_START_DATE | Numeric 8 (yyyymmdd) | Contains the pay period start date. | PR21.1, PR21.4, PR521, PR999 |
#PRY-PAY-END-DATEPAY_END_DATE | Numeric 8 (yyyymmdd) | Contains the pay period end date. | PR21.1, PR21.4, PR521, PR999 |
#PRY-STD-COST-HRSSTD_COST_HRS | Signed 7.2 | — | PR21.3, PR21.4, PR521 |
Indexes (3)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
PRYSET1 |
| Primary | BN100, BN101, BN102, BN103, BN105, BN145, BN150, BN245 +22 more (list truncated in source) | |
PRYSET2 |
| BN66.1, PR140, PR189, PR195, PR274, PR582, PR80.1, PR80.4 +5 more | ||
PRYSET3 |
| KeyChange | PR21.2, PR21.4, PR521, PR271, PR282, PR32.1, PR32.2, PR999 +1 more |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Company | PRSYSTEM | Required |
| ||||||||||
| Overtime Plan | PROVERTIME | Required |
|
Programs
Updated by (6)
- PR192 Nonstandard 12th of Month Calculation
- PR21.1 Pay Plan
- PR21.3 Pay Period Standard Cost Hours
- PR21.4 Nonstandard Pay and Work Period Entry
- PR521 Nonstandard Pay and Work Period CSV Load
- PR999 Payroll Year End Close
Referenced by (55)
- 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
- 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
- HS03.1 Time Entry Pay Period Dates
- HS18.1 Payroll Lock Out Rules
- PR134 Automatic Time Records
- PR139 Arrears Automation
- PR140 Earnings and Deductions Calculation
- PR189 Gross Up Calculation
- PR195 Accrual Program
- PR221 Pay Plan Listing
- PR271 US Affordable Care Act
- PR274 Statistics Canada
- PR282 Canada Record of Employment
- PR32.1 Employee Daily Time Entry
- PR32.2 Employee Daily Time Entry
- PR582 Mass Adjustment Load
- PR80.1 Manual Check
- PR80.4 Manual Payment
- PR82.1 Adjustment
- PR89.1 Payment Modeling
- PRAT.1 Alltax connection test
- PREN.1 Retrieve Period End Dates
- 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
- ZP551 Triad FSA Export Interface
- ZP580 Foundation Contributions Iface