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:
|
[147]Transaction | Fields within this table include:
|
[148]Fee_Balance | Fields within this table include:
|
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. |