Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Student Composite View Reports

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

ACADEMIC_PERIOD_END_DESC Academic period description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

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)

STVTERM

STVTERM_ACYR_CODE

ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(0)

NA

NA

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

SCBSUPP

SCBSUPP_ACTIVITY_DATE

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

SCBSUPP

SCBSUPP_CCSL_CODE

CLASSIFICATION_DESC Course classification code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

SCBSUPP

SCBSUPP_COOP_ED_IND

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

COURSE_IDENTIFICATION Combined subject code and course number that identifies the instructional content of this course. VARCHAR2(9)

CALCULATION

SCBSUPP_SUBJ_CODE||SCBSUPP_CRSE_NUMB

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

SCBSUPP

SCBSUPP_CUDA_CODE

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

SCBSUPP

SCBSUPP_CUDB_CODE

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

SCBSUPP

SCBSUPP_CUDC_CODE

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

SCBSUPP

SCBSUPP_CUDD_CODE

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

SCBSUPP

SCBSUPP_CUDE_CODE

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

SCBSUPP

SCBSUPP_CUDF_CODE

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

SCBSUPP

SCBSUPP_CRSE_NUMB

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

NA

SYSDATE

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

NA

NA

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

OCCUPATIONAL_COURSE Setting of the occupational course indicator code. VARCHAR2(2)

SCBSUPP

SCBSUPP_OCCS_CODE

OCCUPATIONAL_COURSE_DESC Occupational course indicator description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

PERMANENT_DISTRICT_IND Permanent district identifier. VARCHAR2(12)

SCBSUPP

SCBSUPP_PERM_DIST_IND

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

SCBSUPP

SCBSUPP_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

TAXONOMY_OF_PROGRAM Government reporting code typically used for reporting of vocational technical courses or subjects. VARCHAR2(6)

SCBSUPP

SCBSUPP_TOPS_CODE

TAXONOMY_OF_PROGRAM_DESC Taxonomy of program code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA



Ver: 8.1