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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
PDE-COMPANYCOMPANY | Numeric 4 | — | BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1 |
PDE-EMPLOYEEEMPLOYEE | 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. | BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1 |
PDE-PYD-OBJ-ID PKPYD_OBJ_ID | Numeric 12 | — | BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR85.1, PR89.1 +1 more |
PDE-QTD-OBJ-IDQTD_OBJ_ID | Numeric 12 | — | BN66.1, PR140, PR189, PR195, PR197, PR582, PR80.1, PR80.4 +4 more |
PDE-TAX-STATUS PKTAX_STATUS | Alpha 2 | — | BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1 |
PDE-NONTAX-REMUNNONTAX_REMUN | Signed 13.2 | — | BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR85.1, PR89.1 +1 more |
PDE-TAXABLE-MATCHTAXABLE_MATCH | Signed 13.2 | — | BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR85.1, PR89.1 +1 more |
PDE-REMUN-CODEREMUN_CODE | Alpha 4 | — | — |
Indexes (3)
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 |
|---|---|---|---|---|
PDESET1 | PYD-OBJ-ID, TAX-STATUS | Primary | BN66.1, PR140, PR141, PR189, PR195, PR197, PR262, PR582 +6 more | |
PDESET2 | QTD-OBJ-ID, TAX-STATUS, PYD-OBJ-ID | KeyChange, Subset | Where QTD-OBJ-ID != Zeroes | PR294, PR300 |
PDESET3 | COMPANY, EMPLOYEE, PYD-OBJ-ID, TAX-STATUS | Subset | Where TAX-STATUS != Spaces | HR00.1, HR01.1, HR11.1, PA115 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Employee | EMPLOYEE | Required | PDE-COMPANY → EMP-COMPANY, PDE-EMPLOYEE → EMP-EMPLOYEE |
Programs
Updated by (17)
- BN66.1 Estimated Pay Calculation
- HR00.1 Company
- HR01.1 Process Level
- HR11.1 Employee
- PA115 Employee Purge
- PR140 Earnings and Deductions Calculation
- PR189 Gross Up Calculation
- PR195 Accrual Program
- PR197 Payroll Close
- PR300 History Purge
- PR582 Mass Adjustment Load
- PR80.1 Manual Check
- PR80.4 Manual Payment
- PR82.1 Adjustment
- PR85.1 Bank Account Reconciliation
- PR89.1 Payment Modeling
- PRAT.1 Alltax connection test