Student Information > General > Personal CurriculumStudent Information > General > Personal Curriculum
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 will report for each distinct enrollment in a School and Enrollment Start Date.
|
| Post | When the start date for an enrollment is changed.
|
| Put | When 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 or State Exclude check box 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. |
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 |
| District Residency Status Descriptors | Enrollment Student Residency |
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 Requirement | Business Rules | M, C or O | Data Source GUI Path | Database Field |
|---|---|---|---|---|---|
id | The unique identifier of the resource. | 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 |
| calendarReference | A reference related to the Calendar resource. | Report the Calendar reference for the calendar in which the student is enrolled that is being reported. | O | ||
| classOfSchoolYear TypeReference | The year the student is expected to graduate. | Report the year selected in Student Info > General > Graduation > NCLB Cohort End Year.
| C | Student Information > General > Graduation > NCLB Cohort End Year. | |
| graduationPlan Reference | A reference to the related GraduationPlan resource. | This is optional, does not report. | O | ||
| school Reference | A reference to the related School resource. | Reports the fields that are part of the Natural Key for the School resource. | M | ||
| schoolYearType Reference | The school year in which the student is being reported. | Reports 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 | ||
| educationPlans | An unordered collection of studentSchoolAssociationEducationPlans. This association represents the school in which a student is enrolled. | This is optional, does not report. | O | ||
| employedWhile 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 | ||
| 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 | |
| entryGradeLevel Reason Descriptor | 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 | 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. |
| O | Student Information > General > Enrollments | enrollment. enddate |
| exitWithdrawType 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> 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. | This is optional, does not report. | O | Student Information> General> Enrollments> Service Type | enrollment. type |
| 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. | This is optional, does not report. | O | Student Information> General> Enrollments> End Action | enrollment. endAction |
| ResidencyStatus 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. | This is optional, does not report. | Student Information> General> Enrollments> | enrollment. resident district and/or enrollment. serving district | |
| 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. | This is optional, does not report. | O | Student Information> General> Enrollments> School Choice | enrollment. school Choice Program |
| districtEntryDate | The date the student was first enrolled in the District. |
| O | Student Information > General > Enrollments > State Reporting | enrollment. districtDate |
| districtResidency StatusDescriptor | Indicates the student's residency related to the geographic boundaries of the district and/or residency requirements outlined in the Pupil Residency section of the MDE Pupil Accounting Manual. | Reports the Ed-Fi Code from the Student Residency. | O | Student Information > Program Participation > State Programs > Student Residency | |
| districtResidency StatusAsOfDate | Indicates the date of the last change to district residency status. | Reports the Residency Start Date. If there is no Student Residency record, then report the Enrollment Start Date.
| O | Student Information > Program Participation > State Programs > Student Residency or Student Information > General > Enrollments > Start Date | |
| enrollment Percent | The pro rata share for which the student receives educational programs and/or services from the operating district. | Report FTE in General Education. | O | Student Information > General > Enrollments > State Reporting > FTE in General Education | |
| exitWithdrawDate AsOfDate | To support state reporting: captures when ExitWithdrawDate changed. | This is optional, does not report. | |||
| s2E2Education Organization Reference | Reference to the Local Education Agency. | Report reference to the Local Education Agency that matches S2E2 Code. | O | Student Information > General > Enrollments > State Reporting | enrollment. s2e2 |
| endOfTerm StatusDescriptor | The nature of the student’s progress at the end of a given school term. | If student has a 3rd Grade Reading Retention record with a Decision Date within the Scope Year, report End of Term Status. | O | Student Information > Program Participation > State Programs > Third Grade Retention | thirdGrade Retention. endStatus |
| promotion Reason Descriptor | The nature of the student’s promotion or progress at the end of the given school year. | If student has a 3rd Grade Reading Retention record with a Decision Date within the Scope Year, and End of Term Status = Promotion, report Promotion Reason. | O | Student Information > Program Participation > State Programs > Third Grade Retention | thirdGrade Retention. promotion Reason |
| etag | |||||
| bldgOtherwiseAttend SchoolReference | Report reference to the School that matches School Override | Student Information > General > Enrollments > State Reporting | |||
| personalCurriculums | Reports if Personal Curriculum subject droplist is = NOT NULL | Student Information > General > Personal Curriculum | |||
| earlyReadingIntervention | Reports if student has an Early Reading Deficiency record within the identified Scope Year
| Student Information > Program Participation > State Programs > Early Reading Deficiency | |||
| bldgOtherwiseAttend | Reports Building Otherwise Attend | Student Information > General > Enrollments > State Reporting | Enrollment.facilityCode | ||
| tuitionFundedEnrollment | (MI EXT) NULL or 0 = No, 1 = Yes, Indicates if a charge or fee is required to be paid by the student's family to attend the public school. |
| Student Information > General > Enrollments > State Reporting |
Arrays
