Students File Specification

Overview

The student profiles file provides student demographic and contact information from the institution's SIS. Meadow uses it to identify students, support communications, and associate students with school year, program, and campus metadata. Each row is one student.

Students are included based on the following selection criteria:

• Any student enrolled in the last 3 years
• Any student with a transaction within the last year
• Any student with an outstanding balance
• Any student assigned to the pre-collections hold code

File Details

Example: 2026-03-19T143022Z_SCH_students.csv

File Layout

• One row per student
• Includes students meeting at least one of the selection criteria above
• Output is based on the result set of the base student selection, with profile attributes appended

Field Definitions

Business Rules

Student Population

• The file includes only students returned by the base student selection logic.
• Each row represents a single distinct student.
• Students do not need to be currently attending if they meet other selection criteria.

Name Logic

• first_name uses the preferred name when available, otherwise the legal first name.
• last_name uses the standard last name from the SIS.

Phone Logic

• primary_phone is sourced from the student's mobile phone, when available.
• additional_phone is sourced from the student's home phone, when available.
• Only phone numbers with a verification status of Valid or Verified are included.
• Private phone numbers are excluded.
• Phone types are hardcoded: Mobile for primary_phone_type and Home for additional_phone_type.

Email Logic

• primary_email is sourced from the configured preferred email type, typically the school email address.
• additional_email is the first active alternate email that does not match the configured primary email type.

Academic and Program Logic

• school_year_name is populated from the student's current class standing.
• college_name is populated from the student's current degree or program.
• campus_name is populated from the student's current campus or location.

Formatting Rules

• Blank legacy fields must be included in the file and left empty.
• Country fields use the ISO 2-letter country code when available.
• currently_attending is Y if active, N if not active or null.
• Phone and email fields may be blank if no eligible value exists.

Sample File

student_id,academic_year,academic_term,academic_session,currently_attending,payment_plan_enabled,first_name,last_name,dob,primary_phone,primary_phone_type,primary_phone_country_id,additional_phone,additional_phone_type,additional_phone_country_code,primary_email,additional_email,enrollment_date,exp_grad_mm,exp_grad_yyy,grad_year,grad_term,grad_session,school_year_name,college_name,campus_name,created_at,modified_at,long_school_student_id,student_codes
10001234,,,,Y,,Katie,Johnson,,5551234567,Mobile,US,5559876543,Home,US,kjohnson@school.edu,katie.johnson@gmail.com,,,,,,,Sophomore,Biology,Main Campus,,,,"BURS,INTL,COLL"
10004567,,,,N,,Marcus,Lee,,5552221111,Mobile,US,,Home,,mlee@school.edu,,,,,,,,Freshman,Computer Science,Online,,,,
10007890,,,,Y,,Ana,Rivera,,,Mobile,,,Home,,arivera@school.edu,ana.rivera@yahoo.com,,,,,,,Senior,Business,North Campus,,,,

Notes

• Include all students meeting the inclusion criteria.
• Do not include duplicate student rows.
• Legacy fields are required for schema consistency across Meadow integrations.
• Some fields may be blank if the institution does not maintain those values in the SIS.