PAINSCOURS FILE
Course Instructors
Contains the names of the instructors who can teach each course.
TR08.1 (Instructor Courses) is the primary program that updates this file.
REFERENCED BY
TR09.1 TR201 TR207
UPDATED BY
TR01.1 TR07.1 TR08.1 TR14.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
INC-INSTRUCT Numeric 10 TR08.1 TR14.1
Instructor Contains the instructor's
identification number.
INC-COURSE Alpha 10 TR08.1 TR14.1
Course Code Contains the course code.
INC-EFFECTIVE-DATE Numeric 8 (yyyymmdd) TR08.1 TR14.1
Effective Date Contains the first date the instructor
can teach the course.
INC-END-DATE Numeric 8 (yyyymmdd) TR08.1 TR14.1
End Date Contains the last date the instructor
can teach the course.
PAINSCOURS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
INCSET1 COURSE TR01.1 TR08.1
INSTRUCT TR09.1 TR14.1
TR201
INCSET3 INSTRUCT TR07.1 TR09.1
COURSE TR14.1 TR207
PAINSCOURS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Instructor PAINSTRUCT Required
INC-INSTRUCT -> INS-INSTRUCT
PAINSCOURS FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Course PACOURSE
INC-COURSE -> CRS-COURSE
CRS-EFFECTIVE-DATE
Session Instr PAINSTSES Delete Restricted
INC-COURSE -> ISE-COURSE
ISE-SESSION
ISE-START-DATE
ISE-INSTR-TYPE
ISE-INSTRUCT
|