Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
ACADEMIC_PERIOD_END
|
Ending academic period or time frame for the course record.
|
VARCHAR2(6)
|
FUNCTION
|
SOKODSF.F_GET_END_SCBCRSE_TERM
|
NO
|
NO
|
ACADEMIC_PERIOD_END_DESC
|
Academic period description.
|
VARCHAR2(30)
|
STVTERM
|
STVTERM_DESC
|
NO
|
NO
|
ACADEMIC_PERIOD_START
|
Academic period or time frame when the information about the course record is active.
|
VARCHAR2(6)
|
SCBCRSE
|
SCBCRSE_EFF_TERM
|
NO
|
NO
|
ACADEMIC_PERIOD_START_DESC
|
Academic period description.
|
VARCHAR2(30)
|
STVTERM
|
STVTERM_DESC
|
NO
|
NO
|
ACADEMIC_YEAR
|
Academic year associated with the academic period on this record.
|
VARCHAR2(0)
|
NA
|
NA
|
NO
|
NO
|
ACADEMIC_YEAR_DESC
|
Academic year description.
|
VARCHAR2(0)
|
NA
|
NA
|
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
|
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(2)
|
SCBCRSE
|
SCBCRSE_COLL_CODE
|
NO
|
NO
|
COLLEGE_DESC
|
College, faculty or school name.
|
VARCHAR2(30)
|
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
|
COURSE_APPROVAL
|
Type of requirements this course is approved to fulfill.
|
VARCHAR2(1)
|
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(30)
|
STVAPRV
|
STVAPRV_DESC
|
NO
|
NO
|
COURSE_CLASS_LEVEL
|
Expected class (first year, second year, etc.) the enrollee is in when taking the course.
|
VARCHAR2(0)
|
NA
|
NA
|
NO
|
NO
|
COURSE_CLASS_LEVEL_DESC
|
Class level code description.
|
VARCHAR2(0)
|
NA
|
NA
|
NO
|
NO
|
COURSE_DURATION
|
Normal course length or weeks of instruction in the duration units listed.
|
VARCHAR2(44)
|
SCBCRSE
|
SCBCRSE_DUNT_CODE
|
NO
|
NO
|
COURSE_IDENTIFICATION
|
Course subject and course number combined.
|
VARCHAR2(9)
|
CALCULATION
|
SCBCRSE_SUBJ_CODE||SCBCRSE_CRSE_NUMB
|
NO
|
NO
|
COURSE_NUMBER
|
Course number associated with the subject for the course.
|
VARCHAR2(5)
|
SCBCRSE
|
SCBCRSE_CRSE_NUMB
|
NO
|
NO
|
COURSE_TEXT_NARRATIVE
|
Text developed at the institution to describe the course and course content.
|
CLOB
|
SCBDESC
|
SCBDESC_TEXT_NARRATIVE
|
NO
|
NO
|
COURSE_VERSION_NO
|
Course version number.
|
VARCHAR2(0)
|
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
|
CURRENT_DATE
|
System current date (sysdate) or date the data was extracted.
|
DATE
|
NA
|
SYSDATE
|
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(4)
|
SCBCRSE
|
SCBCRSE_DEPT_CODE
|
NO
|
NO
|
DEPARTMENT_DESC
|
Department name.
|
VARCHAR2(30)
|
STVDEPT
|
STVDEPT_DESC
|
NO
|
NO
|
DIVISION
|
Division responsible for the instructional delivery of this course or section.
|
VARCHAR2(4)
|
SCBCRSE
|
SCBCRSE_DIVS_CODE
|
NO
|
NO
|
DIVISION_DESC
|
Name of the division.
|
VARCHAR2(30)
|
STVDIVS
|
STVDIVS_DESC
|
NO
|
NO
|
DOMAIN_VALUE
|
Organization-oriented identifier for the record used to determine access authorization. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
DURATION_UNIT
|
Indicates whether the course duration is in days, weeks, months, etc.
|
VARCHAR2(4)
|
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(0)
|
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(0)
|
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(0)
|
NA
|
NA
|
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.
|
CLOB
|
FUNCTION
|
SOKODSF.F_SCRSYLO_LEARNING_OBJ
|
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(0)
|
NA
|
NA
|
NO
|
NO
|
MAJOR_DESC
|
Major or subject area description.
|
VARCHAR2(0)
|
NA
|
NA
|
NO
|
NO
|
MAXIMUM_REPEAT_UNITS
|
Maximum number of credits permitted.
|
NUMBER
|
SCBCRSE
|
SCBCRSE_MAX_RPT_UNITS
|
NO
|
NO
|
MIF_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(30)
|
NA
|
NA
|
NO
|
NO
|
MIF_VALUE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
NON_TRADITIONAL_IND
|
Indicates whether the course is a non-traditional course.
|
VARCHAR2(0)
|
NA
|
NA
|
NO
|
NO
|
NO_OF_REPEATS_ALLOWED
|
Records the maximum number of times the course may be repeated by a student. Zero (0) is the default. The repeat limit is used in the repeat check process in academic history.
|
NUMBER
|
SCBCRSE
|
SCBCRSE_REPEAT_LIMIT
|
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
|
PROGRAM_CLASSIFICATION
|
Classification of Instructional Program (CIP) codes assigned to an area of study and used for governmental reporting.
|
VARCHAR2(6)
|
SCBCRSE
|
SCBCRSE_CIPC_CODE
|
NO
|
NO
|
PROGRAM_CLASSIFICATION_DESC
|
Program classification description.
|
VARCHAR2(30)
|
STVCIPC
|
STVCIPC_DESC
|
NO
|
NO
|
REPEATABLE_COURSE_IND
|
Indicates whether the course can be repeated.
|
VARCHAR2(0)
|
NA
|
NA
|
NO
|
NO
|
REPEAT_STATUS_CODE
|
Repeat status code used for reporting purposes.
|
VARCHAR2(2)
|
SCBCRSE
|
SCBCRSE_REPS_CODE
|
NO
|
NO
|
REPEAT_STATUS_DESC
|
Repeat status description.
|
VARCHAR2(30)
|
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(0)
|
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(0)
|
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(0)
|
NA
|
NA
|
NO
|
NO
|
STATUS
|
Identifies the current course status. May be used to prevent the creation of sections for this course.
|
VARCHAR2(1)
|
SCBCRSE
|
SCBCRSE_CSTA_CODE
|
NO
|
NO
|
STATUS_DESC
|
Course status description.
|
VARCHAR2(30)
|
STVCSTA
|
STVCSTA_DESC
|
NO
|
NO
|
SUBJECT
|
Main instructional subject area for this course.
|
VARCHAR2(4)
|
SCBCRSE
|
SCBCRSE_SUBJ_CODE
|
NO
|
NO
|
SUBJECT_DESC
|
Subject code description.
|
VARCHAR2(30)
|
STVSUBJ
|
STVSUBJ_DESC
|
NO
|
NO
|
SUB_ACADEMIC_PERIOD
|
A session, portion or part of the academic period.
|
VARCHAR2(0)
|
NA
|
NA
|
NO
|
NO
|
SUB_ACADEMIC_PERIOD_DESC
|
Sub academic period description.
|
VARCHAR2(0)
|
NA
|
NA
|
NO
|
NO
|
TITLE_LONG_DESC
|
Long title of the course.
|
VARCHAR2(4000)
|
FUNCTION
|
SOKODSF.F_GET_SCBCRSE_LONG_TITLE
|
NO
|
NO
|
TITLE_SHORT_DESC
|
Displays the course or section short title.
|
VARCHAR2(30)
|
SCBCRSE
|
SCBCRSE_TITLE
|
NO
|
NO
|
ZONE_VALUE
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|