STUDENT_APS - Data Element Index . Tables and Data Elements . Student Records Data Home . Data Warehouse Home

STUDENT_APS Table

(dwst.student_aps)

Explanation

The basic unit of student academic information is the Academic Program. All students who have matriculated at the University of Pennsylvania have at least one academic program. The Academic Program Summary (APS) contains the high-level activity of students matriculating into academic programs, and all of the related entry/exit information for that program. There can be multiple rows for any given program for a student in the STUDENT_APS table. Unlike the DEGREE_PURSUAL table, which rolls all related APS rows into one row with a single Entry (indicating the earliest activity) and a single Exit (indicating the final actual exit from the program), the STUDENT_APS table contains all of the entry/exit activity associated with that program. It contains one row for every entry that appears on the Student Records System (SRS) screen 110.

Common Uses

• Replicate the student's academic program summary in a report, exactly as it appears on SRS screen 110.
• Used to get the "Primary Major" for the Degree Pursual class in Business Objects

Cautions

• Exercise caution when joining to this table from DEGREE_PURSUAL, DEGREE_TERM, ASSIGNMENT, MAJOR_MINOR_TERM, LEAVE, or DEGREE_RECEIVED, because you can get back multiple rows for anyone who has gone on leave and then returned, even if you join on DP_LINK_ID as well as Penn_ID. Consider using DEGREE_PURSUAL instead, unless you are intentionally looking for all of the specific APS rows represented in SRS..
• Do not use APS_SEQUENCE to determine the order of degrees. The Degree Order column in DEGREE_TERM_ALL_V will tell you what program is primary or secondary. The APS_SEQUENCE in STUDENT_APS is merely the order in which the records appear on SRS screen 110.
• While SSN is part of the key, it is not visable to most queries and users. Use PennID for identification of individuals in this table. Joins in the Business Objects universes are done on PennID, instead of SSN.

STUDENT_APS- Data Element Index . Tables and Data Elements . Student Records Data Home . Data Warehouse Home