| Data element |
mapping back to SRS |
Definition |
|
Concentration
|
RT122 CONCENTRATION, PRI
or
RT123 CONC MAJOR 2 PRI
or
RT124 CONC MAJOR 3 PRI
or
RT149 CONCENTRATION, SEC.
or
RT152 CONC MAJOR 2 SEC
or
RT153 CONC MAJOR 3 SEC
appears on SRS screen 111 |
Further
defines a Major. In SRS, majors can be associated with concentrations.
Concentrations cannot exist without majors. Minors do not have concentrations.
Values:
Refer to CONCENTRATION table.
|
| Degree_Order |
derived from the positional indicators of the term
data elements in SRS.
on SRS screen 111, the degree order appears as text
|
The number of 1 or 2 that indicates the order of the degree program.
It is used to distinguish two degrees, for those students who are pursuing
multiple degrees at the same time.
1 = Primary program
2 = Secondary program
|
| Degree |
RT115 DEGREE, PRI.
or
RT147 DEGREE, SEC.
NATURAL ALIAS: DEG-PRI-RT
or
DEG-SEC-RT
found on SRS screen 111
|
The degree pursued by this student during this term. A student may
pursue more than one degree during the same term. A degree is an academic
title pursued through a division or a school, and awarded by the University
of Pennsylvania.
See also Restrict_Degree in the DEGREE_PURSUAL_ALL_V Table.
See also Degree_Order in the DEGREE_TERM_ALL_V Table.
Values: see the DEGREE table.
|
| Division |
RT111 DIVISION, PRI.
or
RT146 DIVISION, SEC.
NATURAL ALIAS: DIV-PRI-RT
or
DIV-SEC-RT
found of SRS screen 111
|
The sub-unit of the school responsible for administering the student's
pursual of this degree. 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 andSciences),
NUR (Nursing Undergraduate), GFP (Fine Arts Graduate) and GEX (Engineering
and Applied Science Executive).
See also Degree_Order in the DEGREE_TERM_ALL_V Table.
Values: see the DIVISION table.
|
| 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 the Warehouse in date
format. |
| Leave_Flag |
calculated |
Indicates whether the student is on leave for this term.
See also Restrict_Attend_Dates in the DEGREE_TERM_ALL_VTable.
Values:
[null] Not on leave
Y On leave |
| Major_Minor_Order |
derived from the positional indicators of the
term data elements in SRS.
on SRS screen 111, the major, or minor, order is merely
represented by the position of the data elements on the screen.
|
A number from 1 to 3 that indicates the order of the major
or minor (depending on the value in the Major_Minor_Type field in the
MAJOR_MINOR_TERM Table).
This is used only for sequencing purposes and does not imply that one
major or minor is more important than another.
Values:
1, 2, 3
|
| Major_Minor_Type |
n/a |
A code that indicates whether the data in this record refers
to the student's major or minor.
Values:
M Major
N Minor
|
| Major_Minor |
RT120 MAJOR 1, PRI.
or
RT125 MAJOR 2, PRI.
or
RT128 MAJOR 3, PRI.
or
RT148 MAJOR 1, SEC.
or
RT150 MAJOR 2, SEC.
or
RT151 MAJOR 3, SEC.
or
RT130 MINOR, PRI.
or
RT132 MINOR 2, PRI.
or
RT133 MINOR 3, PRI.
T SPECIFIED
or
RT155 MINOR, SEC.
or
RT157 MINOR
2, SEC.
or
RT158 MINOR 3, SEC.
appears on SRS screens 110, 111, 114, 136 and used in context line on
screen 108 |
The academic area which makes up a major or minor component (depending
on the value in the Major_Minor_Type column). For graduate programs,
this is the referred to as the Graduate Group.
Note: in the Wharton school, this is sometimes referred to as 'Concentration.'
See also
Restrict_Major_Minor.
Values:
refer to the MAJOR table for values.
|
| 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.
|
|
Restrict_Major_Minor
|
AA08J MAJOR RESTRICT
NATURAL ALIAS: RS-MAJOR-BIO
found on SRS screen 11 |
Indicates whether a student has notified the University
to
restrict information about his or her major or minor field of study from
release to persons outside of the University.
Values:
[Null] The student has not notified the University to restrict information
about his or her major or minor field of study.
Y Yes, the student has notified the University to restrict information
about his or her major or minor field of study from release outside
of the University.
|
| School |
RT105 SCHOOL, PRI.
or
RT140 SCHOOL, SEC.
NATURAL ALIAS: SCH-PRI-RTT
or
SCH-SEC-RT
appears on SRS screen 111
|
The school responsible for administering the student's pursual of
the degree. 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).
Note that there is no table that explicitly maps divisions to schools.
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
|
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. |
|
Term
|
RT005 STF TERM CODE
NATURAL ALIAS: TERM-RT
Term is part of the record key for all student term
data in SRS, and is found in the context line on many SRS screens
|
The term in which information about this student pursuing this degree
applies.
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_TERM_ALL_VTable.
|
