AM_MS_Exam_date

Discontinued Column:

This column contains data that was formerly entered onto SRS screen 137. Effective in 2003, that screen now is only used for undergraduate language requirement data. The date the AM/MS candidate passed the final exam, which now comes from SRS screen 144, can be found in the tables MASTERS_THESIS and also in PHD_DISSERTATION.

CG035 GRAD AP FLAG

NATURAL ALIAS: APP-GRD-CG

appears on SRS screen 352

A flag that indicates whether or not the student has applied for graduation. Note: this flag is only used by some Penn divisions.

 

Valid values:
NULL - no action entered
Y - YES, student has applied
N - NO, student has not applied

Career

AA630 DEFAULT CAREER

NATURAL ALIAS: CAREER-AA

appears on SRS screens 110, 117, 118. Used in the context line on screens 136, 142

The career associated with this degree. A career may be a portion, or it may be all of a student's academic history at the University of Pennsylvania. Generally, a career corresponds to that portion of a student's academic record that appears on a single transcript and is associated with the academic program in which the student is enrolled. A student may pursue several careers at the University, and each career will appear on a separate transcript. For example, a student who has completed an undergraduate career may come back later and pursue a degree as a Master's or PHD or professional level career.

Note that coursework can count toward multiple careers. For example, a student who is submatriculating can have courses that count towards both the U and the graduate career.

See explanation in the ASSIGNMENT table.

See also Restrict_Degree in the DEGREE_PURSUAL_ALL_V Table.

Values:

U0 - PRE-BACCALAUREATE
U  - UNDERGRADUATE
U2 - UNDERGRADUATE, SECOND DEGREE
UP - POST-BACCALAUREATE
SA - SENIOR ASSOCIATES
SS - SUMMER SESSIONS
CF - CERTIFICATE PROGRAM, FELS
MA - MASTER'S LEVEL, ANNENBERG
MB - MASTER'S LEVEL, CGS MBE DEGREE
MC - MASTER'S LEVEL, CGS MAL DEGREE
MD - MASTER'S LEVEL, CGS MCE DEGREE
MV - MASTER'S LEVEL, CGS MES DEGREE
MW - MASTER'S LEVEL, CGS MSG DEGREE
MX - MASTER'S LEVEL, CGS MAP DEGREE
ME - MASTER'S LEVEL, EDUCATION
MG - MASTER'S LEVEL, ARTS & SCIENCES MGA DEGREE
ML - MASTER'S LEVEL, SOCIAL POLICY & PRAC NONPROFIT LDRSHP
MM - MASTER'S LEVEL, ARTS & SCIENCES MMP DEGREE
MO - MASTER'S LEVEL, ARTS & SCIENCES MSO DEGREE
MI - MASTER'S LEVEL, ENGINEERING INFO TECHNOLOGY
MT - MASTER'S LEVEL, ENGINEERING BIOTECHNOLOGY
MS - MASTER'S LEVEL, ENGINEERING
MN - MASTER'S LEVEL, NURSING
MP - MASTER'S LEVEL, PHILOSOPHY
M2 - MASTER'S LEVEL, NURSING - 2ND MASTERS DEGREE
M3 - MASTER'S LEVEL, NURSING - 3RD MASTERS DEGREE
FA - MASTER'S LEVEL, FINE ARTS
FH - MASTER'S LEVEL, FINE ARTS, HARRISBURG
FN - POST-GRADUATE LEVEL, FINE ARTS
NC - POST-GRADUATE LEVEL, CGS
ND - POST-GRADUATE LEVEL, GRAD ARTS & SCI.
NM - POST-MASTER'S PROGRAM, NURSING
N2 - POST-MASTER'S PROGRAM, 2ND NURSING PROGRAM
N3 - POST-MASTER'S PROGRAM, 3RD NURSING PROGRAM
NW - NON-DEGREE PROGRAM, WHARTON GRADUATE
WG - MASTER'S LEVEL, WHARTON
GX - EXECUTIVE MSE PROGRAM
PG - PHD, GAS
PA - PHD, ANNENBERG 
PE - PHD, EDUCATION 
PS - PHD, ENGINEERING 
PF - PHD, FINE ARTS
PB - PHD, BIOMEDICAL
PN - PHD, NURSING 
PP - PHD, SOCIAL WORK
PW - PHD, WHARTON
PM - PHD/MD, WHILE IN ARTS & SCIENCES
PD - PHD/MD, WHILE IN SEAS
PV - PHD/VMD, WHILE IN ARTS & SCIENCES
DE - DOCTORATE, EDUCATION 
DN - DOCTORATE, NURSING 
SP - MASTER'S LEVEL, SOCIAL POLICY
SW - SOCIAL POLICY & PRACTICE
D  - DENTAL MEDICINE
L  - LAW
V  - VETERINARY MEDCINE
M  - MEDICINE
1  - DUAL DEGREE DSW/AM
2  - DUAL DEGREE MSN/AM
3  - DUAL DEGREE MSE/MBA
10 - JOINT DEGREE GAS/ASP
11 - JOINT DEGREE GAS/BMP
12 - JOINT DEGREE GAS/EDP
13 - JOINT DEGREE GAS/GEP
14 - JOINT DEGREE GAS/GFP
15 - JOINT DEGREE GAS/NUP
16 - JOINT DEGREE GAS/SWP
17 - JOINT DEGREE GAS/WHP
18 - JOINT DEGREE GAS/LWP
19 - JOINT DEGREE ASP/BMP
20 - JOINT DEGREE ASP/EDP
21 - JOINT DEGREE ASP/GEP
22 - JOINT DEGREE ASP/GFP
23 - JOINT DEGREE ASP/NUP
24 - JOINT DEGREE ASP/SWP
25 - JOINT DEGREE ASP/WHP
26 - JOINT DEGREE ASP/LWP
27 - JOINT DEGREE BMP/EDP
28 - JOINT DEGREE BMP/GEP
29 - JOINT DEGREE BMP/GFP
30 - JOINT DEGREE BMP/NUP
31 - JOINT DEGREE BMP/SWP
32 - JOINT DEGREE BMP/WHP
33 - JOINT DEGREE BMP/LWP
34 - JOINT DEGREE EDP/GEP
35 - JOINT DEGREE EDP/GFP
36 - JOINT DEGREE EDP/NUP
37 - JOINT DEGREE EDP/SWP
38 - JOINT DEGREE EDP/WHP
39 - JOINT DEGREE EDP/LWP
40 - JOINT DEGREE GEP/GFP
41 - JOINT DEGREE GEP/NUP
42 - JOINT DEGREE GEP/SWP
43 - JOINT DEGREE GEP/WHP
44 - JOINT DEGREE GEP/LWP
45 - JOINT DEGREE GFP/NUP
46 - JOINT DEGREE GFP/SWP
47 - JOINT DEGREE GFP/WHP
48 - JOINT DEGREE GFP/LWP
49 - JOINT DEGREE NUP/SWP
50 - JOINT DEGREE NUP/WHP
51 - JOINT DEGREE NUP/LWP
52 - JOINT DEGREE SWP/WHP
53 - JOINT DEGREE SWP/LWP
54 - JOINT DEGREE WHP/LWP

AA678 CAREER TRKNG FLAG

NATURAL ALIAS: AP-TRKG-FLG-AA

appears on SRS screen 110 as "AutoTRACK"

From the Academic Program Summary (APS), this flag determines whether or not to allow automatic career tracking for Masters-to-PhD and PhD-to-PhD careers. By default, coursework in research Masters degrees tracks to the transcripts of the PhD. Similarly for multiple PhD careers, the coursework can track to the same transcript. The autotracking is controlled by an internal SRS system table. For students who should not have their graduate careers track into each other, this flag can be set to 'N' in SRS, indicating an override to the autotracking. The flag is set on the "receiving" end, in other words, the flag means "do not track coursework from other careers into this career."

Values:

[null]- Track courses to the APS career (default)
N - Do not track courses to the APS career

Classification

AA636 CLASSIFICATION

NATURAL ALIAS: AP-CLASS-AA

appears on SRS screens 110, 117

Note that because this field is based on accumulation of credit, it does not necessarily reflect the student's year-in-school. A student who takes a heavier-than-normal load of courses, or who has many AP/transfer credits, may be classified in a higher "year" than their actual year-in-school.

Values:

[Null] Unkown  

PBA   Post-Bacclaureate (CGS) 
PRB   Pre-Baccalaureate (CGS) 
SA    Senior Associate
FR    Freshman 
SO    Sophomore 
JR    Junior 
SR    Senior 
ND    Undergraduate, non-degree 
G     Graduate 
GM    Graduate, master's candidate 
GC    Graduate, phd candidate 
P     Professional 
P1    Professional, first level 
P2    Professional, second level 
P3    Professional, third level 
P4    Professional, fourth level 
P5    Professional, fifth level 
P6    Professional, sexth level 
L1    Law, first year 
L1A   Law, first year (SECTION A) 
L1B   Law, first year (SECTION B) 
L2    Law, second year 
L3    Law, third year 

Cohort

AA675 APS COHORT FLAG

NATURAL ALIAS: COHORT-AA

appears on SRS screen 110

The Cohort flag provides a way (in addition to classification) for divisions to group students within an academic program.

Note that there is no standard definition for the use of any cohort value: the schools and divisions use this data element internally, and each has their own definition of what it means to them. For example, for the Nursing School, the values B, I, and F are used for the Accelerated Nursing program:
B = BSN/MSN (means they applied to both the BSN and MSN at the same time)
I = 2nd Degree (applied only to the BSN)
F = RN Return (have an RN, but not a BSN)
and C applies to Nursing submatriculants. However, these same values can mean something completely different to other schools.

- NO COHORT IDENTIFICATION
A - COHORT GROUP A
B - COHORT GROUP B
C - COHORT GROUP C
D - COHORT GROUP D
E - COHORT GROUP E
F - COHORT GROUP F
G - COHORT GROUP G
H - COHORT GROUP H
I - COHORT GROUP I
J - COHORT GROUP J
K - COHORT GROUP K
S - SCHOOL DISTRICT
X - NOT SCHOOL DISTRICT
1 - DINAR
2 - DOLLAR
3 - EURO
4 - PESO
5 - RAND
6 - RUPEE
7 - SHEKEL
8 - YEN
9 - YUAN

See also Stats_Credit_Type in the DEGREE_PURSUAL_ALL_V Table.

AA666 DEGREE AWARDED

NATURAL ALIAS: DEG-AWRD-AA

found on SRS screens 110, 117

The degree awarded by the University of Pennsylvania. The degree awarded may not be the one that was pursued. For example, a student pursuing a PHD may be awarded an AM instead, and they never continue on towards a PhD. In such cases, the AM will appear in this column once it has been awarded. This will only be true if the student received the masters and never continued on with any PhD work. In such cases, there is only one APS row in SRS.

Note that if the student received a masters along the way to a PhD, and intended to continue with the PhD, there usually are two separate APS records in SRS. The masters is usually put on one SRS record and the other is the continuation of the PhD. In such cases, the masters will not appear in the degree awarded column in the degree pursual table.

IMPORTANT NOTE: For a complete record of all degrees received by a student, consult the DEGREE_RECEIVED table.

See also Restrict_Degree in the DEGREE_PURSUAL_ALL_V Table.

AA661 DEG EXPECTED TERM

NATURAL ALIAS: DEG-EXPT-AA

appears on SRS screens 110, 117

The term in which the division or department responsible for this student expects this student to receive this degree. If the student is currently on leave of absence, this column may be null. If the student is no longer expected to receive the degree, this value may no longer be accurate.

See also Exit_Terrm in the DEGREE_PURSUAL_ALL_V Table. See also Restrict_Attend_Dates in the DEGREE_PURSUAL_ALL_V Table.

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.

RA250 DEG HONORS

NATURAL ALIAS: DG-HONR1-RA

appears on SRS screen 123

Graduation honors associated with this degree, for example, Cum Laude, Magna Cum Laude. Latin honors are system generated based on the GPA.

For other types of honors, see the table TRANSCRIPT_HONORS.

See also Restrict_Honors in the DEGREE_PURSUAL_ALL_V Table.

Values:

    - NO HONORS RECEIVED
  C - CUM LAUDE
  M - MAGNA CUM LAUDE
  S - SUMMA CUM LAUDE
  D - GRADUATION WITH DISTINCTION
  H - GRADUATION WITH HONORS
  O - ORDER OF THE COIF

RA251 DEG HONORS 2

NATURAL ALIAS: DG-HONR2-RA

appears on SRS screen 123

Graduation honors associated with this degree, for example, Cum Laude, Magna Cum Laude. Latin honors are system generated based on the GPA.

For other types of honors, see the table TRANSCRIPT_HONORS.

See also Degree_Honors1 in the DEGREE_PURSUAL_ALL_V Table. See also Restrict_Honors in the DEGREE_PURSUAL_ALL_V Table.

Values:

    - NO HONORS RECEIVED
  C - CUM LAUDE
  M - MAGNA CUM LAUDE
  S - SUMMA CUM LAUDE
  D - GRADUATION WITH DISTINCTION
  H - GRADUATION WITH HONORS
  O - ORDER OF THE COIF

AA615 LEVEL

NATURAL ALIAS: AP-LEVEL-AA

appears on SRS screen 110,

See also Restrict_Degree in the DEGREE_PURSUAL_ALL_V Table.

Values:

 U - UNDERGRADUATE
 M - MASTERS LEVEL
 D - DOCTORATE
 P - PROFESSIONAL

AA611 DEGREE

NATURAL ALIAS: AP-DEG-AA

appears on SRS screen 110

The degree that the student is pursuing. A student may pursue more than one degree at a time. A degree is an academic title pursued through a division of a school. For example, students can pursue a Bachelor of Arts degree through the division of The College of Arts and Sciences; students can pursue a PHD through the Graduate division of Arts and Sciences. Both divisions are within the same school, but the College does not grant PHDs and GAS does not grant BAs.

Students can pursue more than one degree at the same time. Such students will have a value in thier Dual_Degree_Type in the DEGREE_TERM_ALL_V table.

See also Division in the DEGREE_PURSUAL_ALL_V Table.

See also Restrict_Degree in the DEGREE_PURSUAL_ALL_V Table.

Values:

See DEGREE table

AA44B DISSERTATION TERMS
NATURAL ALIAS: DISS-TRM-AA

appears on SRS screen 103

The number of terms a student has been pursuing any PHD. A student must have been properly registered in a dissertation course in order for this count to be accurate.

See also Tot_Diss_Term_Count in the DEGREE_PURSUAL_ALL_V Table.

AA610 DIVISION

NATURAL ALIAS: AP-DIV-AA

appears on SRS screen 110

The division associated with this degree pursual for this student. A division is an administrative sub- unit of a school. Schools at Penn can be composed of one or more divisions. A division oversees students as they pursue degrees within that division.

Examples of Division code include CGS (College of General Studies), NUR (Nursing Undergraduate), GFP (School of Design Graduate)and GEX (Engineering and Applied Science Executive).

Divisions can be associated with more than one type of degree. For example, CGS grants BA and MLA degrees.

While students can pursue multiple degrees from the same division, students can only pursue one type of degree from the same division at the same time. For example, a student cannot pursue two masters degrees from GSE simultaneously.

Students can be matriculated into more than one division at the same time. Such students will have a value in thier Dual_Degree_Type in the DEGREE_TERM_ALL_V table.

See also Division in the DEGREE_TERM_ALL_V table.

Values:

Refer to the DIVISION Table for values.

calculated from Total Credits and Equivalent Credits, as appearing on SRS screen 118

See also Stats_Credit_Type in the DEGREE_PURSUAL_ALL_V Table.

See also Entry_Action in the DEGREE_PURSUAL_ALL_V Table.

Values:

Any valid date (stored in Oracle date format DD-MMM-YY).

 AA642 ENTRY ACTION

NATURAL ALIAS: ENT-ACTN-AA

appears on SRS screen 110

See also the Leave_Action in the LEAVE Table. See also Return_Action in the HIATUS Table. See also Restrict_Attend_Datesin the DEGREE_PURSUAL_ALL_V Table.

Values:

AD     Regular Admit
AE     Admit - Exchange Student
AJ     ADMIT TO JOINT DEGREE PROGR
AS     Submatric Admit
AT     Transfer Admit
AV     Admit - Visiting Student
AX     Admit - External Submatric
DD     Admit to Dual Degree
RA     Readmitted
RI     Reinstated (for judicial suspensions only)
TR     Internal Transfer
DT     Degree Transfer within Division (used in the warehouse only*)

Note: RL is an entry action in SRS that you will not find in the DEGREE_PURSUAL_ALL_V table. To report on Leave of Absence and Returns from Leave, see the LEAVE table.

Note: DT is the exit action used in the warehouse when someone transfers to a different degree program within the same division without an actual exit of 'transfer'. In SRS, this shows up as just one Academic Program Summary with the latest degree program, but at the term level there are different degrees in different terms -- all under the same Academic Program Summary. When the data are extracted to the warehouse, because of the relational structure that joins a degree pursual to a degree term, the first degree-related data would be "orphaned" from it's corresponding degree pursual. So, in the warehouse, we scrub the data and give the first degree program an exit of DT and open the second with an entry of DT. See also Exit_Action.

Note: the entry action of CP, Continuing PhD Student, will not be displayed in DEGREE_PURSUAL_ALL_V. This entry action is used for PhD students who received a Master's degree on the way to getting
the PhD, and because all PhD academic program activity is collapsed into one degree pursual in the warehouse, this is not considered a "new" entry into a program. CP does, however, appear in the census extract.
See the CEN_STDT_ACADEMIC_PROGRAM table..

 AA640 ENTRY TERM

NATURAL ALIAS: ENT-TERM-AA

appears on SRS screen 110

Penn divides the academic year into 3 terms or semesters: Fall, Spring, and Summer. Terms are designated by the 4-digit calendaryear, followed by a term code. The Spring term code is A, the Summer term code is B, and the Fall term code is C.

See also Entry_Action in the DEGREE_PURSUAL_ALL_V Table. See also Restrict_Attend_Dates in the DEGREE_PURSUAL_ALL_V Table.

For example: 1995C means Fall 1995, 1996A means Spring 1996, 1996B means Summer 1996

 AA653 EXIT DATE

NATURAL ALIAS: EXIT-DAT-AA

appears on SRS screen 110

See also Exit_Action and Exit_Action_Reason in the DEGREE_PURSUAL_ALL_V Table. See also Restrict_Attend_Dates in the DEGREE_PURSUAL_ALL_V Table.

Values:

Any valid date (stored in Oracle date format DD-MMM-YY).

 AA652 EXIT REASON

NATURAL ALIAS: EXIT-RSN-AA

appears on SRS screen 110

See also Exit_Action in the DEGREE_PURSUAL_ALL_V Table.

Values:

[NULL]     None

AC         Academic
AI         Academic integrity
CU         Curricular
CR         Career/work related
DE         Deceased
EN         Environment, dislikes
FI         Financial
IA         INACTIVITY
MB         Misbehavior
MD         Medical
MS         Military service
NC         Non-correspondence
ND         No reason from division
NS         No reason from student
NL         Not returned from leave
PA         Per Admissions Office
PE         Personal
PG         Pending graduation
PR         No reason (conversion)
SA         Study abroad
SD         Study domestic
ST         Stress/motivational
TR         Travel
VE         Visa exportation

 AA651 EXIT ACTION

NATURAL ALIAS: EXIT-ACT-AA

appears on SRS screen 110

Related columns: Return_Action in the HIATUS Table, Leave_Action in the LEAVE Table.

Values:

NULL   - has not yet exited (see Cautions below about "EG" and leaves of absence)
AW     Withdrawn by Division
CA     Cancelled by admitting office
CP     Completed Certification Program     
DF     Deferred admissions
DR     Dropped by Division
DT     Degree Transfer within Division (used in the warehouse only!)
ED     Withdrew from Dual Degree Program
EP     End of program
FL     For Library access
JE     Judicial expulsion (on transcript)
JS     Judicial suspension (on transcript)
JX     Judicial suspension (not on transcript)
NS     No Show
PD     Dropped from program
PW     Withdrew from program
TR     Internal transfer
WD     Withdrew
WT     Withdrew to transfer
GD     Graduated
CD     Converted from old (pre SRS) student database: graduated

Exit Actions in SRS, that do not appear in DEGREE_PURSUAL_ALL_V:
AL, FL, LV, EG

CAUTIONS:

DT is an exit action used only in the Data Warehouse, and not in SRS. In SRS, when a student changes their degree pursual within the same division the APS does not close. The relational structure of the tables in the Warehouse makes it necessary to distinguish between the different degree pursuals, even when they are within the same division. See also Entry_Action.

SRS exit actions of LV, AL and FL do not appear on any record in DEGREE_PURSUAL_ALL_V; the exit remains null even when the student is on leave; the LEAVE_FLAG is changed to "Y".

There is no exit of EG (expected graduation) in the warehouse. Degree Pursual records of students who have not exited and have not yet graduated will have a null exit, instead of the SRS exit action of EG.

Exits of AL (administrative leave), FL (leave with Library access), LV (leave of absence) are not recorded in DEGREE_PURSUAL_ALL_V; students on any of these types of leave will have their Leave_Flag set to 'Y'. See the LEAVE table for details on student leaves of absence.

 AA650 EXIT TERM

NATURAL ALIAS: EXIT-TRM-AA

appears on SRS screen 110

The last term the student pursued this degree in this division. The value may be null if the student has not exited the degree program. A leave of absence is not considered an exit; students on leave will have a null Exit_Term. The value in Exit_Term will reflect the last term the student was actually active in the degree program (the last term that exists in the SRS term array for this program, regardless of whether there is registration activity in that term). It is not necessarily the exit term found on the SRS screen 110.

See also Exit_Action and Exit_Reason in the DEGREE_PURSUAL_ALL_V Table. See also Restrict_Attend_Dates in the DEGREE_PURSUAL_ALL_V Table.

For this degree program, the total credit awarded by Penn for this student's coursework completed at another institution.

See also Pre_Freshman_Credit, and Status_Credit_Type in the DEGREE_PURSUAL_ALL_V Table.

Discontinued Column:
This column contains data that was formerly entered onto SRS screen 137. Effective in 2003, that screen now is only used for undergraduate language requirement data. PHD candidacy exam data, which now comes from SRS screens 144 and 146, can now be found in the PHD_DISSERTATION table.

RP190 CUM GPA

NATURAL ALIAS: CUM-GPA-RP

appears on SRS screen 118

See also Grade_Points and Quality_Credit in the DEGREE_PURSUAL_ALL_V Table.

 RP130 CUM GRADE POINTS

NATURAL ALIAS: CUM-GPTS-R

appears on SRS screen 118

Grade points are calculated by multiplying the numeric grade equivalent and the Quality_Credit for an enrollment. This value is used in the calculation of the Gpa in the DEGREE_PURSUAL_ALL_V Table.

See also Grade_Point in the ENROLLMENT_ALL_V Table and Term_Grade_Points in the DEGREE_TERM_ALL_V Table.

Values:

[Null]  Not applied 

1       Paid diploma fee 
2       Applied for graduation 
3       Paid diploma fee & applied for graduation 
4       Cleared academically not financially 
5       Cleared for graduation 
A       Applied for degree audit 
C       Degree audit completed 

 AA662 DEG CHECKOUT TERM

NATURAL ALIAS: DEG-CHCK-AA

appears on SRS screens 110, 117

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 DEGREE_PURSUAL_ALL_V Table.

Internal_Transfer_Credit

See also Stats_Credit_Type in the DEGREE_PURSUAL_ALL_V Table.

Values:

Any valid date (stored in Oracle date format DD-MMM-YY). Note: Business Objects users may use the format MM/DD/YYYY in the query panel to look for dates.

See also the DEGREE_TERM Table. See also Restrict_Attend_Dates in the DEGREE_PURSUAL_ALL_V Table.

Indicates whether the student is on leave for this term.

To report on a students leave history, see the LEAVE table.

See also Restrict_Attend_Dates in the DEGREE_TERM_ALL_V Table.

Values:

[null]      Not on leave
Y           On leave

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.

AA4FK LANGUGE CODE

Natural Alias: LANG-CD-AA

appears on SRS screen 137

A four letter code for the language for which the student has either passed the exam or has been waived from the requirement.

Prior to 2003 this column contained PhD Foreign Language information.

Effective in 2003, screen 137 now is only used for undergraduate language requirement data. PhD language requirement data, which now comes from SRS screen 144 , can be found in the GRADUATE_LANGUAGE table.

AA4FM LANGUAGE DATE

Natural Alias: LANG-DT-AA

appears on SRS screen 137

The date the student passed the foreign language exam for the language identified by the Foreign_Language_Code.

Prior to 2003 this column contained PhD Foreign Language completion date.

Effective in 2003, screen 137 now is only used for undergraduate language requirement data. PHD language requirement data, which now comes from SRS screen 144 , can be found in the GRADUATE_LANGUAGE table.

AA44F LANG TERMS EXEMPT

Natural Alias: FLAN-EXM-AA

appears on SRS screen 137

This column contains either a number or a 1-character code:

• the number of semesters waived (if any) of foreign language study for an Undergraduate Student as a result of taking the foreign language exemption exam, or
• a code for the reason the Foreign Language requirement is being waived for the Undergraduate Student.
  

Values:

- NONE SPECIFIED
1 - 1 SEMESTER WAIVED
2 - 2 SEMESTERS WAIVED
3 - 3 SEMESTERS WAIVED
4 - 4 SEMESTERS WAIVED
A - LANG REQ COMPLETE: AP CREDIT
P - LANG REQ COMPLETE: PASSED
W - LANG REQ COMPLETE: WAIVED
X - LANG REQ COMPLETE: EXEMPT

Prior to 2003 this column contained PhD language waiver information. Effective in 2003, screen 137 now is only used for undergraduate language requirement data. PHD language requirement data, which now comes from SRS screen 144 , can be found in the GRADUATE_LANGUAGE table.

PhD_Language2_Date

 RT240 FLAG, REPORT 06

NATURAL ALIAS: RPT-FLG6-RT

appears on SRS screen 119

Values:

Q - student "applied" to the pilot curriculum program, but did not get in.   
P - student is in the Pilot Curriculum program for the selected term.  
N - College student, who is not in the Pilot Curriculum program, nor did they apply.
X - non-College students (not eligible for Pilot Curriculum program).

Preliminary_Phd_Exam_Date

 AA643 PREVIOUS SCHOOL

NATURAL ALIAS: PRE-SCHL-AA

appears on SRS screen 110

The academic institution from which the student was admitted to this degree program. The Previous_Institution can be a high school, a college, or a university. The college or university may also bePenn, for which the ETS (Educational Testing Service) code is 2926.

Where possible, the Previous_Institution is based on the numeric ETS code. Penn assigns codes to some institutions which have no ETS value. Examples of Previous_Institutions are 0220650 (MiddlesexSchool), 0002098 (Cornell University), and 0101102 (Southwest MiamiHigh School).

See also Restrict_Previous_Institution in the DEGREE_PURSUAL_ALL_V Table.

Values:

Refer to the INSTITUTION Table for values.

 RP125 CUM QUALITY UNITS

NATURAL ALIAS: CUM-QPTS-RP

appears on SRS screen 118

 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 placed no restriction on this information.
Y          Restricted.  Do not release outside the University.

NATURAL ALIAS: RS-AD-DT-BIO

appears on SRS screen 11

Values:

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

 AA08N DEG AWARD RESTRICT

NATURAL ALIAS: RS-DG-AW-BIO

appears on SRS screen 11

Values:

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

NATURAL ALIAS: RS-AD-DT-BIO

appears on SRS screen 11

Indicates whether a student has notified the University to restrict his or her exit action from release to persons outside of the University.

Values:

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

 AA08P HONORS RESTRICT

NATURAL ALIAS: RS-HONRS-BIO

appears on SRS screen 11

Values:

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

 AA08R PREV INST RESTRICT

NATURAL ALIAS: RS-PR-IN-BIO

appears on SRS screen 11

Values:

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

 AA635 SCHOOL

NATURAL ALIAS: SCHOOL-AA

appears on SRS screen 110

The code for the school with which this degree pursual is associated. A school is an administrative unit in charge of academic departments, courses, and faculty.

Examples of SCHOOL codes include EG (Engineering and AppliedSciences), ED (Education) and LW (Law).

See also the APPROVED_ACADEMIC_PROGRAMS table.

Values:

Refer to the SCHOOL Table for values.

 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

Restricted column. 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.

RP115 CAREER CREDIT TYPE

NATURAL ALIAS: ST-CR-TY-RP

appears on SRS screen 118

Indicates whether the credits reflected in the statistics data elements in the DEGREE_PURSUAL_ALL_V Table are in Credit Units(CU), Course Units (CU), or Semester Hours (SH).

See also Credit_Type in the ENROLLMENT_ALL_V Table.

Values:

CU     Credit Units
CR     Course Units
SH     Semester Hours

 RP120 CUM UNITS EARNED

NATURAL ALIAS: CUM-UNIT-RP

appears on SRS screen 118

See also Credit_Type in the ENROLLMENT_ALL_V Table.

The number of terms a student has been pursuing any PHD, including terms the student was on Study Abroad. A student must have been properly registered in a dissertation course in order for this count to be accurate.

See also Dissertation_Term_Count in the DEGREE_PURSUAL_ALL_V Table.

RP175 CUM TRANSFER UNITS

NATURAL ALIAS: CUM-T-CR-RP

appears on SRS screen 118

See also Stats_Credit_Type in the DEGREE_PURSUAL_ALL_V Table.

 RT241 HONORS AWARDED 1

NATURAL ALIAS: HONORS-1-RT

appears on SRS screen 119

See also Restrict_Honors in the DEGREE_PURSUAL_ALL_V Table.

Values:

  - NO HONORS
B - BENJAMIN FRANKLIN SCHOLAR
D - DEAN'S SCHOLAR
M - MATTHEW CRYER HONOR SOCIETY
N - SIGMA THETA TAU - NURSING HONOR SOCIE
O - O.K.U. HONOR SOCIETY
P - PHI BETA KAPPA
S - BETA GAMMA SIGMA
T - TAU BETA PI
U - UNIVERSITY SCHOLAR
V - ROY AND DIANA VAGELOS SCIENCE SCHOLAR

 RT242 HONORS AWARDED 2

NATURAL ALIAS: HONORS-2-RT

appears on SRS screen 119

See also Restrict_Honors in the DEGREE_PURSUAL_ALL_V Table.

Values:

  - NO HONORS
B - BENJAMIN FRANKLIN SCHOLAR
D - DEAN'S SCHOLAR
M - MATTHEW CRYER HONOR SOCIETY
N - SIGMA THETA TAU - NURSING HONOR SOCIE
O - O.K.U. HONOR SOCIETY
P - PHI BETA KAPPA
S - BETA GAMMA SIGMA
T - TAU BETA PI
U - UNIVERSITY SCHOLAR
V - ROY AND DIANA VAGELOS SCIENCE SCHOLAR

Sums up any transfer credit equivalency, where the Institution Code is 105 (College Pre-Freshman Program), 106 (Nursing Pre-Freshman Program), 107 (Wharton Pre-Freshman Program), or108 (Engineering Pre-Freshman Program)

See also External_Transfer_Credit in DEGREE_PURSUAL_ALL_V, and also the INTERNAL_COURSE_EQUIV table.