Prerequisite Options
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.
REFERENCED BY
TR120 | TR121 | TR20.1 | TR20.2 | TR20.3 | TR20.4 |
TR202 |
TR01.1 | TR02.2 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
PQO-COURSE Element: Course Code | Alpha 10 Contains the course code. |
|
||
PQO-EFFECTIVE-DATE Element: Start Date | Numeric 8 (yyyymmdd) Contains the date the options become effective. |
|
||
PQO-REQ-PREREQ Element: Required Courses | Numeric 2 Contains the number of required courses the employee must complete before registering for a course. |
|
||
PQO-DES-PREREQ Element: Optional Course | Numeric 2 Contains the number of optional prerequisites an employee must complete before registering for a course. |
|
||
PQO-END-DATE Element: Stop Date | Numeric 8 (yyyymmdd) Contains the last date the options are effective. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
PQOSET1 |
COURSE |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Course | PACOURSE |
| ||||||||||||
Prerequisite | PAPREREQ |
|
All trademarks and registered trademarks are the property of their
respective owners.