Penn Computing

University of Pennsylvania
Penn Computing << go backback
LMS_REGISTRATION_STATUS Table   Tables and Data Elements   Learning Management Home   Data Warehouse Home

LMS_REGISTRATION_STATUS - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.

 

Data element Definition
LAST_EXTRACT_DATE

Indexed - no
Format - date
May be null? yes

The date this record was extracted from Knowledge Link and loaded into the Data Warehouse.

Example: 3/31/2008

Values:
List of values not available.
REGISTRATION_STATUS_CODE

Indexed - yes
Format - number (10)
May be null? no

A number that uniquely identifies the status of a trainee's registration for a given course iteration.

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.

Values:
39 (Enrolled)
40 (Wait-Listed)
41 (Dropped)
      
REGISTRATION_STATUS_DESC

Indexed - no
Format - varchar2 (12)
May be null? yes

The description of the status of a trainee's registration for a given course iteration.

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.

Values:
Dropped
Enrolled
Wait-Listed

 

LMS_REGISTRATION_STATUS Table   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