PRTRDADJ – No description in the Lawson data dictionary
- System
- Payroll (PR)
- Prefix
PTA- Primary key
COMPANY,EMPLOYEE,ORIG-CHECK-ID,TIME-SEQ- Fields
- 5
- Updated by
- 8 programs
- Referenced by
- 0 programs
PRTRDADJ is a Lawson Payroll table (prefix PTA); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, ORIG-CHECK-ID, TIME-SEQ (PTASET1); alternate indexes: PTASET2. It is related 1:1 to PAYMASTR, TIMERECORD, EMPLOYEE and PRTIME and 1:M to PRTRDADJ. It is updated by BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1 and PRAT.1. The table has 5 fields, 2 indexes and 6 documented relations.
About PRTRDADJ
No description in the Lawson data dictionary.
Fields (5)
Column = COBOL field name without the PTA- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
PTA-COMPANY PKCOMPANY | Numeric 4 | — | — |
PTA-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. | — |
PTA-ORIG-CHECK-ID PKORIG_CHECK_ID | Numeric 12 | — | — |
PTA-ADJ-CHECK-IDADJ_CHECK_ID | Numeric 12 | — | BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1 |
PTA-TIME-SEQ PKTIME_SEQ | Numeric 12 | — | — |
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 |
|---|---|---|---|---|
PTASET1 | COMPANY, EMPLOYEE, ORIG-CHECK-ID, TIME-SEQ | Primary | — | |
PTASET2 | COMPANY, EMPLOYEE, TIME-SEQ | BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1 |
Relations
One to one (5) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Adjustment | PAYMASTR | Required | PTA-COMPANY → PYM-COMPANY, PTA-EMPLOYEE → PYM-EMPLOYEE, PTA-ADJ-CHECK-ID → PYM-CHECK-ID | |
| Cur Timerecord | TIMERECORD | Not Required | PTA-COMPANY → TRD-COMPANY, PTA-EMPLOYEE → TRD-EMPLOYEE, PTA-TIME-SEQ → TRD-TIME-SEQ | |
| Employee | EMPLOYEE | Required | PTA-COMPANY → EMP-COMPANY, PTA-EMPLOYEE → EMP-EMPLOYEE | |
| Original | PAYMASTR | Required | PTA-COMPANY → PYM-COMPANY, PTA-EMPLOYEE → PYM-EMPLOYEE, PTA-ORIG-CHECK-ID → PYM-CHECK-ID | |
| Time Record | PRTIME | Not Required | PTA-COMPANY → PRT-COMPANY, PTA-EMPLOYEE → PRT-EMPLOYEE, PYM-PER-END-DATE → PRT-PER-END-DATE, PTA-ADJ-CHECK-ID → PRT-CHECK-ID, PTA-TIME-SEQ → PRT-TIME-SEQ |
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Adjustments | PRTRDADJ | PTA-COMPANY → PTA-COMPANY, PTA-EMPLOYEE → PTA-EMPLOYEE, PTA-ADJ-CHECK-ID → PTA-ORIG-CHECK-ID, PTA-TIME-SEQ |