Versions Compared

Old Version 34

changes.mady.by.user Sangita Singh

Saved on

compared with

New Version 35

changes.mady.by.user Sangita Singh

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Live Search
spaceKeyODS
placeholderSearch Within ODS Knowledge Base
typepage
labelsknowledge_base



Section


Column
width5%


Column
width95%


Panel
borderColor#006747
bgColor#F4F5F7

Semester Seats Analysis – End of Term Report  

This report provide a summary of the number of sections, course section enrollment, 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 end of term numbers. 

Data Source: Banner
Refresh schedule:  Thrice daily. The “Last Refreshed” timestamp on each page indicates the time when the data was last refreshed.





Panel
titleColorwhite
titleBGColor#006747
titleReport pages



  • Page 1: Sections by Term Campus College and Level -> Provides a summary of the number of sections, seats filled, seats available and gross SCH by budget unit (funding campus), college, department and course level. Drill through page is associated with this page to review section level details. 
  • Page 2: PTRM Summary View ->Provides the summary numbers by part of term. Drill through page is associated with this page to review section level details. 
  • Page 3: Course Level Summary View ->Provides the summary numbers by course level. Drill through page is associated with this page to review section level details. 
  • Page 4: Section Type Summary View ->Provides the summary numbers by section type. Drill through page is associated with this page to review section level details. 

     NOTE: Filters are available on each page to view number by semester, part of term, active/held sections (by default active sections are selected), budget unit(funding campus) and college.



Panel
titleColorwhite
titleBGColor#006747
titleGlossary


Data ElementData SourceDescriptionReport Page

Active/Held Sections

BANNER->SSBSECT->SSBSECT_SSTS_CODE 

Active sections are the sections currently active on the Banner Course Schedule. These are coded SSBSECT_SSTS_CODE = 'A'. Held sections are those with an SSBSECT_SSTS_CODE = 'H' and are on stand by and may be opened if needed.

All

Budget Unit or Funding campus

BANNER>NVL(SWBOVRR_OPERATING_UNIT,SWBSUPP_OPERATING_UNIT)

This is 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 college of course record, as listed in Banner Catalog.

All

Department

BANNER->NVL(SSBOVRR_DEPT_CODE,SCBCRSE_DEPT_CODE)

Course override department, if it exists, or the department of course record from Banner Catalog.

1

Course level

Calculated field using course number

BANNER->SSBSECT->SSBSECT_CRSE_NUMB

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)

1,3

Sections

BANNER→SFRSTCR, SFRSTCA 

Count of sections – active or held as filtered. Active sections are selected by default.

All

PTRM

BANNER->SSBSECT->SSBSECT_PTRM_CODE

Part of the term

All

Section Type

BANNER->SSBSECT->SSBSECT_SCHD_CODE

The section type of the course section (i.e., Class Lecture)

4

Section Enrl

BANNER->SSBSECT->SSBSECT_ENRL

Number of section enrollments or seats filled

All

Seat Avail

BANNER->SSBSECT->SSBSECT_MAX_ENRL

Total seats available in the course sections. For the previous year, this category includes sections with enrollment only. Current year numbers include sections with or without enrollment.

All

SCH

BANNER->SSBSECT->SSBSECT_TOT_CREDIT_HRS

Total gross student credit hours generated

All

Sec Diff

Calculated field 

Current year – Previous year numbers

All

Percent change in Sec

Calculated field 

Percentage change over one year difference

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

%Prev Yr Seats Filled

Calculated field 

Section Enrl/Seats Available

All

%Curr Yr Seats Filled

Calculated field 

Section Enrl/Seats Available

All




Panel
titleColorwhite
titleBGColor#006747
titleTips

Filter Panels

Filters are listed on top panel of the report.

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 Small 25mm Lapel Pin Button Badge Novelty Plain White Badge ... .
  • 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

This 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 Black Triangle PNG, Free HD Black Triangle Transparent Image - PNGkit ,  you can sort that column in ascending or descending order by clicking on your mouse. 

   Select a column header to sort by that value, such as College or Department.  

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: 




Panel
titleColorwhite
titleBGColor#006747
titleYou Might Also Be Interested In...