| 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
|
|
| Current Penn_ID
|
This is found in the Business Objects universe STDTTERM. It is not in the underlying table. See the definition for Penn_ID for an explanation about the difference between Penn_ID and Current Penn_ID in Cen Stdt Bio. |
|
|
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:
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 |
| 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
|
| Penn_ID |
The unique 8-digit identification number assigned to the student, from the PennCommunity database.
The value in the Penn_ID column in CEN_STDT_BIO is the person's PennID at the time of the Census snapshot identified on the same row. The value in the person's "Current PennID" object in Business Objects is the person's Penn_ID as of the latest nightly load of data to the warehouse. For most students, the two columns will contain the same ID. If a student's Penn_ID changed, the "old" Penn_ID will remain in the snapshots. In these situations, the Current Penn_ID may be a useful reference, for looking up that student in other data collections.
Please report any duplicate records to either Data Administration, or the Office of the University Registrar. |
| 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
X Non Binary
|
| 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
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 Dependent of workder 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
|
