Penn Computing

University of Pennsylvania
Penn Computing << go backback

CEN COURSE SECTION Table . Tables and Data Elements . Student Data Home . Data Warehouse Home

CEN_COURSE_SECTION Table - Data Element Index

Activity_Group

Identifies a selection of course sections to which a student must limit enrollments for a particular course. Activity_Group is only used by certain academic departments. For those, it is only used in cases where, for courses with course sections having more than one activity (ie., both lectures and labs), an arbitrary combination of enrollments will not satisfy registration requirements. For example: MATH130001, with an activity of LEC, and MATH130201, with an activity of REC, belong to Activity_Group 1. MATH130003, with activity LEC; MATHC130221, with activity REC; and MATH130222, with activity REC; belong to Activity_Group 3. A student enrolling in a lecture from Activity_Group 1 must take a recitation from Activity_Group 1 and not from Activity_Group 3.

Values:

[Null]     Not grouped
1          Group 1 sections
2          Group 2 sections
3          Group 3 sections
4          Group 4 sections
5          Group 5 sections
6          Group 6 sections
7          Group 7 sections
8          Group 8 sections
9          Group 9 sections

 

Activity The method of instruction for the course section. Every course section should have an activity type. For example: LEC (Lecture), LAB (Laboratory), SEM (Seminar).

Values:

[Null]     Not an activity
CLN        Clinic
DAB        Dissertation abroad
DIS        Dissertation
FTI        Full time internship (Grad School of Education only)
IND        Independent study
LAB        Laboratory
LEC        Lecture
MST        Masters thesis
OOR        Out of residence (Grad Fine Arts only)
PRE        Preceptorship (Grad Nursing only)
PTI        Part time internship (Grad School of Education only)
REC        Recitation
SEM        Seminar
SRT        Senior thesis
STU        Studio (Fine Arts)
Audits The total number of students auditing this course section as of the Census Date. Auditors are students who are formally enrolled but do not receive credit or grades for this course section. For example: as of the Census Date, 3 students have audited this course section. The Census Date is one week after the close of the drop period for the term.
Available_Seats
A system-maintained tally of seats left to be filled for this course section as of the Census Date. Unclaimed permits and unclaimed authorizations do not count against the number of available seats. For example: as of the Census Date, 5 seats remain to be filled for CLST001003. The Census Date is one week after the close of the drop period for the term.

Permits guarantee a student his or her enrollment in a course section even if it will bring enrollment over the maximum allowed. Permits are valid only during Advance Registration and Drop/Add.

Authorizations allow a student to enroll in a course section after all valid students have been enrolled and if there are remaining seats. Authorizations are valid only during Advance Registration.

Credit_Connector Indicates the amount or range of credit for which a student is allowed to register for this course section. For example: ARCH999000 is marked as V (Variable Credit Course). Because the credit range for ARCH999000 is 1.00 to 2.00, the student is allowed to register for 1.5 credits.

See also Min_Credit and Max_Credit in the CEN_COURSE_SECTION Table.

Values:

F     Fixed credit course:  credit will print in the Course Catalog as a
      fixed amount; student is allowed to register for the fixed credit
      amount only and the limit will be enforced.

V     Variable credit course:  credit will print in the Course Catalog
      as a range; student is allowed to register for credits within the
      range printed and the limits will be enforced.

A     Alternate credit course:  credit will print in the Course Catalog
      as an alternate amount; student is allowed to register for one or
      the other credit printed and individual registrations may be
      altered only to 1 credits or 2 credits.

T     To be arranged:  credit will print in the Course Catalog as
      "arranged:" student is allowed to register for credits as approved
      by the department.
Credit_Type The unit of measurement for the quantitative credit value of a course section. Different divisions use different units. For example: the Law School uses Semester Hours (SH).

Values:

CU     Course Units
SH     Semester Hours
CR     Credit Units
Drops Total number of students that were dropped from this course section as of the Census Date including system-dropped registration requests as well as student-dropped enrollments. For example: as of the Census Date, 2 students were dropped from this course section. The Census Date is one week after the close of the drop period for the term.
End_Date

The last day of the term or session on which this course section was taught. This date adheres to the term calendar unless changed by the department offering the course section. For example: for the term 1995C, Dec 8, 1995 was the last day on which CPLN661101 was taught.

Date formats in the Warehouse depend on the query tool you are using (Business Objects, GQL, SAS, SQL*Plus) and/or the settings you have established for formatting dates on your computer. For example: dates in Business Objects with Windows may be presented in the mmddyy format with a slash (/) separator, e.g. 5/31/96.

Enrollment The total number of students registered for this course section as of the Census Date. For example: as of the Census Date, 23 students registered for this course section. The Census Date is one week after the close of the drop period for the term.
Expected_Enroll The number of students expected to enroll in this course section. It is also used for computations in the classroom search facility. For example: the course section has an expected enrollment of 32 students.
Extended_Title Extended description of the course section title. An extended title is appended to a title. For example: In 1995C, course section AFAM400302 had a title of "WEB DuBois' Social Ideas" and an extended title of "West Philadelphia as a Test Case."
Grading_Status This data element will usually be null since grade sheets are produced and returned after the Census Date.

The status of grade sheets produced for this course section as of the Census Date. The Census Date is one week after the close of the drop period for the term.

Values:

[Null]    No grade sheet produced
1         Grade sheet produced (missing grade sheet)
2         Grade sheet submitted on time
3         Grade sheet submitted late
Location Indicates whether the course section is taught on campus, at Cigna, or at Colonial Penn. For example: null means the class is taught on Penn's campus.

Values:

[Null]      Penn Campus
CI          Cigna
CP          Colonial Penn
Max_Credit The greatest number of credits for this course section for which a student may register. This data element is only used by SRS in conjunction with variable or alternate credit courses and will validate a student's requested credit during registration.

See also Credit_Connector in the CEN_COURSE_SECTION Table.

Max_Enroll The maximum number of students allowed to enroll in this course section. When this number is reached, no more requests for enrollment are accepted unless a student receives a permit. It is also used for computations in the classroom search facility. For example: 30 students are allowed to enroll in this course section.
Min_Credit

Minimum amount of credit for which a student may take this course section. It must be less than or equal to the Max_Credit. For example: the minimum credit for which a student may have taken DENT800001 in Spring 1995 is 54.0 credit units.

See also Max_Credit in the CEN_COURSE_SECTION Table.

Min_Enroll Minimum number of students required for enrollment to prevent the course section from being canceled. For example: the minimum enrollment to prevent the course section from being cancelled is 17.

Values:
Number from 0 and 999

Requests A system maintained tally of registration requests. It includes all requests whether or not they were satisfied. For example: 152.
Schedule_Print_Flag Indicates whether this course section will print in the Course Timetable (CTT), the Course and Room Roster (CRR), or the Freshman Timetable (FTT). For example: null means that the course section will print in the CTT and the CRR.

Values:

[Null]     Print in CTT and CRR
N          Do not print in any publications
F          Print in FTT only
B          Print in CTT, CRR, and FTT
Schedule_Revision The type of change made to a course section after the schedule of class publications (Course Timetable or Course and Room Roster). All changed course sections along with the changes are printed in the Daily Pennsylvanian prior to registration. The value ranges from 1 to 9 by level of importance with 9 as the most important. If more than one change is made the higher value appears in this field. For example: 9 (Canceled).

Values:

1     Enrollment or message
2     Title or description
3     Instructor
4     Credit
5     Room
6     Time
7     Time and room
8     Section added
9     Canceled
Scheduling_Priority

Used in Advanced Registration processing to determine which students receive higher priority to enroll in this course section. For example: seniors receive more priority then freshmen.

If this data element is null then the student is enrolled or rejected for the course section under the normal enrollment rules.

Section_Control

Used to determine whether a course section will appear on class lists, grade rosters, and transcripts. It is also used to determine whether a course has auto-section create capabilities (the course section is created each term automatically). For example: T (the course section will appear on the class list and transcript but not on the grade roster).

Values:

[Null]     Appears on all class lists, grade rosters, and transcripts.
R          Appears on class lists only.
I          Informal credit activity - optional class lists and on grade
           roster and transcript.
S          Auto section create - Does not appear on any class lists,
           grade rosters, and transcripts.
T          Appears on class list and transcript but not on grade roster.
G          Appears on class list and grade roster but not on transcript.
A          Artificial registration - Does not appear on any class lists,
           grade rosters, and transcripts.
Section_Dept The academic department that developed the course section. Multiple subject areas may be administered by one department. For example: the section department for both ITAL995002 and PRTG110680 is ROML.

See also Subject_Area and Section_Division in the CEN_COURSE_SECTION Table.

See also Division in the CEN_COURSE_SECTION Table.

Section_Division The division that offers this course section. Section_Division is used when a section is administered by a division rather than a department.

Examples of division codes include CGS (College of General Studies), NUR (undergraduate Nursing), and WEM (Wharton Executive MBA Program).

See also Division in the CEN_COURSE_SECTION Table.

Section_Id The unique identifier for a specific course section in a term: Characters 1 to 4 contain the subject area code (subject area is the alpha code of the academic discipline under which the course is offered). Characters 5 to 7 comprise the course number. Characters 8 to 10 comprise the course section. For example: FREN 130301 is FREN (French, subject area), 130 (course number), 301 (section number).

The components that make up Section_Id (subject area, course Id, and section Id) are not available in the CEN_COURSE_SECTION Table. See the COURSE_SECTION Table for these data elements.

Values:

Course numbers indicate course level as follows:
100-399 are undergraduate courses
400-499 are both undergraduate and graduate but mostly undergraduate
500-599 are both undergraduate and graduate but mostly graduate and professional
600-989 are graduate and professional


Section Numbers indicate course activity as follows:
000 - Auto-Section Create courses
001-099 Lectures and any courses that have only one section (050-059 used by many departments exclusively for Study Abroad courses)
100-199 Laboratory sections
200-299 Recitation sections
300-399 Seminar sections
400-499 Cross-listed sections 500-599 Grad Engineering Executive Masters Program
600-699 College of General Studies 700-799 Wharton Executive MBA program
800-899 Reserved for courses converted from the previous system
900-909 Summer courses - 12-week session
910-919 Summer courses - 1st Summer session
920-292 Summer courses - 2nd Summer session
950-959 Summer Study Abroad courses (these are not Study Abroad courses in Fall/Spring)
Section_School The school associated with the department that developed the course section. All sections of a course are associated with the same department and school.

See also Tuition_School in the CEN_COURSE_SECTION Table.

See also School in the CEN_STDT_ENROLLMENT Table.

Section_Type Indicates whether the course section is associated with, or offered as part of, a program. The honors codes, G (General Honors) and H (Wharton Honors) mean that only students in those programs may register for the course section. Other examples are L (Lauder) and W (Writing Across the University or WATU).

NOTE: As of Fall 2001, Section Type will be found in the CEN_COURSE_SECTION_TYPE table. Values for Section Type in terms prior to Fall 2001 will be found in both CEN_COURSE_SECTION and CEN_COURSE_SECTION_TYPE.

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
        K - HIGHER ED EXEC MGMT
        L - LAUDER
        M - QUANTITATIVE DATA ANALYSIS COURSE
        P - ADV STUDY PROJ, LAUDER
        R - WRITING COURSE
        S - STUDY ABROAD
        T - TOPICS COURSE
        V - VET CORE COURSE
        W - WATU COURSE
        X - ARTIFICIAL REGISTRATION
        CC - COLLEGE COMPUTING CERTIFICATE COURSE
        CP - COLLEGE PILOT PROGRAM
        FS - FRESHMAN SEMINAR
        LL - ONE TERM 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

 

Session_Dup Indicates whether more than one section of the course can be taken for credit during any session of a term. If Session_Dup is Y (Yes), then multiple sections are allowed and the Max_Credit for the course section must reflect the number of sections that can be taken in one term. For example: FNCE399001 might be Y (Yes) for a particular term.

See also Max_Credit in the CEN_COURSE_SECTION Table.

Values:

Y    Yes
N    No
Special_Grading Indicates any special rules governing the grades or credit for this course section. For example: GR means normal grading rules only, so student cannot take the course section as Pass/Fail.

See also Grade_Scheme in the CEN_STDT_ENROLLMENT Table.

Values:

[Null]     Normal grading, student option allowed
GR         Normal grading, no student option allowed
PF         Pass/Fail only
NG         No grade
DM         Dissertation/Masters
XC         Exclude credit and excluded from full time/part time
XX         Exclude credit and include in full time/part time
AR         Artificial Registration.
Start_Date The first day of the term or session which this course section is taught. The date is determined by the begin and end dates in the system term calendar. For course sections that are offered the full academic term, this date will generally be null. A date will appear for all special sessions. For example: August 20, 1998.

Date formats in the Warehouse depend on the query tool you are using (Business Objects, GQL, SAS, SQL*Plus) and/or the settings you have established for formatting dates on your computer. For example: dates in Business Objects with Windows may be presented in the mmddyy format with a slash (/) separator, e.g. 5/31/96.

Status Indicates the availability of the course section as of the Census Date: O (Open), C (Closed), H (Hold), X (Cancelled). The Census Date is one week after the close of the drop period for the term.
Subtitle_Code The official subtitle for a course section. A subtitle can serve as a replacement for the regular title when a course section is offered during a specific term, or the subtitle can serve as an addition to the regular title.

Values:

001 to 999

When you enter a subtitle code on a course termfile record, 
SRS replaces the section title text with the subtitles 
for the matching subtitles code.
Subtitle_Print_Flag
Controls the relationship between the fields, Section_Title_Text, Course_Title_Text, Section_Subtitle_Code, and Section_Extended_Title_Text for purposes of printing titles.

Values:

[Null]     Normal, print course section title, followed by extended
           subtitle if present.
S          Subtitle, print course inventory title followed by the course
           section title.
E          Extended, print only the extended title.
Term The term, as of the Census Date, that this course section was offered. Penn divides the academic year into 3 terms: 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. For example: 1995C means Fall 1995; 1996A means Spring 1996; and 1996B means Summer 1996.
Timetable_Instructor The primary instructor or instructors for this course section as of the Census Date. This name is initially provided by a link to the Payroll system (PBP) based on the instructor's ID number. If no ID number is entered, the value defaults to Staff. Note: The instructor's name may be changed and may not match the ID. The format of this data element therefore varies. For example: the values for this data element may appear as Staff; Evans G; Bello/Spivak; Halbfass/Schnei.
Unclaimed_Permits

The total number of students holding unclaimed permits or unclaimed authorizations for this course section as of the Census Date. These students received permits or authorizations to take this course but did not enroll. For example: for this course section, 3 students have unclaimed permits.

See also Available_Seats in the CEN_COURSE_SECTION Table.

 

CEN COURSE SECTION Table . Tables and Data Elements . Student Data Home . Data Warehouse Home


Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania