Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Student Composite View Reports

Banner 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 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


Ver: