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
BBR
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
World Travel
Cross-Collection

Learning Management Join Criteria

The list below provides information on the joins shown in the Knowledge Link LMS diagram, which illustrates the Business Objects Universe with that name. A table or view is shown in the diagram as a black-bordered box. A join is shown as a line between the boxes for the joined tables. The green label next to the line may be found below, along with the criteria for the join.

Further information on the diagram is available here.

Those using a query tool other than Business Objects can join tables as needed. The documentation for a given Learning Management table lists the related Learning Management tables that can be joined directly to it.

Join Label Join Criteria
J1

DWLMS.LM_PARENT_ORG.LM_CHILD_ORG_ID = DWLMS.LM_USER_ORG.LM_ORG_ID

J2

DWLMS.LM_USER_ORG.PENN_ID = DWLMS.LM_USER.PENN_ID

J3

DWLMS.LM_USER.PENN_ID = DWADMIN.EMPLOYEE_GENERAL_V.PENN_ID(+)

J4

DWLMS.LM_USER.PENN_ID = DWLMS.LM_USER_JOB.PENN_ID(+)

J5

DWLMS.LM_USER.PENN_ID = DWLMS.LM_USER_SUPERVISOR.PENN_ID(+)

J6

DWLMS.LM_USER.PENN_ID = DWLMS.LM_CURRENT_TRAINING_STATUS.PENN_ID(+)

J7

DWLMS.LM_CURRENT_TRAINING_STATUS.ITEM_TYPE_ID = DWLMS.LM_ITEM.ITEM_TYPE_ID(+) and DWLMS.LM_CURRENT_TRAINING_STATUS.ITEM_ID = DWLMS.LM_ITEM.ITEM_ID(+) and DWLMS.LM_CURRENT_TRAINING_STATUS.ITEM_REV_DATE = DWLMS.LM_ITEM.ITEM_REV_DATE(+)

J8

DWLMS.LM_CURRENT_TRAINING_STATUS.ITEM_TYPE_ID = DWLMS.LM_CURRICULUM_ITEM.ITEM_TYPE_ID(+) and DWLMS.LM_CURRENT_TRAINING_STATUS.ITEM_TYPE_ID = DWLMS.LM_CURRICULUM_ITEM.ITEM_TYPE_ID(+) and DWLMS.LM_CURRENT_TRAINING_STATUS.ITEM_REV_DATE = DWLMS.LM_CURRICULUM_ITEM.ITEM_REV_DATE(+)

J9

DWLMS.LM_CURRICULUM_ITEM.CURRICULUM_ID=DWLMS.LM_CURRICULUM.CURRICULUM_ID(+)

J10

DWLMS.LM_USER.PENN_ID=DWLMS.LM_REGISTRATION.PENN_ID(+)

J11

DWLMS.LM_REGISTRATION.SCHEDULED_OFFERING_ID = DWLMS.LM_SCHEDULED_OFFERING.SCHEDULED_OFFERING_ID(+)

J12

DWLMS.LM_SCHEDULED_OFFERING.FACILITY_ID = DWLMS.LM_FACILITY.LM_FACILITY_ID(+)

J13

DWLMS.LM_SCHEDULED_OFFERING.ITEM_TYPE_ID = DWLMS.LM_ITEM.ITEM_TYPE_ID(+) and DWLMS.LM_SCHEDULED_OFFERING.ITEM_ID = DWLMS.LM_ITEM.ITEM_ID(+) and
DWLMS.LM_SCHEDULED_OFFERING.ITEM_REV_DATE = DWLMS.LM_ITEM.ITEM_REV_DATE(+)

J14

DWLMS.LM_USER.PENN_ID = DWLMS.LM_LEARNING_HISTORY.PENN_ID(+)

J15

DWLMS.LM_LEARNING_HISTORY.ITEM_TYPE_ID = DWLMS.LM_ITEM.ITEM_TYPE_ID(+) and
DWLMS.LM_LEARNING_HISTORY.ITEM_ID = DWLMS.LM_ITEM.ITEM_ID(+) and
DWLMS.LM_LEARNING_HISTORY.ITEM_REV_DATE = DWLMS.LM_ITEM.ITEM_REV_DATE(+)

J16

DWLMS.LM_LEARNING_HISTORY.SCHEDULED_OFFERING_ID = DWLMS.LM_SCHEDULED_OFFERING.SCHEDULED_OFFERING_ID(+)

J17 DWLMS.LM_SCHEDULED_OFFERING.FACILITY_ID = DWLMS.LM_FACILITY.LM_FACILITY_ID(+)

 

  Collection Information:
top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


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