Skip to main content
Skip table of contents

Search for Students by Fees/Transactions

To search for students based on fee or transaction information use any of the following tables and fields in combination with a valid comparator, such as *<table_name>.<field_name><comparator><value>. Search results vary depending on the expression you enter. 

Note: Fees search codes are designed for searches only. Although they do not work in reports or exports, there is a Fees List Object that you can use to print items such as balances and transactions on an object report. 

Table

Fields

[146]Fee

Fields within this table include:

  • Course_Name
  • Course_Number
  • CreationDate
  • Custom
  • Date
  • DateTime
  • Department_Name
  • Description
  • Fee_Amount
  • Fee_Balance
  • Fee_Category_Name
  • Fee_Paid
  • Fee_Type_ID
  • Fee_Type_Name
  • Group_Transaction_ID
  • ID
  • ModificationDate
  • OriginalFee
  • Priority
  • Pro_Rated
  • SchoolFee_ID
  • SchoolID
  • StudentID
  • System_User_ID
  • TeacherID
  • Time
  • YearID

[147]Transaction

Fields within this table include:

  • Custom
  • Date
  • DateTime
  • Description
  • FeeID
  • Group_Transaction_ID
  • ID
  • NetEffect
  • Payment_Method
  • Payment_Ref_Nbr
  • Receipt_Nbr
  • SchoolID
  • Starting_Balance
  • StudentID
  • System_User_ID
  • TeacherID
  • Time
  • Transaction_Type
  • YearID

[148]Fee_Balance

Fields within this table include:

  • Balance
  • Credit
  • Debit
  • ID
  • SchoolID
  • StudentID
  • TeacherID

Additionally, you can use the following expressions to solicit more complex results:

Expression

Results

*fee.id=noschool

The students who are not related to a school [Fee] record.

*fee.id=nocourse

The students who are not related to a course [Fee] record.

*fee.fee_balance=partial

The students who have at least one fee with a partial balance (partially paid).

*fee_balance.balance=partial

The students who have a partial global balance (partially paid).

*fee_balance.balance=0

The students who have a global balance equal to 0.

Note: The [Fee_balance] record for a student is created when a transaction is created. Some students may not have a [Fee_balance] record because they never had a transaction created. This expression looks for [Fee_balance] records with a zero balance. The students who do not have a [Fee_balance] record will not appear in the results even though their balance is zero.

*fee_balance.balance=null

The students who have no [Fee_balance] record.

Note: This expression complements *fee_balance.balance=0 by returning the students who have no [Fee_balance] record.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.