Wisconsin Ed-Fi Data v3.1 - Student School Association

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. When a student has two enrollments in the same School, Calendar & 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 an enrollment with a higher priority is deleted, the enrollment with lower priority will post a new record. Do not send a student record for an enrollment that is marked as State Exclude, No Show, or WISE Exclude. Do not send a record if enrollment is in a calendar marked as State Exclude, Summer School, or in a School marked Exclude. If Ed-Fi Configuration Profile = Choice + Opt in report a record for all eligible students if Choice = Yes or No on the student's enrollment. If Ed-Fi Configuration Profile = Choice AND Choice = No on Student enrollment, do not report a record.
Post	When the start date for an enrollment is changed. When an enrollment with a lower priority is changed, data will not send.
Put	When an enrollment is updated for a student. When State Enrollment Type is updated for a student. When a change is made to the Graduation > NCLB Cohort End Year field. When a student is assigned to a Graduation or CTE Program or the start and/or end dates are modified. 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 End Action 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. When a students 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.
Delete	When the State Exclude, No Show, or WISE 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: If the School ID changes, all data will remain under the old number and a resync will need to be completed to populate data under the new number. The delete tool would need to be used to remove all data from the old School ID. 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

Action

Business Rule

Post/Delete

Natural Key changes:

If the School ID changes, all data will remain under the old number and a resync will need to be completed to populate data under the new number. The delete tool would need to be used to remove all data from the old School ID. 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
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
classOfSchool YearTypeReference	The year the student is expected to graduate.	This is optional, does not report.	O
graduationPlan Reference	A reference to the related GraduationPlan resource.	This is optional, does not report.	O
schoolReference	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 the student is being reported in.	This is optional, does not report.	O
studentReference	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
entryGrade LevelDescriptor	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.	Report the Ed-Fi Code from the Grade Level mapping for the grade selected on the student's enrollment. If a mapping is not available, the record will error.	M	Student Information> General> Enrollments> Grade
entryGradeLevel ReasonDescriptor	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.	Report the Ed-Fi Code Value mapped to the Start Status selected. If blank, do not report.	O	Student Information> General> Enrollments> Start Status	enrollment. startstatus
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.	O	Student Information> General> Enrollments> End Date	enrollment. enddate
exitWithdraw TypeDescriptor	A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.	Report the Ed-Fi Code Value from the End Status selected. If blank, do not report.	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.	Report 'True' if State Enrollment Type = P "Primary". Otherwise, if Service Type = P: Primary. Else, report 'False'.	M	Student Information> General> Enrollments> State Enrollment Type Student Information> General> Enrollments> Service Type	enrollmentWI.localServiceType 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.	Do not report for students Enrolled in a School with Ed-Fi Reporting Option of Choice ONLY or Choice + Private Opt In. If students are enrolled in a school with Ed-Fi Reporting Option = Public. If State Enrollment Type = Primary. AND If the End Action = Retain on the Enrollment determining reporting, report TRUE. Otherwise, report FALSE. If State Enrollment Type is NOT Primary, do not report.	O	Student Information > General > Enrollment > 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.	O
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
studentSchool AssociationExtensions (actualDaysAttendance)	Aggregate value that captures the actual days in attendance for a student.	See actualDaysAttendance in the Appendix below for reporting logic.	O	Student Information > General > Enrollment > Attendance Override OR Calculated from: System Administration > Calendar > Calendar > Grade Level > Standard Day System Administration > Calendar > Calendar > Days System Administration > Calendar > Calendar > Periods Student Information > General > Schedule Student Information > General > Attendance
studentSchool AssociationExtensions (possibleDays Attendance)	Aggregate value that capture the possible days in attendance for a student.	See possibleDaysAttendance in the Appendix below for reporting logic.	O	Student Information > General > Enrollment > Membership Override OR Calculated from: Student Information > General > Schedule System Administration > Calendar > Calendar > Grade Level > Standard Day System Administration > Calendar > Calendar > Days System Administration > Calendar > Calendar > Periods
studentSchool AssociationExtensions (Wi_student SchoolAssociation ReceivingService)	An unordered collection of student School Association Wisconsin Ext Receiving Services.	See Receiving Services in the Array section below for reporting logic.	O
studentSchool AssociationExtensions (completedSchoolTerm)	Indicates whether or not a student completed the school term during the school enrollment period. It is collected for every student enrollment record and is not related to graduation. A student could have more than one enrollment record for a school year.	For the enrollment that determines the entry date. If State Enrollment Type is NOT = Primary, do not report. Otherwise, if State Enrollment Type = Primary, continue to calculate. If the enrollment is ended prior to the last day of the school year. AND end Status = HSC: High School Completion, report TRUE. AND end status is any other status, report FALSE. If the current date is after the last day of the school year. AND the enrollment end date is on or after (= >) the last day of the school year, report TRUE. AND if the enrollment end date is blank, report TRUE. Otherwise, report FALSE.	O	Student Information > General > Enrollment > End Date
studentSchool AssociationExtensions (expectedTransferLocal EducationAgency Reference)	A reference to the related EducationOrganization resource.	If State Enrollment Type is NOT = Primary, do not report. Otherwise, if State Enrollment Type = Primary, continue to calculate. If Transfer District field is not Null on the most recent enrollment in the school, report the code value of the Transfer District. Otherwise, report blank.	O	Student Information > General > Enrollment > Transfer District	enrollmentWI. transferDistrict
studentSchool AssociationExtensions (expectedTransfer SchoolReference)	A reference to the related School resource.	If State Enrollment Type is NOT = Primary, do not report. Otherwise, if State Enrollment Type = Primary, continue to calculate. If Ed-Fi Transfer School ID is not Null on the most recent enrollment in the school, report the value entered in the field. Otherwise, report blank.	O	Student Information > General > Enrollment > Ed-Fi Transfer School ID	enrollmentWI. edfiTransfer School
studentSchool AssociationExtensions (privateSchoolChoice ProgramParticipant)	Indicates whether a student is a choice student or not.	Report from the Enrollment generating the record. If the enrollment generating the record is in a school where Ed-Fi School Population is marked Choice or Choice + Private Opt in. If Choice student = Y: Yes, report TRUE. Otherwise, report FALSE.	O	Student Information > General > Enrollment > Choice Student	enrollmentWI. choiceStudent
studentSchool AssociationExtensions (parentPlacedPrivate)		f State Enrollment Type is = Parent Placed Private, report TRUE. Otherwise, report FALSE.	O	Student Information > General > Enrollment > State Enrollment Type
etag

Arrays

Click here to expand...

Receiving Services

Data Element Label	Business Requirement	M, C or O	Data Source GUI Path	Database Field
countDateNameType	Report only for the StudentSchoolAssociationWiExt record reporting Attendance. Report in the record that is active and of the highest order on the Count Date. Only report if State Enrollment type = Primary. For all other StudentSchoolAssociationWiExt records, do not add values to the array. If the date is on or after the third Friday in September add the Ed Fi value from the Count Date Name Type for 3rd Friday in September to the array if the student meets the following criteria. The enrollment determining the record is in a calendar in a school where Ed-Fi School Population = Public. And the student's enrollment is active on the third Friday in September (not JUST the effective date for determining attendance, the physical #3 Friday in September on the real calendar). And the student enrollment corresponding to the record has Parent Placement Pri. School = No or blank/ NULL. OR The enrollment determing the record is in a calendar in a school where Ed-Fi School Population = Choice OR Choice + Private Opt In. And the student's enrollment is active on the third Friday in September (not JUST the effective date for determining attendance, the physical #3 Friday in September on the real calendar) Otherwise, do not add values to the array. If the date is on after October 1st. Add the Ed Fi value from the Count Date Name Type for October 1st to the array If the student meets all of the following criteria: the enrollment determining the record is in a calendar in a school where Ed-Fi School Population = Public. the student's enrollment is active on October 1st (10/01/XX). Otherwise, do not add values to the array.	O
countDateReceivingServiceType	Report only for the StudentSchoolAssociationWiExt record reporting Attendance. Report in the record that is active and of the highest order on the Count Date. Only report if State Enrollment type = Primary. For all other StudentSchoolAssociationWiExt records, do not add values to the array. If the date is on or after the third Friday in September. If the third Friday in September is an Instructional, School, Attendance day; use that date for the calculation. Otherwise, use the closest Instructional, School, Attendance day PRIOR to the third Friday in September. Determine if the student is reportable. If the student is not enrolled on that date, do not add to the array. If the enrollment determining the record is in a calendar in a school where Ed-Fi School Population = Public AND the student's enrollment sending the record is marked Parent Placed Pri. = Yes, do NOT add to the array. Determine the student's attendance status for that date. Report first from the 3rd Friday Count Date Override field; If not NULL, add the Ed-fi value for the value saved in the field to the array. Otherwise, if the 3rd Friday Count Date Override field is blank, If the student does not have a schedule in the enrollment calendar or their schedule was ended prior to the count date in all calendars, report 'A' and add the value for count Date Receiving Service Type to the array. If the student has a schedule in the calendar, but their schedule does not meet on the count date, use the closest Instructional, School, Attendance day PRIOR to the count date where the student’s schedule meets. If the student has a schedule and has no attendance marks, report 'P' and add the value for count Date Receiving Service Type to the array. If the student has a "regular" schedule and has attendance marks of Absent Excused or Absent Unexcused, calculate the total number of minutes present for the student ( If a student's enrollment determining the record has Percent Enrolled of 51 -100, or NULL the student is considered a Full Schedule student). If the student is present 33% of their schedule minutes or more minutes, add 'P' and add the value for count Date Receiving Service Type to the array. Otherwise, if the student has less than 33% minutes present but at least 1 minute or of Attendance on the count date, report 'A' and add the value for count Date Receiving Service Type to the array. If the student has a "partial" schedule and has attendance marks of Absent Excused or Absent Unexcused, calculate the total number of minutes present for the student (If a student's enrollment determining the record has Percent Enrolled of 50 or less the student is considered a Partially Scheduled student ). If the student is present 1 or more minutes, add 'P' and add the value for count Date Receiving Service Type to the array. If the student is absent (with 0 minutes Present) on the Count Date, check the student's previous attendance in the current calendar. If the student has 0 minutes of present attendance on all prior days in the calendar, report 'A' and add the value to the array. If the student has at least 1 minute of present attendance on any date prior to the Count Date. If the the current date = the Count Date, report 'A' and add the value to the array. If the current date is AFTER the count date, if the student has at least 1 minute present attendance on any date after the Count date, report 'A'. If the date is on or after October 1st. If the 10/1 is an Instructional school attendance date, use that date for the calculation. Otherwise, use the closest Instructional school attendance day PRIOR to 10/1 for attendance calculation only. Determine if the student is reportable: If the enrollment determining the record is in a calendar in a school where Ed-Fi School Population is marked Choice or Choice + Private Opt In, do not add a value to the array . If the Student does not have a locked IEP or ISP that overlaps the enrollment reporting. Or if the locked Plan and has Special Ed Status = No, do not add a value to the array. If the Student has a locked IEP that overlaps Oct 1 BUT has a SPED exit date before Oct 1, do not add to the array. Otherwise, continue the calculation to determine their status. Determine the student's attendance status for that date. If the student is not enrolled on Oct 1, do not add to the array. Report first from the Oct. 1 Count Date Override field; If not NULL, add the Ed-fi value for the value saved in the field to the array. Otherwise, if the Oct. 1 Count Date Override field is blank, determine if the student is Parentally Place Private. If the student's enrollment sending the record is marked Parent Placed Pri. = Yes, report 'P' and add that value for the count Date Receiving Service Type to the array. Otherwise, use their schedule to determine the value to report. If the student does not have a schedule in the enrollment calendar. OR their schedule was ended prior to the count date in all calendars. OR their schedule starts after the count date. THEN report 'A' and add the value for count Date Receiving Service Type to the array. If the student has a schedule in the calendar, but their schedule does not meet on the count date, use the closest Instructional, School, Attendance day PRIOR to the count date where the student’s schedule meets. If the student has a schedule and has no attendance marks, report 'P' and add the value for count Date Receiving Service Type to the array. If the student has a "regular" schedule and has attendance marks of Absent Excused or Absent Unexcused, calculate the total number of minutes present for the student ( If a student's enrollment determining the record has Percent Enrolled of 51 -100, or NULL the student is considered a Full Schedule student). If the student is present 33% of their schedule minutes or more minutes, add 'P' and add the value for count Date Receiving Service Type to the array. Otherwise, if the student has less than 33% minutes present but at least 1 minute or of Attendance on the count date, report 'A' and add the value for count Date Receiving Service Type to the array. If the student has a "partial" schedule and has attendance marks of Absent Excused or Absent Unexcused, calculate the total number of minutes present for the student (If a student's enrollment determining the record has Percent Enrolled of 50 or less the student is considered a Partially Scheduled student). If the student is present 1 or more minutes, add 'P' and add the value for count Date Receiving Service Type to the array. If the student is absent (with 0 minutes Present) on the Count Date, check the student's previous attendance in the current calendar. If the student has 0 minutes of present attendance on all prior days in the calendar, report 'A' and add the value to the array. If the student has at least 1 minute of present attendance on any date prior to the Count Date. If the the current date = the Count Date, report 'A' and add the value to the array. If the current date is AFTER the c.resent attendance on any date after the Count date, report 'A'.	O

Data Element Label

Business Requirement

M, C or O

Data Source GUI Path

Database Field

countDateNameType

Report only for the StudentSchoolAssociationWiExt record reporting Attendance.
- Report in the record that is active and of the highest order on the Count Date.
- Only report if State Enrollment type = Primary.
- For all other StudentSchoolAssociationWiExt records, do not add values to the array.
If the date is on or after the third Friday in September add the Ed Fi value from the Count Date Name Type for 3rd Friday in September to the array if the student meets the following criteria.
- The enrollment determining the record is in a calendar in a school where Ed-Fi School Population = Public.
  - And the student's enrollment is active on the third Friday in September (not JUST the effective date for determining attendance, the physical #3 Friday in September on the real calendar).
  - And the student enrollment corresponding to the record has Parent Placement Pri. School = No or blank/ NULL.

The enrollment determing the record is in a calendar in a school where Ed-Fi School Population = Choice OR Choice + Private Opt In.
And the student's enrollment is active on the third Friday in September (not JUST the effective date for determining attendance, the physical #3 Friday in September on the real calendar)
Otherwise, do not add values to the array.

If the date is on after October 1st.
- Add the Ed Fi value from the Count Date Name Type for October 1st to the array If the student meets all of the following criteria:
  - the enrollment determining the record is in a calendar in a school where Ed-Fi School Population = Public.
  - the student's enrollment is active on October 1st (10/01/XX).
- Otherwise, do not add values to the array.

countDateReceivingServiceType

Report only for the StudentSchoolAssociationWiExt record reporting Attendance.
- Report in the record that is active and of the highest order on the Count Date.
- Only report if State Enrollment type = Primary.
- For all other StudentSchoolAssociationWiExt records, do not add values to the array.
If the date is on or after the third Friday in September.
- If the third Friday in September is an Instructional, School, Attendance day; use that date for the calculation.
- Otherwise, use the closest Instructional, School, Attendance day PRIOR to the third Friday in September.
Determine if the student is reportable.
- If the student is not enrolled on that date, do not add to the array.
- If the enrollment determining the record is in a calendar in a school where Ed-Fi School Population = Public AND the student's enrollment sending the record is marked Parent Placed Pri. = Yes, do NOT add to the array.
Determine the student's attendance status for that date.
- Report first from the 3rd Friday Count Date Override field;
  - If not NULL, add the Ed-fi value for the value saved in the field to the array.
- Otherwise, if the 3rd Friday Count Date Override field is blank,
- If the student does not have a schedule in the enrollment calendar or their schedule was ended prior to the count date in all calendars, report 'A' and add the value for count Date Receiving Service Type to the array.
- If the student has a schedule in the calendar, but their schedule does not meet on the count date, use the closest Instructional, School, Attendance day PRIOR to the count date where the student’s schedule meets.
- If the student has a schedule and has no attendance marks, report 'P' and add the value for count Date Receiving Service Type to the array.
- If the student has a "regular" schedule and has attendance marks of Absent Excused or Absent Unexcused, calculate the total number of minutes present for the student ( If a student's enrollment determining the record has Percent Enrolled of 51 -100, or NULL the student is considered a Full Schedule student).
  - If the student is present 33% of their schedule minutes or more minutes, add 'P' and add the value for count Date Receiving Service Type to the array.
  - Otherwise, if the student has less than 33% minutes present but at least 1 minute or of Attendance on the count date, report 'A' and add the value for count Date Receiving Service Type to the array.
- If the student has a "partial" schedule and has attendance marks of Absent Excused or Absent Unexcused, calculate the total number of minutes present for the student (If a student's enrollment determining the record has Percent Enrolled of 50 or less the student is considered a Partially Scheduled student ).
  - If the student is present 1 or more minutes, add 'P' and add the value for count Date Receiving Service Type to the array.
- If the student is absent (with 0 minutes Present) on the Count Date, check the student's previous attendance in the current calendar.
  - If the student has 0 minutes of present attendance on all prior days in the calendar, report 'A' and add the value to the array.
  - If the student has at least 1 minute of present attendance on any date prior to the Count Date.
    - If the the current date = the Count Date, report 'A' and add the value to the array.
    - If the current date is AFTER the count date, if the student has at least 1 minute present attendance on any date after the Count date, report 'A'.
If the date is on or after October 1st.
- If the 10/1 is an Instructional school attendance date, use that date for the calculation.
- Otherwise, use the closest Instructional school attendance day PRIOR to 10/1 for attendance calculation only.
Determine if the student is reportable:
- If the enrollment determining the record is in a calendar in a school where Ed-Fi School Population is marked Choice or Choice + Private Opt In, do not add a value to the array .
- If the Student does not have a locked IEP or ISP that overlaps the enrollment reporting.
  - Or if the locked Plan and has Special Ed Status = No, do not add a value to the array.
- If the Student has a locked IEP that overlaps Oct 1 BUT has a SPED exit date before Oct 1, do not add to the array.
- Otherwise, continue the calculation to determine their status.
Determine the student's attendance status for that date.
- If the student is not enrolled on Oct 1, do not add to the array.
- Report first from the Oct. 1 Count Date Override field;
  - If not NULL, add the Ed-fi value for the value saved in the field to the array.
- Otherwise, if the Oct. 1 Count Date Override field is blank, determine if the student is Parentally Place Private.
- If the student's enrollment sending the record is marked Parent Placed Pri. = Yes, report 'P' and add that value for the count Date Receiving Service Type to the array.
- Otherwise, use their schedule to determine the value to report.
- If the student does not have a schedule in the enrollment calendar.
  - OR their schedule was ended prior to the count date in all calendars.
  - OR their schedule starts after the count date.
  - THEN report 'A' and add the value for count Date Receiving Service Type to the array.
- If the student has a schedule in the calendar, but their schedule does not meet on the count date, use the closest Instructional, School, Attendance day PRIOR to the count date where the student’s schedule meets.
- If the student has a schedule and has no attendance marks, report 'P' and add the value for count Date Receiving Service Type to the array.
- If the student has a "regular" schedule and has attendance marks of Absent Excused or Absent Unexcused, calculate the total number of minutes present for the student ( If a student's enrollment determining the record has Percent Enrolled of 51 -100, or NULL the student is considered a Full Schedule student).
  - If the student is present 33% of their schedule minutes or more minutes, add 'P' and add the value for count Date Receiving Service Type to the array.
  - Otherwise, if the student has less than 33% minutes present but at least 1 minute or of Attendance on the count date, report 'A' and add the value for count Date Receiving Service Type to the array.
- If the student has a "partial" schedule and has attendance marks of Absent Excused or Absent Unexcused, calculate the total number of minutes present for the student (If a student's enrollment determining the record has Percent Enrolled of 50 or less the student is considered a Partially Scheduled student).
  - If the student is present 1 or more minutes, add 'P' and add the value for count Date Receiving Service Type to the array.
- If the student is absent (with 0 minutes Present) on the Count Date, check the student's previous attendance in the current calendar.
  - If the student has 0 minutes of present attendance on all prior days in the calendar, report 'A' and add the value to the array.
  - If the student has at least 1 minute of present attendance on any date prior to the Count Date.
    - If the the current date = the Count Date, report 'A' and add the value to the array.
    - If the current date is AFTER the c.resent attendance on any date after the Count date, report 'A'.

Appendices

Click here to expand...

Appendix A: Object Triggering with Multiple Enrollments

Reference	Description	Logic/ Conditions	Visualization(s)/ Results
1	Deleting enrollments when there are multiple concurrent enrollments	A Primary (P) and Special Ed (N) enrollment exist and an Ed-fi record posts with Attendance data. The Primary (P) enrollment is deleted. The Special Ed (N) enrollment is not changed or edited in any way.	Expected Results: The StudentSchoolAssociationWIExt record with the start date of the Primary Enrollment is deleted when the Primary enrollment is deleted. A new StudentSchoolAssociationWIExt record is created and attendance is recalculated based on only the remaining existing Partial enrollment.

Reference

Description

Logic/ Conditions

Visualization(s)/ Results

Deleting enrollments when there are multiple concurrent enrollments

A Primary (P) and Special Ed (N) enrollment exist and an Ed-fi record posts with Attendance data.
The Primary (P) enrollment is deleted.
The Special Ed (N) enrollment is not changed or edited in any way.

Expected Results:

The StudentSchoolAssociationWIExt record with the start date of the Primary Enrollment is deleted when the Primary enrollment is deleted.

A new StudentSchoolAssociationWIExt record is created and attendance is recalculated based on only the remaining existing Partial enrollment.

Appendix B: Attendance Calculations

Data Element	Logic
actualDaysAttendance	Report this element for only one (1) active record per school based on the highest order of enrollments. Only report for enrollments where State Enrollment type is Primary. Report blank for all other records. If there are multiple enrollments and the determining enrollment is ended, report in the next most recent by start date. Report an aggregate from all enrollments in the school the have the same start date. Report first from the Attendance Override field on Enrollment if entered on any of the enrollments fitting the requirements. Otherwise, if Membership Override is NULL/ blank on all reporting Enrollments, continue on to the calculation. Report using the calculation based on the Grade Level, Standard Day setting for the reporting enrollment's grade (System Administration > Calendar > Calendar > Grade Level > Standard Day). If a student's enrollment determining the record has a grade level where the standard day is 0.5, the student is considered a Partially Scheduled student and the Partially Scheduled Students calculation should be used to determine their Attendance. If the Grade Level does NOT have a Standard day of 0.5, determine which calculation to use based on the student's Percent Enrolled. Report using calculation based on the student's Percent Enrolled: If a student's enrollment determining the record has Percent Enrolled of 51 -100 or NULL, the student is considered a Full Schedule student. If a student's enrollment determining the record has Percent Enrolled of 50 or less, the student is considered a Partially Scheduled student. Full Schedule Students calculation For each day that meets the following where the student has a schedule: Instructional, attendance, school date are checked. Day event is NOT 99: Health Emergency. If the student meets the above and has no attendance marks, add 1 to actual days of attendance for that date. If the student meets the above has attendance marks of Absent Excused or Absent Unexcused, calculate the total number of scheduled minutes for the student and the total minutes present for the student on that day. If the student's present minutes are 66% or more of the calculated minutes scheduled, add 1 to the actual days of attendance for that date. If the student's present minutes are 33% or more but less than 66% time present, add a half day (0.5) to the actual days of attendance for that date. If the student less than 33% time present, do not add any days (0) to the actual days of attendance for that date. Partially Scheduled Students calculation For each day that meets the following where the student has a schedule: Instructional, Attendance, School Date are checked. Day event is NOT 99: Health Emergency. If the student has no attendance marks, add 0.5 to actual days of attendance for that date. If the student has attendance marks of Absent Excused or Absent Unexcused but is present 1 or more minutes, add 0.5 to actual days of attendance for that date. If the student has attendance marks of Absent Excused or Absent Unexcused for the entire day with 0 minutes present, do not add any days (0) to the actual days of attendance for that date. 9. Report the total of all actual days of attendance from the beginning of the enrollment to the current date.
possibleDaysAttendance	Report this element for only one (1) active record per school based on the highest order of enrollments. Only report for enrollments were State Enrollment Type is Primary. Report blank for all other records. If there are multiple enrollments and the determining enrollment is ended, report in the next most recent by start date. Report an aggregate from all enrollments in the school the have the same start date. Report first from the Membership Override field on Enrollment if entered on any of the enrollments fitting the requirements. Otherwise if Membership Override is NULL/ blank on all reporting Enrollments, continue on to the calculation. Report using calculation based on the Grade Level, Standard Day setting for the reporting enrollment's grade (System Administration > Calendar > Calendar > Grade Level > Standard Day). If a student's enrollment determining the record has a grade level where Standard day is 0.5, the student is considered a Partially Scheduled student and the Partially Scheduled Students calculation should be used to determine their Attendance. If the Grade Level does not have a Standard day of 0.5, determine which calculation to use based on the student's Percent Enrolled. Report using calculation based on the student's Percent Enrolled: If a student's enrollment determining the record has Percent Enrolled of 51 -100, or NULL the student is considered a Full Schedule student. If a student's enrollment determining the record has Percent Enrolled of 50 or less the student is considered a Partially Scheduled student. Full Schedule Students calculation For each enrollment included in the record calculation from the enrollment start date to the current date, count the unique days of enrollment in each calendar for the days marked Instruction, School, and Attendance and the Day Event is not 99: Health Emergency. If the student is not scheduled on that date, do not add any possible days of attendance for that date. If the student is scheduled into Attendance taking courses, add 1 to the possible days of attendance. Partially Scheduled Students calculation For each enrollment included in the record calculation from the enrollment start date to the current date, count the unique days of enrollment in each calendar for the days marked Instruction, School, and Attendance and the Day Event is not 99: Health Emergency. If the student is not scheduled on that date, do not add any possible days of attendance for that date. If the student is scheduled into Attendance taking courses, add 0.5 to the possible days of attendance. Report the total of all possible days of attendance from the beginning of the enrollment to the current date.

Data Element

Logic

actualDaysAttendance

Report this element for only one (1) active record per school based on the highest order of enrollments.
- Only report for enrollments where State Enrollment type is Primary.
- Report blank for all other records.
- If there are multiple enrollments and the determining enrollment is ended, report in the next most recent by start date.
Report an aggregate from all enrollments in the school the have the same start date.
Report first from the Attendance Override field on Enrollment if entered on any of the enrollments fitting the requirements.
Otherwise, if Membership Override is NULL/ blank on all reporting Enrollments, continue on to the calculation.
Report using the calculation based on the Grade Level, Standard Day setting for the reporting enrollment's grade (System Administration > Calendar > Calendar > Grade Level > Standard Day).
- If a student's enrollment determining the record has a grade level where the standard day is 0.5, the student is considered a Partially Scheduled student and the Partially Scheduled Students calculation should be used to determine their Attendance.
- If the Grade Level does NOT have a Standard day of 0.5, determine which calculation to use based on the student's Percent Enrolled.
Report using calculation based on the student's Percent Enrolled:
- If a student's enrollment determining the record has Percent Enrolled of 51 -100 or NULL, the student is considered a Full Schedule student.
- If a student's enrollment determining the record has Percent Enrolled of 50 or less, the student is considered a Partially Scheduled student.
Full Schedule Students calculation
- For each day that meets the following where the student has a schedule:
  - Instructional, attendance, school date are checked.
  - Day event is NOT 99: Health Emergency.
- If the student meets the above and has no attendance marks, add 1 to actual days of attendance for that date.
- If the student meets the above has attendance marks of Absent Excused or Absent Unexcused, calculate the total number of scheduled minutes for the student and the total minutes present for the student on that day.
  - If the student's present minutes are 66% or more of the calculated minutes scheduled, add 1 to the actual days of attendance for that date.
  - If the student's present minutes are 33% or more but less than 66% time present, add a half day (0.5) to the actual days of attendance for that date.
  - If the student less than 33% time present, do not add any days (0) to the actual days of attendance for that date.
Partially Scheduled Students calculation
- For each day that meets the following where the student has a schedule:
  - Instructional, Attendance, School Date are checked.
  - Day event is NOT 99: Health Emergency.
- If the student has no attendance marks, add 0.5 to actual days of attendance for that date.
- If the student has attendance marks of Absent Excused or Absent Unexcused but is present 1 or more minutes, add 0.5 to actual days of attendance for that date.
- If the student has attendance marks of Absent Excused or Absent Unexcused for the entire day with 0 minutes present, do not add any days (0) to the actual days of attendance for that date.

9. Report the total of all actual days of attendance from the beginning of the enrollment to the current date.

possibleDaysAttendance

Report this element for only one (1) active record per school based on the highest order of enrollments.
- Only report for enrollments were State Enrollment Type is Primary.
- Report blank for all other records.
- If there are multiple enrollments and the determining enrollment is ended, report in the next most recent by start date.
Report an aggregate from all enrollments in the school the have the same start date.
Report first from the Membership Override field on Enrollment if entered on any of the enrollments fitting the requirements.
Otherwise if Membership Override is NULL/ blank on all reporting Enrollments, continue on to the calculation.
Report using calculation based on the Grade Level, Standard Day setting for the reporting enrollment's grade (System Administration > Calendar > Calendar > Grade Level > Standard Day).
- If a student's enrollment determining the record has a grade level where Standard day is 0.5, the student is considered a Partially Scheduled student and the Partially Scheduled Students calculation should be used to determine their Attendance.
- If the Grade Level does not have a Standard day of 0.5, determine which calculation to use based on the student's Percent Enrolled.
Report using calculation based on the student's Percent Enrolled:
- If a student's enrollment determining the record has Percent Enrolled of 51 -100, or NULL the student is considered a Full Schedule student.
- If a student's enrollment determining the record has Percent Enrolled of 50 or less the student is considered a Partially Scheduled student.
Full Schedule Students calculation
- For each enrollment included in the record calculation from the enrollment start date to the current date, count the unique days of enrollment in each calendar for the days marked Instruction, School, and Attendance and the Day Event is not 99: Health Emergency.
  - If the student is not scheduled on that date, do not add any possible days of attendance for that date.
  - If the student is scheduled into Attendance taking courses, add 1 to the possible days of attendance.
Partially Scheduled Students calculation
- For each enrollment included in the record calculation from the enrollment start date to the current date, count the unique days of enrollment in each calendar for the days marked Instruction, School, and Attendance and the Day Event is not 99: Health Emergency.
  - If the student is not scheduled on that date, do not add any possible days of attendance for that date.
  - If the student is scheduled into Attendance taking courses, add 0.5 to the possible days of attendance.
Report the total of all possible days of attendance from the beginning of the enrollment to the current date.

Type/Descriptor

Click here to expand...

Enrollment Type

Code	Description
Primary	Enrollment at the school that most directly supervises the PK-12 educational services.
ParentPlacedPrivate	Non-primary enrollment in a public school providing special education services. If the private school providing primary education services is a Choice school, that school submits the student's enrollment as Primary.
Coursework	Non-primary enrollment for students taking courses at a school that is not their primary school.

countDateNameType

Ed-Fi Code Value	Ed-Fi Short Description	Ed-Fi Description
3FS	3rd Friday of September	3rd Fri Sept
O1	October 1st	Oct 1st

countDateReceivingServiceType

Ed-Fi Code Value	Ed-Fi Short Description	Ed-Fi Description
P	Present, receiving services on the count date	Present
A	Absent, receiving services on the count date	Absent
N	Not receiving services	Not Receiving Services

Entry Type Descriptors

Code Value	Description	Short Description
Transfer	Transfer	Transfer
New to education system	New to education system	New to education system
Next year school	Next year school	Next year school
Other	Other	Other
Re-entry	Re-entry	Re-entry

Exit Withdraw Type Descriptors

Code Value	Short Description	Ed-Fi Description
BCA	Below Compulsory Age	Below Compulsory Age
INM	International move	International move. Not known to be continuing.
ISM	Interstate move. Move to another state within the country.	Interstate move. Move to another state within the country. Not known to be continuing.
PCC	Prior Completion Credential	Prior Completion Credential
TC	Continuing in Current School	Continuing in Current School
TC	Transfer to Another WI School	Transfer to Another WI School. Known to be continuing.
TNC	Transfer to a school not covered by WSLS	Transfer to a school not covered by WSLS. Known to be continuing.
TOS	Transfer out-of-state	Transfer out-of-state. Known to be continuing.
ETC	Expected transfer to another school covered by WSLS	Expected Transfer to Another School Covered WSLS; Not known to be continuing.
HSC	High School Completion	High School Completion
DE	Death	Death
MA	Reached Maximum Age for Services	Reached Maximum Age for Services
ODO	Other dropout or possible dropout	Other dropout or possible dropout

Wisconsin Ed-Fi Data v3.1 - Student School Association

Object Triggering Logic

Resource Toggle and Resync Logic

Natural Key Changes, Cascading Updates, and Deletes Logic

Scope Year Logic

Identity Mapping Object Key

Event Queue Detail

Object Data Elements

Arrays

Receiving Services

Appendices

Appendix A: Object Triggering with Multiple Enrollments

Appendix B: Attendance Calculations

Type/Descriptor

Enrollment Type

countDateNameType

countDateReceivingServiceType

Entry Type Descriptors

Exit Withdraw Type Descriptors

Related Articles