Data Source | PROD_DB |
---|---|
Job/Process Source (Refresh Interval) | Baseline Banner Tables (Live Data) |
Functional User(s) | |
Report Owner | |
Contains PII | No |
🛠 What It’s Used For
🔘 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. |
📄 Results
Field Name | Data Source/Logic | Description (sample) |
---|---|---|
Measurements | ||
Census Enroll | SSBSECT_CENSUS_ENRL | Error rendering macro 'excerpt-include' : No link could be created for 'DOC:Common Definitions'. |
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. |
🗺 Report Domain
A unique Section is defined by a CRN and Term.
Version | Date | Comment |
---|---|---|
Current Version (v. 2) | Jun 29, 2022 20:25 | Jordan Lamb |
v. 2 | Jun 29, 2022 20:25 | Jordan Lamb |
v. 1 | Jun 29, 2022 19:57 | Garrett Woodard |
Add Comment