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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#WKE-COMPANY PK
COMPANY		Numeric 4——
#WKE-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains 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-CODE SET3
PATTERN_CODE		Alpha 3——
#WKE-PATT-EFF-FROM PK
PATT_EFF_FROM		Numeric 8 (yyyymmdd)——
#WKE-WEEK-NBR SET3
WEEK_NBR		Numeric 2——
#WKE-EFF-DATE-TO
EFF_DATE_TO		Numeric 8 (yyyymmdd)——
#WKE-SUN-DETL
SUN_DETL		Signed 4.2——
#WKE-MON-DETL
MON_DETL		Signed 4.2——
#WKE-TUE-DETL
TUE_DETL		Signed 4.2——
#WKE-WED-DETL
WED_DETL		Signed 4.2——
#WKE-THU-DETL
THU_DETL		Signed 4.2——
#WKE-FRI-DETL
FRI_DETL		Signed 4.2——
#WKE-SAT-DETL
SAT_DETL		Signed 4.2——

Indexes (2)

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.

IndexKeysFlagsConditionUsed in
WKESET1
  1. COMPANY
  2. EMPLOYEE
  3. PATT-EFF-FROM
PrimaryTM260, TM265
WKESET3
  1. PATTERN-CODE
  2. WEEK-NBR
  3. COMPANY
  4. EMPLOYEE
  5. PATT-EFF-FROM
KeyChange—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
EMPLOYEEPRWKPATPRWKPATDTLPREMPWKPAT

One to one (3) — lookups and parents

RelationTableRulesConditionField map
EmployeeEMPLOYEERequired
WKE-COMPANY→EMP-COMPANY (EMPSET1)
WKE-EMPLOYEE→EMP-EMPLOYEE
PrwkpatPRWKPATRequired
WKE-PATTERN-CODE→WKP-PATTERN-CODE
PrwkpatdtlPRWKPATDTLRequired
WKE-PATTERN-CODE→WKD-PATTERN-CODE
WKE-WEEK-NBR→WKD-WEEK-NBR

Programs

No Lawson programs are documented as updating or referencing this table.