Data Integration for Pathways
- Former user (Deleted)
- Laura Allen
- Alan Degener
Welcome to Pathways Data Integration!
Follow this guide to send your SIS data to Pathways
Table of Contents:
Introduction
Pathways is a premier school administration software for managing the graduation requirements, grades, and statuses for your high school students.
Data Sets
Each Student Information System (SIS) provides unique data sets for Pathways. Generally speaking, Pathways will collect the following student data:
Students - Contains general student information including: names, ids, etc.
Grades - historical and current-semester grades for your students. Some SISs will send data in two files.
GPA - the weighted and/or unweighted grade point averages for your students. Some SISs include this data within the students file.
IBC (TX Only) - additional details on student graduation paths and programs for Texas districts.
Course Crosswalk - an additional data set, required by some SISs, to align local course codes with sate-assigned course codes.
Method
Data exported from most SISs will be sent to Pathways via SFTP. If your district uses Aeries SIS, data will be transferred using API.
Data Send Schedules
All data sets should be sent nightly (including weekends) before 1am CST.
Data Transfer & Responsibilities
Pathways views your SIS as the Single Source of Truth for all data. Please review the steps below for how data is sent from your SIS to Pathways.
1 - Manage Data in SIS – Sending data to Pathways begins with adding, updating, and maintaining the accuracy of course request, student, and teacher data within your SIS.
2 - Export Data from SIS – Your district IT, with help from your Pathways Data Integrations Engineer, will configure SIS data exports that create the Pathways data files.
3 - Send Files to EAI – Your SIS/District IT will send data files to Pathways on a regular basis (via SFTP or API, depending on your SIS).
4 - Maintain Servers – Pathways will create and maintain servers for the purpose of securely retrieving data from your SIS.
5 - ETL & Data Security – EAI will retrieve the data files from SFTP, encrypt, and store data using AWS. See EAI’s Data Privacy page for more information on how EAI secures your data.
6 - EAI Product - EAI will display your district data in Pathways.
Timeline & Checklist
A meeting with your Pathways DI Engineer to review the data requirements and/or configure exports in your SIS. This meeting can be up to 45 minutes.
Weeks 1: Send First Files:
By the end of the first week, SFTP will be configured and the first files (data sets) sent to Pathways.
Please configure all files to be sent nightly (including weekends) before 1am CST.
Week 2: Data Validation:
Your Pathways DI Engineer will review and validate the sent data, then follow up with you for any needed adjustments to the exports.
After: Data Management:
Once the data in Pathways is validated, you will continue to maintain data within your SIS you may be contacted by your staff if data abnormalities are discovered in Pathways.
Please reach out to your DI Engineer if you need assistance troubleshooting any of these data abnormalities.
Instructions for Exporting SIS Data:
Locate the templates and instructions for your SIS below.
Ascender SIS
Contact your Education Regional Center (ERC) support team to submit a request to send data to Pathways. Please include the information below and cc your DI Engineer as part of this request.
Data Requirements:
Instructions:
eSchoolPLUS
Download the Cognos templates (below) and configure them using the instructions below. Please note, these templates may need to be modified to account for district-specific data.
Cognos Report Templates:
Instructions:
For eSchool districts who do not use Cognos, the following are the file specifications to assist in creating SQL statements or using other reporting tools:
Student Data
eSchool Student Roster Data Specifications
File Name: students.csv
File Format: .csv
Delimiter: Comma ","
Row 1 Headers: Listed below. Spelling is STRICTLY enforced. Capitalization, spaces, and special characters are not enforced. For example, "Student ID", "student_id", and "StudentId" are all acceptable forms for the "Student Id" field.
Column Order: Order of columns is not enforced
Campus ID, State Student ID, Student Id, First Name, Middle Name, Last Name, Student Grade, Student Gender, DOB, Email, Federal Race Code, Federal Race Name, Meal Status Code, Grad Year, Graduation type code, Diploma Type Name, Grad Requirement Group, Grad Requirement Group Name, Endorsement Type, Endorsement Name
Course Cross Walk
eSchool Course Crosswalk Data Specifications
File Name: students.csv
File Format: .csv
Delimiter: Comma ","
Row 1 Headers: Listed below. Spelling is STRICTLY enforced. Capitalization, spaces, and special characters are not enforced. For example, "Student ID", "student_id", and "StudentId" are all acceptable forms for the "Student Id" field.
Column Order: Order of columns is not enforced
Building - Course, Active Status - Course, Receive Mark, Course Code - Course, Course Name - Course, Department - Course, Department Name - Course, Credit - Course, State Course School Year - Course, State Course Code - Course, Dual Credit Indicator - PEIMS CourseCat, Course Level - Course, Course Level Name - Course, Course Type - PEIMS CourseCat, Course Type Desc - PEIMS CourseCat, Non Campus Based Instruction Code - PEIMS CourseCat, Non Campus Based Instruction Desc - PEIMS CourseCat, ACT Indicator - PEIMS CourseCat, College Credit Hours - PEIMS CourseCat, Population Served - PEIMS CourseCat, Population Served Desc - PEIMS CourseCat, Sequence - PEIMS CourseCat, Sequence Desc - PEIMS CourseCat
Grades
This set of specifications is the same for both current_grades and historical_grades files. You will be sending two files.
The current grades file (current_grades.csv) will include data for only the current school year.
Historical grades file (historical_grades.csv) needs to include all data for previous school years in which students took courses that earn high school credit. (Remember to exclude the current school year.)
eSchool Grade Data Specifications
File Name: current_grades.csv or historical_grades.csv
File Format: .csv
Delimiter: Comma ","
Row 1 Headers: Listed below. Spelling is STRICTLY enforced. Capitalization, spaces, and special characters are not enforced. For example, "Student ID", "student_id", and "StudentId" are all acceptable forms for the "Student Id" field.
Column Order: Order of columns is not enforced
State Student ID, Student Id, Student Grade, School Year, Building - Schedules, Course Code, Course Name - Schedules, Credit Attempted - RC, Earned Credit, RC Status - RC, Receive Mark - MS-RC, Student Course Marking Period - RC, Student Course Mark Type - RC, Grade Value
GPA
eSchool GPA Data Specifications
File Name: gpa.csv
File Format: .csv
Delimiter: Comma ","
Row 1 Headers: Listed below. Spelling is STRICTLY enforced. Capitalization, spaces, and special characters are not enforced. For example, "Student ID", "student_id", and "StudentId" are all acceptable forms for the "Student Id" field.
Column Order: Order of columns is not enforced
Student Id, Student Name Last-First-Middle, Cum Gpa, School Year, Grade, Gpa Type, Description
Harmony
Follow the instructions below to manually update data from Harmony SIS to Pathways. We recommend completing this update at the end of each grading period (quarter, semester, trimester, etc.).
Instructions:
PowerSchool
Download the PowerSchool API directly within Pathways and configure it by following the instructions below.
Instructions:
Skyward Q
Download the Import files for your state (below) and then load/configure them in Skyward Q using the instructions below.
Indiana Import Files:
Texas Import Files:
Instructions:
Skyward SMS
Download the Import files for your state (below) and then load/configure them in Skyward SMS using the instructions below.
Indiana Import Files:
Texas Import Files:
Instructions: