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 TR22.1
TR220 TR500 TR07.1 TR207
UPDATED BY
TR04.1 TR09.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ISE-COURSE Alpha 10 TR09.1
Course Code Contains the course code.
ISE-SESSION Numeric 5 TR09.1
Session Contains the session number.
ISE-START-DATE Numeric 8 (yyyymmdd) TR09.1
Session Start Date Contains the session start date.
ISE-INSTR-TYPE Alpha 1 TR09.1
Instructor Type Indicates whether the instructor is
primary, on-call, or backup.
P = Primary
B = Backup
O = On-Call
ISE-INSTRUCT Numeric 10 TR09.1
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
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
Length/Unit of Time 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
ISE-INST-DUR-DETAL Alpha 30 (Lower Case) TR09.1
Evaluation Details Contains comments about the session and
instructor.
ISE-OVERALL-EVAL Signed 7.2 TR09.1
Evaluation Indicates the instructor's performance
level for the session.
ISE-OVERLL-EVAL-BS Signed 7.2 TR09.1
Evaluation Base Contains 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 TR22.1
INSTRUCT TR220 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
|
