PROTWRKPRD – Overtime Work Periods
- System
- Payroll (PR)
- Prefix
PRW- Primary key
COMPANY,PLAN-CODE,EFFECT-DATE,WRK-START-DATE- Fields
- 5
- Updated by
- 4 programs
- Referenced by
- 36 programs
PROTWRKPRD is the Overtime Work Periods table in Lawson Payroll (prefix PRW). It is indexed by COMPANY, PLAN-CODE, EFFECT-DATE, WRK-START-DATE (PRWSET1); alternate indexes: PRWSET2 and PRWSET3. It is related 1:1 to PRSYSTEM and PROVERTIME. It is updated by PR21.1, PR21.4, PR521 and PR999 and referenced by BN100, BN101, BN102, BN103, BN105, BN145, BN245, BN260 and 28 more. The table has 5 fields, 3 indexes and 2 documented relations.
About PROTWRKPRD
This file contains the pay plans with the start and end dates of the work periods within the plans.
Fields (5)
Column = COBOL field name without the PRW- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
PRW-COMPANY PKCOMPANY | Numeric 4 | — | PR21.1, PR21.4, PR521, PR999 |
PRW-PLAN-CODE PKPLAN_CODE | Alpha 4 | Contains the user-defined code that represents a pay plan. | PR21.1, PR21.4, PR521, PR999 |
PRW-EFFECT-DATE PKEFFECT_DATE | Numeric 8 (yyyymmdd) | Contains the effective date of the pay plan. | PR21.1, PR21.4, PR521, PR999 |
PRW-WRK-START-DATE PKWRK_START_DATE | Numeric 8 (yyyymmdd) | Contains the work period start date. | PR21.1, PR21.4, PR521, PR999 |
PRW-WRK-END-DATEWRK_END_DATE | Numeric 8 (yyyymmdd) | Contains the work period end date. | PR21.1, PR21.4, PR521, PR999 |
Indexes (3)
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 |
|---|---|---|---|---|
PRWSET1 | COMPANY, PLAN-CODE, EFFECT-DATE, WRK-START-DATE | Primary | BN100, BN101, BN102, BN103, BN105, BN145, BN245, BN260 +22 more (list truncated in source) | |
PRWSET2 | COMPANY, PLAN-CODE, WRK-END-DATE, EFFECT-DATE* | KeyChange | PR131, PR132, PR32.1, PR32.2 | |
PRWSET3 | COMPANY, PLAN-CODE, EFFECT-DATE, WRK-START-DATE* | KeyChange | PR21.2, PR21.4, PR221, PR521, PR999, PREN.1 |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Company | PRSYSTEM | Required | PRW-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL | |
| Overtime Plan | PROVERTIME | Required | PRW-COMPANY → PRO-COMPANY, PRW-PLAN-CODE → PRO-PLAN-CODE, PRW-EFFECT-DATE → PRO-EFFECT-DATE |
Programs
Updated by (4)
- PR21.1 Pay Plan
- PR21.4 Nonstandard Pay and Work Period Entry
- PR521 Nonstandard Pay and Work Period CSV Load
- PR999 Payroll Year End Close
Referenced by (36)
- BN100 Employee Change Benefit Update
- BN101 Mass Benefit Add
- BN102 Plan Employee Update
- BN103 Mass Benefit Termination
- BN105 Plan Update
- BN145 Flex Dollars Calculation
- 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
- BN71.1 COBRA Benefit Entry
- BN72.1 Retiree Benefit Entry
- 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
- PR131 Retroactive Pay Calculation
- PR132 FLSA Overtime Calculation
- PR221 Pay Plan Listing
- PR32.1 Employee Daily Time Entry
- PR32.2 Employee Daily Time Entry
- 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