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

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: Wed Jun 08 20:50:24 2016

Home
Contact Us



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