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

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.
  

CO_MAS_ID
USER_REC_ID

COMPLIANT
COURSE_MASTER_ID
COURSE_OWNER_BU_ID
COURSE_OWNER_BU_NAME
COURSE_OWNER_BU_NUMBER
CO_MAS_ID
CURRENTLY_REQUIRED
DUE_DATE
FIRST_NAME
LAST_NAME
MANDATORY
PENN_ID
STATUS_DUEDATE_DESCRIPTION
TRAINEE_CRS_ASSIGNMNT_STATUS
USER_REC_ID

COURSE_MASTER
COURSE_OBJECT
CUSTOM_DATA
GEN21_USER
KNODE
KNODE_USER_JOIN
LMS_BUSINESS_UNIT_GROUP
LMS_COURSE_MASTER
LMS_CURRENT_CRS_ITER_REG_INSTR
LMS_CURRENT_TRAINEE_CRS_STATUS
LMS_PERSON
LMS_REGISTRATION
LMS_TRAINEE_BU_COURSE_ASSIGN
LMS_TRAINEE_COURSE_COMPLIANCE
PKG_CRS_JOIN
PROFILER_ASSIGNMENTS
PROFILER_USER_QUESTIONNAIRE
REGISTRATION
UPHS_RAW_DATA
UPHS_USER_ENTITY
USER_COURSES

Cautions

• 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.

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