PRQUALIFY – Required Code Select Criteria

System
Payroll (PR)
Prefix
PRQ
Primary key
COMPANY, RECORD-KEY, SEQ-NBR
Fields
27
Updated by
3 programs
Referenced by
13 programs

PRQUALIFY is the Required Code Select Criteria table in Lawson Payroll (prefix PRQ). It is indexed by COMPANY, RECORD-KEY, SEQ-NBR (PRQSET1). It is related 1:1 to PRSYSTEM, DEPTCODE, EMSTATUS, JOBCODE, REQCODE, PCODES and PRSTATE. It is updated by HR00.1, HR01.1 and PR03.1 and referenced by HR11.1, HR511, LT101, LT111, PA100, PA52.1, PA52.4, PA52.5 and 5 more. The table has 27 fields, 1 index and 8 documented relations.

About PRQUALIFY

Contains the detail selection criteria for required deductions that have not been defined as applying to "all" employees. Use PR03.1 (Deduction Required Code) to define parameters that determine if the system automatically creates an employee deduction (Employee Deduction file record) when you add an employee. The system compares the detail selection criteria you define, with the employee fields to determine if it should create the employee deduction. The Required Deduction Header file stores the required code header information.

Fields (27)

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

Field / columnTypeDescription & valuesUpdated by
PRQ-COMPANY PK
COMPANY		Numeric 4—PR03.1
PRQ-RECORD-KEY PK
RECORD_KEY		Alpha 3Contains the deduction required code.PR03.1
PRQ-SEQ-NBR PK
SEQ_NBR		Numeric 4Contains the deduction sequence number. The value of this field is automatically sequenced based on the Next Nbr field in the Required Deduction Code Header file.PR03.1
PRQ-PROCESS-LEVEL
PROCESS_LEVEL		Alpha 5Contains the employee's process level. The value in this field must be valid in the HR Company and Process Levels file.PR03.1
PRQ-DEPARTMENT
DEPARTMENT		Alpha 5Contains the employee's department. The value in this field must be valid in the Department Parameters file.PR03.1
PRQ-DATE-HIRED
DATE_HIRED		Numeric 8 (yyyymmdd)Contains the employee's hire datePR03.1
PRQ-ADJ-HIRE-DATE
ADJ_HIRE_DATE		Numeric 8 (yyyymmdd)Contains the employee's adjusted hire datePR03.1
PRQ-SALARY-CLASS
SALARY_CLASS		Alpha 1Contains the employee's salary class.
  • H Hourly
  • S Salaried
PR03.1
PRQ-EMP-STATUS
EMP_STATUS		Alpha 2Contains the employee's status. The value in this field must be valid in the Employee/Applicant Status file.PR03.1
PRQ-PAY-FREQUENCY
PAY_FREQUENCY		Numeric 1Contains the employee's pay frequency.
  • 1 Weekly
  • 2 Biweekly
  • 3 Semimonthly
  • 4 Monthly
  • 5 UK Four-Weekly
PR03.1
PRQ-EXEMPT-EMP
EXEMPT_EMP		Alpha 1Contains the employee's overtime exempt indicator.
  • N Non-exempt
  • Y Exempt
PR03.1
PRQ-JOB-CODE
JOB_CODE		Alpha 9Contains the employee's job code. The value in this field must be valid in the Job Code Parameters file.PR03.1
PRQ-UNION-CODE
UNION_CODE		Alpha 10Contains the union code with which the employee is associated. The value in this field must be valid in the Human Resource Code file under type UN (Union).PR03.1
PRQ-TAX-PROVINCE
TAX_PROVINCE		Alpha 2—PR03.1
PRQ-WC-STATE
WC_STATE		Alpha 2Contains the employee's workers compensation state.PR03.1
PRQ-LOCAT-CODE
LOCAT_CODE		Alpha 10Contains the location code.PR03.1
PRQ-WORK-COUNTRY
WORK_COUNTRY		Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).PR03.1
PRQ-WC-PROVINCE
WC_PROVINCE		Alpha 2—PR03.1
PRQ-WORK-STATE
WORK_STATE		Alpha 2Contains the employee's work state.PR03.1
PRQ-TAX-STATE
TAX_STATE		Alpha 2Contains the employee's state taxing authority.PR03.1
PRQ-TAX-COUNTY
TAX_COUNTY		Alpha 10Contains the employee's county taxing authority.PR03.1
PRQ-WORK-COUNTY
WORK_COUNTY		Alpha 10Contains the employee's work state.PR03.1
PRQ-TAX-CITY
TAX_CITY		Alpha 10Contains the employee's city taxing authority.PR03.1
PRQ-WORK-CITY
WORK_CITY		Alpha 10Contains the employee's work city.PR03.1
PRQ-TAX-SCHOOL
TAX_SCHOOL		Alpha 10Contains the employee's school tax authority code.PR03.1
PRQ-WORK-SCHOOL
WORK_SCHOOL		Alpha 10Contains the employee's work school.PR03.1
PRQ-PSRETIRE-PLAN
PSRETIRE_PLAN		Numeric 2—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
PRQSET1COMPANY, RECORD-KEY, SEQ-NBRPrimaryHR00.1, HR01.1, HR11.1, HR511, LT101, LT111, PA100, PA52.1 +8 more

Relations

One to one (8) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredPRQ-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
DepartmentDEPTCODERequiredWhen PRQ-DEPARTMENT != SpacesPRQ-COMPANY → DPT-COMPANY, PRQ-PROCESS-LEVEL → DPT-PROCESS-LEVEL, PRQ-DEPARTMENT → DPT-DEPARTMENT
Emp StatusEMSTATUSRequiredWhen PRQ-EMP-STATUS != SpacesPRQ-COMPANY → EMS-COMPANY, PRQ-EMP-STATUS → EMS-EMP-STATUS
Job CodeJOBCODERequiredWhen PRQ-JOB-CODE != SpacesPRQ-COMPANY → JBC-COMPANY, PRQ-JOB-CODE → JBC-JOB-CODE
Process LevelPRSYSTEMRequiredWhen PRQ-PROCESS-LEVEL != SpacesPRQ-COMPANY → PRS-COMPANY, PRQ-PROCESS-LEVEL → PRS-PROCESS-LEVEL
Required CodeREQCODERequiredPRQ-COMPANY → RQC-COMPANY, PRQ-RECORD-KEY → RQC-REQ-CODE
UnionPCODESRequiredWhen PRQ-UNION-CODE != Spaces"UN" → PCO-TYPE, PRQ-UNION-CODE → PCO-CODE
Wc StatePRSTATERequiredWhen PRQ-WC-STATE != SpacesPRQ-WC-STATE → PSA-STATE

Programs

Updated by (3)

Referenced by (13)