Students File Specification

SIS Generic PeopleSoft

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

Field	Value
File format	CSV (comma-separated), zipped before upload
File name format	`YYYY-MM-DDTHHMMSSZ_[school abbreviation]_students.csv`
Header row	Required
Encoding	UTF-8

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

#	Column name	Required	Description	PeopleSoft Suggested Location
1	`student_id`	Required	Unique school-assigned identifier for the student	`PS_ACCOUNT_SF.EMPLID`
2	`academic_year`		Unused
3	`academic_term`		Unused
4	`academic_session`		Unused
5	`currently_attending`		`Y`/`N` student currently attending
6	`payment_plan_enabled`		Unused
7	`first_name`	Required	Student's first name	`PS_SCC_NAMES_QVW.FIRST_NAME (preferred name PRF, falling back to primary name PRI)`
8	`last_name`	Required	Student's last name	`PS_SCC_NAMES_QVW.LAST_NAME (preferred name PRF, falling back to primary name PRI)`
9	`dob`		Unused
10	`primary_phone`	Required if exists	Preferred contact number	`PS_SCC_PERDATA_QVW.PHONE`
11	`primary_phone_type`		Phone type (e.g., `MOBILE`, `HOME`)
12	`primary_phone_country_id`		Used for number formatting (e.g., "US", "FR")
13	`additional_phone`		Secondary phone number
14	`additional_phone_type`		Phone type (e.g., `MOBILE`, `HOME`)
15	`additional_phone_country_code`		Used for number formatting (e.g., "US", "FR")
16	`primary_email`	Required if exists	Preferred email, typically .edu	`PS_SCC_EMAIL_QVW.EMAIL_ADDR where PREF_EMAIL_FLAG = 'Y'`
17	`additional_email`		Secondary email address, typically personal. There's no functional difference between primary and additional.	`PS_SCC_EMAIL_QVW.EMAIL_ADDR where E_ADDR_TYPE = 'CAMP'`
18	`enrollment_date`		Unused
19	`exp_grad_mm`		Unused
20	`exp_grad_yyy`		Unused
21	`grad_year`		Unused
22	`grad_term`		Unused
23	`grad_session`		Unused
24	`school_year_name`		Label for the student's current standing (e.g., "Sophomore", "Graduate Year 1")
25	`college_name`		Student's college. Can also be degree or program.
26	`campus_name`		Student's campus; useful for segmenting populations
27	`created_at`		Creation timestamp
28	`modified_at`		Modification timestamp
29	`long_school_student_id`		Unique GUID identifier for the student
30	`student_codes`	Required if exists	A comma-separated list of population identifiers (hold codes, programs, etc.). Used for comms targeting and population segmentation. Example BURS,INTL,COLL.	`PS_SRVC_IND_SEL_VW.SRVC_IND_REASON for precollections service indicator.`

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.