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.

Field / column	Type	Description & values	Updated by
`RQS-COURSE` PK COURSE	Alpha 10	Contains the course code.	TR02.1
`RQS-PREREQ-TYPE` PK PREREQ_TYPE	Alpha 2	Indicates 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 10	Contains the course, skill, or employee group.	TR02.1
`RQS-COMPANY` PK COMPANY	Numeric 4	Contains 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 2	Contains 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 3	Contains 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 1	Indicates 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 1	Indicates 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 1	Indicates 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`RQSSET1`	`COURSE`, `PREREQ-TYPE`, `PREREQUISITE`, `COMPANY`	Primary		HR55.1, HS50.3, HS50.4, TR01.1, TR02.1, TR02.2, TR120, TR121 +6 more

Relations

One to one (5) — lookups and parents

Relation	Table	Rules	Condition	Field map
Competency	PCODES	Required	When (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`
Compgroup	PRSYSTEM	Required	When RQS-PREREQ-TYPE = "EG"	`RQS-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Options	PAPREPROPT	Not Required		`RQS-COURSE` → `PQO-COURSE`
Proficiency	PCODES	Required	When (RQS-PROFIC-LEVEL != Spaces)	`"PF"` → `PCO-TYPE`, `RQS-PROFIC-LEVEL` → `PCO-CODE`
Skillcode	PCODES	Required	When (RQS-PREREQ-TYPE = "SK") And (PCO- = RQS-)	`"SK"` → `PCO-TYPE`, `RQS-PREREQUISITE` → `PCO-CODE`

One to many (3) — child tables

Relation	Table	Condition	Field map
Course	PACOURSE		`RQS-COURSE` → `CRS-COURSE`, → `CRS-EFFECTIVE-DATE`
Course Prereq	PACOURSE	Valid When RQS-PREREQ-TYPE = "CS"	`RQS-COURSE` → `CRS-COURSE`, → `CRS-EFFECTIVE-DATE`
Group	PGEMPLOYEE	Valid When RQS-PREREQ-TYPE = "EG"	`RQS-COMPANY` → `PGE-COMPANY`, `RQS-PREREQUISITE` → `PGE-GROUP-NAME`, → `PGE-EMPLOYEE`

Programs

Updated by (1)

TR02.1 Course Prerequisite

Referenced by (12)

HR55.1 Employee Group Definition
HS50.3 Training Courses
HS50.4 Training Courses
TR01.1 Course
TR120 Group Session Registration
TR121 Job Code Session Registration
TR20.1 Session Registration
TR20.2 Mass Registration
TR20.3 Session Registration Override
TR20.4 Employee Session Registration
TR201 Course Profile
TR202 Course Catalog Extract