PAINSTSES – Session Instructors

System
Personnel (PA)
Prefix
ISE
Primary key
COURSE, SESSION, START-DATE, INSTR-TYPE, INSTRUCT
Fields
12
Updated by
2 programs
Referenced by
12 programs

PAINSTSES is the Session Instructors table in Lawson Personnel (prefix ISE). It is indexed by COURSE, SESSION, START-DATE, INSTR-TYPE, INSTRUCT (ISESET1); alternate indexes: ISESET2 and ISESET5. It is related 1:1 to PAINSCOURS, PAINSTRUCT and PASESSION and 1:M to PACOURSE. It is updated by TR04.1 and TR09.1 and referenced by TR07.1, TR08.1, TR14.1, TR200, TR202, TR204, TR207, TR21.1 and 4 more. The table has 12 fields, 3 indexes and 4 documented relations.

About PAINSTSES

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.

Fields (12)

Column = COBOL field name without the ISE- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
ISE-COURSE PK
COURSE		Alpha 10Contains the course code.TR09.1
ISE-SESSION PK
SESSION		Numeric 5Contains the session number.TR09.1
ISE-START-DATE PK
START_DATE		Numeric 8 (yyyymmdd)Contains the session start date.TR09.1
ISE-INSTR-TYPE PK
INSTR_TYPE		Alpha 1Indicates whether the instructor is primary, on-call, or backup.
  • P Primary
  • B Backup
  • O On-Call
TR09.1
ISE-INSTRUCT PK
INSTRUCT		Numeric 10Contains the instructor's identification number.TR09.1
ISE-INSTR-START-DT
INSTR_START_DT		Numeric 8 (yyyymmdd)Contains the first date the instructor will teach if the instructor is not teaching the full session.
  • Blank instructor teaching full session
TR09.1
ISE-INSTR-DURATION
INSTR_DURATION		Numeric 3Contains the length of time the instructor will teach if the instructor is not teaching the full session.
  • Blank instructor teaching full session
TR09.1
ISE-UNITS-CODE
UNITS_CODE		Alpha 1Indicates 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
TR09.1
ISE-INST-DUR-DETAL
INST_DUR_DETAL		Alpha 30 (Lower Case)Contains comments about the session and instructor.TR09.1
ISE-OVERALL-EVAL
OVERALL_EVAL		Signed 7.2Indicates the instructor's performance level for the session.TR09.1
ISE-OVERLL-EVAL-BS
OVERLL_EVAL_BS		Signed 7.2Contains the total number on which the evaluation is based.TR09.1
ISE-OBJ-ID
OBJ_ID		Numeric 12This is the object identifier. It is 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.TR09.1

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ISESET1COURSE, SESSION, START-DATE, INSTR-TYPE, INSTRUCTPrimaryTR04.1, TR08.1, TR09.1, TR14.1, TR200, TR202, TR204, TR21.1 +4 more
ISESET2OBJ-ID, INSTRUCT, INSTR-TYPE—
ISESET5INSTRUCT, COURSE, SESSION, START-DATE, INSTR-TYPETR07.1, TR09.1, TR207

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
Course InstrucPAINSCOURSRequiredISE-COURSE → INC-COURSE, ISE-INSTRUCT → INC-INSTRUCT
InstructorPAINSTRUCTRequiredISE-INSTRUCT → INS-INSTRUCT
SessionPASESSIONRequiredISE-COURSE → SES-COURSE, ISE-SESSION → SES-SESSION, ISE-START-DATE → SES-START-DATE

One to many (1) — child tables

RelationTableRulesConditionField map
CoursePACOURSEISE-COURSE → CRS-COURSE, → CRS-EFFECTIVE-DATE

Programs

Updated by (2)

Referenced by (12)