Data Warehouse: Learning Management Collection Tables and Data Elements


	Query the warehouse
	What you need
	Access request forms
	Password change
	Query tool software
	Training options
	Tips

	Related information
	About the warehouse
	Data Administration
	Security
	Support services
	Warehouse updates

	Data collections
	advancement
	assets
	brim
	brs
	express mail
	facilities
	faculty
	general ledger
	infrastructure
	learning management
	position inventory
	research
	salary management
	student
	tuition distribution
	cross-collection

Learning Management Collection Tables & Data Elements

Tables are listed in alphabetical order. Select Table to obtain the explanation, common uses, primary key, indexed data elements, related tables, and cautions for a table. Select Elements to obtain the definition, list of values, formats, and not null constraints for each data element in the table. A description of table and data element terminology is in the document What the Warehouse Contains.

COURSE_ITERATION
Table   Elements

COURSE_OBJECT
Table   Elements

KNODE
Table   Elements

KNODE_USER_JOIN
Table   Elements

LMS_BUSINESS_UNIT_GROUP
Table   Elements

LMS_BUSINESS_UNIT_TYPE
Table   Elements

LMS_COURSE_ITER_INSTRUCTOR
Table   Elements

LMS_COURSE_MASTER
Table   Elements

LMS_CURRENT_TRAINEE_CRS_STATUS
Table   Elements

LMS_DEFINITION
Table   Elements

LMS_LOCATION
Table   Elements

LMS_PERSON
Table   Elements

LMS_REGISTRATION
Table   Elements

LMS_REGISTRATION_STATUS
Table   Elements

LMS_STAFF_QUAL
Table Elements

LMS_TRAINEE_BU_COURSE_ASSIGN
Table Elements

LMS_TRAINEE_COURSE_ASSIGN
Table   Elements

PKG
Table   Elements

PKG_CRS_JOIN
Table   Elements

PROFILER_ASSIGNMENTS
Table   Elements

PROFILER_USER_ANSWER
Table   Elements

PROFILER_USER_QUESTIONNAIRE
Table   Elements

Other data included in the Learning Management and Profiler Business Objects Universe:

General Ledger data:

ORG_CODES
Table   Elements

Salary Management data:
EMPLOYEE_GENERAL
Table   Elements

JOB_CLASS_GENERAL
Table   Elements



Information Systems and Computing University of Pennsylvania Comments & Questions