PREMPWKPAT – No description in the Lawson data dictionary
- System
- Payroll (PR)
- Prefix
WKE- Primary key
COMPANY,EMPLOYEE,PATT-EFF-FROM- Fields
- 13
- Updated by
- 0 programs
- Referenced by
- 0 programs
PREMPWKPAT is a Lawson Payroll table (prefix WKE); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, PATT-EFF-FROM (WKESET1); alternate indexes: WKESET3. It is related 1:1 to EMPLOYEE, PRWKPAT and PRWKPATDTL. The table has 13 fields, 2 indexes and 3 documented relations.
About PREMPWKPAT
No description in the Lawson data dictionary.
Fields (13)
Column = COBOL field name without the WKE- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
WKE-COMPANY PKCOMPANY | Numeric 4 | — | — |
WKE-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. | — |
WKE-PATTERN-CODEPATTERN_CODE | Alpha 3 | — | — |
WKE-PATT-EFF-FROM PKPATT_EFF_FROM | Numeric 8 (yyyymmdd) | — | — |
WKE-WEEK-NBRWEEK_NBR | Numeric 2 | — | — |
WKE-EFF-DATE-TOEFF_DATE_TO | Numeric 8 (yyyymmdd) | — | — |
WKE-SUN-DETLSUN_DETL | Signed 4.2 | — | — |
WKE-MON-DETLMON_DETL | Signed 4.2 | — | — |
WKE-TUE-DETLTUE_DETL | Signed 4.2 | — | — |
WKE-WED-DETLWED_DETL | Signed 4.2 | — | — |
WKE-THU-DETLTHU_DETL | Signed 4.2 | — | — |
WKE-FRI-DETLFRI_DETL | Signed 4.2 | — | — |
WKE-SAT-DETLSAT_DETL | Signed 4.2 | — | — |
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 |
|---|---|---|---|---|
WKESET1 | COMPANY, EMPLOYEE, PATT-EFF-FROM | Primary | TM260, TM265 | |
WKESET3 | PATTERN-CODE, WEEK-NBR, COMPANY, EMPLOYEE, PATT-EFF-FROM | KeyChange | — |
Relations
One to one (3) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Employee | EMPLOYEE | Required | WKE-COMPANY → EMP-COMPANY (EMPSET1), WKE-EMPLOYEE → EMP-EMPLOYEE | |
| Prwkpat | PRWKPAT | Required | WKE-PATTERN-CODE → WKP-PATTERN-CODE | |
| Prwkpatdtl | PRWKPATDTL | Required | WKE-PATTERN-CODE → WKD-PATTERN-CODE, WKE-WEEK-NBR → WKD-WEEK-NBR |
Programs
No Lawson programs are documented as updating or referencing this table.