Penn Computing

University of Pennsylvania
Penn Computing << go backback

STUDENT_APS Table . Tables and Data Elements . Student Data Home . Data Warehouse Home

STUDENT_APS - Data Element Index

 

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
DD Admit to Dual Degree
RA Readmitted R1 Returning from a D1 exit
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..

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.

STUDENT_APS 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