PAINSTSES

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.
UPDATED BY
TR04.1 TR07.1 TR08.1 TR09.1 TR14.1 TR200
TR202 TR204 TR207 TR21.1 TR22.1 TR220
TR26.1 TR500

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ISE-COURSE
Element: Course Code		Alpha 10
Contains the course code.
TR09.1
ISE-SESSION
Element: Session		Numeric 5
Contains the session number.
TR09.1
ISE-START-DATE
Element: Session Start Date		Numeric 8 (yyyymmdd)
Contains the session start date.
TR09.1
ISE-INSTR-TYPE
Element: Instructor Type		Alpha 1
Indicates whether the instructor is primary, on-call, or backup. P = Primary B = Backup O = On-Call
TR09.1
ISE-INSTRUCT
Element: Instructor		Numeric 10
Contains the instructor's identification number.
TR09.1
ISE-INSTR-START-DT
Instructor Start
Date		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
Element: Length		Numeric 3
Contains 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
Element: Length/Unit of Time		Alpha 1
Indicates 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
Element: Evaluation Details		Alpha 30 (Lower Case)
Contains comments about the session and instructor.
TR09.1
ISE-OVERALL-EVAL
Element: Evaluation		Signed 7.2
Indicates the instructor's performance level for the session.
TR09.1
ISE-OVERLL-EVAL-BS
Element: Evaluation Base		Signed 7.2
Contains the total number on which the evaluation is based.
TR09.1
ISE-OBJ-ID
Element: Obj Id		Numeric 12
This 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


PAINSTSES FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ISESET1 COURSE
SESSION
START-DATE
INSTR-TYPE
INSTRUCT
TR04.1 TR08.1
TR09.1 TR14.1
TR200 TR202
TR204 TR21.1
TR22.1 TR220
TR26.1 TR500
ISESET2 OBJ-ID
INSTRUCT
INSTR-TYPE
ISESET5 INSTRUCT
COURSE
SESSION
START-DATE
INSTR-TYPE
TR07.1 TR09.1
TR207


PAINSTSES FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Course PACOURSE
ISE-COURSE->CRS-COURSE
  CRS-EFFECTIVE-DATE

File created: Thu Jun 09 11:22:14 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.