| Data element |
mapping back to SRS |
Definition |
- Actual_Return_Term
|
derived from AA640 ENTRY_TERM, after the Academic Program
Summary records on SRS screen 110 is updated to reflect the student's
actual return. |
The term that this student returned from the leave of absence.This value
will be null until the student returns from leave.
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.
See also Final_Action_Term and Restrict_Attend_Dates.
|
| Expected_Return_Term |
AA655 TERM RETURN EXPECTED
NATURAL_ALIAS: EXP-RETN-AA
appears on SRS screen 110 |
The term that this student is expected to return from the leave of absence.
This value may be null.
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, theSummer term code is B, and
the Fall term code is C.
|
| Final_Action_Date |
AA673 FINAL DATE
NATURAL ALIAS: FIN-DATE-AA
appears on SRS screen 110
|
The date of the final action that closes the student's degree pursual.
|
| Final_Action_Reason |
AA672 FINAL REASON
NATURAL ALIAS: FIN-RESN-AA
appears on SRS screen 110 |
The effective date of the final action terminating this academic program
entry. A final action is a second exit action taken after a leave of absence.
For example, a student on leave of absence may be allowed to withdraw without
first returning from leave. |
| Final_Action_Term |
|
For students who did not return from a leave of absence, this is the
term in which the University closed the open degree pursual for this
student.
Otherwise, this field is null. |
| Final_Action |
AA671 FINAL ACTION
NATURAL ALIAS: FIN-ACTN-AA
appears on SRS screen 110 |
The final action that closes the student's degree pursual while on
leave.See Final_Action_Reason, and also Exit_Action in the DEGREE_PURSUAL_ALL_V
Table. -
Values:
AW Withdrawn by Division
CA Cancelled by Admitting office
CP Completed certification program
DF Deferred admissions
DR Dropped by Division
ED Withdrew from dual/joint degree program
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 Graduate
|
-
- Last_Activity_Date
|
n/a |
The date this record was downloaded via the SRS extract processand loaded
into the Warehouse. This information is stored in theWarehouse in date format.
|
|
Leave_Action
|
AA651 EXIT ACTION
NATURAL ALIAS: EXIT-ACT-AA
appears on SRS screen 110 |
The action by which the student is placed on leave by theUniversity.
See also Leave_Reason.
Values:
AL Administrative leave
D1 First Drop (treated as a Leave of Absence in the warehouse)
LV Leave of absence
FL For Library (students on leave who keep their Library privileges)
note: "FL" was formerly used for "Family Leave";
changed to "For Library" in Fall 2010
|
| Leave_Date |
AA653 EXIT DATE
NATURAL ALIAS: EXIT-DAT-AA
appears on SRS screen 110 |
The date that the student is placed on leave from the University. |
|
Leave_Reason
|
AA652 EXIT REASON
NATURAL ALIAS: EXIT-RSN-AA
appears on SRS screen 110 |
The reason that the student is on a leave of absence. See also Leave_Action
Values:
[NULL] None
AC Academic
AI Academic integrity
CU Curricular
CR Career/work related
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
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
|
| Leave_Term |
AA650 EXIT TERM
NATURAL ALIAS: EXIT-TRM-AA
appears on SRS screen 110
|
The last term the student was at the University prior to beginning their
leave of absence. There can be enrollment data in this term; by SRS definition,
the leave starts at the end of the term found in Leave_Term. |
| 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 placed no restriction on this information.
Y Restricted. Do not release outside the University.
|
| 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. |
