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 / column | Type | Description & values | Updated by |
|---|---|---|---|
PAQ-COMPANY PKCOMPANY | Numeric 4 | Contains the company number. | PA01.1 |
PAQ-POS-CLASS PKPOS_CLASS | Alpha 3 | Contains a code that represents a position class. | PA01.1 |
PAQ-DESCRIPTIONDESCRIPTION | 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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
PAQSET1 | COMPANY, POS-CLASS | Primary | HCPO.1, PA01.1, PA01.2, PA01.4, PA103, PA201, PA210, PA82.1 +1 more |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Company | PRSYSTEM | Required | PAQ-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL |
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Paq Classpos | PACLASSPOS | Delete Cascades | PAQ-COMPANY → PQP-COMPANY, PAQ-POS-CLASS → PQP-POS-CLASS, → PQP-POSITION |
Programs
Updated by (1)
- PA01.1 Position Class