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.

Fee Detail

Student > Fee > Fee Detail

Filter Field	Mapping & Definition
personID	Internal database identifier.
grade	Student Information > General > Enrollments Notes the grade level of the student.
assignmentID	Internal 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.
dateExempted	Student Information > Fees The date on which the student's fee was marked as exempt.
createdDate	Student 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.
variableRate	Student 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.
feeDebit	Student 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.
feeAmount	Fees > 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.
maxHouseholdPayment	Census > 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

Filter Field	Mapping 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.
studentFeeMax	Fees > Fee Maximums The maximum amount of fees a student may pay in a school year.
householdFeeMax	Fees > Fee Maximums The maximum amount of fees a household may pay in a school year.
feeCount	Student Information > General > Fees The total number of fees assigned to the student in the selected calendar.
totalFees	Student 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.
totalPaid	Student 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.
totalAdjustment	Student Information > General > Fees The total amount of adjustments made.
totalBalance	Student Information > General > Fees The total balance due on fees assigned in this calendar.
totalDueAllYears	Student Information > General > Fees The combined outstanding amount from all school years and calendars.
totalAdjustedBalanceDue	Student 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.
totalAdjustedBalanceDueAllYears	Student 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.
sfmTotalBalance	Campus does not currently support this filter field.

Fee Summary All Years

Student > Fee > 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 Field	Mapping and Definition
personID	Internal database identifier.
feeCount	Student Information > General > Fees Count of fees from all years and calendars
totalFees	Student 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.
totalPaid	Student Information > General > Fees Total amount of fee payments from all years and calendars.
totalAdjustment	Student Information > General > Fees Sum of all fee adjustments made to fee assignments.
totalBalance	Student Information > General > Fees Total fee assignments minus all payments (totalPaid) and adjustments (totalAdjustment)
totalAdjustedBalanceDue	Student 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

Filter Field	Mapping and Definition
personID	Internal database identifier.
assignmentID	Internal database identifier.
calendarID	Internal database identifier.
fee	Fees > Fees Fee name.
feeType	Fees > Fees Category of fee, as set up in System Administration > Custom > Attribute/Dictionary > Fee > Fee Type.
feePaymentAmount	The amount paid toward the fee.
comments	User-entered comments on the fee payment.
creditCardAuthNumber	If 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.
serviceFee	The amount charged by the district to the cardholder to cover the costs of processing the transaction.
transactionFee	The amount charged by the payment processor to the district to process the transaction.
paymentTimestamp	Date/time the transaction occurred.
transactionRef	Transaction Reference Number: an internal reference number provided by the payment processor to identify the transaction.
settlementDate	The date the payment vendor received the payment from the customer's bank.
processDate	The date the payment was processed by the payment vendor.
depositDate	The date the payment processor sent the deposit to the district's bank.
paymentMethodRef	Internal database reference for the payment method used in the transaction.
returnReason	Comments made when an online payment was voided.
returnCode	This field is not used with fees.
returnDate	The date the online payment was voided.
ccAuthDesc	This field is not used with fees.
ccStatus	This field is not used with fees.
accountType	This field is not used with fees.
paymentTransactionState	The current status of the transaction. The list of possible values is found on the Payments Reporter.
paymentSource	Where the transaction occurred. The list of possible values is found on the Payments Reporter.
payerLastName	Last name of the cardholder, entered when the payment method was added.
payerFirstName	First name of the cardholder, entered when the payment method was added.

Fee Payments

Student > Fee > Fee Payments

Filter Field	Mapping and Definition
PaymentID	Internal database identifier.
PaymentAmount	Amount paid toward the assigned fee.
Cash	Student Information > General > Fees Indicates if the payment was made in cash.
CheckNumber	Student Information > General > Fees Check number recorded on the fee payment.
CreditCardAuthNumber	Student 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.
PaymentComments	Student Information > General > Fees Comments entered by the user recording the fee payment.
PaymentDate	Date the payment was made.
PaymentType	Indicates 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.
CreditAmount	Student 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.
AssignedAmount	Student Information > General > Fees Original amount of the fee assignment
AssignmentComments	Student Information > General > Fees Comments entered when the fee assignment was created.
dueDate	Student Information > General > Fees Due date entered when the fee assignment was created.
accountNumber	Fees > Fees District finance account defined for the fee.
feeID	Internal database identifier.
feeAmount	Fees > Fees Fee amount defined in the Fees settings.
feeDescription	Fees > Fees Description defined on the fee in Fees settings.
feeName	Student Information > General > Fees The fee that was paid.
feeType	Fees > Fees Category of fee, as set up in System Administration > Custom > Attribute/Dictionary > Fee > Fee Type.
schoolID	Internal database identifier.
schoolName	Fees > Fees School associated with the fee when it was created in Fees Setup.

Fees Filter Fields for Ad hoc Reporting

On This Page

Fee Detail

Fee Summary

Fee Summary All Years

Online Payments

Fee Payments

Fees Filter Fields for Ad hoc Reporting

On This Page

Fee Detail

Fee Summary

Fee Summary All Years

Online Payments

Fee Payments

Related Articles