BACKLOGGING THIS UNTIL WE MOVE SECTION SEATING TO SNOWFLAKE REFERENCES. In Michael’s dev>backlog folder.

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

Options	Description
Term
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)

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)

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