To create an arrivals list that has transfer details and accommodation requirements, you would need to create a Transfer quick report.

Adding in the transfer criteria, and also adding “Accommodation Finance Status Name” and setting the criteria to “Active” along with the fields for “Booking Accommodation Forename” and “Booking Accommodation Surname”.

This will produce a report on students who require transfer and have an accommodation booked.

There is a helpsheet (no. SQL138) which covers this.  Please click on the following link to view or …

To create an arrivals list that has transfer details but no accommodation requirements, you would need to create a Transfer quick report.

Adding in the transfer criteria, and also adding “Accommodation Finance Status Name” and setting the criteria to “Not Equal To” “Active” or “Is NULL”.

This will produce a report on students who have not booked accommodation or has cancelled accommodation, within the date selected.

There is a helpsheet (no. SQL137) which covers this.  Please click on the following link to view …

There are two options you have a report already created in Class which you may wish to try first this is the “Visa/Passport & UK Sponsorship”.

Otherwise you could create your own report within an Enrolment General Quick Report.

There is a helpsheet (no.SQL204 or SQL176) which covers this.  Please click on the following links to view or download helpsheet – HS204 Reporting – Student Visas Passports & UK Sponsorship Report.doc  or SQL176.net Visa Expiry Report.doc

Within Class you would need to create an ‘Agent’ type document, inserting all text and required merged fields that you wish to include on the mailshot.

Then within an ‘Agent’ type quick report, add the fields and criteria to the report including the agent email address a (so that you can see agents that you might not have email address for).

Then select on ‘Search’ to display all the Agents that match the selected criteria.

You will then have the option to select ‘Send Document’, search …

To find the average age of students you would need to create an Enrolment General quick report.

Then when merging it to an Excel spreadsheet you then have the facility within the AutoSum to select the ‘Average’, this will then calculate the average age.

There is a helpsheet (no.SQL179) which covers this.  Please click on the following link to view or download helpsheet – SQL179.net Student Average Age Report.doc

This type of report can be created using an “Enrolment Course Booking” quick report.

Date Filter could be “Starting” if you require a list of all starters or “Present”  if you want to see all students currently on a course or “Finishing” if you want to see all students finishing a course.

There is a helpsheet (no.SQL069) which covers this.  Please click on the following link to view or download helpsheet – SQL069.net Students starting course List.doc

To produce a list of Accommodation Bookings to send to host families, you would need to create an Accommodation Booking quick report.

There is a helpsheet (no.SQL147) which covers this.. Please click on the following link to view or download helpsheet – SQL089.net Available Beds Report.doc

Firstly you must of created your master document with the details that you are wanting to email the host families with.

Then within quick reports select the “Report Type” “Accommodation” and add the relevant fields, then once you have run the report you then have the facility to send the document from the report and this will then immediately up date the host families profile with this document.

There is a helpsheet (no.SQL042) which covers this.  Please click on the following link …

This can be achieved within an “Enrolment General” quick report.

There is a helpsheet (no.HS066) which covers this.  Please click on the following link to view or download helpsheet – HS066 Quick Reports – Birthday List.docx or please watch the video below demonstrating this process.

is can be achieved by creating an “Accommodation Booking” quick report.

There is a helpsheet (no.SQL036) which covers this.  Please click on the following link to view or download helpsheet – SQL036.net List of Students with current HF.doc