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 TR201 TR207


UPDATED BY
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.
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 02:24:58 2016

Home
Contact Us



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