Skip to content

Aged Debtors Report Data Columns

The table below shows the columns and their explanations that will get printed in the generated report.

ColumnsExplanations
Student NoStudent Number generated by TEAMS.
Enrolment NoEnrolment Number generated by TEAMS.
Student NameIt indicates the Student (First name) (Middle name) (Last name).
Invoice Creation DateThe invoice creation field will display the date when the invoice is created.
TimetableIt Displays the student’s allocated class schedule for their course
Start DateStart date of the enrolment.
Agent NameThis field show the Agent Name linked with the enrolment.
Campus NameThe system will show you the campus linked to the enrolment.
ProgramThe Program field shows the program Name under which the student is enrolled.
Invoice DateThe invoice date will be printed under this column.
Enrolment StatusThe Enrolment status field displays the current status of the student’s enrolment (e.g. Active, Completed, and not yet started).
End DateThe type of enrolment will be printed under this column.
Study WeeksIt indicates the total number of weeks the student is scheduled to study as part of their enrolment.
Academic Holiday WeeksIt represents the number of weeks allocated for academic breaks, such as term or semester holidays set by the institution.
Student Holiday WeeksThe number of holiday weeks approved specifically for the student, separate from academic holidays.
Total DurationThe Total Duration is automatically calculated as the sum of the Study Weeks, Academic Holidays, and Student Holidays.
NationalityIt indicates the student’s country of citizenship, typically based on their passport.
Enrolment TypeThe Enrolment type field displays the type of enrolment, such as full-time, part-time, or short course.
Payment PlanThe system will print yes or no if there is any payment plan linked with this enrolment.
Invoice NoThe invoice number will be printed under this column.
Invoice Due DateThe date by which the invoice must be paid to avoid late fees or penalties.
Total Due DateThe total amount due will be printed under this column.
Total DueThe total amount due will be printed under this column.
0-30This column will display the amount of aged debtors overdue within 0-30 days.
31-60This column will display the amount of aged debtors overdue within 31 to 60 days.
61-90This column will display the amount of aged debtors overdue within 61 to 90 days.
90+This column will display the amount of aged debtors overdue for more than 90 days.
Over Paid AmountIt displays any additional payment made by the student that exceeds the total amount due.
level of StudentIndicates the academic or course level the student is enrolled in (e.g. Beginner, Intermediate, Advanced).
Visa TypeThis displays the type of visa the student holds (e.g. Student Visa, Tourist Visa).
Local AddressThis field shows the residential address of the student.
Mobile NoThis will display the Mobile number of the student.
Email AddressIt represents the primary email address of the student.
Secondary Email AddressIt displays the alternative email address provided by the student.
Phone NoIt will display the student’s phone number.
DOBThis field represents the student’s date of birth.
Payment TypeIt represents to the payment method used by the student (e.g. Bank Transfer, Credit Card).
Student Period Start DateThe start date of the current or relevant study period.
Student Period End DateThe end date of the current or relevant study period.
Previous ProgramsThe Previous Programs field will show details for students with prior enrolments. For current students without a previous program or course, this column will remain blank.