PAPREREQ – Course Prerequisites

System
Personnel (PA)
Prefix
RQS
Primary key
COURSE, PREREQ-TYPE, PREREQUISITE, COMPANY
Fields
12
Updated by
1 program
Referenced by
12 programs

PAPREREQ is the Course Prerequisites table in Lawson Personnel (prefix RQS). It is indexed by COURSE, PREREQ-TYPE, PREREQUISITE, COMPANY (RQSSET1). It is related 1:1 to PCODES, PRSYSTEM and PAPREPROPT and 1:M to PACOURSE and PGEMPLOYEE. It is updated by TR02.1 and referenced by HR55.1, HS50.3, HS50.4, TR01.1, TR120, TR121, TR20.1, TR20.2 and 4 more. The table has 12 fields, 1 index and 8 documented relations.

About PAPREREQ

Contains prerequisite information for each course. Four kinds of prerequisites can be defined: courses, skills, service requirements, and group membership. The Registration Information file references this file when employees are registered into sessions on TR20.1 (Session Registration). TR02.1 (Course Prerequisites) is the primary program that updates this file.

Fields (12)

Column = COBOL field name without the RQS- 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
#RQS-COURSE PK
COURSE		Alpha 10Contains the course code.TR02.1
#RQS-PREREQ-TYPE PK
PREREQ_TYPE		Alpha 2Indicates the type of prerequisite.
  • CS Course
  • EG Employee Group
  • SK Skill
  • SV Service
  • AB Abilities
  • KN Knowledge
  • OA Other Attributes
TR02.1
#RQS-PREREQUISITE PK
PREREQUISITE		Alpha 10Contains the course, skill, or employee group.TR02.1
#RQS-COMPANY PK
COMPANY		Numeric 4Contains the company number if the prerequisite is an employee group.TR02.1
#RQS-EFFECTIVE-DATE
EFFECTIVE_DATE		Numeric 8 (yyyymmdd)Contains the date the prerequisite is effective.TR02.1
#RQS-DATE-TYPE
DATE_TYPE		Alpha 2Contains the type of date on which service calculations should be measured.
  • AJ Adjusted Hire Date
  • AN Anniversary Date
  • HI Hire Date
  • SN Seniority Date
TR02.1
#RQS-DATE-MEASURE
DATE_MEASURE		Numeric 3Contains the amount of time the employee must wait before taking the course, if the prerequisite is a service requirement. The time is measured from the value entered in the Date Type field.TR02.1
#RQS-UNIT-TYPE
UNIT_TYPE		Alpha 1Indicates the unit of time in which the service requirement is measured.
  • D Days
  • M Months
  • Y Years
TR02.1
#RQS-REQUIRED-FLAG
REQUIRED_FLAG		Alpha 1Indicates whether the prerequisite is required.
  • Y Yes
  • N No
TR02.1
#RQS-END-DATE
END_DATE		Numeric 8 (yyyymmdd)Contains the ending date for the prerequisite.TR02.1
#RQS-RENEW-FLAG
RENEW_FLAG		Alpha 1Indicates if skill renewal information should be checked when checking to see if the employee has met the skill requirement.
  • N No
  • Y Yes
TR02.1
#RQS-PROFIC-LEVEL
PROFIC_LEVEL		Alpha 10—TR02.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
RQSSET1
  1. COURSE
  2. PREREQ-TYPE
  3. PREREQUISITE
  4. COMPANY
PrimaryHR55.1, HS50.3, HS50.4, TR01.1, TR02.1, TR02.2, TR120, TR121 +6 more

Relations

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

One to one (5) — lookups and parents

RelationTableRulesConditionField map
CompetencyPCODESRequiredWhen (RQS-PREREQ-TYPE = "AB") Or (RQS-PREREQ-TYPE = "KN") Or (RQS-PREREQ-TYPE = "OA") Or (RQS-PREREQ-TYPE = "SK")
RQS-PREREQ-TYPE→PCO-TYPE
RQS-PREREQUISITE→PCO-CODE
CompgroupPRSYSTEMRequiredWhen RQS-PREREQ-TYPE = "EG"
RQS-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
OptionsPAPREPROPTNot Required
RQS-COURSE→PQO-COURSE
ProficiencyPCODESRequiredWhen (RQS-PROFIC-LEVEL != Spaces)
"PF"→PCO-TYPE
RQS-PROFIC-LEVEL→PCO-CODE
SkillcodePCODESRequiredWhen (RQS-PREREQ-TYPE = "SK") And (PCO- = RQS-)
"SK"→PCO-TYPE
RQS-PREREQUISITE→PCO-CODE

One to many (3) — child tables

RelationTableRulesConditionField map
CoursePACOURSE
RQS-COURSE→CRS-COURSE
—→CRS-EFFECTIVE-DATE
Course PrereqPACOURSEValid When RQS-PREREQ-TYPE = "CS"
RQS-COURSE→CRS-COURSE
—→CRS-EFFECTIVE-DATE
GroupPGEMPLOYEEValid When RQS-PREREQ-TYPE = "EG"
RQS-COMPANY→PGE-COMPANY
RQS-PREREQUISITE→PGE-GROUP-NAME
—→PGE-EMPLOYEE

Programs

Updated by (1)

Referenced by (12)