Penn Computing

University of Pennsylvania
Penn Computing << go backback

CEN STDT BIO Table . Tables and Data Elements . Student Data Home . Data Warehouse Home

CEN_STDT_BIO Table - Data Element Index

Academic_Eligibility Indicates whether the student is eligible to register for the current academic program for this term and in subsequent terms based on active registration holds. For example: Y, the student is eligible to register.

Values:

Y    Yes student is eligible to register
N    No, student is not eligible to register
YM   Yes, student is eligible to register (manual override)
NM   No, student is not eligible to register (manual override)
Birth_Date The student's date of birth.
Birth_Place The city, state, and country of student's birth. For example: Camden, NJ, USA. This data is not required and therefore may be incomplete.
Country_Of_Citizenship

The student's country of citizenship if other than the United States. Null and US means United States. For example: FJ (Fiji).

Values:

Refer to the COUNTRY table.

County_Of_Origin
The student's county of origin, for Pennsylvania residents only. For example: MTG (Montgomery County).

It is common for graduate students to indicate a Pennyslvania county of origin even if they are not Pennyslvania residents.

Values:

ADM    ADAMS
ALL     ALLEGHENY
ARM    ARMSTRONG
BEA    BEAVER
BED    BEDFORD
BER    BERKS
BLR    BLAIR
BRD    BRADFORD
BUC    BUCKS
BUT    BUTLER
CAM    CAMBRIA
CMR    CAMERON
CAR    CARBON
CEN    CENTRE
CHE    CHESTER
CLA    CLARION
CLF    CLEARFIELD
CLN    CLINTON
COL    COLUMBIA
CRW    CRAWFORD
CUM    CUMBERLAND
DAU    DAUPHIN
DEL    DELAWARE
ELK    ELK
ERI    ERIE
FAY    FAYETTE
FOR    FOREST
FRN    FRANKLIN
FUL    FULTON
GRN    GREENE
HUN    HUNTINGDON
IND    INDIANA
JEF    JEFFERSON
JUN    JUNIATA
LAC    LACKAWANNA
LAN    LANCASTER
LAW    LAWRENCE
LEB    LEBANON
LEH    LEHIGH
LUZ    LUZERNE
LYC    LYCOMING
MCK    MCKEAN
MER    MERCER
MIF    MIFFLIN
MON    MONROE
MTG    MONTGOMERY
MNT    MONTOUR
NAM    NORTHAMPTON
NUM    NORTHUMBERLAND
PER    PERRY
PHL    PHILADELPHIA
PIK    PIKE
POT    POTTER
SCH    SCHUYLKILL
SNY    SNYDER
SOM    SOMERSET
SUL    SULLIVAN
SUS    SUSQUEHANNA
TIO    TIOGA
UNI    UNION
VEN    VENANGO
WAR    WARREN
WAS    WASHINGTON
WAY    WAYNE
WES    WESTMORELAND
WYO    WYOMING
YRK    YORK

Deceased
Indicates student is deceased.

Values:

[Null]    Default (The student is alive at time of census date.)
Y         Deceased
Dissertation_Term_Count
Number of terms that student in a PHD academic program has been on dissertation status. The number ranges from 00 to 99. For example: 08, the student has been on dissertation status for 8 terms.

Values:

00     Default
Number from 00-99
Email_Address The student's electronic mail address as reported by the school of the student's primary academic program. For example: benfranklin@wharton.upenn.edu.
Final_Phd_Exam_Date

The date on which a PHD candidate passed the final PHD exam.
Fraternity_Sorority Indicates if a student is a member of a fraternity or sorority.

Values:

[Null]    None
ACA    ACACIA
ACO    ALPHA CHI OMEGA
ACR    ALPHA CHI RHO
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
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
KKG    KAPPA KAPPA GAMMA
KS     KAPPA SIGMA
LPE    LAMBDA PHI EPSILON
LUL    LAMBDA UPSILON LAMBDA
OPH    OMEGA PSI PHI
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
SAM    SIGMA ALPHA MU
SC     SIGMA CHI
SDT    SIGMA DELTA TAU
SK     SIGMA KAPPA SORORITY
SLU    SIGMA LAMBDA UPSILON
SN     SIGMA NU
SPE    SIGMA PHI EPSILON
SAE    SIGMA ALPHA EPSILON
TEP    TAU EPSILON PHI
TR     THETA RHO
TX     THETA XI
ZBT    ZETA BETA TAU
ZPB    ZETA PHI BETA
ZP     ZETA PSI
Marital_Status The student's marital status.

Values:

[null]     Unspecified
S          Single
M          Married
L          Legally separated
D          Divorced
W          Widowed
Native_Language Student's native language.

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
Preliminary_Phd_Exam_Date The date on which a PHD candidate passed the preliminary qualifying exam
Previous_Name Identifies a student's most recent previous name. This data element has a value when a student has had two or more name changes. For example: a student's name is changed from Jane Doe to Jane Smith to Jane D. Smith. Jane D. Smith is now stored in Name, Jane Doe is stored in Initial_Name, and Jane Smith is stored in Previous_Name.

The CEN_STDT_BIO Table can contain up to four names for a student: Name, Initial_Name, Previous_Name, and Long_Name. Name, Initial_Name, and Previous_Name help track over time changes to a student's name. This includes typographical corrections as well as actual name changes.

Name always stores the student's most recent name. If no changes are made to a student's name, Name remains as is and Initial_Name and Previous_Name are null.

If one or more changes are made to a student's name, Initial_Name will always contain the student's name as first entered into SRS. For example: a student's name is changed from Jane Doe to Jane Smith. Jane Smith is stored in Name and Jane Doe, the name first entered into SRS, will now be stored in Initial_Name.

See also Name in the CEN_STDT_BIO Table.

See also Initial_Name in the CEN_STDT_BIO Table.

See also Long_Name in the CEN_STDT_BIO Table.

Religion Identifies a student's religious preference or affiliation. For example: the student is affiliated with FR (Society of Friends).

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 WITNESSES
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      UKRANIAN CATHOLIC
UO      UKRANIAN ORTHODOX
UN      UNITARIAN
UC      UNITED CHURCH OF CHRIST
UM      UNITED METHODIST
UP      UNITED PRESBYTERIAN
ZA      ZOROASTRIAN RELIGION
OT      OTHER
Restrict_All_Addresses Indicates whether a student has restricted his or her address information from release to persons outside the University. These addresses are local, billing, and permanent. For example: null means the student has placed no restriction on releasing address information.

Values:

[Null]     The student has placed no restriction on this information.
Y          Restricted.  Do not release outside the University.
Restrict_Attend_Dates Indicates whether a student has restricted his or her dates of attendance at Penn from release to persons outside the University. For example: null means the student has placed no restriction on releasing dates of attendance.

Values:

[Null]     The student has placed no restriction on this information.
Y          Restricted.  Do not release outside the University.
Restrict_Awards

Indicates whether a student has restricted information about the awards he or she has received at Penn from release to persons outside the University. For example: null means the student has placed no restriction on releasing award information.

Values:

[Null]     The student has placed no restriction on this information.
Y          Restricted.  Do not release outside the University.
Restrict_Birthdate Indicates whether a student has restricted his or her birthdate from release to persons outside the University. For example: Y (Restricted), the student has placed a restriction on releasing his or her birthdate.

Values:

[Null]     The student has placed no restriction on this information.
Y          Restricted.  Do not release outside the University.
Restrict_Birthplace

Indicates whether a student has restricted his or her birth place from release to persons outside the University. For example: null means the student has placed no restriction on releasing birthplace.

Values:

[Null]     The student has placed no restriction on this information.
Y          Restricted.  Do not release outside the University.

Restrict_Degree
Indicates whether a student has restricted information about the degrees he or she has received at Penn from release to persons outside the University. For example: null means the student has placed no restriction on releasing degree information.

Values:

[Null]     The student has placed no restriction on this information.
Y          Restricted.  Do not release outside the University.
Restrict_Directory Indicates whether information about the student may be published in student directories. For example: null means the student has placed no restriction on publishing directory information.

Values:

[Null]     The student has placed no restriction on this information.
D          Do not publish directory information.
Restrict_Email_Address Indicates whether the student's electronic mail address may be published or released to persons outside the University. For example: Y (Restricted), the student has placed a restriction on publishing his or her electronic mail address.

Values:

[Null]     The student has placed no restriction on this information.
Y          Restricted.  Do not publish or distribute electronic mail
           information.

Restrict_Honors

Indicates whether a student has restricted the honors he or she has received at Penn from release to persons outside the University. For example: null means the student has placed no restriction on releasing his or her honors.

Values:

[Null]     The student has placed no restriction on this information.
Y          Restricted.  Do not release outside the University.
Restrict_Local_Address

Indicates whether a student has restricted his or her local address from release to persons outside the University. For example: Y (Restricted), the student has placed a restriction on releasing local address information.

Values:

[Null]     The student has placed no restriction on this information.
Y          Restricted.  Do not release outside the University.
Restrict_Major Indicates whether a student has restricted his or her major field of study from release to persons outside the University. For example: null means the student has placed no restriction on releasing information on his or her major.

Values:

[Null]     The student has placed no restriction on this information.
Y          Restricted.  Do not release outside the University.
Restrict_Name Indicates whether a student has notified the University to restrict his or her name from release to persons outside the University.

Values:

[Null]     The student has not notified the University to restrict his
           or her name.
Y          Yes, the student has notified the University to restrict his
           or her name from release to persons outside the University.
Restrict_Permanent_Address Indicates whether a student has notified the University to restrict his or her permanent address from release to persons outside the University.

Values:

[Null]     The student has not notified the University to restrict his
           or her permanent address.
Y          Yes, the student has notified the University to restrict his
           or her permanent address from release to persons outside the
           University.
Restrict_Phone

Indicates whether a student has notified the University to restrict his or her phone number from release to persons outside the University

Values:

[Null]     The student has not notified the University to restrict his
           or her phone number.
Y          Yes, the student has notified the University to restrict his
           or her phone number from release to persons outside the
           University.

Restrict_Previous_Institution
Indicates whether a student has notified the University to restrict the institutions he or she has previously attended from release to persons outside the University.

See also Previous_Institution in the CEN_STDT_BIO Table.

Values:

[Null]     The student has not notified the University to restrict
           information on previous institutions he or she has
           attended.
Y          Yes, the student has notified the University to restrict
           information on previous institutions he or she has attended
           from release to persons outside the University.
Restrict_Sports Indicates whether a student has notified the University to restrict the sports in which he or she has participated from release to persons outside of the University.

Values:

[Null]     The student has not notified the University to restrict his
           or her sports participation.
Y          Yes, the student has notified the University to restrict his
           or her sports participation from release to persons outside
           the University.
Restrict_Weight_Height_Athlete Indicates whether a student athlete has notified the University to restrict his or her height and/or weight from release to persons outside the University.

Values:

[Null]     The student has not notified the University to restrict his
           or her height and/or weight.
Y          Yes, the student has notified the University to restrict his
           or her height and/or weight from release to persons outside
           the University.
Sex The gender of the student. For example: M (Male).

Values:

[Null]     Not specified
F          Female
M          Male
Srs_Ethnicity

A student's most recently reported ethnic identification. For example: S (Hispanic).
Srs_Previous_Id This student's previous identification number. When a student receives a new student Id number, this data element 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 until the student becomes a resident alien and reports the Social Security Number assigned by the US government. If the student Id has never changed, this data element is null. This is a 9-digit numeric character without dashes, for example, 777777777
Ssn The student's Social Security number; currently used by Penn as the student's identification number. A Social Security number is a unique number assigned to an individual by the federal Social Security Administration. This is a 9-digit numeric character without dashes, for example, 777777777. For foreign students and students who have requested not to use their Social Security number, this number is assigned by Penn.
State_Of_Residency The state the student last reported as his or her state of residency. Originally obtained from the student's application, this data element may be updated by the student while enrolled at the University. This data element may be null. It is not necessarily the state indicated in the permanent address.
Term The term, as of the Census Date, for which this data is valid. Penn divides the academic year into 3 terms: Fall, Spring, and Summer. Terms are designated by the 4-digit calendar year, followed by a term code. The Spring term code is C, the Summer term code is B, and the Fall term code is C. For example: the information is valid for 1995C (the 1995 Fall term).
Title Salutation used in association with student mailings. If no salutation is specified but the student's gender is indicated in the Sex data element, then MR is assigned for males and MS for females. If Title is null and Sex data element is null, then no salutation is provided. Title is in uppercase letters with no periods. For example: MR or MS

See also Restrict_Name in the PERSON_ALL_V Table.

Veterans_Benefit_Expire_Date
The expiration date of the student's Veterans Benefits.

Date formats in the Warehouse depend on the query tool you are using (Business Objects, GQL, SAS, SQL*Plus) and/or the settings you have established for formatting dates on your computer. For example: dates in Business Objects with Windows 3.1 may be presented in the mmddyy format with a slash (/) separator, e.g. 5/31/96. To check date formats: Macintosh users: from the Apple menu, select "Control Panels" then choose "Date&Time". Windows users: select "Control Panel" then choose "International".

See also Veterans_Benefit_Type and Veterans_Eligibility_Status in the PERSON_ALL_V Table.

Veterans_Benefit_Type
The type of Veterans Benefit for which this student is eligible. For example: 30 (the student is eligible for Veterans Benefit Chapter 30).

See also Veterans_Eligibility_Status and Veterans_Benefit_Expire_Date in the PERSON_ALL_V Table.

Values:

[Null]    None
30        Chapter 30
31        Chapter 31
32        Chapter 32
34        Chapter 34
35        Chapter 35
R1        Chapter 106
S9        Chapter 903
Veterans_Eligibility_Status
Indicates the student's eligibility for Veterans Benefits. For example: VE (the student is a Veteran and is eligible for Veterans Benefits).

See also Veterans_Benefit_Type and Veterans_Benefit_Expire_Date in the PERSON_ALL_V Table.

Values:

[Null]    Non-Veteran
VN        VET Not Eligible For Benefits
VE        VET Eligible For Benefits
DP        Dependent Of Deceased War Vet
VR        Vocational Rehabilitation
Visa Type of visa held by the student. For example: the student's visa type is A1 (Diplomatic).

Values:

[Null]    None
A1        Diplomatic
E1        Treaty Trader and Dependents
E2        Treaty Investor and Dependents
F1        Student
J1        Exchange Visitor-Student
JX        Exchange Visitor-Scholar
PR        US Permanent Resident
OT        Other
 

CEN STDT BIO 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