|
COURSE
SECTION INSTRUCTOR Table - Data Element Index . Tables
and Data Elements . Student Records
Data Home . Data Warehouse Home
COURSE SECTION INSTRUCTOR Table
(dwadmin.course_section_instructor)
Explanation
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 |
| TERM, SECTION_ID, INSTRUCTOR_SSN |
INSTRUCTOR_LOAD INSTRUCTOR_SSN SECTION_ID |
CENSUS_TERM COURSE_SECTION |
Cautions
- 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 da-staff@isc.upenn.edu
|
