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 divisions and courses.
Instructor	Selectable after you select a subject.
Campus

Field Name	Data Source/Logic	Description (sample)