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

Classic View: System Administration > Ed-Fi

Search Terms: Ed-Fi

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

To prepare for summer withdrawal students, districts need to perform a specific setup in order to send the Student School Association resource correctly. Please see Appendix A for further details.

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 records if the Calendar Exclude check box is checked in the calendar the student is enrolled. Do not send records if the School Exclude check box is checked in the calendar the student is enrolled.
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 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 field is 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.

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.

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

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. If the Calendar the student is enrolled in is mapped via the EdFi Calendar Override Mapping tool to a different calendar, reference that different calendar.	C	System Administration > Ed-Fi > Ed-Fi Configuration > Resource Preferences > Calendars > Calendar Override Mapping
classOfSchoolYearTypeReference	The year the student is expected to graduate.	Report the year selected in Student Info > General > Graduation > NCLB Cohort End Year. If NCLB Cohort End Year = Null, do not report.	C
graduationPlanReference	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
schoolYearTypeReference	The school year the student is being reported in.	Reports the end year of the calendar.	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
employedWhileEnrolled	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
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.	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
entryGradeLevelReasonDescriptor	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
entryTypeDescriptor	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
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.	Report the enrollment end date.	O	Student Information> General> Enrollments> End Date	enrollment.enddate
exitWithdrawReasonDescriptor	Withdrawal Reasons are a secondary reason for the withdrawal (the primary reason being the Withdrawal Activity Code). Withdrawal Reasons are optional, and will not apply to the great majority of students who withdraw from school prior to the last scheduled day of session.	Report based on the mapped value indicated in the EdFi mapping tool, if it exists, tied to the attribute dictionary item selected. If a mapping does not exist, do not report.	C	Student Information > General > Enrollments > Withdrawal Reason	enrollmentaz.withdrawalreason
exitWithdrawTypeDescriptor	A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.	Report based on the mapped value indicated in the EdFi mapping tool, if it exists, tied to the attribute dictionary item selected, based on the following hierarchy: Report from the “Graduation (Year End Status)” field on Enrollment if set. Ignore End Action and End Status if populated. Report 'WP' if Enrollment End Status = “WP” and Graduation (Year End Status) is null. Report from Enrollment End Action if End Action is mapped in the mapping tool. Report from Enrollment End Status if End Status is not null, and the Ed-Fi Code value of the code selected is not null, and none of the above conditions are true. Report blank if none of the above conditions are true.	C	Student Information > General > Enrollments > End Status Student Information > General > Enrollments > Graduation (Year End Status) Student Information > General > enrollments > End Action	enrollment.endstatus enrollment.yearEndStatus enrollment.endAction
membershipTypeDescriptor	Membership Type identifies whether a school has primary responsibility for managing a specific student's curriculum or not. The "P" code value will allow the reporting of students who are enrolled in a SPED program but not enrolled in a school.	Report based on the mapped value indicated in the EdFi mapping tool, if it exists, tied to the attribute dictionary item selected. If a mapping does not exist, do not report.	M	Student Information > General > Enrollments > State Reporting Fields > Local Service Type
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
repeatGradeIndicator	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
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.	This is optional, does not report.	O
schoolChoiceTransfer	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
etag

Arrays

localEducationAgencies

Data Element Label	Business Requirement	Business Rules	M, C, or O	Data Source GUI Path	Database Field
membershipResponsibilityDescriptor		Report '03' (which = Funding)	M	n/a	n/a
startDate	The effective date of this FTE value.	If the default value is being reported, report the enrollment start date. If the 1st entered value is being reported, report the enrollment start date. If a new value from custom student created, report effective date on the record being reported.	M	Student Information > General > Enrollments > Start Date or Student Information > General > Enrollments > Effective Date
endDate	The date this CTDS ceased being the student's funded district of residence.	If there is a single "split enrollment" record, report the Enrollment End Date the record is tied to. If there are subsequent "split enrollment" records, report the latest instructional date prior to the next record's Effective Date value.	C	Student Information > General > Enrollments > End Date or Student Information > General > Enrollments > Effective Date
localEducationAgencyReference	localEducationAgencyId: The identifier assigned to a local education agency. School Identity Column. Student's District of Residence.	AZ reports the entity ID for the district selected in the Resident District drop list. The list of districts is stored in the District table. Report the Entity ID that corresponds with the District selected in the Resident District table. Note: This is a hard coded list so if changes to AZ district occur, the District table would need to be updated to reflect a change.	M	Student Information > General > Enrollments > Resident District	Enrollment.residentDistrict

membershipFTEs

Data Element Label	Business Requirement	Business Rules	M, C, or O	Data Source GUI Path	Database Field
fteStartDate	The start date for the StudentSchoolAssociationMembership.	If the default value is being reported, report the enrollment start date. If the 1st entered value is being reported, report the enrollment start date. If the value from custom student is being reported, report effective date on the record being reported.	M	Student Information > General > Enrollments > Start Date OR Student Information > General > Enrollments > Effective Date	enrollment.startdate OR customstudent.effectivedate
membershipFTEDescriptor	The ID of the Membership FTE Descriptor.	If Enrollment.percentEnrolled is <> NULL, report based on the mapped value indicated in the EdFi mapping tool, if it exists, tied to the attribute dictionary item selected. If Enrollment.percentEnrolled is NULL, or not NULL but there is no mapped value in the EdFi mapping tool, report based on the value entered into the default field on the Enrollment.percentEnrolled attribute. If Enrollment.percentEnrolled is NULL, and the default field on the Enrollment.percentEnrolled attribute is NULL, report based on a value of '1.00'.	M	System Administration > Custom > Attribute Dictionary > Enrollment > School Membership FTE > Default Value OR Student Information > General > Enrollments > FTE %	enrollment.percentenrolled or customstudent.value
fteEndDate	The end date for the StudentSchoolAssociationMembership.	If there is a single "split enrollment" record, report the Enrollment End Date the record is tied to. If there are subsequent "split enrollment" records, report the latest instructional date prior to the next record's Effective Date value.	C	Student Information > General > Enrollments > End Date OR calculated value	enrollment.enddate OR customstudent.effectivedate

Data Element Label

Business Requirement

Business Rules

M, C, or O

Data Source GUI Path

Database Field

fteStartDate

The start date for the StudentSchoolAssociationMembership.

If the default value is being reported, report the enrollment start date.
If the 1st entered value is being reported, report the enrollment start date.
If the value from custom student is being reported, report effective date on the record being reported.

Student Information > General > Enrollments > Start Date

Student Information > General > Enrollments > Effective Date

enrollment.startdate

customstudent.effectivedate

membershipFTEDescriptor

The ID of the Membership FTE Descriptor.

If Enrollment.percentEnrolled is <> NULL, report based on the mapped value indicated in the EdFi mapping tool, if it exists, tied to the attribute dictionary item selected.
If Enrollment.percentEnrolled is NULL, or not NULL but there is no mapped value in the EdFi mapping tool, report based on the value entered into the default field on the Enrollment.percentEnrolled attribute.
If Enrollment.percentEnrolled is NULL, and the default field on the Enrollment.percentEnrolled attribute is NULL, report based on a value of '1.00'.

System Administration > Custom > Attribute Dictionary > Enrollment > School Membership FTE > Default Value

Student Information > General > Enrollments > FTE %

enrollment.percentenrolled

customstudent.value

fteEndDate

The end date for the StudentSchoolAssociationMembership.

If there is a single "split enrollment" record, report the Enrollment End Date the record is tied to.
If there are subsequent "split enrollment" records, report the latest instructional date prior to the next record's Effective Date value.

Student Information > General > Enrollments > End Date

calculated value

enrollment.enddate

customstudent.effectivedate

specialEnrollments

Data Element Label	Business Requirement	Business Rules	M, C, or O	Data Source GUI Path	Database Field
specialEnrollmentStartDate	The start date for the StudentSchoolAssociationSpecialEnrollment.	If the default value is being reported, report the enrollment start date. If the 1st entered value is being reported, report the enrollment start date. If the value from custom student is being reported, report effective date on the record being reported.	M	Student Information > General > Enrollments > Start Date OR Student Information > General > Enrollments > Effective Date	enrollment.startdate OR customstudent.effectivedate
specialEnrollmentDescriptor	The ID of the Special Enrollment Descriptor.	If default value is entered and no other Special Enrollment record exists, report default value. If a Special Enrollment value exists, report based on the mapped value indicated in the EdFi mapping tool, if it exists, tied to the attribute dictionary item selected. If a mapping does not exist, do not report.	C	System Administration > Custom > Attribute Dictionary > Enrollment> Special Enrollment > Default Value OR Student Information > General > Enrollments > Special Enrollment	enrollment.nclbChoice or customstudent.value
specialEnrollmentEndDate	The end date for the StudentSchoolAssociationSpecialEnrollment.	If there is a single "split enrollment" record, report the Enrollment End Date the record is tied to. If there are subsequent "split enrollment" records, report the latest instructional date prior to the next record's Effective Date value.	C	Student Information > General > Enrollments > End Date OR calculated value	enrollment.enddate OR customstudent.effectivedate

Data Element Label

Business Requirement

Business Rules

M, C, or O

Data Source GUI Path

Database Field

specialEnrollmentStartDate

The start date for the StudentSchoolAssociationSpecialEnrollment.

If the default value is being reported, report the enrollment start date.
If the 1st entered value is being reported, report the enrollment start date.
If the value from custom student is being reported, report effective date on the record being reported.

Student Information > General > Enrollments > Start Date

Student Information > General > Enrollments > Effective Date

enrollment.startdate

customstudent.effectivedate

specialEnrollmentDescriptor

The ID of the Special Enrollment Descriptor.

If default value is entered and no other Special Enrollment record exists, report default value.
If a Special Enrollment value exists, report based on the mapped value indicated in the EdFi mapping tool, if it exists, tied to the attribute dictionary item selected.
1. If a mapping does not exist, do not report.

System Administration > Custom > Attribute Dictionary > Enrollment> Special Enrollment > Default Value

Student Information > General > Enrollments > Special Enrollment

enrollment.nclbChoice

customstudent.value

specialEnrollmentEndDate

The end date for the StudentSchoolAssociationSpecialEnrollment.

If there is a single "split enrollment" record, report the Enrollment End Date the record is tied to.
If there are subsequent "split enrollment" records, report the latest instructional date prior to the next record's Effective Date value.

Student Information > General > Enrollments > End Date

calculated value

enrollment.enddate

customstudent.effectivedate

tuitionPayers

Data Element Label	Business Requirement	Business Rules	M, C, or O	Data Source GUI Path	Database Field
payerStartDate	The start date for the StudentSchoolAssociationTuitionPayer.	If the default value is being reported, report the enrollment start date. If the 1st entered value is being reported, report the enrollment start date. If the value from custom student is being reported, report effective date on the record being reported.	M	Student Information > General > Enrollments > Start Date OR Student Information > General > Enrollments > Effective Date	enrollment.startdate OR customstudent.effectivedate
tuitionPayerDescriptor	The ID of the Tuition Payer Descriptor.	If Enrollment.stateAid <> NULL, report based on the the mapped value indicated in the EdFi mapping tool, if it exists, tied to the attribute dictionary item selected. If no mapping exists, continue below to #3 If Enrollment.stateAid is NULL, report based on the value entered into the default field on the Enrollment.stateAid attribute. If Enrollment.stateAid is NULL, and the default field on the Enrollment.stateAid attribute is NULL, report based on a value of '1'.	M	Student Information > General > Enrollments > Tuition Payer OR System Administration > Custom > Attribute Dictionary > Enrollment > Tuition Payer > Default Value	Enrollment.stateAid OR customstudent.value
payerEndDate	The end date for the StudentSchoolAssociationTuitionPayer.	If there is a single "split enrollment" record, report the Enrollment End Date the record is tied to. If there are subsequent "split enrollment" records, report the latest instructional date prior to the next record's Effective Date value.	C	Student Information > General> Enrollments > End Date OR calculated value	enrollment.enddate OR customstudent.effectivedate

Data Element Label

Business Requirement

Business Rules

M, C, or O

Data Source GUI Path

Database Field

payerStartDate

The start date for the StudentSchoolAssociationTuitionPayer.

If the default value is being reported, report the enrollment start date.
If the 1st entered value is being reported, report the enrollment start date.
If the value from custom student is being reported, report effective date on the record being reported.

Student Information > General > Enrollments > Start Date

Student Information > General > Enrollments > Effective Date

enrollment.startdate

customstudent.effectivedate

tuitionPayerDescriptor

The ID of the Tuition Payer Descriptor.

If Enrollment.stateAid <> NULL, report based on the the mapped value indicated in the EdFi mapping tool, if it exists, tied to the attribute dictionary item selected.
1. If no mapping exists, continue below to #3
If Enrollment.stateAid is NULL, report based on the value entered into the default field on the Enrollment.stateAid attribute.
If Enrollment.stateAid is NULL, and the default field on the Enrollment.stateAid attribute is NULL, report based on a value of '1'.

Student Information > General > Enrollments > Tuition Payer

System Administration > Custom > Attribute Dictionary > Enrollment > Tuition Payer > Default Value

Enrollment.stateAid

customstudent.value

payerEndDate

The end date for the StudentSchoolAssociationTuitionPayer.

If there is a single "split enrollment" record, report the Enrollment End Date the record is tied to.
If there are subsequent "split enrollment" records, report the latest instructional date prior to the next record's Effective Date value.

Student Information > General> Enrollments > End Date

calculated value

enrollment.enddate

customstudent.effectivedate

Type/Descriptor

Entry Grade Level Descriptors

Code Value	Description	Name Space	Short Description
Adult Education	Adult Education	uri://ed-fi.org/GradeLevelDescriptor	Adult Education
Early Education	Early Education	uri://ed-fi.org/GradeLevelDescriptor	Early Education
Eighth grade	Eighth grade	uri://ed-fi.org/GradeLevelDescriptor	Eighth grade
Eleventh grade	Eleventh grade	uri://ed-fi.org/GradeLevelDescriptor	Eleventh grade
Fifth grade	Fifth grade	uri://ed-fi.org/GradeLevelDescriptor	Fifth grade
First grade	First grade	uri://ed-fi.org/GradeLevelDescriptor	First grade
Fourth grade	Fourth grade	uri://ed-fi.org/GradeLevelDescriptor	Fourth grade
Grade 13	Grade 13	uri://ed-fi.org/GradeLevelDescriptor	Grade 13
Infant/toddler	Infant/toddler	uri://ed-fi.org/GradeLevelDescriptor	Infant/toddler
Kindergarten	Kindergarten	uri://ed-fi.org/GradeLevelDescriptor	Kindergarten
Ninth grade	Ninth grade	uri://ed-fi.org/GradeLevelDescriptor	Ninth grade
No grade level	No grade level	uri://ed-fi.org/GradeLevelDescriptor	No grade level
Other	Other	uri://ed-fi.org/GradeLevelDescriptor	Other
Postsecondary	Postsecondary	uri://ed-fi.org/GradeLevelDescriptor	Postsecondary
Preschool/Prekindergarten	Preschool/Prekindergarten	uri://ed-fi.org/GradeLevelDescriptor	Preschool/Prekindergarten
Second grade	Second grade	uri://ed-fi.org/GradeLevelDescriptor	Second grade
Seventh grade	Seventh grade	uri://ed-fi.org/GradeLevelDescriptor	Seventh grade
Sixth grade	Sixth grade	uri://ed-fi.org/GradeLevelDescriptor	Sixth grade
Tenth grade	Tenth grade	uri://ed-fi.org/GradeLevelDescriptor	Tenth grade
Third grade	Third grade	uri://ed-fi.org/GradeLevelDescriptor	Third grade
Twelfth grade	Twelfth grade	uri://ed-fi.org/GradeLevelDescriptor	Twelfth grade
Ungraded	Ungraded	uri://ed-fi.org/GradeLevelDescriptor	Ungraded

Entry Type Descriptors

Code Value	Description	Namespace	Short Description
Transfer	Transfer	uri://ed-fi.org/EntryTypeDescriptor	Transfer
New to education system	New to education system	uri://ed-fi.org/EntryTypeDescriptor	New to education system
Next year school	Next year school	uri://ed-fi.org/EntryTypeDescriptor	Next year school
Other	Other	uri://ed-fi.org/EntryTypeDescriptor	Other
Re-entry	Re-entry	uri://ed-fi.org/EntryTypeDescriptor	Re-entry

Exit Withdraw Type Descriptors

Code Value	Description	Namespace	Short Description
Completed	Completed	uri://ed-fi.org/ExitWithdrawTypeDescriptor	Completed
Died or is permanently incapacitated	Died or is permanently incapacitated	uri://ed-fi.org/ExitWithdrawTypeDescriptor	Died or is permanently incapacitated
Dropout	Dropout	uri://ed-fi.org/ExitWithdrawTypeDescriptor	Dropout
End of school year	End of school year	uri://ed-fi.org/ExitWithdrawTypeDescriptor	End of school year
Enrolled in a high school diploma program	Enrolled in a high school diploma program	uri://ed-fi.org/ExitWithdrawTypeDescriptor	Enrolled in a high school diploma program
Expelled	Expelled	uri://ed-fi.org/ExitWithdrawTypeDescriptor	Expelled
Graduated	Graduated	uri://ed-fi.org/ExitWithdrawTypeDescriptor	Graduated
Incarcerated	Incarcerated	uri://ed-fi.org/ExitWithdrawTypeDescriptor	Incarcerated
Invalid enrollment	Invalid enrollment	uri://ed-fi.org/ExitWithdrawTypeDescriptor	Invalid enrollment
Involuntarily Removed	Involuntarily Removed	uri://ed-fi.org/ExitWithdrawTypeDescriptor	Involuntarily Removed
No show	No show	uri://ed-fi.org/ExitWithdrawTypeDescriptor	No show
Other	Other	uri://ed-fi.org/ExitWithdrawTypeDescriptor	Other
Reached maximum age	Reached maximum age	uri://ed-fi.org/ExitWithdrawTypeDescriptor	Reached maximum age
Transferred	Transferred	uri://ed-fi.org/ExitWithdrawTypeDescriptor	Transferred
Withdrawn	Withdrawn	uri://ed-fi.org/ExitWithdrawTypeDescriptor	Withdrawn

membershipTypeDescriptor = Local Service Type

Code Value	Description
A: Ancillary	Ancillary
C: Concurrent Course Work Program	Concurrent Course Work Program
D: Dropout Recovery Program	Dropout Recovery Program
G: Grand Canyon Diploma	Grand Canyon Diploma
O: Program Only	Program Only
P: Primary	Primary
M: Main	Main
T: AOI	AOI

Appendix A - Summer Withdrawal Students

When a student has finished their previous year’s enrollment and intends to come back to the school the following year, but the student is a no show for the district, a Student School Association record must still be sent. The following setup options must be completed in order to report data correctly for summer withdrawal students:

Post all Ed-Fi resources. Ed-Fi resources must be posted prior to marking the 'No Show' checkbox on the student's enrollment. If an enrollment record is marked as 'No Show' prior to posting the Ed-Fi records, no records will ever post for the student. Performing a resync on a student marked as 'No Show' does not send records either.
Once all Ed-Fi records have been processed for the student, mark the 'No Show' checkbox on the student's enrollment.
All of the Ed-Fi data for the student is automatically deleted after marking the 'No Show' checkbox, except for the Student School Association record.
This process must be completed each year in order to send data for summer withdrawal students correctly.

Arizona 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

Resource Preferences

Identity Mapping Object Key

Event Queue Detail

Object Data Elements

Arrays

localEducationAgencies

membershipFTEs

specialEnrollments

tuitionPayers

Type/Descriptor

Entry Grade Level Descriptors

Entry Type Descriptors

Exit Withdraw Type Descriptors

membershipTypeDescriptor = Local Service Type

Appendix A - Summer Withdrawal Students

Related Articles