Penn Computing

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

LMS_COURSE_ITER_INSTRUCTOR - Data Element Index

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

 

Data element Definition
INSTRUCTOR_PENN_ID

Indexed - yes
Format - varchar2 (8)
May be null? yes

The Penn ID of the instructor assigned to teach the course iteration (ITERATION_ID). See also USER_REC_ID.

A Penn ID is an 8-digit identification number assigned to an individual by the Penn Community system. No two persons have the same Penn ID.

Information on the instructor is available in the LMS_PERSON table where LMS_COURSE_ITER_INSTRUCTOR.INSTRUCTOR_PENN_ID = LMS_PERSON.PENN_ID.

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.

Example: 12345678

Values:
List of values not available
ITERATION_ID

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

A number used within the Knowledge Link system to uniquely identify the course iteration that the instructor (INSTRUCTOR_PENN_ID) has been assigned 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. 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.

Information on the course iteration is available in the COURSE_ITERATION table where LMS_COURSE_ITER_INSTRUCTOR.ITERATION_ID = COURSE_ITERATION.ITERATION_ID.

Example: 46461

Values:
Refer to the COURSE_ITERATION 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.
PRIMARY_INSTRUCTOR

Indexed - yes
Format - varchar2 (1)
May be null? yes

This data element currently is not used.

USER_REC_ID

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

A number used within the Knowledge Link system to uniquely identify the instructor assigned to teach the course iteration (ITERATION_ID). See also INSTRUCTOR_PENN_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.

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.

Example: 20454

Values:
Refer to the LMS_COURSE_ITER_INSTRUCTOR table for values.

 

LMS_COURSE_ITER_INSTRUCTOR 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