Data Warehouse: Learning Management Data Collection



	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:



Information Systems and Computing University of Pennsylvania Comments & Questions