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 Cancelled (“C”, “R”, “N”) 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 of the course
Division Code
Section Count		Number of distinct sections
Total Fees		Total Fees Census in the Division for this row, this is the total of the fees multiplied by the enrollment at census.

Field Name	Data Source/Logic	Description (sample)
Course
Title
Unit
CRN
Instructor
Start Date
End Date
Current Enroll		Section current enrollment
Census Enroll		Section enrollment at Census
Code		Material Code
Section Fee		Total Material Fee by student
Total Fee		Total Material Fees by section