DORIS Logo
 Back

  InstructionalAssignment


Description
Instructional or other staff course assignments by academic term.

Data includes percent of responsibility and primary instructor indicator.

Entity relationship: Person + Employee + CourseSection + AcademicTerm = InstructionalAssignment

Fields
  courseSectionNumber   string    CourseSection->courseSectionNumber
Unique identifier for every course section
Additional Notes
Value is client-defined, but is typically the Course Reference Number (CRN), the Course Section Identifier or a combination of data fields that result in a unique value.
The value for courseSectionNumber will be referenced as a one-to-one relationship in CourseSection, CourseSectionSchedule and Registration.
  instructorPercent   number   
Instructors percentage of responsibility to the assignment
  isIPEDSReportable   boolean   
If record is applicable for IPEDS reporting, value = 1, else 0
  isPrimary   boolean   
If instructor is the primary instructor of record, value = 1, else 0
  partOfTermCode   string    AcademicTerm->partOfTermCode
Part of academic term
Additional Notes
If field is not applicable or value unknown, use default value of 1 for full term.
  personId   string    Employee->PersonId
Unique identifier of employee
  recordActivityDate   date   
Date source record inserted or modified
  termCode   string    AcademicTerm->termCode
Academic term code
  crn   string    deprecated
Course instance assigned to instructor
Additional Notes
Renamed to courseSectionNumber. Remap the crn field to the courseSectionNumber field.
  section   string    deprecated
Course sequence number to uniquely identify a course instance within a term
Additional Notes
Removed. The section field is not required, since courseSectionNumber uniquely identifies the course section.

Example SQL