PAPREREQ FILE
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.
REFERENCED BY
HR55.1 HS50.3 HS50.4 TR01.1 TR120 TR121
TR20.1 TR20.2 TR20.3 TR201 TR202
UPDATED BY
TR02.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RQS-COURSE Alpha 10 TR02.1
Course Code Contains the course code.
RQS-PREREQ-TYPE Alpha 2 TR02.1
Prerequisite Type Indicates the type of prerequisite.
CS = Course
EG = Employee Group
SK = Skill
SV = Service
AB = Abilities
KN = Knowledge
OA = Other Attributes
RQS-PREREQUISITE Alpha 10 TR02.1
Prerequisite Contains the course, skill, or employee
group.
RQS-COMPANY Numeric 4 TR02.1
Company Contains the company number if the
prerequisite is an employee group.
RQS-EFFECTIVE-DATE Numeric 8 (yyyymmdd) TR02.1
Start Date Contains the date the prerequisite is
effective.
RQS-DATE-TYPE Alpha 2 TR02.1
Date Type 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
RQS-DATE-MEASURE Numeric 3 TR02.1
Length 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.
RQS-UNIT-TYPE Alpha 1 TR02.1
Length/Unit of Time Indicates the unit of time in which the
service requirement is measured.
D = Days
M = Months
Y = Years
RQS-REQUIRED-FLAG Alpha 1 TR02.1
Required Indicates whether the prerequisite is
required.
Y = Yes
N = No
RQS-END-DATE Numeric 8 (yyyymmdd) TR02.1
Stop Date Contains the ending date for the
prerequisite.
RQS-RENEW-FLAG Alpha 1 TR02.1
Renew Flag Indicates if skill renewal information
should be checked when checking to see
if the employee has met the skill
requirement.
N = No
Y = Yes
RQS-PROFIC-LEVEL Alpha 10 TR02.1
Profic Level
PAPREREQ FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RQSSET1 COURSE HR55.1 HS50.3
PREREQ-TYPE HS50.4 TR01.1
PREREQUISITE TR02.1 TR02.2
COMPANY TR120 TR121
TR20.1 TR20.2
TR20.3 TR201
TR202
PAPREREQ FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
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 (RQS- = RQS-)
"SK" -> PCO-TYPE
RQS-PREREQUISITE -> PCO-CODE
PAPREREQ FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Compgroup PRSYSTEM
RQS-COMPANY -> PRS-COMPANY
PRS-PROCESS-LEVEL
Course PACOURSE
RQS-COURSE -> CRS-COURSE
CRS-EFFECTIVE-DATE
Group PGEMPLOYEE
RQS-COMPANY -> PGE-COMPANY
RQS-PREREQUISITE -> PGE-GROUP-NAME
PGE-EMPLOYEE
|
