| Data element |
mapping back to SRS |
Definition |
| Degree |
AA611 DEGREE
NATURAL ALIAS: AP-DEG-AA
appears on SRS screen 110
|
The degree the student was pursuing when the hiatus began. A degree
is an academic title pursued through a division of a school, and awarded
by the University of Pennsylvania.
See also Restrict_Degree in the DEGREE_PURSUAL_ALL_V
Table.
Values: Refer to the DEGREE table. |
| Division |
AA610 DIVISION
NATURAL ALIAS: AP-DIV-AA
appears on SRS screen 110
|
The division in which the student was pursuing the degree when the
hiatus began. 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 COL (College of Arts and Sciences),
NUR (Nursing Undergraduate), GFP (Fine Arts Graduate) and GEX (Engineering
and Applied Science Executive).
Values: Refer to the DIVISION Table.
|
| DP_LINK_ID |
n/a |
A system-generated internal index column, used to join the term records
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_ALL_V, MAJOR_MINOR_TERM, ASSIGNMENT,
DEGREE_TERM_ALL_V and INTERNAL_COURSE_EQUIV tables. |
| Exit_Action_Date |
AA653 EXIT DATE
NATURAL ALIAS: EXIT-DAT-AA
appears on SRS screen 110 |
The effective date of the action that began the hiatus for this student.
See also Restrict_Attend_Dates in the HIATUS Table.
|
| Exit_Action_Reason |
AA652 EXIT REASON
NATURAL ALIAS: EXIT-RSN-AA
appears on SRS screen 110 |
The reason that began the hiatus for this student.
See also Exit_Action
Values:
[NULL] None
AC Academic
AI Academic integrity
CU Curricular
CR Career/work related
DE Deceased
EN Environment, dislikes
FI Financial
MB Misbehavior
MD Medical
MS Military service
NC Non-correspondence
ND No reason from division
NS No reason frim student
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 began the hiatus for this student.
See also Exit_Action_Reason in the HIATUS Table.Values:
AW Withdrawn by Division
CA Cancelled by Admitting office
DF Deferred admissions
DR Dropped by Division
EP End of program
JE Judicial expulsion (on transcript)
JS Judicial suspension (on transcript)
JX Judicial suspension (not on transcript)
PD Dropped from program
PW Withdrew from program
TR Internal transfer
WD Withdrew
WT Withdrew to transfer
GD Graduated
|
| Exit_Term |
AA650 EXIT TERM
NATURAL_ALIAS: EXIT-TRM-AA
appears on SRS screen 110 |
The first term that this student was on hiatus from this degree. This
should be the last active term for this student in this degree and division,
however divisional procedures may vary. The student may still be pursuing
a degree in another division in this term.
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 EXIT_ACTION in the HIATUS Table. See also Restrict_Attend_Dates
in the HIATUS Table
|
| 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. |
| 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.
|
| 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.
|
| Return_Action |
AA642 ENTRY ACTION
NATURAL ALIAS: ENT-ACTN-AA
appears on SRS screen 110 |
The action by which a student is returned to a previously closed degree
pursual and ends this hiatus.
See also Exit_Action in the HIATUS Table.
Values:
RA Readmitted
RI Reinstated
|
| Return_Term |
AA640 ENTRY TERM
NATURAL ALIAS: ENT-TERM-AA
appears on SRS screen 110 |
The term in which this student returned to pursue this degree.
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 Return_Action in the HIATUS Table. See also Restrict_Attend_Dates
in the HIATUS Table.
|
| School |
AA635 SCHOOL
NATURAL ALIAS: SCHOOL-AA
appears on SRS screen 110 |
The school in which the student was pursuing the degree when the hiatus
began. A school is an administrative unit in charge of academic departments,
courses and faculty.
Examples of SCHOOL codes include EG (Engineering and Applied Sciences),
ED (Education) and LW (Law).
Values: Refer to the SCHOOL table..
|
| 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. |
