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 | TR20.4 | TR201 | TR202 |
TR02.1 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
RQS-COURSE Element: Course Code | Alpha 10 Contains the course code. |
|
||
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 |
|
||
RQS-PREREQUISITE Element: Prerequisite | Alpha 10 Contains the course, skill, or employee group. |
|
||
RQS-COMPANY Element: Company | Numeric 4 Contains the company number if the prerequisite is an employee group. |
|
||
RQS-EFFECTIVE-DATE Element: Start Date | Numeric 8 (yyyymmdd) Contains the date the prerequisite is effective. |
|
||
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 |
|
||
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. |
|
||
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 |
|
||
RQS-REQUIRED-FLAG Element: Required | Alpha 1 Indicates whether the prerequisite is required. Y = Yes N = No |
|
||
RQS-END-DATE Element: Stop Date | Numeric 8 (yyyymmdd) Contains the ending date for the prerequisite. |
|
||
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 |
|
||
RQS-PROFIC-LEVEL Element: Profic Level | Alpha 10 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
RQSSET1 |
COURSE PREREQ-TYPE PREREQUISITE COMPANY |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Competency | PCODES |
Required
| ||||||||||||||||||||||||||||||
Compgroup | PRSYSTEM |
Required
| ||||||||||||||||||||||||||||||
Options | PAPREPROPT |
Not Required
| ||||||||||||||||||||||||||||||
Proficiency | PCODES |
Required
| ||||||||||||||||||||||||||||||
Skillcode | PCODES |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Course | PACOURSE |
| |||||||||||||||
Course Prereq | PACOURSE |
| |||||||||||||||
Group | PGEMPLOYEE |
|
All trademarks and registered trademarks are the property of their
respective owners.