PAINSCOURS

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


UPDATED BY
TR01.1 TR07.1 TR08.1 TR14.1 TR201 TR207

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
INC-INSTRUCT
Element: Instructor		Numeric 10
Contains the instructor's identification number.
TR08.1 TR14.1
INC-COURSE
Element: Course Code		Alpha 10
Contains the course code.
TR08.1 TR14.1
INC-EFFECTIVE-DATE
Element: Effective Date		Numeric 8 (yyyymmdd)
Contains the first date the instructor can teach the course.
TR08.1 TR14.1
INC-END-DATE
Element: End Date		Numeric 8 (yyyymmdd)
Contains the last date the instructor can teach the course.
TR08.1 TR14.1


PAINSCOURS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
INCSET1 COURSE
INSTRUCT
TR01.1 TR08.1
TR09.1 TR14.1
TR201
INCSET3 INSTRUCT
COURSE
TR07.1 TR09.1
TR14.1 TR207


PAINSCOURS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Instructor PAINSTRUCT Required
INC-INSTRUCT->INS-INSTRUCT


PAINSCOURS FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED 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

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

Home
Contact Us



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