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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#RQC-COMPANY PKCOMPANY | Numeric 4 | — | PR03.1 |
#RQC-REQ-CODE PKREQ_CODE | Alpha 3 | Contains the user-defined required code defined for the deduction. | PR03.1 |
#RQC-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | Contains the required code description. | PR03.1 |
#RQC-ALL-EMPLOYEESALL_EMPLOYEES | Alpha 1 | Contains 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.
| PR03.1 |
#RQC-NEXT-NBRNEXT_NBR | Numeric 4 | Contains 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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
RQCSET1 |
| Primary | HR00.1, HR01.1, HR11.1, HR511, HRQC.1, LT101, LT111, PA100 +10 more |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Company | PRSYSTEM | Required |
|
One to many (2) — child tables
Programs
Updated by (3)
Referenced by (15)
- HR11.1 Employee
- HR511 Employee Conversion
- HRQC.1 Required Code Selection Invoke
- LT101 HRM Receiver Update
- LT111 HRM Receiver Update
- PA100 Action Update
- PA52.1 Individual Action
- PA52.4 Hire an Applicant
- PA52.5 Position and Job Action
- PR05.1 Deduction
- PR13.1 Employee United States Taxes
- PR13.5 Employee Canada Taxes
- PR14.1 Employee Deduction
- PR15.2 Employee Deduction Speed Entry
- PR205 Deduction Listing