Penn Computing

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

LMS_STAFF_QUAL - Data Element Index

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

 

Data element Definition
CO_REC_ID

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

A number that uniquely identifies the version of the course that the instructor (USER_REC_ID) is qualified to teach.

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. Information on the course version is available in the COURSE_OBJECT table where LMS_STAFF_QUAL.CO_REC_ID = COURSE_OBJECT.CO_REC_ID.

Example: 10100

Values:
Refer to the COURSE_OBJECT table for values.
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.
QUAL_DATE

Indexed - no
Format - date
May be null? yes

If the instructor (USER_REC_ID) is qualified to teach a course version (CO_REC_ID) for a limited period of time, QUAL_DATE is the date when that period begins. In most cases, there is no limitation on when the instructor is qualified to teach the course version, so QUAL_DATE is null.

Note: The value of this data element sometimes includes not only the date, but also the time, although Business Objects displays only the date by default in reports. Business Objects users that set a condition on QUAL_DATE and type a date value in the condition will find that Business Objects supplies 12:00:00 AM as the time. This does not matter if the value of QUAL_DATE does not include the time, but if it does, that time is almost never 12:00:00 AM. Because conditions using an = (Equal to) operator will often not work as expected, use BETWEEN instead. For example, rather than setting the condition QUAL_DATE Equal to 3/1/2005, set the condition QUAL_DATE Between 3/1/2005 and 3/2/2005.

Example: 1/15/2008

Values:
List of values not available
QUAL_EXPIRE

Indexed - no
Format - date
May be null? yes

If the instructor (USER_REC_ID) is qualified to teach a course version (CO_REC_ID) for a limited period of time, QUAL_EXPIRE is the date when that period ends. In most cases, QUAL_EXPIRE is null (because the period is open-ended, or because there is no limitation on when the instructor is qualified to teach the course version).

Note: The value of this data element sometimes includes not only the date, but also the time, although Business Objects displays only the date by default in reports. Business Objects users that set a condition on QUAL_EXPIRE and type a date value in the condition will find that Business Objects supplies 12:00:00 AM as the time. This does not matter if the value of QUAL_EXPIRE does not include the time, but if it does, that time is almost never 12:00:00 AM. Because conditions using an = (Equal to) operator will often not work as expected, use BETWEEN instead. For example, rather than setting the condition QUAL_EXPIRE Equal to 3/1/2006, set the condition QUAL_EXPIRE Between 3/1/2006 and 3/2/2006.

Example: 1/15/2009

Values:
List of values not available
QUAL_REC_ID

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

The number that uniquely identifies the LMS_STAFF_QUAL record. This table has one record for each combination of course version (CO_REC_ID) and qualified instructor (USER_REC_ID).

Example: 10001

Values:
Refer to the LMS_STAFF_QUAL table for values.
REMARKS

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

Notes (if any) regarding the course version (CO_REC_ID) and the qualified instructor (USER_REC_ID). The data is stored in mixed case. The value of REMARKS is often null.

Values:
List of values not available
USER_REC_ID

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

The code used internally by Knowledge Link to uniquely identify the instructor who is qualified to teach the course version (CO_REC_ID).

Information on the instructor is available in the LMS_PERSON table where LMS_COURSE_ITER_INSTRUCTOR.USER_REC_ID = LMS_PERSON.USER_REC_ID. Another option is to access information on the instructor 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.

Example: 21085

Values:
Refer to the LMS_PERSON table or the GEN21_USER table for values.

 

LMS_STAFF_QUAL 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