PACLASS – Position Class

System
Personnel (PA)
Prefix
PAQ
Primary key
COMPANY, POS-CLASS
Fields
3
Updated by
1 program
Referenced by
6 programs

PACLASS is the Position Class table in Lawson Personnel (prefix PAQ). It is indexed by COMPANY, POS-CLASS (PAQSET1). It is related 1:1 to PRSYSTEM and 1:M to PACLASSPOS. It is updated by PA01.1 and referenced by HCPO.1, PA103, PA201, PA210, PA82.1 and PR323. The table has 3 fields, 1 index and 2 documented relations.

About PACLASS

The Position Class file contains information for each position class established within a company.

Fields (3)

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

Field / columnTypeDescription & valuesUpdated by
PAQ-COMPANY PK
COMPANY
Numeric 4Contains the company number.PA01.1
PAQ-POS-CLASS PK
POS_CLASS
Alpha 3Contains a code that represents a position class.PA01.1
PAQ-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)Contains the description of the position class.PA01.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
PAQSET1COMPANY, POS-CLASSPrimaryHCPO.1, PA01.1, PA01.2, PA01.4, PA103, PA201, PA210, PA82.1 +1 more

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredPAQ-COMPANYPRS-COMPANY, SpacesPRS-PROCESS-LEVEL

One to many (1) — child tables

RelationTableRulesConditionField map
Paq ClassposPACLASSPOSDelete CascadesPAQ-COMPANYPQP-COMPANY, PAQ-POS-CLASSPQP-POS-CLASS, PQP-POSITION

Programs

Updated by (1)

Referenced by (6)