Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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