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
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
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.
- Listing the instructors assigned
to the specified course iterations.
- Listing the course iterations assigned to the
||Indexed Data Elements
- 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
system. No two
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
- Information on the course iteration is available in the COURSE_ITERATION
table where LMS_COURSE_ITER_INSTRUCTOR.ITERATION_ID = COURSE_ITERATION.ITERATION_ID.
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
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.
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
Questions about this page? Email us at email@example.com