...
| Element | Source (System->Table->Column) | Description | Frequency of Update |
|---|---|---|---|
| # of Sections | BANNER->SSBSECT->SSBSECT_SEQ_NUMB | Count of SSBSECT_SEQ_NUMB | Live |
| Campus | BANNER->SSBSECT->SSBSECT_CAMP_CODE | ||
| Cohort | BANNER->SGRCHRT->SGRCHRT_CHRT_CODE | ||
College | BANNER->SCBCRSE->SCBCRSE_COLL_CODE | College that is funding the course. | |
| Conc1 | BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_CONC_1 | Concentration | |
| Conc2 | BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_CONC_2 | Concentration | |
| Course Attributes | BANNER->SCRATTR->SCRATTR_ATTR_CODE | Course level attributes from Banner. | Live |
| Course Number | BANNER->SCBCRSE→SCBCRSE_CRSE_NUMB BANNER->SSBSECT->SSBSECT_CRSE_NUMB | The code that includes the level of a course and is assigned to identify the course in a systematic manner. | |
| Course Prefix | BANNER->SCBCRSE→SCBCRSE_SUBJ_CODE BANNER->SSBSECT->SSBSECT_SUBJ_CODE | The alpha abbreviation assigned to a course by Common Course Numbering. | |
| Course Section (=Section Number) | BANNER->SSBSECT->SSBSECT_SEQ_NUMB | A unique identifier assigned by the institution for each section of a course offered during the term reported. | |
| Course Session | BANNER->SSBSECT->SSBSECT_PTRM_CODE | ||
| Course Title | BANNER->SCBCRSE_TITLE | Course title. | |
| Current Enrollment | BANNER->SSBSECT->SSBSECT_ENRL | Current student enrollment, updated regularly when registration is open. | |
| Delivery Method | SID_Instructional_Activity->delivery_method_ind | Online delivery method = AD | |
| Degree App Status | |||
| Degree App Term | |||
| Degree Status | |||
| Degree Type | |||
| Department | Department that is funding the course. | ||
| DGW Overall % | |||
| DGW Req Comp % | |||
| DGW Requirements | |||
| CRETE ->DGWSTUDENT_REQUIREMENTS->EMAIL | |||
| Enrollment # Year-1 | SID_Instructional_Activity->SECTN_HEADCNT_ENROL | Actual enrollment number for the course in the same semester one year prior for all campuses. | |
| Enrollment # Year-2 | SID_Instructional_Activity->SECTN_HEADCNT_ENROL | Actual enrollment number for the course in the same semester two years prior for all campuses.. | |
| Enrollment # Year-3 | SID_Instructional_Activity->SECTN_HEADCNT_ENROL | Actual enrollment number for the course in the same semester three years prior for all campuses.. | |
| Enrollment # Year-4 | SID_Instructional_Activity->SECTN_HEADCNT_ENROL | Actual enrollment number for the course in the same semester four years prior for all campuses.. | |
| Enrollment # Year-5 | SID_Instructional_Activity->SECTN_HEADCNT_ENROL | Actual enrollment number for the course in the same semester five years prior for all campuses.. | |
| Interest Student # | CSCHED_REGCART | Number of students interested in taking the course from the College Scheduler tool for undergraduate students. Count of rows for the term_code, crn, pidm in CSCHED_REGCART table. | |
| Last Enrolled Term | |||
| Major | |||
| Major2 | |||
| Max Enrollment | BANNER->SSBSECT->SSBSECT_MAX_ENRL | Indicates the total number of available seats in the current semester for all campuses. | |
| Minor1 | |||
| Minor2 | |||
| Name First | |||
| Name Last | |||
| PIDM | |||
| Potential Deficit | Max Enrollment-Interest Student # | Calculated column | |
| Program Name | |||
| QM Flag | CRETE -> temp_qmcourses | This flag indicates the course has a Quality Matters or equivalent designation. | |
| Section College | BANNER->SCBCRSE->SCBCRSE_COLL_CODE | ||
| Section Department | BANNER->SCBCRSE->SCBCRSE_DEPT_CODE | ||
| Section Number | BANNER->SSBSECT->SSBSECT_SEQ_NUMB | ||
| Section Type | |||
| Student Level | |||
| Student Type | |||
| Term Code | |||
UID | |||
...