PAPREPROPT

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


UPDATED BY
TR01.1 TR02.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PQO-COURSE
Element: Course Code
Alpha 10
Contains the course code.
TR02.2
PQO-EFFECTIVE-DATE
Element: Start Date
Numeric 8 (yyyymmdd)
Contains the date the options become effective.
TR02.2
PQO-REQ-PREREQ
Element: Required Courses
Numeric 2
Contains the number of required courses the employee must complete before registering for a course.
TR02.2
PQO-DES-PREREQ
Element: Optional Course
Numeric 2
Contains the number of optional prerequisites an employee must complete before registering for a course.
TR02.2
PQO-END-DATE
Element: Stop Date
Numeric 8 (yyyymmdd)
Contains the last date the options are effective.
TR02.2


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
TR20.4 TR202


PAPREPROPT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 02:25:06 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.