PAPREREQ

Course Prerequisites

Contains prerequisite information for each course. Four kinds of prerequisites can be defined: courses, skills, service requirements, and group membership. The Registration Information file references this file when employees are registered into sessions on TR20.1 (Session Registration). TR02.1 (Course Prerequisites) is the primary program that updates this file.
UPDATED BY
TR02.1 TR02.2 HR55.1 HS50.3 HS50.4 TR01.1
TR120 TR121 TR20.1 TR20.2 TR20.3 TR20.4
TR201 TR202

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RQS-COURSE
Element: Course Code		Alpha 10
Contains the course code.
TR02.1
RQS-PREREQ-TYPE
Element: Prerequisite Type		Alpha 2
Indicates the type of prerequisite. CS = Course EG = Employee Group SK = Skill SV = Service
AB = Abilities
KN = Knowledge
OA = Other Attributes
TR02.1
RQS-PREREQUISITE
Element: Prerequisite		Alpha 10
Contains the course, skill, or employee group.
TR02.1
RQS-COMPANY
Element: Company		Numeric 4
Contains the company number if the prerequisite is an employee group.
TR02.1
RQS-EFFECTIVE-DATE
Element: Start Date		Numeric 8 (yyyymmdd)
Contains the date the prerequisite is effective.
TR02.1
RQS-DATE-TYPE
Element: Date Type		Alpha 2
Contains the type of date on which service calculations should be measured. AJ = Adjusted Hire Date AN = Anniversary Date HI = Hire Date SN = Seniority Date
TR02.1
RQS-DATE-MEASURE
Element: Length		Numeric 3
Contains the amount of time the employee must wait before taking the course, if the prerequisite is a service requirement. The time is measured from the value entered in the Date Type field.
TR02.1
RQS-UNIT-TYPE
Element: Length/Unit of Time		Alpha 1
Indicates the unit of time in which the service requirement is measured. D = Days M = Months Y = Years
TR02.1
RQS-REQUIRED-FLAG
Element: Required		Alpha 1
Indicates whether the prerequisite is required. Y = Yes N = No
TR02.1
RQS-END-DATE
Element: Stop Date		Numeric 8 (yyyymmdd)
Contains the ending date for the prerequisite.
TR02.1
RQS-RENEW-FLAG
Element: Renew Flag		Alpha 1
Indicates if skill renewal information should be checked when checking to see if the employee has met the skill requirement.
N = No
Y = Yes
TR02.1
RQS-PROFIC-LEVEL
Element: Profic Level		Alpha 10
TR02.1


PAPREREQ FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RQSSET1 COURSE
PREREQ-TYPE
PREREQUISITE
COMPANY
HR55.1 HS50.3
HS50.4 TR01.1
TR02.1 TR02.2
TR120 TR121
TR20.1 TR20.2
TR20.3 TR20.4
TR201 TR202


PAPREREQ FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Competency PCODES Required
When (RQS-PREREQ-TYPE ="AB" )
Or(RQS-PREREQ-TYPE ="KN" )
Or(RQS-PREREQ-TYPE ="OA" )
Or(RQS-PREREQ-TYPE ="SK" )
RQS-PREREQ-TYPE->PCO-TYPE
RQS-PREREQUISITE->PCO-CODE
Compgroup PRSYSTEM Required
When RQS-PREREQ-TYPE ="EG"
RQS-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Options PAPREPROPT Not Required
RQS-COURSE->PQO-COURSE
Proficiency PCODES Required
When (RQS-PROFIC-LEVEL !=Spaces )
"PF"->PCO-TYPE
RQS-PROFIC-LEVEL->PCO-CODE
Skillcode PCODES Required
When (RQS-PREREQ-TYPE ="SK" )
And(PCO- =RQS-)
"SK"->PCO-TYPE
RQS-PREREQUISITE->PCO-CODE


PAPREREQ FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Course PACOURSE
RQS-COURSE->CRS-COURSE
  CRS-EFFECTIVE-DATE
Course Prereq PACOURSE
Valid When RQS-PREREQ-TYPE ="CS"
RQS-COURSE->CRS-COURSE
  CRS-EFFECTIVE-DATE
Group PGEMPLOYEE
Valid When RQS-PREREQ-TYPE ="EG"
RQS-COMPANY->PGE-COMPANY
RQS-PREREQUISITE->PGE-GROUP-NAME
  PGE-EMPLOYEE

File created: Wed Jun 08 20:50:26 2016

Home
Contact Us



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