Student School Associations (Indiana v3.6)

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

Object Triggering Logic

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, report 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, post the record with the highest enrollment ID. Do not send a record if any of the following exclusions are present: Enrollment State Exclude Enrollment No Show Enrollment Grade Exclude from State Reporting Calendar Exclude School Exclude Enrollment End Status mapped to State Code of '000'
DELETE / POST PUT	A DELETE/POST will be performed when the natural key of the record is changed. A PUT will be performed otherwise: When a student's enrollment is changed on any of the following fields: End Action End Date Local End Status End Year Grade Service Type Start Date Local Start Status State Exclude No Show When a student's graduation tab is changed on any of the following fields: NCLB Cohort End Year
DELETE	When an enrollment is deleted. When an enrollment is excluded in some way (State Exclude, No Show, etc.).

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, report 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, post the record with the highest enrollment ID.
Do not send a record if any of the following exclusions are present:
- Enrollment State Exclude
- Enrollment No Show
- Enrollment Grade Exclude from State Reporting
- Calendar Exclude
- School Exclude
- Enrollment End Status mapped to State Code of '000'

DELETE /
POST

PUT

A DELETE/POST will be performed when the natural key of the record is changed. A PUT will be performed otherwise:

When a student's enrollment is changed on any of the following fields:
- End Action
- End Date
- Local End Status
- End Year
- Grade
- Service Type
- Start Date
- Local Start Status
- State Exclude
- No Show
When a student's graduation tab is changed on any of the following fields:
- NCLB Cohort End Year

DELETE

When an enrollment is deleted.
When an enrollment is excluded in some way (State Exclude, No Show, etc.).

Error Log

Error	Possible Causes / How to Fix
The Grade Level associated with this student's enrollment is not mapped in Resource Preferences. Map the grade levels in Resource Preferences and resync this student.	The JSON is attempting to send with a blank entryGradeLevelDescriptor or without an entryGradeLevelDescriptor. Map the Grade Levels in Resource Preferences and then resync the Student School Association resource for the student who errored.

Object Data Elements

Any data elements not listed here are not sent with the Ed-Fi record in Indiana. Data elements in bold are part of the natural key.

Click here to expand...

Data Element Label	Business Rules	Mandatory (M), Conditional (C), or Optional (O)	Data Source Path Database Field
entryDate	Reports the Start Date. Does not report if the Local End Status is 000: SEOA Start. 000 statuses "join" enrollments together. For these joined enrollments, we will report the Start Date of the enrollment that does NOT have a Local Start Status of 000: SEOA Start.	M	Student Information > General > Enrollments > Start Date enrollment.startdate
calendarReference	Reports the fields that are part of the Natural Key for the Calendar resource. If the calendar the student is associated with (Calendar A) is mapped to a different calendar (Calendar B) using the Calendar Override Mapping Tool (found in Resource Preferences), report the information of the different calendar	O	N/A
classOfSchoolYear TypeReference	Reports the NCLB Cohort End Year.	O	Student Information > General > Graduation > NCLB Cohort End Year graduation.cohortYearNCLB
schoolReference	Reports the fields that are part of the Natural Key for the Schools resource. educationOrganizationId = 10 + State District Number + State School Number	M	District Information > State District Number School Information > State School Number District.number School.number
schoolYearType Reference	Reports the End Year of the associated calendar.	M	N/A
studentReference	Reports the fields that are part of the Natural Key for the Students resource.	M	N/A
entryGradeLevel Descriptor	Reports the Ed-Fi Code mapped to the value selected for Grade.	M	Enrollments > Grade enrollment.grade
exitWithdrawDate	Reports the End Date. Does not report if the Local End Status is 000: SEOA End. 000 statuses "join" enrollments together. For these joined enrollments, we will report the End Date of the enrollment that does NOT have a Local End Status of 000: SEOA End.	C	Enrollments > End Date enrollment.enddate
exitWithdrawType Descriptor	Reports the Ed-Fi Code mapped to the value selected for End Status.	C	Enrollments > End Status enrollment.endstatus
primarySchool	Reports True when Service Type is P: Primary. Reports False in all other situations.	M	Enrollments > Service Type enrollment.serviceType

Descriptors