PAPREPROPT – Prerequisite Options
- System
- Personnel (PA)
- Prefix
PQO- Primary key
COURSE- Fields
- 5
- Updated by
- 2 programs
- Referenced by
- 7 programs
PAPREPROPT is the Prerequisite Options table in Lawson Personnel (prefix PQO). It is indexed by COURSE (PQOSET1). It is related 1:M to PACOURSE and PAPREREQ. It is updated by TR01.1 and TR02.2 and referenced by TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4 and TR202. The table has 5 fields, 1 index and 2 documented relations.
About PAPREPROPT
Contains the number of required and recommended courses needed as a course prerequisite. If this record is not created, all required courses must be taken and none of the recommended courses is required. TR02.2 (Prerequisite Options) is the primary program that updates this file.
Fields (5)
Column = COBOL field name without the PQO- 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 |
|---|---|---|---|
#PQO-COURSE PKCOURSE | Alpha 10 | Contains the course code. | TR02.2 |
#PQO-EFFECTIVE-DATEEFFECTIVE_DATE | Numeric 8 (yyyymmdd) | Contains the date the options become effective. | TR02.2 |
#PQO-REQ-PREREQREQ_PREREQ | Numeric 2 | Contains the number of required courses the employee must complete before registering for a course. | TR02.2 |
#PQO-DES-PREREQDES_PREREQ | Numeric 2 | Contains the number of optional prerequisites an employee must complete before registering for a course. | TR02.2 |
#PQO-END-DATEEND_DATE | Numeric 8 (yyyymmdd) | Contains the last date the options are effective. | TR02.2 |
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 |
|---|---|---|---|---|
PQOSET1 |
| Primary | TR01.1, TR02.1, TR02.2, TR120, TR121, TR20.1, TR20.2, TR20.3 +2 more |