Fees Filter Fields for Ad hoc Reporting

The Ad hoc Reporting tools allow you to create custom queries and reports on various types of information stored within the Campus database. Reports may be used for data analysis and state reporting and queries may be exported out of Campus or used to create filters for standard reports. Custom filters and reports are built by adding elements from Ad hoc Reporting tools like the Filter Designer and the Letter Designer.

On This Page

Fee Detail

Student > Fee > Fee Detail
Screenshot of fee detail
Filter FieldMapping & Definition

personID

Internal database identifier.

gradeStudent Information > General > Enrollments
Notes the grade level of the student.
assignmentIDInternal database identifier.

calendarID

Internal database identifier.

dueDate

Student Information > Fees
Date the fee is due to be paid.

endYear

Student Information > Fees

The ending year of the calendar; e.g., 2022-2023 end year is 2023.

exempt

Student Information > Fees
When marked, this checkbox indicates the student is exempt from selected fee.

dateExemptedStudent Information > Fees
The date on which the student's fee was marked as exempt.
createdDateStudent Information > Fees
The date on which the fee was assigned to the student.

comments

Student Information > Fees
User-entered comments on the fee.

exemptFeeMax

Student Information > Fees
Indicates the fee is exempt from Fee Maximums
voidID

Internal database identifier.

voidDate

Student Information > General > Fees
The date on which the fee was made void.
voidComments

Student Information > General > Fees
Comments made when the fee was made void.

courseID

Internal database identifier.

courseNumber

Scheduling > Courses > Fees 
Course number associated with fee.

courseName

Scheduling > Courses > Fees 
Course name associated with fee.

feeID

Internal database identifier.

feeName

Fees > Fees
Fee name.

feeDescription

Fees > Fees
Fee description.

variableRateStudent Information > General > Fees
The Fee amount when it was assigned to the student.

feeType

Fees > Fees
Activity or event for which the fee is assessed, as set up in System Administration > Custom > Attribute/Dictionary > Fee > Fee Type.

nonstackable

Fees > Fees
If flagged, Assessed Only Once checkbox indicates the fee cannot be assessed more than one time.

accountNumber

Fees > Fees
District finance account with which this fee is associated.

showForParents

Fees  > Fees

Indicates whether the Display on Parent Portal checkbox is marked.

showForStudents

Fees  > Fees

Indicates whether the Display on Student Portal checkbox is marked.

feeDebitStudent Information > General > Fees
The amount of the fee.

feeCredit

Student Information > General > Fees
Amount student has paid toward the fee.

feeAdjustment

Student Information > General > Fees
The total fee adjustments on a particular fee.

feeAmountFees > Fees
Fee amount.

balance

Student Information > General > Fees

The amount the student owes if there is no fee maximum.

maxStudentPayment

Student Information > General > Fees

The amount the student owes if there is a fee maximum.
maxHouseholdPaymentCensus > Households > Household Fees
The amount the household owes if there is a fee maximum.
adjustedBalanceDue

Student Information > General > Fees

The net of all debits minus all credits. Using this while using Fee Max will show the correct Fee balance if there were any adjustments made via Fee Maximum.

Fee Summary

Student > Fee > Fee Summary
Screenshot of fee summary
Filter FieldMapping and Definition
personID

Internal database identifier.

calendarID

Internal database identifier.

endYear

Student Information > Fees

The ending year of the calendar; e.g., 2022-2023 end year is 2023.

studentFeeMaxFees > Fee Maximums
The maximum amount of fees a student may pay in a school year.
householdFeeMaxFees > Fee Maximums
The maximum amount of fees a household may pay in a school year.
feeCountStudent Information > General > Fees
The total number of fees assigned to the student in the selected calendar.
totalFeesStudent Information > General > Fees
The total amount assigned that counts toward Fee Maximums in the selected Calendar. 
Fees marked as Exempt or Fee assignments that have been voided are not included in this total.
totalPaidStudent Information > General > Fees
The total amount paid towards fees assigned in the selected calendar. This amount counts toward Student and Household Fee Maximums. Fees marked as Exempt are not included in this total.
totalAdjustmentStudent Information > General > Fees
The total amount of adjustments made.
totalBalanceStudent Information > General > Fees
The total balance due on fees assigned in this calendar.
totalDueAllYearsStudent Information > General > Fees
The combined outstanding amount from all school years and calendars.
totalAdjustedBalanceDueStudent Information > General > Fees
The total outstanding amount, adjusted for fee maximums, that the student needs to pay. Using this while using Fee Max will show the correct Fee balance if there were any adjustments made via Fee Maximum.
totalAdjustedBalanceDueAllYearsStudent Information > General > Fees
The combined outstanding amount from all school years, adjusted for fee maximums. Using this while using Fee Max will show the correct Fee balance if there were any adjustments made via Fee Maximum.
sfmTotalBalanceCampus does not currently support this filter field.


Fee Summary All Years

Student > Fee > Fee Summary All Years

Screenshot of fee summary all years


Students with an enrollment in the selected calendar will be included in this view if they have ever had a fee assigned to them. Students who have never had a fee assigned to them will not be included.

Student Fee Maximums are accounted for in totalAdjustedBalanceDue; household maximums are NOT.

Filter FieldMapping and Definition
personID

Internal database identifier.

feeCountStudent Information > General > Fees
Count of fees from all years and calendars
totalFeesStudent Information > General > Fees
Total amount of fee assignments from all years and calendars.
Fees marked as Exempt or Fee assignments that have been voided are not included in this total.
totalPaidStudent Information > General > Fees
Total amount of fee payments from all years and calendars.
totalAdjustmentStudent Information > General > Fees
Sum of all fee adjustments made to fee assignments.
totalBalanceStudent Information > General > Fees
Total fee assignments minus all payments (totalPaid) and adjustments (totalAdjustment)
totalAdjustedBalanceDueStudent Information > General > Fees
Total due for all years and calendars, based on the student fee max set in each school year. 
This field will include students that have not had fees assessed in the current school year.

Online Payments

Student > Fee > Online Payments

Screenshot of online payments
Filter FieldMapping and Definition
personID

Internal database identifier.

assignmentID

Internal database identifier.

calendarID

Internal database identifier.

fee

Fees > Fees
Fee name.

feeTypeFees > Fees
Category of fee, as set up in System Administration > Custom > Attribute/Dictionary > Fee > Fee Type.
feePaymentAmountThe amount paid toward the fee.
commentsUser-entered comments on the fee payment.
creditCardAuthNumberIf your district uses Campus Payments, this is the last 4 digits of the credit/debit card.
If your district does not use Campus Payments, this is the manually entered Reference Number.
serviceFeeThe amount charged by the district to the cardholder to cover the costs of processing the transaction.
transactionFeeThe amount charged by the payment processor to the district to process the transaction.
paymentTimestampDate/time the transaction occurred.
transactionRefTransaction Reference Number: an internal reference number provided by the payment processor to identify the transaction.
settlementDateThe date the payment vendor received the payment from the customer's bank.
processDateThe date the payment was processed by the payment vendor.
depositDateThe date the payment processor sent the deposit to the district's bank.
paymentMethodRefInternal database reference for the payment method used in the transaction.
returnReasonComments made when an online payment was voided.
returnCodeThis field is not used with fees.
returnDateThe date the online payment was voided.
ccAuthDescThis field is not used with fees.
ccStatusThis field is not used with fees.
accountTypeThis field is not used with fees.
paymentTransactionStateThe current status of the transaction. The list of possible values is found on the Payments Reporter.
paymentSourceWhere the transaction occurred. The list of possible values is found on the Payments Reporter.
payerLastNameLast name of the cardholder, entered when the payment method was added.
payerFirstNameFirst name of the cardholder, entered when the payment method was added.

Fee Payments

Student > Fee > Fee Payments

Screenshot of fee payments
Filter FieldMapping and Definition
PaymentID

Internal database identifier.

PaymentAmountAmount paid toward the assigned fee.
CashStudent Information > General > Fees
Indicates if the payment was made in cash.
CheckNumberStudent Information > General > Fees
Check number recorded on the fee payment.
CreditCardAuthNumberStudent Information > General > Fees or
Campus Parent > My Cart > Card Number
Last 4 digits of the credit/debit card if the payment was made using Campus Payments.
If your district does not use Campus Payments, this is the manually entered Reference Number.
PaymentCommentsStudent Information > General > Fees
Comments entered by the user recording the fee payment.
PaymentDateDate the payment was made.
PaymentTypeIndicates the source of the payment
OFF: Payment made in office (Student Information > General > Fees)
OLP: Payment made using Campus Payments.
FeeCreditAssignmentID

Internal database identifier.

FeeCreditPaymentID

Internal database identifier.

CreditAmountStudent Information > General > Fees
Amount being paid (credited) to the fee assignment.
CalendarID

Internal database identifier.

AssignmentID

Internal database identifier.

PersonID

Internal database identifier.

FeeAssignmentFeeID

Internal database identifier.

AssignedAmountStudent Information > General > Fees
Original amount of the fee assignment
AssignmentCommentsStudent Information > General > Fees
Comments entered when the fee assignment was created.
dueDateStudent Information > General > Fees
Due date entered when the fee assignment was created.
accountNumberFees > Fees
District finance account defined for the fee.
feeIDInternal database identifier.
feeAmountFees > Fees
Fee amount defined in the Fees settings. 
feeDescriptionFees > Fees
Description defined on the fee in Fees settings.
feeNameStudent Information > General > Fees
The fee that was paid.
feeTypeFees > Fees
Category of fee, as set up in System Administration > Custom > Attribute/Dictionary > Fee > Fee Type.
schoolIDInternal database identifier.
schoolNameFees > Fees
School associated with the fee when it was created in Fees Setup.