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