LMS_TRAINEE_COURSE_ASSIGN
Table

DWLMS Schema

Explanation
Tracks the currently required course assignments for trainees. There
is one record for each trainee, for each course that is currently required
for the trainee. An LMS_TRAINEE_COURSE_ASSIGN
record stores:

the COURSE_MASTER_ID of the currently required course and the title of
the latest version of the course

the trainee’s name, Penn ID, and USER_REC_ID

the trainee's status with regard to the currently required course and
some of the factors affecting that status

The LMS_TRAINEE_COURSE_ASSIGN table is a summarized version of the LMS_TRAINEE_BU_COURSE_ASSIGN
table, and was developed to support ad hoc reporting. The primary source of
information on which courses are currently required for trainees is the KNODE_CRS_JOIN
table, which stores information on mandatory and
optional courses currently assigned to business units that may represent individual
trainees or groups of trainees. The USER_COURSES and LMS_TRAINEE_BU_COURSE_ASSIGN
tables store information
on mandatory courses currently assigned to individual trainees. If a trainee
belongs to multiple business units that have the same mandatory course assigned
to them, these tables store more than one record for the trainee and course.
The LMS_TRAINEE_COURSE_ASSIGN table stores one record per trainee and currently
required course. (If the course
is actively assigned as a mandatory course to a business unit that currently
includes the trainee, and the trainee is not grandfathered for the course,
the course is currently required for the trainee.) Historical information on
mandatory course assignments is not available. If a trainee was once required
to take a
particular
course,
but
is
not currently required to take it, there is no way to tell that the course was
ever required
for the trainee.

Common Uses

Reporting on the courses that are currently required for a particular
trainee

Listing all of the trainees that are currently required to take a particular
course

Identifying trainees that are or are not compliant
with regard to their currently required courses, or checking the some of
the factors that determine whether or not they are compliant.

As mentioned above, the LMS_TRAINEE_COURSE_ASSIGN table stores one record
per trainee and currently
required course. If the course
is actively assigned as a mandatory course to a business unit that
currently includes the trainee, and the trainee is not grandfathered
for the course,
the course is currently required for the trainee.

If a trainee was once required to take a particular course, but is
not currently required to take it, there is no way to tell that the course
was ever required for the trainee.

For information on all of the currently active mandatory course
assignments for a trainee and course (which may or may not result in
the course's being currently required for the trainee), see the LMS_TRAINEE_BU_COURSE_ASSIGN
table.

The LMS_TRAINEE_COURSE_ASSIGN table stores information on the trainee's
status with regard to the currently required course, as well as some of the
factors affecting that status.

PERIODICITY is the number of months in the period from the time when
a trainee completes the currently required course to the time when the
trainee
is due to complete it again. When PERIODICITY is null or 0, the trainee
is required to complete the course only once.

DUE_DATE is the date
when the trainee is next due to complete an iteration of the currently
required course. STATUS_DUEDATE_DESCRIPTION is a phrase describing when the
trainee is next due to complete an iteration of the course ('Neither
Soon Due nor Past Due', 'Soon Due', or 'Past
Due').

DUE_DATE and STATUS_DUEDATE_DESCRIPTION
are null if no initial due date was specified
when the mandatory course was assigned, and the trainee
has yet to complete an iteration of the course.

To check the initial due date
for all of the mandatory course assignments for the trainee
and course, see LMS_GOVERNING.INITIAL_DUE_DATE where
LMS_TRAINEE_BU_COURSE_ASSIGN.KCJ_REC_ID = LMS_GOVERNING.KCJ_REC_ID
and LMS_TRAINEE_BU_COURSE_ASSIGN.CO_MAS_ID = LMS_TRAINEE_COURSE_ASSIGN.CO_MAS_ID
and LMS_TRAINEE_BU_COURSE_ASSIGN.USER_REC_ID = LMS_TRAINEE_COURSE_ASSIGN.USER_REC_ID

DUE_DATE and STATUS_DUEDATE_DESCRIPTION are two of the factors
that determine:

whether Knowledge Link sends E-mail Notifications about
a course to a trainee. For more information, see the data
element documentation for COURSE_OBJECT.SD_BOUNDARY.

whether the trainee is compliant with regard to a currently
required course.

COMPLIANT
is 'Y' if the trainee is
currently required to take the course, and has completed an iteration
of the course,
and is not overdue to re-take the course.

In some cases, the record for a trainee
and currently required course has a null value for
STATUS_DUEDATE_DESCRIPTION.
Although
the trainee is not considered overdue for the course,
if the trainee has never completed an iteration of
the
course, COMPLIANT is 'N'.

Information on the trainee's latest completion
of the course is not available in the LMS_TRAINEE_COURSE_ASSIGN table.
See the documentation on the LAST_COURSE_COMPLETION_FLAG
in the LMS_REGISTRATION table.

The LMS_TRAINEE_COURSE_ASSIGN table stores
the COURSE_OWNER_BU_NUMBER, COURSE_OWNER_BU_ID, COURSE_OWNER_BU_NAME, which
provide information on the business unit that owns the
course version cited
in the mandatory course assignment that makes the course
currently required for the trainee. If the trainee has multiple mandatory
course assignments for the course that make it
currently required for the trainee, the assignment with the lowest non-null
value of DUE_DATE is the one whose COURSE_OWNER_BU_ID
is stored in the LMS_TRAINEE_COURSE_ASSIGN table. (For
all of the currently active mandatory course assignments for the trainee
and course, see the
LMS_TRAINEE_BU_COURSE_ASSIGN table.)

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.