Penn Computing

University of Pennsylvania
Penn Computing << go backback

STUDENT TERM Table . Tables and Data Elements . Student Data Home . Data Warehouse Home

STUDENT TERM Table - Data Element Index

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

RT200 GI CERT TYPE

NATURAL ALIAS: GI-CT-TP-RT

appears on SRS screen 119

The time status certification submitted to the Veteran's Administration for the student for this term.

Values:

[Null]   None
1        Full time
2        3/4 but not full time
3        1/2 time but not 3/4
4        Graduate student
5        Less than 1/2 time
6        1/4 time
7        2/3 time

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

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.

 

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