PRWEEKS – Employee Weeks Worked
- System
- Payroll (PR)
- Prefix
PWK- Primary key
COMPANY,PAYROLL-YEAR,QUARTER,EMPLOYEE,REPORT-ENTITY,PROCESS-LEVEL,WORK-STATE- Fields
- 8
- Updated by
- 2 programs
- Referenced by
- 4 programs
PRWEEKS is the Employee Weeks Worked table in Lawson Payroll (prefix PWK). It is indexed by COMPANY, PAYROLL-YEAR, QUARTER, EMPLOYEE, REPORT-ENTITY, PROCESS-LEVEL, WORK-STATE (PWKSET1); alternate indexes: PWKSET2. It is related 1:1 to PRSYSTEM, EMPLOYEE and PRSTATE. It is updated by PR289 and PR83.1 and referenced by HR170, HR70.1, PR291 and PR292. The table has 8 fields, 2 indexes and 4 documented relations.
About PRWEEKS
This file contains the number of weeks an employee worked during the defined payroll year and quarter. This includes the process level and work state on the employee record at the time of payment.
Fields (8)
Column = COBOL field name without the PWK- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
PWK-COMPANY PKCOMPANY | Numeric 4 | — | PR289, PR83.1 |
PWK-PAYROLL-YEAR PKPAYROLL_YEAR | Numeric 4 | Contains the payroll year for which you want to display or adjust weeks worked. | PR289, PR83.1 |
PWK-QUARTER PKQUARTER | Numeric 1 | Contains the fiscal quarter for the data stored in this record. 1 2 3 4 | PR289, PR83.1 |
PWK-EMPLOYEE PKEMPLOYEE | Numeric 9 | Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person. | PR289, PR83.1 |
PWK-PROCESS-LEVEL PKPROCESS_LEVEL | Alpha 5 | Contains the process level of employees who worked in weeks associated with the payroll year and quarter defined. | PR289, PR83.1 |
PWK-WORK-STATE PKWORK_STATE | Alpha 2 | Contains the work state on the employee record at the time of payment. | PR289, PR83.1 |
PWK-NBR-WEEKSNBR_WEEKS | Signed 2.0 | Contains the number of weeks the employee worked during the defined payroll year and quarter. | PR289, PR83.1 |
PWK-REPORT-ENTITY PKREPORT_ENTITY | Alpha 5 | — | — |
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 |
|---|---|---|---|---|
PWKSET1 | COMPANY, PAYROLL-YEAR, QUARTER, EMPLOYEE, REPORT-ENTITY, PROCESS-LEVEL, WORK-STATE | Primary | PR289, PR291, PR292, PR83.1 | |
PWKSET2 | COMPANY, EMPLOYEE, PAYROLL-YEAR, QUARTER, REPORT-ENTITY, PROCESS-LEVEL, WORK-STATE | HR170, HR70.1 |
Relations
One to one (4) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Company | PRSYSTEM | Required | PWK-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL | |
| Employee | EMPLOYEE | Required | PWK-COMPANY → EMP-COMPANY, PWK-EMPLOYEE → EMP-EMPLOYEE | |
| Process Level | PRSYSTEM | Required | PWK-COMPANY → PRS-COMPANY, PWK-PROCESS-LEVEL → PRS-PROCESS-LEVEL | |
| Work State | PRSTATE | Required | PWK-WORK-STATE → PSA-STATE |