| 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
|
