REQCODE – Required Deduction Code Header

System
Payroll (PR)
Prefix
RQC
Primary key
COMPANY, REQ-CODE
Fields
5
Updated by
3 programs
Referenced by
15 programs

REQCODE is the Required Deduction Code Header table in Lawson Payroll (prefix RQC). It is indexed by COMPANY, REQ-CODE (RQCSET1). It is related 1:1 to PRSYSTEM and 1:M to DEDCODE and PRQUALIFY. It is updated by HR00.1, HR01.1 and PR03.1 and referenced by HR11.1, HR511, HRQC.1, LT101, LT111, PA100, PA52.1, PA52.4 and 7 more. The table has 5 fields, 1 index and 3 documented relations.

About REQCODE

The Required Deduction Code Header file contains the header information for deduction required codes. The system links the required codes to deductions by storing the required code in the Deduction file. When you add employees, the system uses the deduction required codes to automatically create Employee Deduction file records. PR03.1 (Deduction Required Code) is the primary program that updates this file. If the required code is not to be created for all employees, the system stores the detail selection criteria in the Required Code Select Criteria file.

Fields (5)

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

Field / columnTypeDescription & valuesUpdated by
RQC-COMPANY PK
COMPANY		Numeric 4—PR03.1
RQC-REQ-CODE PK
REQ_CODE		Alpha 3Contains the user-defined required code defined for the deduction.PR03.1
RQC-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)Contains the required code description.PR03.1
RQC-ALL-EMPLOYEES
ALL_EMPLOYEES		Alpha 1Contains the value that determines if the required code is created for all employees or based on selection criteria stored in the Required Code Select Criteria file.
  • N No - Define selection criteria
  • Y Select Criteria
PR03.1
RQC-NEXT-NBR
NEXT_NBR		Numeric 4Contains the sequence number. This field is used to set the value of the sequence number when Required Code Select Criteria file records are created.PR03.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
RQCSET1COMPANY, REQ-CODEPrimaryHR00.1, HR01.1, HR11.1, HR511, HRQC.1, LT101, LT111, PA100 +10 more

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredRQC-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL

One to many (2) — child tables

RelationTableRulesConditionField map
Deduction CodeDEDCODEDelete RestrictedRQC-COMPANY → DDC-COMPANY, RQC-REQ-CODE → DDC-REQ-CODE, → DDC-DED-CODE
PrqualifyPRQUALIFYDelete CascadesRQC-COMPANY → PRQ-COMPANY, RQC-REQ-CODE → PRQ-RECORD-KEY, → PRQ-SEQ-NBR

Programs

Updated by (3)

Referenced by (15)