PAPREPROPT FILE
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 TR202
UPDATED BY
TR01.1 TR02.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PQO-COURSE Alpha 10 TR02.2
Course Code Contains the course code.
PQO-EFFECTIVE-DATE Numeric 8 (yyyymmdd) TR02.2
Start Date Contains the date the options become
effective.
PQO-REQ-PREREQ Numeric 2 TR02.2
Required Courses Contains the number of required courses
the employee must complete before
registering for a course.
PQO-DES-PREREQ Numeric 2 TR02.2
Optional Course Contains the number of optional
prerequisites an employee must complete
before registering for a course.
PQO-END-DATE Numeric 8 (yyyymmdd) TR02.2
Stop Date Contains the last date the options are
effective.
PAPREPROPT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PQOSET1 COURSE TR01.1 TR02.1
TR02.2 TR120
TR121 TR20.1
TR20.2 TR20.3
TR202
PAPREPROPT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Course PACOURSE
PQO-COURSE -> CRS-COURSE
CRS-EFFECTIVE-DATE
Prerequisite PAPREREQ
PQO-COURSE -> RQS-COURSE
RQS-PREREQ-TYPE
RQS-PREREQUISITE
RQS-COMPANY
|
