Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            PAINSCOURS FILE

                           Course Instructors

Contains the names of the instructors who can teach each course.

TR08.1 (Instructor Courses) is the primary program that updates this file.

REFERENCED BY

TR09.1    TR201     TR207

UPDATED BY

TR01.1    TR07.1    TR08.1    TR14.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

INC-INSTRUCT         Numeric 10                                  TR08.1  TR14.1
Instructor           Contains the instructor's
                     identification number.

INC-COURSE           Alpha 10                                    TR08.1  TR14.1
Course Code          Contains the course code.

INC-EFFECTIVE-DATE   Numeric 8  (yyyymmdd)                       TR08.1  TR14.1
Effective Date       Contains the first date the instructor
                     can teach the course.

INC-END-DATE         Numeric 8  (yyyymmdd)                       TR08.1  TR14.1
End Date             Contains the last date the instructor
                     can teach the course.

                         PAINSCOURS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

INCSET1   COURSE                                                 TR01.1  TR08.1
          INSTRUCT                                               TR09.1  TR14.1
                                                                 TR201

INCSET3   INSTRUCT                                               TR07.1  TR09.1
          COURSE                                                 TR14.1  TR207

                         PAINSCOURS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Instructor     PAINSTRUCT   Required

                            INC-INSTRUCT    -> INS-INSTRUCT

                         PAINSCOURS FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Course         PACOURSE

                            INC-COURSE      -> CRS-COURSE
                                               CRS-EFFECTIVE-DATE

Session Instr  PAINSTSES    Delete Restricted

                            INC-COURSE      -> ISE-COURSE
                                               ISE-SESSION
                                               ISE-START-DATE
                                               ISE-INSTR-TYPE
                                               ISE-INSTRUCT