| Data element |
mapping back to SRS |
Definition |
| Change_Date |
RT399_SCE_DATE
NATURAL_ALIAS: SC-DATE-RT
appears on SRS screens 113, 193
|
The date of the last change to this student's enrollment in this course
section. |
| Course_Id |
the first seven positions of the RT305 SCE SECTION
NUMBER
NATURAL ALIAS: SC-CR-ID-RT
appears on SRS screens 104, 1A4, 1B4, 107, 109, 120, 193 |
Identifies the course related to the course section in which the student
is enrolled. Course_Id is a component of Section_Id in the ENROLLMENT_ALL_V
Table. A value of the format of 2, 3 or 4- alphabetic characters, followed
by 2, 1 or 0 blanks (respectively) for the Subject_Area; followed by 3 numeric
characters for the Course_Number. For example, 'MATH001', 'EE 691'.
Values:
Positions 1 to 4 Refer to SUBJECT_AREA table
Positions 5 to 7:
001 to 099 Undergraduate courses primarily for Freshmen
100 to 399 Undergraduate courses
400 to 499 Undergraduate courses primarily for
undergraduates but graduates may also take the
course for credit with permission
500 to 599 Graduate courses primarily for graduates but
undergraduates may also take the course for
credit
600 to 989 Graduate courses
990 to 999 Graduate independent study courses
|
| Course_Number |
positions 5 through 7 of the RT305 SCE SECTION
NUMBER
NATURAL ALIAS: SC-CR-ID-RT
appears on SRS screens 104, 1A4, 1B4, 107, 109, 120,
193 |
The course number of the course section in which the student has enrolled.
Course_Number is a component of Course_Id in the ENROLLMENT_ALL_V Table.
See Course_ID for description of values associated with positions
5 through 7
|
| Career_Pointer1 |
RT355 SCE CAREER POINTER 1
NATURAL ALIAS: SC-C-PT1-RT
appears on SRS screen 113 |
If credit for this course should be counted towards a
career that is different from the student's primary
or secondary program in the term the course was taken, this column will
have the additional career code.
Business Objects users: to find the degree programs in Degree_Pursual
towards which a course is being counted, use the "AA" branch's version
of Enrollment. This joins to Degree_Pursual through Assignment, and will
automatically join to the correct degree program(s) in Degree_Pursual
towards which this course is being counted. You do not need to do your
own calculations using the career pointers.
See also Program_Pointer. |
| Career_Pointer2 |
RT356 SCE CAREER POINTER 2
NATURAL ALIAS: SC-C-PT2-RT
appears on SRS screen 113 |
If credit for this course should be counted towards a career that
is different from the student's primary or secondary program in the term
the
course was taken, this column will have the additional career code. Only
used if there is already something in Career_Pointer1, and an additional
career needs to be indicated.
Business Objects users: to find the degree programs in Degree_Pursual
towards which a course is being counted, use the "AA" branch's
version of Enrollment. This joins to Degree_Pursual through Assignment,
and will automatically join to the correct degree program(s)
in Degree_Pursual towards which this course is being counted. You do not
need to do your own calculations using the career pointers.
See also Program_Pointer. |
| Career_Pointer3 |
RT357 SCE CAREER POINTER 3
NATURAL ALIAS: SC-C-PT3-RT
appears on SRS screen 113 |
If credit for this course should be counted towards a career that
is different from the student's primary or secondary program in the term
the
course was taken, this column will have the additional career code. Only
used if there is already something in both Career_Pointer1 and Career_Pointer2,
and an additional career needs
to be indicated.
Business Objects users: to find the degree programs in Degree_Pursual
towards which a course is being counted, use the "AA" branch's
version of Enrollment. This joins to Degree_Pursual through Assignment,
and will automatically join to the correct degree program(s)
in Degree_Pursual towards which this course is being counted. You do not
need to do your own calculations using the career pointers.
See also Program_Pointer. |
| Credit_Type |
RT324 SCE CREDIT TYPE
NATURAL ALIAS: SC-CR-TP-RT
appears on SRS screens 113, 118, 136, 193 |
The unit of measurement of the credit statistics for this student enrolled
in this course section.
On the student's transcript in SRS, the Credit Type is system generated,
based on the student's primary program.
A Course Unit (CU) is the typical unit of measurement for course credit
at Penn. The majority of standard semester-long courses are worth one
course unit. The Credit (CR) unit of measurement is used at the Dental
and Vet Schools -- which follow a quarter system. 6 Credits = 1 Course
Unit. A Semester Hour (SH) is the unit of measurement used at the Law
School. 3 Semester Hours = 1 Course Unit.
See also Registered_Credit, Earned_Credit, and Quality_Credit in the
ENROLLMENT_ALL_V Table.
Values:
CU Credit Unit
SH Semester Hour (3 SH = 1 CU)
CR Credit Hour (6 CR = 1 CU)
|
| Earned_Credit |
calculated based on the sucessful completion of a course
bearing registered credit.
appears on SRS screens 136, 193 |
Indicates the credit the student is awarded for successful completion
of enrollment in a course section. Not every completed course section contributes
to Earned_Credit. Certain grades do not earn credit, for example, XX, XC,
NG, and AUD.
See also Special_Grading in the COURSE_SECTION Table.
|
| Grade_Point |
calculated |
The weighted numeric value for the grade received for the enrollment in
the course section. This value is used in the calculation of all grade point
averages. It is weighted by Quality_Credit, so that an A received in a course
section with 1.5 course units improves the GPA more than an A received in
a course section with 0.5 course units.
Courses with marks such as HP, P, and Audit have zero Quality_Credit,
zero Grade_Point and do not affect the GPA.
The grade values used, multiplied by the Quality_Credit, to calculate
Grade_Point are:
4.0 A+
4.0 A
3.7 A-
3.3 B+
3.0 B
2.7 B-
2.3 C+
2.0 C
1.7 C-
1.3 D+
1.0 D
0.7 D-
0.0 F
|
| Grade_Type |
RT310 SCE GRADE TYPE
NATURAL ALIAS: SC-GR-TP-RT
Appears on SRS screens 104, 1A4, 113, 109 |
A code indicating the set of rules that are used to process the grade
or mark the student receives for the course. In SRS, Grade Type is used
in conjuntion with "SCE-GRADE-SCHEME-CODE" in the calculation of Registered
Credits, Earned Credits, Quality Credits, Time Status, Student Classification,
and in determining whether the student has reached the Desired Load or
Max Load for registration. Also used in determining some honors, such
as Dean's List.
Values:
- NORMAL GRADE RULES
- COUNTS TOWARD:
- EARNED HOURS - YES
- GRADE POINT AVG - YES
- FULL TIME CALC - YES
- TERM LOAD LIMIT - YES
AU - AUDIT
- COUNTS TOWARD:
- EARNED HOURS - NO
- GRADE POINT AVG - NO
- FULL TIME CALC - NO
- TERM LOAD LIMIT - NO
PF - PASS/FAIL
- COUNTS TOWARD:
- EARNED HOURS - YES
- GRADE POINT AVG - NO IF PASSED, YES IF FAILED
- FULL TIME CALC - YES
- TERM LOAD LIMIT - YES
PN - PASS/NO CREDIT -
- ONLY PASSED COURSES APPEAR ON TRANSCRIPT
- COUNTS TOWARD:
- EARNED HOURS - YES
- GRADE POINT AVG - NO
- FULL TIME CALC - YES
- TERM LOAD LIMIT - YES
NG - NON-GRADED
- COUNTS TOWARD:
- EARNED HOURS - NO
- GRADE POINT AVG - NO
- FULL TIME CALC - NO
- TERM LOAD LIMIT - NO
DM - DISSERTATION/MASTERS
- NON-GRADED BUT APPEARS ON TRANSCRIPT
- COUNTS TOWARD:
- EARNED HOURS - NO
- GRADE POINT AVG - NO
- FULL TIME CALC - YES
- TERM LOAD LIMIT - YES
AR - ARTIFICIAL REGISTRATION
- TEMPORARY REGISTRATION,
- DOES NOT APPEAR ON TRANSCRIPT
- COUNTS TOWARD:
- EARNED HOURS - NO
- GRADE POINT AVG - NO
- FULL TIME CALC - YES
- TERM LOAD LIMIT - NO
RX - REPEAT (EXCLUDE FROM GPA)
- COUNTS TOWARD:
- EARNED HOURS - NO
- GRADE POINT AVG - NO
- FULL TIME CALC - YES
- TERM LOAD LIMIT - YES
RI*- REPEAT (INCLUDE IN GPA)
- COUNTS TOWARD:
- EARNED HOURS - NO
- GRADE POINT AVG - YES
- FULL TIME CALC - YES
- TERM LOAD LIMIT - YES
XC - EXCLUDE CREDIT (EXCLUDE FROM FT/PT)
- COUNTS TOWARD:
- EARNED HOURS - NO
- GRADE POINT AVG - NO
- FULL TIME CALC - NO
- TERM LOAD LIMIT - NO
XX - EXCLUDE CREDIT (INCLUDE IN FT/PT)
- COUNTS TOWARD:
- EARNED HOURS - NO
- GRADE POINT AVG - NO
- FULL TIME CALC - YES
- TERM LOAD LIMIT - YES
|
| 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. |
| Lauder_Grade |
RT322 SCE LAUDER GRADE
NATURAL ALIAS: SC-DL-GR-RT
appears on SRS screen 113 |
Records the Graduate Arts and Sciences grade for the Dual Degree Wharton
Graduate/Graduate Arts and Sciences student enrolled in a course section
which counts toward both degree programs in this term. The Wharton Graduate
grade (using the HP, P, DS scheme) will be found in Official_Grade. The
Lauder_Grade column is the official Graduate Arts and Sciences grade for
the student's transcript.
Values:
A+
A
A-
B+
B
B-
C+
C
C-
D+
D
D-
F
|
| Official_Grade |
RT315 SCE OFFICIAL GRADE
NATURAL ALIAS: SC-OF-GR-RT
appears on SRS screens 113, 136, 193 |
Indicates the Official_Grade assigned to the student for this course.
This may be different from the Reported_Grade if the student has elected
to take the course section Pass/Fail. For example, if the reported grade
is B, but the student requested to take the class Pass/Fail, the Official_Grade
stores the transformed version of the grade (P). The Official Grade is the
grade printed on the transcript.
Values:
A* - EXCELLENT
A+ - EXCELLENT
A - EXCELLENT
A- - EXCELLENT
B+ - ABOVE AVERAGE
B - ABOVE AVERAGE
B- - ABOVE AVERAGE
C+ - AVERAGE
C - AVERAGE
C- - AVERAGE
D+ - BELOW AVERAGE
D - BELOW AVERAGE
D- - BELOW AVERAGE
F - FAILING
O - OUTSTANDING
P - PASS
S - SATISFACTORY
U - UNSATISFACTORY
DD - DISTINGUISHED
DS - DISTINGUISHED
HP - HIGH PASS
NC - NO CREDIT
NCR - NO CREDIT
CR - CREDIT
E - EXCELLENT/EXEMPT
G - GOOD
Q - QUALIFIED
QC - QUALIFIED CREDIT
UNC - UNSATISFACTORY; NO CREDIT
CRD - UNGRADED CREDIT
H - HONORS
F/C - FAIL THEN PASS - REPEATED EXAM
F/P - FAIL THEN PASS
FNC - FAIL - NO CREDIT
-
- MARKS
-
X - VIOLATION/EXEMPT
I - INCOMPLETE
II - INCOMPLETE - EXTENDED
I* - PERMANENT INCOMPLETE
IW - INCOMPLETE (WITHDREW)
W - WITHDREW
WF - WITHDREW, FAILING
AUD - AUDIT
NR - NO GRADE REPORT
GR - NO GRADE RETURNED
|
| Owner |
n/a |
Data element definition to be supplied when available. |
| 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.
|
| Previous_Grade |
RT320 SCE PRIOR GRADE
NATURAL ALIAS: SC-PR-GR-RT
appears on SRS screen 113 |
Indicates the previous Reported_Grade assigned to the student for this
course section. This value is null if the grade has not been changed.
Values:
See "Official Grade"
|
| Program_Pointer |
RT353 SCE PROGRAM POINTER
NATURAL ALIAS: SC-PG-PT-RT
appears on SRS screen 113 |
Indicates whether this course should be counted towards the career
of the students' primary program, secondary program, both, or neither.
See also Career_Pointer(s)
Valid Values:
1 - counts towards the program that is the student's primary program
this term
2 - counts towards the program that is the student's seconday program
this term
B - counts towards both programs the student is in this term
N
- does not count towards any program that the student is enrolled in this term
Business Objects users: to find the degree programs in Degree_Pursual
towards which a course is being counted, use the "AA" branch's
version of Enrollment. This joins to Degree_Pursual through Assignment,
and will automatically join to the correct degree program(s)
in Degree_Pursual towards which this course is being counted. You do
not need
to do your own calculations using the program pointer. |
| Quality_Credit |
calculated |
Earned_Credits that are included in the calculation for the student's
grade point average (GPA). For example, a course enrollment may have a
registered
credit
of
1.00,
but
the grading scheme of the student dictates that the grade will be a mark
(such as HP, P, DS) and not a regular grade, so the Quality_Credits for
said course enrollment will be zero. Note that if a course
is taken Pass/Fail, and the student passes the course, it is not included
in Quailty_Credits, and therefore is not included in the GPA calculation.
If the student fails the course, the Registered_Credits are included in
the Quality_Credit. Values:
can be blank
|
| Registered_Credit |
RT325 SCE REGISTERED CREDS
NATURAL ALIAS: SC-RHRS-RT
appears on SRS screens 104, 113, 136, 193 |
The amount of credit this enrollment in a course section
carries. Registered_Credit is used to compute academic statistics. See also
Credit_Type, Earned_Credit, and Quality_Credit in the ENROLLMENT_ALL_V Table. |
| Reported_Grade |
RT321 SCE REPORTED GRADE
NATURAL ALIAS: SC-RP-GR-RT
appears on SRS screen 113 |
Indicates the grade assigned to the student for this course section.
This may be different from the Official_Grade. For example, if the student
has elected to take
the course section Pass/Fail, the Reported_Grade will be a letter grade,
and the Official_Grade will be either "P" or "F".
Values:
See "Official Grade"
|
| 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 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.
|
|
Section_Id
|
RT305 SCE SECTION NUMBER
NATURAL ALIAS: SC-CR-ID-RT
appears on SRS screen 104, 1A4, 1B4, 107, 109, 120,
193 |
Used to identify the course section in which the student has enrolled.
A unique identifier for a specific course section in a specific term is
composed of the Subject_Area, the Course_Number, and the Section_Number.
Note: Although a Section_Id may be used in more than one term, the activity
may be different in different terms.
Positions 1 to 4 are the alphabetic code for the subject area of the
academic discipline under which the course is offered.
Positions 5 to 7 indicate the course number assigned to the course at
the inventory level.
Positions 8 to 10 indicate the section number for a specific course section
in a specific term.
Generally, term specific sections with a midlle digit of 5 indicate that
the course was taken through Study Abroad.
Values:
Positions 1 to 4 Refer to Table AO35 Table of Subject Areas
Positions 5 to 7:
001 to 099 Undergraduate courses primarily for Freshmen
100 to 399 Undergraduate courses
400 to 499 Undergraduate courses primarily for undergraduates
but graduates may also take the course for credit
with permission
500 to 599 Graduate courses primarily for graduates but
undergraduates may also take the course for credit
600 to 989 Graduate courses
990 to 999 Graduate independent study courses
Positions 8 to 10:
000 Auto section create is for independent study
courses only. The student is assigned a section
number by the department, the section is
automatically created when the student registers
through PennInTouch.
001 to 049 Lecture sections
050 to 059 Study Abroad sections
060 to 099 Lecture sections
100 to 199 Laboratory sections
200 to 299 Recitation sections
300 to 399 Seminar sections
400 to 499 Crosslisted sections
500 to 599 Grad Engineering Executive Masters Program sections
600 to 699 College of General Studies sections
700 to 799 Wharton Executive MBA sections
800 to 999 Reserved for courses converted from the previous
course numbering system
|
| Section_Number |
Positions 8-10 of the RT305 SCE SECTION NUMBER
NATURAL ALIAS: SC-CR-ID-RT
appears on SRS screens 104, 1A4, 1B4, 107, 109, 120,
193 |
A 3-digit number that indicates a specific course section in a specific
term. The unique identifier for a specific course section in a specific
term is composed of the Subject_Area, the Course_Number, and the Section_Number.
Note: Although a Section_Id may be used in more than one term, the activity
may be different in different terms.
Positions 1 to 4 are the alphabetic code for the subject area of the
academic discipline under which the course is offered.
Positions 5 to 7 indicate the course number assigned to the course at
the inventory level.
Positions 8 to 10 indicate the section number for a specific course section
in a specific term.
Generally, term specific sections with a midlle digit of 5 indicate that
the course was taken through Study Abroad.
See Section_ID for definition of values for position 8 through 10.
|
| 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. |
| Status |
RT301 SCE STATUS
NATURAL ALIAS: SC-STAT-RT
appears on SRS screen 109 |
Indicates the student's current registration status for this course section
for this term. Note that currently only course enrollments with a status
of "E" (Enrolled) are loaded into the data warehouse. |
|
Subject_Area
|
the first four positions of the RT305 SCE SECTION
NUMBER
NATURAL ALIAS: SC-CR-ID-RT
appears on SRS screens 104, 1A4, 1B4, 107, 109, 120,
193 |
The subject area of the course section in which the student has enrolled.
A subject area is a 4- character alphabetic code that indicates the subject
area of the academic discipline under which the course is offered. One academic
department may administer multiple subject areas.
Values: Refer to the SUBJECT_AREA 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 this student was enrolled for this course section.
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
|
