Penn Computing

University of Pennsylvania
Penn Computing << go backback

COURSE SECTION INSTRUCTOR Table - Data Element Index . Tables and Data Elements . Student Records Data Home . Data Warehouse Home




Links the instructor(s) teaching a course section to the course section taught. One record exists for each term an instructor teaches a course section and for each course section that instructor teaches. For example, if an instructor taught two course sections during the Spring 1996 term, there will be two records for that instructor for that term. If a course section is team-taught by two instructors during a term, there would be a record for each instructor for the course section.

Common Uses

  • Determining who taught a course section for a particular term. ("Who is teaching the Nursing practicum this term?")
  • Determining the instructors who taught a course section over time. ("Has this professor always taught this course (section)?")
  • Analyzing faculty load. ("What is the average number of course sections that a faculty member teaches during the summer?")
Primary Key Indexed Data Elements Related Tables


  • Instructors are assigned to courses in SRS, on the 132 screen. Departments are encouraged to use only valid WorkDay records when assigning instructors to courses. The Course_Section_Instructor table does not contain the instructor names that are typed into SRS screen 129; the name comes from a lookup function in SRS: When entering instructor information on SRS screen 132, departments can do a Name Lookup. The lookup goes to a file that comes from PennCommunity, and will find anyone who matches the entered name who has an affiliation record with source = PENNPAY. Note that effective 7/1/2019, the "PENNPAY" affiliation is sourced from WorkDay, replacing the legacy Payroll system data on active Workers and Affiliates.

  • If joining this table to COURSE_SECTION, use Instructor_Load to properly take into account the official share of participation the instructor has in teaching the course section.
  • SSN is not visable to most queries and users. Also, the SSN of the instructor found in this table is the SSN as-of the last time the course section was updated from SRS; there is no ssn-change process for instructor SSN. Use PennID for identification of individuals in this table. Joins in the Business Objects universes are done on PennID, instead of SSN.
  • This table does not have the name of the instructor. Either use CENSUS_TERM Table, or join to the EMPLOYEE_GENERAL view to get the instructor name.

COURSE SECTION INSTRUCTOR Table - Data Element Index . Tables and Data Elements . Student Records Data Home . Data Warehouse Home

Questions about this page? Email us at

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania