if the universe makes the join for you, it is not recommended that you include a duplicate join in your query statement; duplication of sql join statements can significantly impact query performance. If your query has elements from two tables and you do not see the join listed, then you may need to include that logic in your webi query logic. For example, DEGEE_TERM and STUDENT_TERM are not directly joined in the STDTCANQ universe, so you probably will need to either join them on Term, or explicitly indicate the Term criteria for both tables in your query filters.
| Table to Table |
joined on |
| DEGREE_TERM to DEGREE_PURSUAL |
Penn_ID and DP_Link_ID |
| DEGREE TERM to MAJOR_MINOR_TERM |
Penn_ID and Term and DP_Link_ID |
| DEGREE_TERM to ENROLLMENT |
Penn_ID and Term |
| DEGREE_TERM to ADVISOR_TERM |
Penn_ID and Term.
Outer Join, open on the ADVISOR_TERM side |
| ENROLLMENT to ENROLLMENT_SECTION_TYPE |
Penn_ID and Section_ID and Term |
| ENROLLMENT to COURSE_SECTION |
Section_ID and Term |
| COURSE_SECTION to COURSE_SECT_TYPE_TERM |
Section_ID and Term
Outer Join, open on the COURSE_SECT_TYPE_TERM side |
| COURSE_SECTION to COURSE_SECTION_TUIT_SCHOOL |
Section_ID and Term
Outer Join, open on the COURSE_SECTION_TUIT_SCHOOL side |
| COURSE_SECTION to COURSE_SECTION_REG_CONTROL |
Section_ID and Term
Outer Join, open on the COURSE_SECTION_REG_CONTROL side |
| COURSE_SECTION to COURSE_SECTION_INSTRUCTOR |
Section_ID and Term
Outer Join, open on the COURSE_SECTION_INSTRUCTOR side |
| COURSE_SECTION_INSTRUCTOR to EMPLOYEE_GENERAL |
Instructor_Penn_ID |
| COURSE_SECTION to COURSE_INVENTORY |
Course_ID and
Term in COURSE_SECTION is greater than or equal to Course_First_Term in COURSE_INVENTORY
and
(Term in COURSE_SECTION is less than or equal to Course_Final_Term in COURSE_INVENTORY or Course_Final_term is null) |
| COURSE_INVENTORY to COURSE_XLIST_INVENTORY |
Course_ID and Course_First_Term
Outer Join, open on the COURSE_XLIST_INVENTOY side |
| COURSE_INVENTORY to COURSE_INVENTORY_DESC |
Course_ID
Outer Join, open on the COURSE_INVENTORY_DESC side |
| COURSE_INVENTORY_DESC to COURSE_INV_DESC_TEXT |
Course_ID
Outer Join, open on the COURSE_INV_DESC_TEXT side |
| COURSE_SECTION to COURSE_SECTION_MTG |
Section_ID and Term
Outer Join, open on the COURSE_SECTION_MTG side |
| DEGREE_PURSUAL to PERSON |
Penn_ID |
| PERSON to ENROLLMENT |
Penn_ID
|
| PERSON to ADDRESS |
Penn_ID
Outer Join, open on the ADDRESS side |
| PERSON to SRS_UNDERGRAD_ADMISSIONS |
Penn_ID
Outer Join, open on the SRS_UNDERGRAD_ADMISSIONS side |
| PERSON to STUDENT_HOLDS |
Penn_ID
Outer Join, open on the STUDENT_HOLDS side |
| PERSON to STUDENT_TERM |
Penn_ID |
| PERSON to DEGREE_RECEIVED |
Penn_ID
Outer Join, open on the DEGREE_RECEIVED side |
| PERSON to LEAVE |
Penn_ID
Outer Join, open on the LEAVE side |
| DEGREE_RECEIVED to MAJOR_MINOR_TERM |
Penn_ID and DP_LINK_ID
Outer Join, open on the MAJOR_MINOR_TERM side |
| STUDENT_TERM to ATHLETIC |
Penn_ID and Term
Outer Join, open on the ATHLETIC side |
| STUDENT_TERM to EQUITY_AND_ACCESS_PROGRAMS |
Penn_ID and Term
Outer Join, open on the EQUITY_AND_ACESS_PROGRAMS side |
| DEGREE_PURSUAL to ASSIGNMENT |
Penn_ID and DP_LINK_ID |
| ASSIGNMENT to ENROLLMENT |
Penn_ID and Term and Section_ID |
| DEGREE_PURSUAL to INSTITUTION |
Previous_Instituion/Institution_Code
Outer Join, open on the INSTITUTION side |
| DEGREE_PURSUAL to INTERNAL_COURSE_EQUIVALENT |
Penn_ID and DP_LINK_ID
Outer Join, open on the INTERNAL_COURSE_EQUIVALENT side |
| DEGREE_PURSUAL to HIATUS |
Penn_ID and DP_LINK_ID
Outer Join, open on the HIATUS side |
| DEGREE_PURSUAL and TRANSCRIPT_HONORS |
Penn_ID
Outer Join, open on the TRANSCRIPT_HONORS side |
| DEGREE_PURSUAL and TRANSCRIPT_TEXT |
Penn_ID and Career
Outer Join, open on the TRANSCRIPT_TEXT side |
| DEGREE_PURSUAL and MAJOR_MINOR_TERM |
Penn_ID and DP_LINK_ID and Term=Last_Degee_Term
Outer Join, open on the MAJOR_MINOR_TERM side |
| DEGREE_PURSUAL to MASTER_THESIS |
Penn_ID
Outer Join, open on the MASTER_THESIS side |
| DEGREE_PURSUAL to PHD_DISSERTATION |
Penn_ID
Outer Join, open on the PHD_DISSERTATION side |
| DEGREE_PURSUAL to PHD_COMMITTEE |
Penn_ID
Outer Join, open on the PHD_COMMITTEE side |
| DEGREE_PURSUAL to GRADUATE_TEACHING_TERM |
Penn_ID
Outer Join, open on the GRADUATE_TEACHING_TERM side |
| DEGREE_PURSUAL to GRADUATE_LANGUAGE |
Penn_ID
Outer Join, open on the GRADUATE_LANGUAGE side |
| DEGREE_PURSUAL to LANGUAGE_CERTIFICATE |
Penn_ID
Outer Join, open on the LANGUAGE_CERTIFICATE side |
| COURSE_SECTION_MTG to ROOM_PROFILE |
Department = Room_Dept_Priority_1 |
| ROOM_PROFILE to BUILDING |
Building_Code
Outer Join, open on the BUILDING side |
| STUDENT_APS TO PERSON_ALL_V |
Penn_ID |
