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 Data Diagram

The Knowledge Link LMS Universe diagram illustrates how the current data in the Learning Management collection is organized for Business Objects users. The diagram shows the tables that are included in the Knowledge Link LMS Universe and the how the tables are joined to each other in the Universe.

A table or view is shown in the diagram as a black-bordered box. The table's name is shown in black; its Business Objects Class folder name is shown in color if it differs from the table's name. A grey-shaded box indicates a table from another data collection. (In addition to data from the Learning Management collection, the Learning Management Universe provides access to supplemental data from the Salary Management collection (on University employees and job classes) and from the General Ledger collection (on University orgs.). Those who have access to the Learning Management collection also have access to this supplemental data.) A box with a red or blue border indicates a Business Objects folder storing multiple tables or views. A join is shown as a line between the boxes for the joined tables. Labels in parentheses next to the box for a table indicate that the Business Objects folder (Class) for the table includes one or more Objects for data elements stored in reference tables:

(LABEL) Schema.ReferenceTableName.JoinColumn
JOB_CLASS DWADMIN.JOB_CLASS_GENERAL_V.JOB_CLASS
LM_JOB
DWLMS.LM_JOB.LM_JOB_ID
LM_ORG DWLMS.LM_ORG.LM_ORG_ID
LM_USER
DWLMS.LM_USER.PENN_ID
ORG_CODES DWADMIN.ORG_CODES.ORGANIZATION_CODE

Click on a black-bordered box for a table to see the documentation for that table. (Documentation will not be displayed if it is currently under construction.) Click on the green label next to the line denoting a join to see the join criteria.

The diagram can be printed in landscape orientation on letter-sized paper (8 1/2 by 11 inches).

  Collection Information:
top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


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