Reporting View Target: COURSE

Go To View:	RETURN TO BANNER ODS META DATA 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
COURSE_IDENTIFICATION

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column

ACADEMIC_PERIOD Academic Period Academic period or time frame associated with this course record. VARCHAR2(63)
SCBCRSE

SCBCRSE_EFF_TERM

ACADEMIC_PERIOD_DESC Academic Period Description Academic period description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

ACADEMIC_YEAR 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 Academic year description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

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

F_ACTIVE_COURSE_IND

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

NA

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

MSKFUNC.F_COUNT_COURSE_ATTRIBUTES

BILLING_IND Billing Indicator 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 Billing Maximum Defines the second valid billing value or the high billing value within a range. NUMBER
SCBCRSE

SCBCRSE_BILL_HR_HIGH

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

SCBCRSE_BILL_HR_LOW

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

SCBCRSE_COLL_CODE

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

STVCOLL_DESC

CONTACT_IND Contact Indicator 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 Contact Maximum High number of lecture, lab, and others contact hour value for the course. NUMBER
SCBCRSE

SCBCRSE_CONT_HR_HIGH

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

SCBCRSE_CONT_HR_LOW

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

SCBCRSE_CEU_IND

COOPERATIVE_EDUCATION_IND Cooperative Education Indicator Indicates this is a cooperative education course. VARCHAR2(1)
SCBSUPP

SCBSUPP_COOP_ED_IND

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

SCBCRSE_APRV_CODE

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

STVAPRV_DESC

COURSE_CLASSIFICATION 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 Course Classification Description Description for the course classification. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

COURSE_CLASS_LEVEL 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 Course Class Level Description Class level code description. VARCHAR2(255)
NA

NA

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

MSKFUNC.F_COUNT_COURSE_COREQ

COURSE_CREDIT_CATEGORY 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 Course Duration Normal course length or weeks of instruction in the duration units listed. VARCHAR2(255)
SCBCRSE

SCBCRSE_DUNT_CODE

COURSE_IDENTIFICATION Course ID 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 Course Information 1 Institution defined reporting code for course element 1 information or characteristic. VARCHAR2(63)
SCBSUPP

SCBSUPP_CUDA_CODE

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

SCBSUPP_CUDB_CODE

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

SCBSUPP_CUDC_CODE

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

SCBSUPP_CUDD_CODE

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

SCBSUPP_CUDE_CODE

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

SCBSUPP_CUDF_CODE

COURSE_LEVEL_COUNT 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 Course number associated with the subject for the course. VARCHAR2(63)
SCBCRSE
SCBSUPP

SCBCRSE_CRSE_NUMB
SCBSUPP_CRSE_NUMB

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

F_CHECK_FOR_COURSE_PREREQS

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

SCBDESC_TEXT_NARRATIVE

COURSE_VERSION Course Version Course version number. VARCHAR2(255)
NA

NA

CREDIT_IND Credit Indicator 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 Credit Maximum 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 Credit Minimum 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 Default Grade Type Indicates whether this is the default grade type for the course. VARCHAR2(63)
SCRGMOD

SCRGMOD_GMOD_CODE

DEFAULT_GRADE_TYPE_DESC Default Grade Type Description Grade type description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

DEPARTMENT Department Department responsible the academic instruction. VARCHAR2(63)
SCBCRSE

SCBCRSE_DEPT_CODE

DEPARTMENT_DESC Department Description Department name. VARCHAR2(255)
STVDEPT

STVDEPT_DESC

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

SCBCRSE_DIVS_CODE

DIVISION_DESC Division Description Name of the division. VARCHAR2(255)
STVDIVS

STVDIVS_DESC

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

SCBCRSE_DUNT_CODE

FA_COUNTY_CREDITS 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 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 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 Grade Type Count Count the number of grading types or modes for this course. NUMBER
FUNCTION

MSKFUNC.F_COUNT_GRADE_TYPE

LAB_IND Lab Indicator 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 Lab Maximum High value specified for a course that has variable lab contact hours. NUMBER
SCBCRSE

SCBCRSE_LAB_HR_HIGH

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

SCBCRSE_LAB_HR_LOW

LECTURE_IND Lecture Indicator 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 Lecture Maximum High value specified for a course that has variable lecture contact hours. NUMBER
SCBCRSE

SCBCRSE_LEC_HR_HIGH

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

SCBCRSE_LEC_HR_LOW

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

NA

MAJOR_DESC Major Description Major or subject area description. VARCHAR2(255)
NA

NA

MAXIMUM_REPEAT_CREDITS Maximum Repeat Credits Maximum number of credits permitted. NUMBER
SCBCRSE

SCBCRSE_MAX_RPT_UNITS

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

NA

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

NA

NON_TRADITIONAL_IND Non Traditional Indicator Indicates whether the course is a non-traditional course. VARCHAR2(1)
NA

NA

NUMBER_OF_REPEATS_ALLOWED Number Of Repeats Allowed Number of course repeats allowed. NUMBER
SCBCRSE

SCBCRSE_REPEAT_LIMIT

OCCUPATIONAL_COURSE_CODE Occupational Course Code Setting of the occupational course indicator code. VARCHAR2(63)
SCBSUPP

SCBSUPP_OCCS_CODE

OCCUPATIONAL_COURSE_DESC Occupational Course Description Occupational course indicator description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

OTHER_IND Other Indicator 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 Other Maximum High value specified for a course that has variable other contact hours. NUMBER
SCBCRSE

SCBCRSE_OTH_HR_HIGH

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

SCBCRSE_OTH_HR_LOW

PROCESS_GROUP 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 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 Program classification description. VARCHAR2(255)
STVCIPC

STVCIPC_DESC

REPEATABLE_COURSE_IND Repeatable Course Indicator Indicates whether the course can be repeated. VARCHAR2(1)
NA

NA

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

SCBCRSE_REPS_CODE

REPEAT_STATUS_DESC Repeat Status Description Repeat status description. VARCHAR2(255)
STVREPS

STVREPS_DESC

REPORT_COUNTY_CREDITS 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 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 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 Schedule Count Count of the instruction or delivery methods for this course. NUMBER
FUNCTION

MSKFUNC.F_COUNT_COURSE_SCHEDULE

STATUS 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 Status Description Course status description. VARCHAR2(255)
STVCSTA

STVCSTA_DESC

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

SCBCRSE_SUBJ_CODE
SCBSUPP_SUBJ_CODE

SUBJECT_DESC Subject Description Subject code description. VARCHAR2(255)
STVSUBJ

STVSUBJ_DESC

TAXONOMY_OF_PROGRAM_CODE 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 Description Taxonomy of program code description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

TITLE_LONG_DESC Title Long Description Long title of the course. VARCHAR2(255)
SCRSYLN

SCRSYLN_LONG_COURSE_TITLE

TITLE_SHORT_DESC Title Short Description Displays the course or section short title. VARCHAR2(255)
SCBCRSE

SCBCRSE_TITLE

Ver: 9.0

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 COURSE_IDENTIFICATION

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	Academic Period	Academic period or time frame associated with this course record.	VARCHAR2(63)	SCBCRSE	SCBCRSE_EFF_TERM
ACADEMIC_PERIOD_DESC	Academic Period Description	Academic period description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ACADEMIC_YEAR	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	Academic year description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ACTIVE_COURSE_IND	Active Course Indicator	Indicates whether the course is active and may have sections scheduled.	VARCHAR2(1)	FUNCTION	F_ACTIVE_COURSE_IND
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
ATTRIBUTE_COUNT	Attribute Count	Count of course degree attributes recorded for the course.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_COURSE_ATTRIBUTES
BILLING_IND	Billing Indicator	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	Billing Maximum	Defines the second valid billing value or the high billing value within a range.	NUMBER	SCBCRSE	SCBCRSE_BILL_HR_HIGH
BILLING_MIN	Billing Minimum	Defines the first valid billing value or the low billing value within a range.	NUMBER	SCBCRSE	SCBCRSE_BILL_HR_LOW
COLLEGE	College	College, faculty or school to which the course instructional responsibility is associated.	VARCHAR2(63)	SCBCRSE	SCBCRSE_COLL_CODE
COLLEGE_DESC	College Description	College, faculty or school name.	VARCHAR2(255)	STVCOLL	STVCOLL_DESC
CONTACT_IND	Contact Indicator	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	Contact Maximum	High number of lecture, lab, and others contact hour value for the course.	NUMBER	SCBCRSE	SCBCRSE_CONT_HR_HIGH
CONTACT_MIN	Contact Minimum	Low number of lecture, lab, and others contact hour value for the course.	NUMBER	SCBCRSE	SCBCRSE_CONT_HR_LOW
CONTINUING_EDUCATION_IND	Continuing Education Indicator	Indicates whether the course earns continuing education units instead of credits.	VARCHAR2(1)	SCBCRSE	SCBCRSE_CEU_IND
COOPERATIVE_EDUCATION_IND	Cooperative Education Indicator	Indicates this is a cooperative education course.	VARCHAR2(1)	SCBSUPP	SCBSUPP_COOP_ED_IND
COURSE_APPROVAL	Course Approval	Type of requirements this course is approved to fulfill.	VARCHAR2(63)	SCBCRSE	SCBCRSE_APRV_CODE
COURSE_APPROVAL_DESC	Course Approval Description	Description for the type of requirement fulfilled by this course. Included may be degree, certificate, etc.	VARCHAR2(255)	STVAPRV	STVAPRV_DESC
COURSE_CLASSIFICATION	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	Course Classification Description	Description for the course classification.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
COURSE_CLASS_LEVEL	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	Course Class Level Description	Class level code description.	VARCHAR2(255)	NA	NA
COURSE_COREQ_COUNT	Course Coreq Count	Count of the number of course corequisites recorded for this course.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_COURSE_COREQ
COURSE_CREDIT_CATEGORY	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	Course Duration	Normal course length or weeks of instruction in the duration units listed.	VARCHAR2(255)	SCBCRSE	SCBCRSE_DUNT_CODE
COURSE_IDENTIFICATION	Course ID	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	Course Information 1	Institution defined reporting code for course element 1 information or characteristic.	VARCHAR2(63)	SCBSUPP	SCBSUPP_CUDA_CODE
COURSE_INFO2	Course Information 2	Institution defined reporting code for course element 2 information or characteristic.	VARCHAR2(63)	SCBSUPP	SCBSUPP_CUDB_CODE
COURSE_INFO3	Course Information 3	Institution defined reporting code for course element 3 information or characteristic.	VARCHAR2(63)	SCBSUPP	SCBSUPP_CUDC_CODE
COURSE_INFO4	Course Information 4	Institution defined reporting code for course element 4 information or characteristic.	VARCHAR2(63)	SCBSUPP	SCBSUPP_CUDD_CODE
COURSE_INFO5	Course Information 5	Institution defined reporting code for course element 5 information or characteristic.	VARCHAR2(63)	SCBSUPP	SCBSUPP_CUDE_CODE
COURSE_INFO6	Course Information 6	Institution defined reporting code for course element 6 information or characteristic.	VARCHAR2(63)	SCBSUPP	SCBSUPP_CUDF_CODE
COURSE_LEVEL_COUNT	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	Course number associated with the subject for the course.	VARCHAR2(63)	SCBCRSE SCBSUPP	SCBCRSE_CRSE_NUMB SCBSUPP_CRSE_NUMB
COURSE_PREREQS_COUNT	Course Prereqs Count	Count of the number of pre-requisites listed for this course.	NUMBER	FUNCTION	F_CHECK_FOR_COURSE_PREREQS
COURSE_TEXT_NARRATIVE	Narrative Course Text	Text developed at the institution to describe the course and course content.	CLOB	SCBDESC	SCBDESC_TEXT_NARRATIVE
COURSE_VERSION	Course Version	Course version number.	VARCHAR2(255)	NA	NA
CREDIT_IND	Credit Indicator	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	Credit Maximum	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	Credit Minimum	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	Default Grade Type	Indicates whether this is the default grade type for the course.	VARCHAR2(63)	SCRGMOD	SCRGMOD_GMOD_CODE
DEFAULT_GRADE_TYPE_DESC	Default Grade Type Description	Grade type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
DEPARTMENT	Department	Department responsible the academic instruction.	VARCHAR2(63)	SCBCRSE	SCBCRSE_DEPT_CODE
DEPARTMENT_DESC	Department Description	Department name.	VARCHAR2(255)	STVDEPT	STVDEPT_DESC
DIVISION	Division	Division responsible for the instructional delivery of this course or section.	VARCHAR2(63)	SCBCRSE	SCBCRSE_DIVS_CODE
DIVISION_DESC	Division Description	Name of the division.	VARCHAR2(255)	STVDIVS	STVDIVS_DESC
DURATION_UNIT_CODE	Duration Unit Code	Indicates whether the course duration is in days, weeks, months, etc.	VARCHAR2(255)	SCBCRSE	SCBCRSE_DUNT_CODE
FA_COUNTY_CREDITS	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	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	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	Grade Type Count	Count the number of grading types or modes for this course.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_GRADE_TYPE
LAB_IND	Lab Indicator	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	Lab Maximum	High value specified for a course that has variable lab contact hours.	NUMBER	SCBCRSE	SCBCRSE_LAB_HR_HIGH
LAB_MIN	Lab Minimum	Low value specified for a course that has variable lab contact hours.	NUMBER	SCBCRSE	SCBCRSE_LAB_HR_LOW
LECTURE_IND	Lecture Indicator	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	Lecture Maximum	High value specified for a course that has variable lecture contact hours.	NUMBER	SCBCRSE	SCBCRSE_LEC_HR_HIGH
LECTURE_MIN	Lecture Minimum	Low value specified for a course that has variable lecture contact hours.	NUMBER	SCBCRSE	SCBCRSE_LEC_HR_LOW
MAJOR	Major	First major to which the course belongs.	VARCHAR2(63)	NA	NA
MAJOR_DESC	Major Description	Major or subject area description.	VARCHAR2(255)	NA	NA
MAXIMUM_REPEAT_CREDITS	Maximum Repeat Credits	Maximum number of credits permitted.	NUMBER	SCBCRSE	SCBCRSE_MAX_RPT_UNITS
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NON_TRADITIONAL_IND	Non Traditional Indicator	Indicates whether the course is a non-traditional course.	VARCHAR2(1)	NA	NA
NUMBER_OF_REPEATS_ALLOWED	Number Of Repeats Allowed	Number of course repeats allowed.	NUMBER	SCBCRSE	SCBCRSE_REPEAT_LIMIT
OCCUPATIONAL_COURSE_CODE	Occupational Course Code	Setting of the occupational course indicator code.	VARCHAR2(63)	SCBSUPP	SCBSUPP_OCCS_CODE
OCCUPATIONAL_COURSE_DESC	Occupational Course Description	Occupational course indicator description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
OTHER_IND	Other Indicator	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	Other Maximum	High value specified for a course that has variable other contact hours.	NUMBER	SCBCRSE	SCBCRSE_OTH_HR_HIGH
OTHER_MIN	Other Minimum	Low value specified for a course that has variable other contact hours.	NUMBER	SCBCRSE	SCBCRSE_OTH_HR_LOW
PROCESS_GROUP	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	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	Program classification description.	VARCHAR2(255)	STVCIPC	STVCIPC_DESC
REPEATABLE_COURSE_IND	Repeatable Course Indicator	Indicates whether the course can be repeated.	VARCHAR2(1)	NA	NA
REPEAT_STATUS_CODE	Repeat Status Code	Repeat status code used for reporting purposes.	VARCHAR2(63)	SCBCRSE	SCBCRSE_REPS_CODE
REPEAT_STATUS_DESC	Repeat Status Description	Repeat status description.	VARCHAR2(255)	STVREPS	STVREPS_DESC
REPORT_COUNTY_CREDITS	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	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	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	Schedule Count	Count of the instruction or delivery methods for this course.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_COURSE_SCHEDULE
STATUS	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	Status Description	Course status description.	VARCHAR2(255)	STVCSTA	STVCSTA_DESC
SUBJECT	Subject	Main instructional subject area for this course.	VARCHAR2(63)	SCBCRSE SCBSUPP	SCBCRSE_SUBJ_CODE SCBSUPP_SUBJ_CODE
SUBJECT_DESC	Subject Description	Subject code description.	VARCHAR2(255)	STVSUBJ	STVSUBJ_DESC
TAXONOMY_OF_PROGRAM_CODE	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 Description	Taxonomy of program code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
TITLE_LONG_DESC	Title Long Description	Long title of the course.	VARCHAR2(255)	SCRSYLN	SCRSYLN_LONG_COURSE_TITLE
TITLE_SHORT_DESC	Title Short Description	Displays the course or section short title.	VARCHAR2(255)	SCBCRSE	SCBCRSE_TITLE