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

LMS_REGISTRATION_STATUS Table

DWLMS Schema

Explanation
Reference table for codes indicating the status of a trainee's registration for a given course iteration. Contains the 2-digit REGISTRATION_STATUS_CODE and its 12-character description (REGISTRATION_STATUS_DESC). For example, the description corresponding to REGISTRATION_STATUS_CODE 39 is "Enrolled.")

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
Displaying the description of the registration status, rather than the code that appears in a related table. ("Don't show the codes in the report. Show the English instead.")

Primary Key	Indexed Data Elements	Related Tables
REGISTRATION_STATUS_CODE	REGISTRATION_STATUS_CODE	LMS_CURRENT_CRS_ITER_REG_INSTR LMS_CURRENT_TRAINEE_CRS_STATUS LMS_CURR_TRNEE_CRS_STAT_MV LMS_DEFINITION LMS_REGISTRATION REGISTRATION

Cautions

• A Knowledge Link user who wishes to take a given course must register as a trainee for an iteration of that course. There are three values for registration status:
  • Enrolled
  • Wait-Listed
  • Dropped
• Although the LMS_REGISTRATION_STATUS table may be joined to any of the related tables listed above, it is recommended that it be joined only to REGISTRATION (to decode STATUS). LMS_DEFINITION is the source of the data in the LMS_REGISTRATION_STATUS table. There is no need to join LMS_REGISTRATION_STATUS to any of the other tables, because they store the description of the registration status (as well as the registration status code).

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_REGISTRATION_STATUS Table - Data Element Index    Tables and Data Elements   Learning Management Home   Data Warehouse Home