Data Warehouse: Learning Management Data Collection

[an error occurred while processing this directive]



	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 Learning Management 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.

Several tables in the Learning Management collection are available for ad hoc reporting, but are not included in the Learning Management Universe, and are not illustrated in a diagram. 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	LMS_BUSINESS_UNIT_GROUP.BUSINESS_UNIT_MEMBER_NUMBER = KNODE_USER_JOIN.KNODE_ID
J2	KNODE_USER_JOIN..USER_REC_ID = LMS_PERSON.USER_REC_ID
J3	LMS_PERSON.PENN_ID = EMPLOYEE_GENERAL_V.PENN_ID(+)
J4	LMS_PERSON.USER_REC_ID = LMS_TRAINEE_COURSE_ASSIGN.USER_REC_ID(+)
J5	LMS_PERSON.USER_REC_ID = LMS_TRAINEE_BU_COURSE_ASSIGN.USER_REC_ID(+)
J6	LMS_TRAINEE_BU_COURSE_ASSIGN.COURSE_ASSIGNMENT_BU_NUMBER = LMS_BUSINESS_UNIT_GROUP.BUSINESS_UNIT_MEMBER_NUMBER
J7	LMS_PERSON.USER_REC_ID = LMS_CURRENT_TRAINEE_CRS_STATUS.USER_REC_ID(+)
J8	LMS_PERSON.USER_REC_ID = LMS_REGISTRATION.USER_REC_ID(+)
J9	LMS_CURRENT_TRAINEE_CRS_STATUS.COURSE_OWNER_BU_NUMBER = LMS_BUSINESS_UNIT_GROUP.BUSINESS_UNIT_MEMBER_NUMBER
J10	LMS_CURRENT_TRAINEE_CRS_STATUS.ITERATION_ID = COURSE_ITERATION.ITERATION_ID(+)
J11	LMS_LOCATION.LOCATION_ID(+) = COURSE_ITERATION.LOCATION_ID
J12	COURSE_ITERATION.ITERATION_ID = LMS_COURSE_ITER_INSTRUCTOR.ITERATION_ID(+)
J13	COURSE_ITERATION.CO_REC_ID = COURSE_OBJECT.CO_REC_ID(+)
J14	COURSE_OBJECT.CO_MAS_ID = LMS_COURSE_MASTER.CO_MAS_ID(+)
J15	LMS_BUSINESS_UNIT_GROUP.BUSINESS_UNIT_MEMBER_NUMBER = LMS_COURSE_MASTER.LATEST_COURSE_OWNER_BU_NUMBER
J16	LMS_REGISTRATION.COURSE_OWNER_BU_NUMBER = LMS_BUSINESS_UNIT_GROUP.BUSINESS_UNIT_MEMBER_NUMBER
J17	LMS_REGISTRATION.ITERATION_ID = COURSE_ITERATION.ITERATION_ID
J18	LMS_LOCATION.LOCATION_ID(+) = COURSE_ITERATION.LOCATION_ID
J19	COURSE_ITERATION.ITERATION_ID = LMS_COURSE_ITER_INSTRUCTOR.ITERATION_ID(+)
J20	LMS_COURSE_ITER_INSTRUCTOR.USER_REC_ID = LMS_PERSON.USER_REC_ID(+)
J21	COURSE_ITERATION.CO_REC_ID = COURSE_OBJECT.CO_REC_ID
J22	LMS_BUSINESS_UNIT_GROUP.BUSINESS_UNIT_MEMBER_NUMBER = COURSE_OBJECT.KNODE_ID
J23	COURSE_OBJECT.CO_REC_ID = LMS_STAFF_QUAL.CO_REC_ID(+)
J24	COURSE_OBJECT.CO_REC_ID = PKG_CRS_JOIN.CO_REC_ID(+)
J25	PKG_CRS_JOIN.PKG_ID = PKG.PKG_ID(+)
J26	COURSE_OBJECT.CO_MAS_ID = LMS_COURSE_MASTER.CO_MAS_ID
J27	LMS_BUSINESS_UNIT_GROUP.BUSINESS_UNIT_MEMBER_NUMBER = LMS_COURSE_MASTER.LATEST_COURSE_OWNER_BU_NUMBER



Information Systems and Computing University of Pennsylvania Comments & Questions