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 will report for each distinct enrollment in a School and Enrollment Start Date.
|
| Post | When the start date for an enrollment is changed.
|
| Put | An enrollment is updated for a student:
|
| Delete | When an enrollment is deleted.
|
| Delete | When the start date of an enrollment is changed.
|
| Delete | When 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 |
|---|---|
| None | If a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send. |
| Put | If 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'. |
| Resync | If 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. |
| Resync | If 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. |
| Resync | If 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:
|
| Delete | Cascading Deletes: If the Student School Association is deleted, all dependent resources will be deleted.
|
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 |
|---|---|
| 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 Labels in bold are part of the Natural Key and are required data elements for Data to send to Ed-Fi
| Data Element Label | Business Requirement | Business Rules | M, C or O | Location |
|---|---|---|---|---|
id | The unique identifier of the resource. | M | ||
| graduationPlanReference | A 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 | |
| classOfSchool YearTypeReference | The year the student is expected to graduate. |
| O | Student 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.
| M | |
| entryDate | The month, day, and year on which an individual enters and begins to receive instructional services in a campus. | Report the enrollment start date.
| M | Student Information > General > Enrollments > Start Date enrollment.startdate |
| entryGradeLevel 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. |
| M | Student 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. |
| O | Student 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:
| O | Student 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. |
| O | Student 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.
01, 02, 03, 05, 10, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 25, 26, 27, 28, 29, 30, 31, 33, 34, 35, 50 | C | Student 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. |
| C | Student 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. |
| O | Student Information > General > Enrollments enrollment.residentdistrict + enrollmentresidentSchool and / or enrollment.servingdistrict + enrollment.servingSchool |
| primarySchool | Indicates if a given enrollment record should be considered the primary record for a student. If omitted, the default is true. |
| O | Student 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 |
