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

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 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
PQPSET1
  1. COMPANY
  2. POS-CLASS
  3. POSITION
PrimaryPA01.1, PA01.2, PA01.3, PA103, PA201, PA210, PA82.1, PR323
PQPSET2
  1. COMPANY
  2. POSITION
  3. POS-CLASS
HCPO.1, LT101, LT111, PA01.2, PA01.4, PA02.1, PA302, PA502

Relations

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

One to one (3) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
PQP-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
PassignedPAASSIGNEDNot Required
PQP-COMPANY→PAA-COMPANY
PQP-POSITION→PAA-POSITION
Spaces→PAA-PROCESS-LEVEL
Spaces→PAA-DEPARTMENT
Spaces→PAA-JOB-CODE
Pqp ClassPACLASSRequired
PQP-COMPANY→PAQ-COMPANY
PQP-POS-CLASS→PAQ-POS-CLASS

One to many (4) — child tables

RelationTableRulesConditionField map
PabudgetPABUDGET
PQP-COMPANY→PAB-COMPANY
PQP-POSITION→PAB-POSITION
—→PAB-EFFECT-DATE
—→PAB-PROCESS-LEVEL
—→PAB-DEPARTMENT
—→PAB-JOB-CODE
PaencumberPAENCUMBER
PQP-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 EmployeePATHFIND
PQP-COMPANY→PTF-COMPANY
126→PTF-FLD-NBR
PQP-POSITION→PTF-FLD-VALUE
—→PTF-EMPLOYEE
—→PTF-POS-LEVEL
Pqp PositionsPAPOSITIONRequired
PQP-COMPANY→POS-COMPANY
PQP-POSITION→POS-POSITION
—→POS-EFFECT-DATE

Programs

Updated by (8)

Referenced by (6)