RETURN TO COMPOSITE VIEW REPORTS LIST
Student Composite View Reports

SGHE Operational Data Store
Composite View Target: AS_COURSE_CATALOG

Description Source composite view contains all of the informational details recorded for the subject or course at a specific time frame or academic period.

Target Column Business Definition Database Data Type 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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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_INFO1 Institution defined reporting code for course element 1 information or characteristic. VARCHAR2(0)

NA

NA

COURSE_INFO2 Institution defined reporting code for course element 2 information or characteristic. VARCHAR2(0)

NA

NA

COURSE_INFO3 Institution defined reporting code for course element 3 information or characteristic. VARCHAR2(0)

NA

NA

COURSE_INFO4 Institution defined reporting code for course element 4 information or characteristic. VARCHAR2(0)

NA

NA

COURSE_INFO5 Institution defined reporting code for course element 5 information or characteristic. VARCHAR2(0)

NA

NA

COURSE_INFO6 Institution defined reporting code for course element 6 information or characteristic. VARCHAR2(0)

NA

NA

COURSE_NUMBER Course number associated with the subject for the course. VARCHAR2(5)

SCBCRSE

SCBCRSE_CRSE_NUMB

COURSE_TEXT_NARRATIVE Text developed at the institution to describe the course and course content. VARCHAR2(0)

NA

NA

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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_DESC

SUBJECT Main instructional subject area for this course. VARCHAR2(4)

SCBCRSE

SCBCRSE_SUBJ_CODE

SUBJECT_DESC Subject code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_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(0)

NA

NA

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: 3.1