| ODS Column |
ODS Business Definition |
ODS Calculation Formula |
ODS Data Type |
Banner Source Name |
Banner Source Column |
Banner Form Name |
|
ACADEMIC_PERIOD
|
Academic period or time frame associated with this course record.
|
|
|
SCBCRSE
|
SCBCRSE_EFF_TERM
|
|
|
ACADEMIC_PERIOD_DESC
|
Academic period description.
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
|
ACADEMIC_YEAR
|
Academic year associated with the academic period on this record.
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
|
ACADEMIC_YEAR_DESC
|
Academic year description.
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
|
ACTIVE_COURSE_IND
|
Indicates whether the course is active and may have sections scheduled.
|
|
|
FUNCTION
|
F_ACTIVE_COURSE_IND
|
|
|
ADMINISTRATIVE_GROUP
|
Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
|
|
NA
|
NA
|
|
|
ATTRIBUTE_COUNT
|
Count of course degree attributes recorded for the course.
|
|
|
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.
|
|
|
SCBCRSE
|
SCBCRSE_BILL_HR_IND
|
|
|
BILLING_MAX
|
Defines the second valid billing value or the high billing value within a range.
|
|
|
SCBCRSE
|
SCBCRSE_BILL_HR_HIGH
|
|
|
BILLING_MIN
|
Defines the first valid billing value or the low billing value within a range.
|
|
|
SCBCRSE
|
SCBCRSE_BILL_HR_LOW
|
|
|
COLLEGE
|
College, faculty or school to which the course instructional responsibility is associated.
|
|
|
SCBCRSE
|
SCBCRSE_COLL_CODE
|
|
|
COLLEGE_DESC
|
College, faculty or school name.
|
|
|
STVCOLL
|
STVCOLL_DESC
|
|
|
CONTACT_IND
|
Identifies whether there is a range of contact hours or a specific variable number or an additional number.
|
|
|
SCBCRSE
|
SCBCRSE_CONT_HR_IND
|
|
|
CONTACT_MAX
|
High number of lecture, lab, and others contact hour value for the course.
|
|
|
SCBCRSE
|
SCBCRSE_CONT_HR_HIGH
|
|
|
CONTACT_MIN
|
Low number of lecture, lab, and others contact hour value for the course.
|
|
|
SCBCRSE
|
SCBCRSE_CONT_HR_LOW
|
|
|
CONTINUING_EDUCATION_IND
|
Indicates whether the course earns continuing education units instead of credits.
|
|
|
SCBCRSE
|
SCBCRSE_CEU_IND
|
|
|
COOPERATIVE_EDUCATION_IND
|
Indicates this is a cooperative education course.
|
|
|
SCBSUPP
|
SCBSUPP_COOP_ED_IND
|
|
|
COURSE_APPROVAL
|
Type of requirements this course is approved to fulfill.
|
|
|
SCBCRSE
|
SCBCRSE_APRV_CODE
|
|
|
COURSE_APPROVAL_DESC
|
Description for the type of requirement fulfilled by this course. Included may be degree, certificate, etc.
|
|
|
STVAPRV
|
STVAPRV_DESC
|
|
|
COURSE_CLASSIFICATION
|
Classification code associated with this course. Code used to group courses together for reporting.
|
|
|
SCBSUPP
|
SCBSUPP_CCSL_CODE
|
|
|
COURSE_CLASSIFICATION_DESC
|
Description for the course classification.
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
|
COURSE_CLASS_LEVEL
|
Expected class (first year, second year, etc.) the enrollee is in when taking a course.
|
|
|
NA
|
NA
|
|
|
COURSE_CLASS_LEVEL_DESC
|
Class level code description.
|
|
|
NA
|
NA
|
|
|
COURSE_COREQ_COUNT
|
Count of the number of course corequisites recorded for this course.
|
|
|
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.
|
|
|
SCBSUPP
|
SCBSUPP_CREDIT_CATEGORY_IND
|
|
|
COURSE_DURATION
|
Normal course length or weeks of instruction in the duration units listed.
|
|
|
SCBCRSE
|
SCBCRSE_DUNT_CODE
|
|
|
COURSE_IDENTIFICATION
|
Combined subject code and course number that identifies the instructional content of this course.
|
|
|
CALCULATION
|
SCBCRSE_SUBJ_CODE||SCBCRSE_CRSE_NUMB
|
|
|
COURSE_INFO1
|
Institution defined reporting code for course element 1 information or characteristic.
|
|
|
SCBSUPP
|
SCBSUPP_CUDA_CODE
|
|
|
COURSE_INFO2
|
Institution defined reporting code for course element 2 information or characteristic.
|
|
|
SCBSUPP
|
SCBSUPP_CUDB_CODE
|
|
|
COURSE_INFO3
|
Institution defined reporting code for course element 3 information or characteristic.
|
|
|
SCBSUPP
|
SCBSUPP_CUDC_CODE
|
|
|
COURSE_INFO4
|
Institution defined reporting code for course element 4 information or characteristic.
|
|
|
SCBSUPP
|
SCBSUPP_CUDD_CODE
|
|
|
COURSE_INFO5
|
Institution defined reporting code for course element 5 information or characteristic.
|
|
|
SCBSUPP
|
SCBSUPP_CUDE_CODE
|
|
|
COURSE_INFO6
|
Institution defined reporting code for course element 6 information or characteristic.
|
|
|
SCBSUPP
|
SCBSUPP_CUDF_CODE
|
|
|
COURSE_LEVEL_COUNT
|
Count of the number of levels authorized for this course. Include may be undergraduate and graduate, etc.
|
|
|
FUNCTION
|
MSKFUNC.F_COUNT_COURSE_LEVEL
|
|
|
COURSE_NUMBER
|
Course number associated with the subject for the course.
|
|
|
SCBCRSE SCBSUPP
|
SCBCRSE_CRSE_NUMB SCBSUPP_CRSE_NUMB
|
|
|
COURSE_PREREQS_COUNT
|
Count of the number of pre-requisites listed for this course.
|
|
|
FUNCTION
|
F_CHECK_FOR_COURSE_PREREQS
|
|
|
COURSE_TEXT_NARRATIVE
|
Text developed at the institution to describe the course and course content.
|
|
|
SCBDESC
|
SCBDESC_TEXT_NARRATIVE
|
|
|
COURSE_VERSION
|
Course version number.
|
|
|
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.
|
|
|
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.
|
|
|
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.
|
|
|
SCBCRSE
|
SCBCRSE_CREDIT_HR_LOW
|
|
|
DEFAULT_GRADE_TYPE
|
Indicates whether this is the default grade type for the course.
|
|
|
SCRGMOD
|
SCRGMOD_GMOD_CODE
|
|
|
DEFAULT_GRADE_TYPE_DESC
|
Grade type description.
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
|
DEPARTMENT
|
Department responsible the academic instruction.
|
|
|
SCBCRSE
|
SCBCRSE_DEPT_CODE
|
|
|
DEPARTMENT_DESC
|
Department name.
|
|
|
STVDEPT
|
STVDEPT_DESC
|
|
|
DIVISION
|
Division responsible for the instructional delivery of this course or section.
|
|
|
SCBCRSE
|
SCBCRSE_DIVS_CODE
|
|
|
DIVISION_DESC
|
Name of the division.
|
|
|
STVDIVS
|
STVDIVS_DESC
|
|
|
DURATION_UNIT_CODE
|
Indicates whether the course duration is in days, weeks, months, etc.
|
|
|
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.
|
|
|
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.
|
|
|
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.
|
|
|
NA
|
NA
|
|
|
GRADE_TYPE_COUNT
|
Count the number of grading types or modes for this course.
|
|
|
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.
|
|
|
SCBCRSE
|
SCBCRSE_LAB_HR_IND
|
|
|
LAB_MAX
|
High value specified for a course that has variable lab contact hours.
|
|
|
SCBCRSE
|
SCBCRSE_LAB_HR_HIGH
|
|
|
LAB_MIN
|
Low value specified for a course that has variable lab contact hours.
|
|
|
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.
|
|
|
SCBCRSE
|
SCBCRSE_LEC_HR_IND
|
|
|
LECTURE_MAX
|
High value specified for a course that has variable lecture contact hours.
|
|
|
SCBCRSE
|
SCBCRSE_LEC_HR_HIGH
|
|
|
LECTURE_MIN
|
Low value specified for a course that has variable lecture contact hours.
|
|
|
SCBCRSE
|
SCBCRSE_LEC_HR_LOW
|
|
|
MAJOR
|
First major to which the course belongs.
|
|
|
NA
|
NA
|
|
|
MAJOR_DESC
|
Major or subject area description.
|
|
|
NA
|
NA
|
|
|
MAXIMUM_REPEAT_CREDITS
|
Maximum number of credits permitted.
|
|
|
SCBCRSE
|
SCBCRSE_MAX_RPT_UNITS
|
|
|
MULTI_SOURCE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
|
|
NA
|
NA
|
|
|
MULTI_SOURCE_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
|
|
NA
|
NA
|
|
|
NON_TRADITIONAL_IND
|
Indicates whether the course is a non-traditional course.
|
|
|
NA
|
NA
|
|
|
NUMBER_OF_REPEATS_ALLOWED
|
Number of course repeats allowed.
|
|
|
SCBCRSE
|
SCBCRSE_REPEAT_LIMIT
|
|
|
OCCUPATIONAL_COURSE_CODE
|
Setting of the occupational course indicator code.
|
|
|
SCBSUPP
|
SCBSUPP_OCCS_CODE
|
|
|
OCCUPATIONAL_COURSE_DESC
|
Occupational course indicator description.
|
|
|
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.
|
|
|
SCBCRSE
|
SCBCRSE_OTH_HR_IND
|
|
|
OTHER_MAX
|
High value specified for a course that has variable other contact hours.
|
|
|
SCBCRSE
|
SCBCRSE_OTH_HR_HIGH
|
|
|
OTHER_MIN
|
Low value specified for a course that has variable other contact hours.
|
|
|
SCBCRSE
|
SCBCRSE_OTH_HR_LOW
|
|
|
PROCESS_GROUP
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
|
|
NA
|
NA
|
|
|
PROGRAM_CLASSIFICATION
|
Program classification identifying the course major subject area used for government reporting to group subjects (courses).
|
|
|
SCBCRSE
|
SCBCRSE_CIPC_CODE
|
|
|
PROGRAM_CLASSIFICATION_DESC
|
Program classification description.
|
|
|
STVCIPC
|
STVCIPC_DESC
|
|
|
REPEATABLE_COURSE_IND
|
Indicates whether the course can be repeated.
|
|
|
NA
|
NA
|
|
|
REPEAT_STATUS_CODE
|
Repeat status code used for reporting purposes.
|
|
|
SCBCRSE
|
SCBCRSE_REPS_CODE
|
|
|
REPEAT_STATUS_DESC
|
Repeat status description.
|
|
|
STVREPS
|
STVREPS_DESC
|
|
|
REPORT_COUNTY_CREDITS
|
Reporting credits - county, which is the number of eligible credits for this course for county reporting purposes.
|
|
|
NA
|
NA
|
|
|
REPORT_FEDERAL_CREDITS
|
Reporting credits - federal, which is the number of eligible credits used for this course for federal reporting purposes.
|
|
|
NA
|
NA
|
|
|
REPORT_STATE_CREDITS
|
Reporting credits - state, which is the number of eligible credits for this course for state reporting purposes.
|
|
|
NA
|
NA
|
|
|
SCHEDULE_COUNT
|
Count of the instruction or delivery methods for this course.
|
|
|
FUNCTION
|
MSKFUNC.F_COUNT_COURSE_SCHEDULE
|
|
|
STATUS
|
Identifies the current course status. May be used to prevent the creation of sections for this course.
|
|
|
SCBCRSE
|
SCBCRSE_CSTA_CODE
|
|
|
STATUS_DESC
|
Course status description.
|
|
|
STVCSTA
|
STVCSTA_DESC
|
|
|
SUBJECT
|
Main instructional subject area for this course.
|
|
|
SCBCRSE SCBSUPP
|
SCBCRSE_SUBJ_CODE SCBSUPP_SUBJ_CODE
|
|
|
SUBJECT_DESC
|
Subject code description.
|
|
|
STVSUBJ
|
STVSUBJ_DESC
|
|
|
TAXONOMY_OF_PROGRAM_CODE
|
Government reporting code typically used for reporting of vocational technical courses or subjects.
|
|
|
SCBSUPP
|
SCBSUPP_TOPS_CODE
|
|
|
TAXONOMY_OF_PROGRAM_DESC
|
Taxonomy of program code description.
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
|
TITLE_LONG_DESC
|
Long title of the course.
|
|
|
SHRTCKN
|
SHRTCKN_LONG_COURSE_TITLE
|
|
|
TITLE_SHORT_DESC
|
Displays the course or section short title.
|
|
|
SCBCRSE
|
SCBCRSE_TITLE
|
|