PRQCENTGRP – No description in the Lawson data dictionary

System
Payroll (PR)
Prefix
PQC
Primary key
COMPANY, PROCESS-LEVEL, QC-ENT-NBR-GRP
Fields
4
Updated by
5 programs
Referenced by
86 programs

PRQCENTGRP is a Lawson Payroll table (prefix PQC); no description in the lawson data dictionary. It is indexed by COMPANY, PROCESS-LEVEL, QC-ENT-NBR-GRP (PQCSET1). It is related 1:1 to PRSYSTEM and 1:M to EMPLOYEE. It is updated by HR00.1, HR00.3, HR01.1, PR11.4 and PR127 and referenced by BN150, BN305, BN55.2, BN555, EXI2.1, EXI4.1, HPQC.1, HR11.1 and 78 more. The table has 4 fields, 1 index and 3 documented relations.

About PRQCENTGRP

No description in the Lawson data dictionary.

Fields (4)

Column = COBOL field name without the PQC- 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
#PQC-COMPANY PK
COMPANY
Numeric 4—HR00.1, HR00.3, HR01.1
#PQC-PROCESS-LEVEL PK
PROCESS_LEVEL
Alpha 5—HR00.1, HR00.3, HR01.1
#PQC-QC-ENT-NBR-GRP PK
QC_ENT_NBR_GRP
Alpha 4—HR00.1, HR00.3, HR01.1
#PQC-QC-ENT-NBR
QC_ENT_NBR
Alpha 16—HR00.1, HR00.3, HR01.1

Indexes (1)

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
PQCSET1
  1. COMPANY
  2. PROCESS-LEVEL
  3. QC-ENT-NBR-GRP
PrimaryBN150, BN305, BN55.2, BN555, HPQC.1, HR00.1, HR00.3, HR01.1 +22 more (list truncated in source)

Relations

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

One to one (2) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
PQC-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
Process LevelPRSYSTEMRequired
PQC-COMPANY→PRS-COMPANY
PQC-PROCESS-LEVEL→PRS-PROCESS-LEVEL

One to many (1) — child tables

RelationTableRulesConditionField map
EmployeesEMPLOYEE
PQC-COMPANY→EMP-COMPANY
PQC-PROCESS-LEVEL→EMP-PROCESS-LEVEL
—→EMP-EMPLOYEE

Programs

Updated by (5)

Referenced by (86)