Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Student Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: COURSE_CATALOG

Description Contains details for a subject (course) offered as part of the instruction in an academic study program. Details tracked will be specific to each academic period for which the subject could be offered. Academic periods will end when the course has an end academic period or when the status associated with the subject makes it not available to be scheduled.
Key & Frequency One row per subject and course number per academic period in which the course was active.
Recommended Search Columns SUBJECT, COURSE_NUMBER
ACADEMIC_PERIOD

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Academic period or time frame associated with this course record. VARCHAR2(63)

SCBCRSE

SCBCRSE_EFF_TERM

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ACADEMIC_YEAR Academic year associated with the academic period on this record. VARCHAR2(63)

FUNCTION

GOKODSF.F_GET_DESC

ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ACTIVE_COURSE_IND Indicates whether the course is active and may have sections scheduled. VARCHAR2(1)

FUNCTION

F_ACTIVE_COURSE_IND

ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

ATTRIBUTE_COUNT Count of course degree attributes recorded for the course. NUMBER

FUNCTION

MSKFUNC.F_COUNT_COURSE_ATTRIBUTES

BILLING_IND Indicates whether the course can be billed for variable credit. Used to specify the relationship between the low and high billing values. An Or/To value must exist in order to enter a value in the CEU/Credits high field. VARCHAR2(2)

SCBCRSE

SCBCRSE_BILL_HR_IND

BILLING_MAX Defines the second valid billing value or the high billing value within a range. NUMBER

SCBCRSE

SCBCRSE_BILL_HR_HIGH

BILLING_MIN Defines the first valid billing value or the low billing value within a range. NUMBER

SCBCRSE

SCBCRSE_BILL_HR_LOW

COLLEGE College, faculty or school to which the course instructional responsibility is associated. VARCHAR2(63)

SCBCRSE

SCBCRSE_COLL_CODE

COLLEGE_DESC College, faculty or school name. VARCHAR2(255)

STVCOLL

STVCOLL_DESC

CONTACT_IND Identifies whether there is a range of contact hours or a specific variable number or an additional number. VARCHAR2(2)

SCBCRSE

SCBCRSE_CONT_HR_IND

CONTACT_MAX High number of lecture, lab, and others contact hour value for the course. NUMBER

SCBCRSE

SCBCRSE_CONT_HR_HIGH

CONTACT_MIN Low number of lecture, lab, and others contact hour value for the course. NUMBER

SCBCRSE

SCBCRSE_CONT_HR_LOW

CONTINUING_EDUCATION_IND Indicates whether the course earns continuing education units instead of credits. VARCHAR2(1)

SCBCRSE

SCBCRSE_CEU_IND

COOPERATIVE_EDUCATION_IND Indicates this is a cooperative education course. VARCHAR2(1)

SCBSUPP

SCBSUPP_COOP_ED_IND

COURSE_APPROVAL Type of requirements this course is approved to fulfill. VARCHAR2(63)

SCBCRSE

SCBCRSE_APRV_CODE

COURSE_APPROVAL_DESC Description for the type of requirement fulfilled by this course. Included may be degree, certificate, etc. VARCHAR2(255)

STVAPRV

STVAPRV_DESC

COURSE_CLASSIFICATION Classification code associated with this course. Code used to group courses together for reporting. VARCHAR2(63)

SCBSUPP

SCBSUPP_CCSL_CODE

COURSE_CLASSIFICATION_DESC Description for the course classification. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

COURSE_CLASS_LEVEL Expected class (first year, second year, etc.) the enrollee is in when taking a course. VARCHAR2(63)

NA

NA

COURSE_CLASS_LEVEL_DESC Class level code description. VARCHAR2(255)

NA

NA

COURSE_COREQ_COUNT Count of the number of course corequisites recorded for this course. NUMBER

FUNCTION

MSKFUNC.F_COUNT_COURSE_COREQ

COURSE_CREDIT_CATEGORY Code used for some types of governmental reporting. For Example, California MIS process for field CB22. VARCHAR2(5)

SCBSUPP

SCBSUPP_CREDIT_CATEGORY_IND

COURSE_DURATION Normal course length or weeks of instruction in the duration units listed. VARCHAR2(255)

SCBCRSE

SCBCRSE_DUNT_CODE

COURSE_IDENTIFICATION Combined subject code and course number that identifies the instructional content of this course. VARCHAR2(255)

CALCULATION

SCBCRSE_SUBJ_CODE||SCBCRSE_CRSE_NUMB

COURSE_INFO1 Institution defined reporting code for course element 1 information or characteristic. VARCHAR2(63)

SCBSUPP

SCBSUPP_CUDA_CODE

COURSE_INFO2 Institution defined reporting code for course element 2 information or characteristic. VARCHAR2(63)

SCBSUPP

SCBSUPP_CUDB_CODE

COURSE_INFO3 Institution defined reporting code for course element 3 information or characteristic. VARCHAR2(63)

SCBSUPP

SCBSUPP_CUDC_CODE

COURSE_INFO4 Institution defined reporting code for course element 4 information or characteristic. VARCHAR2(63)

SCBSUPP

SCBSUPP_CUDD_CODE

COURSE_INFO5 Institution defined reporting code for course element 5 information or characteristic. VARCHAR2(63)

SCBSUPP

SCBSUPP_CUDE_CODE

COURSE_INFO6 Institution defined reporting code for course element 6 information or characteristic. VARCHAR2(63)

SCBSUPP

SCBSUPP_CUDF_CODE

COURSE_LEVEL_COUNT Count of the number of levels authorized for this course. Include may be undergraduate and graduate, etc. NUMBER

FUNCTION

MSKFUNC.F_COUNT_COURSE_LEVEL

COURSE_NUMBER Course number associated with the subject for the course. VARCHAR2(63)

SCBCRSE

SCBSUPP

SCBCRSE_CRSE_NUMB

SCBSUPP_CRSE_NUMB

COURSE_PREREQS_COUNT Count of the number of pre-requisites listed for this course. NUMBER

FUNCTION

F_CHECK_FOR_COURSE_PREREQS

COURSE_TEXT_NARRATIVE Text developed at the institution to describe the course and course content. CLOB

SCBDESC

SCBDESC_TEXT_NARRATIVE

COURSE_VERSION Course version number. VARCHAR2(255)

NA

NA

CREDIT_IND Indicates whether the course can be offered for variable credit. The Or/To field specifies the relationship between low and high credits values. A value must exist in the Or/To field in order to enter a value in the CEU/Credits High field. VARCHAR2(2)

SCBCRSE

SCBCRSE_CREDIT_HR_IND

CREDIT_MAX Second valid credit value or the high credit value within a range of credits available for a course. NUMBER

SCBCRSE

SCBCRSE_CREDIT_HR_HIGH

CREDIT_MIN First valid credit value or the low credit value within a range of credits available for a course. NUMBER

SCBCRSE

SCBCRSE_CREDIT_HR_LOW

DEFAULT_GRADE_TYPE Indicates whether this is the default grade type for the course. VARCHAR2(63)

SCRGMOD

SCRGMOD_GMOD_CODE

DEFAULT_GRADE_TYPE_DESC Grade type description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

DEPARTMENT Department responsible the academic instruction. VARCHAR2(63)

SCBCRSE

SCBCRSE_DEPT_CODE

DEPARTMENT_DESC Department name. VARCHAR2(255)

STVDEPT

STVDEPT_DESC

DIVISION Division responsible for the instructional delivery of this course or section. VARCHAR2(63)

SCBCRSE

SCBCRSE_DIVS_CODE

DIVISION_DESC Name of the division. VARCHAR2(255)

STVDIVS

STVDIVS_DESC

DURATION_UNIT_CODE Indicates whether the course duration is in days, weeks, months, etc. VARCHAR2(255)

SCBCRSE

SCBCRSE_DUNT_CODE

FA_COUNTY_CREDITS Financial aid credits - county, which is the number of eligible credits for this course for county financial aid reporting. VARCHAR2(255)

NA

NA

FA_FEDERAL_CREDITS Financial aid credits - federal, which is the number of eligible credits for this course used for federal financial aid reporting. VARCHAR2(255)

NA

NA

FA_STATE_CREDITS Financial aid credits - state, which is the number of eligible credits used for this course for state financial aid reporting. VARCHAR2(255)

NA

NA

GRADE_TYPE_COUNT Count the number of grading types or modes for this course. NUMBER

FUNCTION

MSKFUNC.F_COUNT_GRADE_TYPE

LAB_IND Defines whether the course can be offered for variable lab hours. Connector may be an or specifying an either relationship or it may be a to specifying between the low and high lab hour values. Indicator must exist to enter low and high values. VARCHAR2(2)

SCBCRSE

SCBCRSE_LAB_HR_IND

LAB_MAX High value specified for a course that has variable lab contact hours. NUMBER

SCBCRSE

SCBCRSE_LAB_HR_HIGH

LAB_MIN Low value specified for a course that has variable lab contact hours. NUMBER

SCBCRSE

SCBCRSE_LAB_HR_LOW

LECTURE_IND Defines whether the course can be offered for variable lab hours. Connector may be an or specifying an either relationship or it may be a to specifying between the low and high lecture hour values. Indicator must exist to enter low and high values. VARCHAR2(2)

SCBCRSE

SCBCRSE_LEC_HR_IND

LECTURE_MAX High value specified for a course that has variable lecture contact hours. NUMBER

SCBCRSE

SCBCRSE_LEC_HR_HIGH

LECTURE_MIN Low value specified for a course that has variable lecture contact hours. NUMBER

SCBCRSE

SCBCRSE_LEC_HR_LOW

MAJOR First major to which the course belongs. VARCHAR2(63)

NA

NA

MAJOR_DESC Major or subject area description. VARCHAR2(255)

NA

NA

MAXIMUM_REPEAT_CREDITS Maximum number of credits permitted. NUMBER

SCBCRSE

SCBCRSE_MAX_RPT_UNITS

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NON_TRADITIONAL_IND Indicates whether the course is a non-traditional course. VARCHAR2(1)

NA

NA

NUMBER_OF_REPEATS_ALLOWED Number of course repeats allowed. NUMBER

SCBCRSE

SCBCRSE_REPEAT_LIMIT

OCCUPATIONAL_COURSE_CODE Setting of the occupational course indicator code. VARCHAR2(63)

SCBSUPP

SCBSUPP_OCCS_CODE

OCCUPATIONAL_COURSE_DESC Occupational course indicator description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

OTHER_IND Defines whether the course can be offered for variable lab hours. Connector may be an or specifying an either relationship or it may be a to specifying between the low and high other contact hour value. Indicator must exist to enter low and high values. VARCHAR2(2)

SCBCRSE

SCBCRSE_OTH_HR_IND

OTHER_MAX High value specified for a course that has variable other contact hours. NUMBER

SCBCRSE

SCBCRSE_OTH_HR_HIGH

OTHER_MIN Low value specified for a course that has variable other contact hours. NUMBER

SCBCRSE

SCBCRSE_OTH_HR_LOW

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

PROGRAM_CLASSIFICATION Program classification identifying the course major subject area used for government reporting to group subjects (courses). VARCHAR2(63)

SCBCRSE

SCBCRSE_CIPC_CODE

PROGRAM_CLASSIFICATION_DESC Program classification description. VARCHAR2(255)

STVCIPC

STVCIPC_DESC

REPEATABLE_COURSE_IND Indicates whether the course can be repeated. VARCHAR2(1)

NA

NA

REPEAT_STATUS_CODE Repeat status code used for reporting purposes. VARCHAR2(63)

SCBCRSE

SCBCRSE_REPS_CODE

REPEAT_STATUS_DESC Repeat status description. VARCHAR2(255)

STVREPS

STVREPS_DESC

REPORT_COUNTY_CREDITS Reporting credits - county, which is the number of eligible credits for this course for county reporting purposes. VARCHAR2(255)

NA

NA

REPORT_FEDERAL_CREDITS Reporting credits - federal, which is the number of eligible credits used for this course for federal reporting purposes. VARCHAR2(255)

NA

NA

REPORT_STATE_CREDITS Reporting credits - state, which is the number of eligible credits for this course for state reporting purposes. VARCHAR2(255)

NA

NA

SCHEDULE_COUNT Count of the instruction or delivery methods for this course. NUMBER

FUNCTION

MSKFUNC.F_COUNT_COURSE_SCHEDULE

STATUS Identifies the current course status. May be used to prevent the creation of sections for this course. VARCHAR2(63)

SCBCRSE

SCBCRSE_CSTA_CODE

STATUS_DESC Course status description. VARCHAR2(255)

STVCSTA

STVCSTA_DESC

SUBJECT Main instructional subject area for this course. VARCHAR2(63)

SCBCRSE

SCBSUPP

SCBCRSE_SUBJ_CODE

SCBSUPP_SUBJ_CODE

SUBJECT_DESC Subject code description. VARCHAR2(255)

STVSUBJ

STVSUBJ_DESC

TAXONOMY_OF_PROGRAM_CODE Government reporting code typically used for reporting of vocational technical courses or subjects. VARCHAR2(63)

SCBSUPP

SCBSUPP_TOPS_CODE

TAXONOMY_OF_PROGRAM_DESC Taxonomy of program code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

TITLE_LONG_DESC Long title of the course. VARCHAR2(255)

SHRTCKN

SHRTCKN_LONG_COURSE_TITLE

TITLE_SHORT_DESC Displays the course or section short title. VARCHAR2(255)

SCBCRSE

SCBCRSE_TITLE



Ver: 8.0