Penn Computing

University of Pennsylvania
Penn Computing << go backback

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

PERSON_ALL_V - Data Element Index

 

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

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.

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

Indicates whether a student has notified the University to restrict his or her email address 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_email was not populated from the Online Directory.

Restrict_Email_Address_Penn

 n/a

populated from the OnlineDirectory; not stored in SRS

Indicates whether a student has notified the University to restrict his or her email address 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.

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

The type of Veterans Benefit for which this student iseligible.

Note that Chapter 106 (R1), is the old code for the current VA Chapter 1606 (06).

Values:

 - none
06 - Chapter 1606 Reserve Educ Assist Pgm (REAP) 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.

See also Veterans_Benefit_Type and Veterans_Benefit_Expire_Date

Values:

        - none
VN - Vet not eligible for benefits VE - Vet eligible for benefits DP - Dependent of deceased war vet VR - Vocational Rehabilitation
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

 

PERSON_ALL_V 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