| Data element |
mapping back to SRS |
Definition |
| Application_ID |
AA680 APPLICATION ID
NATURAL ALIAS: AP-APPL-ID-AA
apppears on SRS screen 110 |
The unique system identifier for this student in this program, in the Admissions system. Application _ID was introduced in the Fall of 2011; it will not appear on older records. Application_ID can be found on APS records that are created by the Admissions batch interface program; records created manually in SRS will not have an Application_ID. |
| Application_Source |
AA679 APPLICATION SOURCE
NATURAL ALIAS: AP-APPL-SRC-AA
appears on SRS screen 110 |
- The code for the source Admissions system that created the APS record. See also Application_ID.
Values:
null - record not created by a batch Admissions interface program
AY - record originated in the Apply Yourself graduate admissions program
|
| APS_Sequence |
appears on SRS screen 110 |
This is a field internal to SRS; along with the SSN it is used to identify a unique row. It does not designate the program order (Primary, Secondary, etc.), and should not be used to prioritize APS rows. |
|
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
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
|
| Career Tracking Flag |
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 |
The student's classification in this program. For undergraduates, classification
is system-maintained, based on accumulation of earned credit; for graduate
and professional students, it is maintained by the student's division.
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
|
| Degree_Awarded |
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 and then either withdraw from the PHD, or continue
pursuit of the PHD. In such cases, the AM will appear in this column
once it
has
been
awarded.
Note, however, that if the student subsequently successfully completes
and is awarded a PHD, the PHD will over-write the AM in this column.
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.
|
| Degree_Expected_Term |
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.
|
| Degree_Level |
AA615 LEVEL
NATURAL ALIAS: AP-LEVEL-AA
appears on SRS screen 110, |
The academic level of the degree sought by the student. Degree_Level is
used to group degrees across the University.
See also Restrict_Degree in the DEGREE_PURSUAL_ALL_V Table.
Values:
U - UNDERGRADUATE
M - MASTERS LEVEL
D - DOCTORATE
P - PROFESSIONAL
|
| Degree_Pursued |
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
|
| Division |
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.
|
| DP_LINK_ID |
system-generated number |
This is the Primary key for DEGREE_PURSUAL_ALL_V, but it is not the Primary Key for the STUDENT_APS table. Multiple rows in the STUDENT_APS table can share the same DP_LINK_ID.
An internal index column,
DP_LINK_ID is used to join the related term records back to the appropriate degree pursual.
It is re-generated each time a student's records are refreshed from SRS,
and the old value over-written. See also DP_LINK_ID in the DEGREE_PURSUAL, DEGREE_TERM,
DEGREE_RECEIVED, MAJOR_MINOR_TERM, ASSIGNMENT, HIATUS, and INTERNAL_COURSE_EQUIV
tables. |
| Entry_Action |
AA642 ENTRY ACTION
NATURAL ALIAS: ENT-ACTN-AA
appears on SRS screen 110 |
Indicates the type of action that caused this Degree_Pursual to be opened
for this student. In some cases, RA (Readmit) and RI(Reinstate) may appear.
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
CP Continuing PhD Student
DD Admit to Dual Degree
RA Readmitted
R1 Returning from a D1 exit
RI Reinstated (for judicial suspensions only)
RL Return from Leave
RX Return to study
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..
|
| Entry_Term |
AA640 ENTRY TERM
NATURAL ALIAS: ENT-TERM-AA
appears on SRS screen 110 |
The term the student first enrolled in classes for this division and degree.
This may not be the student's first term at Penn.
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
|
| Exit_Action_Date |
AA653 EXIT DATE
NATURAL ALIAS: EXIT-DAT-AA
appears on SRS screen 110 |
The date of the action that concludes this Degree_Pursual for this student.
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).
|
| Exit_Action_Reason |
AA652 EXIT REASON
NATURAL ALIAS: EXIT-RSN-AA
appears on SRS screen 110 |
The code for the reason given for the exit_action that concludes this
Degree_Pursual for this student. Not every exit action has a reason.
For example, the Exit_Action "GD" (graduation) does not have any corresponding
reason.
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
|
| Exit_Action |
AA651 EXIT ACTION
NATURAL ALIAS: EXIT-ACT-AA
appears on SRS screen 110 |
The action that concludes this Degree Pursual for this student.
Values:
AL Administrative Leave
AW Withdrawn by Division
CA Cancelled by admitting office
CP Completed Certification Program
DF Deferred admissions
D1 First Drop
DR Dropped by Division
ED Withdrew from Dual Degree Program
EG Expected graduation
EP End of program
FL For Library access
JE Judicial expulsion (on transcript)
JS Judicial suspension (on transcript)
JX Judicial suspension (not on transcript)
LV Leave of absence
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
Note that not all of the above exit actions that appear in the Student_APS table are used in the Degree_Pursual table. See the Degree_Pursual table cautions. |
| Exit_Term |
AA650 EXIT TERM
NATURAL ALIAS: EXIT-TRM-AA
appears on SRS screen 110 |
The last term the student pursued this degree program in this division.
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.
|
| Expected_Return_Term |
AA655 TERM RETURN EXPECTED
NATURAL ALIAS: EXP-RETN-AA
appears on SRS screen 110 |
The student's term of expected return from an academic program that terminated with the expectation that the student would return. Generally only used with Leaves of Absence. |
| Extract_Date |
system generated |
The last date this record was extracted from SRS.
|
| Final_Exit_Action |
AA671 FINAL ACTION
NATURAL ALIAS: FIN-ACTN-AA
appears on SRS screen 110 |
A second exit action taken after a leave of absence taken from a specific Academic Program. For example, a student on leave of absence may be allowed to withdraw without returning from leave.
Note: in the Student Records System, if "Graduation" is entered as the final exit action in SRS, that action is automatically switched to the Exit_Action, and the action formerly in the exit is moved to the Final_Exit_Action. When looking for exit = GD, use the Exit_Action column.
Note: Unlike the Degree Pursual table, exits of LV and EG will appear in this table. See the Table definition.
Values:
AL - ADMINISTRATIVE LEAVE OF ABSENCE
AW - WITHDRAWN BY DIVISION
CA - CANCELLED BY ADMITTING OFFICE
CP - COMPLETED CERTIFICATION PROGRAM
DF - DEFERRED ADMISSION
D1 - 1st drop
DR - DROPPED BY DIVISION
ED - WITHDREW FROM DUAL/JOINT DEGREE PROGRAM
EG - EXPECTED GRADUATION
EP - END OF PROGRAM
FL - FAMILY LEAVE/LIBRAY ACCESS
JE - JUDICIAL EXPULSION (ON TRANS)
JS - JUDICIAL SUSP (ON TRANS)
JX - JUDICIAL SUSP (NO TRANS)
LV - LEAVE OF ABSENCE
NS - NO SHOW
PD - DROPPED FROM PROGRAM
PW - WITHDREW FROM PROGRAM
TR - INTERNAL TRANSFER
WD - WITHDREW
WT - WITHDREW TO TRANSFER
GD*- GRADUATION
CD*- GRADUATION (CONVERSION)
|
| Final_Exit_Date |
AA673 FINAL DATE
NATURAL ALIAS: FIN-DATE-AA
appears on SRS screen 110 |
The effective date of the final action terminating this academic program.
Note: if the date is after the start of a term, and there is any term-specific activity for the student in that term, the student will still be considered active until the end of the term. |
| Final_Exit_Reason |
AA672 FINAL REASON
NATURAL ALIAS: FIN-RESN-AA
appears on SRS screen 110 |
The reason for the final action terminating this academic program. See also Final_Exit_Action.
Values:
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 EXPIRATION
|
| Graduation_Checkout_Status |
AA663 DEG_CHECKOUT_STATUS
NATURAL ALIAS: DEG-C-ST-AA
appears on SRS screen 117
|
Indicates a student's progress through graduation checkout
for this academic program.
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
|
| Graduation_Checkout_Term |
AA662 DEG CHECKOUT TERM
NATURAL ALIAS: DEG-CHCK-AA
appears on SRS screens 110, 117 |
The term when the student had his or her degree requirements examined
by the appropriate office. If the student received the degree, this is the
same as the term the degree was received. Note: This is not necessarily
the same as Last_Degree_Term 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.
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.
|
| Major |
AA612 MAJOR
NATURAL ALIAS: AP-MAJ-AA
appears on SRS screens 110 |
The most recent primary major (or grad group) pursued by this student in this academic program.
This is the major that appears as the Primary Major on the student's transcript for the career associated with this academic program.
Values: see the Major 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.
|
| Previous_Institution |
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.
|
| 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 placed no restriction on this information.
Y Restricted. Do not release outside the University.
|
| Restrict_Classification |
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 classification 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.
|
| Restrict_Degree |
AA08N DEG AWARD RESTRICT
NATURAL ALIAS: RS-DG-AW-BIO
appears on SRS screen 11 |
Indicates whether a student has notified the University to restrict the
degrees he or she has received 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.
|
| Restrict_Exit_Action |
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 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. |
| 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 the
honors she or he has received 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.
|
| Restrict_Previous_Institution |
AA08R PREV INST RESTRICT
NATURAL ALIAS: RS-PR-IN-BIO
appears on SRS screen 11 |
Indicates whether a student has notified the University to restrict the
previous institutions he or she has attended fromrelease 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.
|
| School |
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.
|
| 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 |
Protected: This column will appear blank to most users of the Data Warehouse.
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. Special Note for people with security clearance to use SSNs: 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. |
| Rollup_DP_Link_ID |
|
not currently being used. |
