Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PAPREPROPT


                            PAPREPROPT FILE

                          Prerequisite Options

Contains the number of required and recommended courses needed as a course
prerequisite. If this record is not created, all required courses must be
taken and none of the recommended courses is required.

TR02.2 (Prerequisite Options) is the primary program that updates this file.

REFERENCED BY

TR120     TR121     TR20.1    TR20.2    TR20.3    TR202

UPDATED BY

TR01.1    TR02.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PQO-COURSE             Alpha 10                                  TR02.2
Element: Course Code   Contains the course code.

PQO-EFFECTIVE-DATE     Numeric 8  (yyyymmdd)                     TR02.2
Element: Start Date    Contains the date the options become
                       effective.

PQO-REQ-PREREQ         Numeric 2                                 TR02.2
Element: Required CoursContains the number of required courses
                       the employee must complete before
                       registering for a course.

PQO-DES-PREREQ         Numeric 2                                 TR02.2
Element: Optional CoursContains the number of optional
                       prerequisites an employee must complete
                       before registering for a course.

PQO-END-DATE           Numeric 8  (yyyymmdd)                     TR02.2
Element: Stop Date     Contains the last date the options are
                       effective.

                         PAPREPROPT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PQOSET1   COURSE                                                 TR01.1  TR02.1
                                                                 TR02.2  TR120
                                                                 TR121   TR20.1
                                                                 TR20.2  TR20.3
                                                                 TR202

                         PAPREPROPT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Course         PACOURSE

                            PQO-COURSE    -> CRS-COURSE
                                             CRS-EFFECTIVE-DATE

Prerequisite   PAPREREQ

                            PQO-COURSE    -> RQS-COURSE
                                             RQS-PREREQ-TYPE
                                             RQS-PREREQUISITE
                                             RQS-COMPANY