Penn Computing

University of Pennsylvania
Penn Computing << go backback

STUDENT_APS - Data Element Index . Tables and Data Elements . Student 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

 

Primary Key Indexed Data Elements Related Tables
SSN, APS_SEQUENCE

DIVISION,
DEGREE_AWARDED,
DEGREE_PURSUED,
SCHOOL, ENTRY_TERM, ENTRY_ACTION, EXIT_TERM, EXIT_ACTION, DEGREE_EXPECTED_TERM, GRADUATION_CHECKOUT_TERM, MAJOR, PENN_ID, APS_SEQUENCE,
SSN

PERSON_ALL_V, DEGREE_PURSUAL_ALL_V

Cautions

  • When joining to this table from DEGREE_PURSUAL, DEGREE_TERM, ASSIGNMENT, MAJOR_MINOR_TERM, LEAVE, or DEGREE_RECEIVED, it is advisable to join on DP_LINK_ID. See the Degree Pursual table for further explanation of DP_LINK_ID.
  • Do not use APS_SEQUENCE to determine the order of degrees. Instead, use the Degree Order column in DEGREE_TERM_ALL_V.
  • 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 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