Fee Assignments¶
File: feeassignment_data.csv · Where: Admin Tasks → End-of-Year Reports → year →
Fee Assignments
A fee assignment is one charge to one student. When you create a "Marching Band Fee" and assign it to 120 students, that's one fee and 120 fee assignments — and this file has the 120 rows.
Use it to answer "who was charged what, and did they pay it" for a closed year.
What's in it¶
| Column | What it holds |
|---|---|
id |
The assignment's own ID. Credits Used points back here with fee_assignment_id |
fee_id |
Which fee was charged |
user_id |
The student who owed it — look this up in Account Data |
invoice_id |
The payment that settled it, if it was paid. Look this up in Invoices |
paid |
1 if paid, 0 if not |
amount |
The student's share when the fee was split. Blank means the student owed the fee's full amount |
date |
The date the fee was assigned to the student. Blank if it was never set — it can be edited from the audit trail |
archive |
1 if the assignment had been archived |
Reading it¶
A blank amount is normal. Most students owe the whole fee, and the amount lives on the fee
itself rather than being repeated on every assignment. A value appears only where the charge was
split — between two households, or into instalments.
Reversed payments leave no trace here. Deleting a payment clears both paid and
invoice_id on the assignment and removes the payment from Invoices — the
export shows the outcome, not the history. The audit trail is
where corrections are visible while the year is still open.
A fee settled entirely by credit shows paid = 1 with no invoice_id. The matching row is
in Credits Used, pointing at this assignment's id.
Fee names aren't in this file
The export records fee_id, not the fee's name — there is no separate fee list among the
end-of-year reports. To put names to the numbers, use the
final account statements, which show each student's fees in full, or
the fees summary spreadsheet, which lists unpaid fees by name.