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.

REFERENCED BY
TR01.1


UPDATED BY
HR55.1 HS50.3 HS50.4 TR02.1 TR02.2 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: Thu Jun 09 11:22:21 2016

Home
Contact Us



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