Tool Search: Ed-Fi

This association represents the school in which a student is enrolled.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	When a new enrollment is saved for a student. A record reports for each distinct enrollment in a School and Enrollment Start Date. When a student has two enrollments in the same School, Calendar and Schedule Structure with the same start date, reports from the enrollment service type in the following order: P: Primary Enrollment S: Partial/Ancillary N: Special Ed Services When a student has two Primary enrollments in the same school with the same start date, posts the record with the highest enrollment ID. When an enrollment with a higher priority is deleted, the enrollment with lower priority posts a new record. Does not send records when the Calendar Exclude check box is marked on the calendar in which the student is enrolled. Does not send records when the School Exclude check box is marked on the calendar in which the student the student is enrolled. Does not send a record when the No Show check box is marked.
Post	When the start date for an enrollment is changed. When an enrollment with a lower priority is changed, data does not send.
Put	When an enrollment is updated for a student. When a change is made to the Graduation NCLB Cohort End Year field. When a student is assigned to a Graduation or CTE Program or the start and/or end dates are modified. When a student's Start Status is changed. When a student's End Status is changed. When a student's Grade Level is changed. When a student's End Action is changed. When a student's School Choice checkbox is marked or unmarked. When a student's Resident District or Service District fields are changed. When a students Service Type is changed. When the Calendar reference is changed due to a Natural Key update on the Calendars resource.
Delete	When an enrollment is deleted. When a student has two enrollments in the same school for the same start date, records with lower priority do not trigger a delete.
Delete	When the start date of an enrollment is changed.
Delete	When the No Show check box is marked.

Resource Toggle and Resync Logic

This table describes the Resource Toggle and Trigger logic of this object.

Action	Business Rule
None	When a resource is toggled to OFF after data has sent, all sent data remains in the ODS but no new data is sent.
Put	When the natural key of the Calendar Reference is changed, a put is done to update the Calendar Reference evenwhen the Student School Association resource is turned OFF.
Resync	When a record is in the Ed-Fi Identity Mapping table and not in the ODS, it is deleted from the Ed-Fi Identity Mapping table.
Resync	When a record is in the ODS and it does not have a matching record in Campus or the Ed-Fi Identity Mapping table, it is deleted from the ODS.
Resync	When a mapping is changed in Resource Preferences, a resync needs to be done to reflect the changes.

Natural Key Changes, Cascading Updates, and Deletes Logic

This table describes the Natural Key Changes/Cascading Updates and Deletes logic of this object.

Action

Business Rule

Post/Delete

Natural Key changes:

When the School Number/Ed-Fi School Number changes, a delete/post occurs with the cascading deletes from the School ID Change triggers.
When an Ed-Fi ID changes, this happens with the cascading deletes from the Ed-Fi ID Change trigger.
When the enrollment start date changes, all dependent resources is deleted and reposted. When a dependent resource is turned off, all dependent resources are deleted and not reposted.

Delete

Cascading Deletes: When the Student School Association is deleted, all dependent resources are deleted.

Student Parent Associations
Student Education Organization Associations
Student Section Associations
Graduation Plans
Student Program Associations
Student CTE Program Associations
Student Special Education Program Associations
Student Title 1 Part A Program Associations

Student Academic Records
Course Transcripts
Grades
Student Discipline Incident Associations
Discipline Actions
Student Cohort Associations
Student School Attendance Events
Student Section Attendance Events

Scope Year Logic

This table describes scope year logic of this object.

Logic
The record sends to the scope year for the school year for which the enrollment is associated.
Data only sends for the years that have valid configuration.

Resource Preferences

This table describes the Resource Preferences of this object.

Data Element Label	Mapping Needed
Entry Type Descriptors	Enrollment Start Status
Exit Withdraw Type Descriptors	Enrollment End Status

Identity Mapping Object Key

This table describes the Identity Mapping Object Key of this object.

campusObjectType	Object Key Data Source
Enrollment	enrollmentID

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus Table	Ed-Fi Action	Fields
enrollment	Post/Put/Delete	The primary table used for sending data for this resource.
person	Post/Delete	Student ID in Student Reference
graduation	Put	Class of School Year Type Reference
programs	Put	Graduation Plan Reference
programparticipation	Put	Graduation Plan Reference

Object Data Elements

This table describes data elements sent within the Student School Association resource.

Data Element Label	Business Requirements and Rules	Mandatory, Conditional, or Optional	Location
id	The unique identifier of the resource.	M
entryDate	Reports the student's earliest start date of the enrollment in the school. Reports the enrollment start date.	M	Student Information > General > Enrollments > General Enrollment Information > Start Date Enrollment.startdate
calendarReference	A reference related to the Calendar resource. Reports the Calendar reference for the calendar in which the student is enrolled that is being reported.	O
classOfSchoolYearTypeReference	The year the student is expected to graduate. Reports the year selected in the NCLB Cohort End Year on the student's Graduation record. When the NCLB Cohort End Year is not populated, does not report.	C
graduationPlanReference	A reference to the related GraduationPlan resource. Reports the associated Graduation Plan when a student is assigned to a Graduation Program or Career Tech Program that is eligible to report to Ed-Fi. The Program Participation record must overlap the enrollment(s) that are aligned to the Student School Association record(s) being reported. Reports the Graduation Plan School year that is aligned to the student's NCLB Cohort End Year. When the student does not have a NCLB Cohort End Year, does not report a record. When the student has both a CTE and a Graduation Plan, reports the Graduation Plan. When the student has more than one Graduation Plan, reports the plan with the most recent start date	O
schoolReference	A reference to the related School resource. Reports the fields that are part of the Natural Key for the School resource.	M
schoolYearTypeReference	The school year in which the student is being reported. Reports the end year of the calendar.	O
studentReference	A reference to the related Student resource. Reports the Ed-Fi ID from the Student State ID field.	M
educationPlans	An unordered collection of studentSchoolAssociationEducationPlans. This association represents the school in which a student is enrolled. This is optional and does not report.	O
employedWhileEnrolled	An individual who is a paid employee or works in his or her own business, profession, or farm and at the same time is enrolled in secondary, postsecondary, or adult education. This is optional and does not report.	O
entryGradeLevelDescriptor	The grade level or primary instructional level at which a student enters and receives services in a school or an educational institution during a given academic session. Reports the Ed-Fi Code from the Grade Level mapping for the grade selected on the student's enrollment. When a mapping is not available, the record errors.	M	Student Information > General > Enrollments > Grade Enroilment.grade
entryGradeLevelReasonDescriptor	A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. This is optional and does not report.	O
entryTypeDescriptor	A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. Reports the Ed-Fi Code Value mapped to the Start Status selected. When blank, does not report.	O	Student Information > General > Enrollments > Start Status Enrollment.startStatus
exitWithdrawDate	The month, day, and year of the first day after the date of an individual''s last attendance at a campus (if known), the day on which an individual graduated, or the date on which it becomes known officially that an individual left school. NEDM: Exit/Withdraw Date Reports the enrollment end date.	O	Student Information > General > Enrollments > End Date Enrollment.endDate
exitWithdrawTypeDescriptor	A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. Reports the Ed-Fi Code Value from the End Status selected. When blank, does not report.	O	Student Information > General > Enrollments > General Enrollment Information > End Status Enrollment.endstatus
primarySchool	Indicates if a given enrollment record should be considered the primary record for a student. If omitted, the default is true. Reports True when the Enrollment Service Type is P: Primary. Otherwise, reports False.	O	Student Information > General > Enrollments > Service Type Enrollment.type
repeatGradeIndicator	An indicator of whether the student is enrolling to repeat a grade level, either by failure or an agreement to hold the student back. Looks at the student's last enrollment record prior to the enrollment that is reporting and report the following: Reports True when End Action is R: Retain. Reports False when the End Action is P: Promote, D: Detain or not populated. The prior enrollment's start date must be before the reporting enrollment's start date.	O	Student Information > General > Enrollments > End Action Enrollment.endAction
residencyStatusDescriptor	An indication of the location of a persons legal residence relative to (within or outside of) the boundaries of the public school attended and its administrative unit. Reports the Resident of admin unit and school area when the Resident and Serving District fields are either NULL or equal to the reporting district. This can be any combination of NULL or populated (ex. Serving District can be NULL and Resident District is equal to reporting District). Reports the Resident of admin unit, but other school area when the Serving District is not equal to Reporting District. The Resident District must be NULL or equal to the reporting district to report. When not, reports blank. Reports Resident of this state, but not of this admin unit when the Resident District is not equal to the Reporting District. The Serving District must be NULL or equal to the reporting district to report. When not, then report blank.		Student Information > General > Enrollments > Resident District Enrollment.residentDistrict Enrollment.servingDistrict
schoolChoiceTransfer	An indication of whether students transferred in or out of the school did so during the school year under the provisions for public school choice in accordance with Title I, Part A, Section 1116. Reports True when the checkbox is marked. Reports False when the checkbox is not marked.	O	Student Information > General > Enrollments > School Choice Enrollment.schoolChoiceProgram
fullTimeEquivalency	The full-time equivalent ratio for the student s assignment to a school for services or instruction. For example, a full-time student would have an FTE value of 1 while a half-time student would have an FTE value of 0.5. This is optional and does not report.	O

Type/Descriptor

Click here to expand...

Residency Status Descriptors

Code	Description	Short Description	State/Legacy Code Description	Namespace
01	Regular student	Regular student	Regular student A student who meets all of the regular admission requirements of a school or an educational institution. This includes only students who are residents of the operating school district, students who are residents of member towns of a union district, and students tuitioned from other districts.	uri://vermont.ed.gov/ResidencyStatusDescriptor
02	School Choice Student	School Choice Student	School Choice Student- A high school student who meets all of the regular admission requirements of a school attending from another Vermont high school with a school choice agreement.	uri://vermont.ed.gov/ResidencyStatusDescriptor
03	Exchange student	Exchange student	Exchange student A student from a country outside of the United States or its outlying areas who is temporarily enrolled in classes or a course of study at a school or educational institution in the United States. These students should have a FUNDSOURCE of 07, 09 or 98, and an ADMTDIST of 906.	uri://vermont.ed.gov/ResidencyStatusDescriptor
04	Home-study student taking academic classes	Home-study student taking academic classes	Home Study student taking academic classes A student who receives home instruction and takes academic courses at a school. Academic courses include those courses that regular students receive academic credit for and that take place during normal school hours. Note: these students may or may not participate in extra- or co-curricular activities.	uri://vermont.ed.gov/ResidencyStatusDescriptor
05	Home-study only extra-activities	Home-study only extra-activities	Home Study student participating in extra- or co-curricular activities only A student who receives home instruction and who participates in school sponsored extra- or co-curricular activities. These activities frequently take place outside of normal school hours and often last for only a portion of the school year. The school is not required to track attendance for these students. Do not include students attending an independent school and participating in extra- or co-curricular activities here.	uri://vermont.ed.gov/ResidencyStatusDescriptor
06	Guest student	Guest student	Guest student A student attending a school or educational institution on a full-time basis other than the school of his or her regular enrollment without tuition payments.	uri://vermont.ed.gov/ResidencyStatusDescriptor
07	Receiving Services But Not Enrolled	Receiving Services But Not Enrolled	Student is receiving services at this school, and enrolled in a different organization.	uri://vermont.ed.gov/ResidencyStatusDescriptor
08	Enrolled But Receiving Services Elsewhere	Enrolled But Receiving Services Elsewhere	Student is enrolled at this school, but, receiving services in a different organization.	uri://vermont.ed.gov/ResidencyStatusDescriptor
09	HSCP Student	HSCP Student	HSCP Student Attending the high school completion program.	uri://vermont.ed.gov/ResidencyStatusDescriptor

EntryType Descriptors

Code	Description	Short Description	Namespace
01	Transfer from VT Public School	Transfer from VT Public School	uri://vermont.ed.gov/EntryTypeDescriptor
02	Transfer from Independent School	Transfer from Independent School	uri://vermont.ed.gov/EntryTypeDescriptor
03	Transfer from Outside State	Transfer from Outside State	uri://vermont.ed.gov/EntryTypeDescriptor
04	Transfer from Institution	Transfer from Institution	uri://vermont.ed.go/EntryTypeDescriptor
05	Transfer from Home Study	Transfer from Home Study	uri://vermont.ed.gov/EntryTypeDescriptor
06	Matriculation/Promotion	Matriculation/Promotion	uri://vermont.ed.gov/EntryTypeDescriptor
07	Re-entry	Re-entry	uri://vermont.ed.gov/EntryTypeDescriptor
08	New to Any Education System	New to Any Education System	uri://vermont.ed.gov/EntryTypeDescriptor
09	New to U.S. Without School Interruption	New to U.S. Without School Interruption	uri://vermont.ed.gov/EntryTypeDescriptor
10	New to U.S. With School Interruption	New to U.S. With School Interruption	uri://vermont.ed.gov/EntryTypeDescriptor

Exit Type Descriptor

Code	Description	Short Description	Namespace
01	Transfer to VT Public School	Transfer to VT Public School	uri://vermont.ed.gov/ExitWithdrawTypeDescriptor
02	Transfer To VT School Choice	Transfer To VT School Choice	uri://vermont.ed.gov/ExitWithdrawTypeDescriptor
03	Transfer To VT Independent School	Transfer To VT Independent School	uri://vermont.ed.gov/ExitWithdrawTypeDescriptor
04	Transfer To School Outside VT	Transfer To School Outside VT	uri://vermont.ed.gov/ExitWithdrawTypeDescriptor
05	Transfer To An Institution	Transfer To An Institution	uri://vermont.ed.gov/ExitWithdrawTypeDescriptor
06	Transfer to Home Study	Transfer to Home Study	uri://vermont.ed.gov/ExitWithdrawTypeDescriptor
07	Matriculation/Promotion	Matriculation/Promotion	uri://vermont.ed.gov/ExitWithdrawTypeDescriptor
08	Graduated With Regular Diploma	Graduated With Regular Diploma	uri://vermont.ed.gov/ExitWithdrawTypeDescriptor
09	Completed School With Other Credentials	Completed School With Other Credentials	uri://vermont.ed.gov/ExitWithdrawTypeDescriptor
11	Death	Death	uri://vermont.ed.gov/ExitWithdrawTypeDescriptor
12	Illness	Illness	uri://vermont.ed.gov/ExitWithdrawTypeDescriptor
14	Discontinued Schooling	Discontinued Schooling	uri://vermont.ed.gov/ExitWithdrawTypeDescriptor
15	Absence/Status Unknown	Absence/Status Unknown	uri://vermont.ed.gov/ExitWithdrawTypeDescriptor
16	Moved And Not Known To Be Continuing School	Moved And Not Known To Be Continuing School	uri://vermont.ed.gov/ExitWithdrawTypeDescriptor
18	Transfer to GED program NOT operated by VT School	Transfer to GED program NOT operated by VT School	uri://vermont.ed.gov/ExitWithdrawTypeDescriptor
19	Transfer to College Program	Transfer to College Program	uri://vermont.ed.gov/ExitWithdrawTypeDescriptor

Entry Grade Level Descriptor

Code	Grade Level
01	1st Grade
02	2nd Grade
03	3rd Grade
04	4th Grade
05	5th Grade
06	6th Grade
07	7th Grade
08	8th Grade
09	9th Grade
10	10th Grade
11	11th Grade
12	12th Grade
AW	Adult Without Diploma
EE	Early Essential Education (EEE)
IT	Infant and Toddlers
KF	Full-Time Kindergarten
KP	Part-Time Kindergarten
PD	Post Graduate/Adult With Diploma
PK	Pre-Kindergarten

Student School Associations (Vermont v3.6)