Ed-Fi Mapping Information and Documents¶
Ed-Fi Mapping Document¶
Below is a link to the latest version of the Ed-Fi mapping document. The purpose of this document is to help describe to SIS vendors the different places VT is expecting data to be delivered, and other specific advice on working with Ed-Fi in VT.
This document was updated in May of 2025:
Vermont AOE - Ed-Fi Mapping - SY26.v1.xlsx
Legacy EdFusion to Ed-Fi mapping¶
This file has not be updated in some time, but represents the original mapping we had between EdFusion to EdFi. Please double check information contained here against the latest mapping files.
EdFusion file to Ed-Fi mapping
General EdFusion Table to Ed-Fi mapping:¶
Below is a mapping of commonly referred to tables and how they generally map to Ed-Fi. Please use the actual mapping documents for full reference, this is just a quick guide to help you find what you're looking for.
| EdFusion Table | Ed-Fi Resource | Ed-Fi Short Name |
|---|---|---|
| 0_Staff_Identity | staffs | staffs |
| 0_Student_Identity | students | students |
| 4_PS_Enroll | studentSchoolAssociations, studentEducationOrganizationResponsibilityAssociations | student_school, student_lea_responsibility student_school_responsibility is a join of these two |
| 5A_Public_PreK_Stu_Link | StudentProgramAssociations of type "UPK" | student_programs |
| 5_PS_GradeProg | studentSchoolAssociations | student_school |
| 6_PS_ADM | studentSchoolAssociations, student_lea | student_school has ADMTDIST student_lea can caputre ADMHOURS/ADMDAYS |
| 7_PS_Att | StudentSchoolAttendanceEvents | attendance |
| 8_OrgProfile | Calendars | calendars |
| 8a_OrgProfile_Holidays | CalendarDates | calendar_dates |
| 10_EmpOrg | StaffEducationOrganizationEmploymentAssociations | staff_emp |
| 11_POS | StaffEducationOrganizationAssignmentAssociations | staff_assign |
| 11a_POS_RoleTable | StaffEducationOrganizationAssignmentAssociations | staff_assign |
| 12_Course | CourseOfferings | course_offerings |
| 13_CourseSection | Sections | sections |
| 14a_StuSectionEnrollment | studentSectionAssociations | student_section |
| 14b_StaffSectionAssignment | StaffSectionAssociations | staff_section |
| 15_StudentSecResults | StudentAcademicRecords, CourseTranscripts | student_academics, course_transcripts |
| 16_CIRS_Incidents | DisciplineIncidents | discipline_incidents |
| 17_CIRS_Offenders | studentDisciplineIncidentAssociations | discipline_student |
| 18_CIRS_Actions | DisciplineActions | discipline_actions |
| 19_CIRS_Victims | studentDisciplineIncidentNonOffenderAssociations | discipline_victim |