PACLASSPOS – Position Class/Position Number

System
Personnel (PA)
Prefix
PQP
Primary key
COMPANY, POS-CLASS, POSITION
Fields
3
Updated by
8 programs
Referenced by
6 programs

PACLASSPOS is the Position Class/Position Number table in Lawson Personnel (prefix PQP). It is indexed by COMPANY, POS-CLASS, POSITION (PQPSET1); alternate indexes: PQPSET2. It is related 1:1 to PRSYSTEM, PAASSIGNED and PACLASS and 1:M to PABUDGET, PAENCUMBER, PATHFIND and PAPOSITION. It is updated by LT101, LT111, PA01.1, PA01.2, PA01.4, PA02.1, PA302 and PA502 and referenced by HCPO.1, PA103, PA201, PA210, PA82.1 and PR323. The table has 3 fields, 2 indexes and 7 documented relations.

About PACLASSPOS

The Position Class/Position Number file is used to associate position numbers with position classes.

Fields (3)

Column = COBOL field name without the PQP- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
PQP-COMPANY PK
COMPANY		Numeric 4Contains the company number which represents an established company.PA01.1, PA01.2, PA01.4
PQP-POS-CLASS PK
POS_CLASS		Alpha 3Contains the code that represents a position class.PA01.1, PA01.2, PA01.4
PQP-POSITION PK
POSITION		Alpha 12Contains the user-defined code that represents a position in the company.PA01.1, PA01.2, PA01.4

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PQPSET1COMPANY, POS-CLASS, POSITIONPrimaryPA01.1, PA01.2, PA01.3, PA103, PA201, PA210, PA82.1, PR323
PQPSET2COMPANY, POSITION, POS-CLASSHCPO.1, LT101, LT111, PA01.2, PA01.4, PA02.1, PA302, PA502

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredPQP-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
PassignedPAASSIGNEDNot RequiredPQP-COMPANY → PAA-COMPANY, PQP-POSITION → PAA-POSITION, Spaces → PAA-PROCESS-LEVEL, Spaces → PAA-DEPARTMENT, Spaces → PAA-JOB-CODE
Pqp ClassPACLASSRequiredPQP-COMPANY → PAQ-COMPANY, PQP-POS-CLASS → PAQ-POS-CLASS

One to many (4) — child tables

RelationTableRulesConditionField map
PabudgetPABUDGETPQP-COMPANY → PAB-COMPANY, PQP-POSITION → PAB-POSITION, → PAB-EFFECT-DATE, → PAB-PROCESS-LEVEL, → PAB-DEPARTMENT, → PAB-JOB-CODE
PaencumberPAENCUMBERPQP-COMPANY → PEN-COMPANY, PQP-POSITION → PEN-POSITION, Spaces → PEN-PROCESS-LEVEL, Spaces → PEN-DEPARTMENT, Spaces → PEN-JOB-CODE, → PEN-EMPLOYEE, → PEN-GLT-OBJ-ID, → PEN-ATN-OBJ-ID
Pqp EmployeePATHFINDPQP-COMPANY → PTF-COMPANY, 126 → PTF-FLD-NBR, PQP-POSITION → PTF-FLD-VALUE, → PTF-EMPLOYEE, → PTF-POS-LEVEL
Pqp PositionsPAPOSITIONRequiredPQP-COMPANY → POS-COMPANY, PQP-POSITION → POS-POSITION, → POS-EFFECT-DATE

Programs

Updated by (8)

Referenced by (6)