Penn Computing

University of Pennsylvania
Penn Computing << go backback
LMS_COURSE_ITER_INSTRUCTOR Table - Data Element Index    Tables and Data Elements   Learning Management Home   Data Warehouse Home

LMS_COURSE_ITER_INSTRUCTOR Table

DWLMS Schema

Explanation
Tracks current information on the instructor(s) assigned to teach the course iterations. There is one LMS_COURSE_ITER_INSTRUCTOR record per combination of instructor (INSTRUCTOR_PENN_ID) and course iteration (ITERATION_ID). In LMS_COURSE_ITER_INSTRUCTOR, a course iteration may have one or more instructors, and an instructor may be assigned to teach one or more course iterations.

A course is a formal educational unit that deals with a particular subject. A course provides training to members of the Penn Community in support of their academic activities and job responsibilities at the University and/or at the University of Pennsylvania Health System. A course may have more than one version. For example, if the course covers Software Package X, version 1 of the course might cover Software Package X release 2.0, and version 2 of the course might cover Software Package X release 3.5. A course iteration is an offering of a particular version of the course. For example, version 2 of the instructor-led course on Software Package X will have two course iterations if it is offered in two different places on the same date and at the same time. Web-based courses commonly have one iteration per version.

Common Uses

  • Listing the instructors assigned to the specified course iterations.
  • Listing the course iterations assigned to the specified instructors.
Primary Key Indexed Data Elements Related Tables
USER_REC_ID
ITERATION_ID
INSTRUCTOR_PENN_ID
ITERATION_ID
USER_REC_ID
CUSTOM_DATA
GEN21_USER
LMS_CURRENT_CRS_ITER_REG_INSTR
LMS_CURRENT_TRAINEE_CRS_STATUS
LMS_PERSON
LMS_REGISTRATION
LMS_STAFF_ASSIGN
LMS_STAFF_QUAL
LMS_STG_PERSON
LMS_TRAINEE_BU_COURSE_ASSIGN
LMS_TRAINEE_COURSE_ASSIGN
PROFILER_ASSIGNMENTS
PROFILER_USER_ANSWER
PROFILER_USER_QUESTIONNAIRE
REGISTRATION
UPHS_CI_PATHLORE
UPHS_RAW_DATA
UPHS_USER_ENTITY
USER_COURSES


Cautions

  • The LMS_COURSE_ITER_INSTRUCTOR table stores only the current information for a course iteration/instructor combination. Historical information is not available. For example, say John Doe was originally one of the instructors assigned to teach course iteration I, but he was later replaced by Jane Smith. There is no way to tell from the LMS_COURSE_ITER_INSTRUCTOR table that John Doe was ever assigned to teach course iteration I.
  • You can identify the instructor assigned to a given course iteration using the INSTRUCTOR_PENN_ID or the USER_REC_ID.
    • The INSTRUCTOR_PENN_ID stores the instructor's Penn ID, which is an 8-digit identification number assigned to the instructor by the Penn Community system. No two persons have the same Penn ID. Information on the instructor is available in the LMS_PERSON table where LMS_COURSE_ITER_INSTRUCTOR.INSTRUCTOR_PENN_ID = LMS_PERSON.PENN_ID. (Business Objects users will see that these tables are joined for them in the Learning Management and Profiler Universe.)
    • The USER_REC_ID is a number used within the Knowledge Link system to uniquely identify the instructor. Information on the instructor is also available in the GEN21_USER table (a subset of the LMS_PERSON data elements), where LMS_COURSE_ITER_INSTRUCTOR.USER_REC_ID = GEN21_USER.USER_REC_ID.
    • Note that every instructor has a record in the LMS_PERSON and GEN21_USER tables, but those tables also store records on people who are not instructors.
  • The ITERATION_ID identifies the course iteration to which the instructor is assigned.
    • Information on the course iteration is available in the COURSE_ITERATION table where LMS_COURSE_ITER_INSTRUCTOR.ITERATION_ID = COURSE_ITERATION.ITERATION_ID. (Business Objects users will see that these tables are joined for them in the Learning Management and Profiler Universe.)
    • Many course iterations do not have any corresponding records in the LMS_COURSE_ITER_INSTRUCTOR table. This is common for iterations of course versions that are Web-based, or for course iterations that are under construction. However, there are iterations of instructor-led course versions that do not have any corresponding records in the LMS_COURSE_ITER_INSTRUCTOR table. Many such course iterations are closed, but some are active.
    • Although most of the records in the LMS_COURSE_ITER_INSTRUCTOR table apply to iterations of instructor-led course versions, there are many that apply to active iterations of Web-based course versions.

Source

Knowledge Link, the learning management system used by the University and by the University of Pennsylvania Health System (UPHS) since March, 2005.

Knowledge Link enables authorized administrators to schedule training courses, assign resources to courses, assign groups of trainees to courses, and to create online courses. It enables trainees to find out what courses have been assigned to them, to register for those courses (whether those courses are on-line or instructor-led), to take on-line courses, and to provide feedback via course evaluations. Knowledge Link was first used to track information on training required by regulation, but it now tracks information on a variety of training courses.

LMS_COURSE_ITER_INSTRUCTOR Table - Data Element Index    Tables and Data Elements   Learning Management Home   Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

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