Arizona Ed-Fi Data v3.5 - Student School Associations

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 where 'State Exclude' is not checked. 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.
Post	When the start status is changed from ZZZ to a different value.
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 change. 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 re-posted.
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 re-posted.

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
	Enrollment Graduation (Year End Status)
	Enrollment End Action
Exit Reason Descriptors	Enrollment Withdrawal Reason
Membership FTE Descriptors	Enrollment School Membership FTE
Membership Type Descriptors	Enrollment Local Service Type
Special Enrollment Descriptors	Enrollment Special Enrollment
Tuition Payer Descriptors	Enrollment Tuition Payer

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 dates. When there are enrollments with an end status of ZZZ and a subsequent enrollment with a start status of ZZZ, combine the enrollments and report the earliest start date (where the start status is NOT ZZZ) for the enrollment start date. The enrollments must be in the same school, grade, and local service type. Also, the enrollment start date must be the next instructional day after the ZZZ end status, or be before or equal to the ZZZ end status.	M	Student Information> General> Enrollments> Start Date	enrollment. startdate
calendarReference	A reference related to the Calendar resource.	Reports the Calendar reference for the calendar in which the student is enrolled that is being reported. When 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
classOfSchoolYear TypeReference	The year the student is expected to graduate.	Reports the year selected in Student Information > General > Graduation > NCLB Cohort End Year. When NCLB Cohort End Year = Null, do not report.	C
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.	Reports the end year of the calendar.	O
studentReference	A reference to the related Student resource.	Reports the reference for the student being reported. Note: The Ed-Fi ID reports from the Student State ID field.	M
educationPlans	An unordered collection of studentSchoolAssociation EducationPlans. This association represents the school in which a student is enrolled.	This is optional, does not report.	O
employedWhile Enrolled	An individual who is a paid employee or works in his or her own business, profession, or farm and at the same time is enrolled in secondary, postsecondary, or adult education.	This is optional, does not report.	O
entryGradeLevel Descriptor	The grade level or primary instructional level at which a student enters and receives services in a school or an educational institution during a given academic session.	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 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
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 selected Start Status. When 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.	Reports the enrollment end date. When there are enrollments with an end status of ZZZ and a subsequent enrollment with a start status of ZZZ, combine the enrollments and report the latest end date (where the end status is NOT ZZZ) for the enrollment end date. The enrollments must be in the same school, grade, and local service type. Also, the enrollment start date must be the next instructional day after the ZZZ end status, or be before or equal to the ZZZ end status.	O	Student Information> General> Enrollments> End Date	enrollment. enddate
exitWithdraw ReasonDescriptor	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.	Reports based on the mapped value indicated in the Ed-Fi mapping tool tied to the attribute dictionary item selected. When a mapping does not exist, do not report.	C	Student Information > General > Enrollments > Withdrawal Reason	enrollmentaz. withdrawalreason
exitWithdrawType Descriptor	A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.	Reports based on the mapped value indicated in the Ed-Fi mapping tool, tied to the attribute dictionary item selected, based on the following hierarchy: Reports from the “Graduation (Year End Status)” field on Enrollment when entered. The End Action and End Status values are ignored when populated. Reports 'WP' when Enrollment End Status is “WP” and Graduation (Year End Status) is blank. Reports from Enrollment End Action when End Action is mapped in the mapping tool. Reports from Enrollment End Status when End Status is not blank, and the Ed-Fi Code value of the code selected is not null, and none of the above conditions are true. Reports blank when 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
membershipType Descriptor	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.	Reports based on the mapped value indicated in the EdFi mapping tool, when it exists, tied to the attribute dictionary item selected. When 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
repeatGrade Indicator	An indicator of whether the student is enrolling to repeat a grade level, either by failure or an agreement to hold the student back.	This is optional, does not report.	O
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
totalCommunityCollege EnrolledCredits	The total value of credits for courses at community college.	Reports the value from the 'Total CC CTE Credits' field, when populated.	C	Student Information > General > Enrollments > State Reporting Fields > Total CC CTE Credits
totalPlannedInstructional Hours	he planned total number of clock hours for CTED courses.	Reports the value from the 'Total CTE Hours' field, when populated.	C	Student Information > General > Enrollments > State Reporting Fields > Total CTE Hours
etag

Arrays

Click here to expand...

localEducationAgencies

Data Element Label	Business Requirement	Business Rules	M, C, or O	Data Source GUI Path	Database Field
membershipResponsibilityDescriptor		Reports '03' (which = Funding)	M	n/a	n/a
startDate	The effective date of this FTE value.	When the default value is being reported, the enrollment start date reports. When the first entered value is being reported, the enrollment start date reports. When a new value from custom student is created, the effective date on the record reports.	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.	When there is a single "split enrollment" record, the Enrollment End Date the record is tied to reports. When there are subsequent "split enrollment" records, the latest instructional date prior to the next record's Effective Date value reports.	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.	This reports the entity ID for the district selected in the Resident District field. The Entity ID that corresponds with the District selected in the Resident District table reports.	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 Student School Association Membership.	When the default value is being reported, report the enrollment start date. When the first entered value is being reported, report the enrollment start date. When 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
membershipFTE Descriptor	The ID of the Membership FTE Descriptor.	When the Percent Enrolled field is not NULL, reports based on the mapped value indicated in the EdFi mapping tool, when it exists, tied to the attribute dictionary item selected. When the Percent Enrolled is NULL, or not NULL but there is no mapped value in the EdFi mapping tool, reports based on the value entered into the default field on the Percent Enrolled attribute. When Percent Enrolled is NULL, and the default field on the Percent Enrolled attribute is NULL, reports 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 Student School Association Membership.	When there is a single "split enrollment" record, reports the Enrollment End Date to which the record is tied. When there are subsequent "split enrollment" records, reports 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 Student School Association Membership.

When the default value is being reported, report the enrollment start date.

When the first entered value is being reported, report the enrollment start date.

When 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

membershipFTE
Descriptor

The ID of the Membership FTE Descriptor.

When the Percent Enrolled field is not NULL, reports based on the mapped value indicated in the EdFi mapping tool, when it exists, tied to the attribute dictionary item selected.

When the Percent Enrolled is NULL, or not NULL but there is no mapped value in the EdFi mapping tool, reports based on the value entered into the default field on the Percent Enrolled attribute.

When Percent Enrolled is NULL, and the default field on the Percent Enrolled attribute is NULL, reports 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 Student School Association Membership.

When there is a single "split enrollment" record, reports the Enrollment End Date to which the record is tied.

When there are subsequent "split enrollment" records, reports 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
specialEnrollment StartDate	The start date for the Student School Association Special Enrollment.	When the default value is being reported, reports the enrollment start date. When the first entered value is being reported, reports the enrollment start date. When the value from custom student is being reported, reports 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
specialEnrollment Descriptor	The ID of the Special Enrollment Descriptor.	When the default value is entered and no other Special Enrollment record exists, reports the default value. When the Special Enrollment value exists, reports based on the mapped value indicated in the EdFi mapping tool, when it exists, tied to the attribute dictionary item selected. When a mapping does not exist, does 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
specialEnrollment EndDate	The end date for the Student School Association Special Enrollment.	When there is a single "split enrollment" record, reports the Enrollment End Date to which the record is tied. When there are subsequent "split enrollment" records, reports 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

specialEnrollment
StartDate

The start date for the Student School Association Special Enrollment.

When the default value is being reported, reports the enrollment start date.

When the first entered value is being reported, reports the enrollment start date.

When the value from custom student is being reported, reports effective date on the record being reported.

Student Information > General > Enrollments > Start Date

Student Information > General > Enrollments > Effective Date

enrollment.startdate

customstudent.effectivedate

specialEnrollment
Descriptor

The ID of the Special Enrollment Descriptor.

When the default value is entered and no other Special Enrollment record exists, reports the default value.

When the Special Enrollment value exists, reports based on the mapped value indicated in the EdFi mapping tool, when it exists, tied to the attribute dictionary item selected.

When a mapping does not exist, does not report.

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

Student Information > General > Enrollments > Special Enrollment

enrollment.nclbChoice

customstudent.value

specialEnrollment
EndDate

The end date for the Student School Association Special Enrollment.

When there is a single "split enrollment" record, reports the Enrollment End Date to which the record is tied.

When there are subsequent "split enrollment" records, reports 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 Student School Association Tuition Payer.	When the default value is being reported, reports the enrollment start date. When the first entered value is being reported, reports the enrollment start date. When 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
tuitionPayer Descriptor	The ID of the Tuition Payer Descriptor.	When State Aid is not NULL, report based on the the mapped value indicated in the EdFi mapping tool, if it exists, tied to the attribute dictionary item selected. When no mapping exists, continue below to the second bullet. When State Aid is NULL, reports based on the value entered into the default field on the Enrollment.stateAid attribute. When State Aid is NULL, and the default field on the Enrollment.stateAid attribute is NULL, reports 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 Student School Association Tuition Payer.	When there is a single "split enrollment" record, reports the Enrollment End Date to which the record is tied. When there are subsequent "split enrollment" records, reports 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 Student School Association Tuition Payer.

When the default value is being reported, reports the enrollment start date.

When the first entered value is being reported, reports the enrollment start date.

When 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

tuitionPayer Descriptor

The ID of the Tuition Payer Descriptor.

When State Aid is not NULL, report based on the the mapped value indicated in the EdFi mapping tool, if it exists, tied to the attribute dictionary item selected.

When no mapping exists, continue below to the second bullet.

When State Aid is NULL, reports based on the value entered into the default field on the Enrollment.stateAid attribute.

When State Aid is NULL, and the default field on the Enrollment.stateAid attribute is NULL, reports 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 Student School Association Tuition Payer.

When there is a single "split enrollment" record, reports the Enrollment End Date to which the record is tied.

When there are subsequent "split enrollment" records, reports 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

Click here to expand...

Enrollment State Start Status Descriptors

Code	Description
E	NON-SAIS DISTRICT USE ONLY!
E1	1st AZ enroll, from same school
E2	1st AZ enroll, from within district
E3	1st AZ enroll, from other district
E4	NOT 1st AZ enroll, from other district
E5	NOT 1st AZ enroll, from within district
E6	1st AZ enroll, from other state
E7	1st AZ enroll, from within district, dropout
E8	1st AZ enroll, other district, dropout
E9	NOT 1st AZ enroll; from within district, dropout
E10	NOT 1st AZ enroll, other district dropout
E11	1st AZ enroll this year for home taught student
E15	1st AZ enroll, from detention facility
E16	NOT 1st AZ enroll, from detention facility
E17	GCD awarded: attending AZ university
E18	GCD awarded: attending AZ community college
E19	GCD-eligible, enrolled in CTE program
E20	GCD-eligible, pursuing additional board exam
EK	Transferred calendar tracks within the same school
P	Program Only
R1	Readmission after a W1
R2	Readmission after a W2
R3	Readmission after a W3
R4	Readmission after a W4
R5	Readmission after a W5
R6	Readmission after a W6
R9	Readmission after a W9
R10	Readmission after a W10
R11	Readmission after a W11
R12	Readmission after a W12
R21	Readmission after a W21/S21
R22	Readmission after a W22
RD	Mid-year Demoted re-entry
RP	Mid-year Promoted re-entry

Exit Withdraw Type Descriptors

Code	Name	Ed-Fi Code Value
W	Not State Reported District Use Only
W1	Transfer: other school	W1
W2	Illness	W2
W3	Expelled or long term suspension	W3
W4	Absence or status unknown	W4
W5	Dropout	W5
W6	Age	W6
W7	Graduated	W7
W8	Deceased	W8
W9	Transfer: home taught	W9
W10	Transfer: detention	W10
W11	GED	W11
W12	Vocational school	W12
W13	Completed (AIMS)	W13
W14	GCD-Eligible	W14
W15	GCD awarded	W15
W17	GCD awarded no criteria for four-year univ	W17
W18	CD awarded no criteria for AZ comm college	W18
W19	GCD eligible not in full-time CTE prog	W19
W20	GCD awarded, no post GCD participation	W20
W21	Transfer to another school out of state	W21
W22	Transferred to attend school in another country	W22
WD	Mid Year Demote	WD
WP	Mid Year Promotion	WP
WK	Transferred calendar tracks within the same school	WK
S1	Summer transfer - out of district	S1
S4	Summer absence or status unknown	S4
S5	Summer dropout	S5
S6	Summer not of school age	S6
S7	Summer early graduation	S7
S8	Summer deceased	S8
S9	Summer transfer - home taught	S9
S10	Summer transfer - detention	S10
S11	Summer GED	S11
S12	Summer transfer - vocational school	S12
S99	Summer transfer - within district	S99
S19	GCD, not enrolled in full-time CTE program	S19
S21	Transferred to attend school out of state	S21
S22	Transferred to attend school in another country	S22
D1	Eligible for GCD	D1
D2	Awarded GCD	D2

Enrollment Graduation (Year End Status)

Code Value	Description
A: Attended-Concluded HS not expected to reenroll	A: Attended-Concluded HS not expected to reenroll
C: Completed course of Study	C: Completed course of Study at year end
G: Graduated	G: Graduated at year end
P: Promoted to the next grade	P: Promoted
R: Retained	R: Retained
SC: Still Enrolled (Course Study Reqs)	SC: Still Enrolled (Course Study Requirements)

Enrollment End Action

Code Value	Description
D: Demote	D: Demote
P: Promote	P: Promote
R: Retain	R: Retain

Enrollment Withdrawal Reason

Code Value	Description
WR1: School identified for Federal Improvement	WR1: School identified for Federal Improvement
WR2: School persistently dangerous	WR2: School persistently dangerous
WR3: Individual Transfer Option	WR3: Individual Transfer Option
WR4: Pregnancy/Biological Parent	WR4: Pregnancy/Biological Parent

Enrollment School Membership FTE

Code Value	Description
0.00: 00%	0.00: Student's course load is part time, equivalent to 0% of a full time program
0.25: 25%	0.25: 0.25 Student's course load is part time, equivalent to 25% of a full time program
0.50: 50%	0.50: 0.50 Student's course load is part time, equivalent to 50% of a full time program
0.75: 75%	0.75: 0.75 Student's course load is part time, equivalent to 75% of a full time program
1.00: 100%	1.00: 1.00 Student's course load is part time, equivalent to 100% of a full time program

Enrollment 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
T: AOI	AOI

Enrollment Special Enrollment

Ed-Fi Code Value	Description
1	CECA
2	CECB
3	Open Enrollment

Enrollment Tuition Payer

Ed-Fi Code Value	Short Description	Description
1	1 The "normal" setting for Arizona school children who generate state funding	The "normal" setting for Arizona school children who generate state funding.
2	Privately paid tuition, no tuition charged.	Privately paid tuition, no tuition charged.
3	Foreign Exchange Student	Foreign exchange student
4	Non-SPED (NSE) students in residential treatment centers	Non-SPED (NSE) students in residential treatment centers
5	JTED/Non-Resident Charter (concurrent)	JTED/Non-Resident Charter (concurrent)
6	ISEP Student	ISEP student
7	Other State funded formula	Students funded through other state formula programs
8	Non-AZ resident at specail school	Non-Arizona resident boarding at specialized school

Appendix A - Summer Withdrawal Students

Click here to expand...

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:

Mark the 'No Show' checkbox on the student's enrollment.
Any Ed-Fi data that was previously sent 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.5 - Student School Associations

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

Enrollment State Start Status Descriptors

Exit Withdraw Type Descriptors

Enrollment Graduation (Year End Status)

Enrollment End Action

Enrollment Withdrawal Reason

Enrollment School Membership FTE

Enrollment Local Service Type

Enrollment Tuition Payer

Appendix A - Summer Withdrawal Students

Related Articles