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 |
TR01.1 | TR07.1 | TR08.1 | TR14.1 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
INC-INSTRUCT Element: Instructor | Numeric 10 Contains the instructor's identification number. |
|
||
INC-COURSE Element: Course Code | Alpha 10 Contains the course code. |
|
||
INC-EFFECTIVE-DATE Element: Effective Date | Numeric 8 (yyyymmdd) Contains the first date the instructor can teach the course. |
|
||
INC-END-DATE Element: End Date | Numeric 8 (yyyymmdd) Contains the last date the instructor can teach the course. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
INCSET1 |
COURSE INSTRUCT |
|
| ||||||||||||
INCSET3 |
INSTRUCT COURSE |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||
---|---|---|---|---|---|
Instructor | PAINSTRUCT |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Course | PACOURSE |
| |||||||||||||||
Session Instr | PAINSTSES |
Delete Restricted
|
All trademarks and registered trademarks are the property of their
respective owners.