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
ISSS-iOffice
Learning Management
Position Inventory
Research-PennERA Proposals
Salary Management
Student
Travel Expense Management
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