Pathways Data Requirements & Sources
- James Beltran
SIS | Roster | Grades | GPA | Courses | Crosswalk and/or Service IDs | Diploma | Endorsement | Programs of Study | Other Grad Req. (CPR, PO, Speech, FAFSA) | IBCs | Exams | DC Status | Notes |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Ascender | Automated | Automated | Automated | Automated | Not Required | Default: FHSP-E | Manual file upload | Manual file upload | Automated | Automated | Manual file upload | Automated | Should create local dual credit crosswalks if not sent in file |
eSchool | Automated | Automated | Automated | Automated | Crosswalk only | Default: FHSP-E | Manual file upload | Manual file upload | Automated | Automated | Manual file upload | Automated | Â |
Frontline TEAMS | Automated | Automated | Automated | Automated | Crosswalk only | Default: FHSP-E | Manual file upload | Manual file upload | Automated | Automated | Manual file upload | Automated | Â |
Skyward | Automated | Automated | Automated | Automated | Crosswalk only | Default: FHSP-E | Manual file upload | Manual file upload | Manual file upload | Can be setup thru SIS | Manual file upload | Manual file upload | Â |
Skyward Q | Automated | Automated | Automated | Automated | Both | Default: FHSP-E | Manual file upload | Manual file upload | Manual file upload | Manual file upload | Manual file upload | Manual file upload | Â |
SIS Ingested Data Files Details
SIS | File Name | Ingested Data |
|---|---|---|
Ascender | current_grades.txt | Basic student demographic data, including information regarding courses they are taking in the current academic year (fall & spring), if the course is an AP, DC, or OnRamps course, current grades, potential credits, and State Service ID Codes. |
 | historical_grades.txt | Basic student demographic data, including information regarding courses they have already completed in previous academic years, if the course is an AP, DC, or OnRamps course, final grades, awarded credits, and State Service ID Codes. |
 | students.txt | All student demographic data, including GPAs, Endorsements, IBCs, dual credit status, and other graduation requirements (CPR, FAFSA, etc.). |
eSchool | courses.csv | Includes all course-related information, including course departments, course codes, course names, year the course was offered, if it was a dual credit course, course level (if weighted), and the State Service ID Codes. |
 | current_grades.csv | Basic student demographic data, including information regarding courses they are taking in the current academic year (fall & spring) along with the associated current grades and potential credits. |
 | gpa.csv | Includes basic student demographic information along with their current GPA. |
 | historical_grades.csv | Basic student demographic data, including information regarding courses they have already completed in previous academic years along with the associated final grades, and awarded credits. |
 | students.csv | All student demographic data, including diploma types and Endorsements. |
Frontline TEAMS | courses.csv | Includes all course-related information, including course departments, course codes, course names, if it was a dual credit or OnRamps course, if the course counts towards a student’s GPA, and the State Service ID Codes. |
 | current_grades.csv | Basic student demographic data, including information regarding courses they are taking in the current academic year (fall & spring) along with the associated current grades and potential credits. |
 | historical_grades.csv | Basic student demographic data, including information regarding courses they have already completed in previous academic years along with the associated final grades, and awarded credits. |
 | students.csv | All student demographic data, including diploma types, GPA, Endorsements, IBCs, and other graduation requirements. |
Skyward | course_crosswalk.csv | Includes all course-related information, including departments, course codes, course names, and associated State Service ID Codes. |
 | gpa.csv | Includes basic student demographic information along with their current GPA. |
 | grades.csv | Combined file that gives basic student demographic data, including information regarding both in-progress and completed coursework along with associated grades and credits. |
 | ibc.csv | Correlates IBCs to specific students based on their TSDS number.  |
 | students.csv | All students demographic information only. |
Skyward Q | course_crosswalk.csv | Includes all course-related information, including departments, course codes, and course names. |
 | gpa.csv | Includes basic student demographic information along with their current GPA. |
 | grades.csv | Combined file that gives basic student demographic data, including information regarding both in-progress and completed coursework along with associated grades and credits. |
 | serviceids.csv | Correlates course codes from the crosswalk document with associated State Service ID Codes. |
 | students.csv | All students demographic information only. |