Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Neu Catalog Data Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: NEU_CATALOG_DATA - NEU_CATALOG_DATA

Description This folder contains information about courses in the university catalog

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
SCBCRSE_LAB_HR_IND     VARCHAR2(2 CHAR)      
SCBCRSE_LEC_HR_HIGH     NUMBER(7,3)      
SCRGMOD_CONCAT_DESC   Defines grading mode authorizations description for a course VARCHAR2(3000 CHAR)      
SCBCRSE_ACTIVITY_DATE     DATE      
SCBCRSE_ADD_FEES_IND     VARCHAR2(1 CHAR)      
SCBCRSE_APRV_CODE     VARCHAR2(1 CHAR)      
SCBCRSE_BILL_HR_HIGH     NUMBER(7,3)      
SCBCRSE_BILL_HR_IND     VARCHAR2(2 CHAR)      
SCBCRSE_BILL_HR_LOW     NUMBER(7,3)      
SCBCRSE_CAPP_PREREQ_TEST_IND     VARCHAR2(1 CHAR)      
SCBCRSE_CEU_IND     VARCHAR2(1 CHAR)      
SCBCRSE_CIPC_CODE     VARCHAR2(6 CHAR)      
SCBCRSE_COLL_CODE     VARCHAR2(2 CHAR)      
SCBCRSE_CONT_HR_HIGH     NUMBER(7,3)      
SCBCRSE_CONT_HR_IND     VARCHAR2(2 CHAR)      
SCBCRSE_CONT_HR_LOW     NUMBER(7,3)      
SCBCRSE_CREDIT_HR_HIGH     NUMBER(7,3)      
SCBCRSE_CREDIT_HR_IND     VARCHAR2(2 CHAR)      
SCBCRSE_CREDIT_HR_LOW     NUMBER(7,3)      
SCBCRSE_CRSE_NUMB     VARCHAR2(5 CHAR)      
SCBCRSE_CSTA_CODE     VARCHAR2(1 CHAR)      
SCBCRSE_DATA_ORIGIN     VARCHAR2(30 CHAR)      
SCBCRSE_DEPT_CODE     VARCHAR2(4 CHAR)      
SCBCRSE_DIVS_CODE     VARCHAR2(4 CHAR)      
SCBCRSE_DUNT_CODE     VARCHAR2(4 CHAR)      
SCBCRSE_EFF_TERM     VARCHAR2(6 CHAR)      
SCBCRSE_LAB_HR_HIGH     NUMBER(7,3)      
SCBCRSE_LAB_HR_LOW     NUMBER(7,3)      
SCBCRSE_LEC_HR_LOW     NUMBER(7,3)      
SCBCRSE_MAX_RPT_UNITS     NUMBER(9,3)      
SCBCRSE_NUMBER_OF_UNITS     NUMBER(7,2)      
SCBCRSE_OTH_HR_HIGH     NUMBER(7,3)      
SCBCRSE_OTH_HR_IND     VARCHAR2(2 CHAR)      
SCBCRSE_OTH_HR_LOW     NUMBER(7,3)      
SCBCRSE_PWAV_CODE     VARCHAR2(1 CHAR)      
SCBCRSE_REPEAT_LIMIT     NUMBER(2)      
SCBCRSE_REPS_CODE     VARCHAR2(2 CHAR)      
SCBCRSE_SUBJ_CODE   Subject Code Information from Course General Base Table VARCHAR2(4 CHAR)      
SCBCRSE_TITLE     VARCHAR2(30 CHAR)      
SCBCRSE_TUIW_IND     VARCHAR2(1 CHAR)      
SCBCRSE_USER_ID     VARCHAR2(30 CHAR)      
SCBDESC_TEXT_NARRATIVE   Course Catalog Description Narrative Text VARCHAR2(4000 CHAR)      
SCBSUPP_CCSL_CODE     VARCHAR2(3000 CHAR)      
SCBSUPP_COOP_ED_IND     VARCHAR2(3000 CHAR)      
SCBSUPP_CREDIT_CATEGORY_IND     VARCHAR2(3000 CHAR)      
SCBSUPP_CUDA_CODE     VARCHAR2(3000 CHAR)      
SCBSUPP_CUDB_CODE     VARCHAR2(3000 CHAR)      
SCBSUPP_CUDC_CODE     VARCHAR2(3000 CHAR)      
SCBSUPP_CUDD_CODE     VARCHAR2(3000 CHAR)      
SCBSUPP_CUDE_CODE     VARCHAR2(3000 CHAR)      
SCBSUPP_CUDF_CODE     VARCHAR2(3000 CHAR)      
SCBSUPP_OCCS_CODE     VARCHAR2(3000 CHAR)      
SCBSUPP_PERM_DIST_IND     VARCHAR2(3000 CHAR)      
SCBSUPP_TOPS_CODE     VARCHAR2(3000 CHAR)      
SCRATTR_CONCAT   Course Attributes Codes VARCHAR2(3000 CHAR)      
SCRATTR_CONCAT_DESC   Course Attributes Description VARCHAR2(3000 CHAR)      
SCRCORQ_CONCAT   Course Corequisites VARCHAR2(3000 CHAR)      
SCRCPRT_CONCAT   Partition Codes define campus zones, which are catagories or groupings of rooms. This table contains course partition codes in the catalog module. VARCHAR2(3000 CHAR)      
SCRCPRT_CONCAT_DESC   Partition Codes define campus zones, which are catagories or groupings of rooms. This table contains course partition codes in the catalog module. VARCHAR2(3000 CHAR)      
SCRCRDF_CONCAT   Room definition/attribute code for catalog course entry VARCHAR2(3000 CHAR)      
SCRCRDF_CONCAT_DESC   Room definition/attribute code descriptions for catalog course entry VARCHAR2(3000 CHAR)      
SCREQIV_CONCAT   Defines an equivalent course subject codes for the master course VARCHAR2(3000 CHAR)      
SCREQIV_CONCAT_DESC   Defines an equivalent course subject code descriptions for the master course VARCHAR2(3000 CHAR)      
SCRFEES_CONCAT   Defines the type of fee to fee assessment VARCHAR2(3000 CHAR)      
SCRFEES_CONCAT_DESC   Defines the type of fee description to fee assessment VARCHAR2(3000 CHAR)      
SCRGMOD_CONCAT   Defines grading mode authorizations for a course VARCHAR2(3000 CHAR)      
SCRINTG_CONCAT   Define the User Integration Codes for a Course VARCHAR2(3000 CHAR)      
SCRINTG_CONCAT_DESC   Define the User Integration Codes description for a Course VARCHAR2(3000 CHAR)      
SCRLEVL_CONCAT   Defines the Course Level Codes VARCHAR2(3000 CHAR)      
SCRLEVL_CONCAT_DESC   Defines the Course Level Codes Description VARCHAR2(3000 CHAR)      
SCRRARE_CONCAT   Defines the Area codes description of students for which course registration restrictions exist VARCHAR2(3000 CHAR)      
SCRRARE_CONCAT_DESC   Defines the Area codes description of students for which course registration restrictions exist VARCHAR2(3000 CHAR)      
SCRRCAM_CONCAT   Defines the Catalog campus restriction campus code VARCHAR2(3000 CHAR)      
SCRRCAM_CONCAT_DESC   Defines the Catalog campus restriction campus code description VARCHAR2(3000 CHAR)      
SCRRCLS_CONCAT   Defines the classification codes of students for which registration restrictions exist. VARCHAR2(3000 CHAR)      
SCRRCLS_CONCAT_DESC   Defines the classification codes description of students for which registration restrictions exist. VARCHAR2(3000 CHAR)      
SCRRCMP_CONCAT   Defines the campus codes for which campus schedule restrictions exist VARCHAR2(3000 CHAR)      
SCRRCMP_CONCAT_DESC   Defines the campus codes description for which campus schedule restrictions exist VARCHAR2(3000 CHAR)      
SCRRCOL_CONCAT   Defines the college(s) codes of students for which course registration restrictions exist VARCHAR2(3000 CHAR)      
SCRRCOL_CONCAT_DESC   Defines the college(s) codes description of students for which course registration restrictions exist VARCHAR2(3000 CHAR)      
SCRRDEG_CONCAT   Defines the degree codes of students for which course registration restrictions exist VARCHAR2(3000 CHAR)      
SCRRDEG_CONCAT_DESC   Defines the degree codes description of students for which course registration restrictions exist VARCHAR2(3000 CHAR)      
SCRRLVL_CONCAT   Defines the Course Level Restriction Level Codes VARCHAR2(3000 CHAR)      
SCRRLVL_CONCAT_DESC   Defines the Course Level Restriction Level Codes Description VARCHAR2(3000 CHAR)      
SCRRMAJ_CONCAT   Defines the majors codes of students for which registration restrictions exist VARCHAR2(3000 CHAR)      
SCRRMAJ_CONCAT_DESC   Defines the majors codes descr of students for which registration restrictions exis VARCHAR2(3000 CHAR)      
SCRRPRG_CONCAT   Defines the Program(s) of students for which course registration restrictions exis VARCHAR2(3000 CHAR)      
SCRRPRG_CONCAT_DESC   Describes the Program code of students for which course registration restrictions exist VARCHAR2(3000 CHAR)      
SCRRTRM_CONCAT   Defines the term codes for which term scheduling restrictions exist VARCHAR2(3000 CHAR)      
SCRRTRM_CONCAT_DESC   Defines the term code descriptions for which term scheduling restrictions exist VARCHAR2(3000 CHAR)      
SCRRTST_CONCAT   The course test score restriction and course pre-requisites VARCHAR2(3000 CHAR)      
SCRSBGI_CONCAT   Defines the Source background institution code VARCHAR2(3000 CHAR)      
SCRSBGI_CONCAT_DESC   Defines the Source background institution code description VARCHAR2(3000 CHAR)      
SCRSCHD_CONCAT   Course Schedule Type Code VARCHAR2(3000 CHAR)      
SCRSCHD_CONCAT_DESC   Course Schedule Type Description VARCHAR2(3000 CHAR)      
SCRSYLN_COURSE_URL   Defines the URL of the course VARCHAR2(4000 CHAR)      
SCRSYLN_LONG_COURSE_TITLE   Defines the long title of the course VARCHAR2(4000 CHAR)      
SCRSYLO_LEARNING_OBJECTIVES   Course Syllabus course learning objectives VARCHAR2(4000 CHAR)      
SCRSYRM_REQ_MATERIALS   Defines the Required Materials for the course VARCHAR2(4000 CHAR)      
SCRSYTR_TECH_REQUIREMENT   Defines the Technical Requirements for the cours VARCHAR2(4000 CHAR)      
SCRTEXT_CONCAT   Defines the Course Text VARCHAR2(3000 CHAR)      


Ver: 9.0