...
| 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 | BANNER->SHRDGMR->SHRDGMR_DEGS_CODE | ||
| Degree App Term | BANNER->SHRDGMR->SHRDGMR_TERM_CODE_GRAD | ||
| Degree Status | BANNER->SHRDGMR->SHRDGMR_DEGS_CODE | ||
| Degree Type | CRETE ->DIMDGWSTUDENT>DGW_DEGREE | ||
| Department | BANNER->SGBSTDN->SGBSTDN_DEPT_CODE | Department that is funding the course. | |
| DGW Overall % | CRETE ->DIMDGWSTUDENTREQUIREMENTS->DGW_COMPLETION_PERCENTAGE | ||
| DGW Req Comp % | CRETE ->DIMDGWSTUDENTREQUIREMENTS->DGW_REQUIREMENTS_COMPLETION_PERCENTAGE | ||
| DGW Requirements | CRETE ->DIMDGWSTUDENTREQUIREMENTS->DGW_REQUIREMENTS | ||
| CRETE ->DIMDGWSTUDENT>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 | CRETE ->DIMDGWSTUDENT->DGW_ACTIVE_TERM | ||
| Major | BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_1 | ||
| Major2 | BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_2 | ||
| Max Enrollment | BANNER->SSBSECT->SSBSECT_MAX_ENRL | Indicates the total number of available seats in the current semester for all campuses. | |
| Minor1 | BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_MINR_1 | ||
| Minor2 | BANNER->SGBSTDN->SGBSTDN_MAJR_CODE_MINR_2 | ||
| Name First | CRETE ->DIMDGWSTUDENT->PERSONNAMEFIRST | ||
| Name Last | CRETE ->DIMDGWSTUDENT->PERSONNAMELAST | ||
| PIDM | BANNER->CSCHED_REGCART->PIDM | ||
| Potential Deficit | Max Enrollment-Interest Student # | Calculated column | |
| Program Name | CRETE->TEMP_COURSEDEMAND->PROGRAMNAME | ||
| 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 | BANNER->SSBSECT->SSBSECT_SCHD_CODE | ||
| Student Level | CRETE ->DIMDGWSTUDENT->STUDENTINSTITUTIONALCLASSIFICATION | ||
| Student Type | BANNER->STVSTYP->STVSTYP_CODE | ||
| Term Code | BANNER->CSCHED_REGCART->TERM_CODE | ||
UID | BANNER->CSCHED_REGCART->STUDENTID |
| Gallery | ||||
|---|---|---|---|---|
|
...