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

Field / columnTypeDescription & valuesUpdated by
#PTA-COMPANY PK
COMPANY
Numeric 4——
#PTA-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.—
#PTA-ORIG-CHECK-ID PK
ORIG_CHECK_ID
Numeric 12——
#PTA-ADJ-CHECK-ID
ADJ_CHECK_ID
Numeric 12—BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
#PTA-TIME-SEQ PK
TIME_SEQ
Numeric 12——

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
PTASET1
  1. COMPANY
  2. EMPLOYEE
  3. ORIG-CHECK-ID
  4. TIME-SEQ
Primary—
PTASET2
  1. COMPANY
  2. EMPLOYEE
  3. TIME-SEQ
BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1

Relations

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

One to one (5) — lookups and parents

RelationTableRulesConditionField map
AdjustmentPAYMASTRRequired
PTA-COMPANY→PYM-COMPANY
PTA-EMPLOYEE→PYM-EMPLOYEE
PTA-ADJ-CHECK-ID→PYM-CHECK-ID
Cur TimerecordTIMERECORDNot Required
PTA-COMPANY→TRD-COMPANY
PTA-EMPLOYEE→TRD-EMPLOYEE
PTA-TIME-SEQ→TRD-TIME-SEQ
EmployeeEMPLOYEERequired
PTA-COMPANY→EMP-COMPANY
PTA-EMPLOYEE→EMP-EMPLOYEE
OriginalPAYMASTRRequired
PTA-COMPANY→PYM-COMPANY
PTA-EMPLOYEE→PYM-EMPLOYEE
PTA-ORIG-CHECK-ID→PYM-CHECK-ID
Time RecordPRTIMENot 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

RelationTableRulesConditionField map
AdjustmentsPRTRDADJ
PTA-COMPANY→PTA-COMPANY
PTA-EMPLOYEE→PTA-EMPLOYEE
PTA-ADJ-CHECK-ID→PTA-ORIG-CHECK-ID
—→PTA-TIME-SEQ

Programs

Updated by (8)