Penn Computing

Penn Computing

Computing Menu Computing A-Z
Computing Home Information Systems & Computing Penn

  
  UPDATES
Current Load Status
Regular Availability
  
  INFORMATION
FAQs & Tips
Password Changer
Support services
Security
About the Data Warehouse
Data Administration
  
  DATA COLLECTIONS
Advancement
Assets
BRIM
Express Mail
Facilities
Faculty
GAR
General Ledger
Infrastructure
Learning Management
OIP
Position Inventory
Research-PennERA Proposals
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.

LM_COMPLETION_STATUS
Table   Elements

LM_CURRENT_TRAINING_STATUS
Table   Elements

LM_CURRICULUM
Table   Elements

LM_CURRICULUM_ITEM
Table   Elements

LM_DOMAIN
Table   Elements

LM_FACILITY
Table   Elements

LM_ITEM
Table   Elements

LM_JOB
Table   Elements

LM_LEARNING_HISTORY
Table   Elements

LM_ORG
Table   Elements

LM_PARENT_ORG
Table   Elements

LM_REGISTRATION
Table   Elements

LM_SCHEDULED_OFFERING
Table   Elements

LM_USER
Table   Elements

LM_USER_JOB
Table   Elements

LM_USER_ORG
Table   Elements

LM_USER_SUPERVISOR
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

 

  Collection Information:


top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


Penn Computing University of Pennsylvania
Information Systems and Computing, University of Pennsylvania