PRDEDDTL – No description in the Lawson data dictionary

System
Payroll (PR)
Prefix
PDE
Primary key
PYD-OBJ-ID, TAX-STATUS
Fields
8
Updated by
17 programs
Referenced by
3 programs

PRDEDDTL is a Lawson Payroll table (prefix PDE); no description in the lawson data dictionary. It is indexed by PYD-OBJ-ID, TAX-STATUS (PDESET1); alternate indexes: PDESET2 and PDESET3. It is related 1:1 to EMPLOYEE. It is updated by BN66.1, HR00.1, HR01.1, HR11.1, PA115, PR140, PR189, PR195 and 9 more and referenced by PR141, PR262 and PR294. The table has 8 fields, 3 indexes and 1 documented relation.

About PRDEDDTL

No description in the Lawson data dictionary.

Fields (8)

Column = COBOL field name without the PDE- 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
#PDE-COMPANY SET3
COMPANY		Numeric 4—BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
#PDE-EMPLOYEE SET3
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.BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
#PDE-PYD-OBJ-ID PK
PYD_OBJ_ID		Numeric 12—BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR85.1, PR89.1 +1 more
#PDE-QTD-OBJ-ID SET2
QTD_OBJ_ID		Numeric 12—BN66.1, PR140, PR189, PR195, PR197, PR582, PR80.1, PR80.4 +4 more
#PDE-TAX-STATUS PK
TAX_STATUS		Alpha 2—BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
#PDE-NONTAX-REMUN
NONTAX_REMUN		Signed 13.2—BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR85.1, PR89.1 +1 more
#PDE-TAXABLE-MATCH
TAXABLE_MATCH		Signed 13.2—BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR85.1, PR89.1 +1 more
#PDE-REMUN-CODE
REMUN_CODE		Alpha 4——

Indexes (3)

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
PDESET1
  1. PYD-OBJ-ID
  2. TAX-STATUS
PrimaryBN66.1, PR140, PR141, PR189, PR195, PR197, PR262, PR582 +6 more
PDESET2
  1. QTD-OBJ-ID
  2. TAX-STATUS
  3. PYD-OBJ-ID
KeyChange, SubsetWhere QTD-OBJ-ID != ZeroesPR294, PR300
PDESET3
  1. COMPANY
  2. EMPLOYEE
  3. PYD-OBJ-ID
  4. TAX-STATUS
SubsetWhere TAX-STATUS != SpacesHR00.1, HR01.1, HR11.1, PA115

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
EmployeeEMPLOYEERequired
PDE-COMPANY→EMP-COMPANY
PDE-EMPLOYEE→EMP-EMPLOYEE

Programs

Updated by (17)

Referenced by (3)