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

Banner Operational Data Store
Composite View Target: AS_COURSE_SUPPLEMENTAL

Description Source composite view contains additional information about the course that may have the specific purpose to accommodate reporting requirements of the institution.

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 this supplemental information to apply to this course record. VARCHAR2(6)

FUNCTION

SOKODSF.F_GET_END_SCBSUPP_TERM

NO

NO
ACADEMIC_PERIOD_END_DESC Academic period description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
ACADEMIC_PERIOD_START Academic period or time frame when supplemental course information like taxonomy of program codes and user defined codes are assigned to a course record. VARCHAR2(6)

SCBSUPP

SCBSUPP_EFF_TERM

NO

NO
ACADEMIC_PERIOD_START_DESC Academic period description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
ACADEMIC_YEAR Academic year associated with the academic period on this record. VARCHAR2(0)

STVTERM

STVTERM_ACYR_CODE

NO

NO
ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(0)

NA

NA

NO

NO
ACTIVITY_DATE Date that information for this record in the table was entered or last updated. DATE

SCBSUPP

SCBSUPP_ACTIVITY_DATE

NO

NO
CLASSIFICATION Classification code identified for the course to be used in reporting. VARCHAR2(2)

SCBSUPP

SCBSUPP_CCSL_CODE

NO

NO
CLASSIFICATION_DESC Course classification code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
COOPERATIVE_EDUCATION_IND Indicates this is a cooperative education course. VARCHAR2(1)

SCBSUPP

SCBSUPP_COOP_ED_IND

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_IDENTIFICATION Course subject and course number combined. VARCHAR2(9)

CALCULATION

SCBSUPP_SUBJ_CODE||SCBSUPP_CRSE_NUMB

NO

NO
COURSE_INFO1 Institution defined reporting code for course element 1 information or characteristic. VARCHAR2(15)

SCBSUPP

SCBSUPP_CUDA_CODE

NO

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

SCBSUPP

SCBSUPP_CUDB_CODE

NO

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

SCBSUPP

SCBSUPP_CUDC_CODE

NO

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

SCBSUPP

SCBSUPP_CUDD_CODE

NO

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

SCBSUPP

SCBSUPP_CUDE_CODE

NO

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

SCBSUPP

SCBSUPP_CUDF_CODE

NO

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

SCBSUPP

SCBSUPP_CRSE_NUMB

NO

NO
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

NO

NO
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

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
OCCUPATIONAL_COURSE Setting of the occupational course indicator code. VARCHAR2(2)

SCBSUPP

SCBSUPP_OCCS_CODE

NO

NO
OCCUPATIONAL_COURSE_DESC Occupational course indicator description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
PERMANENT_DISTRICT_IND Permanent district identifier. VARCHAR2(12)

SCBSUPP

SCBSUPP_PERM_DIST_IND

NO

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

SCBSUPP

SCBSUPP_SUBJ_CODE

NO

NO
SUBJECT_DESC Subject code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_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
TAXONOMY_OF_PROGRAM Government reporting code typically used for reporting of vocational technical courses or subjects. VARCHAR2(6)

SCBSUPP

SCBSUPP_TOPS_CODE

NO

NO
TAXONOMY_OF_PROGRAM_DESC Taxonomy of program code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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: