ParentSquare
This tasks creates up to 7 csv files that will be sent to the vendor via SFTP.
schools.csv
| school_id | |
| school_name | |
| school_zip | |
| principal_first_name | |
| principal_last_name | |
| principal_email | |
| school_address | |
| school_phone | |
| school_city | Version 2 export only |
| school_state | Version 2 export only |
students.csv
| school_id | |
| student_id | |
| first_name | |
| last_name | |
| grade_level | |
| student_email | |
| cellphone | |
| state_student_id | |
| is_504 | |
| is_iep | |
| is_ell | |
| is_reduced_meal | |
| is_free_meal | |
| is_special_education | |
| included columns for selected User Flags | column header set to user flag codes |
| status | Version 2 export only. Is student Active? 1 - Yes. 0 - No. |
staff.csv
| school_id | |
| staff_id | |
| title | |
| first_name | |
| last_name | |
| mobile | |
| login | Version 2 Only |
| secondary_phone | Version 2 Only |
sections.csv
| school_id | |
| staff_id | |
| course_name | |
| term_id | |
| is_primary | |
| period_number | |
| section_number | Version 2 Only |
roster.csv
| school_id | |
| section_id | |
| student_id |
terms.csv
| school_id | |
| term_id | |
| term_name | |
| start_date | |
| end_date | |
| school_year |
parents.csv
| school_id | |
| student_id | |
| first_name | |
| last_name | |
| email2 | |
| mobile | |
| secondary_phone | |
| address | |
| iep | optional setting |
| language | |
| relationship | |
| parent_id | Version 2 Only |
| login | Version 2 Only |
| educational_rights | Version 2 Only (column data blank) |
Groups may contain Bus Routes, Bus Numbers, Clubs and Sports based on configuration settings
groups.csv
| school_id | |
| group_id | |
| group_name | "Bus# ..", "Route .." or Activity Name |
| category | "Bus" or Activity Type Code |
group_members.csv
| school_id | |
| group_id | |
| student_id |
emergency_contacts.csv
| school_id | |
| student_id | |
| contact_id | |
| first_name | |
| last_name | |
| phone |
Only contacts marked Emergency 1 - 4 ill be included in emergency file
attendance.csv
| school_id | |
| student_id | |
| date | today's date |
| period | column produces "all_day" in every row |
| code | A or T |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article