Penn Computing

University of Pennsylvania
Penn Computing << go backback
COURSE Table . Pennant Student Records Home . Data Warehouse Home

COURSE Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.

  • Long_Title
  • Max_Credit
  • Max_Credit_Bu
  • Min_Credit
  • Min_Credit_Bu
  • Num_Duration_Unit_Ext
  • Oth_Max_Credit
  • Oth_Max_Cred_Bu
  • Oth_Min_Cred
  • Oth_Min_Credit_Bu
  • Oth_Var_Cred_Ind
  • Prereq_Check_Method
  • Prereq_Check_Method_Desc
  • Prereq_Waiv_Code
  • Pri_Sec_Ind
  • Refresh_Date
  • Repeat_Limit
  • Repeat_Status
  • Sched_Priority_Rule
  • Sched_Priority_Rule_Desc
  • School
  • Subject
  • Supp_Activity_Date
  • Syln_Activity_Date
  • Term
  • Terms_Offered
  • Terms_Offered_Desc
  • Title
  • Topics_Course_Flag
  • Tuition_Exempt_Ind
  • Var_Credit_Ind
  • Xlist_Family
  • Data element Definition
    Active_Flag

    Indexed - no
    Format - Varchar2(1)
    May be Null? Y

    Flag indicating whether a course record is currently active. A=Active, I=Inactive. Source field: SCBCRSE_CSTA_CODE.

    Add_Fees_Ind

    Indexed - no
    Format - Varchar2(1)
    May be Null? Y

    Indicates additional fees, outside of SFARGFE assessment rules, can be assessed on this course. Source field: SCBCRSE_ADD_FEES_IND.

    Bill_Max_Cred

    Indexed - no
    Format - Number
    May be Null? Y

    For billing purposes, the maximum number of credits, converted into Penn currency, based on the CREDIT_TYPE.

    Bill_Max_Credit_Bu

    Indexed - no
    Format - Number
    May be Null? Y

    For billing purposes, the maximum number of credits, stored in Banner Units (BU). If the VAR_FIXED_CREDIT value is Fixed, the MIN_CREDIT will be the same as the MAX_CREDIT. Source field: SCBCRSE_BILL_HR_HIGH.

    Bill_Min_Cred

    Indexed - no
    Format - Number
    May be Null? Y

    For billing purposes, the minimum number of credits, converted into Penn currency, based on the CREDIT_TYPE.

    Bill_Min_Credit_Bu

    Indexed - no
    Format - Number
    May be Null? Y

    For billing purposes, the minimum number of credits, stored in Banner Units (BU). If the VAR_FIXED_CREDIT value is Fixed, the MIN_CREDIT will be the same as the MAX_CREDIT. Source field: SCBCRSE_BILL_HR_MIN.

    Bill_Var_Cred

    Indexed - no
    Format - Varchar2(2)
    May be Null? Y

    For credit that is part of the billing calculation, this field indicates whether the course will be offered for a fixed number of credits, or a variable number of credits, or any number of credits within a defined range. Source field: SCBCRSE_BILL_HR_IND.

    Catalog_End_Term

    Indexed - no
    Format - Varchar2(6)
    May be Null? Y

    This is the To Term of the latest version of the course. If changed to an earlier or later term, all To Terms for all versions of this course will change to end in this term. It cannot be earlier than a term where sections are scheduled. Source field: SCBCRKY_TERM_CODE_END.

    Catalog_Print_Flag

    Indexed - no
    Format - Varchar2(1)
    May be Null? Y

    Indicates whether or not the course should appear in the public view of the Course Catalog. Values are Y = Print in the catalog, N = Do not print in the catalog. Source field: SCBSUPP_CUDE. Source validation table: STVCUDE.

    Catalog_Start_Term

    Indexed - no
    Format - Varchar2(6)
    May be Null? Y

    This is the From Term of the earliest version of the course. If changed to earlier or later term, all From Terms change for all versions of this course to begin in this term. It cannot be later than a term where sections are scheduled. Source field: SCBCRKY_TERM_CODE_START.

    Contact_Hours_High

    Indexed - no
    Format - Number
    May be Null? Y

    This column contains the sum of high lecture, lab and others hours columns. It functions the same as the cont_hr_low column. A value may only be entered if the OR/TO field is entered and must be greated than contact hours low. Stored in this field in native Penn currency, based on the CREDIT_TYPE.

    Contact_Hours_Ind

    Indexed - no
    Format - Varchar2(2)
    May be Null? Y

    This column contains the literal TO or OR to define the relationship between the low and high contact hours. Source field: SCBCRSE_CONT_HR_IND.

    Contact_Hours_Low_Bu

    Indexed - no
    Format - Number
    May be Null? Y

    This column contains the sum of low lecture, lab and others hours columns. Contact hours divided by 10 are the continuing education units for a continuing ed course. This calculated value is stored in the credit hour field when the ceu_ind = Y. Stored in this column in Banner Units (BU). Source field: SCBCRSE_CONT_HR_LOW.

    Continuing_Ed_Ind

    Indexed - no
    Format - Varchar2(1)
    May be Null? Y

    Flag indicating whether the course can count as a Continuing Education unit. Source field: SCBCRSE_CEU_IND.

    Course_Admin_Code

    Indexed - no
    Format - Varchar2(15)
    May be Null? Y

    This field is derived from a course attribute that contains "-ADMIN-" in the lookup table of the attribute code. Identifies administrative units associated with a course. Currently used by only some schools at Penn. Source field: SCRATTR_ATTR_CODE

    Course_Admin_Desc

    Indexed - no
    Format - Varchar2(30)
    May be Null? Y

    Description of the Course Admin (attribute) code. Source: STVATTR_DESC

    Course_Clasif_Level

    Indexed - no
    Format - Varchar2(2)
    May be Null? Y

    The group level or classification to which the course belongs, for example, 1=Introductory, 2=Intermediate, 3=Advanced, 4=Graduate. Caution: This should not be confused with the Level at which the course is offered (see CRSE_LEVEL table) . Source field: SCBSUPP_CCSL_CODE. Source validation table: STVCCSL. Data Warehouse validation table: V_CRSE_CCSL

    Course_Clasif_Level_Desc

    Indexed - no
    Format - Varchar2(30)
    May be Null? Y

    Description of the Course Clasif Level code.

    Course_Id

    Indexed - no
    Format - Varchar2(9)
    May be Null? Y

    Subject area and course number put together in one field (no spaces added).

    Course_Num

    Indexed - no
    Format - Varchar2(5)
    May be Null? Y

    Part of the unique identifer of a course: the course number and subject area, along with the effective term, uniquely identify a course. Most course numbers consist of 4 digits. Courses that are multi-term will also have an alpha character following the number. Source field: SCBCRSE_CRSE_NUMB.

    Course_Pk

    Indexed - yes
    Format - Varchar2(15)
    May be Null? N

    Internal warehouse primary key, based on the subject code, course number, and term.

    Credit_Type

    Indexed - no
    Format - Varchar2(15)
    May be Null? Y

    Derived field, indicating the Penn course currency. All courses in Banner will be stored in Banner units, but Penn recognizes different "native" currencies: CU (credit unit: 1 CU = 1 Banner unit, CR (credits, used by Dental School): 6 CR = 1 Banner unit, and SH (semester hours, used by Law School): 3 SH = 1 Banner unit. Data Warehouse validation table: V_NATIVE CURRENCY.

    Crky_Activity_Date

    Indexed - no
    Format - Date
    May be Null? Y

    The latest date the course information was updated in the source table SCBCRKY

    Crse_Activity_Date

    Indexed - no
    Format - Date
    May be Null? Y

    The latest date the course information was updated in the source table SCBCRSE

    Department

    Indexed - no
    Format - Varchar2(4)
    May be Null? Y

    Four character code for the department that administers the course. Source field: SCBCRSE_DEPT_CODE. Source validation table: STVDEPT. Data Warehouse validation table: V_DEPARTMENT.

    Duration_Unit

    Indexed - no
    Format - Varchar2(4)
    May be Null? Y

    Indicates the type of duration the course is offered for, for example weeks, or months. Source field: SCBCRSE_DUNT_CODE. Source validation: STVDUNT.

    Effective_Term

    Indexed - no
    Format - Varchar2(6)
    May be Null? Y

    First term of this version of this course record. In the source system, courses are stored by effective term. In the warehouse, courses are stored term-by-term, and we also include the effective term for reference. Source field: SCBCRSE_EFF_TERM. Source validation table: STVTERM. Data Warehouse validation table: V_TERM.

    First_Time_Offered

    Indexed - no
    Format - Varchar2(1)
    May be Null? Y

    Catalog Approval code. At Penn, this is used to indicate a course is approved as "First Time Offered" with a value of 'F' in this column. Source field: SCBCRSE_APRV_CODE. Source validation table: STVAPRV.

    Lab_Max_Cred

    Indexed - no
    Format - Number
    May be Null? Y

    Maximum number of credits that can be earned by taking the lab section of this course (if exists), converted into Penn currency, based on the CREDIT_TYPE.

    Lab_Max_Credit_Bu

    Indexed - no
    Format - Number
    May be Null? Y

    The maximum number of credits that can be earned by taking the lab section of this course (if exists), stored in Banner Units (BU). If the VAR_FIXED_CREDIT value is Fixed, the MIN_CREDIT will be the same as the MAX_CREDIT. Source field: SCBCRSE_LAB_HR_HIGH.

    Lab_Min_Cred

    Indexed - no
    Format - Number
    May be Null? Y

    Minimum number of credits that can be earned by taking the lab section of this course (if exists), converted into Penn currency, based on the CREDIT_TYPE.

    Lab_Min_Credit_Bu

    Indexed - no
    Format - Number
    May be Null? Y

    The minimum number of credits that can be earned by taking the lab section of this course (if exists), stored in Banner Units (BU). If the VAR_CREDIT_IND value is Fixed, the MIN_CREDIT will be the same as the MAX_CREDIT. Source field: SCBCRSE_LAB_HR_LOW.

    Lab_Var_Cred_Ind

    Indexed - no
    Format - Varchar2(2)
    May be Null? Y

    Indicates whether the lab section of this course (if exists) will be offered for a fixed number of credits, or a variable number of credits, or any number of credits within a defined range. Source field: SCBCRSE_LAB_HR_IND.

    Lec_Max_Cred

    Indexed - no
    Format - Number
    May be Null? Y

    Maximum number of credits that can be earned by taking the lecture section of this course (if exists), converted into Penn currency, based on the CREDIT_TYPE.

    Lec_Max_Credit_Bu

    Indexed - no
    Format - Number
    May be Null? Y

    The maximum number of credits that can be earned by taking the lecture section of this course (if exists), stored in Banner Units (BU). If the VAR_FIXED_CREDIT value is Fixed, the MIN_CREDIT will be the same as the MAX_CREDIT. Source field: SCBCRSE_LEC_HR_HIGH.

    Lec_Min_Cred

    Indexed - no
    Format - Number
    May be Null? Y

    Minimum number of credits that can be earned by taking the lecture section of this course (if exists), converted into Penn currency, based on the CREDIT_TYPE.

    Lec_Min_Credit_Bu

    Indexed - no
    Format - Number
    May be Null? Y

    The minimum number of credits that can be earned by taking the lecture section of this course (if exists), stored in Banner Units (BU). If the VAR_CREDIT_IND value is Fixed, the MIN_CREDIT will be the same as the MAX_CREDIT. Source field: SCBCRSE_LEC_HR_LOW.

    Lec_Var_Cred_Ind

    Indexed - no
    Format - Varchar2(2)
    May be Null? Y

    Indicates whether the lecture section of this course (if exists) will be offered for a fixed number of credits, or a variable number of credits, or any number of credits within a defined range. Source field: SCBCRSE_LEC_HR_IND.

    Long_Title

    Indexed - no
    Format - Varchar2(100)
    May be Null? Y

    Text of the long title for the course. Source field: SCRSYLN_LONG_COURSE_TITLE.

    Max_Credit

    Indexed - no
    Format - Number
    May be Null? Y

    Maximum number of credits that can be earned by taking this course, converted into Penn currency, based on the CREDIT_TYPE.

    Max_Credit_Bu

    Indexed - no
    Format - Number
    May be Null? Y

    The maximum number of credits that can be earned by taking this course, stored in Banner Units. If the VAR_CREDIT_IND value is Fixed, the MIN_CREDIT will be the same as the MAX_CREDIT. Source field: SCBCRSE_CREDIT_HR_HIGH.

    Min_Credit

    Indexed - no
    Format - Number
    May be Null? Y

    Minimum number of credits that can be earned by taking this course, converted into Penn currency, based on the CREDIT_TYPE.

    Min_Credit_Bu

    Indexed - no
    Format - Number
    May be Null? Y

    The minimum number of credits that can be earned by taking this course, stored in Banner units. If the VAR_FIXED_CREDIT value is Fixed, the MIN_CREDIT will be the same as the MAX_CREDIT. Source field: SCBCRSE_CREDIT_HR_LOW.

    Num_Duration_Unit_Ext

    Indexed - no
    Format - Number
    May be Null? Y

    Indicates the total number of times the duration unit extends. Source field: SCBCRSE_NUMBER_OF_UNITS.

    Oth_Max_Credit

    Indexed - no
    Format - Number
    May be Null? Y

    Maximum number of credits that can be earned by taking sections of this course that are something other than lecure or lab, converted into Penn currency, based on the CREDIT_TYPE.

    Oth_Max_Cred_Bu

    Indexed - no
    Format - Number
    May be Null? Y

    The maximum number of credits that can be earned by taking the sections of this course that are something other than lecure or lab, stored in Banner Units (BU). If the VAR_FIXED_CREDIT value is Fixed, the MIN_CREDIT will be the same as the MAX_CREDIT. Source field: SCBCRSE_OTH_HR_HIGH.

    Oth_Min_Cred

    Indexed - no
    Format - Number
    May be Null? Y

    Minimum number of credits that can be earned by taking sections of this course that are something other than lecure or lab, converted into Penn currency, based on the CREDIT_TYPE.

    Oth_Min_Credit_Bu

    Indexed - no
    Format - Number
    May be Null? Y

    The minimum number of credits that can be earned by taking the sections of this course that are something other than lecure or lab, stored in Banner Units (BU). If the VAR_CREDIT_IND value is Fixed, the MIN_CREDIT will be the same as the MAX_CREDIT. Source field: SCBCRSE_OTH_HR_LOW.

    Oth_Var_Cred_Ind

    Indexed - no
    Format - Varchar2(2)
    May be Null? Y

    Indicates whether the sections of this course that are something other than lecure or lab will be offered for a fixed number of credits, or a variable number of credits, or any number of credits within a defined range. Source field: SCBCRSE_OTH_HR_IND.

    Prereq_Check_Method

    Indexed - no
    Format - Varchar2(1)
    May be Null? Y

    Indicates type of prerequisite checking. B = Banner basic, C = CAPP, D = Degree Works

    Prereq_Check_Method_Desc

    Indexed - no
    Format - Varchar2(30)
    May be Null? Y

    Description of the prerequisite checking method code.

    Prereq_Waiv_Code

    Indexed - no
    Format - Varchar2(1)
    May be Null? Y

    Code for the type of approval required to waive a pre-requisite. Source field: SCBCRSE_PWAV_CODE. Source validation table: STVPWAV.

    Pri_Sec_Ind

    Indexed - no
    Format - Varchar2(1)
    May be Null? Y

    Indicates whether the course is the primary (P) or the secondary (S) of the cross-listed relationship. If a course is not cross-listed, there will still be a 'P' in this field (making it the primary in a "family" of one). Parsed from the first character in the source field: SCBSUPP_PERM_DIST_IND.

    Refresh_Date

    Indexed - no
    Format - Date
    May be Null? Y

    The latest date this warehouse table was refreshed.

    Repeat_Limit

    Indexed - no
    Format - Number
    May be Null? Y

    Identifies the maximum number of times the course may be re-taken by the student. Source field SCBCRSE_REPEAT_LIMIT.

    Repeat_Status

    Indexed - no
    Format - Varchar2(2)
    May be Null? Y

    Code indicating whether the course may be repeated. Source field: SCBCRSE_REPS_CODE. Source validation table: STVREPS.

    School

    Indexed - no
    Format - Varchar2(2)
    May be Null? Y

    One character code for the school that is considered the Home School of the course. Source field: SCBCRSE_COLL_CODE. Source validation table: STVCOLL. Data Warehouse validation table: V_SCHOOL.

    Subject

    Indexed - no
    Format - Varchar2(4)
    May be Null? Y

    Subject area of the course. Source field: SCBCRSE_SUBJ_CODE. Source validation table: STVSUBJ. Data Warehouse validation table: V_SUBJECT.

    Supp_Activity_Date

    Indexed - no
    Format - Date
    May be Null? Y

    The latest date the course information was updated in the source table SCBSUPP

    Syln_Activity_Date

    Indexed - no
    Format - Date
    May be Null? Y

    The latest date the course information was updated in the source table SCRSYLN

    Term

    Indexed - no
    Format - Varchar2(6)
    May be Null? Y

    A term in which this course version is in effect. The term-effective records in the source are turned into term-by-term records in the Data Warehouse extract/load process.

    Terms_Offered

    Indexed - no
    Format - Varchar2(15)
    May be Null? Y

    Code for the term or terms in which the course is typically offered. Source field: SCBSUPP_CUDE. Source validation table: STVCUDE. Data Warehouse validation table: V_CRSE_TERMS_OFFR.

    Terms_Offered_Desc

    Indexed - no
    Format - Varchar2(30)
    May be Null? Y

    Description of the Terms Offered code. Source: STVCUDE_DESC.

    Title

    Indexed - no
    Format - Varchar2(30)
    May be Null? Y

    Text of the course title, also sometimes called "Short Title." Source field: SCBCRSE_TITLE.

    Topics_Course_Flag

    Indexed - no
    Format - Varchar2(15)
    May be Null? Y

    Code indicating whether or not the course is a "topics course." Values are T = Topics, U = No topics. Source field: SCBSUPP_CUDC. Source validation table: STVCUDC.

    Tuition_Exempt_Ind

    Indexed - no
    Format - Varchar2(1)
    May be Null? Y

    Definition tbd. Source field: SCBCRSE_TUIW_IND.

    Var_Credit_Ind

    Indexed - no
    Format - Varchar2(2)
    May be Null? Y

    Indicates whether the course will be offered for a fixed number of credits, or a variable number of credits, or any number of credits within a defined range. Source field: SCBCRSE_CREDIT_HR_IND.

    Xlist_Family

    Indexed - no
    Format - Varchar2(12)
    May be Null? Y

    Code that identifies the group, or "family" of cross-listed courses. If a course is not cross-listed, there will still be a value in this field (making it a "family" of one). Parsed from the source field: SCBSUPP_PERM_DIST_IND.

    Sched_Priority_Rule

    Indexed - no
    Format - Varchar2(15)
    May be Null? Y

    Code that identifies the prioritization rule that will be applied to student requests for a scheduled section of the course during advance registration. Source: SCBSUPP_CUDF_CODE.

    Sched_Priority_Rule_Desc

    Indexed - no
    Format - Varchar2(30)
    May be Null? Y

    Description of the Sched_Priority_Rule code. Source: STVCUDF_DESC.

    COURSE Table . Pennant Student Records 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