Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PAPREREQ


                             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
Element: Course Code   Contains the course code.

RQS-PREREQ-TYPE        Alpha 2                                   TR02.1
Element: Prerequisite TIndicates 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
Element: Prerequisite  Contains the course, skill, or employee
                       group.

RQS-COMPANY            Numeric 4                                 TR02.1
Element: Company       Contains the company number if the
                       prerequisite is an employee group.

RQS-EFFECTIVE-DATE     Numeric 8  (yyyymmdd)                     TR02.1
Element: Start Date    Contains the date the prerequisite is
                       effective.

RQS-DATE-TYPE          Alpha 2                                   TR02.1
Element: 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
Element: 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
Element: Length/Unit ofIndicates the unit of time in which the
                       service requirement is measured.
                       D = Days
                       M = Months
                       Y = Years

RQS-REQUIRED-FLAG      Alpha 1                                   TR02.1
Element: Required      Indicates whether the prerequisite is
                       required.
                       Y = Yes
                       N = No

RQS-END-DATE           Numeric 8  (yyyymmdd)                     TR02.1
Element: Stop Date     Contains the ending date for the
                       prerequisite.

RQS-RENEW-FLAG         Alpha 1                                   TR02.1
Element: 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
Element: 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  (PCO-            = 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