| Data element |
Definition |
| Academic_Level Indexed - no
Format - Varchar2(800)
May be Null? Y
tcval.attr = 'academic_level' | The curriculum management academic level designation for the course. Note that this is not the same as the Banner Level codes.
Examples of values: 1 (Undergraduate) and 2 (Graduate). |
| Activity_1 Indexed - no
Format - Varchar2(800)
May be Null? Y
tcval.attr = 'instruction_type' | This data element was de-comissioned in the Summer of 2021. No new data is being collected for this field. See instead the field named Schedule_Type_Hours. |
| Activity_2 Indexed - no
Format - Varchar2(800)
May be Null? Y
tcval.attr = 'instruction_type' | This data element was de-comissioned in the Summer of 2021. No new data is being collected for this field. See instead the field named Schedule_Type_Hours. |
| Activity_3 Indexed - no
Format - Varchar2(800)
May be Null? Y
tcval.attr = 'instruction_type' | This data element was de-comissioned in the Summer of 2021. No new data is being collected for this field. See instead the field named Schedule_Type_Hours. |
| Banner_Prereqs Indexed - no
Format - Varchar2(800)
May be Null? Y
tcval.attr = 'banner_prereqs' | Prerequisites, entered as text in the Curriculum Management system. May contain text that indicates logic such as "AND", "OR" in addition to listing the course prequisites. |
| Banner_Prereqs_CL Indexed - no
Format - Varchar2(800)
May be Null? Y
tcval.attr = 'banner_prereqs_cl' | Prerequisites as selected from drop-down choices in the Course Leaf application (Curriculum Management system). Contains additional information about pre-requisites, such as the number of credit hours, minimum grade, and comments. |
| CL_Course_Id Indexed - no
Format - Varchar2(800)
May be Null? Y
tcval.attr = 'code' | The identifying subject and course number, in the format used by the CourseLeaf source system |
| Committee Indexed - no
Format - Varchar2(800)
May be Null? Y
tcval.attr = 'committee_membership' | The code for the committee responsible for reviewing the proposal, if any. Examples of values: Col_CCA College Cross-Cultural Analysis Committee
Col_CDUS College Cultural Diversity in the U.S. Committee
Col_Curriculum_Cmte College Curriculum Committee
Col_FRA College Formal Reasoning and Analysis Committee
Col_HSS College Humanities and Social Science Panel
Col_NSM College Natural Science and Mathematics Panel
Col_QDA College Quantitative Data Analysis Committee |
| Corequisites Indexed - no
Format - Varchar2(4000)
May be Null? Y
tcval.attr = 'coreqs_ascii' | List of course corequisites. Multiple corequisites are concatenated together in this field. |
| Corequisites_Non_Ascii Indexed - no
Format - Varchar2(4000)
May be Null? Y
tcval.attr = 'coreqs' | This data element was de-comissioned in the Summer of 2021. No new data is being collected for this field. |
| Course_Activity_Credit_1 Indexed - no
Format - Number
May be Null? Y
tcval.attr = 'format_method'
tcval.part = 'hours_per_week' | This data element was de-comissioned in the Summer of 2021. No new data is being collected for this field. See instead the field named Schedule_Type_Hours. |
| Course_Activity_Credit_2 Indexed - no
Format - Number
May be Null? Y
tcval.attr = 'format_method'
tcval.part = 'hours_per_week' | This data element was de-comissioned in the Summer of 2021. No new data is being collected for this field. See instead the field named Schedule_Type_Hours. |
| Course_Activity_Credit_3 Indexed - no
Format - Number
May be Null? Y
tcval.attr = 'format_method'
tcval.part = 'hours_per_week' | This data element was de-comissioned in the Summer of 2021. No new data is being collected for this field. See instead the field named Schedule_Type_Hours. |
| Course_Attributes Indexed - no
Format - Number
May be Null? Y
tcval.attr = 'course_attributes'
tcval.part = 'hours_per_week' | This field is populated from a drop-down pick list in the Course Leaf application (Curriculum Management system). Multiple attributes can be associated with a course. All attribute values selected are concatenated into one field in the cm_course_current_proposal table. |
| Course_Currency Indexed - no
Format - Varchar2(800)
May be Null? Y
tcval.attr = '' | The Penn type of course credit used. Most schools at Penn use "CU" (Credit Units) which are also the same as Banner credit units. Exceptions are the Law School, which uses "SH" (Semester Hours), and the Dental and Veterminary schools, which use "CR" (credit hours). If this field is null, assume "CU". |
| Course_Curr_Prop_Id Indexed - yes
Format - Number
May be Null? N | Primary key to the warehouse table. System-generated; does not come from the source system. |
| Course_Frequency Indexed - no
Format - Varchar2(800)
May be Null? Y
tcval.attr = 'course_frequency' | Code that identifies when the course is usually offered. Information only -- does not impact when a course can actually be offered for enrollment. Examples of values: EOT Every Other Term
EOY Every Other Year
ET Every Term
OT Other |
| Course_Id Indexed - no
Format - Varchar2(800)
May be Null? Y | The identifying subject and course number. Format: the first four positions are for the Subject, and positions 5 to the end are the number. Examples: ECON0100, CIS 0100, BE 0100 |
| Course_Level Indexed - no
Format - Varchar2(800)
May be Null? Y
tcval.attr = 'acad_level' | This data element was de-comissioned in the Summer of 2021. No new data is being collected for this field.
|
| Course_Num Indexed - no
Format - Varchar2(800)
May be Null? Y | The number that, when associated with the subject area, identifies the course. |
| Credit_Type Indexed - no
Format - Varchar2(800)
May be Null? Y
tcval.attr = 'credit_type' | The native Penn currency type. Values are CU = Course Units, CR = Credits (used by the Dental and Vet schools) and SH = Semester Hours (used by the Law School) |
| Credit_Connector Indexed - no
Format - Varchar2(200)
May be Null? Y
tcval.attr = 'credit_connector' | This data element was de-comissioned in the Summer of 2021. No new data is being collected for this field. See new field: Credits. |
| Credits Indexed - no
Format - Varchar2(200)
May be Null? Y
tcval.attr = 'credits' | Indicates the number of Banner Credits for which the course may be offered. In the case of variable credit courses, the min and max credits will both be listed, separated by a comma. |
| Department Indexed - no
Format - Varchar2(4000)
May be Null? Y
tcval.attr = 'department' | The code for the academic department that administers the course. |
| Description Indexed - no
Format - Varchar2(4000)
May be Null? Y
tcval.attr = 'description_ascii' | Text description of the course in a standard format (contains only ascii characters) |
| Description_Non_Ascii Indexed - no
Format - Varchar2(4000)
May be Null? Y
tcval.attr = 'description' | Text desctiption of the course in the format used by CourseLeaf source system; may contain non-ascii characters. |
| Distance_Learning Indexed - no
Format - Varchar2(4000)
May be Null? Y
tcval.attr = 'distance_learning' | Flag indicating whether the course will be used for distance learning. |
| Exams Indexed - no
Format - Varchar2(4000)
May be Null? Y
tcval.attr = 'exams' | Text describing exams expected by the course. |
| First_Time_Offering Indexed - no
Format - Varchar2(4000)
May be Null? Y
tcval.attr = 'first_time_offering' | Flag indicating whether this proposal is for a new (first time offered) course. A value of 'Y' indicates it is a new course. |
| Grade_Mode Indexed - no
Format - Varchar2(800)
May be Null? Y
tcval.attr = 'grade_mode' | This data element was de-comissioned in the Summer of 2021. No new data is being collected for this field. |
| Hours_Per_Week Indexed - no
Format - Number
May be Null? Y
tcval.attr = 'hours_week' | The number of hours per week the course typically meets. Information only; this proposal field does not enforce meeting times for course sections. |
| Instructor_Name Indexed - no
Format - Varchar2(800)
May be Null? Y
tcval.attr = 'instructor_name' | The name of the instructor who typically teaches the course. Information only; section offerings may be taught by other instructors. |
| Instructor_Objectives Indexed - no
Format - Varchar2(4000)
May be Null? Y
tcval.attr = 'instruct_objectives' | Optional. The stated course objectives as entered with the course proposal in the curriculum management source system. |
| Instructor_Rank Indexed - no
Format - Varchar2(800)
May be Null? Y
tcval.attr = 'instructor_rank' | A ranking category for the instructor as assigned by the Curriculum Management source system. Note: this is not the same as any faculty ranking in the payroll or FIS databases. Examples of values: FTL, PTL, AJ, Lecturer B, Other |
| Instructor_Status Indexed - no
Format - Varchar2(4000)
May be Null? Y
tcval.attr = 'instructor_status' | The instructor status as assigned by the Curriculum Management source system. Note: this is not the same as any faculty status in the payroll or FIS databases. Examples of values: 1 (Standing Faculty), 2 (Adjunct Faculty), 3 (Full Time Lecturer), 4 (Part Time Lecturer), etc. |
| Last_Refresh_Date Indexed - no
Format - Date
May be Null? Y | The date the record in the Data Warehouse was last refreshed from the source. |
| Last_Term_Offered Indexed - no
Format - Varchar2(4000)
May be Null? Y
tcval.attr = 'last_eff_term' | For courses that are ending, the last term the course can be offered for enrollment. |
| Latest_Action_Date Indexed - no
Format - Date
May be Null? Y
tsoaction.actiontime
| Date action was taken in Curriculum Management source system.
|
| Legacy_Course_Num Indexed - no
Format - Varchar2(800)
May be Null? Y | The number in legacy SRS format that, when associated with the subject area, identifies the course. |
| Legacy_Last_Term_Offered Indexed - no
Format - Varchar2(20)
May be Null? Y | For courses that are ending, the last term the course can be offered for enrollment, in legacy SRS format. |
| Legacy_School Indexed - no
Format - Varchar2(800)
May be Null? Y | School that offers and manages the course, in the legacy SRS code. |
| Long_Title Indexed - no
Format - Varchar2(4000)
May be Null? Y
tcval.attr = 'long_title_ascii' | Text for the long title of the course in a standard format (contains only ascii characters). |
| Long_Title_Non_Ascii Indexed - no
Format - Varchar2(4000)
May be Null? Y
tcval.attr = 'long_title' | Text for the long title of the course in the format used by CourseLeaf source system; may contain non-ascii characters. |
| Max_Credit Indexed - no
Format - Varchar2 (200)
May be Null? Y
derived from tcval.attr = 'credits' | This data element was de-comissioned in the Summer of 2021. No new data is being collected for this field. See new field: Credits. |
| Min_Credit Indexed - no
Format - Varchar2(200)
May be Null? Y
derived from tcval.attr = 'credits' | This data element was de-comissioned in the Summer of 2021. No new data is being collected for this field. See new field: Credits. |
| Multi_Term_YN Indexed - no
Format - Varchar2(200)
May be Null? Y
tcval.attr = 'multi_term_yn' | A 'Y' in this field indicates the course will be offered across multiple terms. |
| Multi_Term_Details Indexed - no
Format - Varchar2(200)
May be Null? Y
tcval.attr = 'multi_term_details' | Text details about the multi-term course. |
| Mutual_Exclude Indexed - no
Format - Varchar2(200)
May be Null? Y
tcval.attr = 'mutually_exclusive' | A course that has been identified as multually exclusive of the course in this record: the two are close in content, and thus students may not take both for credit. The text format for this field is Subject and Course Number with a space in-between. |
| Other_Requirements Indexed - no
Format - Varchar2(4000)
May be Null? Y
tcval.attr = 'other_requirements' | Text description of course requirements, if any, that are not described in prereqs, coreqs, etc. |
| Papers_Assigned Indexed - no
Format - Varchar2(4000)
May be Null? Y
tcval.attr = 'papers_assigned' | Information about the work typically assigned in the course. |
| Path_Id_Number Indexed - no
Format - Varchar2(800)
May be Null? Y
derived from pages.path | Internal CourseLeaf identifying number, for locating the record in the source system. |
| Prerequisites Indexed - no
Format - Varchar2(4000)
May be Null? Y
tcval.attr = prereqs_ascii | This data element was de-comissioned in the Summer of 2021. No new data is being collected for this field. Replaced by Banner_Prereqs and Banner_Prereqs_CL. |
| Prerequisites_Non_Ascii Indexed - no
Format - Varchar2(4000)
May be Null? Y
tcval.attr = 'prereqs' | This data element was de-comissioned in the Summer of 2021. No new data is being collected for this field. Replaced by Banner_Prereqs and Banner_Prereqs_CL. |
| Proposal_Id Indexed - no
Format - Number
May be Null? Y | Internal Data Warehouse identification number for the proposal. Used to join this table to other tables in the Curriculum Management data collection. |
| Proposal_History_Id Indexed - no
Format - Number
May be Null? Y | Internal Data Warehouse number used to join this table to the history key table in the Curriculum Management data collection. |
| Rationale_for_change Indexed - no
Format - Varchar2(4000)
May be Null? Y
tcval.attr = 'rationale_for_change' | Text description of the reason given by the proposer for the proposed change to this course. |
| Reg_Restriction Indexed - no
Format - Varchar2(4000)
May be Null? Y
tcval.attr = 'restrictions' | Code identifying the registration restrictions that should be enforced when this course is used in scheduled sections. Note that this is an internal Curriculum Management code, and not a code used by the Pennant Records Banner database. As-of summer 2019, these codes are still under development, and the list of valid values is not yet available. |
| Schedule_Type_Hours Indexed - no
Format - Varchar2(4000)
May be Null? Y
tcval.attr = 'schedule_type_hours' | Contains the schedule type (formerely known as activity type) that the course may be offered in, such as "LEC", "LAB", "REC", "CLN", "IND", etc., and the contact hours per week associated with each schedule type. |
| Scheduling_Priority Indexed - no
Format - Varchar2(4000)
May be Null? Y
tcval.attr = 'scheduling_priority' | Code for the Advance Registration scheduling priority rule. Examples of valid values: 'A' (Undergrad seniority and major preference), 'B' (Undergrad major preference), 'C' (Undergrad seniority preference), 'O' (LPS preference then A), etc. |
| School Indexed - no
Format - Varchar2(800)
May be Null? Y
derived from dwcat_cm.subject_dept_school | School that offers and manages the course |
| Session_Duplicate Indexed - no
Format - Varchar2(4000)
May be Null? Y | Flag indicating whether the course can be taken multiple times in the same term |
| Short_Title Indexed - no
Format - Varchar2(4000)
May be Null? Y
tcval.attr = 'short_title_ascii' | Text for the abbreviated title (max 30 characters) of the course, in standard format (ascii characters only). |
| Short_Title_Non_Ascii Indexed - no
Format - Varchar2(4000)
May be Null? Y
tcval_attr = 'short_title' | Text for the abbreviated title (max 30 characters) of the course in source system format. May contain non-ascii characters. |
| Subject Indexed - no
Format - Varchar2(800)
May be Null? Y
tcval.attr = subject' | Code for the subject area of the course. Subject area, along with course number, identifies the course. |
| Term_Offered Indexed - no
Format - Varchar2(4000)
May be Null? Y
tcval.attr = 'term_offered' | Code for the term or terms that the course is typically offered. Examples of values:
A Course usually offered in Fall term
B Course usually offered in spring term
C One-term course offered either term
D Two Term - Enter Either/Credit Either
E Two Term - Enter First/Credit After Both
F Two Term - Enter Either/Credit After Both
G Two Term - Enter First/Credit NC 2nd Term
H Course offered fall; even-numbered years
I Course offered fall; odd-numbered years
J Course offered spring; even-numbered years
K Course offered spring; odd-numbered years
L Course usually offered summer term only
M Course not offered every year
S Course offered summer, fall and spring terms |
| Xlist_Also_Offered_As_1 Indexed - no
Format - Varchar2(4000)
May be Null? Y | For courses that are cross-listed with other courses at the same level, this is the Course_ID of the first of up to 5 courses that the course can also be offered as. |
| Xlist_Also_Offered_As_2 Indexed - no
Format - Varchar2(4000)
May be Null? Y | For courses that are cross-listed with other courses at the same level, this is the Course_ID of the second of up to 5 courses that the course can also be offered as. |
| Xlist_Also_Offered_As_3 Indexed - no
Format - Varchar2(4000)
May be Null? Y | For courses that are cross-listed with other courses at the same level, this is the Course_ID of the third of up to 5 courses that the course can also be offered as. |
| Xlist_Also_Offered_As_4 Indexed - no
Format - Varchar2(4000)
May be Null? Y | For courses that are cross-listed with other courses at the same level, this is the Course_ID of the fourth of up to 5 courses that the course can also be offered as. |
| Xlist_Also_Offered_As_5 Indexed - no
Format - Varchar2(4000)
May be Null? Y | For courses that are cross-listed with other courses at the same level, this is the Course_ID of the fifth of up to 5 courses that the course can also be offered as. |
| Xlist_Primary_Course Indexed - no
Format - Varchar2(800)
May be Null? Y | For courses that are cross-listed, this will be the Course_ID of the primary course. |
| Xlist_P_Or_S Indexed - no
Format - Varchar2(4000)
May be Null? Y | For courses that are cross-listed with other courses at the same level, this indicator will be 'P' if the course on this row is considered the "Primary" course, else it will be "S" for "Secondary" |
