Semester Seats Analysis – End of Term
Part of Student Success Hub
maintained by Student Success Research and Analytics
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: Twice daily. The “Last Refreshed” timestamp on each page indicates the time when the data was last refreshed.
Report pages
Summary of sections by one USF structure -> 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
Part of Term Summary ->Provides the summary numbers by part of term
Course Level summary ->Provides the summary numbers by course level
Section Type summary ->Provides the summary numbers by section type
Modality → Provides the summary numbers by course section modality
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.
All of the pages on this report provide drill throughs to course section level details. Right-clicking into a data cell in the data table shows the "Drill through" option.
Glossary
Data Element | Data Source | Description | Report 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 the operating unit associated with the course section. Maintained in the Banner Schedule Override form. | All |
College | SID_Title_GlobalDepartments_All_Vw | Global College code (derived using xref-rules created by IT for mapping course department ID to one usf global college code and department. | All |
CollegeTitle | SID_Title_GlobalDepartments_All_Vw | Global college title | All |
DepartmentTitle | SID_Title_GlobalDepartments_All_Vw | Global department code (derived using xref-rules created by IT for mapping course department ID to one usf global college and department. | All |
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 O = Others. These are placeholder sections and include (INTO AE courses, Intl Exch, Palazzi, Semester) Please note: Some 6000 level courses may go in either category of Grad I or Grad II. Hence for the purpose of this report, courses 5000-6999 level are counted as Grad I and course above 6000 level are counted as Grad II. | Summary of sections by one USF structure Drill-through pages |
Sections | BANNER→SFRSTCR, SFRSTCA | Count of sections – active or held as filtered. Active sections are selected by default. | All |
PartOfTerm | 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) |
|
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 |
Section Modality | BANNER→ SSBSECT→ SSBSCET_INSM_CODE | AD,CL,HB or PD section modalities | Modality |