Indiana Ed-Fi Data v2.4/3.1 - Student School Association

Classic View: System Administration > Ed-Fi

Search Terms: 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.

ActionTrigger
Post

When a new enrollment is saved for a student.  A record will report 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, report from the enrollment service type in the following order:
    1. P: Primary Enrollment
    2. S: Partial/Ancillary
    3. N: Special Education Services
  • When an enrollment with a higher priority is deleted, the enrollment with lower priority will post a new record.
  • Do not send records if the Calendar Exclude check box is checked in the calendar the student is enrolled.
  • Do not send records if the School Exclude check box is checked in the calendar the student is enrolled.
  • Do not send a record if the No Show check box is checked.
Post

When the start date for an enrollment is changed.

  • When an enrollment with a lower priority is changed, data will not send.
Put

An enrollment is updated for a student:

  • When a student's end status is changed.
  • When a student's grade level is changed.
  • When a change is made to the Graduation > NCLB Cohort End Year field.
  • When a student's 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 will not trigger a delete.
Delete

When the start date of an enrollment is changed.

DeleteWhen the No Show checkbox is checked.

Resource Toggle and Resync Logic

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

Action

Business Rule

NoneIf a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
PutIf the natural key of the Calendar Reference is changed, a put will be done to update the Calendar Reference even if the Student School Association resource is turned 'OFF'.
ResyncIf a record is in the Ed-Fi Identity Mapping table and not in the ODS, it will be deleted from the Ed-Fi Identity Mapping table.
ResyncIf a record is in the ODS and it does not have a matching record in Campus or the Ed-Fi Identity Mapping table, it will be deleted from the ODS.
ResyncIf a mapping is changed in Resource Preferences, a resync will need 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:  

  • If the School Number/Ed-Fi School Number changes, a delete/post will occur with the cascading deletes from the School ID Change triggers. 
  • If an Ed-Fi ID changes, this will happen with the cascading deletes from the Ed-Fi ID Change trigger.
  • If the enrollment start date changes, all dependent resources will be deleted and reposted.   If a dependent resource is turned off, all dependent resources will be deleted and not reposted.
Delete

Cascading Deletes:  If the Student School Association is deleted, all dependent resources will be 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 will send to the scope year for the school year the enrollment is associated with.
Data will only send for the years that have valid configuration.


Identity Mapping Object Key

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

campusObjectType

Object Key Data Source

EnrollmentenrollmentID

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.

personPost/DeleteStudent ID in Student Reference
graduationPutClass of School Year Type Reference
programsPutGraduation Plan Reference
programparticipationPutGraduation Plan Reference

Object Data Elements

This table describes data elements sent within the Student School Association resource. Data Element Labels in bold are part of the Natural Key and are required data elements for Data to send to Ed-Fi

Data Element LabelBusiness RequirementBusiness RulesM, C or O

Location

 id   

The unique identifier of the resource. 


M
graduationPlanReferenceA reference to the related Graduation Plan resource.

Report a hardcoded '01: General' if a student's graduation data on studentAcademicRecord is populated.


C
school
Reference  
 A reference to the related School resource. 

Report 10+District+School


M
classOf
School
YearType
Reference
The year the student is expected to graduate.
  1. Populate the year selected in Student Info > General > Graduation > NCLB Cohort End Year.
  2. When NCLB Cohort End Year = Null, do not report.
OStudent Info > General > Graduation > NCLB Cohort End Year
school
Year Type
Reference  
The school year in which the student is being reported.

Report the end year of the calendar.

O
student
Reference
  
 A reference to the related Student resource. 

Report the reference for the student being reported.

  • A student's Ed-Fi ID


M
entryDateThe month, day, and year on which an individual enters and begins to receive instructional services in a campus.Report the enrollment start date.MStudent Information > General > Enrollments > Start Date

enrollment.startdate
entryGrade
Level
Descriptor 
 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. 
  1. Report the Ed-Fi Code from the Grade Level mapping for the grade selected on the student's enrollment.
  2. If a mapping is not available, the record will error.
MStudent Information > General > Enrollments > Grade
entryGrade
LevelReasonType
 A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. 

This is optional, does not report.

O
entryType
Descriptor 
 A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. 
  1. Report the Ed-Fi Code Value from the Start Status selected.
  2. If blank, do not report.
OStudent Information > General > Enrollments > Start Status
repeatGrade
Indicator
An indicator of whether the student is enrolling to repeat a grade level, either by failure or an agreement to hold the student back.Look at the student's last enrollment record prior to the enrollment that is reporting and report the following:
  1. Report 'True' of End Action is = R: Retain
  2. Report 'False' if the End Action = P: Promote, D: Detain or NULL:
    • The prior enrollments start date must be before the reporting enrollment's start date.
OStudent Information > General > Enrollments > End Action


enrollment. endAction
schoolChoice
Transfer
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.
  1. Report 'True' when the checkbox is checked.
  2. Report 'False' when the checkbox is not checked.
OStudent Information > General > Enrollments > School Choice

enrollment. schoolChoice
Program
exitWithdraw
Date 
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. 

Report the enrollment end date.

CStudent Information > General > Enrollments > End Date

enrollment.enddate
exitWithdraw
Type
Descriptor 
 A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. 
  1. Report the Ed-Fi Code Value from the End Status selected.
  2. If blank, do not report.
CStudent Information > General > Enrollments > End Status

enrollment.endstatus
residency
Status
Descriptor 
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.
  1. Report 'Resident of admin unit and school area' if the Resident and Serving District fields are either NULL or = to the reporting district.
    • This can be any combination of NULL or populated (ex. Serving District can be NULL and Resident District = to reporting District).
  2. Report 'Resident of admin unit, but other school area' when the Serving District is not = to Reporting District.
    • The Resident District must be NULL or = to the reporting district to report.   If not, then report blank.
  3. Report 'Resident of this state, but not of this admin unit' when the Resident District is not = Reporting District.
    • The Serving District must be NULL or = to the reporting district to report.  If not, then report blank.
OStudent Information > General > Enrollments


enrollment.residentdistrict + enrollmentresidentSchool


and / or


enrollment.servingdistrict + enrollment.servingSchool


primarySchoolIndicates if a given enrollment record should be considered the primary record for a student. If omitted, the default is true.
  1. Report 'True' if Service Type = P: Primary.
  2. Otherwise report 'False'.

OStudent Information > General > Enrollments > Service Type

enrollment.type
employed
While
Enrolled
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, does not report.O
educationPlan
TypeID
An unordered collection of studentSchoolAssociationEducationPlans. This association represents the school in which a student is enrolled.This is optional, does not report.O
entryDate
(plan entry)
Education plan entry date.This is optional, does not report.O
etag



Type / Descriptor

Entry Grade Level Descriptors

Code ValueDescriptionName SpaceShort Description
01Grade 1http://doe.in.gov/Descriptor/GradeLevelDescriptor.xmlGrade 1
02Grade 2http://doe.in.gov/Descriptor/GradeLevelDescriptor.xmlGrade 2
03Grade 3http://doe.in.gov/Descriptor/GradeLevelDescriptor.xmlGrade 3
04Grade 4http://doe.in.gov/Descriptor/GradeLevelDescriptor.xmlGrade 4
05Grade 5http://doe.in.gov/Descriptor/GradeLevelDescriptor.xmlGrade 5
06Grade 6http://doe.in.gov/Descriptor/GradeLevelDescriptor.xmlGrade 6
07Grade 7http://doe.in.gov/Descriptor/GradeLevelDescriptor.xmlGrade 7
08Grade 8http://doe.in.gov/Descriptor/GradeLevelDescriptor.xmlGrade 8
09Grade 9http://doe.in.gov/Descriptor/GradeLevelDescriptor.xmlGrade 9
10Grade 10http://doe.in.gov/Descriptor/GradeLevelDescriptor.xmlGrade 10
11Grade 11http://doe.in.gov/Descriptor/GradeLevelDescriptor.xmlGrade 11
12Grade 12http://doe.in.gov/Descriptor/GradeLevelDescriptor.xmlGrade 12
13Used for an individual assigned to a class or program that does not have standard grade designations. This may include students who remain enrolled in school after completing high school in order to earn additional high school credits and students with disabilities.http://doe.in.gov/Descriptor/GradeLevelDescriptor.xmlGrade 13
KGKG - Full Dayhttp://doe.in.gov/Descriptor/GradeLevelDescriptor.xmlKG - Full Day
KG - AfternoonKG - Afternoonhttp://doe.in.gov/Descriptor/GradeLevelDescriptor.xmlKG - Afternoon
KG - MorningKG - Morninghttp://doe.in.gov/Descriptor/GradeLevelDescriptor.xmlKG - Morning
PKPreKindergartenhttp://doe.in.gov/Descriptor/GradeLevelDescriptor.xmlPreKindergarten

Entry Type Descriptors

Code ValueDescriptionNamespaceShort Description
TransferTransferuri://ed-fi.org/EntryTypeDescriptorTransfer
New to education systemNew to education systemuri://ed-fi.org/EntryTypeDescriptorNew to education system
Next year schoolNext year schooluri://ed-fi.org/EntryTypeDescriptorNext year school
OtherOtheruri://ed-fi.org/EntryTypeDescriptorOther
Re-entryRe-entryuri://ed-fi.org/EntryTypeDescriptorRe-entry

Exit Withdraw Type Descriptors

Code ValueDescriptionNamespaceShort Description
01Record of School Failurehttp://doe.in.gov/Descriptor/ExitWithdrawTypeDescriptor.xmlRecord of School Failure
02Disinterest in Curriculumhttp://doe.in.gov/Descriptor/ExitWithdrawTypeDescriptor.xmlDisinterest in Curriculum
03Interpersonal Problemshttp://doe.in.gov/Descriptor/ExitWithdrawTypeDescriptor.xmlInterpersonal Problems
05Need to Earn Money (financial hardship and the individual must be employed to support the individuals family or a dependent)http://doe.in.gov/Descriptor/ExitWithdrawTypeDescriptor.xmlNeed to Earn Money
10Poor Health - Students who are unable to attend school (or to receive instruction through alternate means) due to a long-term medical condition can be exited from the cohort due to poor health.http://doe.in.gov/Descriptor/ExitWithdrawTypeDescriptor.xmlPoor Health
12Armed Services Enlistment - Students whose enlistment has been verified by a recruiter.http://doe.in.gov/Descriptor/ExitWithdrawTypeDescriptor.xmlArmed Services Enlistment
13Court Ordered to Dropout - Student ordered to drop out of school (or obtain a High School Equivalency) by a court that has jurisdiction over the student.http://doe.in.gov/Descriptor/ExitWithdrawTypeDescriptor.xmlCourt Ordered to Dropout
14Unknown or No Shows (Age 18+) - Code 14 (Unknown or No Show) can only be reported for a student 18 years of age or older. A student reported under this code will have a status of 'dropout' on the graduation cohort report. http://doe.in.gov/Descriptor/ExitWithdrawTypeDescriptor.xmlUnknown or No Shows (Age 18+)
15Truancy (Underage No Shows) - If a student has not completed an exit interview and has not shown up to school then the student should be reported under Code 15, Truant. Code 15 (truancy) can only be reported for a student under the age of 18. http://doe.in.gov/Descriptor/ExitWithdrawTypeDescriptor.xmlTruancy (Underage No Shows)
16Expulsion, Did Not Return Students who did not return to school after the term of an expulsion. Code 16 is for expelled students who do not return to any educational setting when their expulsion is over; they are considered dropouts. http://doe.in.gov/Descriptor/ExitWithdrawTypeDescriptor.xmlExpulsion, Did Not Return
17Missing but Locatedhttp://doe.in.gov/Descriptor/ExitWithdrawTypeDescriptor.xmlMissing but Located
18Failure of Graduation Qualifying Exam (GQE)http://doe.in.gov/Descriptor/ExitWithdrawTypeDescriptor.xmlFailure of Graduation Qualifying Exam (GQE)
19Transferred - One of the primary reasons a student is mobile is because the student has transferred to another school. http://doe.in.gov/Descriptor/ExitWithdrawTypeDescriptor.xmlTransferred
20Removed by parents to provide Home-Schooled instruction - A parent who removes their student from school in order to provide instruction equivalent to that given in a public school should be reported as code 20, Removal to Homeschool.http://doe.in.gov/Descriptor/ExitWithdrawTypeDescriptor.xmlRemoved by parents to provide Home-School instruction
21Deceasedhttp://doe.in.gov/Descriptor/ExitWithdrawTypeDescriptor.xmlDeceased
22Incarcerated or placed in protective custodyhttp://doe.in.gov/Descriptor/ExitWithdrawTypeDescriptor.xmlIncarcerated or placed in protective custody
25Transferred out of state -  Code 25 can be used for a student of any grade who moves out of the state (including those moving out of the country) and enrolls in another school.http://doe.in.gov/Descriptor/ExitWithdrawTypeDescriptor.xmlTransferred Out of State
26Missing, students who cannot be located and have been reported to the Clearinghouse for Information on Missing Children.http://doe.in.gov/Descriptor/ExitWithdrawTypeDescriptor.xmlMissing, students who cannot be located
27Foreign exchange student who returns to country of origin-  A student who attended a school through a foreign exchange program and left to return to the student's  home county should be reported as Foreign Exchange.http://doe.in.gov/Descriptor/ExitWithdrawTypeDescriptor.xmlForeign exchange student who returns to country of origin
28A student who has been removed from school for religious purposes should be reported as code 28. An example of a student removed for religious purposes is an Amish student.http://doe.in.gov/Descriptor/ExitWithdrawTypeDescriptor.xmlReligious Beliefs
29Special education student becomes ineligible due to age - Student reaches the age of 22 but does not graduate from high school and does not return by October 1.http://doe.in.gov/Descriptor/ExitWithdrawTypeDescriptor.xmlSpecial education student becomes ineligible due to age
30Earned High School Equivalency (replaced GED)http://doe.in.gov/Descriptor/ExitWithdrawTypeDescriptor.xmlEarned High School Equivalency (replaced GED)
31Transferred to a non-state-accredited non-public school or a non-state-accredited nonpublic virtual schoolhttp://doe.in.gov/Descriptor/ExitWithdrawTypeDescriptor.xmlTransferred to a non-state-accredited non-public school
33Serving Expulsionhttp://doe.in.gov/Descriptor/ExitWithdrawTypeDescriptor.xmlServing Expulsion
34Midyear Graduate (or midyear recipient of Certificate of Completion, Course Completion or diploma)http://doe.in.gov/Descriptor/ExitWithdrawTypeDescriptor.xmlMidyear Graduate
35Participation in the HSE Pilot Programhttp://doe.in.gov/Descriptor/ExitWithdrawTypeDescriptor.xmlParticipation in the HSE Pilot Program
50End of School Year - If the student is expected to return to the same school or next school (based on grade promotion) in the same corporation, use this code.http://doe.in.gov/Descriptor/ExitWithdrawTypeDescriptor.xmlEnd of School Year

Graduation Plan Type Descriptor

Code ValueDescriptionNamespaceShort Description
01Generalhttp://doe.in.gov/Descriptor/GraduationPlanTypeDescriptor.xml
General