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

Ver: 9.2