Semester Seats Analysis – Point-in-Time Report
This report provide a summary of course section enrollments, seats available and gross SCH by budget unit (funding campus), college, department and course level. Current numbers are shown in comparison to the previous year’s point-in-time numbers.
The "Seats Available" for the previous year on this report is indicative of the caps in the Schedule as off end of term.
Data Source: Banner
Refresh schedule: Thrice daily. The “Last Refreshed” timestamp on each page indicates the time when the data was last refreshed.
- Pages 1 & 5: Fall /Summer- By Campus -> Provides summary numbers for section enrollment, active seats available and gross SCH by budget unit or funding campus of the course section. Part of Term filter is available for summer semester.
- Pages 2 & 6: Fall /Summer – By Camp & Level -> Provides section enrollment and gross SCH by budget unit and course level.
- Pages 3 & 7: Fall /Summer – By Camp Coll Level ->Provides summary numbers by budget unit, college and course level.
- Pages 4 & 8: Fall /Summer – By Camp Coll Dept ->Provides summary numbers by budget unit, college, department and course level.
| Data Element | Data Source | Description | Report Page |
|---|---|---|---|
Budget Unit | BANNER>NVL(SWBOVRR_OPERATING_UNIT,SWBSUPP_OPERATING_UNIT) | This is the operating unit associated with the course section. Maintained in the Banner Schedule Override form. | All |
College | BANNER-> NVL(SSBOVRR_COLL_CODE,SCBCRSE_COLL_CODE) | Course override college, if it exists, or the course college, as listed in Banner Catalog. | 3, 4, 7, 8 |
Crslevl | Course Level Definition: UGLL=1000-2999 Courses UGUL=3000-4999 Courses GR1=5000-69999 Courses GR2> 7000 Courses GR3 = Medical sections Placeholder (INTO, Intl Exch, Palazzi, Semester) | 2, 3, 4, 6, 7, 8 | |
Department | Course override department, if it exists, or the department of record as listed in Banner Catalog. | 4, 8 | |
Section Enrl | Number of section enrollments or seats filled | All | |
Seats Available | Total seats available in the section. For previous year, this total includes active sections with enrollment. For current year this category includes active section with or without enrollment. | 1, 3, 4, 5, 7, 8 | |
SCH | Total gross student credit hours generated | All | |
Enrl Diff | Calculated field | Current year – Previous year numbers | All |
Percent Change in Enrl | Calculated field | Percentage change over one year difference | All |
SCH Diff | Calculated field | Current year – Previous year numbers | All |
Percent Change in SCH | Calculated field | Percentage change over one year difference | All |
Avail Diff | Calculated field | Current year – Previous year numbers | All |
Percent Change in Avail | Calculated field | Percentage change over one year difference | All |
Filter Panels
If filters are available, filter panel will be on top or left of data panel. All pages may not have filter panel.
Notes:
- Click the down arrow to select from options in the filters and narrow down your results.
- To deselect an item, click on the option again.
- Some filters are radio buttons and you can select only one item. The items in these filters are indicated as round buttons
. - Some filters allow multiple selections. To select multiples in a filter, hold the Ctrl key as you check the square boxes
.
- Filters for the report may not have Blank as an option.
Data Panel
Data panel displays the filtered results. To work with data in this panel:
- Select an individual row in the table to highlight the item/row. Select it again to return to the full table view.
- You can sort the data by column values, if the sorting is available for that column. Hover your mouse over the last row item in the column header and if a small black triangle appears
, you can sort that column in ascending or descending order by clicking on your mouse.
Tasks
Export Data to Excel
To export the data results to Excel, hover your mouse over the upper right hand side corner of the data table and a horizontal menu bar 
will pop up. Click the 
in the top right corner .
A drop down menu will appear with 'Export data' as one of the options. Select Export Data to work with the data in Excel.
Note : The exported data in Excel may not look exactly like the screen.
Drill through
To 'Drill through', right click on a data cell in the data table. A menu will pop up with 'Drill Through" as one of the options. Selecting drill-though option will open another window with the details.
Note : All data tables may not have 'Drill through' functionality.
Reset to Default
If you have made any changes, such as implementing filters or sorting the table, you have the ability to return the sorting and filtering to the report creator's default view. Click the Reset to Default image in the Report Header: 