| Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
ACADEMIC_PERIOD
|
Academic Period
|
Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year.
|
VARCHAR2(63)
|
SCBCRSE
|
SCBCRSE_EFF_TERM
|
|
ACADEMIC_PERIOD_DESC
|
Academic Period Description
|
Academic period description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
ACADEMIC_PERIOD_END
|
Academic Period End
|
This field identifies the academic period or term associated with the information in the course attribute record.
|
VARCHAR2(63)
|
FUNCTION
|
SOKODSF.F_GET_END_SCBCRSE_TERM
|
|
ACADEMIC_PERIOD_END_DESC
|
Academic Period Description
|
This field specifies the academic period or term associated with the academic period code.
|
VARCHAR2(255)
|
STVTERM
|
STVTERM_DESC
|
|
ACADEMIC_PERIOD_START
|
Academic Period Start
|
This field identifies the session or part of the academic period associated with the information in the course attribute record.
|
VARCHAR2(63)
|
SCBCRSE
|
SCBCRSE_EFF_TERM
|
|
ACADEMIC_PERIOD_START_DESC
|
Academic Period Start Description
|
This field specifies the session or part of the academic period associated with the session code.
|
VARCHAR2(255)
|
STVTERM
|
STVTERM_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
|
Administrative-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
|
First level of the institution organization structure that owns the student or the academic instruction for a student course.
|
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
|
Course subject and course number combined.
|
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.
|
VARCHAR2(4000)
|
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 for the major subject area of a student course or associated with the major within the student academic study.
|
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
|
|
LEARNING_OBJECTIVES
|
|
The Learning Objective of the course.
|
VARCHAR2(4000)
|
SCRSYLO
|
SCRSYLO_LEARNING_OBJECTIVES
|
|
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
|
Major subject area of the person's academic study.
|
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
|
Classification of Instructional Program (CIP) codes assigned to an area of study and used for governmental reporting.
|
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
|