Data Source	Oracle
Job/Process Source (Refresh Interval)	Live
Report Domain
Functional User(s)	Daniel Alvarado (Curriculum Specialist), Vanessa Escobar (Scheduling Coordinator)
Stakeholder(s)
Report Owner	Daniel Alvarado (Curriculum Specialist)
Data Domain(s)	Academic
Contains PII	No

🛠 What It’s Used For

Shows the number of material fees and the total fees collected at census per Division. Does not include canceled sections.

🔘 Options

Options	Description
Term	Common alias for `%TERM_CODE`. The first 4 digits are determined by the Academic Calendar end year. The last 2 digits refer to the semester/intersession where "10" represents Fall, "20" - Spring, and "30" - Summer. Sequoias CCD has a preceding Summer Academic Calendar. 7% was used for Community Education 999999 is the `STVTERM_TERM_CODE` value used to represent “The End of Time” (The “End of Time” has an End Date of 05/15/2999. So, if you are reading this around that time plan accordingly. ⏲) 000000, conversely, represents “The Beginning of Time” (The beginning of time has a Start Date at 01/01/1900. Nothing existed prior to this date. 🙃 ) Semester YYYY is the typical format for how this description field is populated. (Spring 2022)
Division	Grouping of departments and/or courses.
Instructor	Selectable after you select a Division.
Campus	Selectable after Term is selected.

Field Name	Data Source/Logic	Description (sample)
Division
Division Code
Count		Number of distinct sections
Total		Total Fees Census In the Division for this row, this is the total of the fees multiplied by the enrollment at census.