Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Course Demand Reports
NotesIntro here: To provide information about “courses” as well as “sections within courses”, with continuous Banner updates. tools that can assist in the development of course schedules within and across colleges and campuses
...
Report Elements Glossary Table
...
General Intro
Report: Course Demand - College Scheduler Details |
---|
...
It shows the courses that the students have showed interested in signing up for within College Scheduler. Other attributes from Banner like the degree status and the cohort information are available as filters. Also included are the QM flags and program filters to look for specific required courses. This is not for past classes. Doesn't give number of students or number of total records.
Filters
Campus
Cohort
College
...
start with the Degree Works report and identify students close to completion and then using this new report to see what courses they want to take. Once identified, the courses can be looked up on the course level and section level reports to ensure enough seats are available. I’m sure you can think of other options as well.
This is a listing of students with all of their requirements for their degree. Includes total number of students and total number of records.
Lots of filters
Filters
Campus
Cohort
College
...
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 | Identifies the campus of the student or where the course is being taught. | Live |
Cohort | BANNER->SGRCHRT->SGRCHRT_CHRT_CODE | The specific classification for students, established for tracking and reporting. This report uses the following formatting/categorization: FTICYY08 – Full-time first time in college student entering in summer (continuing to fall) or fall semesters. SKRALLYY08 – Full- or part-time first time in college student entering in summer (continuing to fall) or fall semesters. | |
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 | Classification of student from these options:
| Live |
Student Level | CRETE ->DIMDGWSTUDENT->STUDENTINSTITUTIONALCLASSIFICATION | ||
Student Type | BANNER->STVSTYP->STVSTYP_CODE | ||
Term Code | BANNER->CSCHED_REGCART->TERM_CODE | Live | |
UID | BANNER->CSCHED_REGCART->STUDENTID |
...