Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACADEMIC_PERIOD_END		Ending academic period or time frame for the course record.	VARCHAR2(6)		FUNCTION	SOKODSF.F_GET_END_SCBCRSE_TERM
ACADEMIC_PERIOD_END_DESC		Academic period description.	VARCHAR2(30)		STVTERM	STVTERM_DESC
ACADEMIC_PERIOD_START		Academic period or time frame when the information about the course record is active.	VARCHAR2(6)		SCBCRSE	SCBCRSE_EFF_TERM
ACADEMIC_PERIOD_START_DESC		Academic period description.	VARCHAR2(30)		STVTERM	STVTERM_DESC
ACADEMIC_YEAR		Academic year associated with the academic period on this record.	VARCHAR2(0)		NA	NA
ACADEMIC_YEAR_DESC		Academic year description.	VARCHAR2(0)		NA	NA
ACTIVE_COURSE_IND		Indicates whether the course is active and may have sections scheduled.	VARCHAR2(1)		FUNCTION	F_ACTIVE_COURSE_IND
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
BILLING_MAX		Defines the second valid billing value or the high billing value within a range.	NUMBER(7, 3)		SCBCRSE	SCBCRSE_BILL_HR_HIGH
BILLING_MIN		Defines the first valid billing value or the low billing value within a range.	NUMBER(7, 3)		SCBCRSE	SCBCRSE_BILL_HR_LOW
COLLEGE		College, faculty or school to which the course instructional responsibility is associated.	VARCHAR2(2)		SCBCRSE	SCBCRSE_COLL_CODE
COLLEGE_DESC		College, faculty or school name.	VARCHAR2(30)		STVCOLL	STVCOLL_DESC
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
CONTACT_MAX		High number of lecture, lab, and others contact hour value for the course.	NUMBER(7, 3)		SCBCRSE	SCBCRSE_CONT_HR_HIGH
CONTACT_MIN		Low number of lecture, lab, and others contact hour value for the course.	NUMBER(7, 3)		SCBCRSE	SCBCRSE_CONT_HR_LOW
CONTINUING_EDUCATION_IND		Indicates whether the course earns continuing education units instead of credits.	VARCHAR2(1)		SCBCRSE	SCBCRSE_CEU_IND
COURSE_APPROVAL		Type of requirements this course is approved to fulfill.	VARCHAR2(1)		SCBCRSE	SCBCRSE_APRV_CODE
COURSE_APPROVAL_DESC		Description for the type of requirement fulfilled by this course. Included may be degree, certificate, etc.	VARCHAR2(30)		STVAPRV	STVAPRV_DESC
COURSE_CLASS_LEVEL		Expected class (first year, second year, etc.) the enrollee is in when taking the course.	VARCHAR2(0)		NA	NA
COURSE_CLASS_LEVEL_DESC		Class level code description.	VARCHAR2(0)		NA	NA
COURSE_DURATION		Normal course length or weeks of instruction in the duration units listed.	VARCHAR2(44)		SCBCRSE	SCBCRSE_DUNT_CODE
COURSE_IDENTIFICATION		Combined subject code and course number that identifies the instructional content of this course.	VARCHAR2(9)		CALCULATION	SCBCRSE_SUBJ_CODE||SCBCRSE_CRSE_NUMB
COURSE_NUMBER		Course number associated with the subject for the course.	VARCHAR2(5)		SCBCRSE	SCBCRSE_CRSE_NUMB
COURSE_TEXT_NARRATIVE	Course Text Narrative	Text developed at the institution to describe the course and course content.	CLOB		SCBDESC	SCBDESC_TEXT_NARRATIVE
COURSE_VERSION_NO		Course version number.	VARCHAR2(0)		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.	VARCHAR2(2)		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.	NUMBER(7, 3)		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.	NUMBER(7, 3)		SCBCRSE	SCBCRSE_CREDIT_HR_LOW
CURRENT_DATE		System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DEPARTMENT		Department responsible the academic instruction.	VARCHAR2(4)		SCBCRSE	SCBCRSE_DEPT_CODE
DEPARTMENT_DESC		Department name.	VARCHAR2(30)		STVDEPT	STVDEPT_DESC
DIVISION		Division responsible for the instructional delivery of this course or section.	VARCHAR2(4)		SCBCRSE	SCBCRSE_DIVS_CODE
DIVISION_DESC		Name of the division.	VARCHAR2(30)		STVDIVS	STVDIVS_DESC
DOMAIN_VALUE		Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)		NA	NA
DURATION_UNIT		Indicates whether the course duration is in days, weeks, months, etc.	VARCHAR2(4)		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.	VARCHAR2(0)		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.	VARCHAR2(0)		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.	VARCHAR2(0)		NA	NA
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
LAB_MAX		High value specified for a course that has variable lab contact hours.	NUMBER(7, 3)		SCBCRSE	SCBCRSE_LAB_HR_HIGH
LAB_MIN		Low value specified for a course that has variable lab contact hours.	NUMBER(7, 3)		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.	VARCHAR2(2)		SCBCRSE	SCBCRSE_LEC_HR_IND
LECTURE_MAX		High value specified for a course that has variable lecture contact hours.	NUMBER(7, 3)		SCBCRSE	SCBCRSE_LEC_HR_HIGH
LECTURE_MIN		Low value specified for a course that has variable lecture contact hours.	NUMBER(7, 3)		SCBCRSE	SCBCRSE_LEC_HR_LOW
MAJOR		First major to which the course belongs.	VARCHAR2(0)		NA	NA
MAJOR_DESC		Major or subject area description.	VARCHAR2(0)		NA	NA
MAXIMUM_REPEAT_UNITS		Maximum number of credits permitted.	NUMBER(9, 3)		SCBCRSE	SCBCRSE_MAX_RPT_UNITS
MIF_DESC		Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)		NA	NA
MIF_VALUE		Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)		NA	NA
NON_TRADITIONAL_IND		Indicates whether the course is a non-traditional course.	VARCHAR2(0)		NA	NA
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(2)		SCBCRSE	SCBCRSE_REPEAT_LIMIT
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
OTHER_MAX		High value specified for a course that has variable other contact hours.	NUMBER(7, 3)		SCBCRSE	SCBCRSE_OTH_HR_HIGH
OTHER_MIN		Low value specified for a course that has variable other contact hours.	NUMBER(7, 3)		SCBCRSE	SCBCRSE_OTH_HR_LOW
PROGRAM_CLASSIFICATION		Program classification identifying the course major subject area used for government reporting to group subjects (courses).	VARCHAR2(6)		SCBCRSE	SCBCRSE_CIPC_CODE
PROGRAM_CLASSIFICATION_DESC		Program classification description.	VARCHAR2(30)		STVCIPC	STVCIPC_DESC
REPEATABLE_COURSE_IND		Indicates whether the course can be repeated.	VARCHAR2(0)		NA	NA
REPEAT_STATUS_CODE		Repeat status code used for reporting purposes.	VARCHAR2(2)		SCBCRSE	SCBCRSE_REPS_CODE
REPEAT_STATUS_DESC		Repeat status description.	VARCHAR2(30)		STVREPS	STVREPS_DESC
REPORT_COUNTY_CREDITS		Reporting credits - county, which is the number of eligible credits for this course for county reporting purposes.	VARCHAR2(0)		NA	NA
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
REPORT_STATE_CREDITS		Reporting credits - state, which is the number of eligible credits for this course for state reporting purposes.	VARCHAR2(0)		NA	NA
STATUS		Identifies the current course status. May be used to prevent the creation of sections for this course.	VARCHAR2(1)		SCBCRSE	SCBCRSE_CSTA_CODE
STATUS_DESC		Course status description.	VARCHAR2(30)		STVCSTA	STVCSTA_DESC
SUBJECT		Main instructional subject area for this course.	VARCHAR2(4)		SCBCRSE	SCBCRSE_SUBJ_CODE
SUBJECT_DESC		Subject code description.	VARCHAR2(30)		STVSUBJ	STVSUBJ_DESC
SUB_ACADEMIC_PERIOD		A session, portion or part of the academic period.	VARCHAR2(0)		NA	NA
SUB_ACADEMIC_PERIOD_DESC		Sub academic period description.	VARCHAR2(0)		NA	NA
TITLE_LONG_DESC		Long title of the course.	VARCHAR2(4000)		FUNCTION	SOKODSF.F_GET_SCBCRSE_LONG_TITLE
TITLE_SHORT_DESC		Displays the course or section short title.	VARCHAR2(30)		SCBCRSE	SCBCRSE_TITLE
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: