What is the Families With Multiple Students Report (FAM-5)?

IN THIS ARTICLE:
Learn about the Families With Multiple Students Report (FAM-5), its filter options, and how to generate it.

What is the Families With Multiple Students Report?

The Families With Multiple Students Report is a list of families in your database that have more than one student associated with the family account. The list will include both primary and secondary guardians, the primary phone number and a list of all student names associated with the family.

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 Families With Multiple Students Report is available in either HTML, PDF, XLS or CSV format.

General Filters

  • ADVANCED ACTIVE/INACTIVE SEARCH or AS OF DATE: If this option is left disabled, the system will use the “As Of Date” specified below to look at families 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 families/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 families/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 families/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 families/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).

  • ENROLLMENT TYPE
    • Include Class Enrollments – Only includes families with "ACTIVE" type Class enrollments during the specified date range/on the specified “As of Date.”
    • Include Camp Enrollments – Only includes families with "ACTIVE" type Camp enrollments during the specified date range/on the specified “As of Date.” 
  • LOCATIONS: the system will only include families with enrollments associated with the selected Location(s) in the results.
  • CHOOSE PROGRAM: selecting one or more specific programs will limit the results only to families with active enrollments in classes/camps assigned to the selected program(s) within the parameters defined within the status filters. (Leaving this filter blank will include all programs.)
  • CHOOSE FAMILY KEYWORDS: selecting one or more specific keywords will limit the results only to families associated with the selected family keyword(s), and who meet the parameters defined within the status filters. (Leaving this filter blank will include all families. Selecting multiple family keywords will only include families associated with ALL of the selected keywords.)
  • CHOOSE STUDENT KEYWORDS: selecting one or more specific keywords will limit the results only to families associated with the selected student keyword(s), and who meet the parameters defined within the status filters. (Leaving this filter blank will include all families. Selecting multiple student keywords will only include families associated with ALL of the selected keywords.)
  • CHOOSE PROGRAM KEYWORDS: selecting one or more specific keywords will limit the results only to families with enrollments in classes/camps associated with the selected program keyword(s), and who meet the parameters defined within the status filters. (Leaving this filter blank will include all families. Selecting multiple program keywords will only include families associated with ALL of the selected keywords.)
  • CHOOSE CLASS KEYWORDS: selecting one or more specific keywords will limit the results only to families with enrollments in classes associated with the selected class keyword(s), and who meet the parameters defined within the status filters. (Leaving this filter blank will include all families. Selecting multiple class keywords will only include families associated with ALL of the selected keywords.)
  • CHOOSE CAMP KEYWORDS: selecting one or more specific keywords will limit the results only to families with enrollments in camps associated with the selected camp keyword(s), and who meet the parameters defined within the status filters. (Leaving this filter blank will include all families. Selecting multiple camp keywords will only include families associated with ALL of the selected keywords.)
  • CHOOSE A REFERRAL SOURCE: the family must have the selected “Referral Source” associated with their account. 

Class/Camp Filters

  • PRE-FILTER – the “Pre-filter” limits the results of the Class/Camp filter and only affects the options shown there. It does not affect any actual report results.
    • Choose Instructor – limits the Class/Camp filter results to only show classes/camps with the selected Instructor(s) assigned.
    • Status
      • Active – will display only classes/camps that are marked “Active”
      • Inactive – will display only classes/camps that are marked “Inactive”
    • CHOOSE CLASS: select a Class to limit the report to only families with an active enrollment in the class, as determined by the ADVANCED ACTIVE/INACTIVE SEARCH or AS OF DATE.
    • CHOOSE CAMP: select a Class to limit the report to only families with an active enrollment in the camp, as determined by the ADVANCED ACTIVE/INACTIVE SEARCH or AS OF DATE. 

Display Options

  • PRINT GUARDIAN NAME AS ‘LAST NAME, FIRST NAME’: by default, the report shows the Guardian name in FIRSTNAME LASTNAME format. By enabling this option, you can reverse this to LASTNAME, FIRSTNAME, making it easier to sort in Excel or another spreadsheet program.

Need more assistance?

Call us at 877-554-6776. Our business hours are Mon–Sat, 9am–9pm (CT).