Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PAINSTSES


                             PAINSTSES FILE

                          Session Instructors

Contains the names of the instructors who can teach each session. The
instructor must be listed in the course record of PAINSCOURS.

TR09.1 (Instructor Sessions) is the primary program that updates this file.

REFERENCED BY

TR08.1    TR14.1    TR200     TR202     TR204     TR21.1
TR22.1    TR220     TR26.1    TR500     TR07.1    TR207

UPDATED BY

TR04.1    TR09.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ISE-COURSE             Alpha 10                                  TR09.1
Element: Course Code   Contains the course code.

ISE-SESSION            Numeric 5                                 TR09.1
Element: Session       Contains the session number.

ISE-START-DATE         Numeric 8  (yyyymmdd)                     TR09.1
Element: Session Start Contains the session start date.

ISE-INSTR-TYPE         Alpha 1                                   TR09.1
Element: Instructor TypIndicates whether the instructor is
                       primary, on-call, or backup.
                       P = Primary
                       B = Backup
                       O = On-Call

ISE-INSTRUCT           Numeric 10                                TR09.1
Element: Instructor    Contains the instructor's
                       identification number.

ISE-INSTR-START-DT     Numeric 8  (yyyymmdd)                     TR09.1
Instructor Start       Contains the first date the instructor
Date                   will teach if the instructor is not
                       teaching the full session.
                       Blank = instructor teaching full session

ISE-INSTR-DURATION     Numeric 3                                 TR09.1
Element: Length        Contains the length of time the
                       instructor will teach if the instructor
                       is not teaching the full session.
                       Blank = instructor teaching full session

ISE-UNITS-CODE         Alpha 1                                   TR09.1
Element: Length/Unit ofIndicates the unit in which the length
                       of time the instructor will teach is
                       measured.
                       Blank = instructor teaching full session
                       H = Hours
                       D = Days
                       M = Months

ISE-INST-DUR-DETAL     Alpha 30  (Lower Case)                    TR09.1
Element: Evaluation DetContains comments about the session and
                       instructor.

ISE-OVERALL-EVAL       Signed 7.2                                TR09.1
Element: Evaluation    Indicates the instructor's performance
                       level for the session.

ISE-OVERLL-EVAL-BS     Signed 7.2                                TR09.1
Element: Evaluation BasContains the total number on which the
                       evaluation is based.

ISE-OBJ-ID             Numeric 12                                TR09.1
Object                 This is the object identifier. It is
Identification         used to relate commitments or posted
                       transactions back to the originating
                       subsystems. Each subsystem record that
                       is updated as a commitment or posted
                       transaction is assigned an object
                       identifier. The object identifier is
                       maintained in the subsystem files and in
                       the Activity Commitments Detail and
                       Activity Transaction files. The object
                       identifier is a unique key used to drill
                       back from Activity Management to the
                       subsystems.

                         PAINSTSES FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ISESET1   COURSE                                                 TR04.1  TR08.1
          SESSION                                                TR09.1  TR14.1
          START-DATE                                             TR200   TR202
          INSTR-TYPE                                             TR204   TR21.1
          INSTRUCT                                               TR22.1  TR220
                                                                 TR26.1  TR500

ISESET2   OBJ-ID
          INSTRUCT
          INSTR-TYPE

ISESET5   INSTRUCT                                               TR07.1  TR09.1
          COURSE                                                 TR207
          SESSION
          START-DATE
          INSTR-TYPE

                         PAINSTSES FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Course Instruc PAINSCOURS   Required

                            ISE-COURSE        -> INC-COURSE
                            ISE-INSTRUCT      -> INC-INSTRUCT

Instructor     PAINSTRUCT   Required

                            ISE-INSTRUCT      -> INS-INSTRUCT

Session        PASESSION    Required

                            ISE-COURSE        -> SES-COURSE
                            ISE-SESSION       -> SES-SESSION
                            ISE-START-DATE    -> SES-START-DATE

                         PAINSTSES FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Course         PACOURSE

                            ISE-COURSE        -> CRS-COURSE
                                                 CRS-EFFECTIVE-DATE