| Data element |
mapping back to SRS |
Definition |
|
Degree_Awarded_Date
|
RA245 DEG DATE
NATURAL ALIAS: DG-RC-DT-RA
appears on SRS screen 123 |
The date that the degree was awarded. For University of Pennsylvania
degrees (institution code 2926), this is the Commencement date for the
term in which the degree is awarded. Degrees awarded at other institutions
may have various dates. |
|
Degree_Awarded_Term
|
Calculated using the Degree_Awarded_Date
and the SRS Term Calendar.
|
The term that this degree was awarded from the University ofPennsylvania.
The value is null for non-Penn degrees.
|
|
Degree_Awarded
|
RA205 DEG CODE, AWARDED
NATURAL ALIAS: DG-CODE-RA
appears on SRS screen 123 |
The degree earned by a student either at the University of Pennsylvania
or at another institution.
Values: refer to the DEGREE table. |
|
Division
|
RA231 DEG DIVISION CODE
NATURAL ALIAS: DG-DIV-RA
appears on SRS screen 123 |
For Penn degrees (institution code 2926), the division associated with
this degree received by 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. Degrees received from non-Penn
schools will have a null value in the Division column.
Examples of Division code include COL (College of Arts andSciences),
NUR (Nursing Undergraduate), GFP (Fine Arts Graduate)and GEX (Engineering
and Applied Science Executive).
Values:
[Null] - Non-Penn degree
Penn degrees - Refer to the DIVISION
Table for values.
|
| DP_LINK_ID |
n/a |
A system-generated internal index column, used to join the degree received
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, DEGREE_TERM, MAJOR_MINOR_TERM,
ASSIGNMENT, HIATUS and INTERNAL_COURSE_EQUIV tables. |
|
Institution
|
RA240 DEG INSTITUTION CODE
NATURAL ALIAS:
DG-INST-RA
appears on SRS screen 123 |
The academic institution (Penn or non-Penn) awarding the degree. For Penn,
the ETS (Educational Testing Service) code is 2926.
Where possible, the Institution is based on the numeric ETS code. Penn
assigns codes to some institutions which have no ETS value. Examples of
Institutions are 0990095 (Oxford University), 0002098 (Cornell University),
and 0101102 (Southwest Miami High School).
See also Restrict_Previous_Institution in the DEGREE_RECEIVEDTable.
Values:
Refer to the INSTITUTION Table for values.
|
|
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. |
|
Penn_Id
|
n/a |
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. It is populated in the Data Warehouse
from a extract from PennCommunity.
|
|
Restrict_Attend_Dates
|
AA08L ATTEND DATE RESTRICT
NATURAL ALIAS:
RS-AD-DT-BIO
found 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_Degree
|
AA08N DEG AWARD RESTRICT
NATURAL ALIAS: RS-DG-AW-BIO
found 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_Previous_Institution
|
AA08R PREV INST RESTRICT
NATURAL ALIAS: RS-PR-IN-BIO
found on SRS screen 11 |
Indicates whether a student has notified the University to restrict the
institutions he or she has previously attended 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. |
