| Date_Completed |
AA4FG LANG1 EXAM DATE
or
AA4FJ LANG2 EXAM DATE
or
AA46S LANG3 EXAM DATE
or
AA46W LANG4 EXAM DATE
NATURAL ALIAS: LANG1-DT-AA through LANG4-DT-AA
appears on SRS screen 144 |
The date the student completed the Graduate Language requirement. Note, if the language requirement was waived, the Date Completed will be null.
|
| Language_Code |
AA4FE LANGUGE 1 PHD
or
AA4FH LANGUGE 2 PHD
or
AA46Q LANGUGE 3 PHD
or
AA46U LANGUGE 4 PHD
NATURAL ALIAS: LANG1-PHD-AA through LANG4-PHD-AA
appears on SRS screen 144 |
An alpha character code for the language the student studied to satistfy the Graduate Language Requirement.
See also Cert_Code and Cert_Desc in the lookup table LANGUAGE_CERTIFICATE.
|
| Language_Waived |
AA4FN LANGUGE CODE 1
or
AA4FO LANGUGE CODE
or
AA46T LANGUGE CODE 3 WAIVE
or
AA46X LANGUGE CODE 4 WAIVE
NATURAL ALIAS: LANG1-WVD-AA through LANG4-WVD-AA
appears on SRS screen 144 |
Indicates whether or not the Graduate Language Requirement was waived for this student.
Values:
- NONE SPECIFIED
Y - LANGUAGE REQUIREMENT WAIVED
|
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. |
