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 records when the Calendar Exclude check box is checked in the calendar the student is enrolled. Does not send records when the School Exclude check box is checked in the calendar the student is enrolled. Does not send a record when 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 does not send.
Put	When an enrollment is updated for a student. 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 School Choice checkbox is checked or unchecked. When a student's Resident District or Service District fields are changed.
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 does not trigger a delete. When the start date of an enrollment is changed. When the No Show 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	When a resource is toggled to off after data has sent, all sent data remains in the ODS but no new data sends.
Put	When the natural key of the Calendar Reference is changed, a put is done to update the Calendar Reference even if 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 are 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

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 are 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 the enrollment is associated with.
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
Residency Status Descriptors	Enrollment State Aid

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	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. Reports the Enrollment Start Date.	M	Enrollments > Start Date Enrollment.startdate
calendarReference	A reference related to the Calendar resource. Reports the fields that are part of the Natural Key for the Calendar resource. The schoolID is the Reporting School. Calendar is currently not sending at this time.	O
schooReference	A reference to the related School resource. Reports the fields that are part of the Natural Key for the School resource. The schoolID is the Reporting School.	M	District ID + SchoolID
schoolYearTypeReference	The school year in which the student is being reported. Reports the fields that are part of the Natural Key for the School Year. The schoolYear is the end year of the calendar.	M
studentReference	A reference to the related Student resource. Reports the fields that are part of the Natural Key for the Student resource. The schoolID is the Student State ID.	M
entryGradeLevelDescriptor	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. Reports the Ed-Fi Code from the Grade Level mapping for the grade selected on the student's Enrollment. When a mapping is not available, the record errors.	M	Enrollments > Grade Enrollment.grade
entryTypeDescriptor	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 mapped to the Start Status selected. When blank, does not report.	O	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 (when known), the day on which an individual graduated, or the date on which it becomes known officially that an individual left school. NEDM: Exit/Withdraw Date. Reports the Enrollment End Date.	O	Enrollments > End Date Enrollment.endDate
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	Enrollments > End Status enrollment.endStatus
residencyStatusDescriptor	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. Reports the State Code from State Aid. When blank, reports as R1.	O	Enrollments > State Aid enrollment.stateAid
schoolChoiceDescriptor	Does not report.
ExtendedSchoolHours	Does not report.
FollowUpZip	Does not report.
HoursInSession	Does not report.
hsCareerEdDescriptor	Does not report.
InBuildingLessThanYearIndicator	Indicates whether any student who was not enrolled in the building the last Wednesday in September OR was not enrolled in the building during the MAP administration OR was not enrolled in the building at least half of the eligible days between the last Wednesday in September and the MAP administration. Considers all enrollments for the school year at same school as well as dual-enrolled students UNLESS: Grade Level flagged as Exclude from state reporting (Calendars > Grade Levels). Calendar flagged as Exclude (Calendar > Calendars). Student flagged as State Exclude (Enrollments > State Reporting Fields). Student flagged as No Show (Enrollments > General Enrollment Information). When the student is not enrolled on the MAP administration date set by the user in the Ed-Fi Configuration tool and/or not enrolled at least half of the eligible days between the last Wednesday in September and the MAP administration date set by the user in the Ed-Fi Configuration tool and/or no enrolled on the last Wednesday in September, Y reports. Otherwise, reports as N.	M	Enrollments > Start Date Enrollments.startDate
instructionMethodDescriptor	Does not report.
RegularHourrsAttended	Number of full-time and part-time hours the student spent in attendance at the attending district. Override: When there is already a value in the RegHrsAttended Field on Enrollments, that value report. When the value is calculated: Instructional Minutes sum minus absent minutes within school year start and end dates. Looks at student's entire schedule and sum each scheduled day's instructional minutes within school year start and end dates. Minus out absent minutes. Converts to hours for reporting. Period must be instructional. Course must be checked for Attendance. Period Absent and Excuse = Excused, Unknown or Unexcused. Compares the roster date to the term date. Looks for the maximum start date between the term and the roster start date whichever is the latest. For example, term date starts 9/1/08 and roster date starts 10/15/08 THEN start date should be 10/15/08 OR term date is 11/01/08 but roster start date is 8/15/08 THEN start date should be 11/01/08. Look for the minimum End Date of the Term Date and the Roster Date whichever comes first. Aggregates all the minutes attended for each term. Subtract absent minutes from sum of instructional minutes. Converts the minutes to hours and report. Must return 0 when the End Date and Start Date of the enrollment are both on the first day of the school year. Otherwise, must returns a value greater than 0 when the Grade Level is not PK. Virtual Course logic: Course or Section > Online Course is Yes. When multiple online courses are skinnied with other online courses, sums all minutes for online courses in the skinnied period (regular courses that are skinnied, only one courses is calculated). When online and regular courses are skinnied, all online course minutes/hours are calculated and one of the regular courses is summed. First, uses the current attendance calculation but excludes all course and sections marked Online as Yes, from the calculation. 94% Calculation: Once initial calculation is complete, looks for Transcript entries during that year marked Online is Yes. When a Transcript entry exists, looks for that course/section that the student was enrolled, calculate all hours of the course and add 94% of those hours to the first attendance calculation for Regular Hours Attended. 47% calculation: Now, looks for courses marked Online is Yes, when no transcript detail exists for the course, calculates all hours of the course/section and add 47% of those hours to the first attendance calculation for Regular Hours Attended. When student roster start date and end date are the same, (=) do NOT calculate hours. 95% Calculation: When Online Course > Program is 50: Missouri Virtual Instructional Program or 52: MOCAP, find students where State Reporting Fields > A+ Student = Y: Yes. Once initial calculation is complete, looks for Transcript entries during that year marked Online is Yes. When a Transcript entry exists, look for that course/section that the student was enrolled, calculates all hours of the course and add 95% of those hours to the first attendance calculation for Regular Hours Attended. 47% calculation: Now, looks for courses marked Online as Yes, when no transcript detail exists for the course, calculates all hours of the course/section and add 47% of those hours to the first attendance calculation for Regular Hours Attended. When student roster start date and end date are the same, (=) does NOT calculate hours. Regular hours attended cannot exceed Calendar Instructional minutes. Must report regular hours attended = calendar minutes when they exceed calendar instructional minutes, for the entire calculation. Hours are removed from the virtual records to cap at calendar instructional minutes as of current date. When multiple online courses are skinnied into a period, counts the full period for each course. Ex: 2 online courses skinnied into a period with 60 minutes, each course calculates the 60 minutes. Absent calculation is not done for online courses. Even if there is an absence for the period do not calculate minutes out. Just calculate all the hours and add to regular hours attended, either 94% of hours or 47% of hours depending on transcript detail entry. The regular hours absent field needs to change to not calculate absences in courses/sections marked Online. Competency Based Attendance Logic: Sums minutes of Course/Section checked Competency Based within school year dates. Multiplies by Prior year ADA% on District History (Sys Admin > Resources > District Info) record closest to current date but not greater than school year end date. Add sum to calculations above. Partial Week calc: our calculation uses sql datediff for weeks. This means that in this case, the week will be counted in term 3, but not in term 4. Datediff essentially count week transitions (think crossovers from saturday to sunday). A term with the dates: '01/07/2022', and '03/09/2022' counts weeks like this: SELECT CONVERT(DEC(7,1),DATEDIFF(WEEK, '01/07/2022', '03/09/2022')) = 9. A term with dates like this: '03/10/2022', and '05/25/2022' is like so: SELECT CONVERT(DEC(7,1),DATEDIFF(WEEK, '03/10/2022', '05/25/2022')) = 11.0	M	Enrollments > Regular Hours Attended Virtual Course Logic: Course or Section > Online Learning (Section acts as an override of Course, if they differ)
RegularHoursAbsent	Number of hours the student was absent at the attending district. Override: when there is already a value in the RegHrsAbsent Field on Enrollments, reports that value DOES NOT calculate. Status = Absent and Excuse = Excused, Unknown or Unexcused. Reports 0 when the End Date and Start Date of the enrollment are both on the first day of the school year. Reports as a whole number, but calculated in minutes and then converted to hours and rounded to the full hour.	M	Enrollments > Regular Hours Absent
RemedialHoursAttended	Does not report.
ReportComment	Does not report.
SummerAttendanceHours	Does not report.
SummerMembership	Does not report.
TeacherName	Reports Precode Teacher from the school year. When Precode Teacher is blank, then reports Homeroom Teacher from Course > Section > Teacher with Homeroom checkbox marked. The course must be: In the current school year. The most recently rostered section for which there is a Precode Teacher (Section Editor). When none of the above, then reports the school name.	O	Enrollments > State Reporting Fields > Precode Teacher Course > Section > Teacher School > School Detail > Name

Type/Descriptor

Click here to expand...

Grade Level Descriptors

Ed-Fi Code	Ed-Fi Short Description	Namespace	Ed-Fi Description
PK	Pre-Kindergarten	uri://dese.mo.gov/GradeLevelDescriptor	Pre-Kindergarten
PKA	Pre-Kindergarten AM	uri://dese.mo.gov/GradeLevelDescriptor	Pre-Kindergarten AM
PKP	Pre-Kindergarten PM	uri://dese.mo.gov/GradeLevelDescriptor	Pre-Kindergarten PM
K	Kindergarten	uri://dese.mo.gov/GradeLevelDescriptor	Kindergarten
KA	Kindergarten AM	uri://dese.mo.gov/GradeLevelDescriptor	Kindergarten AM
KP	Kindergarten PM	uri://dese.mo.gov/GradeLevelDescriptor	Kindergarten PM
1	First Grade	uri://dese.mo.gov/GradeLevelDescriptor	First Grade
2	Second Grade	uri://dese.mo.gov/GradeLevelDescriptor	Second Grade
3	Third Grade	uri://dese.mo.gov/GradeLevelDescriptor	Third Grade
4	Fourth Grade	uri://dese.mo.gov/GradeLevelDescriptor	Fourth Grade
5	Fifth Grade	uri://dese.mo.gov/GradeLevelDescriptor	Fifth Grade
6	Sixth Grade	uri://dese.mo.gov/GradeLevelDescriptor	Sixth Grade
7	Seventh Grade	uri://dese.mo.gov/GradeLevelDescriptor	Seventh Grade
8	Eighth Grade	uri://dese.mo.gov/GradeLevelDescriptor	Eighth Grade
9	Ninth Grade	uri://dese.mo.gov/GradeLevelDescriptor	Ninth Grade
10	Tenth Grade	uri://dese.mo.gov/GradeLevelDescriptor	Tenth Grade
11	Eleventh Grade	uri://dese.mo.gov/GradeLevelDescriptor	Eleventh Grade
12	Twelfth Grade	uri://dese.mo.gov/GradeLevelDescriptor	Twelfth Grade

Entry Type Descriptors

Ed-Fi Code	Ed-Fi Short Description	Namespace	Ed-Fi Description
E100	Initial Entry	uri://dese.mo.gov/EntryTypeDescriptor	Initial Entry
R101	Remained: Advanced	uri://dese.mo.gov/EntryTypeDescriptor	Remained: Advanced
R102	Remained: Retained	uri://dese.mo.gov/EntryTypeDescriptor	Remained: Retained
R103	Remained: Other	uri://dese.mo.gov/EntryTypeDescriptor	Remained: Other
R104	Remained: Changed Grade	uri://dese.mo.gov/EntryTypeDescriptor	Remained: Changed Grade
S100	StopOut: Entry	uri://dese.mo.gov/EntryTypeDescriptor	StopOut: Entry
S101	StopOut Suspension: Entry	uri://dese.mo.gov/EntryTypeDescriptor	StopOut Suspension: Entry
T100	Tfer In from Unknown	uri://dese.mo.gov/EntryTypeDescriptor	Tfer In from Unknown
T101	Tfer from pub schl outside district in state	uri://dese.mo.gov/EntryTypeDescriptor	Tfer from pub schl outside district in state
T102	Tfer from pub schl within district	uri://dese.mo.gov/EntryTypeDescriptor	Tfer from pub schl within district
T103	Tfer from home schl in state	uri://dese.mo.gov/EntryTypeDescriptor	Tfer from home schl in state
T104	Tfer from private schl in state	uri://dese.mo.gov/EntryTypeDescriptor	Tfer from private schl in state
T105	Tfer from pub schl out of state	uri://dese.mo.gov/EntryTypeDescriptor	Tfer from pub schl out of state
T106	Tfer from private schl out of state	uri://dese.mo.gov/EntryTypeDescriptor	Tfer from private schl out of state
T107	Tfer from home schl out of state	uri://dese.mo.gov/EntryTypeDescriptor	Tfer from home schl out of state
T108	Tfer from drop-out	uri://dese.mo.gov/EntryTypeDescriptor	Tfer from drop-out
T109	Tfer from another country	uri://dese.mo.gov/EntryTypeDescriptor	Tfer from another country

Exit Withdraw Type Descriptors

Ed-Fi Code	Ed-Fi Short Description	Namespace	Ed-Fi Description
D01	Dropped Out: Other	uri://dese.mo.gov/ExitWithdrawTypeDescriptor	Dropped Out: Other
D02	Dropped Out: Expulsion	uri://dese.mo.gov/ExitWithdrawTypeDescriptor	Dropped Out: Expulsion
D03	Dropped Out: Received Cert	uri://dese.mo.gov/ExitWithdrawTypeDescriptor	Dropped Out: Received Cert
D04	Dropped Out: Reached Max Age	uri://dese.mo.gov/ExitWithdrawTypeDescriptor	Dropped Out: Reached Max Age
D05	Dropped Out: GED Program	uri://dese.mo.gov/ExitWithdrawTypeDescriptor	Dropped Out: GED Program
D06	Dropped Out: Moved not known continuing	uri://dese.mo.gov/ExitWithdrawTypeDescriptor	Dropped Out: Moved not known continuing
G01	Graduated	uri://dese.mo.gov/ExitWithdrawTypeDescriptor	Graduated
G03	Graduated - Alternate Standards	uri://dese.mo.gov/ExitWithdrawTypeDescriptor	Graduated - Alternate Standards
R001	Remained: Advanced	uri://dese.mo.gov/ExitWithdrawTypeDescriptor	Remained: Advanced
R002	Remained: Retained	uri://dese.mo.gov/ExitWithdrawTypeDescriptor	Remained: Retained
R003	Remained: Other	uri://dese.mo.gov/ExitWithdrawTypeDescriptor	Remained: Other
R004	Remained: Changed Grade	uri://dese.mo.gov/ExitWithdrawTypeDescriptor	Remained: Changed Grade
S000	StopOut:Exit	uri://dese.mo.gov/ExitWithdrawTypeDescriptor	StopOut:Exit
S001	StopOut Suspension: Exit	uri://dese.mo.gov/ExitWithdrawTypeDescriptor	StopOut Suspension: Exit
T001	Tfer to pub schl outside district in state	uri://dese.mo.gov/ExitWithdrawTypeDescriptor	Tfer to pub schl outside district in state
T002	Tfer to pub schl within district	uri://dese.mo.gov/ExitWithdrawTypeDescriptor	Tfer to pub schl within district
T003	Tfer to home Schl in state	uri://dese.mo.gov/ExitWithdrawTypeDescriptor	Tfer to home Schl in state
T004	Tfer to private Schl in state	uri://dese.mo.gov/ExitWithdrawTypeDescriptor	Tfer to private Schl in state
T005	Tfer to pub schl out of state	uri://dese.mo.gov/ExitWithdrawTypeDescriptor	Tfer to pub schl out of state
T006	Tfer to private schl out of state	uri://dese.mo.gov/ExitWithdrawTypeDescriptor	Tfer to private schl out of state
T007	Tfer to home schl out of state	uri://dese.mo.gov/ExitWithdrawTypeDescriptor	Tfer to home schl out of state
T008	Tfer to another country	uri://dese.mo.gov/ExitWithdrawTypeDescriptor	Tfer to another country
T009	Deceased	uri://dese.mo.gov/ExitWithdrawTypeDescriptor	Deceased

Residency Status Descriptors

IC	Ed-Fi Code	Ed-Fi Short Description	Namespace	Ed-Fi Description
DI	Deseg-In	Deseg-In	uri://dese.mo.gov/ResidencyStatusDescriptor	Desegregation
FL	FedLands	FedLands	uri://dese.mo.gov/ResidencyStatusDescriptor	FedLands
NR	Non-Resident	Non-Resident	uri://dese.mo.gov/ResidencyStatusDescriptor	Non-Resident
PT	Parent Tuition	Parent Tuition	uri://dese.mo.gov/ResidencyStatusDescriptor	Parent Tuition
R1	Resident I	Resident I	uri://dese.mo.gov/ResidencyStatusDescriptor	Resident I
R2	Resident II	Resident II	uri://dese.mo.gov/ResidencyStatusDescriptor	Resident II

Student School Association (Missouri v3.6)