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 when an enrollment is marked as No Show or State Exclude. Does not send a record when enrollment is in a Calendar marked as State Exclude. Does not send a record when enrollment is in a School marked as State Exclude.
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 or State Exclude check box is marked on the enrollment record.

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 value from Enrollment Override location. When the Enrollment Override location is NULL, reports based on the following: When the previous school year does not have an exit code, reports the earliest enrollment start date where the student consecutively attended the current school. Otherwise, report the current enrollment start date.	M	Student Information > General > Enrollments > General Enrollment Information > Start Date Enrollment.startdate Student Information > General > Enrollments > State Reporting Fields > Entry into School Override EnrollmentKS.schoolDate
calendarReference	A reference related to the Calendar resource. This field is optional and does not report.	O
studentReference	A reference to the related Student resource. Reports the Ed-Fi ID from the Student State ID field.	M
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
localEducationAgencyEntryDate	Reports the student's earliest date of entry at the district. Reports the value from Enrollment Override location. When the Override location is NULL, reports based on the following: When the previous school year does not have an exit code (endStatus) = 1, 5, or 6, then reports the earliest enrollment start date where the student consecutively attended in the current district. Otherwise, reports the current enrollment start date.	M	Student Information > General > Enrollments > State Reporting Fields > Entry into District Override EnrollmentKS.districtDate
stateEntryDate	Reports the student's earliest date of entry at a school in the state. Reports the value from Enrollment Override location. When the Enrollment Override location is NULL, reports based on the following: When the previous school year does not have an exit code (endStatus) = 1, 2, 4, 5, 6 or 15, then reports the earliest enrollment start date where the student consecutively attended in the current state. Otherwise, reports the current enrollment start date.	M	Student Information > General > Enrollments > State Reporting Fields > Entry into State Override EnrollmentKS.stateDate
membershipDays	Report the number of days the student has been enrolled in this school when school was in session during the current school year. Calculation: Membership Days = Days present + Days absent. Notes: When exit code (endStatus) = 18 (Student Data Claimed in Error), reports 0 (zero) for Membership Days. Half-day kindergarten students should not have their days of attendance divided by two. Count half-day kindergarten students in attendance for every day they attend their half-day program. Cannot be greater than 366.	O	Calculated
attendanceDays	The number of days the student has been present in this school when school was in session during the current school year. Calculation: Attendance Days = Membership Days - Days absent. Notes: When exit code (endStatus) = 18 (Student Data Claimed in Error), report '0' (zero) for Attendance Days. Part-time students should be marked as a full day of attendance when they were present for all of their scheduled time. Half-day kindergarten students should not have their days of attendance divided by two. Count half-day kindergarten students in attendance for every day they attend their half-day program. Cannot be greater than 366.	O	Calculated
minutesEnrolled	Total number of instructional minutes for which the student is enrolled. When the "Sept 20th Rule" OR the "Feb 20th Rule" is marked, Minutes Enrolled = 0. When neither is marked, reports Minutes Enrolled from the Enrolled Minutes Override field When the Enrolled Minutes Override is blank, calculate daily minutes as follows: Find a week where all 5 days are instructional: Sum all period minutes student is scheduled into. Subtract lunch time minutes. Add the minutes between periods when the amount of time between periods is < = 10 minutes for each day that week. Subtract minutes from one lunchtime passing period each day - either before or after lunch NOT both. Divide by 5. Round value to the nearest whole number	O	Student Information > General > Enrollments > State Reporting Fields >Include Feb 20th Student Information > General > Enrollments > State Reporting Fields > Enrolled Minutes Override
unweightedGradePointAverage	Student's unweighted cumulative GPA. Only reports for students who graduated with a regular high school diploma. When a student has an exit code (endStatus) = 8, report as follows: When unweighted cumulative GPA = blank, reports blank. Otherwise, when unweighted cumulative GPA > 4.00, report 4.00. Otherwise, report value. Otherwise, does not report.		Student Information > General > Enrollments > General Enrollment Information > Local End Status Student Information > General > Credit Summary > Cumulative GPA
qualifiedfor504Descriptor	Indicates the type of 504 qualification of the student. Assigns qualifiedfor504Descriptor value based on the following logic: When the student has a section 504 record that overlaps the config year AND End Date is null OR >= today's date, reports: Currently a 504 qualified student" (KIDs value 1) Otherwise, when a student has a section 504 record that overlaps the config year AND End date < today's date, reports: "Not currently a 504 qualified student but has been this school year" (KIDs value 2) Othterwise, reports: "Not a 504 qualified student and has not been this school year" (KIDs value 0)		Student Information > Program Participation > Section 504 > Start Date Student Information > Program Participation > Section 504 > End Date
cteContactMinutes	Number of minutes student received instruction in a state funding approved career and technical education course. Report students in grades 9-12 and secondary students who are not graded. Reports value specified or blank when none was entered.	O	Student Information > General > Enrollment > State Reporting Fields > Tech Ed Minutes EnrollmentKS.vocationalMinutes
individualPlanOfStudy	Indicates whether a student in grades 11-17 has an Individual Plan of Study (IPS). For students in grades 11-17, report: 0 when student does not have an IPS 1 when an IPS exists with a start date that overlaps the config year Reports blank for all other students.	O	Student Information > Program Participation > State Programs > Individual Plan of Study
creditsEarned	For students assigned to a Graduation Program, reports the number of completed credits earned towards High School graduation. When the student is assigned to a Graduation Program which overlaps the config year, report total Credits Earned. Otherwise, reports blank. **Only reports for students enrolled in state code 14,15,16, or 17.		Student Information > Academic Planning > Graduation Program > Graduation Program Detail Program.programCategory Program.name Transcript > Credits Earned TranscriptCredit.creditsEarned
creditRequiredtoGraduate	For students assigned to a Graduation Program, reports the number of completed credits required towards High School graduation. When the student is assigned to a Graduation Program with dates overlaps the config year, report total Credits Earned. Otherwise, reports blank. **Only reports for students enrolled in state code 14,15,16, or 17.		Student Information > Academic Planning > Graduation Program > Graduation Program Detail Transcript > Credits Earned

Type/Descriptor

Click here to expand...

Entry Grade Level Descriptors

Code Value	Description	Name Space	Short Description
Infant/toddler	Infant/toddler	uri://ed-fi.org/GradeLevelDescriptor	Infant/toddler
Kindergarten	Kindergarten	uri://ed-fi.org/GradeLevelDescriptor	Kindergarten
First Grade	First Grade	uri://ed-fi.org/GradeLevelDescriptor	First Grade
Second Grade	Second Grade	uri://ed-fi.org/GradeLevelDescriptor	Second Grade
Third Grade	Third Grade	uri://ed-fi.org/GradeLevelDescriptor	Third Grade
Fourth Grade	Fourth Grade	uri://ed-fi.org/GradeLevelDescriptor	Fourth Grade
Fifth Grade	Fifth Grade	uri://ed-fi.org/GradeLevelDescriptor	Fifteh Grade
Sixth Grade	Sixth Grade	uri://ed-fi.org/GradeLevelDescriptor	Sixth Grade
Seventh Grade	Seventh Grade	uri://ed-fi.org/GradeLevelDescriptor	Seventh Grade
Eighth Grade	Eighth Grade	uri://ed-fi.org/GradeLevelDescriptor	Eighth Grade
Ninth Grade	Ninth Grade	uri://ed-fi.org/GradeLevelDescriptor	Ninth Grade
Tenth Grade	Tenth Grade	uri://ed-fi.org/GradeLevelDescriptor	Tenth Grade
Eleventh Grade	Eleventh Grade	uri://ed-fi.org/GradeLevelDescriptor	Eleventh Grade
Twelfth Grade	Twelfth Grade	uri://ed-fi.org/GradeLevelDescriptor	Twelfth Grade
Ungraded	Ungraded	uri://ed-fi.org/GradeLevelDescriptor	Ungraded
Preschool	Preschool	uri://ed-fi.org/GradeLevelDescriptor	Preschool

Exit Withdraw Type Descriptors

Qualified For 504 Descriptor

Code Value	Description	Name Space	Short Description
Currently a 504 qualified student	Currently a 504 qualified student	uri://ksde.org/QualifiedFor504Descriptor	Currently a 504 qualified student
Not 504 qualified but has been this school year	Not 504 qualified but has been this school year	uri://ksde.org/QualifiedFor504Descriptor	Not 504 qualified but has been this school year
Not a 504 qualified student this school year	Not a 504 qualified student this school year	uri://ksde.org/QualifiedFor504Descriptor	Not a 504 qualified student this school year

Code Value	Description	Namespace	Short Description
1	Transfer to a public school in the same district	uri://ksde.org/ExitWithdrawTypeDescriptor	Transfer to a public school in the same district
2	Transfer to a public school in a different district in Kansas	uri://ksde.org/ExitWithdrawTypeDescriptor	Transfer to a public school in a different district in Kansas
3	Transfer to a public school in a different state	uri://ksde.org/ExitWithdrawTypeDescriptor	Transfer to a public school in a different state
4	Transfer to an accredited private school in Kansas or in a different state	uri://ksde.org/ExitWithdrawTypeDescriptor	Transfer to an accredited private school in Kansas or in a different state
5	Transfer to non-accredited private school in Kansas or in a different state	uri://ksde.org/ExitWithdrawTypeDescriptor	Transfer to non-accredited private school in Kansas or in a different state
6	Transfer to home schooling	uri://ksde.org/ExitWithdrawTypeDescriptor	Transfer to home schooling
8	Graduated with regular diploma	uri://ksde.org/ExitWithdrawTypeDescriptor	Graduated with regular diploma
10	Student death	uri://ksde.org/ExitWithdrawTypeDescriptor	Student death
11	Student illness	uri://ksde.org/ExitWithdrawTypeDescriptor	Student illness
12	Student expulsion (or long-term suspension)	uri://ksde.org/ExitWithdrawTypeDescriptor	Student expulsion (or long-term suspension)
13	Reached maximum age for services	uri://ksde.org/ExitWithdrawTypeDescriptor	Reached maximum age for services
14	Discontinued schooling (including preschoolers/Kindergartners who are removed from schooling by parents).	uri://ksde.org/ExitWithdrawTypeDescriptor	Discontinued schooling (including preschoolers/Kindergartners who are removed from schooling by parents).
15	Transfer to a juvenile or adult correctional facility where diploma completion services are provided.	uri://ksde.org/ExitWithdrawTypeDescriptor	Transfer to a juvenile or adult correctional facility where diploma completion services are provided.
16	Moved within the US, not known to be enrolled in school	uri://ksde.org/ExitWithdrawTypeDescriptor	Moved within the US, not known to be enrolled in school
17	Unknown	uri://ksde.org/ExitWithdrawTypeDescriptor	Unknown
18	Student data claimed in error by an ASGT record	uri://ksde.org/ExitWithdrawTypeDescriptor	Student data claimed in error by an ASGT record
19	Transfer to a GED completion program	uri://ksde.org/ExitWithdrawTypeDescriptor	Transfer to a GED completion program
20	Transferred to a juvenile or adult correctional facility where diploma completion services are not provided	uri://ksde.org/ExitWithdrawTypeDescriptor	Transferred to a juvenile or adult correctional facility where diploma completion services are not provided
21	Student moved to another country, may or may not be continuing	uri://ksde.org/ExitWithdrawTypeDescriptor	Student moved to another country, may or may not be continuing
22	Student with disabilities who met the district graduation requirements for a regular diploma, but is remaining in school to receive transitional services deemed necessary by the IEP team	uri://ksde.org/ExitWithdrawTypeDescriptor	Student with disabilities who met the district graduation requirements for a regular diploma, but is remaining in school to receive transitional services deemed necessary by the IEP team
98	Unresolved Exit (KSDE use only)	uri://ksde.org/ExitWithdrawTypeDescriptor	Unresolved Exit (KSDE use only)
99	Undo a previously submitted EXIT Record	uri://ksde.org/ExitWithdrawTypeDescriptor	Undo a previously submitted EXIT Record

Student School Association (Kansas v3.6)