Data Source	PROD_DB
Job/Process Source (Refresh Interval)	Baseline Banner Tables (Live Data)
Functional User(s)
Report Owner	Vanessa Escobar (Scheduling Coordinator)
Contains PII	No

What It’s Used For

To analyze if more/less sections should be offered or if Enrollment Capacity’s should be changed.

Replaces EIS - Section Fill Rate report which did not have data down to the section level.

Options

Options	Description

Options	Description
Accounting Method	Allows the results to be filtered based on the Section’s accounting method. Defined by SSBSECT_ACCT_CODE.
Term	Allows the results to be filtered based on the Section’s term code. Defined by SSBSECT_TERM_CODE.
Academic Year	Allows the results to be filtered based on the Academic Year. This is the Academic Year associated with the Section’s Term Code. Defined by the STVTERM_ACYR_CODE referenced from the section’s SSBSECT_TERM_CODE.

Field Name	Data Source/Logic	Description (sample)

Field Name	Data Source/Logic	Description (sample)
Measurements
Census Enroll	SSBSECT_CENSUS_ENRL
Max Enroll	SSBSECT_MAX_ENROL	The Max Enroll value represents the maximum enrollment capacity for the Section.
Fill Rate	“Census Enroll” / “Max Enroll”	The Fill Rate is the ratio between the Section’s census enrollment and the Section’s max enrollment. If a Section’s census enrollment is 10 and its max enrollment is 20, then Fill Rate is 10 / 20 = 0.50
Fill Rate %	“Fill Rate” * 100%	The percentage representation of the Fill Rate. If a Section’s Fill Rate is 0.50, then Fill Rate % is 0.5 * 100% = 50%
Dimensions
Division	SCBCRSE_DIVS_CODE	SCBCRSE is joined on Subject and Course, with the most recent effective term up until, and including, section’s Term.
Subject	SSBSECT_SUBJ_CODE	The section’s subject code.
Course	SSBSECT_CRSE_NUMB	The section’s course.
CRN	SSBSECT_CRN	The section’s CRN.

A unique Section is defined by a CRN and Term.