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 |
|---|---|
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) | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
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.
| ||||||||||
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. | ||||||||||
...