Penn Computing

University of Pennsylvania
Penn Computing << go backback

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

TRANSCRIPT HONORS Table

(dwadmin.transcript_honors)

Explanation

This table contains one row per transcript honors per student, as entered on SRS screen 119.

Common Uses

  • Finding students in a specified category who are receiving honors that will appear on the transcript.
  • Investigation of the level of participation in the various honors programs.

Schema Name

DWADMIN

Primary Key Indexed Data Elements Related Tables

SSN

  DEGREE_PURSUAL_ALL_V

Cautions

  • Although Transcript Honors appears on a term-related screen in SRS, the term is an attribute, and not a file key. Students can receive multiple honors, not all of which are stored on every term record in SRS. The term indicates the first term in which their honors became effective.
  • This is a student data table, not a system decode table. Currently the data warehouse does not have a system decode table for transcript honors values. For the most current list of valid values, please consult the Student Records System, screen 119.
  • Students can only be awarded up to 2 transcript honors per term, but they can, over their degree pursual, be awarded more than two transcript honors. The data elements Transcript_Honors1 and Transcript_Honors2 in the DEGREE_PURSUAL table will only list the honors that appear in the last degree term for the student. To see all honors, and to see the free-form text entered on the SRS Transcript in the "Honors" section, you must use this TRANSCRIPT_HONORS table.

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