Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
  • 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 canceled Cancelled (“C”, “R”, “N”) sections.

🔘 Options

Options

Description

Term

Insert excerpt
Common Definitions
Common Definitions
nameTERM_CODE
nopaneltrue
Insert excerpt
Common Definitions
Common Definitions
nameTERM
nopaneltrue

Division

Grouping of divisions departments and/or courses.

Instructor

Selectable after you select a subjectDivision.

Campus

Selectable after Term is selected.

📄 Results (Top)

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.

📄 Results (Bottom)

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

...

Change History