Penn Computing

University of Pennsylvania
Penn Computing << go backback

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

GRADUATE_TEACHING_TERM - Data Element Index

Data element mapping back to SRS Definition
Course_ID

AA45G TEACHING COURSE 1
or
AA45H TEACHING COURSE 2
or
AA45I TEACHING COURSE 3
or
AA45J TEACHING COURSE 4

NATURAL ALIAS: TEACHCRS1-AA through TEACHCRS1-AA

appears on SRS screen 144

The Course ID of the course taught by the graduate student, used to satisfy the Graduate Teaching Requirement.

 

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.

Term

 AA4F2 WAIVER TERM 1
or
AA4F4 WAIVER TERM 2
or
AA45D WAIVER TERM 3
or
AA45F WAIVER TERM 4

NATURAL ALIAS: TEACHTRM1-AA through TEACHTRM4-AA

appears on SRS screen 144

The term in which the graduate student taught the course, used to satisfy the Graduate Teaching Requirement.

GRADUATE_TEACHING_TERM 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