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