PRWKPAT – No description in the Lawson data dictionary
- System
- Payroll (PR)
- Prefix
WKP- Primary key
PATTERN-CODE- Fields
- 3
- Updated by
- 0 programs
- Referenced by
- 0 programs
PRWKPAT is a Lawson Payroll table (prefix WKP); no description in the lawson data dictionary. It is indexed by PATTERN-CODE (WKPSET1). It is related 1:M to PREMPWKPAT and PRWKPATDTL. The table has 3 fields, 1 index and 2 documented relations.
About PRWKPAT
No description in the Lawson data dictionary.
Fields (3)
Column = COBOL field name without the WKP- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
WKP-PATTERN-CODE PKPATTERN_CODE | Alpha 3 | — | — |
WKP-PATTERN-DESCPATTERN_DESC | Alpha 20 | — | — |
WKP-WEEKS-IN-PATTWEEKS_IN_PATT | Numeric 3 | — | — |
Indexes (1)
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 |
|---|---|---|---|---|
WKPSET1 | PATTERN-CODE | Primary | TM260, TM265 |
Relations
One to many (2) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Prempwkpat | PREMPWKPAT | Delete Cascades | WKP-PATTERN-CODE → WKE-PATTERN-CODE, WKE-WEEK-NBR, WKE-COMPANY, WKE-EMPLOYEE, WKE-PATT-EFF-FROM | |
| Prwkpatdtl | PRWKPATDTL | Delete Cascades | WKP-PATTERN-CODE → WKD-PATTERN-CODE, WKD-WEEK-NBR |
Programs
No Lawson programs are documented as updating or referencing this table.