| Data element |
mapping back to SRS |
Definition |
| Career |
AA630 DEFAULT_CAREER
NATURAL ALIAS: CAREER-AA
Appears on SRS screen 110 |
The
career associated with this degree during this term. In SRS, the degree
programs at the term level are mapped to a record in the APS (Academic
Program Summary) to find the associated career.
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 then pursue a career in Law. See
also Restrict_Degree in the DEGREE_PURSUAL_ALL_V Table. |
| Classification_Credit |
calculated
|
The cumulative earned credits the student has completed as of the
start of this term, used to determine the Classification for this student
this term.
|
| Classification |
RT106 CLASSIFICATION, PRI
or
RT141 CLASSIFICATION, SEC.
NATURAL ALIAS: CLS-PRI-RT
or
CLS-SEC-RT
Appears on SRS screen 111
|
The student's classification/year 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.
Example: FR means Freshman.
See also Penn_Classification in this table,
and Med_Classification in the STUDENT_TERM table.
-
Values:
[Null] Unknown
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
|
| Credit_Type |
RT012 CREDIT TYPE
NATURAL ALIAS: CRD-TYP-RT
appears on SRS screen 118 |
The unit of measurement of the term statistics (credits completed,
GPA, etc.) for a student for this term.
See also Registered_Credit, Earned_Credit, and Quality_Credit in the
ENROLLMENT_ALL_V Table.
***COURSE UNIT:
The typical unit of measurement for a course credit at Penn. An average course
is worth one course unit.
***CREDIT:
The unit of measurement for a course credit at the Vet School, which follws
a quarter system. Six Credits are the equivalent of one Course Unit.
***SEMESTER HOUR:
The unit of measurement for a course credit in the following schools:
Law School, School of Design, Dental School.
Three Semester Hourse are the equivalent of one Course Unit.
Values:
CU - COURSE UNITS
SH - SEMESTER HOURS
CR - CREDIT UNITS
|
| 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 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
0 = this is a place-holder in the warehouse. You will not find this value
in SRS. It is used in situations where a dual degree student has an
unresolved leave from a previous program, resulting in 3 overlapping programs.
The unresolved leave program will have a Degree Order of 0. (Note: a Degree
Order of zero usually indicates the student's data in the APS record in
SRS, as seen on screen 110, needs to be corrected.)
See also Dual Degree Type |
| 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 3-character code that identifies 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.
|
| 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, HIATUS and INTERNAL_COURSE_EQUIV tables. |
| Dual_Degree_Type |
RT165 PROGRAM RELATIONSHIP
NATURAL ALIAS: PGM-REL-RT
found on SRS screen 111
|
For students pursuing two degrees, this indicates the relationship
between the primary and secondary degrees. A Dual Degree student is pursuing
two degrees at either the undergraduate or the graduate or professional
level. A Joint Degree student is also pursuing two degrees, but there
is a pre-defined relationship between the two degrees the constitutes a
special joint degree program. A Sub-Matriculating student is pursuing two
degrees: one at the undergraduate
level and one at the graduate level. See also Restrict_Degree in the DEGREE_PURSUAL_ALL_V
Table.
Values:
- NONE
D - DUAL PROGRAM
J - JOINT DEGREE
S - SUB-MATRIC |
| Elig_To_Register |
calculated |
Indicates
whether the student is eligible to register for this and subsequent terms.
Values:
N Not Eligible
Y Eligible
|
| Entry_Action |
AA642 ENTRY ACTION
NATURAL ALIAS: ENT-ACTN-AA
appears on SRS screen 114 |
Indicates the type of action that caused this degree term record to be
created for this student. In SRS, the degree
programs at the term level are mapped to a record in the APS (Academic
Program Summary) to find the associated Entry_Action.
See also
Entry_Action in the DEGREE_PURSUAL_ALL_V Table. See also Entry_Action
in the HIATUS Table.
Values:
AD Regular Admit
AE Admit - Exchange student
AS Submatric Admit
AT Transfer Admit
CO continuing
DD Admit to Dual Degree
DT Degree Transfer within Division
RA Readmit
RI Reinstate (only used with judicial actions)
RL Return from leave
TR Internal Transfer
|
| Joint_Degree_Flag |
RT235 FLAG, REPORT 01
NATURAL ALIAS: RPT-FLG1-RT
appears on SRS screen 119 |
Indicates
the student is enrolled in a specific joint degree program.
Values: B - Vagelos Program: Wharton/Arts and Sciences *
C - Comp & Cog Science: Artificial Intelligence
D - 7 year Bio-Dental
E - Economics and Applied Science
H - Nursing and Health Care Management
I - International Studies
L - Liberal Studies & Technology
M - Management & Technology
N - Nursing & Technology
P - Energy Research (VIPER)
S - Design Theory & Structural Theory
T - Science, Technology and Society
V - Environment and Technology
W - Work Based Learning Leadership Program
X - Executive Master's in Technology-Mgmt
1 - LAUDER / WHARTON - GAS/MBA
2 - LAW / WHARTON - JD/MBA
3 - MED / WHARTON - MS/MBA
4 - VET / WHARTON - VMD/MBA
5 - WHARTON / DESIGN - MBA/MFA
6 - WHARTON / SEAS - MBA/MSEng
7 - WHARTON / HARVARD KENNEDY SCHOOL
8 - WHARTON / JOHNS HOPKINS - SAIS
* Note: for the Vagelos Program, there will be only one degree program
in
DEGREE_TERM_ALL_V. It will be either a Wharton or Arts & Sciences
degree, depending on which school was the student's matriculating school.
|
| 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_Count |
calculated
see majors on SRS screen 111 |
The total number of majors for this student for this degree program and
term.
Values:
[Null] No majors
1 1 major
2 2 majors
3 3 majors
|
| Max_Load |
RT136 MAX LOAD, PRI.
NATURAL ALIAS: MX-LOAD-RT
appears on SRS screen 111
|
The maximum number of credits that the student is allowed to register
for in this term, as defined by the primary division. |
| Minor_Count |
calculated
see minors on SRS screen 111 |
The total number of minors for this student for this degree program and
term.
Values:
[Null] No minors
1 1 minor
2 2 minors
3 3 minors
|
| Owner |
n/a |
Data element definition to be supplied when available. |
| Penn_Classification |
RT1F1 CLASSIFICATION, PRI
or
RT1F2 CLASSIFICATION, SEC
NATURAL ALIAS: PCLASS-PRI-RT
or
SEC-PENN-CLASS-RT
appears on SRS screen 111 |
The student's classification/year in this program. Used for undergraduates,
Penn classification is system-maintained, based on accumulation of earned
credit minus Advanced Placement credit.
- See also Classification in this table, and
Med_Classification in the STUDENT_TERM table.
- Values:
- [Null] Unknown
FR Freshman
SO Sophomore
JR Junior
SR Senior
|
| 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.
|
| Pilot_Curriculum |
RT240 FLAG, REPORT 06
NATURAL ALIAS: RPT-FLG6-RT
appears on SRS screen 119 |
College Pilot Curriculum program (first implemented in Fall 2000; phased
out after the class entering in Fall 2006). Beginning in Fall 2018, the Wharton school began using this field to identify students in their new curriculum.
Values:
- regular requirements
Q - student "applied" to the pilot curriculum program
P - student in the College Pilot Curriculum program this term
T - Transferred out of Pilot Curriculum
W - New Wharton curriculum
|
| 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.
|
| 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.
See also
Degree_Order in the DEGREE_TERM_ALL_V Table.
Values:
Refer to the SCHOOL Table for values.
|
- Special_Program
|
RT134 SPECIAL PGM., PRI.
or
RT161 SPECIAL PGM., SEC.
NATURAL ALIAS: SP-PG-PR-RT
or
SP-PG-SC-RT
appears on SRS screen 111 |
Further specifies academic programs that cannot be defined
solely by the combination of division, degree, major and concentration.
Values beginning with "A" refer to penn students on study
abroad programs at other institutions and, if used, will keep the students
from
being billed.
Values beginning with "B" refer to penn students on Office
of International Programs study abroad programs at other institutions
and, if used, will bill the student based on tables in the student financial
services system.
Values beginning with "C" refer to CGS non-degree programs.
Values beginning with "E" refer to School of Education divisions.
Values beginning with "F" refer to foreign students from
other institutions on study abroad programs at penn. By using this code
the
students will not be billed, will appear on the CER/RCR report under
the non-billable column, and will not be included in the tuition distribution
process. They will continue to be included in the headcount enrollment
reports, degree and course enrollment reports.
Values beginning with "L" refer to Law School/Wharton gradraduate
certitification programs.
Values beginning with "T" refer to special program codes
that need to have exceptions made for them in the tuition calc program.
Values beginning with "W" refer to study away from penn that
are not study abroad programs and the WEMBA East and West programs.
Values beginning with "X" refer to the Bryn Mawr, Swarthmore
and Haverford consortium programs and will be used only for students
who
have spent an entire semester at one of these schools.
For a list of Values:
see the SPECIAL_PROGRAM 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. |
| Term_Cumulative_Gpa |
calculated |
This field contains the cumulative grade point average calculated for the student up to the selected term. If the term selected is still in-progress, the cumulative gpa will reflect all prior terms completed. |
| Term_Earned_Credit |
RT025 TERM EARNED CREDITS
NATURAL ALIAS: CR-EHRS-RT
appears on SRS screen 118 |
Indicates the total credit that the student is awarded this term for successful
completion of enrollments in course sections. Not every completed course
section contributes to Earned_Credit. Certain grades do not earn credit,
for example XX, XC, NG, and AUD. This does not include Total_Penn_Eqvlnt_Credit_Amount
in the DEGREE_PURSUAL_ALL_V Table.
See also
Stats_Credit_Type in the DEGREE_PURSUAL_ALL_VTable.
|
| Term_Gpa |
RT040 TERM-GPA
NATURAL ALIAS: CURR-GPA-RT
appears on SRS screens 118, 136 |
A measure of the student's academic success for this term for this degree
program. Term_Gpa is calculated by dividing the grade points (numerator) by the
quality credit (denominator).
See also Term_Grade_Points and Term_Quality_Credit.
|
| Term_Grade_Points |
RT035 TERM GRADE POINTS
NATURAL ALIAS: CR-QPTS-RT
appears on SRS screen 118 |
The sum of the numberic values which correspond to each grade to be included in the term GPA.
Note: in SRS this is the system-generated sum of the grade points in the student term file. It includes credits for all courses, regardless of which career the course is applied to. It excludes grade points for courses that are applied to no career.
See also
Grade_Point in the ENROLLMENT_ALL_V Table. See also Grade_Points in the
DEGREE_PURSUAL_ALL_V Table.
|
| Term_Quality_Credit |
RT030 TERM QUALITY CREDITS
NATURAL ALIAS: CR-QHRS-RT
appears on SRS screen 118 |
The total number of credits for enrollments attempted this term towards
the student's GPA for this degree pursual. Examples of enrollments which
are NOT attempted towards grade point averages(GPA) include Pass/Fail enrollments
which receive a grade of Pass(P); Audits (AUD); and Withdraw Passing (W).
Qualtiy_Credit
is calculated by using Registered_Credits, except for enrollments not
attempted towards grade point averages (GPA),in which case Quality_Credit
is 0.
Note: in SRS this is the system-generated sum of the quality credits in the student term file. It includes credits for all courses, regardless of which career the course is applied to. It excludes credit for courses that are applied to no career. |
| Term_Registered_Credit |
RT020 TERM REGISTERED CRED
NATURAL ALIAS: CR-AHRS-RT
appears on SRS screens 118, 104, 109, 113, 136 |
The total credits for all courses in which a student is enrolled in this term.
In SRS, this field is the system-generated sum of the registered credits in the student term file. It includes credits for all courses regardless of which career the course is applied to. It also includes credits for courses that are applied to no career.
Registered_Credit is used to
compute academic statistics.
See also Stats_Credit_Type in the DEGREE_PURSUAL_ALL_V Table. See also
Term_Earned_Credit and Term_Quality_Credit in theDEGREE_TERM_ALL_V Table. |
| 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.
|
|
Time_Status
|
RT090 TIME STATUS
NATURAL ALIAS: FT-PT-RT
appears on SRS screen 111 |
Indicates the time status of the student. In most cases, Time_Status is
based on the number of courses the student is registered for and the rules
established for the student division, however this may be overridden by
the student's division.
The value
may change frequently early in the term due to the registration process.
Values:
[Null] Not calculated
N Student has zero enrolled hours
F Full-time
H Half-time
P Part-time
Q Quarter-time
|
|
Converted units
|
This is NOT in SRS, nor is it in the warehouse table. This is a calculated object used in the Business Objects universes. See "Course Units Converted" in the STDTCANQ universe folder "Degree Term" |
Not all schools at Penn report on registered credits using the same credit type. For example, the Law school uses semester hours, the Dental school uses credit hours, and most other schools use credit units. The converted units object in the Business Objects universe converts all credits – whether taken as CUs or SHs or CRs – into a single “currency”: If the term registered credits are of credit type SH (semester hours), this object will divide by 3.
If the term registered credits are of type CR (credit hours), this object will divide by 6. If the term registered credits are of type CU (course units), this object will report the CUs as-is.
|
