| Data element |
mapping back to SRS |
Definition |
|
Acad_Pgms_In_Residence
|
RT264 APR CODE
NATURAL_ALIAS: APR-CODE-RT
appears on SRS screen 119 |
Indicates the student's participation in an Academic Program in Residence
during this term. Used to determine student's eligibility for APR courses.
Reserved for the Office of Academic Programs in Residence, the flag in
SRS is updated by the Residence interface from the Room Assignment Process.
Values:
[Null] No APR program
A* - Arts house
B* - Butcher-Speakman
C* - Community house
D* - DuBois house
E* - East Asia house
H* - Harnwell house
I* - Hill house
K* - Kings Court
L* - Latin America house
M* - Modern language
N* - International house
S* - Spruce Street
T* - Stouffer
U* - Upper Quad
V* - Van Pelt
W* - Ware
Y* - Community service
AB - AL_BAYT AL-ARABI
AH - ART HOUSE
AL - ARTS AND LITERATURE ALLIANCE
BF - CONSCIOUSNESS IN BLACK FILM
BP - BIOSPHERE
CH - CASA HISPANICA
CI - CASA ITALIANA
CP - POLITICS AND CULTURAL PLURALISM
CR - CONFLICT RESOLUTION
CS - COMMUNITY SERVICE
DH - DEUTCHES HAUS
EA - EAST ASIA
EF*- EFFECTIVE
EN - ENTREPRENEURIAL MANAGEMENT
EP - EXPLORING PHILADELPHIA
FC - FILM CULTURE
FE - FRESHMAN EXPERIENCE
FL - FRESHMAN LEADERSHIP
FM - MEDICAL CARE & MEDICAL CHALLENGE
FR - FRANKLIN COMMUNITY
HF - HEALTH AND FITNESS
HL - HEALTHY LIVING
HP - HUNTSMAN
HS - HEALTH AND SOCIETY
HU - HUMANITIES
ID - INFECTIOUS DISEASES
IP - INTERNATIONAL
LA - LATIN AMERICA
LC - LIVING CULTURES
LD - LEADERSHIP
LS - LAW AND SOCIETY
MC - GOLDBERG MEDIA & COMMUNICATIONS
MF - MAISON FRANCAISE
ML - MODERN LANGUAGES
MP - MUSEUM
MU - MUSIC, PERFORMANCE AND COMPOSITION
RC - READER'S CORNER
RD - RUSKY DOM
SC - SCIENCE & DISEASE
SM - SPRUCE MENTORS
SP*- SPRUCE PROGRAMS
ST - SCIENCE AND TECHNOLOGY
VA - VISUAL ARTS
VP*- VAN PELT
WC - WORLD CINEMA
WS - WOMEN IN SCIENCE
WT - WOMEN IN LEADERSHIP ACROSS THE UNIVERSITY
|
| Academic_Status |
RT080 ACADEMIC STATUS
NATURAL ALIAS: ACA-ACT-RT
appears on SRS screen 111 |
A description of this student's academic standing for this term. Students
in good standing are making satisfactory progress toward the degree.
This column is used by the undergraduate divisions in the process of determining
Academic Probation.
Values:
[Null] (Good standing)
GS Good standing
PB General probation
IN Too many I/NR's
I2 I/NR Second letter
ML Mandatory leave of absence
DR Dropped
OK Reprieved from academic probation
DD Deferred drop
WR Warning
|
| Advisor_Signoff |
RT246 ADVISOR SIGNOFF
NATURAL ALIAS: ADV-SO-RT
appears on SRS screen 111 |
Indicates whether a student has obtained an academic advisor's signoff
for this term. School of Engineering and Applied Sciences divisions require
that their students obtain an academic
advisor's signoff before being allowed to register for courses.
Values:
[Null] Not specified
N No
Y Yes
|
| College House Code |
RT185 DORM CODE
NATURAL ALIAS: DORM-CD1-RT
appears on SRS screen 119 |
The code for the dorm or housing group to which the student was assigned. Note: this is not necessarily where the student lives; College House communities are comprised of students who live in those dorms and/or who are assigned to be a part of the community in those dorms, whether they live there or not.
Values:
(blank) - not assigned to a College House this term
COMM - Community House
DUBS - DuBois House
FSHS - Fisher Hassenfeld
GOLD - Goldberg House
GREG - Gregory House
HAML - Hamilton House
HARN - Harnwell House
HARS - Harrison House
HILL - Hill House
KCEH - Kngs Crt/Eng Hse
RIEP - Riepe College House
RODN - Rodin College House
SPRU* - Spruce House
SHER - Sheraton Hotel
STOU - Stouffer House
WARE - Ware House
WOOD* - Woodland House
|
| Deans_List |
RT075 DEAN'S LIST
NATURAL ALIAS: DNS-LST-RT
appears on SRS screen 111 |
Indicates whether this student is on the Dean's List for this term. This
is an academic honor that is only awarded to undergraduate students once
a year at the end of Spring term.
See also Restrict_Honors in the STUDENT_TERM Table.
Values:
Y Placed on dean's list by system
N Not on dean's list; system-maintained
YM Placed on dean's list by user
NM Not on dean's list; user-maintained
|
| Desired_Load |
RT045 DESIRED LOAD
NATURAL ALIAS: DES-LD-RT
appears on SRS screen 111 |
The number of credits the student wants to take this term. The default
value is determined by the student's division. There may exist maximum limits,
based on the student's classification or academic status. Desired load is
used by the Advanced Registration scheduling algorithm when processing students'
requests for enrollment. |
| Directors_List |
RT053 DIRECTORS LIST
NATURAL ALIAS: DIR-LST-RT
appears on SRS screen 111 |
Indicates whether this student is on the Director's List for this term.
This is an academic honor that is only awarded to Wharton graduate MBA students
each term.
See also Restrict_Honors in the STUDENT_TERM Table.
Values:
YM On director's list (manual)
NM Not on director's list (manual)
Y On director's list (system)
N Not on director's list (system)
|
| Dissertation_Masters |
RT263 DISST-MASTERS FLAG
NATURAL ALIAS: PGM-FLG6-RT
appears on SRS screen 111 |
Indicates that the student is registered for either dissertation or masters
thesis course in this term. Also sometimes referred to as "dissertation
status."
This is a system-generated field in SRS. The logic for populating this in SRS is:
If grade type is ‘DM’, and if course number is (990 or 899) and the current flag in not ‘D’, move ‘M’ to flag,
else move ‘D’ to flag.
See also Dissertation_Term_Count. Values:
[Null] Not on dissertation/thesis
D Dissertation
M Masters thesis
|
| Dissertation_Term_Count |
calculated |
The number of terms a student has been in PHD Dissertation Status (see
Dissertation_Masters), up to and including this term, excluding terms in
which they were on dissertation-Study
Abroad.
See also Dissertation Term Count in DEGREE_PURSUAL.
|
| Elig_To_Register |
calculated |
Indicates whether the student is currently eligible to register this term.
If one or more holds has been placed on the student, the student is not
eligible to register.
Values:
N No, the student is on hold - DO NOT REGISTER
Y Yes, the student is eligible to register
|
| Gi_Certification_Type |
|
see VA_Certification_Type
|
| Honors_Program |
RT236 HONORS PROGRAM
NATURAL ALIAS: HONS-PGM-RT
appears on SRS screen 119 |
Identifies the student as an honors student for this term. Used in evaluating
student eligibility for honors sections of courses.
Note that for some honors programs, the program indicator is entered into the first term in which that student has been awarded the honor, and the student remains in that program for all subsequent terms, even though the program indicator is not entered into subsequent terms. For example, if a student has an 'F' in their Honors Program in 2006C, they are considered a Fontaine Fellow from Fall 2006 going forward for the rest of their time at Penn. The 'F' indicator will only be entered in SRS for the first term; it will not appear in subsequent terms, but the student is still considered as being in this honors program. For this reason, it is not advisable to put a specific term into your query filters when looking for Fontaine Fellows. Similarly, you should not join to the Student Term table on term when looking for such programs. If you must filter on term for other reason, use a sub-query to find Fontaine Fellows in any term.
See also Restrict_Honors in the STUDENT_TERM Table.
Values:
[Null] No honors recorded for this term
B Benjamin Franklin Scholar
U University Scholar
X BFS and University Scholar
W Joseph Wharton Scholar
N Nursing Undergraduate Honors Program
Y BFS and NUHP
R RACHLEFF SCHOLARS
S RACHLEFF AND BENJAMIN FRANKLIN SCHOLAR
T RACHLEFF AND UNIVERSITY SCHOLAR
Z BFS, UNIV SCHOLAR, AND NUHP
F FONTAINE FELLOW
|
| Last_Activity_Date |
n/a |
The date this record was downloaded via the SRS extract process and loaded
into the Warehouse. This information is stored in the Warehouse in date
format. |
| Leave_Flag |
calculated |
Indicates whether this student is on leave for this term.
See also Restrict_Attend_Dates in the STUDENT_TERM Table.
Values:
[NULL] Not on leave
Y On leave
|
| Med_Classification |
RT205 MED CLASSIFICATION
NATURAL ALIAS: CLS-MED-RT
appears on SRS screen 111 |
The student's classification/year in a School of Medicine program,
based on accumulation of earned credit and/or status in a joint non_Med
program. Note that in SRS, this field is not associated with a particular
degree pursual, which is why it appears in the STUDENT_TERM table, and
not in the DEGREE_TERM table.
This
column will be null for students who are not in the Med School.
Values:
- NONE
X - NON-MEDICAL CURRICULUM
06 - FRESHMAN
07 - SOPHMORE
08 - JUNIOR
09 - SENIOR
10 - 5TH YEAR
11 - 6TH YEAR
12 - 7TH YEAR
13 - 8TH YEAR
14 - 9TH YEAR
15 - 10TH YEAR
See also Classification and Penn_Classification in the DEGREE_TERM table. |
| 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. |
| PhD_Term_Counter |
RT289 PHD TERM COUNTER
NATURAL ALIAS: PHD-TRM-CNT-RT
appears on SRS screen 111 |
Indicates the number of terms a student has been active as a PhD student;
used in the tuition calc program. PhD students are billed full tuition
for 10 terms, followed by reduced tuition for up to 10 terms.
The counter is incremented by 1 each
time a new term record is created, if the primary degree is PHD. Can
be manually modified in SRS, if the schools desire to override the system-calculated
counter. |
| Pre_Freshman_Status |
n/a |
Indicates the status of this student in the pre-freshmen program for this
term.
Values:
[Null] Not a participant
P Participant
C Control group
E Eligible, did not participate
|
|
Restrict_Attend_Dates
|
AA08L ATTEND DATE RESTRICT
NATURAL ALIAS: RS-AD-DT-BIO
appears on SRS screen 11 |
Indicates whether a student has notified the University to restrict his
or her dates of attendance at Penn from release to persons outside of the
University.
Values:
[Null] The student has not notified the University to restrict
his or her dates of attendance..
Y Yes, the student has notified the University to restrict
his or her dates of attendance from release outside of the
University.
|
| Restrict_Honors |
AA08P HONORS RESTRICT
NATURAL ALIAS: RS-HONRS-BIO
appears on SRS screen 11 |
Indicates whether a student has notified the University to restrict information
about the honors he or she has received from release to persons outside
of the University.
Values:
[Null] The student has not notified the University to restrict
information about honors.
Y Yes, the student has notified the University to restrict
information about the honors he or she has received from
release outside of the University.
|
| ROTC |
RT245 ROTC FLAG
NATURAL ALIAS: ROTC-FLG-RT
appears on SRS screen 119 |
Indicates the student's participation in Army or Navy Reserve Officer
Training Corps during this term.
Values:
[Null] Not specified
A Army ROTC program
N Navy ROTC program
|
| MA_Benefit (Military Affiliate Benefit) |
RT288 MA-BENEFIT
NATURAL ALIAS: MA-BENEFIT-RT
appears on SRS screen 119 |
The type of benefit for which a military-affiliated student is eligible this term.
Values:
06 - CHAPTER 1606 RESERVE EDUC ASSIST PGM
07 - CHAPTER 1607 MONTGOMERY BILL
30 - CHAPTER 30
31 - CHAPTER 31
32 - CHAPTER 32
33 - CHAPTER 33
34 - CHAPTER 34
35 - CHAPTER 35
36 - CHAPTER 33 YELLOW RIBBON
R1 - CHAPTER 106
S9 - CHAPTER 903
|
| MA_Election (Military Affiliate Election) |
RT291 MA-ELECTION
NATURAL ALIAS: MA-ELECTION-RT
appears on SRS screen 119 |
Students receiving military benefits must elect whether or not they want to use their benefits or not each term.
Values:
Y = 'Yes'
N = 'No'
|
| VA_Yellow_Ribbon_Used |
RT292 VA-YELLOW-FLAG
NATURAL ALIAS: VA-YELLOW-RIBBON-FLAG-RT
appears on SRS screen 119 |
Indicates whether a Veterans Administration Yellow Ribbon slot will be/has been granted to the student in the term.
Values:
Y = 'Yes'
N = 'No'
|
| VA_Certifiction_Type |
RT200 GI CERT TYPE
NATURAL ALIAS: GI-CT-TP-RT
appears on SRS screen 119 |
Code for the full-time/part-time status submitted to the Veterans Administration for the student this term. Values in this field a more detailed that the values found in other time status fields.
Values:
blank - NONE
1 - FULL TIME
2 - 3/4 BUT NOT FULL TIME
3 - HALF TIME BUT NOT 3/4
4 - GRADUATE STUDENT
5 - LESS THAN HALF TIME
|
| Special_Tuition_Rate |
RT170 SPECIAL TUITION RATE
NATURAL ALIAS: SPC-TUI-RT
appears on SRS screen 111 |
Code used to override the normal tuition calc: indicates the tuition
calculation used when generating the student's bill for this term.
Values:
[Null] NORMAL CALC
PT PART-TIME
Student is enrolled in a full-tuition
school but is to be charged by the
course rather than the full flat rate
NC NO CHARGE
Student is not liable for Penn tuition
or general fee; tuition calc will bypass
this student
FO GEN FEE ONLY
Med school only; student is to be
charged the general fee only
|
| 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. |
| Term |
RT005 STF TERM CODE
NATURAL ALIAS: TERM-RT
Term is part of the record key for all student term
data in SRS, and is found in the context line on many SRS screens
|
The term in which information about this student applies.
Penn divides the academic year into 3 terms or semesters: Fall, Spring,
and Summer. Terms are designated by the 4-digit calendar year, followed
by a term code. The Spring term code is A, the Summer term code is
B, and the Fall term code is C.
Example: 1995C means Fall 1995, 1996A means Spring 1996, 1996B means
Summer 1996
See also Restrict_Attend_Dates in the STUDENT_TERM Table.
|
