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

 

top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


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