Penn Computing

University of Pennsylvania
Penn Computing << go backback

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

MASTERS_THESIS - Data Element Index

Data element mapping back to SRS Definition
Masters_Final_Exam_Date

AA4FD AM/MS EXAM DATE

NATURAL ALIAS: AMMS-EX-DT-AA

appear on SRS screen 144

The date the AM/MS candidate passed the final exam.

See also Masters_Final_Exam_Date in the PHD_DISSERTATION table.

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.

Research_Req_Course_ID

AA46M AMMS RSRCH REQ COURS

NATURAL ALIAS: AMMS-RSRCHREQ-CRS-AA

appears on SRS screen 144

The Course ID of the course used to fulfill the AM/MS Research Requirement, if any.

Research_Req_Proj_Ind

AA46P AMMS RSRCH PROJECT

NATURAL ALIAS: AMMS-RSRCHREQ-PRJ-AA

appears on SRS screen 144

Indicates whether this AM/MS candidate must complete a Research Project requirement.

Values:

   - paper (default)
 Y - project       
Research_Req_Term
 

AA46O AMMS RSRCH REQ TERM

NATURAL ALIAS: AMMS-TRM-AA

appears on SRS screen 144

The term in which the AM/MS candidate completed the Research Requirement.
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.

Supervisor_Penn_ID n/a

The 8-digit identification number assigned to the employee 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.

Thesis_Title

AA53A DISSERTATION TITLE

NATURAL ALIAS: DISS-TITLE-AA

appears on SRS screen 144

The Masters Thesis Title for this AM/MS candidate.
Transcript_Print

AA492 DISSERTATION TRANS P

NATURAL ALIAS: DISS-TRANSCRPT-PRT-AA

appears on SRS screen 144

Indicates whether or not the thesis information can be printed on the transcript.

Values:

   - No, do not print to transcript
 Y - Yes, print to transcript

MASTERS_THESIS 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