| Data Element |
mapping back to SRS |
Definition |
|
Admissions_Ethnicity
|
not currently used. |
Further defines student's ethnic identification; this
field comes from undergraduate Admissions, but is seldom populated.
see instead SRS_Ethnicity |
| Birth_Date |
AA035 STUDENT BIRTHDATE
NATURAL ALIAS: SBIRTH-BIO
appears on SRS screens 007, 103 |
The student's month, day, and year (including century)
of birth.
See also Restrict_Birthdate.
|
| Birth_Place |
AA037 BIRTHPLACE
NATURAL ALIAS: BRTH-PLC-BIO
appears on SRS screen 007 |
City, state and country of this student's birth. This field isoften null.
Data for this column is usually missing and when entered,
is not consistently formatted.
Examples of inconsistent formatting include: CITY comma
space STATE CITY comma STATE CITY comma COUNTRY CITY comma space COUNTRY
See also Restrict_Birthplace
|
|
Country_Of_Citizenship
|
AA060 CITIZENSHIP
NATURAL ALIAS: CITZSHP-BIO
appears on SRS screen 103 |
This student's country of citizenship. If this column is null and the
Visa column is also null, the student is assumed to be a US citizen.
See the PERSON_ALL_V
Table "Cautions" for more details. See also Country in the ADDRESS Table.
Values:
See COUNTRY table.
|
| Deceased |
AA082 DECEASED FLAG
NATURAL ALIAS: DCEAS-FL-BIO
appears on SRS screen 11 |
Indicates that this student is deceased. This column should always be
used to screen out records of deceased students in any query whose purpose
is to generate a mailing list.
Values:
[NULL] The student has not been reported as dead.
Y The student is dead.
|
| Email_Address |
AA15E LOCAL ADDR EMAIL
NATURAL ALIAS: LO-EMAIL-BIO
appears on SRS screens 003, 103 |
- The student's electronic mail address. This address
is not populated directly in the Student Records System. The system
of record for email addresses is the OnlineDirectory. Student email
addresses are fed to the directory by the various school email servers.
However, students may update their OnlineDirectory record themselves,
and can substitute their "preferred" contact email address to be something
other than their upenn.edu address.
Email_Address in the Data Warehouse comes from an extract from the OnlineDirectory.
See also Restrict_Email_Address |
| English_Terms_Waived |
AA44G ENG TERMS EXEMPT
NATURAL_ALIAS: ENGL-EXM-AA |
The number of semesters of English study waived for the undergraduate
student as a result of passing the English exemption exam. Values:
[NULL] None specified
1 1 semester waived
2 2 semesters waived
|
| First_Name |
derived from AA010 STUDENT NAME
NATURAL ALIAS: SNAME-BIO
appears on all student-related screens in SRS |
The student's first name. It is the first word of the student's name.
The system does not distinguish between a 2-word first name and a first
name
and a middle name. The name is in uppercase letters.
Example: For MARY ANN DOE, MARY is the first name; ANN
is the middle name.
See also Restrict_Name
|
| Fraternity_Sorority |
AA117 FRAT/SORORITY
NATURAL ALIAS: FRAT-SOR-BIO
appears on SRS screen 103 |
The fraternity or sorority to which the student belongs. This field is
null if the student does not participate in a fraternity or sorority.
Values:
ACA - ACACIA
ACO - ALPHA CHI OMEGA
ACR - ALPHA CHI RHO
ADF - ALPHA DELTA PHI/ADELPHIA SOC
ADP - ALPHA DELTA PI
AEP - ALPHA EPSILON PI
AKA - ALPHA KAPPA ALPHA
APH - ALPHA PHI
APA - ALPHA PHI ALPHA
APD - ALPHA PHI DELTA
ASP - ALPHA SIGMA PHI
ATO - ALPHA TAU OMEGA
BSR - BETA SIGMA RHO
BTP - BETA THETA PI
CO - CHI OMEGA
DDD - DELTA DELTA DELTA
DKE - DELTA KAPPA EPSILON
DP - DELTA PHI
DS - DELTA PSI
DSP - DELTA SIGMA PHI
DST - DELTA SIGMA THETA
DTD - DELTA TAU DELTA
DU - DELTA UPSILON
KAP - KAPPA ALPHA PSI
KAS - KAPPA ALPHA SOCIETY
KAT - KAPPA ALPHA THETA
KD - KAPPA DELTA
KDP - KAPPA DELTA PHI
KKG - KAPPA KAPPA GAMMA
KS - KAPPA SIGMA
LCA - LAMBDA CHI ALPHA
LPE - LAMBDA PHI EPSILON
LUL - LAMBDA UPSILON LAMBDA
LTA - LAMBDA THETA ALPHA
OPH - OMEGA PSI PHI
PBS - PHI BETA SIGMA
PDT - PHI DELTA THETA
PEP - PHI EPSILON PI
PGD - PHI GAMMA DELTA
PKP - PHI KAPPA PSI
PKS - PHI KAPPA SIGMA
PSK - PHI SIGMA KAPPA
PSS - PHI SIGMA SIGMA
PBP - PI BETA PHI SORORITY
PKA - PI KAPPA ALPHA
PKH - PI KAPPA PHI
PLP - PI LAMBDA PHI
PU - PSI UPSILON
SAE - SIGMA ALPHA EPSILON
SAM - SIGMA ALPHA MU
SBR - SIGMA BETA RHO
SC - SIGMA CHI
SDT - SIGMA DELTA TAU
SK - SIGMA KAPPA SORORITY
SLU - SIGMA LAMBDA UPSILON
SN - SIGMA NU
SPE - SIGMA PHI EPSILON
SP - SIGMA PI
SPZ - SIGMA PSI ZETA
TEP - TAU EPSILON PHI
TR - THETA RHO
TX - THETA XI
ZBT - ZETA BETA TAU
ZPB - ZETA PHI BETA
ZP - ZETA PSI
ZTA - ZETA TAU ALPHA |
| Language_Terms_Waived |
AA44F LANG TERMS EXEMPT
NATURAL ALIAS: FLAN-EXM-AA
appears on SRS screen 137 |
Undergraduate students only: The number of semesters
of foreign language study waived for the student as a result
of passing
the
foreign
language
exemption exam. For most students, this value is null.
Values:
[NULL] None specified
1 1 semester waived
2 2 semesters waived
3 3 semesters waived
4 4 semesters waived
|
| Last_Activity_Date |
n/a |
The date this record was downloaded via the SRS extract processand loaded
into the Warehouse. This information is stored in theWarehouse in date format.
|
| Last_Name |
derived from AA010 STUDENT NAME
NATURAL ALIAS: SNAME-BIO
appears on all student-related screens in SRS |
The student's last name. It is the last word of the student'sname
unless it is a recognized suffix. The name is in uppercaseletters.
Example: For JOHN H DOE JR, DOE is considered the last
name.
See also Restrict_Name
|
| Legal_Name |
AA985 LEGAL NAME
appears on SRS screen 199 |
The legal name of the student. May only be changed at the request of the student
and only when appropriate documentation is presented to the Office of the University Registrar.
See also Restrict_Name
|
| Long_Name |
AA012 NAME,LONG
NATURAL ALIAS: NM-LONG-BIO
appears on SRS screens 007, 352 |
The name printed on official documents for students. This fieldmay be
null. It is entered independently from the other name fieldsand may therefore
have differences. It may be a mixture of upperand lower case letters.
The format is as follows: First Name space Middle Name
orInitial space Last Name space Suffix (if entered). Example: John H.Doe.
See also Restrict_Name
|
| Marital_Status |
AA045 MARITAL STATUS
NATURAL ALIAS: SMARITL-BIO
appears on SRS screens 007, 103 |
Marital status of the student.
Values:
[Null] Not specified
D Divorced
L Legally separated
M Married
S Single
W Widowed
|
| Middle_Name |
derived from AA010 STUDENT NAME
NATURAL ALIAS: SNAME-BIO
appears on all student-related screens in SRS |
The student's middle name. It is the second word of the student's name.
The system does not distinguish between a 2-word first name and a first
name and a middle name. Sometimes, the student's middle name is only an
initial with no period. The name, as with all character data from SRS, is
in uppercase letters.
Example: For MARY ANN DOE, MARY is the first name; ANN
is the middle name For MARY A DOE, MARY is the first name; A is the middle
initial with no period
See also Restrict_Name
|
| Name |
AA010 STUDENT NAME
NATURAL ALIAS: SNAME-BIO
appears on all student-related screens in SRS |
The full name of this student. The name is in uppercase letters.
The name is in the following format. There is no space between the comma
and the first name. LAST_NAME space (SUFFIX if exists) comma FIRST_NAME
space MIDDLE_NAME Example: SMITH JR,JOHNJOSEPH
See also Restrict_Name and Previous_Name
|
| Native_Language |
AA097 NATIVE LANG
NATURAL ALIAS: NAT-LANG-BIO
appears on SRS screen 103 |
The student's native language. May be null.
Values:
101 - AFRIKAANS
104 - AKAN
107 - AMHARIC
501 - ARABIC
401 - ARMENIAN
301 - ASSAMESE
304 - BALUCHI
110 - BAMBARA
404 - BASQUE(EUSKARA)
305 - BENGALI
113 - BERBER
407 - BULGARIAN
307 - BURMESE
310 - CAMBODIAN
410 - CATALAN
312 - CEBUANO
315 - CHINESE
413 - CZECH
416 - DANISH
419 - DUTCH
116 - EFIK
422 - ENGLISH
425 - ESTONIAN
119 - EWE
504 - FARSI(PERSIAN)
601 - FIJIAN
428 - FINNISH
431 - FLEMISH
434 - FRENCH
122 - FULANI(FULA)
125 - GA
127 - GALLA(GALLINYA)
130 - GANDA
437 - GERMAN
318 - GONDI
440 - GREEK
201 - GUARANI
320 - GUJARATI
133 - HAUSA
507 - HEBREW
323 - HINDI
443 - HUNGARIAN
136 - IBO
447 - ICELANDIC
326 - ILOCANO(ILOKO)
328 - INDONESIAN
450 - ITALIAN
331 - JAPANESE
332 - JAVANESE
335 - KANNADA(KANARESE)
338 - KASHMIRI
139 - KIKONGO
142 - KIKUYU
340 - KOREAN
604 - KUSAIEAN
343 - LOA
145 - LINGALA
453 - LITHUANIAN
148 - LUBA-LULUA
151 - LUGANDA
153 - LUO
156 - MALAGASY
345 - MALAY(BAHASA)
346 - MALAYALAM
159 - MALINKE(MANDINGO)
348 - MARATHI
607 - MARSHALLESE
162 - MENDE
351 - NEPALI
456 - NORWEGIAN
353 - ORIYA
610 - PALAUAN
459 - POLISH
613 - PONAPEAN
461 - PORTUGUESE
355 - PUNJABI
357 - PUSHTU
464 - ROMANIAN
467 - RUSSIAN
616 - SAMOAN
165 - SEPEDI
470 - SERBO-CROATIAN
167 - SETSWANA
170 - SHONA
360 - SINDHI
361 - SINHALESE
473 - SLOVAK
475 - SLOVENE
173 - SOMALI
478 - SPANISH
364 - SUNDANESE
176 - SWAHILI
481 - SWEDISH
367 - TAGALOG
619 - TAHITIAN
370 - TAMIL
373 - TELUGU
376 - THAI
379 - TIBETAN
179 - TIGRINYA
622 - TONGAN
625 - TRUKESE
382 - TULU
484 - TURKISH
182 - TWI-FANTI
487 - UKRAINIAN
628 - ULITHIAN
385 - URDU
388 - VIETNAMESE
391 - VISAYAN
185 - WOLOF
631 - YAPESE
188 - YORUBA
191 - ZULU
|
| Non_Resident_Alien |
derived from values in Country_of_Citizenship and Visa |
Indicates whether the student is neither a citizen nor
apermanent resident.
Values:
[Null] Student is not a non-resident alien.
Y Student is a non-resident alien.
|
| Owner |
n/a |
Data element definition to be supplied when available. |
| 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.
|
|
Pennkey |
data element not sourced from SRS
|
The Pennkey username used by students and alumni to authenticate to Penn's online systems. The Pennkey is selected by or assigned to the student via the Penn Community system. |
| Previous_Name |
AA015 PREVIOUS NAME
NATURAL ALIAS: NM-PREV-BIO
appears on SRS screens 007, 103 |
For students who have
had more than one previous name, this is the most recent name. It will
be
null if the student has not changed names more than once.
The name is in
uppercase letters. There is no space between the comma
and the first name. LAST_NAME space (SUFFIX if exists)comma FIRST_NAME
space MIDDLE_NAME Example: SMITH JR,JOHN JOSEPH
See also Name and Restrict_Name
|
| Religion |
AA055 RELIGION
NATURAL ALIAS: RELIGION-BIO
appears on SRS screen 103 |
This student's religious affiliation. It is a self-reported and non-required
field.
Values:
[NULL] Unspecified
AG Agnostic
AS Assemblies of God
AT Atheist
BH Bahai
BP Baptist
BU Buddhist
CS Christian Science
CC Church of Christ
CG Church of God
CF Confucianism
DC Disciples of Christ
EO Eastern Orthodox
EP Episcopalian/Anglican
ET Ethical Culture Society
GC Greek Catholic
GO Greek Orthodox
HI Hindu
JW Jehovah's Witness
JU Judaism
LS Latter Day Saints
LU Lutheran
MN Mennonite
MU Muslim
MR Moravian
PE Pentecostal
PR Protestant
RC Roman Catholic
RO Russian Orthodox
SO Serbian Orthodox
SA Seventh Day Adventist
FR Society of Friends
SB Southern Baptist
SY Syrian Orthodox
UK Ukrainian Catholic
UO Ukrainian Orthodox
UN Unitarian
UC United Church of Christ
UM United Methodist
UO United Presbyterian
ZA Zoroastrian Religion
OT Other
|
| Restrict_Birthdate |
AA08E BIRTH DATE RESTRICT
NATURAL ALIAS: RS-BDATE-BIO
appears on SRS screen 11 |
Indicates whether a student has notified the University torestrict his
or her date of birth from release to persons outsideof the University.
Values:
[Null] The student has not notified the University to restrict
his or her date of birth.
Y Yes, the student has notified the University to restrict
his or her date of birth from release outside of the
University.
|
| Restrict_Birthplace |
AA08F BIRTH PLACE RESTRICT
NATURAL ALIAS: RS-BPLCE-BIO
appears on SRS screen 11 |
Indicates whether a student has notified the University torestrict his
or her place of birth from release to persons outsideof the University.
Values:
[Null] The student has not notified the University to restrict
his or her place of birth.
Y Yes, the student has notified the University to restrict
his or her place of birth from release outside the
University.
|
| Restrict_Email_Address |
Populated from the OnlineDirectory, stored in SRS
in :
AA080 EMAIL ADDRESS RESTRI
NATURAL ALIAS: RS-EMAIL-BIO
appears on SRS screen 11 |
Based on current Directory rules, all student local and permanent addresses, email addresses, and phone numbers are restricted from being released outside of the University. Student contact information may be used internally for the purposes of conducting University business only.
|
| Restrict_Email_Address_Penn |
n/a
populated from the OnlineDirectory; not stored in SRS |
Based on current Directory rules, all student local and permanent addresses, email addresses, and phone numbers are restricted from being released outside of the University. Student contact information may be used internally for the purposes of conducting University business only.
|
| Restrict_Name |
Populated from the OnlineDirectory, stored in SRS
in :
AA08A NAME RESTRICT
NATURAL ALIAS: RS-NAME-BIO
appears on SRS screen 11 |
Indicates whether a student has notified the University
to restrict his or her name from release to persons outside of the University.
Values:
N - The student has placed no restriction on this information.
Y - Restricted. Do not include this data in your query unless it for use by someone with an official University affiliation.
If you see a student with a NULL in this column, it is because they are inactive and their restrict_name was not populated from the Online Directory.
|
| Restrict_Name_Penn |
n/a
populated from the OnlineDirectory; not stored in SRS
|
Indicates whether a student has notified the University
to restrict his or her name from release to anyone.
Values:
N - The student has placed no restriction on this information.
Y - Restricted. Do not include this data in your query unless it for use by someone with an official University affiliation, who needs it in order to do the business of the University.
|
| Sex |
AA040 SEX CODE
NATURAL ALIAS: SSEX-BIO
appears on SRS screens 007, 103 |
The sex of the student.
Values:
[Null] Not specified
F Female
M Male
X Non Binary
|
| Srs_Ethnicity |
AA050 ETHNIC ORIGIN
NATURAL ALIAS: SETHNIC-BIO
appears on SRS screen 007, 103 |
A student's most recently reported ethnic identification.
Values:
[Null] Not specified
A American Indian/Alaskan native. A person having origins
in any of the original peoples of North America and who
maintains cultural identification through tribal affiliation
or community recognition.
B Black, Non-Hispanic. A person having origins in any of the
black racial groups of Africa.
C White, Non-Hispanic. A person having origins in any of the
original peoples of Europe, North Africa, or the Middle East.
O Other
R Asian or Pacific Islander. A person having origins in any
of the original peoples of the Far East, South East Asia,
the Indian subcontinent or the Pacific Islands. This area
includes China, Japan, Korea, The Philippine Islands and Samoa.
S Hispanic. A person of Mexican, Puerto Rican, Cuban, Central
or South American or other Spanish culture or origin,
regardless of race.
Z Multiple/mixed ethnicity.
|
| Srs_Previous_Id |
AA031 PREVIOUS SID
NATURAL ALIAS: SID2-BIO
appears on SRS screens 007, 103 |
This student's previous identification number. When a student receives
a new student ID number, this field contains the old ID number. For international
students, this ID may be assigned by the Office of the Registrar or the
Records Office of the student's school unless the student reports a Social
Security
Number assigned by the US government on becoming a resident alien. If the
student ID has never changed, this field is null. If the student ID
changes more than once, this field contains only the previous one; there is no
archive of multiple student ID changes.
The format is 9 digits with no hyphens. Example: 097242579
|
| 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. |
| State_Of_Residency |
AA065 STATE OF RESIDENCY
NATURAL ALIAS: SSTATE-BIO
appears on SRS 103 |
The state in which the student last reported his or her residency. Originally
obtained from the student's application, this field may be updated by the
student while enrolled at the University. This field may be null. It is
not necessarily the state from the permanent address. |
| Suffix |
derived from AA010 STUDENT NAME
NATURAL ALIAS: SNAME-BIO
appears on all student-related screens in SRS
|
A modifier added to the end of the student's name. The suffixis in uppercase
letters.
Example: For JOHN H DOE JR, JR is considered the suffix.
See also Restrict_Name
|
| Title |
AA027 STUDENT TITLE
NATURAL ALIAS: STITLE-BIO
appears on SRS screen 103 |
Salutation used in association with student mailings. This
field is never null. That is, if a salutation has not been specified,
MR is assigned
for males and MS for females. Title is inuppercase letters with no periods.
See also Restrict_Name
-
Values:
[Null] None specified
ADM Admiral
BISH Bishop
BGEN Bri Gen
BR Brother
CAPT Captain
COL Colonel
CMDR Commndr
DRS Doctors
DR Doctor
DMRS Doctor and Mrs.
FR Father
GEN General
HNMR Hon. and Mr.
HON Honrble
LTC Lt. Col.
LT Lieutenant
MAJ Major
MISS Miss
MSGR Monsgr
MRDR Mr. and Dr.
MR Mr.
MMRS Mr. and Mrs.
MRS Mrs.
MS Ms.
PAST Pastor
PROF Prof.
RAB Rabbi
REV Rev.
RVMS Rev. and Mrs.
SEN Senator
SHK Sheik
SIR Sir
SR Sister
|
| Veterans_Benefit_Expire_Date |
AA113 VET BEN EXP DATE
NATURAL ALIAS: VB-EX-DT-BIO
appears on SRS screen 008 |
The expiration date of the student's Veterans Benefits.
See also Veterans_Benefit_Type and Veterans_Eligibility_Status
|
| Veterans_Benefit_Type |
AA111 VETERAN BENEFIT
NATURAL ALIAS: VET-BENE-BIO
appears on SRS screen 008 |
NOTE: this is historical information only. As-of Spring 2019, this is now in the STUDENT_TERM table, column MA_Benefit.
Values:
- none
06 - Chapter 1606 Reserve Educ Assist Pgm (REAP) -- previously Chap 1606
07 - Chapter 1607 Montgomery Bill Selected Reserve
30 - Chapter 30 Montgomery Bill Active Duty
31 - Chapter 31 Vocational Rehab Train Pgm
33 - Chapter 33
32 - Chapter 32 Veterans Educ Assist Pgm (VEAP)
34 - Chapter 34
35 - Chapter 35 Dependants Educ Assist Pgm
36 - Chapter 33 Yellow Ribbon
R1 - Chapter 106
S9 - Chapter 903
|
| Veterans_Eligibility_Status |
AA110 VETERAN CODE
NATURAL ALIAS: VET-CODE-BIO
appears on SRS screen 008 |
Indicates the student's eligibility for Veterans Benefits.
Values:
- none
VN - Vet not eligible for benefits
VE - Vet eligible for benefits
DP - Dependent of deceased war vet
VP - VETERAN BENEFITS PAID FROM VA
VR - Vocational Rehabilitation
See also Veterans_Benefit_Expire_Date
See also the Military Affiliate fields in the STUDENT_TERM table
|
| Veterans Claim Number |
AA112 VETERAN CLAIM NUM
NATURAL ALIAS: VET-C-NO-BIO
appears on SRS screen 008 |
The identifier assigned to a veteran by the Federal Veterans Administration.
|
| Visa |
AA090 VISA TYPE
NATURAL ALIAS: SVISA-BIO
appears on SRS screen 103 |
Type of visa held by the student, if they are not a US citizen. If this
column is null and the Country_of_citizenship column is also null, the
student is assumed to be a non-citizen Permanent Resident. See the PERSON_ALL_V
Table "Cautions" for more details.
Values:
- NONE
A1 - DIPLOMATIC
DA - DACA(DEFERRED ACTION-CHILD ARRIVAL)
E1 - TREATY TRADER AND DEPENDENTS
E2 - TREATY INVESTOR AND DEPENDENTS
E3 - TEMPORARY AUSTRALIAN WORKER
F1 - STUDENT
F2 - DEPENDENT OF STUDENT
H1 - TEMPORARY WORKER
H4 - DEPENDENT OF TEMPORARY WORKER
I9 - EMPLOYMENT ELIGIBILITY
J1 - EXCHANGE VISITOR-STUDENT
J2 - SPOUSE/CHILD OF J1
JX - EXCHANGE VISITOR-SCHOLAR
K3 - SPOUSE OF US CITIZEN
K4 - MINOR CHILD OF K3 ALIEN
NT - NATO
O1 - WORKER WITH EXTRAORD ABILITY
O3 - DEP OF WORKER WITH EXTRAORD ABILITY
PR - US PERMANENT RESIDENT
TN - NAFTA PROFESSIONAL
US - NOW US CITIZEN
V1 - PERMANENT RESIDENT SPOUSE
V2 - CHILD OF V1
V3 - CHILD OF V1 OR V2
OT - OTHER
|
