ENROLLMENT
SECTION TYPE Table . Tables
and Data Elements . Student
Data Home . Data Warehouse Home
ENROLLMENT_SECTION_TYPE Table - Data Element Index
-
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 PARIS.
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_Type |
RT377 SCE SECTION TYPE
NATURAL ALIAS: SC-SC-TP-RT
Appears on SRS screen 1S3 |
Carries information about a course section into the student's academic
term record. For example, the field identifies whether the course section
was a General Honors section, a Wharton honors section, a Lauder Institute
section, or a continuing education section. Can also be entered at the
specific enrollment level. For example, the course section might not
have a section type of Watu, but the student enrollment section type
can be Watu, for a specific student in a specific class. Values:
A - ADV STUDY PROJ, NON-LAUDER
C - CONTINUING ED
E - RECIPROCAL EXCHANGE PROGRAM
F - PRE-FRESHMAN PROGRAM
G - GENERAL HONORS
H - WHARTON HONORS
I - INTERNATIONAL
L - LAUDER
M - QUANTITATIVE SKILLS COURSE
P - ADV STUDY PROJ, LAUDER
R - WRITING COURSE
S - STUDY ABROAD
T - TOPICS COURSE
V - VET CORE COURSE
W - WATU COURSE (Writing Across the University)
X - ARTIFICIAL REGISTRATION CC - COLLEGE COMPUTING CERTIFICATE COURSE CP - COLLEGE PILOT PROGRAM CW - CREATIVE WRITING COURSE FR - FORMAL REASONING FS - FRESHMAN SEMINAR C1 - CROSS-CULTURAL ANALYSIS C2 - CULTURAL DIVERSITY IN THE US LL - ONE TERM COURSE L0 - LANGUAGE SKILLS COURSE L1 - THE FIRST TERM OF A TWO-TERM COURSE L2 - THE SECOND TERM OF A TWO-TERM COURSE N1 - NURSING SECTOR I PETITION
N2 - NURSING SECTOR II PETITION
N3 - NURSING SECTOR III PETITION
N4 - NURSING SECTOR IV PETITION
NA - NURSING BSN SCIENCE GPA COURSE
NC - NURSING CLINICAL COURSE
ND - NURSING PHD DISTRIBUTION COURSE
NE - NURSING BSN ELECTIVE
NG - NURSING MSN ELECTIVE
NI - NURSING INFORMATICS COURSE
NM - NURSING MINOR REQUIRED COURSE
NP - NURSING PHD CORE CURRICULUM
NS - NURSING SCIENCE COURSE
NT - NURSING DISTANCE LEARNING
NY - NURSING CASE STUDY
SA - SENIOR ASSOCIATES
WL - WORLD LITERATURE
|
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.
|
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 |
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. |
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
See also Restrict_Attend_Dates in the DEGREE_TERM_ALL_V Table.
|
-
-
ENROLLMENT
SECTION TYPE Table . Tables
and Data Elements . Student
Data Home . Data Warehouse Home
Questions about this page? Email us at da-staff@isc.upenn.edu
|