What is the Custom Student List?

IN THIS ARTICLE:

Learn about the Custom Student List, its filter options, and how to generate it.

What is the Custom Student List?

The Custom Student List allows you to generate a customized student report based on selected filters and columns to be included. The report allows you to choose from a number of student details and include that information in the final report.

The Custom Student list can be generated from REPORTS>STUDENTS, or directly from the QuickTools "Reports" menu on the STUDENTS page after selecting one or more students.

If you commonly use the same filters when running this report, you can now save them as Presets! Simply load a Preset Filter whenever you open the report page, set your date range and click to generate the report in your preferred format. See our “Preset Filters for Reports” document for more information.

NOTE: Chosen filters that relate to enrollments will produce results that are true as of the day you generate the report.

Available Formats

The Custom Student List is available in either HTML, XLS or CSV format. (Due to the number of possible options available to be included, a PDF option will not available directly. However, if a PDF version is required and the data would allow it, the report can be generated as HTML and a PDF can then be created using your browser's "Save as PDF"/"Save to PDF" option.)

Active Filters

Dates

  • AS OF DATE or ADVANCED ACTIVE/INACTIVE SEARCH: If this option is left disabled, the system will use the “As Of Date” specified below to look at students active as of that date. (The “As Of Date” defaults to the current date.)
  • When searching by an “As Of Date”, you can specify an enrollment status:
    • Currently Enrolled (Active) – Choose this option to include students that have an "ACTIVE" type enrollment in classes/camps on the “As of Date” (regardless of past or future enrollment status)
    • Enrolled in the Future (Only) – Choose this option to include students that do not have a current "ACTIVE" type enrollment in classes/camps on the “As of Date” but do have an "ACTIVE" type enrollment after that date.
    • Previously Enrolled (Only) – Choose this option to include students that do not have a current "ACTIVE" type enrollment in classes/camps on the “As of Date” but did have an "ACTIVE" type enrollment prior to that date.
    • Never Enrolled – Choose this option to include students which have no recorded "ACTIVE" type enrollments in classes/camps.

If the “Advanced Active/Inactive Search” option is enabled, you are presented with the option to enter date ranges:

  • Active Date Search – students must have had an active enrollment within the specified date range.
  • Inactive Date Search – students must have been inactive within the specified date range.

Leaving BOTH options enabled will assume that both statements must be true (i.e., the student must have been active within the specified active date range AND inactive within the specified inactive date range).

Enrollments

  • ENROLLMENT TYPE
    • Include Class Enrollments – Only includes students with "ACTIVE" type Class enrollments during the specified date range/on the specified “As of Date.”
    • Include Camp Enrollments – Only includes students with "ACTIVE" type Camp enrollments during the specified date range/on the specified “As of Date.”
      • NOTE: Camp enrollments are considered ACTIVE in a camp for a period of time starting with the first block they have selected and ending with the last block. Therefore, if a student is enrolled only on May 5th and May 8th, their enrollment will be considered active from May 5th-May 8th (also encompassing May 6th and 7th).
    • Include Appointment Bookings – Only includes students with a booking in an appointment that is scheduled to meet during the specified date range/on the specified “As of Date.”
    • Any/All - if one or more enrollment types are selected (classes/camps/appointments) allows you to choose whether to results should be based on whether students meet ANY selected criteria or ALL of the selected criteria.
      • Any - only includes students with enrollments/bookings in either of the selected enrollment types.
      • All - only includes students with enrollments/bookings in ALL of the selected enrollment types.
  • ENROLLMENT TYPE STATUS - only appears if either "Include Class Enrollments" or "Include Camp Enrollments" is enabled.
    • Active
    • Single Day
    • Make Up
    • Trial
    • Wait List

General

  • LOCATIONS: the system will only include students with enrollments associated with the selected Location(s) in the results.
  • CLASS/CAMP STATUS
    • Active – will limit the report to only students with enrollments in classes/camps that are currently marked “Active.”
    • Inactive – will limit the report to only students with enrollments in classes/camps that are currently marked “Inactive.”
  • INSTRUCTORS - select one or more Instructor(s) to limit the report to only students with enrollments in a class associated with the specified Instructor(s).
    • NOTE: This option references permanently assigned instructors only.
  • PROGRAM: selecting one or more specific Program(s) will limit the results to only students with an active enrollment in a class/camp/appointment associated with that Program. (This filter will not have any effect on the results if the CLASS/CAMP STATUS filter is set to “Inactive”.)
  • LEVEL: selecting one or more specific Class Level(s) will limit the results to only students with an active enrollment in a class associated with that Level.  (This filter will not have any effect on the results if the CLASS/CAMP STATUS filter is set to “Inactive”.)
  • SESSIONS: select one or more specific Session(s) will limit the results to only students with an active enrollment associated with that Session.  (This filter will not have any effect on the results if the CLASS/CAMP STATUS filter is set to “Inactive”.)
  • ROLLING SESSIONS: select one or more specific Rolling Session(s) will limit the results to only students with an active enrollment in a class associated with that Rolling Session whose enrollments occurred within the dates of at least one of the selected Rolling Sessions. (This filter will not have any effect on the results if the CLASS/CAMP STATUS filter is set to “Inactive”.)
  • START TIME: selecting one or more specific Start Time(s) will limit the results to only students with an active enrollment in a class/camp/appointment scheduled to start at the selected time.
  • PROGRAM KEYWORDS: selecting one or more specific Program Keyword(s) will limit the results to only students with an active enrollment in a class/camp/appointment associated with a Program to which that Keyword has been assigned. (This filter will not have any effect on the results if the CLASS/CAMP STATUS filter is set to “Inactive”.)
  • DAY OF THE WEEK: selecting one or more specific Day(s) of the Week will limit the results to only students with an active enrollment in a class/camp/appointment scheduled to meet on the selected day.
  • CLASS KEYWORDS: selecting one or more specific Class Keyword(s) will limit the results to only students with an active enrollment in a class to which that Keyword has been assigned. (This filter will not have any effect on the results if the CLASS/CAMP STATUS filter is set to “Inactive”.)
  • CAMP KEYWORDS: selecting one or more specific Camp Keyword(s) will limit the results to only students with an active enrollment in a camp to which that Keyword has been assigned. (This filter will not have any effect on the results if the CLASS/CAMP STATUS filter is set to “Inactive”.)

Pre-Filters

  • INSTRUCTORS: select one or more Instructor(s) to limit the “Choose Class/Camp/Appointment” filter(s) to only show classes/camps/appointments associated with the specified Instructor(s).
    • NOTE: This option references permanently assigned instructors only.

Class/Camp

  • CHOOSE CLASS: selecting one or more Class(es) will limit the results to only students with an active enrollment in the selected Class(es), as determined by the ADVANCED ACTIVE/INACTIVE SEARCH or AS OF DATE.
  • CHOOSE CAMP: selecting one or more Camp(s) will limit the results to only students with an active enrollment in the selected Camp(s), as determined by the ADVANCED ACTIVE/INACTIVE SEARCH or AS OF DATE.
  • CHOOSE APPOINTMENT: selecting one or more appointment(s) will limit the results to only students with an active booking in the selected appointment(s), as determined by the ADVANCED ACTIVE/INACTIVE SEARCH or AS OF DATE.

Family Filters

General

  • ATTENDANCE DATE: limits results to only students who were marked PRESENT for attendance on the specified date. (If left blank, the system will look at any students meeting other specified criteria.)
  • STUDENT KEYWORDS: selecting one or more specific Student Keywords will limit the results only to students associated with the selected Keyword(s), and who meet the parameters defined within other selected filters. (Leaving this filter blank will include all students. Selecting multiple student keywords will only include students associated with ALL of the selected keywords.)
  • ATTENDANCE: limits results to only students matching the selected Attendance Status(es) on the specified date. (If left blank, the system will look at any students meeting other specified criteria.) Options are:
    • Present
    • Absent
    • Tardy
    • Left Early
    • Excused
    • Unexcused
  • STUDENT POLICIES: used in conjunction with the "Student Policy Status" filter below, this allows you to limit the results based on the acceptance status of the student policies selected here. (If one or more policies are selected, the family's acceptance status must match at least one of the Policy Statuses selected.)
  • STUDENT POLICY STATUS: used in conjunction with the "Student Policies" filter above, this allows you to limit the results based on the acceptance status of the selected student policies. (If one or more Policy Statuses are selected, the family must match at least one of the statuses for the Student Policy/Policies selected above). Options are:
    • Accepted Current
    • Accepted Past
    • Rejected Current
    • Rejected Past
    • Not Accepted Current
    • No Activity

Options

  • Exclude Students With Phone Numbers
  • Exclude Students Without Phone Numbers
  • Exclude Students With E-mails
  • Exclude Students Without E-mails
  • Use Active Filters on Event Column
    • NOTE: enabling/disabling this option will affect the results of selected columns below.

Columns/Order

Allows you to select which columns of data will be included in the final report results. Clicking the up/down arrows to the right of the column name will change its location in the report. (Results will be shown left to right going down the list.)

Any items that are NOT selected will not be included in the final report.

  • Student Name
  • Primary Guardian Name
  • Primary Email
  • Primary Phone Number
  • Secondary Guardian Names (Single Column) - Secondary guardian names will be concatenated into one column.
  • Secondary Guardian Names (Multiple Columns) - Secondary guardian names will be displayed in separate columns.
  • Secondary Phone Numbers (Single Column) - Secondary guardian phone numbers will be concatenated into one column.
  • Secondary Phone Numbers (Multiple Columns) - Secondary guardian phone numbers will be displayed in separate columns.
  • Secondary Email (Single Column) - Secondary guardian email addresses will be concatenated into one column.
  • Secondary Email (Multiple Columns) - Secondary guardian email addresses will be displayed in separate columns.
  • Balance Due
  • Last Payment Date
  • Last Payment Amount
  • Primary Address (Single Column) - Street, city, state, and zip of primary addresses will be concatenated into one column.
  • Primary Address (Multiple Columns) - Street, city, state, and zip of primary addresses will be displayed in separate columns.
  • Association ID
  • Gender
  • Birthday
  • Age
  • Student Keyword List - displays a concatenated list of all student keywords associated with the student.
  • Anniversary Charge Eligibility Date
  • Anniversary Charge Eligibility Month
  • Roll Sheet Comment
  • Allergies/Special Health Concerns
  • Hospital Clinic Preference
  • Insurance Carrier/Company
  • Policy Number
  • Physician Name
  • Physician Phone
  • Created Date
  • Active Class/Camp/Appointment Count - displays the total number of unique active class/camp enrollments and/or appointment bookings that are linked to the student.
    • NOTE: If the "Use Active Filters on Event Column" option is enabled in the "Student Filters" section, the system will use the "Active Date" filters to calculate these totals.  If it is disabled, these totals will be calculated as of the date the report is generated.
  • Active Class Enrollment Count - displays the total number of unique active class enrollments that are linked to the student.
    • NOTE: If the "Use Active Filters on Event Column" option is enabled in the "Student Filters" section, the system will use the "Active Date" filters to calculate these totals.  If it is disabled, these totals will be calculated as of the date the report is generated.
  • Active Camp Enrollment Count - displays the total number of unique active camp enrollments that are linked to the student.
    • NOTE: If the "Use Active Filters on Event Column" option is enabled in the "Student Filters" section, the system will use the "Active Date" filters to calculate these totals.  If it is disabled, these totals will be calculated as of the date the report is generated.
  • Active Appointment Enrollment Count - displays the total number of unique appointment bookings that are linked to the student.
    • NOTE: If the "Use Active Filters on Event Column" option is enabled in the "Student Filters" section, the system will use the "Active Date" filters to calculate these totals.  If it is disabled, these totals will be calculated as of the date the report is generated.
  • Class/Camp/Appointment Name - the names of any matching class/camp enrollments and/or appointment bookings will be concatenated into one column.
    • NOTE: If the "Use Active Filters on Event Column" option is enabled in the "Student Filters" section, the system will use the "Active Date" filters to compile this list.  If it is disabled, the list will be based on enrollments/bookings as of the date the report is generated.
  • Instructor Name - the names of any instructors associated with class/camp enrollments and/or appointment bookings will be concatenated into one column.
    • NOTE: If the "Use Active Filters on Event Column" option is enabled in the "Student Filters" section, the system will use the "Active Date" filters to compile this list.  If it is disabled, the list will be based on enrollments/bookings as of the date the report is generated.
  • Student Custom Field - displays the name/contents of any Student Custom Field(s) that contain data. (Note: if multiple custom fields exist, a column will be displayed for each.)

Sorting

Allows you to define which data will be used to sort the final report results. Results can be sorted in "Ascending" order (from lowest to highest or alphabetically, depending on the data type), or "Descending" order (from highest to lowest or reversed alphabetically, depending on the data type).

Adding additional sort criteria will further sort the data after it has been sorted according to the previous sorting method. For example, choosing to sort by "Created Date" (Descending) and then by "Student Name" (Ascending) would sort the results by the newest student record. If multiple records have the same "Created Date", the system would then sort those records alphabetically by the "Student Name."

Display Options

  • Display Names as 'Last Name, First Name' (enabled by default) - if disabled, Student and Guardian names will be displayed in ‘First Name/Last Name’ format.
    • NOTE: Changing the way names are displayed will affect how the final report is sorted if you choose to sort results based on "Student Name", as this will place the first name in the primary (sortable) position.

Need more assistance?

Customer support is available at 1-877-554-6776 Mon - Fri, 9 am to 9 pm (CT) and Sat, 9 am to 6 pm (CT).