Penn Computing

University of Pennsylvania
Penn Computing << go backback

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

TRANSCRIPT HONORS - Data Element Index

 
Data element mapping back to SRS Definition
Career

AA630 DEFAULT CAREER

NATURAL ALIAS: CAREER-AA

part of the record key for all screens that show transcript information

For text entered in the "H" section of the transcript, this is the career associated with the transcript. A career may be a portion, or it may be all of a student's academic history at the University of Pennsylvania. Generally, a career corresponds to that portion of a student's academic record that appears on a single transcript and is associated with the academic program in which the student is enrolled. A student may pursue several careers at the University, and each career will appear on a separate transcript.

Rows with a value other than '*' in the Transcript_Honor column will have a null career in this table.

Last Activity Date n/a The date this record was downloaded via the SRS extract process and loaded into the Warehouse. This information is stored in the Warehouse in date format.
Penn_ID appears on SRS screen 103

The 8-digit identification number assigned to the student when their record was created in the PennCommunity database. No two persons have the same Penn_ID. Only persons affiliated with the University will be assigned a Penn_ID.

Penn_ID is not stored in SRS, but can be used on screen 103 to look up a student. It is populated in the Data Warehouse from a extract from PennCommunity.

Note that because the SSN is still the record key in SRS, it is possible for two records to accidentally get created in SRS with different SSNs, for the same person. When this happens, there will be two different records in the Data Warehouse with the same PennID. Please report all PennID duplicates to either Data Administration, or the Office of the University Registrar.

SSN

AA005 STUDENT ID

NATURAL_ALIAS: SID-AA

the record key for all student data in SRS; appears in the context line of all student-related screens

For students who are United States citizens or permanent residents, the Student ID number in SRS is generally the Social Security number of this student. A Social Security number is a unique number assigned to an individual by the federal Social Security Administration.

For foreign students and a few other exceptions, the value in this column may be a Penn-assigned ssn.

Note: Never release a student's Social Security number to anyone without the student's permission. Whenever possible, do not include SSN in your query results, and if you must do so, you do so with the full knowlege that you will be held responsibile for the careful maintenance of any datafiles, reports or other stored data containing SSNs.

Please see http://www.upenn.edu/privacy/ for more about the University's policies and general cautions regarding the use of SSNs.

Start_Term

RT005 STF TERM CODE

NATURAL ALIAS: TERM-RT

The first term that the transcript honor appears on the student's record in the student term file in SRS. Transcript Honors will roll from term to term, unless they are deleted or replaced by other honors.

Transcript_Honor

RT241 HONORS AWARDED 1,
NATURAL ALIAS: HONORS-1-RT
or
RT242 HONORS AWARDED 2,
NATURAL ALIAS: HONORS-2-RT

appears on SRS screen 119

OR

derived from comment in the "honors" section of the transcript (see RQ015_POSITION from SRS screen 124)

Honor awarded once during a student's career.

Values:

* - an asterisk indicates there is free form 
text for the honor awarded, as entered in the
"Honors" section of the SRS Transcript Text
fields. The text will appear in the
Transcript_Honor_Desc column for this record.
Values for trancript honors the come from the
SRS term record (screen 119): B - Benjamin Franklin Scholors D - Dean's Scholar M - Matthew Cryer Honor Society
N - Sigma Theta Tau O - O.K.U. Honor Society P - Phi Beta Kappa S - Beta Kappa Sigma
T - Tau Beta Pi U - University Scholar V - Valegos Science Scholar W - Joseph Wharton Scholar L - Lauder Reginald H Jones Thesis Prize
Transcript_Honor_Desc

Decode value for RT241 HONORS AWARDED 1,
NATURAL ALIAS: HONORS-1-RT
or
RT242 HONORS AWARDED 2,
NATURAL ALIAS: HONORS-2-RT

appears on SRS screen 119

OR

RQ110 TRANSCRIPT TEXT,
NATURAL_ALIAS: TEXT-RQ
when the position of the comment is in the "honors" (H) section of the transcript text (see RQ015_POSITION,
NATURAL ALIAS: POSITION-RQ )

appears on SRS screen 124

The long value for the transcript honor, or the text entered in the honors section of the transcript. For the latter, a value of "*" will appear in the Transcript_Honor column.


TRANSCRIPT_HONORS Table . 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