Penn Computing

University of Pennsylvania
Penn Computing << go backback
Tables and Data Elements . Student Data Home . Data Warehouse Home

 

List of joins in the STDTCANQ Universe

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.

see the Universe Diagram for a graphic of how the tables are joined in this universe.
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 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

 

Tables and Data Elements . Student Data Home . Data Warehouse Home

 


Questions about this page? Email us at da-staff@isc.upenn.edu

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