Oracle

Live

Course Material Fees

Finance

No

Term

Select the relevant term.

Division

Select a division (optional)

Instructor

Select an Instructor (optional)

Select Campus

“All” campuses checked by default. Uncheck to see specific campuses. The campus list is a multi-select box and more than one can be chosen at a time (Hold CTRL and click each campus you wish to use in the query).

Division

STVDIVS_DESC

Division names (description) based on selected Term, Campus, and optionally Division dropdown list.

Division_Code

STVDIVS_CODE

Division codes based on selected Term, Campus, and optionally Division dropdown list.

Count

COUNT (SSRFEES_DETL_CODE)

A Count of each Section grouped within the selected term & division.

Total

Function that aggregates (sum) the Section Fee values for each CRN (F_SCHED_FEES)

Sum of all section fees for each CRN in a given Division group.

Detail Section

CRN

SSBSECT_CRN

CRN

Course

SSBSECT_SUBJ_CODE + SSBSECT_CRSE_NUMB

Course subject and number.

Title

SSBSECT_CRSE_TITLE

Course title.

Units

SSBSECT_CREDIT_HRS or

(SCBCRSE_CREDIT_HR_HIGH or SCBCRSE_CREDIT_HR_LOW)

Units for the Course.

Start Date

SSBSECT_PTRM_START_DATE

Section Start Date.

End Date

SSBSECT_PTRM_END_DATE

Section End Date.

Current Enroll

SSBSECT_ENRL

Current student enrollment.

Census Enroll

SSBSECT_CENSUS_ENRL

Enrollment at Census date.

Section Fee

F_SCHED_FEES

Section Fee per student.

Code

SSRFEES_DETL_CODE

Total Fee

SUM of Section Fees * Census Enroll value

Total section fee based on census enroll students and section fees.

Instructor

SPRIDEN_LAST_NAME + SPRIDEN_FIRST_NAME

or

"STAFF"

Primary instructor’s last, first name. “Staff” if no primary instructor listed.