Arizona Ed-Fi Data v2.0

Last Modified on 10/22/2022 10:49 am CDT

Classic View: System Administration > Ed-Fi

Search Terms: Ed-Fi

This article defines all of the elements of data sent per entity between Campus and the Ed-Fi system.

This document defines AzEDS v4.0/Ed-Fi v2.0 logic and reported data.

Note: The following resources were added for AzEDS 4.0 reporting in the 1825 release:

Calendar Date Track Events
Grading Periods
Student Program Associations
Tracks

If using the AzEds 5.0 logic and Ed-Fi v3.1, please see the Arizona Ed-Fi v3.1 (19-20) article.

- Future data is suppressed when syncing data from Campus to Ed-Fi. Only past and present data is synced.
- Data in calendars marked as Exclude will not send data to Ed-Fi.
- Person-related records do not trigger a send of data to Ed-Fi if the person does not have an Ed-Fi ID value assigned.
- Ed-Fi ignores custom field data entered in Campus.

For more information about proper Ed-Fi setup for Arizona users, see the following:

An entity is a collection of related data which is sent in a cluster of data elements from Campus to Ed-Fi. Select the following links to view what data elements are contained and sent within that entity:

No Show Logic:

If the No Show checkbox is marked on an enrollment record prior to any data sent to Ed-Fi, only the Student and Student School Association record will be sent.
If the No Show checkbox is marked on an enrollment record after data has been sent to Ed-Fi, the following will occur:
- Deletes are sent for the following resources:
  - StudentEducationOrganizationAssociation
  - StudentSchoolAssociationMembershipFTE
  - StudentSchoolAssociationTuitionPayer
  - StudentSchoolAssociationSpecialEnrollment
  - StudentNeeds
  - StudentProgramAssociation
  - Student Special Education Program Association
- Student and Student School Association records will remain in Ed-Fi and the Student School Association record will be updated with the proper enrollment End Date and Exit Status values.

Understand Object Triggering Tables

The Object Triggering Logic Tables describe what actions within Campus result in data being triggered to sync to Ed-Fi.

Image 1: Example of an Object Triggering Logic Table

The following table lists the definition of each potential Action:

Action	Definition
Post	This will insert new records and data within Ed-Fi.
Put	This action will update existing information within Ed-Fi.
Get	This action is used for items that are pre-loaded by ADE. For example, Courses and Programs.
Delete	This will delete records and data within Ed-Fi.

Understand Object Data Element Tables

The Object Data Element tables describe all of the elements contained within a reporting entity. Each element is given a description of what it is and any potential logic used to calculate the element, if the element is mandatory for reporting to Ed-Fi (indicated by an M), where the data is pulled from the Campus database and where the pulled information is entered within the Campus UI.

Elements marked as M are mandatory elements which must report data to Ed-Fi in order to meet reporting requirements. Elements marked as O are optional elements which are not mandatory for the Ed-Fi requirement but can be populated and report data for additional state-specific reporting purposes. Elements listed as C are conditional elements which are not required to report but will report data if the data is present within Campus.

Data Element Labels in bold are part of the Natural Key and are required data elements for Data to send to Ed-Fi.

Image 2: Example of a Object Data Elements Table

Understand Type/Descriptor Tables

The Type/Descriptor section describes each element and their corresponding Campus to Ed-Fi value translation that is occurring.

If the element is reporting a Descriptor, the Ed-Fi Code Value is reported.

If the element is reporting a Type, the Ed-Fi Short Description is reported.

Image 3: Example of a Type/Descriptor Table

Entities and Elements

The following lists all the currently available and syncing entities and their respective elements.

Negative Attendance calculation logic will report a record for each school, regardless of enrollment type.

Logic will first look at the Attendance Type field on the Enrollment tab, as this is considered an override field. If this field is not populated, the Attendance Type indicated on the calendar is reported.

Calendar Date Track Events

This entity represents a day in the school calendar.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	When a Day and/or a Day Event is created and saved or the Instruction check box is checked. Days can be set either manually or by the Day Reset tool. Day Events can be set either manually or by the Multi Day Event Wizard. Send a record for each date that meets the reporting criteria. When there is more than one calendar/schedule structure, any day that has a day event reports. If the same day in multiple calendars has events that are not the same, all events report. Do not send a record if the Calendar Exclude checkbox is checked. Do not send a record if the School Exclude checkbox is checked.
Put	When a Day Event or Duration is changed and saved.
Delete	When the Instruction check box is unchecked or a Day Event is deleted and saved. When removing a day event there must only be one day event reported to send a delete. If there is more than one, it will update the day, not delete (I.e., if there were previously two identical types saved in a given day, all of them must be deleted for a Delete to send)

Action

Trigger

Post

When a Day and/or a Day Event is created and saved or the Instruction check box is checked.

Days can be set either manually or by the Day Reset tool.
Day Events can be set either manually or by the Multi Day Event Wizard.
Send a record for each date that meets the reporting criteria.
When there is more than one calendar/schedule structure, any day that has a day event reports. If the same day in multiple calendars has events that are not the same, all events report.
Do not send a record if the Calendar Exclude checkbox is checked.
Do not send a record if the School Exclude checkbox is checked.

Put

When a Day Event or Duration is changed and saved.

Delete

When the Instruction check box is unchecked or a Day Event is deleted and saved.

When removing a day event there must only be one day event reported to send a delete. If there is more than one, it will update the day, not delete (I.e., if there were previously two identical types saved in a given day, all of them must be deleted for a Delete to send)

Scope Year Logic

This table describes scope year logic of this object.

Logic
Reports the calendar dates in the scope year to which the calendar is aligned.
Data only sends for the years that have valid configuration.
Future Years data will be suppressed until the Active Year is changed: This allows the Schedule Wizard to be used and reducing the number of records sent until the final schedule is completed. A resync must be done after the Active Year is changed to send data.

Logic

Reports the calendar dates in the scope year to which the calendar is aligned.

Data only sends for the years that have valid configuration.

Future Years data will be suppressed until the Active Year is changed:

This allows the Schedule Wizard to be used and reducing the number of records sent until the final schedule is completed.
A resync must be done after the Active Year is changed to send data.

Object Data Elements

This table describes data elements sent within the Calendar Date Track Events resource.

Data Element	Description		Campus Database Field	Campus GUI Location
id	The unique identifier of the resource.	M
trackReference	Reports the Natural Key of the Tracks resource. schoolId: The identifier assigned to a school by the State Education Agency (SEA). trackLocalEducationAgencyId: The identifier assigned to a local education agency by the State Education Agency (SEA). numberDescriptor (trackNumberDescriptor): The track number descriptor (e.g. 01, 02, 03 etc.) link	M	School.entityID Calendar.track TrackLocalEducationAgencyID Calendar.distrcitID School.districtEntityID	System Administration > Resources > School > school record > Entity ID System Administration > Resources > Calendar > Calendar > Track System Administration > Resources > Calendar > Calendar > Number System Administration > District Information > district record > Entity ID Override, if it exists: System Administration > Resources > School > school record > District Entity ID
date	Reports the month, day, and year of the CalendarDate for each record.	M		System Administration > Calendar > Calendar > Days > day record > Date
eventDuration	Reports the amount of time for the event as recognized by the school: 1 day = 1, 1/2 day = 0.5, 1/3 day = 0.33. Report the value for each unique Day Event record. Calculate the value: ((Day Event > Duration) / (Student Day (Instructional Minutes)) If either location is NULL or '0', report a value of '1.0'. Display to the thousandths decimal position: 'n.nn'.	M		System Administration > Calendar > Student Day (Instructional Minutes) System Administration > Calendar > Calendar > Days > day record > Day Events > Duration
trackEventDescriptor	The type of scheduled or unscheduled event for the day. For example: Instructional day Teacher only day Holiday Make-up day Weather day Student late arrival/early dismissal. Report the Type value for each unique Day Event record. If the "Instructional" checkbox is selected on any day, report '07: Instructional day' on that date. 'Instructional day' only reports for a date in a calendar where the Instructional checkbox is selected and when it is the only Calendar Date Track Event on that date. a. If 'Instructional day' initially reports (as it is the only record on a date in a calendar) and an additional reportable dictionary item is subsequently saved on that date, the Calendar Date Track Event tied to the initial 'Instructional day' record is deleted. b. If a calendar date has a reportable dictionary item saved on that date, and the "Instructional" checkbox is subsequently selected (where it hadn't been selected before), no additional records are generated. c. If a calendar date that previously had a Calendar Date Track Event resource sent due to a reportable dictionary item being saved on a date, and the 'Instructional' checkbox is selected, and the reportable dictionary item that previously saved a Calendar Date Track Event is subsequently deleted, then a new Calendar Date Track Event will be posted for the 'Instructional day' record that may now be reported.	M		System Administration > Calendar > Calendar > Days > day record > Day Events > Type System Administration > Calendar > Calendar > Days > day record > Day Detail > Instructional checkbox
_etag	A unique system-generated value that identifies the version of the resource.	O

Types/Descriptors

This table describes the Ed-Fi Value mapped and reported for Calendar Event Descriptors:

Code Value	Short Description	Description
Make-up day,Instructional	Make-up day,Instructional	Make-up day,Instructional
Weather day,Instructional	Weather day,Instructional	Weather day,Instructional
Teacher Strike,Non-Instructional	Teacher Strike,Non-Instructional	Teacher Strike,Non-Instructional
Student late arrival/early dismissal	Student late arrival/early dismissal	Student late arrival/early dismissal
Teacher only day	Teacher only day	Teacher only day
Emergency day,Instructional	Emergency day,Instructional	Emergency day,Instructional
Christmas Day	Christmas Day	Christmas Day
Independence Day	Independence Day	Independence Day
New Year's Day	New Year's Day	New Year's Day
Veteran's Day	Veteran's Day	Veteran's Day
Spring Break	Spring Break	Spring Break
Fall Break	Fall Break	Fall Break
Winter Break	Winter Break	Winter Break
Columbus Day	Columbus Day	Columbus Day
Labor Day	Labor Day	Labor Day
Martin Luther King Day	Martin Luther King Day	Martin Luther King Day
Memorial Day	Memorial Day	Memorial Day
President's Day	President's Day	President's Day
Thanksgiving Day	Thanksgiving Day	Thanksgiving Day
Other Holiday	Other Holiday	Other Holiday
Other Non Session Day	Other Non Session Day	Other Non Session Day
Weekend day	Weekend day	Weekend day
Student Refusal to Attend 15-806,Instructional	Student Refusal to Attend 15-806,Instructional	Student Refusal to Attend 15-806,Instructional
Student Refusal to Attend 15-806,Non-Instructional	Student Refusal to Attend 15-806,Non-Instructional	Student Refusal to Attend 15-806,Non-Instructional
Weather day,Non-Instructional	Weather day,Non-Instructional	Weather day,Non-Instructional
Emergency day, Non-Instructional	Emergency day, Non-Instructional	Emergency day, Non-Instructional

Class Periods

This entity represents the designation of a regularly scheduled series of class meetings at designated times and days of the week.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	When a Period Schedule is created and saved. A separate record will be sent for each Period Schedule/Period Name/Schedule Structure ID combination created. Do not send records if the Calendar Exclude check box is checked. Do not send a record if the School Exclude checkbox is checked.
Put	When a Period Schedule Name or Period Name is changed and saved.
Delete	When a Period Schedule or Period is deleted.

Action

Trigger

Post

When a Period Schedule is created and saved.

A separate record will be sent for each Period Schedule/Period Name/Schedule Structure ID combination created.
Do not send records if the Calendar Exclude check box is checked.
Do not send a record if the School Exclude checkbox is checked.

Put

When a Period Schedule Name or Period Name is changed and saved.

Delete

When a Period Schedule or Period is deleted.

Scope Year Logic

This table describes scope year logic of this object.

Logic
Reports the class periods in the scope year that the calendar is aligned to.
Data will only send for the years that have valid configuration.
Future Years data will be suppressed until the Active Year is changed: This allows the Schedule Wizard to be used and reducing the number of records sent until the final schedule is completed. A resync must be done after the Active Year is changed to send data.

Logic

Reports the class periods in the scope year that the calendar is aligned to.

Data will only send for the years that have valid configuration.

Future Years data will be suppressed until the Active Year is changed:

This allows the Schedule Wizard to be used and reducing the number of records sent until the final schedule is completed.
A resync must be done after the Active Year is changed to send data.

Object Data Elements

This table describes data elements sent within the Class Periods resource.

Data Element	Description		Campus Database Field	Campus GUI Location
schoolID	Reports the Entity ID entered on the School Editor.	M	School.entityID	System Administration > Resources > School > Entity ID
schoolReference	Reports data from the SchoolID field that is part of the natural key for the Schools resource. The following elements are reported: schoolID	M	School.number	System Administration > Resources > School > State School Number
name	Indicates the portion of a typical daily session in which students receive instruction in a specified subject (e.g., morning, sixth period, block period, etc). The Period Schedule Name + Period Name + Schedule Structure ID reports (with a space between each value). The maximum value for this field is 20 characters. The Period Schedule Name or Period Name may have to be abbreviated if the concatenation exceeds the 20 character limit.	M	PeriodSchedule.name Period.name ScheduleStructure. structureID	System Administration > Calendar > Calendar > Periods System Administration > Calendar > Calendar > Schedule Structure
etag	A unique system-generated value that identifies the version of the resource.	O	N/A	N/A

Course Offering

This entity represents an offering of a course by school during a session, representing the course catalog of available courses.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

This resource will not push data for Courses marked as Inactive or State Exclude.

Action	Trigger
Post	When a section with Section Placement is created and saved. Do not send if course is marked as Inactive or State Exclude. Do not send records if the Calendar Exclude check box is checked. Do not send a record if the School Exclude checkbox is checked. 1 record will report per Course and Term Type combination.
Delete/Post	When the Local Course Number is changed.
Delete/Post	If the Term Descriptor changes either via section placement or mapping override and a course offering already exists with non-matching Term Descriptors.
Put	When Course information is changed and saved. Send a Put when the local course name, attendance, unit attendance or SCED Seq Number is changed.
Delete	When a section is deleted.
Delete	When a section schedule placement is removed and saved.

Scope Year Logic

This table describes scope year logic of this object.

Logic
Reports course offerings for the scope year the courses calendar is aligned to.
Data will only send for the years that have valid configuration.
Future Years data will be suppressed until the Active Year is changed: This allows the Schedule Wizard to be used and reducing the number of records sent until the final schedule is completed. A resync must be done after the Active Year is changed to send data.

Logic

Reports course offerings for the scope year the courses calendar is aligned to.

Data will only send for the years that have valid configuration.

Future Years data will be suppressed until the Active Year is changed:

This allows the Schedule Wizard to be used and reducing the number of records sent until the final schedule is completed.
A resync must be done after the Active Year is changed to send data.

Object Data Elements

This table describes data elements sent within the Course Offering resource.

Data Element	Description			Campus Database Field	Campus GUI Location
id	The unique identifier of the resource.		M	N/A	N/A
courseReference	Reports the following elements that are part of the Natural Key for the Course resource: educationOrganizationReference code		M	N/A	N/A
schoolReference	Reports the following elements that are part of the Natural Key for the Schools resource: EntityID		M	School.entityID	System Administration > Resources > School > Entity ID
sessionReference	Reports the following elements that are part of the Natural Key for the Sessions resource. Term Descriptor will report based on section schedule placement of the sections of the course. If Term Descriptor Override is checked and there is an existing mapping for the course, Term Descriptors will report based on the mapping.		M	N/A	N/A
localCourseCode	The local code assigned by the LEA or Campus that identifies the organization of subject matter and related learning experiences provided for the instruction of students.		M	Course.number	Scheduling > Course > Number
localCourseTitle	The descriptive name given to a course of study offered in the school, if different from the CourseTitle.		O	Course.name	Scheduling > Course > Name
courseSchedules	An unordered collection of courseOfferingCourseSchedules.CourseSchedule for a given course.		O
	scheduleDate	The Schedule date for the course. Reports the earliest instructional date the course/section meets in the calendar.			Course > Section > Section Schedule Placement System Administration > Calendar > Calendar > Terms > Start Date
	instructionalMinutesPlanned	The number of Instructional minutes planned for given ScheduledDate. Reports the number of instructional minutes tied to the period the course/section first meets in the calendar.			Course > Section > Section Schedule Placement System Administration > Calendar > Calendar > Terms > Start Date System Administration > Calendar > Calendar > Periods
InstructionalTimePlanned	The plannned total number of clock minutes of instruction for this course offering. Generally, this should be at least as many minutes as is required for completion by the related state- or district-defined Course.		O	N/A	N/A
endOfCourse AssessmentCodeType	Identifies which assessments, if any, are offered in conjunction with the course. Report the value if saved in the db. If a change occurs to this field, it should force a 'Put' for the resource, to update the value in the state's db.		O	Course. endOfCourseAssessment	Scheduling > Course > End of Course Assessment
curriculumUsed	An unordered collection of courseOfferingCurriculumUseds. This entity represents an offering of a course by school during a session, representing the course catalog of available courses.		O	N/A	N/A
etag	A unique system-generated value that identifies the version of the resource.		O	N/A	N/A

Course Transcripts

This entity is the final record of a student's performance in their courses at the end of a semester or school year.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Course Transcript records will also report from State Reported Grading tasks and Standards for AZ.

Action	Trigger
Post	When transcript records are posted for a student for course with a state code and in grades 9-12 or when a grade is posted to a grading task that is marked as State Reported for grades K-8. Only report transcript records where the record's school number = to the school number where the student is enrolled. Only reports records for the school year the enrollment is aligned to. Do not send a record if the Student has an enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY! Do not report if posted from a course in an excluded calendar. If transcript is manually entered, only report if student has an enrollment in a calendar not marked as excluded. Do not report if the Course is marked as inactive or State Excluded.
Post/Delete	When a grade is changed on a state reported grading task or part of the Natural Key is changed.
Put	When any field not part of the natural key is changed.
Delete	When a transcript record is deleted for a student.
Delete	When a state reported grade is deleted for a student.
Delete	Transcript and Grade records will delete when a student has only 1 Student School Association record for a specific School and Year and that record is deleted. If a new Student School Association record is created, existing records will not re-post, a resync must be completed to resend the data.
Delete	When the State Exclude or No Show check boxes are checked. If the boxes are unchecked the data will not post, a resync must be completed to resend the data.
Delete	When the District Number on the course transcript is changed and it no longer matches the reporting districts Number.

Scope Year Logic

This table describes scope year logic of this object.

Logic
Transcript records will send to the scope year based on the school year the record is posted to.
Grades will post to the scope year the course's calendar is aligned to.
Data will only send for the years that have valid configuration.

Object Data Elements

This table describes data elements sent within the Course Transcripts resource.

Data Element	Description		Campus Database Field	Campus GUI Location
courseEducation OrganizationId	The Education Organization that provided the reported instruction. This element always reports 79275.	M	School.number	System Administration > Resources > School > State School Number
Course Reference	Reports the Natural Key from the Course reference. Eeducation Organization Reference always reports "79275". Course code: Reports the state course number.	M	N/A	N/A
courseCode	The actual code that identifies the organization of subject matter and related learning experiences provided for the instruction of students. Report the Course State Code from the Course when reporting from State Reported Grading Task. Report the State Code when reported from the Transcript record.	M	TranscriptCourse. statecode Course.statecode	Student Information > General > Transcripts > State Code Scheduling > Course > State Code
schoolID	The school where the student completed instruction.		TranscriptCourse. schoolNumber	Student Information > General > Transcripts > School Number
studentAcademic RecordReference	Reports the following Natural Key elements for the Student Academic Record resource: educationOrganizationReference schoolYearTypeReference studentReference termType	M	N/A	N/A
courseAttemptResultType	The result from the student's attempt at taking the course (e.g., Pass, Fail, Incomplete, Withdrawn). When reporting from State Reported Grading Task or Standard use the Score Group or Rubric used for the posted grade to determine the Result Type: Report 'Pass' when the posted score has the Passing check box checked on the score group where the grade was posted from. Report 'Fail' when the posted grade does not have the Passing check box checked on the score group where the grade was posted from. When reporting from Transcript Records use the Credits Earned vs. Credit Attempted to determine the Result Type: Report 'Pass' when the sum of credits Earned is >= the sum of credits Attempted Report 'Fail' when the sum of credits Earned is blank or = 0 Report 'Incomplete' when the sum of credits Earned is not blank or = 0 and < than the sum of credits Attempted Incomplete or Withdrawn from Grading Tasks or Standards records are not reported.	M	Transcriptcredit. creditsAttempted Transcriptcredit. creditsEarned	Student Information > General > Transcripts > Earned Student Information> General > Transcripts > Attempted
attemptedCreditType	The type of credits or units of value attempted for the completion of a course.	O	N/A	N/A
attemptedCreditConversion	Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units.	O	N/A	N/A
attemptedCredit	The number of credits attempted for a course. Logic reports the sum of credits from the Attempted field on the Transcript record being reported.	O	Transcriptcredit. creditsAttempted	Student Information > General > Transcripts > Attempted
earnedCreditType	The type of credits or units of value awarded for the completion of a course.	O	N/A	N/A
earnedCreditConversion	Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units.	O	N/A	N/A
earnedCredit	The number of credits awarded or earned for the course. Logic reports the sum of credits from the Earned field on the Transcript record being reported. For students in Grades K-8, report '1'. For all other students, report the sum of credits from the Earned field on the Transcript record being reported.	M	Transcriptcredit. creditsEarned	Student Information > General > Transcripts > Earned
whenTakenGrade LevelDescriptor	Student's grade level at time of course. Report the State Grade Level from the Grade that the student was in when they completed the courseReport from the enrollment record with same School Year as the transcript record. Report from the students Primary enrollment: Service Type = P If a student has multiple enrollments with Service Type = T : AOI and Service Type = A : Ancillary, report one record for the Service Type = T : AOI enrollment. If the student only has one enrollment, report a record regardless of Service Type. If student has multiple enrollments that meet the above criteria, report from most recent start date. If start dates are the same, report from highest enrollment ID. If the student does not have a corresponding enrollment record, report b.	O	Enrollment.grade	Student Information > General > Enrollments > Grade
gradeLevelDescriptor	The student's grade level at time of course. Logic reports the State Grade Level from the Grade the student was in when they completed the reporting course from the enrollment record in the same School Year as the transcript record. Only Primary enrollment records are reported. If a student has multiple enrollments with Service Type = T : AOI and a Service Type = A : Ancillary, report one record for the Service Type = T : AOI enrollment. If the student only has one enrollment, report a record regardless of Service Type. If student has multiple enrollments that meet the above criteria, report from most recent start date. If start dates are the same, report from highest enrollment ID. If the student does not have a corresponding enrollment record, report blank.	O	Enrollment.grade	Student Information > General > Enrollments > Grade
methodCreditEarnedType	The method used for gaining credits (i.e., classroom, examination, transfer, etc).	O	N/A	N/A
finalLetterGradeEarned	The final letter grade earned for the course. Report the Current Score posted to the transcript record. Report the Score Name when reporting from the State Reported Grading Task or Standard. Look at the score being reported and determine if it is an integer or not. If the posted value is not an Integer then report the value here. Else, report the score in the Final Numeric Grade Earned.	O	TranscriptCourse.score	Student Information > General > Transcripts > Current Score, Name
finalNumericGradeEarned	The final numeric grade earned for the course. Report the Current Score posted to the transcript record. Report the Score Name when reporting from the State Reported Grading Task or Standard. Look at the score being reported and determine if it is an integer or not. If the posted value is an Integer then report the value here. Else, report the score in the Final Letter Grade Earned.	O	TranscriptCourse.score	Student Information > General > Transcripts > Current Score, Name
courseRepeatCodeType	Indicates that an academic course has been repeated by a student and how that repeat is to be computed in the student''s academic grade average.	O	N/A	N/A
courseTitle	Reports the name of the course completed. The Course Name from the transcript record is reported.	O	TranscriptCourse. courseName	Student Information > General > Transcripts > Course Name
alternativeCourseTitle	The descriptive name given to a course of study offered in the school, if different from the CourseTitle.	O	TranscriptCourse. courseName	Student Information> General> Transcripts > Course Name
alternativeCourseCode	The local code assigned by the school that identifies the course offering, the code from an external educational organization, or other alternate course code.	O	TranscriptCourse. courseName	Student Information> General> Transcripts > Course Name
earnedadditionalCredits	An unordered collection of courseTranscriptAdditionalCredits. This entity is the final record of a student's performance in their courses at the end of a semester or school year.	O	N/A	N/A

Course

This educational entity represents the organization of subject matter and related learning experiences provided for the instruction of students on a regular or systematic basis.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

States have pre-loaded courses so we do not post or delete courses.
- No Trigger, this is a look-up as Courses are pre-loaded. We do a match on the State Course Code to see if the course exists in the ODS.
- We do not send data for courses that are marked as Excluded or not marked as Active.
- Do not send data for Courses if the Calendar Exclude checkbox is checked.
- Do not send data for Courses if the School Exclude checkbox is checked.

Object Data Elements

This table describes data elements sent within the Course resource.

Data Element	Description		Campus Database Field	Campus GUI Location
id	The unique identifier of the resource.	M	N/A	N/A
education Organization Reference	A reference to the related EducationOrganization resource. Reports the following elements that are part of the Natural Key for the Schools resource: schoolId	M	N/A	N/A
code	The code that identifies the organization of subject matter and related learning experiences provided for the instruction of students. The State Course Number is reported.	M	Course.stateCode	Scheduling > Course > State Code
title	The descriptive name given to a course of study offered in a school or other institution or organization. In departmentalized classes at the elementary, secondary, and post-secondary levels (and for staff development activities), this refers to the name by which a course is identified (e.g., American History, English III). For elementary and other non-departmentalized classes, it refers to any portion of the instruction for which a grade or report is assigned (e.g., reading, composition, spelling, and language arts).	M	Course.name	Scheduling > Course > Name
numberOfParts	The number of parts identified for a course. The number in the SCED Sequence Part N field is reported. This field reports a default value of 1 for all courses.	M	course.sced SequenceNum	Defaults to 1 for all courses
academicSubject Descriptor	The intended major subject area of the course. This field is optional and does not report.	O	Data is preloaded by Arizona	Data is preloaded by Arizona
description	A description of the content standards and goals covered in the course. Reference may be made to state or national content standards.	O	Data is preloaded by Arizona	Data is preloaded by Arizona
dateCourseAdopted	The date the district adopted the course.	O	Data is preloaded by Arizona	Data is preloaded by Arizona
highSchoolCourse Requirement	An indication that this course credit is required for a high school diploma.	O	Data is preloaded by Arizona	Data is preloaded by Arizona
gpaApplicability Type	An indicator of whether or not this course being described is included in the computation of the student’s Grade Point Average, and if so, if it is weighted differently from regular courses.	O	Data is preloaded by Arizona	Data is preloaded by Arizona
definedByType	Specifies whether the course was defined by the SEA, LEA, school or national organization.	O	Data is preloaded by Arizona	Data is preloaded by Arizona
minimumAvailable CreditType	The type of credits or units of value awarded for the completion of a course.	O	Data is preloaded by Arizona	Data is preloaded by Arizona
minimumAvailable CreditConversion	Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units.	O	Data is preloaded by Arizona	Data is preloaded by Arizona
minimumAvailable Credit	The minimum amount of credit available to a student who successfully completes the course.	O	Data is preloaded by Arizona	Data is preloaded by Arizona
maximumAvailable CreditType	The type of credits or units of value awarded for the completion of a course.	O	Data is preloaded by Arizona	Data is preloaded by Arizona
maximumAvailable CreditConversion	Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units.	O	Data is preloaded by Arizona	Data is preloaded by Arizona
maximumAvailable Credit	The maximum amount of credit available to a student who successfully completes the course.	O	Data is preloaded by Arizona	Data is preloaded by Arizona
careerPathwayType	The career cluster or pathway representing the career path of the Vocational/CTE concentrator.	O	Data is preloaded by Arizona	Data is preloaded by Arizona
timeRequired ForCompletion	The actual or estimated number of clock minutes required for class completion. This number is especially important for career and technical education classes and may represent (in minutes) the clock hour requirement of the class.	O	Data is preloaded by Arizona	Data is preloaded by Arizona
competencyLevels	An unordered collection of courseCompetencyLevels. This educational entity represents the organization of subject matter and related learning experiences provided for the instruction of students on a regular or systematic basis.	O	Data is preloaded by Arizona	Data is preloaded by Arizona
gradeLevels	An unordered collection of courseGradeLevels. This educational entity represents the organization of subject matter and related learning experiences provided for the instruction of students on a regular or systematic basis.	O	Data is preloaded by Arizona	Data is preloaded by Arizona
IdentificationCodes	An unordered collection of courseIdentificationCodes. This educational entity represents the organization of subject matter and related learning experiences provided for the instruction of students on a regular or systematic basis.	O	Data is preloaded by Arizona	Data is preloaded by Arizona
learningObjectives	An unordered collection of courseLearningObjectives. This educational entity represents the organization of subject matter and related learning experiences provided for the instruction of students on a regular or systematic basis.	O	Data is preloaded by Arizona	Data is preloaded by Arizona
learningStandards	An unordered collection of courseLearningStandards. This educational entity represents the organization of subject matter and related learning experiences provided for the instruction of students on a regular or systematic basis.	O	Data is preloaded by ArizonaData	Data is preloaded by Arizona
levelCharacteristics	An unordered collection of courseLevelCharacteristics. This educational entity represents the organization of subject matter and related learning experiences provided for the instruction of students on a regular or systematic basis.	O	Data is preloaded by Arizona	Data is preloaded by Arizona
etag	A unique system-generated value that identifies the version of the resource.	O	N/A	N/A

Grading Periods

This entity represents the time span for which grades are reported; Quarter, Semester, Final, etc. The Start and End dates must have a calendar event in the Calendar Dates resource before Grading Periods can send. Users need to perform a day reset prior to filling out the Grading Periods tab.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	When a new Grading Period is created and saved on the Grading Periods tab. Do not send records if the Calendar Exclude checkbox is checked. Do not send if the School is marked as Exclude. If the start date on an existing Grading Period is changed, the "old" record will remain in Ed-Fi and a new record will post with the new date.
Put	When the Grading Period End Date is updated and saved.
Delete	Grading Periods cannot be deleted due to the dependency of the core Ed-Fi model where it is required for Sessions to report grading periods.

Action

Trigger

Post

When a new Grading Period is created and saved on the Grading Periods tab.

Do not send records if the Calendar Exclude checkbox is checked.
Do not send if the School is marked as Exclude.
If the start date on an existing Grading Period is changed, the "old" record will remain in Ed-Fi and a new record will post with the new date.

Put

When the Grading Period End Date is updated and saved.

Delete

Grading Periods cannot be deleted due to the dependency of the core Ed-Fi model where it is required for Sessions to report grading periods.

Scope Year Logic

This table describes scope year logic of this object.

Logic
Reports the grading periods in the scope year to which the calendar is aligned. Data will only send for the years that have valid configuration. Future Years data will be suppressed until the Active Year is changed: This allows the Schedule Wizard to be used and reduces the number of records sent until the final schedule is completed. A resync must be done after the Active Year is changed to send data.

Logic

Reports the grading periods in the scope year to which the calendar is aligned.

Data will only send for the years that have valid configuration.
Future Years data will be suppressed until the Active Year is changed:
- This allows the Schedule Wizard to be used and reduces the number of records sent until the final schedule is completed.
- A resync must be done after the Active Year is changed to send data.

Object Data Elements

This table describes data elements sent within the Grading Periods resource.

Data Element	Description		Campus Database Field	Campus GUI Location
id	The unique identifier of the resource.	M	N/A	N/A
schoolReference	Reports the Natural Key for the Schools resource the grading period is aligned to.	M	N/A	N/A
beginDate	The start date of the grading period. Report the start date from the Grading Period being reported: If there is more than 1 calendar or schedule structure, report a record for each Grading Period & Start Date Combination. The date entered must be an Instructional day on the Days tab.	M	edfigradingperiod.startDate	System Administration > Calendar > Calendar > Ed-Fi Grading Periods > Grading Period Start Date
endDate	The end date of the grading period. Report the end date from the Grading Period being reported: If there is more than 1 calendar or schedule structure, report the latest end date. The date entered must be an Instructional day on the Days tab.	M	edfigradingperiod.endDate	System Administration > Calendar > Calendar > Ed-Fi Grading Periods > Grading Period End Date
descriptor	The name of the grading period. See the Grading Period Descriptor table in the Type/Descriptor section below. Report the code value from the Grading Period Name selected.	M	edfigradingperiod.name	System Administration > Calendar > Calendar > Ed-Fi Grading Periods > Grading Period Name
totalInstructionalDays	The total number of instructional days in the grading period. Count the number of instructional days on the Days tab that occur during the start and end date for the grading period. If there is more than 1 calendar or schedule structure, report the distinct number of instructional days from all calendars/schedule structures. Instructional days will not send an update if changed after original post unless a resync is completed.	M	N/A	System Administration > Calendar > Calendar >Days
periodSequence	The sequence of the grading period. Report the Sequence from the term the Grading Period being reported is aligned. If the same Grading Period is aligned to different Terms, report the earliest Term Sequence.	O	N/A	System Administration> Calendar> Terms> Sequence
_etag	N/A	O	N/A	N/A

Type/Descriptors

The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Grading Period Descriptors Type:

Ed-Fi Code Value	Ed-Fi Short Description	Ed-Fi Description
End of Year	End of Year	End of Year
Fifth Six Weeks	Fifth Six Weeks	Fifth Six Weeks
First Nine Weeks	First Nine Weeks	First Nine Weeks
First Semester	First Semester	First Semester
First Six Weeks	First Six Weeks	First Six Weeks
First Summer Session	First Summer Session	First Summer Session
First Trimester	First Trimester	First Trimester
Fourth Nine Weeks	Fourth Nine Weeks	Fourth Nine Weeks
Fourth Six Weeks	Fourth Six Weeks	Fourth Six Weeks
Second Nine Weeks	Second Nine Weeks	Second Nine Weeks
Second Semester	Second Semester	Second Semester
Second Six Weeks	Second Six Weeks	Second Six Weeks
Second Summer Session	Second Summer Session	Second Summer Session
Second Trimester	Second Trimester	Second Trimester
Sixth Six Weeks	Sixth Six Weeks	Sixth Six Weeks
Summer Semester	Summer Semester	Summer Semester
Third Nine Weeks	Third Nine Weeks	Third Nine Weeks
Third Six Weeks	Third Six Weeks	Third Six Weeks
Third Six Weeks	Third Summer Session	Third Summer Session
Third Trimester	Third Trimester	Third Trimester

Local Education Agency

This entity represents an administrative unit at the local level, which exists primarily to operate schools or to contract for educational services. It includes school districts, charter schools, charter management organizations or other local administrative organizations.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

LEA is preloaded to Ed-Fi so there is no trigger logic necessary at this time.

Scope Year Logic

This table describes the scope year logic of this object.

Action
Districts are not aligned to a year so all Districts will send to each scoped year.
Data will only send for the years that have valid configuration.
A resync must be completed on the resource when a new scope year is connected in order for this data to send.

Object Data Elements

This table describes data elements sent within the Local Education Agency resource.

At this time, only localEducationAgencyId is reported. All other elements are not reported.

Data Element	Description		Campus Database Field	Campus GUI Location
id	The unique identifier of the resource.	M	N/A	N/A
educationService CenterReference	A reference to the related EducationServiceCenter resource.	O	N/A	N/A
stateEducation AgencyReference	A reference to the related StateEducationAgency resource.	O	N/A	N/A
localEducation AgencyId	The Local Educational Organization. If the District Entity ID is populated on the School editor, this value is reported. If not, the District Entity ID on the District editor is reported.	M	Customschool.value Customdistrict.value	System Administration > Resources > District Information > Entity ID System Administration > Resources > School > School Detail > Entity ID
stateOrganizationId	The identifier assigned to an education agency by the State Education Agency (SEA). Also known as the State LEP ID. NEDM: IdentificationCode, LEA Identifier.	M	N/A	N/A
nameOfInstitution	The full, legally accepted name of the institution. NEDM: Name of Institution.	M	N/A	N/A
shortNameOfInstitution	N/A	O	N/A	N/A
webSite	N/A	O	N/A	N/A
operationalStatusType	N/A	O	N/A	N/A
parentLocalEducation AgencyId	N/A	O	N/A	N/A
categoryType	N/A	M	N/A	N/A
addresses	N/A	O	N/A	N/A
educationOrganization Categories	N/A	O	N/A	N/A
identificationCodes	N/A	O	N/A	N/A
institutionTelephones	N/A	O	N/A	N/A
internationalAddresses	N/A	O	N/A	N/A
accountabilities	N/A	O	N/A	N/A
etag	N/A	O	N/A	N/A

Locations

This entity represents the physical space where students gather for a particular class/section. The location may be an indoor or outdoor area designated for the purpose of meeting the educational needs of students.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	When a new Room is created and saved. Do not send if the School is marked as Exclude.
Post	When a Room Name is changed and saved.
Put	When the Maximum Number Of Seats is modified.
Delete	When a Room Name is changed and saved.
Delete	When a Room is deleted.

Scope Year Logic

This table describes scope year logic of this object.

Logic
Rooms are not aligned to a year so all Rooms will send to each scoped year.
Data will only send for the years that have valid configuration.
A resync must be completed on the Locations resource when a new scope year is connected in order for this data to send.

Object Data Elements

This table describes data elements sent within the Locations resource.

Data Element	Description		Campus Database Field	Campus GUI Location
id	The unique identifier of the resource.	M	N/A	N/A
schoolReference	Reports the following elements that are part of the Natural Key for the School resource: EntityID	M	School.entityID	System Administration > Resources > School > EntityID
classroom IdentificationCode	A unique number or alphanumeric code assigned to a room by a school, school system, state, or other agency or entity.	M	Room.name	System Administration > Resources > Resources > Rooms > Name
maximumNumber OfSeats	The maximum number of seats the class can maintain. The value in the Capacity field is reported.	O	Room.capacity	System Administration > Resources > Resources > Rooms > Capacity
optimalNumber OfSeats	The number of seats that is most favorable to the class. This field is not collected or reported.	O	N/A	N/A
etag	A unique system-generated value that identifies the version of the resource.	O	N/A	N/A

Parents

This entity represents a parent or guardian of a student, such as mother, father or caretaker.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

All optional data has been removed from core logic.

Action	Trigger
Post	When the Guardian check box is checked AND 1 person is a student and 1 person is not a student. The guardian does NOT have to be a member of the same household as the student to report. Start date must be on or before today's date. Person must have an Ed-Fi ID to send. A record will not send if the student they are associated with has an enrollment marked as a no show, state exclude or enrollment is in a calendar or school marked as Exclude. Do not send a record if the Student has an enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY! If there is one active guardian record, report that record. If multiple active guardian records, report the one with the latest Start Date. If Start Dates are NULL or the same, look at the End Date, and report the latest End Date (or if 1 is NULL and the other is not, report the <>NULL guardian). If both Start Dates & End Dates are NULL or the same, then it will choose the guardian with the highest PersonID. If there are no active guardian records, report the inactive guardian record with the latest start date.
Put	A record will be updated when any of the following are changed and saved: When the person’s identity record is changed. When one of the person’s household locations is changed. When one of the person’s household memberships is changed. When one of the person’s relationships that is marked Guardian is changed.
Delete	A Parent record is a shared resource among all districts in the state and cannot be deleted. When the Student Parent Association is removed, the district will no longer have authorization to see the parent record.

Action

Trigger

Post

When the Guardian check box is checked AND 1 person is a student and 1 person is not a student.

The guardian does NOT have to be a member of the same household as the student to report.
Start date must be on or before today's date.
Person must have an Ed-Fi ID to send.
A record will not send if the student they are associated with has an enrollment marked as a no show, state exclude or enrollment is in a calendar or school marked as Exclude.
Do not send a record if the Student has an enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY!
If there is one active guardian record, report that record.
If multiple active guardian records, report the one with the latest Start Date.
If Start Dates are NULL or the same, look at the End Date, and report the latest End Date (or if 1 is NULL and the other is not, report the <>NULL guardian).
If both Start Dates & End Dates are NULL or the same, then it will choose the guardian with the highest PersonID.
If there are no active guardian records, report the inactive guardian record with the latest start date.

Put

A record will be updated when any of the following are changed and saved:

When the person’s identity record is changed.
When one of the person’s household locations is changed.
When one of the person’s household memberships is changed.
When one of the person’s relationships that is marked Guardian is changed.

Delete

A Parent record is a shared resource among all districts in the state and cannot be deleted. When the Student Parent Association is removed, the district will no longer have authorization to see the parent record.

Scope Year Logic

This table describes scope year logic of this object.

Logic
A parent record will report when they are a guardian to a student with an enrollment aligned to a scoped year. The related pair start date must be null or on/before the scope year end date to report. The related pair end date must be null or on/after the scope year end date to report. Data will only send for the years that have valid configuration. A resync must be completed on the Parents resource when a new scope year is connected in order for this data to send.
When using data in Campus that has an effective date, the following logic will be applied to determine the scope year(s) to report the data to. Current Year: Records will be compared to today's date to determine if the record is eligible to report. Previous Years: The record's date must be on or before the schools year's end date defined in the School Years editor. If blank, the default date of 6/30/xxxx is used. Future Years: The record's date must be on or after the schools year's start date defined in the School Years editor. If blank, the default date of 7/01/xxxx is used.
When using data in Campus that have start and end dates, the following logic will be applied to determine the scope year(s) to report the data to. Current Year: The records start date must be on or before today's date and the records end date must be on or after today's date. Previous Years: The record's start date must be on or before the school year's end date and the record's end date must be after the school year's end date defined in the School Years editor. If blank, the default date of 6/30/xxxx is used. Future Years: The record's start date must be on or before the schools year's start date and the record's end date must be on or after the school year's start date defined in the School Years editor. If blank, the default date of 7/01/xxxx is used.

Logic

A parent record will report when they are a guardian to a student with an enrollment aligned to a scoped year.

The related pair start date must be null or on/before the scope year end date to report.
The related pair end date must be null or on/after the scope year end date to report.
Data will only send for the years that have valid configuration.
A resync must be completed on the Parents resource when a new scope year is connected in order for this data to send.

When using data in Campus that has an effective date, the following logic will be applied to determine the scope year(s) to report the data to.

Current Year: Records will be compared to today's date to determine if the record is eligible to report.
Previous Years: The record's date must be on or before the schools year's end date defined in the School Years editor. If blank, the default date of 6/30/xxxx is used.
Future Years: The record's date must be on or after the schools year's start date defined in the School Years editor. If blank, the default date of 7/01/xxxx is used.

When using data in Campus that have start and end dates, the following logic will be applied to determine the scope year(s) to report the data to.

Current Year: The records start date must be on or before today's date and the records end date must be on or after today's date.
Previous Years: The record's start date must be on or before the school year's end date and the record's end date must be after the school year's end date defined in the School Years editor. If blank, the default date of 6/30/xxxx is used.
Future Years: The record's start date must be on or before the schools year's start date and the record's end date must be on or after the school year's start date defined in the School Years editor. If blank, the default date of 7/01/xxxx is used.

Object Data Elements

This table describes data elements sent within the Parents resource.

Data Element	Description		Campus Database Field	Campus GUI Location
id	The unique identifier of the resource.	M	N/A	N/A
parentUniqueId	A parent's Ed-Fi ID is reported.	M	Person.edFiId	Census > People > Demographics > EdFi ID
personalTitlePrefix	A prefix used to denote the title, degree, position or seniority of the person. This element is not collected or reported.	C	N/A	N/A
firstName	The reporting parent's first name. This is reported from the person's most recent identity record.	M	Identity.firstName	Census > People > Identities > First Name
middleName	The reporting parent's middle name. This is reported from the person's most recent identity record. This element is not reported.	C	Identity.middleName	Census > People > Identities > Middle Name
lastSurname	The reporting parent's last name. This is reported from the person's most recent identity record.	M	Identity.lastName	Census > People > Identities > Last Name
generationCodeSuffix	An appendage, if any, used to denote an individual's generation in his family (e.g., Jr., Sr., III). This is reported from the person's most recent identity record. This element is not reported.	C	Identity.suffix	Census > People > Identities > Suffix
maidenName	The person's maiden name, if applicable. This element is not collected or reported.	O	N/A	N/A
sexType	A person's gender. This element is not reported.	O	N/A	N/A
loginId	The login ID for the user; used for security access control interface. This element is not collected or reported.	M	N/A	N/A
addresses	This element is not collected or reported.	O	N/A	N/A
employmentStatus	Indicates if the parent is employed. This element is not collected or reported.	O	N/A	N/A
identification Documents	Reports an unordered collection of the parent's identification documents. This element is not collected or reported..	O	N/A	N/A
international Addresses	Reports an unordered collection of the parent's international addresses. This element is not collected or reported.	O	N/A	N/A
otherNames	Reports an unordered collection of the parent's other known names (aliases). This field is optional and does not report.	O	N/A	N/A
telephones	An unordered collection of parentTelephones. This entity represents a parent or guardian of a student, such as mother, father or caretaker. This field is optional and does not report.	O	N/A	N/A
etag	A unique system-generated value that identifies the version of the resource.	O	N/A	N/A

Programs

This entity represents any program designed to work in conjunction with, or as a supplement to, the main academic program. Programs may provide instruction, training, services or benefits through federal, state or local agencies. Programs may also include organized extracurricular activities for students.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Get	No Trigger, this is a look-up as programs are pre-loaded by DOE. When a program is created and saved for a student, it matches on the program in Ed-Fi.

Object Data Elements

This table describes data elements sent within the Programs resource.

Only the educationOrganizationReference, type and name elements are reported at this time.

Data Element	Description		Campus Database Field	Campus GUI Location
id	N/A	M	N/A	N/A
educationOrganization Reference	A reference to the related Education Organization resource. Report the SPED Service DOR Entity ID if populated on the IEP. If 'Funded SPED Service DOR' is NULL, report the 'District Entity ID' from the school the student is enrolled in. If school District Entity ID is not NULL, report that value. Else, report the District Entity ID for the district the student is enrolled.	M	Plan.spedResidentDistrict OR school.entityid OR customdistrict.attributeid	Student Information > General > SPED > Documents > Plan > Enrollments > Funded SPED Service DOR OR System Administration > Resources > School > District Entity ID OR System Administration > Resources > District Information > Entity ID
type	Reports the Program Type from the short description based on the program the student participates. Reports 'ELL' when an English Learners (EL) Service is created and saved for a student that is mapped to a state code. Reports 'SPED' when an IEP is created and locked for a student. Reports 'Support Program' when a Flag is created and saved for a student when it is mapped to a state code. Reports "Grand Canyon Diploma' when a Flag created and saved for a student when it is mapped to a state code = GCD. Reports "Dropout Recovery Program' when a Flag created and saved for a student when it is mapped to a state code = DRP.	M	LepService.type Enrollment. specialEdSetting ProgramParticipation. programId	Student Information > General > Program Participation > English Learners (EL) > EL Services > Service Type Student Information > General > Enrollment > Special Ed Fields > Special Ed Setting Student Information > General > Flags
name	The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies. For ELL, the program name is determined based on the Service that is saved for the student. For SPED, the program name is determined based on the SPED Setting selected for the student. For Support Programs, the program name is determined based on the State Code the flag is Mapped to.	M	LepServiceType.code + LepServiceType.name Enrollment. specialEdSetting	Program Admin > English Learners (EL) > EL Setup > State Service Type Student Information > General > Enrollment > Special Ed Fields > Special Ed Setting Programs > Flags > State Program Code
sponsorType	N/A	O	N/A	N/A
characteristics	N/A	O	N/A	N/A
learningObjectives	N/A	O	N/A	N/A
learningStandards	N/A	O	N/A	N/A
services	N/A	O	N/A	N/A
etag	N/A	O	N/A	N/A

Schools

This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Get	No Trigger, this is a look-up as schools are pre-loaded by DOE. When a new school is created and saved, it matches on the State School Number to determine reporting school.

Object Data Elements

This table describes data elements sent within the Schools resource.

At this time, only schoolId is reported. All other elements are not reported.

Data Element	Description		Campus Database Field	Campus GUI Location
id	N/A	M	N/A	N/A
localEducation AgencyReference	N/A	O	N/A	N/A
schoolId	Indicates the School Entity ID. Districts must populate a valid Ed-Fi School ID in the Entity ID field on the School editor for data to send to Ed-Fi. If this field is blank, data will not send.	M	School.entityId	System Administration > Resources > School > Entity ID
stateOrganizationId	N/A	M	N/A	N/A
nameOfInstitution	N/A	M	N/A	N/A
shortNameOfInstitution	N/A	O	N/A	N/A
webSite	N/A	O	N/A	N/A
operationalStatus Type	N/A	O	N/A	N/A
type	N/A	O	N/A	N/A
charterStatusType	N/A	O	N/A	N/A
titleIPartASchool DesignationType	N/A	O	N/A	N/A
magnetSpecialProgram EmphasisSchoolType	N/A	O	N/A	N/A
administrativeFunding ControlDescriptor	N/A	O	N/A	N/A
internetAccessType	N/A	O	N/A	N/A
addresses	N/A	O	N/A	N/A
educationOrganization Categories	N/A	O	N/A	N/A
identificationCodes	N/A	O	N/A	N/A
institutionTelephones	N/A	O	N/A	N/A
internationalAddresses	N/A	O	N/A	N/A
schoolCategories	N/A	O	N/A	N/A
gradeLevels	N/A	O	N/A	N/A
etag	N/A	O	N/A	N/A

Section

This educational entity represents a setting in which organized instruction of course content is provided to one or more students for a given period of time. A course may be offered to more than one class/section. Instruction, provided by one or more teachers or other staff members, may be delivered in person or via a different medium.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	When a section is created and saved. Room and Section Placement are required in order for the section to send. 1 record will report for each Section, Term Type, Class Period combination. Do not send records if the Calendar Exclude check box is checked. Do not send records if the course is marked inactive or State Exclude. Do not send if the School Exclude check box is checked.
Post	When Section Placement is changed and saved on a section.
Post	When the Local Course Number or Term type Override is changed.
Put	When any fields listed below are changed: When the local course name, attendance, unit attendance or SCED Seq Number is changed and saved on the Course editor. When the Room or Instructional Setting is changed and saved on a section. When the Credit field is changed and saved on a Grading Task assigned to the course. When an External Provider Teacher is added/changed/removed from Staff History Send a put when the Roster is changed for Grade Levels.
Delete	When a section is deleted.
Delete	When a section schedule placement is removed and saved.
Delete	When the Local Course Number or Term type Override is changed.

This resource will not push data for Courses marked as Inactive or State Exclude.

Scope Year Logic

This table describes scope year logic of this object.

Logic
Reports Sections in the scope year the course's calendar is aligned to.
Data will only send for the years that have valid configuration.
Future Years data will be suppressed until the Active Year is changed: This allows the Schedule Wizard to be used and reducing the number of records sent until the final schedule is completed. A resync must be done after the Active Year is changed to send data.

Logic

Reports Sections in the scope year the course's calendar is aligned to.

Data will only send for the years that have valid configuration.

Future Years data will be suppressed until the Active Year is changed:

This allows the Schedule Wizard to be used and reducing the number of records sent until the final schedule is completed.
A resync must be done after the Active Year is changed to send data.

Object Data Elements

This table describes data elements sent within the Section resource.

Data Element	Description			Campus Database Field	Campus GUI Location
id	The unique identifier of the resource.		M	N/A	N/A
classPeriodReference	Reports the following elements that are part of the Natural Key for the Class Periods resource: id name		M	N/A	N/A
courseOfferingReference	Reports the following elements that are part of the Natural Key for the Course Offering resource: schoolReference sessionReference localCourseCode		M	N/A	N/A
locationReference	Reports the following elements that are part of the Natural Key for the Locations resource: schoolReference classroomIdentificationCode		M	N/A	N/A
schoolReference	Reports the following elements that are part of the Natural Key for the School resource: EntityID		M	N/A	N/A
sessionReference	Reports the following elements that are part of the Natural Key for the Sessions resource: id schoolReference schoolYearTypeReference termType name		M	N/A	N/A
uniqueSectionCode	A unique identifier for the section, that is defined for a campus by the classroom, the subjects taught, and the instructors that are assigned. This element reports the section ID of the section being reported.		M	N/A	N/A
sequenceOfCourse	When a section is part of a sequence of parts for a course, the number if the sequence is reported. If the course has only onle part, the value of this section attribute should be 1 The value in the SCED Sequence Part N field is reported. If null, a value of 1 is reported		M	N/A	N/a
educationalEnvironment Type	The setting in which a child receives education and related services. For example, Center-based instruction Home-based instruction, Hospital class, Mainstream Residential care, treatment facility. Logic reports the Ed-Fi Code value from the Instructional Setting selected on the course section being reported.		O	Section. instructionalSetting	Scheduling > Course > Section > Instructional Setting
mediumOfInstructionType	The media through which teachers provide instruction to students and students and teachers communicate about instructional matters. This element is optional and does not report.		O	N/A	N/A
populationServedType	The population for which the course was designed for. This element is optional and does not report.		O	N/A	N/A
availableCreditType	The type of credits or units of value awarded for the completion of a course. This element is optional and does not report.		O	N/A	N/A
availableCredit Conversion	Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units. This element is optional and does not report.		O	N/A	N/A
instructionLanguage Descriptor	This element is optional and does not report.		O	N/A	N/A
availableCredit	Credits or units of value awarded for the completion of a course. Logic calculates this as follows: Sum the total number of credits from the Grading Tasks on the course. Divide by the number of terms the course section occurs.		O	GradingTaskCredit. Credit	Scheduling > Courses > Course > Grading Tasks > Credit
characteristics	This descriptor defines characteristics of a section, such as whether attendance is taken and the section is graded. This reports when the following are added: Report '01' when Attendance and/or Positive Attendance check box is checked on a course. Report '02' when a grading task is added and saved to a course (graded credit available).		O	GradingTaskCredit. Credit	Scheduling > Course > Attendance/Positive Attendance Scheduling > Course > Grading Tasks
programs	An unordered collection of sectionPrograms. This educational entity represents a setting in which organized instruction of course content is provided to one or more students for a given period of time. This element is optional and does not report.		O	N/A	N/A
etag	A unique system-generated value that identifies the version of the resource. This element is optional and does not report.		O	N/A	N/A
timetableDayIdentifier	The unique identifier for the locally defined rotation cycle date code when the class meets (e.g., in a two day schedule, valid values could be "A" and "B", or "1" and "2"). Always reports 'MTWRF'		O	N/A	N/A
courseCharacteristics	An unordered collection of CourseCharacteristics. This educational entity represents a setting in which organized instruction of course content is provided to one or more students for a given period of time. A course may be offered to more than one class/section. Instruction, provided by one or more teachers or other staff members, may be delivered in person or via a different medium. Reports when the following are added: CTE check box is checked on the course or section. Report if Dual Credit checkbox is checked on the course or section. Report from Level drop list if selected on course.		O	N/A	N/A
courseCharacteristics	courseLevelCharactersticType	The item for indication of the nature and difficulty of instruction: Remedial, Basic, Honors, AP, IB, Dual Credit, CTE, etc. Report the Short Description from the Course Level Characteristic Type page under Type/Descriptors below based on the mapping provided.	O	N/A	N/A
externalProviderTeachers	An unordered collection of sectionExternalProviderTeachers. This educational entity represents a setting in which organized instruction of course content is provided to one or more students for a given period of time. A course may be offered to more than one class/section. Instruction, provided by one or more teachers or other staff members, may be delivered in person or via a different medium. Reports when Section Staff assigned to section has an Assignment Code = EXPx. x = the district will create however many external providers they need and will number them as created. Ex: EXP1, EXP2 etc... x will be a different number for each external provider. Only report if the Assignment Code is selected for District Assignment in the school being reported and is active during which the course occurred. District Assignment start date must be before term end date of the section. District Assignment end date must be after the term start date of the section or NULL. If start and end dates are entered on the Staff History tab, District Assignment must also be valid within those dates.		O	N/A	N/A
	externalProviderName	The name of the External Provider (company/school name). Report the Name from the Assignment Code selected for that teacher.	M	EmploymentAssignment. assignmentcode	Census > People > District Assignments > Assignment Code
	providerTeacherLastName	The Last Name of the external provider. Report the last name from the person's current identity.	O	Identity.lastName	Census > People > Identities > Last Name
	providerTeacherFirstName	The First Name of the external provider. Report the first name from the person's current identity.	O	Identity.firstName	Census > People > Identities > First Name
	classroomPositionDescriptor	The role of the external provider. Report the code from the Role selected on the Section Staff History.	O	SectionStaffHistory.role	Scheduling > Course > Section > Staff History > Role
	beginDate	The start date the external provider was associated with the section. Report the start date from the Section Staff History. If blank, report the earliest term start date based on the section schedule placement.	O	SectionStaffHistory. startdate	Scheduling > Course > Section > Staff History > Start Date
	endDate	The end date the external provider was no longer associated with the section. Report the end date from the Section Staff History. If blank, report the latest term end date based on the section schedule placement	O	SectionStaffHistory. enddate	Scheduling > Course > Section > Staff History > End Date
gradeLevels	An unordered collection of sectionGradeLevels. This educational entity represents a setting in which organized instruction of course content is provided to one or more students for a given period of time. A course may be offered to more than one class/section. Instruction, provided by one or more teachers or other staff members, may be delivered in person or via a different medium. Reports the lowest and the highest grade level of students scheduled in the course section. All students are considered regardless of rosters start or end date. If a student changes grade levels either by updating grade on enrollment or creating a new enrollment this will not trigger a change on section. A resync would need to be done on section to update this field. If a grade level is marked as State Exclude in the Calendar > Grade Levels tab, those grade levels are excluded from consideration/inclusion of this endpoint.		O	N/A	Course > Section > Roster

Type/Descriptor

This table describes the Ed-Fi Value mapped and reported for Course Level Characteristic Descriptor:

Campus Code	Campus Name	Campus Path	Ed-Fi Code Value	Ed-Fi Short Description	Ed-Fi Description
HS	High School Equivalent	Scheduling > Course > Level	Accepted as high school equivalent	Accepted as high school equivalent	Accepted as high school equivalent
AD	Enriched or Advanced	Scheduling > Course > Level	Advanced	Advanced	Advanced
AD	Enriched or Advanced	Scheduling > Course > Level	Advanced Placement	Advanced Placement	Advanced Placement
BA	Basic	Scheduling > Course > Level	Basic	Basic	Basic
			Core Subject	Core Subject	Core Subject
			Correspondence	Correspondence	Correspondence
		Scheduling > Course > CTE or Scheduling > Course > Section > CTE	Career and Technical Education	Career and Technical Education	Career and Technical Education
			Distance Learning	Distance Learning	Distance Learning
		Scheduling > Course > Dual Credit	Dual Credit	Dual Credit	Dual Credit
GN	General or Regular	Scheduling > Course > Level	General	General	General
GT	Gifted or Talented	Scheduling > Course > Level	Gifted and Talented	Gifted and Talented	Gifted and Talented
GT	Gifted or Talented	Scheduling > Course > Level	Graduation Credit	Graduation Credit	Graduation Credit
HO	Honors	Scheduling > Course > Level	Honors	Honors	Honors
			International Baccalaureate	International Baccalaureate	International Baccalaureate
			Magnet	Magnet	Magnet
			Pre-AP	Pre-AP	Pre-AP
			Pre-IB	Pre-IB	Pre-IB
RM	Remedial	Scheduling > Course > Level	Remedial	Remedial	Remedial
UN	Untracked	Scheduling > Course > Level	Untracked	Untracked	Untracked
CL	College Level	Scheduling > Course > Level	College-level	College-level	College-level

Sessions

This entity represents the prescribed span of time when an education institution is open, instruction is provided and students are under the direction and guidance of teachers and/or education institution administration. A session may be interrupted by one or more vacations.

In order to report properly, the Ed-Fi Term Type field needs to be populated on the Calendar Term Detail editor. This ties the Course Section to the Term. If the Course Section needs to use a different term type, the Ed-Fi Term Type Override field needs to be populated on the Course Section Editor.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	When a new Term Schedule is created and mapped to a Term Type and a resync of Sessions is completed. If the same Term Type is selected on multiple Terms, group the Terms together so only 1 record will report per Term Type. If there are multiple Calendars or Schedule structures in a School with the same Term Types, only 1 record can report to Ed-Fi. Report the earliest Term Start Date and latest Term End Date. Do not send records if the Calendar Exclude check box is checked. Do not send if the School is marked as Exclude.
Post	When a Term Descriptor Override is selected on a Course or Section and saved and the course is mapped to a Term Descriptor Override and a resync of Sessions is completed. The Session will report the start and end dates based on the mapping of the course section. .If the same Term Type is selected in the Terms tab and the Term Type Override, a record will not send from the override field. Do not send records if the Calendar Exclude check box is checked or Course is marked as Inactive or Exclude.
Put	When the Grading Period, Term Name, start or end dates are changed and saved. The term dates can change either on the Terms tab or by changing Section Schedule Placement on a section.
Delete	Terms are never deleted; they are only used as a reference. They remain if a Term Schedule is deleted or Term Types are changed.

Scope Year Logic

This table describes scope year logic of this object.

Logic
Reports Sessions for the scope year the calendar is aligned to.
Data will only send for the years that have valid configuration.
Future Years data will be suppressed until the Active Year is changed: This allows the Schedule Wizard to be used and reducing the number of records sent until the final schedule is completed. A resync must be done after the Active Year is changed to send data.

Logic

Reports Sessions for the scope year the calendar is aligned to.

Data will only send for the years that have valid configuration.

Future Years data will be suppressed until the Active Year is changed:

This allows the Schedule Wizard to be used and reducing the number of records sent until the final schedule is completed.
A resync must be done after the Active Year is changed to send data.

Object Data Elements

This table describes data elements sent within the Sessions resource.

Data Element	Description		Campus Database Field	Campus GUI Location
id	The unique identifier of the resource.	M	N/A	N/A
schoolReference	Reports the following elements that are part of the Natural Key for the School resource: EntityID	M	N/A	N/A
schoolYearTypeReference	A reference to the related SchoolYearType resource. This element reports the End year from the calendar term reported.	M	N/A	N/A
Session Type Descriptor	Localized way to define the Term Type for Arizona. This element reports the Ed-Fi Code value based on the mapping provided in the Session Type Descriptor mapping provided below: Report the corresponding Term Type Descriptor based on the Term Type that is selected on the Terms tab or the Term Type Override field.	O	N/A	System Administration> Calendar> Calendar> Terms> Term Type OR Scheduling> Course or Section> Term Type Override
termType	The term for the session during the school year. This element reports the corresponding Term Type based on the sum of total terms in the term schedule and the sequence of the terms being reported. This element reports the Ed-Fi Code value based on the mapping provided in the Term Type mapping provided below:	M	Term.edfiType	System Administration > Calendar > Calendar > Terms > Term Type
name	The identifier for the calendar for the academic session. This element reports the Schedule Structure + Term Name with a - separating the names (e.g., Main - Term 1).	M	Term.edfiTypeName	System Administration > Calendar > Calendar > Terms > Term Type Name
termDescriptor	When reporting from Term Descriptors mapping, report the Ed-Fi Code for the value selected. When Ed-Fi Term Type = Null, or when no Ed-Fi code exists, do not report. When reporting from the Term Descriptor Overrides, report the Ed-Fi code value selected.
beginDate	The term start date. This element reports the start date of the term being reported. When reporting from a Term Schedule, report the start date of the term being reported. If more than 1 term has the same Term Type selected, report the earliest start date. When reporting from a Term Type Override on a section: Report the start date from the mapping the course is aligned to.	M	Term.startDate	System Administration > Calendar > Calendar > Terms > Start Date
endDate	The term end date. This element reports the end date of the term being reported. When reporting from a Term Schedule, report the end date of the term being reported. If more than 1 term has the same Term Type selected, use the latest end date. When reporting from a Term Type Override on a section: Report the end date from the mapping the course is aligned to.	M	Term.endDate	System Administration > Calendar > Calendar > Terms > End Date
totalInstructionalDays	This element reports the total number of instructional days from the Days tab from the calendar and schedule structure the term is associated with. A day reset must be completed before the days will calculate. Use the resync function of Ed-Fi Tools to have instructional days calculated and sent.	M	N/A	N/A
academicWeeks	An unordered collection of sessionAcademicWeeks.	O	N/A	N/A
gradingPeriods	An unordered collection of sessionGradingPeriods. This is not reported in Arizona	O	N/A	N/A
etag	A unique system-generated value that identifies the version of the resource.	O	N/A	N/A

Type/Descriptor

This table describes the Ed-Fi Value mapped and reported for Session Type Descriptor:

Term Type	Ed-Fi Code Value	Ed-FI Short Description	Ed-Fi Description
Full School Year	FS	Full School Year	Full School Year
Spring Semester, Fall Semester or Summer Semester	SE	Semester	Semester
First Trimester, Second Trimester or Third Trimester	TR	Trimester	Trimester
First Quarter, Second Quarter, Third Quarter or Fourth Quarter	QR	Quarter	Quarter
First Quinmester, Second Quinmester, Third Quinmester, Fourth Quinmester, Fifth Quinmester	QN	Quinmester	Quinmester
Year Round	12	Twelve Month	Twelve Month
Any other number of terms not = to one above	XX	Other	Other

The following types do not report as they do not have clear definitions on how to determine them based on the term/sequence combination:

ST: Summer Term
IN: Intersession
LS: Long Session
MT: Mini Term
12: Twelve Month

This table describes the Ed-Fi Value mapped and reported for Term Type :

Ed-Fi Code Value	Ed-Fi Short Description	Ed-Fi Description
Fall Semester	Fall Semester	Fall Semester
Spring Semester	Spring Semester	Spring Semester
First Trimester	First Trimester	First Trimester
Second Trimester	Second Trimester	Second Trimester
Third Trimester	Third Trimester	Third Trimester
First Quarter	First Quarter	First Quarter
Second Quarter	Second Quarter	Second Quarter
Third Quarter	Third Quarter	Third Quarter
Fourth Quarter	Fourth Quarter	Fourth Quarter
First Quinmester	First Quinmester	First Quinmester
Second Quinmester	Second Quinmester	Second Quinmester
Third Quinmester	Third Quinmester	Third Quinmester
Fourth Quinmester	Fourth Quinmester	Fourth Quinmester
Fifth Quinmester	Fifth Quinmester	Fifth Quinmester
Full School Year	Full School Year	Full School Year
Long Session	Long Session	Long Session
MiniTerm	MiniTerm	MiniTerm
Summer Semester	Summer Semester	Summer Semester
Year Round	Year Round	Year Round

Staff Education Organization Assignment Association

This association indicates the education organization to which a staff member provides services; also known as school of service.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	When a District Assignment record is created or changed and saved for a staff member. Do not send a record if the staff does not have an Ed-FI ID
Put	N/A, a delete and insert occurs when any field is edited and saved. When the person’s employment assignment record is changed
Post/Delete	When the Assignment Code, Start Date or End date is modified on the District Assignment record
Delete	When a District Assignment record is changed or deleted.

Scope Year Logic

This table describes scope year logic of this object.

Logic
A record will report when a person has a District Assignment record that is aligned to a scoped year. Report when a staff has an active District Assignment record that overlaps with the School year Start and End Dates. If School Year Start Date is NULL, 7/1/xxxx will be the default start date used. If School Year End Date is NULL, 6/30/xxxx will be the default end date used. Data will only send for the years that have valid configuration.
When using data in Campus that has an effective date, the following logic will be applied to determine the scope year(s) to report the data to. Current Year: Records will be compared to today's date to determine if the record is eligible to report. Previous Years: The record's date must be on or before the schools year's end date defined in the School Years editor. If blank, the default date of 6/30/xxxx is used. Future Years: The record's date must be on or after the schools year's start date defined in the School Years editor. If blank, the default date of 7/01/xxxx is used.

Logic

A record will report when a person has a District Assignment record that is aligned to a scoped year.

Report when a staff has an active District Assignment record that overlaps with the School year Start and End Dates.
- If School Year Start Date is NULL, 7/1/xxxx will be the default start date used.
- If School Year End Date is NULL, 6/30/xxxx will be the default end date used.
Data will only send for the years that have valid configuration.

When using data in Campus that has an effective date, the following logic will be applied to determine the scope year(s) to report the data to.

Current Year: Records will be compared to today's date to determine if the record is eligible to report.
Previous Years: The record's date must be on or before the schools year's end date defined in the School Years editor. If blank, the default date of 6/30/xxxx is used.
Future Years: The record's date must be on or after the schools year's start date defined in the School Years editor. If blank, the default date of 7/01/xxxx is used.

Object Data Elements

This table describes data elements sent within the Staff Education Organization Agreement Association resource.

Data Element	Description		Campus Database Field	Campus GUI Location
id	The unique identifier of the resource.	M	N/A	N/A
StaffEducationOrganization EmploymentAssociationReference	Reports the data that is part of the Natural Key for the Staff Education Organization Employment Association resource: educationOrganizationReference staffReference employmentStatusDescriptor hireDate	M	N/A	N/A
educationOrganizationReference	Reports the data that is part of the Natural Key for the Schools resource: EntityID Reports the school entity id from the District Assignment record being reported	M	N/A	N/A
staffReference	Reports the data that is part of the Natural Key for the Staff resource: staffUniqueId	M	N/A	N/A
staffClassificationDescriptor	The titles of employment, official status, or rank of education staff. This element reports the value in the Ed-Fi code field from the mapping for the Assignment Code droplist on the District Assignment. If field is blank or does not match a valid code, report 'Teacher' for Teacher. See the Staff Classification Descriptors table in the Type/Descriptor section below.	M	EmploymentAssignment. assignmentCode	Census > People > District Assignment > Assignment Code
beginDate	The month, day and year of the start or effective date of a staff member's employment, contract or relationship with the LEA. When reporting from the District Employment record, report the District Employment Start Date When reporting from the District Assignment record, report the District Assignment Start Date	M	EmploymentAssignment. startDate	Census > People > District Assignment > Start Date
positionTitle	The descriptive name of an individual's position. This field is optional and does not report.	O	N/A	N/A
endDate	The month, day and year of the end or termination date of a staff member's employment, contract or relationship with the LEA. When reporting from the District Employment record, report the District Employment End Date If NULL, do not report When reporting from the District Assignment record, report the District Assignment End Date If NULL, do not report	O	EmploymentAssignment. endDate	Census > People > District Assignment > End Date
orderOfAssignment	Describes whether the assignment is this the staff member's primary assignment, secondary assignment This field does not report	O	N/A	N/A
etag	A unique system-generated value that identifies the version of the resource.	O	N/A	N/A

Type/Descriptor

The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Staff Classification Descriptors:

The needs Data Dictionary is an unlocked list that is managed by the districts

To create a new or modify an existing Ed-Fi Org Title Code:

When Ed-Fi Org Title Code on District Employment is not null, a record will be sent for that employee
1. When Ed-Fi Org Title Code on District Employment is null, a record will not be sent for that employee

Field Logic :

When Ed-Fi Org Title's Standard code = 000, the educationOrganizationReference will report 000.
When Ed-Fi Org Title's Standard code = NA, the positiontitle will report blank.
1. Else, positiontitle will report the ED-Fi Short description which is the Name field in the data dictionary.

Ed-Fi Code Value	Short Description	Description
Counselor	Counselor	Counselor
Teacher	Teacher	Teacher
Other	Other	Other
Assistant Superintendent	Assistant Superintendent	Assistant Superintendent
Superintendent	Superintendent	Superintendent
LEA Administrator	LEA Administrator	LEA Administrator
School Administrator	School Administrator	School Administrator
School Specialist	School Specialist	School Specialist
LEA Specialist	LEA Specialist	LEA Specialist
Substitute Teacher	Substitute Teacher	Substitute Teacher
School Leader	School Leader	School Leader
Instructional Coordinator	Instructional Coordinator	Instructional Coordinator
Librarians/Media Specialists	Librarians/Media Specialists	Librarians/Media Specialists
Support Services Staff	Support Services Staff	Support Services Staff
Operational Support	Operational Support	Operational Support
Instructional Aide	Instructional Aide	Instructional Aide
State Administrator	State Administrator	State Administrator
Principal	Principal	Principal
Assistant Principal	Assistant Principal	Assistant Principal
LEA Systems Administrator	LEA Systems Administrator	LEA Systems Administrator

Staff Education Organization Employment Association

This association indicates the education organization an employee, contractor, volunteer or other service provider is formally associated with typically indicated by which organization the staff member has a services contract with or receives compensation from.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	When a District Assignment record is created or changed and saved for a staff member. Do not send a record if the person does not have an Ed-Fi ID
Put	N/A - A delete and insert occurs when any field is edited and saved.
Delete	When a District Assignment record is changed or deleted.

Action

Trigger

Post

When a District Assignment record is created or changed and saved for a staff member.

Do not send a record if the person does not have an Ed-Fi ID

Put

N/A - A delete and insert occurs when any field is edited and saved.

Delete

When a District Assignment record is changed or deleted.

Scope Year Logic

This table describes scope year logic of this object.

Logic

A record will report when a person has a District Assignment record that is aligned to a scoped year.

Report when a staff has an active District Assignment record that overlaps with the School year Start and End Dates.

If School Year Start Date is NULL, 7/1/xxxx will be the default start date used.
If School Year End Date is NULL, 6/30/xxxx will be the default end date used.

Data will only send for the years that have valid configuration.

Object Data Elements

This table describes data elements sent within the Staff Education Organization Employment Association resource.

Data Element	Description		Campus Database Field	Campus GUI Location
id	The unique identifier of the resource.	M	N/A	N/A
educationOrganization Reference	Reports the data that is part of the Natural Key for the Schools resource: EntityID	M	School.entityID	System Administration > Resources > School > Entity ID
staffReference	Reports the data that is part of the Natural Key for the Staff resource: staffUniqueId	M	N/A	N/A
employmentStatus Descriptor	This descriptor defines the type of employment or contract. When reporting from the District Employment record, report the mapped code from Employment Status. When reporting from District Assignment, report the mapped code from Type. If field is blank or does not match a valid code, report 'Tenured or permanent' for Tenured or permanent.	M	Employment assignment.type	Census > People > District Assignment > Type
hireDate	The month, day, and year on which a contract between an individual and a governing authority specifies that employment is to begin (or the date on which the agreement is made valid). When reporting from the District Employment record, report the District Employment Start Date When reporting from the District Assignment record, report the District Assignment Start Date	M	Employment assignment.startDate	Census > People > District Assignment > Start Date
endDate	The month, day, and year on which a contract between an individual and a governing authority ends or is terminated under the provisions of the contract (or the date on which the agreement is made invalid). When reporting from the District Employment record, report the District Employment End Date If NULL, do not report When reporting from the District Assignment record, report the District Assignment End Date If NULL, do not report	O	Employment assignment.endDate	Census > People > District Assignment > End Date
separationType	The type of employment separation (e.g., Voluntary separation, Involuntary separation, Mutual agreement, Other, etc). This is not collected within Campus and is not reported.	O	N/A	N/A
separationReason Descriptor	This descriptor defines the reasons for terminating the employment. This is not collected within Campus and is not reported.	O	N/A	N/A
department	The department or su-organization the employee/contractor is associated with in the Education Organization. This is not collected within Campus and is not reported.	O	N/A	N/A
fullTimeEquivalency	The ratio between the hours of work expected in a position and the hours of work normally expected in a full-time position in the same setting. This is not collected within Campus and is not reported.	O	N/A	N/A
offerDate	Date at which the staff member was made an official offer for this employment. This is not collected within Campus and is not reported.	O	N/A	N/A
hourlyWage	Hourly wage associated with the employment position being reported. This is not collected within Campus and is not reported.	O	N/A	N/A
etag	A unique system-generated value that identifies the version of the resource.	O	N/A	N/A

Type/Descriptor

The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Employment Status Descriptors:

Ed-Fi Code	Ed-Fi Short Description	Ed-Fi Description
Probationary	Probationary	Probationary
Contractual	Contractual	Contractual
Substitute/temporary	Substitute/temporary	Substitute/temporary
Tenured or permanent	Tenured or permanent	Tenured or permanent
Volunteer/no contract	Volunteer/no contract	Volunteer/no contract
Employed or affiliated with outside organization	Employed or affiliated with outside organization	Employed or affiliated with outside organization
Non-contractual	Non-contractual	Non-contractual
Employed part-time	Employed part-time	Employed part-time
Employed or affiliated with outside agency part-time	Employed or affiliated with outside agency part-time	Employed or affiliated with outside agency part-time
Other	Other	Other

Staff Section Association

This association indicates the course sections to which a student is assigned.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	When a staff is added to a course section on Staff History Must have a Staff Type of P: Primary Teacher or T: Teacher in the Section Staff History Table. Do not send records if the Calendar Exclude check box is checked Do not send a record if the Course is marked Inactive or Exclude Do not send a record if we have not sent a Staff record for this person Do not send a record if Course is in a school marked as exclude
Post	When a Role mapped to an Ed-Fi code is added to an existing teacher on the Staff History Record
Put	When Start or End dates are modified on the Staff History If the start or end dates are modified on the District Assignment record, an update will not occur. A resync must be completed to have all the records updated.
Delete	When a staff member is deleted from Staff History.

Scope Year Logic

This table describes scope year logic of this object.

Logic
Reports for Sections in the scope year the course's calendar is aligned to.
Data will only send for the years that have valid configuration.
Future Years data will be suppressed until the Active Year is changed: This allows the Schedule Wizard to be used and reducing the number of records sent until the final schedule is completed. A resync must be done after the Active Year is changed to send data.

Logic

Reports for Sections in the scope year the course's calendar is aligned to.

Data will only send for the years that have valid configuration.

Future Years data will be suppressed until the Active Year is changed:

This allows the Schedule Wizard to be used and reducing the number of records sent until the final schedule is completed.
A resync must be done after the Active Year is changed to send data.

Object Data Elements

This table describes data elements sent within the Staff Section Association resource.

Data Element	Description		Campus Database Field	Campus GUI Location
id	The unique identifier of the resource.	M	N/A	N/A
sectionReference	Reports the data that is part of the Natural Key for the Section resource: id classPeriodReference courseOfferingReference locationReference schoolReference sessionReference	M	N/A	N/A
staffReference	Reports the data that is part of the Natural Key for the Staff resource: staffUniqueId	M	N/A	N/A
classroomPosition Descriptor	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 value from the Role that is selected. Report default value is selected. If Role is NULL, report 'R'.	M	SectionStaffHistory.role	Course > Section > Staff History > Role
beginDate	The month, day and year of a teacher's assignment to the section. This element reports the Staff History Start Date, if populated. If blank, logic looks at the District Assignment record for the teacher for the School and reports the Assignment Start Date if it is on or after the lowest Term Start Date and on or before the highest Term End Date for the section. If District Assignment Start Date is prior to the lowest Term Start Date, report the lowest Term Start Date for that section.	M	SectionStaffHistory. startDate EmploymentAssignment. startDate Term.startDate	Course > Section > Staff History > Start Date Census > People > District Assignment > Start Date System Administration > Calendar > Calendar > Terms
endDate	The month, day and year of the last day of a teacher''s assignment to the section. This element reports the Staff History End Date, if populated. If Blank, look at the District Assignment record for the teacher for that School and report Assignment End Date if it is on or after the lowest Term Start Date and on or before the highest Term End Date for that section. Otherwise, report the Term End Date for that section.	O	SectionStaffHistory. endDate EmploymentAssignment. endDate	Course > Section > Staff History > End Date Census > People > District Assignment > End Date
highlyQualified Teacher	An indication of whether a teacher is classified as highly qualified for his/her assignment according to state definition. This field is optional and does not report.	O	N/A	N/A
teacherStudent DataLinkExclusion	This element indicates the student-section combination is excluded from calculation of value-added or growth attribution calculations used for a particular teacher evaluation. This field is optional and does not report.	O	N/A	N/A
percentage Contribution	The percentage of time the teacher is responsible for the student. This field is optional and does not report.	O	N/A	N/A
etag	A unique system-generated value that identifies the version of the resource.	O	N/A	N/A

Type/Descriptor

The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Classroom Position Descriptors:

Ed-Fi Code Value	Ed-Fi Short Description	Ed-Fi Description
1	Lead Team Teacher	Lead Team Teacher
2	Assisting Teacher	Assisting Teacher
A	Absent Teacher of Record	Absent Teacher of Record
C	Co-Teacher	Co-Teacher
L	Student Teacher	Student Teacher
P	Course Proctor	Course Proctor
R	Regular Class	Regular Class
S	Special Education Consultant	Special Education Consultant
U	Long Term Substitute	Long Term Substitute

Staff

This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action

Trigger

Post

When a District Assignment record is created and saved for a person.

Put

When any data is edited for the person in the Data Elements fields below.

When the person’s identity record is changed.
When the person’s employment assignment record is changed.
When the person’s employment record is changed.
When one of the person’s section staff history records is changed.
When one of the person’s employment credentials is changed.

Delete

Staff records are a shared resource among all districts, this record will not delete.

Scope Year Logic

This table describes scope year logic of this object.

Logic
A record will report when a person has a District Assignment record that is aligned to a scoped year.
Report when a staff has an active District Assignment record that overlaps with the School year Start and End Dates. If School Year Start Date is NULL, 7/1/xxxx will be the default start date used. If School Year End Date is NULL, 6/30/xxxx will be the default end date used.
Data will only send for the years that have valid configuration.
When using data in Campus that has an effective date, the following logic will be applied to determine the scope year(s) to report the data to. Current Year: Records will be compared to today's date to determine if the record is eligible to report. Previous Years: The record's date must be on or before the schools year's end date defined in the School Years editor. If blank, the default date of 6/30/xxxx is used. Future Years: The record's date must be on or after the schools year's start date defined in the School Years editor. If blank, the default date of 7/01/xxxx is used.
When using data in Campus that have start and end dates, the following logic will be applied to determine the scope year(s) to report the data to. Current Year: The records start date must be on or before today's date and the records end date must be on or after today's date. Previous Years: The record's start date must be on or before the school year's end date and the record's end date must be after the school year's end date defined in the School Years editor. If blank, the default date of 6/30/xxxx is used. Future Years: The record's start date must be on or before the schools year's start date and the record's end date must be on or after the school year's start date defined in the School Years editor. If blank, the default date of 7/01/xxxx is use.

Object Data Elements

This table describes data elements sent within the Staff resource.

Data Element	Description			Campus Database Field	Campus GUI Location
id	The unique identifier of the resource.		M	N/A	N/A
staffUniqueId	A unique alpha-numeric code assigned to a staff. The staff member's Ed-Fi ID is reported.		M	Census.edFiId	Census > People > Demographics > EdFi ID
personalTitlePrefix	A prefix used to denote the title, degree, position or seniority of the person. This element is currently not reported or collected.		C	N/A	N/A
firstName	The staff member's legal first name. The first name form the person's current identity record is reported.		M	Identity.firstName	Census > People > Identities > First Name
middleName	The staff member's legal middle name. The middle name form the person's current identity record is reported.		C	Identity. middleName	Census > People > Identities > Middle Name
lastSurname	The staff member's legal last name. The last name form the person's current identity record is reported.		M	Identity.lastName	Census > People > Identities > Last Name
generationCodeSuffix	An appendage, if any, used to denote an individual's generation in his family (e.g., Jr., Sr., III). The suffix form the person's current identity record is reported.		C	Identity.suffix	Census > People > Identities > Suffix
maidenName	The person''s maiden name, if applicable. This element is currently not reported or collected.		O	N/A	N/A
sexType	The person's gender.		M	Identity.gender	Census > People > Identities > Gender
birthDate	The month, day, and year on which an individual was born. The Birth Date from the person's current identity record is reported.		M	Identity.birthDate	Census > People > Identities > Birth Date
hispanicLatinoEthnicity	An indication that the individual traces his or her origin or descent to Mexico, Puerto Rico, Cuba, Central and South America, and other Spanish cultures, regardless of race. Report from "Is the individual Hispanic/Latino?" from the person's current identity: If droplist is = Yes, report "true" If droplist is = No or NULL, report "false"		M	Identity. hispanicEthnicity	Census > People > Identities > Is the individual Hispanic/Latino?
oldEthnicityType	Previous definition of Ethnicity combining Hispanic/latino and race 1 - American Indian or Alaskan Native 2 - Asian or Pacific Islander 3 - Black, not of Hispanic origin 4 - Hispanic 5 - White, not of Hispanic origin. This element is optional and does not report.		O	Identity. raceEthnicityFed	Historical data in Campus database
highestCompletedLevel OfEducationDescriptor	The highest level of completed for a staff member. The Education value from the person's Credentials tab is reported. Report the Ed-Fi Code value from from the person's Credentials tab when the Credential Type is = ED: Education If there is not a valid credential, report the Ed-Fi Code Value from Education droplist on the person's District Employment record If there is no Education record or the Ed-Fi code value is NULL, do not report.		O	N/A	Census > People > Credentials Census > People> District Employment
yearsOfPrior ProfessionalExperience	The total number of years that an individual has previously held a similar professional position in one or more education institutions. Do not report, this will be a localized element by state		O	N/A	N/A
yearsOfPrior TeachingExperience	The total number of years that an individual has previously held a teaching position in one or more education institutions. Do not report, this will be a localized element by state		O	N/A	N/A
highlyQualifiedTeacher	An indication of whether a teacher is classified as highly qualified for his/her assignment according to state definition. This attribute indicates the teacher is highly qualified for ALL sections being taught. This element reports True when the person has a Credential Type = HQ: Highly Qualified. Start date must be on or before today's date End date must be NULL, or on or after today's date This element reports False when the person is a teacher on any active course section and does not have an HQ: Highly Qualified Credential. If person is not a teacher, do not report a record. Scope Year logic is used to determine the Scope Year to post or update.		O	N/A	Census > People > Credentials
loginId	The login ID for the user; used for security access control interface. This element is currently not reported or collected.		O	N/A	N/A
citizenshipStatusType	A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. This element is currently not reported or collected.		O	N/A	N/A
addresses	Report the person's address(es). This element is optional and does not report.		O	N/A	N/A
credentials	An unordered collection of staffCredentials. This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion.		O	N/A	N/A
electronicMails	An unordered collection of staffElectronicMails. This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion. See the Electronic Mail table in the section below for the Ed-Fi value that is reported. This element is an array which also reports the following data:		O	Contact.email	Census > People > Demographics > Email Census> People> Demographics> Secondary Email
	electronicMailType	This element reports the Electric Mail mapping. The Email (primary) address reports as 'Work'. The Secondary Email address reports as 'Home/Personal'.	M	N/A	N/A
	electronicMailAddress	The numbers, letters, and symbols used to identify an electronic mail (e-mail) user within the network to which the individual or organization belongs.	M	Contact.email	Census > People > Demographics > Email Census> People> Demographics> Secondary Email
	primaryEmail AddressIndicator	An indication that the electronic mail address should be used as the principal electronic mail address for an individual or organization.	O	N/A	N/A
identificationCodes	An unordered collection of staffIdentificationCodes. This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion. This element is an array which also reports the following data:		O	N/A	N/A
	Staff Identification System Descriptor	This element reports the short description from the Staff Identification Code mapping described in the table and section below. Report 'District' when reporting the local staff number Report 'State' when reporting the license number Report "Educator Stakeholder' when reporting the Staff State ID	M	N/A	N/A
	Assigning Organization Identification Code	The organization code or name assigning the Staff Identification Code. Do not report, we do not collect the agency name that issues staff state id's or license Numbers	O	N/A	N/A
	Identification Code	A unique number or alphanumeric code assigned to a staff member by a school, school system, a state, or other agency or entity. Reporting Logic is as follows: Report the Staff State ID if populated Report the Local Staff Number if populated Report the License Number from the District Employment Record Start Date must be on or before today's date End Date must be on or after today's date If License Number from District Employment is NULL, Report the License Number from the Credentials tab when the type = Licensure/Certification Start Date must be on or before today's date End Date must be on or after today's date If staff has more than 1 eligible record, report the most recent start date. If start date is the same, report highest id.	M	N/A	Census > People >Demographics > State Staff ID/Local Staff ID and/or Census > People > District Employment > License or Credentials > License Number
identificationDocuments	An unordered collection of staffIdentificationDocuments. This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion. This element is currently not reported or collected.		O	N/A	N/A
internationalAddresses	An unordered collection of staffInternationalAddresses. This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion. This element is currently not reported or collected.		O	N/A	N/A
languages	An unordered collection of staffLanguages. This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion. This element is currently not reported or collected.		O	N/A	N/A
otherNames	An unordered collection of staffOtherNames. This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion. This element is currently not reported or collected.		O	N/A	N/A
races	An unordered collection of staffRaces. This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion. Determine the Race/Ethnicity(s) that are checked on the staff's current identity record. Use the Identity Race Ethnicity table to determine all of the check boxes checked for the students current identity id. Do not report if the person does not have a Race/Ethnicity checked. This element is also an array which reports the following data:		O	Identity. raceEthnicity and RaceEthnicity. raceid	Census > People > Identities > Race/Ethnicity
races	raceType	The general racial category which most clearly reflects the individual's recognition of his or her community or with which the individual most identifies. This element reports the short description mapped based on the Race Type table in the section below.	M	Identity. raceEthnicity and RaceEthnicity. raceid	Census > People > Identities > Race/Ethnicity
telephones	An unordered collection of staffTelephones. This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion. This element reports the phone numbers entered in the person's Personal Contact Information editor. See the Telephone Number table in the section below for the Ed-Fi value that is reported. This element is an array which reports the following additional data:		O	Contact.homephone Contact.workphone Contact.cellphone Contact.pager	Census > People > Demographics > Personal Contact Information > Other Phone, Work Phone, Cell Phone, Pager
	telephoneNumberType	This element reports the short description mapped in the Telephone Number Type table listed in the section below.	M	N/A	N/A
	orderOfPriority	The order of priority assigned to telephone numbers to define which number to attempt first, second, etc.	O	N/A	N/A
	textMessage CapabilityIndicator	An indication that the telephone number is technically capable of sending and receiving Short Message Service (SMS) text messages.	O	N/A	N/A
	telephoneNumber	The 10-digit telephone number, including the area code, for the person. This element reports the phone numbers entered in the person's Personal Contact Information editor.	M	Contact.homephone Contact.workphone Contact.cellphone Contact.pager	Census > People > Demographics > Personal Contact Information > Other Phone, Work Phone, Cell Phone, Pager
visas		An unordered collection of staffVisas. This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion. This element is currently not reported or collected.	O	N/A	N/A

Type/Descriptor

The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Level of Education Descriptors:

Campus Code	Campus Name	Ed-Fi Code	Ed-Fi Short Description	Ed-Fi Description
HS	High School Diploma	High School Diploma	High School Diploma	High School Diploma
GED	GED or Equivalent	No Degree	No Degree	No Degree
B	Bachelors	Bachelor's	Bachelor's	Bachelor's
BA	Bachelor of Arts (B.A.)	Bachelor's	Bachelor's	Bachelor's
BS	Bachelor of Science (B.S.)	Bachelor's	Bachelor's	Bachelor's
BFA	Bachelor of Fine Arts (B.F.A.)	Bachelor's	Bachelor's	Bachelor's
BBA	Bachelor of Business Administration (B.B.A.)	Bachelor's	Bachelor's	Bachelor's
BED	Bachelor of Education (B.Ed.)	Bachelor's	Bachelor's	Bachelor's
FPD	First Professional Degree
M	Masters	Master's	Master's	Master's
MA	Master of Arts (M.A.)	Master's	Master's	Master's
MS	Master of Science (M.S.)	Master's	Master's	Master's
MED	Master of Education (M.Ed.)	Master's	Master's	Master's
MBA	Master of Business Administration (M.B.A.)	Master's	Master's	Master's
CAGS	Certificate in Advanced Graduate Study
JD	Juris Doctor	Doctorate	Doctorate	Doctorate
EDD	Educational Doctorate (Ed.D.)	Doctorate	Doctorate	Doctorate
EDS	Educational Specialist (Ed.S.)	Doctorate	Doctorate	Doctorate
PHD	Doctor of Philosophy (Ph.D.)	Doctorate	Doctorate	Doctorate
MD	Doctor of Medicine (MD)	Doctorate	Doctorate	Doctorate
PSD	Doctor of Psychology (Psy.D.)	Doctorate	Doctorate	Doctorate

This table describes the Ed-Fi Value mapped and reported for Telephone Number :

Code in Campus	Ed-Fi Type ID	Ed-Fi Code Value	Ed-Fi Short Description	Ed-Fi Description
Other Phone	1	Home	Home	Home
Other Phone	2 Currently not collected or reported.	Fax	Fax	Fax
Cell Phone	3	Mobile	Mobile	Mobile
Cell Phone	4 Currently not collected or reported.	Unlisted	Unlisted	Unlisted
Work Phone	5	Work	Work	Work
Pager	6	Other	Other	Other
	7 Currently not collected or reported.	Emergency 1	Emergency 1	Emergency 1
	8 Currently not collected or reported.	Emergency 2	Emergency 2	Emergency 2

This table describes the Ed-Fi Value mapped and reported for Race Type:

Code in Campus	Race/Ethnicity in Campus	Ed-Fi Type ID	Ed-Fi Code Value	Ed-Fi Short Description	Ed-Fi Description
3	Black or African American	3	Black - African American	Black - African American	Black - African American
1	American Indian or Alaska Native	1	American Indian - Alaskan Native	American Indian - Alaskan Native	American Indian - Alaskan Native
4	Native Hawaiian or Other Pacific Islander	4	Native Hawaiian - Pacific Islander	Native Hawaiian - Pacific Islanders	Native Hawaiian - Pacific Islander
5	White	5	White	White	White
2	Asian	2	Asian	Asian	Asian

This table describes the Ed-Fi Value mapped and reported for Electronic Mail:

Code in Campus	Ed-Fi Type ID	Ed-Fi Code Value	Ed-Fi Short Description	Ed-Fi Description
All address report as "Home/Personal"	1	Home/Personal	Home	Home
	2	Organization	Organization	Organization
	3	Other	Other	Other
	4	Work	Work	Work

This table describes the Ed-Fi Value mapped and reported for Staff Identification System Type :

Identification Code	Code Value	Ed-Fi Short Description	Ed-Fi Description
License Number	State	State	State
Staff State ID	Educator Stakeholder	Educator Stakeholder	Educator Stakeholder
Local Staff Number	District	N/A - Not reported	District

Student Academic Record

This educational entity represents the cumulative record of academic achievement for a student.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action

Trigger

Post

When transcript records are posted for a student for course with a state code and in grades 9-12 or when a grade is posted to a grading task that is marked as State Reported and the student is in grades K-8

Only report transcript records that have a district number = to the district number where the student is enrolled.
Do not send a record if the Student has an enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY!
Do not report if posted from a course in an excluded calendar. If transcript is manually entered, only report if student has an enrollment in a calendar not marked as excluded.
Do not report if the Course is marked as inactive or State Excluded.
Do not send a record if the Grade Level Exclude checkbox is checked in the grade level record tied to the calendar in which the student is enrolled.

Delete

Student Academic Records will only delete when a student has only 1 Student School Association record for a specific School and Year and all Student School Association records are deleted

Delete/Post

If the natural key is changed.

If a term descriptor mapping changed either in the Sessions Preferences or the Ed-Fi Transcript Term Override.

If the Actual Term is changed on a Course Transcript Record and the Ed-Fi Transcript Term Override field is NULL.

If the Ed-Fi Transcript Term Descriptor Override mapping is changed.

Scope Year Logic

This table describes scope year logic of this object.

Logic
Records will send to the scope year based on the school year the Transcript or Grade record is posted to.
Data will only send for the years that have valid configuration.

Object Data Elements

This table describes data elements sent within the Student Academic Record resource.

Data Element	Description		Campus Database Field	Campus GUI Location
id	The unique identifier of the resource.	M	N/A	N/A
nbrCommunity CollegeClassMeetHSReq	This is part of AZ swagger but not required by AZ to report.	O	N/A	N/A
educationOrganization Reference	Reports the fields that are part of the Natural Key for the Schools resource: EntityID	M	N/A	N/A
schoolYearType Reference	A reference to the related SchoolYearType resource. This element reports the end year of the school year being reported. Reports the end year the Diploma Date is aligned to	M	N/A	N/A
studentReference	Reports the fields that are part of the Natural Key for the Student resource: studentUniqueId	M	N/A
termType	The term for the session during the school year. Logic for reporting this element is as follows: When reporting from a State Reported Grading Task, report the term the grade occurred in based on the section schedule placement for the section the student was scheduled and the Term Type logic reported for that course/section When reporting from a Transcript record: Report the Ed-Fi code for the value selected in "Ed-Fi Transcript Term Override" field on the transcript. If this field is NULL and the record is not posted from a section to determine the associated Term, report the Ed-Fi Code from the Ed-Fi Transcript Term Descriptor Override in the SAR. When "Ed-Fi Transcript Term Override" field = Null, report the Term Descriptor based on the Course Term Type Override, else Section Term Type Override. When both the Course Term and the Section Term Override fields = Null, report the Term Descriptor for the term aligned to the Grading Score for the posted Grade c. If a Term cannot be provided, provide error.	M	N/A	N/A
cumulativeEarned CreditType	Key for Credit. This is optional and does not report	O	N/A	N/A
cumulativeEarned CreditConversion	Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units. This is optional and does not report	O	N/A	N/A
cumulativeEarned Credit	The cumulative number of credits an individual earns by completing courses or examinations during his or her enrollment in the current school as well as those credits transferred from schools in which the individual had been previously enrolled. Does not report	O	N/A	N/A
cumulativeAttempted CreditType	Key for Credit. This is optional and does not report	O	N/A	N/A
cumulativeAttempted CreditConversion	Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units. This is optional and does not report	O	N/A	N/A
cumulativeAttempted Credit	The cumulative number of credits an individual earns by completing courses or examinations during his or her enrollment in the current school as well as those credits transferred from schools in which the individual had been previously enrolled. Does not report	O	N/A	N/A
cumulativeGrade PointsEarned	The cumulative number of grade points an individual earns by successfully completing courses or examinations during his or her enrollment in the current school as well as those transferred from schools in which the individual had been previously enrolled. This is optional and does not report	O	N/A	N/A
cumulativeGrade PointAverage	A measure of average performance in all courses taken by an individual during his or her school career as determined for record-keeping purposes. This is obtained by dividing the total grade points received by the total number of credits attempted. This usually includes grade points received and credits attempted in his or her current school as well as those transferred from schools in which the individual was previously enrolled. This is optional and does not report	O	N/A	N/A
gradeValueQualifier	The scale of equivalents, if applicable, for grades awarded as indicators of performance in schoolwork. For example, numerical equivalents for letter grades used in determining a student's Grade Point Average (A=4, B=3, C=2, D=1 in a four-point system) or letter equivalents for percentage grades (90-100%=A, 80-90%=B, etc.). This is optional and does not report	O	N/A	N/A
projectedGraduation Date	The month and year the student is projected to graduate. This is optional and does not report	O	N/A	N/A
sessionEarned CreditType	Key for Credit. This is optional and does not report	O	N/A	N/A
sessionEarned CreditConversion	Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units. This is optional and does not report	O	N/A	N/A
sessionEarnedCredit	The number of an credits an individual earned in this session. This is optional and does not report	O	N/A	N/A
sessionAttempted CreditType	Key for Credit. This is optional and does not report	O	N/A	N/A
sessionAttempted CreditConversion	Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units. This is optional and does not report	O	N/A	N/A
sessionAttemptedCredit	The number of an credits an individual attempted to earn in this session. This is optional and does not report	O	N/A	N/A
sessionGradePoints Earned	The number of grade points an individual earned for this session. This is optional and does not report	O	N/A	N/A
sessionGrade PointAverage	The grade point average for an individual computed as the grade points earned during the session divided by the number of credits attempted. This is optional and does not report	O	N/A	N/A
classRanking	This educational entity represents the cumulative record of academic achievement for a student. This is optional and does not report	O	N/A	N/A
academicHonors	An unordered collection of studentAcademicRecordAcademicHonors. This educational entity represents the cumulative record of academic achievement for a student. This is optional and does not report	O	N/A	N/A
diplomas	An unordered collection of studentAcademicRecordDiplomas. This educational entity represents the cumulative record of academic achievement for a student. Does not report	O	N/A	N/A
recognitions	An unordered collection of studentAcademicRecordRecognitions. This educational entity represents the cumulative record of academic achievement for a student. This is optional and does not report	O	N/A	N/A
reportCards	An unordered collection of studentAcademicRecordReportCards. This educational entity represents the cumulative record of academic achievement for a student. This is optional and does not report	O	N/A	N/A
etag	A unique system-generated value that identifies the version of the resource. This is optional and does not report	O	N/A	N/A

Student Parent Association

This association relates students to their parents, guardians or caretakers.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	When the Guardian check box is checked AND 1 person is a student and 1 person is not a student. The guardian does NOT have to be a member of the same household as the student to report. Report the active guardian record. If multiple active guardian records, report the one with the latest Start Date. If Start Dates are NULL or the same, look at the End Date, and report the latest End Date (or if 1 is NULL and the other is not, report the <>NULL guardian) If both Start Dates & End Dates are NULL or the same, then it will choose the guardian with the highest PersonID If there are no active guardian records, follow the same logic as listed above for the inactive guardian records A record will not send if the student they are associated with has an enrollment marked as a no show, state exclude or enrollment is in a calendar marked as Exclude Do not send a record if the Student has an enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY!
Put	When the relationship type is changed
Delete	When the Guardian check box is unchecked, relationship is deleted.
Delete	Records will delete when a student has only 1 Student School Association record for a specific School and Year that record is deleted for. If a new Student School Association record is created, existing records will not re-post, a resync must be completed to resend the data
Delete	When the State Exclude or No Show check boxes are checked. if the boxes are unchecked the data will not re-post, a resync must be completed to resend the data

Scope Year Logic

This table describes scope year logic of this object.

Logic
A record will report when they are a guardian to a student with an enrollment aligned to a scoped year. The related pair start date must be null or on/before the scope year end date to report. The related pair end date must be null or on/after the scope year end date to report
Data will only send for the years that have valid configuration.
A resync must be completed on the resource when a new scope year is configured in order for this data to send.
When using data in Campus that have start and end dates, the following logic will be applied to determine the scope year(s) to report the data to: Current Year: The records start date must be on or before today's date and the records end date must be on or after today's date. Previous Years: The record's start date must be on or before the school year's end date and the record's end date must be after the school year's end date defined in the School Years editor. If blank, the default date of 6/30/xxxx is used. Future Years: The record's start date must be on or before the schools year's start date and the record's end date must be on or after the school year's start date defined in the School Years editor. If blank, the default date of 7/01/xxxx is used.

Object Data Elements

This table describes data elements sent within the Student Parent Association resource.

Data Element	Description		Campus Database Field	Campus GUI Location
id	The unique identifier of the resource	M	N/A	N/A
parentReference	Reports the fields that are part of the Natural Key for the Parents resource: parentUniqueId	M	N/A	N/A
studentReference	Reports the fields that are part of the Natural Key for the Student resource: studentUniqueId	M	N/A	N/A
relationType	The nature of an individual's relationship to a student. See the Relationship Type table in the section below for the Ed-Fi value that is reported. Report the Ed-Fi Code from the Ed-Fi Relation Type field that is mapped. If there is no mapping, do not report.	O	N/A	Census > People > Relationships > Relationship
primaryContactStatus	Indicator of whether the person is a primary parental contact for the student. Report True if there is only 1 guardian being reported If more than 1 guardian report the guardian with the earliest start date If Start dates are the same or NULL on 1 or more guardians, report the person with the lowest personID Else, report False	O	N/A	Census > People > Relationships > Guardian
livesWith	Indicator of whether the student lives with the associated parent. This element reports True if the student is in the same household of the parent being reported. Otherwise, reports False. Both Student and Parent Household start date must be null or on/before the scope year end date to report. Both Student and Parent Household end date must be null or on/after the scope year end date to report.	O	N/A	Census > People > Households
emergency ContactStatus	Indicator of whether the person is a designated emergency contact for the student. This element will report true if there is a number entered in the Emergency Priority field for the parent being reported.	O	N/A	Census > People > Relationships > Emergency Priority
contactPriority	The numeric order of the preferred sequence or priority of contact. This data is not collected in Campus is not reported.	O	N/A	N/A
contactRestrictions	Restrictions for student and/or teacher contact with the individual. This data is not collected in Campus is not reported.	O	N/A	N/A
etag	A unique system-generated value that identifies the version of the resource.	O	N/A	N/A

Type/Descriptor

The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Relationship Type:

Ed-Fi Code Value	Ed-Fi Short Description	Ed-Fi Description
	Aunt	Aunt
	Brother	Brother
	BrotherInLaw	BrotherInLaw
	CourtAppointedGuardian	CourtAppointedGuardian
	Cousin	Cousin
	Daughter	Daughter
	DaughterInLaw	DaughterInLaw
	Employer	Employer
	Father	Father
	Father, step	Father, step
	FathersSignificantOther	FathersSignificantOther
	FathersCivilPartner	FathersCivilPartner
	FatherInLaw	FatherInLaw
	Fiance	Fiance
	Fiancee	Fiancee
	Foster parent	Foster parent
	Friend	Friend
	Grandfather	Grandfather
	Grandmother	Grandmother
	Great aunt	Great aunt
	Great uncle	Great uncle
	Great Grandparent	Great Grandparent
	Husband	Husband
	MothersSignificantOther	MothersSignificantOther
	Mother	Mother
	Mother, step	Mother, step
	MothersCivilPartner	MothersCivilPartner
	Nephew	Nephew
	Niece	Niece
	Other	Other
	SignificantOther	SignificantOther
	Sister	Sister
	Son	Son
	Unknown	Unknown
	Uncle	Uncle
	Ward	Ward
	Wife	Wife

Student School Association

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 or the State Exclude check box is unchecked and Enrollment Start Status NOT = E: NON-SAIS DISTRICT USE ONLY! Do not post a record when the State Exclude check box is checked When a student has two enrollments in the same school for the same start date report from the enrollment service type in the following order: P: Primary Enrollment S: Partial/Ancillary T: AOI O: Program Only 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 a record if the Student has an enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY! Do not send records if the School Exclude checkbox is checked in the calendar the student is enrolled. Do not send records if the Grade Level Exclude checkbox is is marked in the grade level tied to the calendar in which 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 If the No Show check box is checked, the record will remain and update the exit date and exit withdraw type descriptor if populated on the enrollment
Put	When an enrollment is updated for a student.
Put	When a change is made to Graduation > Grad Year
Delete	When an enrollment is deleted or the State Exclude check boxes are checked When a student has two enrollments in the same school for the same start date, records will lower priority will not trigger a delete
Delete	When the start date of an enrollment is changed
Delete	When a student's enrollment Start Status is changed from a valid code to E: NON-SAIS DISTRICT USE ONLY! and saved

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.

Object Data Elements

This table describes data elements sent within the Student School Association resource.

Data Element	Description		Campus Database Field	Campus GUI Location
id	The unique identifier of the resource.	M	N/A	N/A
graduationPlan Reference	A reference to the related GraduationPlan resource. Report the associated Graduation Plan when a student is assigned to a Graduation Program or Career Tech Program that is eligible to report to Ed-Fi The Program must overlap the enrollment(s) that are aligned to the Student School Association record(s) being reported Program Start Date must be on or before "today's" date to report Program End Date must be null or after "today's date to report If an end date is added in the current scoped year, delete the reference Report the Graduation Plan School year that is aligned to the student's NCLB Cohort End Year If the student does not have a NCLB Cohort End Year, do not report a record If the student has both a CTE & Graduation Plan, report the Graduation Plan If the student has more than 1 Graduation Plan, report the plan with the most recent start date	O	N/A	N/A
schoolReference	Reports the fields that are part of the Natural Key for the School resource: schoolReference studentReference entryDate	M	N/A	N/A
classOfSchool YearTypeReference	The year the student is expected to graduate. This element will report the value in the Grad Year field. If it is <> NULL< report the value in "classOfSchoolYearTypeReference" If it is NULL, report the value based on the stateGrade value: When the enrollment has a stateGrade = 12, then report the enrollment’s end year, When the enrollment has a stateGrade = 11, then report the enrollment’s end Year +1 When the enrollment has a stateGrade = 10, then report the enrollment’s end Year +2 When the enrollment has a stateGrade = 09, then report the enrollment’s end Year +3 When the enrollment has any other stateGrade, do not report	C	Graduation.gradYear	Student Information > General > Graduation
schoolYearType Reference	The school year the student is being reported in. Reports the end year of the calendar	O	N/A	N/A
studentReference	Reports the fields that are part of the Natural Key for the Student resource: studentUniqueId	M	N/A	N/A
entryDate	The month, day, and year on which an individual enters and begins to receive instructional services in a campus.	M	Enrollment.startDate	Student Information > General > Enrollments > Start Date
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. Report the Ed-Fi Code if populated in the State Grade Level Code attribute	M	Enrollment.grade	Student Information > General > Enrollments > Grade
entryGradeLevel ReasonType	A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. This is optional and does not report.	O	N/A	N/A
entryTypeDescriptor	Reports the enrollment entry status for a student. The Ed-Fi code value from the Entry Type Descriptor mapping is reported. See the Entry Type Descriptor table in the section below for reported Ed-Fi code values.	O	Enrollment. startStatus	Student Information > General > Enrollments > Start Status
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 and does not report.	O	N/A	N/A
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 and does not report.	O	N/A	N/A
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. NEDM: Exit/Withdraw Date.	O	Enrollment.endDate	Student Information > General > Enrollments > End Date
exitWithdrawType Descriptor	Report the Ed-Fi Code Value from the Exit Withdraw Type Descriptor mapping page linked below Report from Graduation Diploma Type if set Ignore End Action and End Status if populated Report “WP” if Enrollment End Status = “WP” if Graduation (Year End Status) is null Report from Enrollment End Action if End Action is not equal to “D” and not null, and none of the above conditions are true Report from Enrollment End Status if End Status is not null and none of the above conditions are true Report blank if none of the above conditions are true See the Exit Withdraw Type Descriptor for a breakdown of the Ed-Fi mapped value that is reported.	O	Enrollment. endStatus	Student Information > General > Enrollments > End Status
residencyStatus Descriptor	A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. This is optional and does not report.	O	N/A	N/A
primarySchool	Indicates if a given enrollment record should be considered the primary record for a student. If omitted, the default is true. This element reports a value of True if Service Type = P: Primary.	O	Enrollment. serviceType	Student Information > General > Enrollments > Local Service Type
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 and does not report.	O	N/A	N/A
educationPlans	An unordered collection of studentSchoolAssociationEducationPlans. This association represents the school in which a student is enrolled. This is optional and does not report.	Array	N/A	N/A
etag	A unique system-generated value that identifies the version of the resource.	O	N/A	N/A
trackReference	A reference to the related Track resource. Report the track reference for the enrollment being reported First report based on the entityID saved in the School record Perform a 'Get' on the 'Tracks' reference, to see if this is a valid id If the school entityID is NULL OR if the school entityID is not in the 'Tracks' reference, look at the District override entityID saved on the School editor Perform a 'Get' on the 'Tracks' reference, to see if this is a valid id If the District override entityID is NULL OR if the District override entityID is not in the 'Tracks' reference, look at the District entityID saved on the District Information editor If an enrollment is marked a no show after the initial record is sent, the track reference will be updated to not report Note that the track value saved in Calendar > Calendar > Track needs to exist, and must match the value reported above to send properly.	O	Calendar.track School.entityID School.districtEntityID District.entityID	System Administration > Calendar > Calendar > Track System Administration > Resources > School > Entity ID System Administration > Resources > School > District Entity ID System Administration > Resources > District Information > Entity ID
exitWithdraw ReasonDescriptor	Reports the reason a student withdrew from school. The Ed-Fi Code value from the Exit Withdrawal Reason Descriptor mapping is reported.	O	Enrollmentaz. withdrawalReason	Student Information > General > Enrollments > Withdrawal Reason
membership TypeDescriptor	Reports if the enrollment is Primary, Ancillary or AOI. If Service Type = P, report 'M' If Service Type = A, report 'A' If Service Type = T, report 'T' If Service Type = O, report 'P'	O	Enrollment. serviceType	Student Information > General > Enrollments > Local Service Type

Type/Descriptor

The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Membership Type Descriptor:

Ed-Fi Code Value	Short description	Description
M	Main	Main
A	Ancillary	Ancillary
T	AOI (formerly TAPBI)	AOI (formerly TAPBI)
P	Program Only	Student enrolled in a SPED only program
G	Grand Canyon Diploma	Grand Canyon Diploma

This table describes the Ed-Fi Value mapped and reported for Entry Type Descriptor:

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

This table describes the Ed-Fi Value mapped and reported for Exit Withdraw Type Descriptor:

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

Student School Attendance Event

This event entity represents the recording of whether a student is in attendance on a daily basis at their school.

Object Triggering Logic for Negative Attendance

This table describes logic for triggering Negative Attendance syncing of this object.

Action	Trigger
Post	When a new attendance event is verified for a student on the course section and the Attendance Status + Attendance Excuse combination is mapped to an Ed-Fi code.
	Calendar Attendance Type is = 004 OR Student Enrollment Type = 004 When a student has two enrollments in the same school in the same school year, report from the enrollment service type in the following order: P: Primary Enrollment S: Partial/Ancillary N: Special Ed Services
	Unknown attendance events will not send an event to ed-fi. The original post will not appear until an excuseID is entered in the attendance table.
	Do not send records if the student's enrollment is marked as a No Show or State Exclude.
	Do not send records if attendance records are associated with a Calendar when the Exclude check box is checked.
	Do not send a record if the Student has an enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY!
	A record will send for each distinct Date and Attendance Event Category Descriptor
	Do not send a record if the only attendance records associated with a date are marked as Tardy.
	Do not send a record if the only attendance records associated with a date are marked as Exempt.
	Do not send records if the Grade Level Exclude checkbox is marked in the grade level tied to the calendar in which the student is enrolled.
	Update the attendance event if new attendance is entered If an attendance status is changed, the first event must be deleted from ed-fi and a new record sent. The Attendance Event Category Descriptor is a primary key and does now allow updates in Ed-Fi.
Delete	Delete attendance record if all attendance is removed for the day.

Object Triggering Logic for AOI Positive Attendance

This table describes logic for triggering AOI Positive Attendance syncing of this object.

Enrollment Service Type is = T: AOI
Calendar Attendance Type is = 017 OR Student Enrollment Type = 017
Do not send records if the student's enrollment is marked as a No Show or State Exclude.
Do not send records if attendance records are associated with a Calendar when the Exclude check box is checked.
A record will send for each distinct Date and Attendance Event Category Descriptor.
Do not send a record on a date where a student has '0' instructional minutes

Setting Up AOI Positive Attendance

For AOI positive attendance to be enabled in any school, System Administration > Attendance > Positive Attendance Preference MUST be set to Yes
- Note: Toggling this to 'on' does nothing to preclude negative attendance or non-AOI positive attendance from working in the district.
Student must be set up with a service type = T:AOI
Student should also have attendance type = 017
Positive Attendance checkbox must be checked on a course
- The regular Attendance checkbox can remain checked and will have no impact on reporting
If a student is reporting positive AOI attendance - any other type of attendance (if entered) will be completely ignored
AOI positive attendance will ONLY send data if present minutes exist and are entered/saved for a valid student (no defaults for being present are sent as is done with Non-AOI)
- AOI positive attendance WILL send whatever duration is saved, even if the amount of present minutes exceeds the actual course (it is based entirely off of time in/time out entered)
  - lunch minutes and passing minutes are a not looked at in any way for AOI positive attendance
Once AOI positive attendance is entered/saved (via either teacher's campus instruction positive attendance module or via student's positive attendance module) it will automatically push to Ed-Fi, with no resync needed

Action	Trigger
Post	When a positive attendance amount is entered and saved to the attendance unit table.
Put	Update the attendance event if attendance events are changed/added.
Delete	Delete attendance record if all attendance is deleted for a day.

Object Triggering Logic for Non-AOI Positive Attendance

This table describes logic for triggering non-AOI Positive Attendance syncing of this object.

Enrollment Service Type is NOT = T: AOI
Calendar Attendance Type is = 017 OR Student Enrollment Type = 017
Do not send records if the student's enrollment is marked as a No Show or State Exclude.
Do not send records if attendance records are associated with a Calendar when the Exclude check box is checked.
A record will send for each distinct Date and Attendance Event Category Descriptor.
Do not send a record on a date where a student has '0' instructional minutes
Only positive attendance records for the school that the student is actively enrolled in on a given date are sent.

Action	Trigger
Post	Records will be suppressed for the current day and sent in a batch at midnight of each day.
Put	Update the attendance event if attendance events are changed/added for any day that is not the current day.
Delete	Delete attendance record if all attendance is deleted for any day that is not the current day.

Scope Year Logic

This table describes scope year logic of this object.

Logic
Attendance will send to the scope year for the school year the attendance dates are associated with based on the student's enrollment.
Data will only send for the years that have valid configuration.

Object Data Elements

This table describes data elements sent within the Student School Attendance Event resource.

For all calculations:

Do not report data with the following State Exclude Flags:
- Enrollment State Exclude flag omits student from report
- Calendar Exclude flag omits school from report
- Grade Level State Exclude flag does not omit student from report
If FTE is missing, the default is = 1
Attendance events with a status = Tardy do not report as an absence record.

For positive attendance reporting:

If a student has not attended for any possible scheduled instructional minutes on a date, no record is sent.
If the student has previously reported out an attendance record on a date and subsequently had an updated attendance record so that they now have not attended any possible scheduled instructional minutes on a date, a delete record is sent to the state for the previous attendance record sent on that date.

If a resync is performed via the Resync tool for a positive attendance student and the attendance date fields are either blank or encompass (either in part or in whole) future dates, positive attendance recrods are only sent for past or current dates (and not for future dates).

Data Element	Description		Campus Database Field	Campus GUI Location
id	The unique identifier of the resource	M	N/A	N/A
schoolReference	Reports the fields that are part of the Natural Key for the Schools resource: entityID	M	N/A	N/A
sessionReference	Reports the fields that are part of the Natural Key for the Sessions resource: id schoolReference schoolYearTypeReference termType name	M	N/A	N/A
studentReference	Reports the fields that are part of the Natural Key for the Student resource: studentUniqueId	M	N/A	N/A
eventDate	Date for this attendance event.	M	N/A	N/A
attendanceEvent CategoryDescriptor	Reports the Absence Reason Code for the student. This element reports the Ed-Fi code value from the Attendance Event Category mapping described in the table and section below.	M	N/A	N/A
attendanceEventReason	The reported reason for a student's absence. This is optional and does not report	O	N/A	N/A
educational EnvironmentType	The educational environment. This is optional and does not report	O	N/A	N/A
etag	A unique system-generated value that identifies the version of the resource	O	N/A	N/A
absenceAmountDescriptor	Reports the absent amount for the student for a day. This value is reported based on the following logic: 0.25 = Student was absent for the equivalent of one-fourth of a full school day 0.5 = Student was absent for the equivalent of one half of a full school day 0.75 = Student was absent for the equivalent of three-fourths of a full school day 1 = Student was absent for the equivalent of one full school day The Attendance Calculation value will deteremine how a school will calculated attendance: HW = Half Day/Whole Day QD = Quarter Day For ALL grade levels: The following are not considered when calculating attendance: No Show flag Threshold values on the calendar or grade level tabStudents Homebound on the day of the absence Student Information > General > Programs > Program The following are considered when calculating attendance: State Exclude flags on the enrollment, calendar, and grade levels Students who have absences during the year in which the 004 Absence Transaction is being generatedStudents FTE value Students FTE value: For all reporting based on FTE value, FTE value is identified in the following method: a. If Enrollment.percentEnrolled is not NULL, report based on the value entered in the record. b. If Enrollment.percentEnrolled is NULL, report based on the value entered into the default field on the Enrollment.percentEnrolled attribute. c. If Enrollment.percentEnrolled is NULL, and the default field on the Enrollment.percentEnrolled attribute is NULL, report based on a value of '1.00'. Student's absent amount cannot exceed their FTE value. Exclude Present Minutes from total minutes missed Student Information > General > Attendance Present minutes for student's cannot include Lunch Time System Administration > Calendar > Calendar > Periods All State Grade Level codes except for the following PS: Preschool Student's are reported in minutes on 017 Kindergarten or UE:Ungraded Elementary (Excluding Homebound Students): Kindergarten Code must = A: Half Day Every Day System Administration > Calendar > Calendar > Grade Levels Calculation: Number of Instructional minutes missed ( divided by ) Scheduled minutes ( X ) FTE Calculated Value: 26% or more = A reported Ed-Fi value of 0.50. Calculated Value: 0-25% = Student is not reported. Kindergarten Code must equal one of the following codes B: Full Day Every Other Day C: Full Day 3 Days a week D: Full Day Every Day Spring-Only E: Full Day Every Day F: Full Day Every Day Title 1 Calculate Value: 51% or more = A reported Ed-Fi value of 1.00 Calculated Value: 0-50% = Student is not reported. Grades 1-8 (Excluding Homebound Student's) Calculation: Number of Instructional minutes missed (divided by) Scheduled minutes, including non-instructional minutes, ( X ) FTE When 'Attendance Calculation' = QD: Quarter Day, report as follows: Calculated Value: 76-100% = Reported Ed-Fi value of 1.00 Calculated Value: 51-75% = Reported Ed-Fi value of 0.75 Calculated Value: 26-50% = Reported Ed-Fi value of 0.50 Calculated Value: 25% = Reported Ed-Fi value of 0.25 Calculated Value: 0-24% = Student is not reported When 'Attendance Calculation' = HW: Half Day/Whole Day, report as follows: Calculated Value: 51-100% = Reported Ed-Fi value of 1.00 Calculated Value: 26-50% = Reported Ed-Fi value of 0.50 Calculated Value: 0-25% = Student is not reported Grades 9-12 The following considerations will be made: Accredited classes Scheduling > Courses > Grading Tasks > Credit value greater than 0 or Null 4 day calendar 5 day calendar For 004a: Negative Method 1 Attendance, report students as such: Absence amount = FTE x (1 - ((The number of classes attended) / (The number of classes scheduled))) Value is reported as rounded UP to the nearest quarter (eg.: 1, .75, .50, .25, 0). a. It should be impossible to send a value of '0', since that would suggest that a student's negative absence record for a date is '0', meaning there was no negative attendance event. b. Exclude Absence Types of: 'Tardy', 'Present'. c. Exclude Absence Status of: 'Exempt'. To be considered a class for the purposes of the calculation, the course needs to be scheduled into an instructional period, and the student actively rostered into a course/section on a given attendance date. For 004: Negative Method 2 Attendance, report students as such: The number of courses a student is expected to attend is based on the FTE value for the student: If the student has 100% FTE, the student is expected for 4 courses. If the student has 75% FTE, the student is expected for 3 courses. If the student has 50% FTE, the student is expected for 2 courses. If the student has 25% FTE, the student is expected for 1 course. If the student has 00% FTE, the student is not expected for any courses. To be considered a course, look for an hour of instruction time. A course must be more than 55 minutes to be counted as a full hour, and can be counted as more than one course if it is greater than 120 minutes (two full hours). Courses can also be added together to count as extra courses, so two courses with 180 minutes would be counted as 3, and two courses with 240 minutes would be counted as 4. To calculate absent minutes, take the FTE minus .25 for each attended course. If this number is greater than 0, it is reported, if this number is less than or equal to 0, no record is reported for the student on that dayr When a student is absent in a non-accredited class, the attendance will not be considered. If the student is not enrolled in accredited classes for the minimum amount of minutes set by the state, the student will report absences. Non-instructional periods will not be considered. If a course is not flagged to take attendance that course will be considered non-instructional. The value reported will not exceed the FTE for the time period governing the attendance data. Scheduled minutes are calculated by taking the sum of all course minutes for attendance taking courses.	M	Calculated	Calcuated
instructionalMinutes	Reports the positive attendance minutes of instruction for a student for a day. For Non-AOI Positive Attendance: Attendance Calculation: Scheduled minutes - Absent minutes Scheduled minutes calculation: Only look at periods for Courses that are marked as Attendance. Only sum periods that are marked as Instructional. Do not include lunch minutes. The Day must be marked as Instructional and Attendance Absent minutes calculation: Scheduled minutes - Present minutes Attendance Status = A and Excuse not = X (exempt) Present minutes are created using the Check-in/Check-out tools. So if a student is marked absent for a whole period then is checked in during the same period, present minutes need to be added back in. For AOI Positive Attendance*: Positive Attendance check boxes must be flagged on the Course Editor for Positive Attendance to be entered for a course. Report the sum of all positive attendance minutes entered for the student for that day.	C	N/A	N/A

Type/Descriptor

The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Attendance Event Category Descriptor:

Logic in Campus

Ed-Fi Code Value

Ed-Fi Short Description

Ed-Fi Description

Reports when Absent Minutes is > 0 and Unexcused is = 0

Excused Absence

Reports when Absent Minutes is > 0 and Unexcused is > 0

Unexcused Absence

Used for Positive Attendance only

Report when Instructional Minutes are being reported

In Attendance

The following Ed-Fi values are not reported as they do not have clear definitions on how to determine these values:

Tardy
Exempt
Early Release

This table describes the Ed-Fi Value mapped and reported for Absence Amount Descriptors :

Ed-Fi Code	Short Description	Description
0.25	student was absent for the equivalent of one-fourth of a full school day	student was absent for the equivalent of one-fourth of a full school day
0.50	student was absent for the equivalent of one half of a full school day	student was absent for the equivalent of one half of a full school day
1.00	student was absent for the equivalent of one full school day	student was absent for the equivalent of one full school day
0.75	student was absent for the equivalent of three-fourths of a full school day	student was absent for the equivalent of three-fourths of a full school day

Student Section Association

This association indicates the course sections to which a student is assigned.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	When a student is scheduled into a course section. A record will report for each Section record that is reported based on the Sections logic. If roster start date is after the term end date, do not report a record for the prior term. Only send records if the student has a enrollment in the schedule structure where the student is rostered and is not marked as No Show or State Exclude or has an enrollment start status of E: NON-SAIS DISTRICT USE ONLY! Do not send records if the Calendar Exclude checkbox is checked. Do not send records if the Grade Level Exclude checkbox is marked in the grade level record tied to the calendar in which the student is enrolled.
Post	Send a new record if a student's roster start date is changed.
Put	When section information is updated for a student or section.
Put	When the course homeroom field is changed.
Put	When the section homeroom field is changed.
Delete	When a student is deleted from a course section.
Delete	Delete any future records if the student is given a roster end date for the course. Roster End Date must be before Term Start date of future records
Delete	Delete the record if a student's roster start date is changed.
Delete	When No Show is marked on a student's enrollment record. All records tied to the enrollment record are deleted.

This resource will not push data for Courses marked as Inactive or State Exclude.

Scope Year Logic

This table describes scope year logic of this object.

Logic

Reports records in the scope year the course/section's calendar is aligned to.

Data will only send for the years that have valid configuration.

Future Years data will be suppressed until the Active Year is changed:

This allows the Schedule Wizard to be used and reducing the number of records sent until the final schedule is completed.
A resync must be done after the Active Year is changed to send data.

Object Data Elements

This table describes data elements sent within the Student Section Association resource.

Data Element	Description		Campus Database Field	Campus GUI Location
id	The unique identifier of the resource.	M	N/A	N/A
sectionReference	Reports the fields that are part of the Natural Key for the Section resource: id classPeriodReference courseOfferingReference locationReference schoolReference sessionReference	M	N/A	N/A
studentReference	Reports the fields that are part of the Natural Key for the Student resource : studentUniqueId	M	N/A	N/A
beginDate	Month, day and year of the student''s entry or assignment to the section. If blank, default is the start date of the first grading period. Logic reports based on the following: Report the roster start date for the term record in which the start date occurs. For any records in the future terms for that course, use the term start date. If Start Date is NULL, report the term start date associated with the term descriptor selected for this section based onsection schedule placement.	M	Enrollment.startDate Terms.startDate roster.startdate	Student Information > General > Enrollments > Start Date OR System Administration > Calendar > Calendar > Terms OR Student Information > General > Schedule > Roster Start Date
endDate	Month, day, and year of the withdrawal or exit of the student from the section. Logic reports based on the following: Report the roster end date for the student, if it exists. If a roster end date is entered, delete any records for future terms for that section. If the Roster End Date is null, only report a value if, when the resource is triggered to send, the currentDate is on or after the section and greater than the Term End Date and the student is in grades 9 through 12. The value reported should be the section's Terms.endDate. If not, no value is reported. If a student's future-dated end date is the last date of the term, and the student's Enrollment is also end dated on the same date, the date will not report until currentDate is on or after the end date.	O	Roster.endDate Terms.endDate	Student Information > General > Schedule > Roster End Date OR System Administration > Calendar > Calendar > Terms
homeroomIndicator	Indicator that the class is the student's designated homeroom used for daily attendance reporting. This element reports a value of True if the Homeroom checkbox is marked on the section or the course the section is assigned to.	O	Course.homeroom Section.homeroom	Scheduling > Course > Homeroom or Scheduling > Course > Section > Homeroom
repeatIdentifierType	An indication as to whether a student has previously taken a given course. This element is currently not reported or collected.	O	N/A	N/A
teacherStudent DataLinkExclusion	Indicates that the student-section combination is excluded from calculation of value-added or growth attribution calculations used for a particular teacher evaluation. This element is currently not reported or collected.	O	N/A	N/A
etag	A unique system-generated value that identifies the version of the resource.	O	N/A	N/A
courseEntryDescriptor	The way the student entered this course section, either as a new enrollee or as a transfer from another section at the same school. Logic reports as follows: Report 'T' when the student transferred into a different section of the same course in the same school year. Student's roster start date is after the earliest term start date based on section schedule placement. Student must have been scheduled into the same course in a different section prior to the roster start date of the section being reported. The sections must have the same section schedule placement in order to be considered. Else, report 'N'.	O
courseExitDescriptor	The type of exit the student had from this course. Logic reports a value based on the following: Send a Course Exit Descriptor when the student gets a posted grade to Transcript for this course. This will on trigger when the Transcript records are posted via the Posting tool. Manual entries will not trigger since they lack a section ID to trace back to the student's course record: If transcript>Credits Earned = Credits Attempted, report CF. If transcript>Credits Earned is less than Credits Attempted but greater than 0, report CP. If transcript>Credits Earned 0, report CN. Send a Course Exit Descriptor when the a Roster End Date is entered and saved for a student: If student Roster End Date before Section>End date and Enrollment>End date is null or after Roster End date, report SC. If student's Roster Exit date is before the highest Section Term End Date based on section schedule placement and = to Student's latest Enrollment End Date, report LS. Else, report blank.	O
note	This element is currently not reported or collected.	O	N/A	N/A
dualCredit	A flag indicating if this student is earning Dual Credit in a Dual Credit course. Report 'True' if Dual Credit check box is selected on the Course editor. Report 'True' if Dual Credit check box is selected on the Section editor. Report 'True' if Dual Credit check box is selected on the Roster Batch Edit editor. Else report 'False'.	M		Course > Dual Credit Course > Section > Dual Credit Course > Section> Roster Batch Edit > Dual Credit
concurrentEnrollment	A Flag indicating if this student is concurrently enrolled in a course that offers concurrent enrollment. Report 'True' if the Post Secondary check box is checked on the course. Else, report 'False'.	M		Scheduling > Course > Post Secondary

Type/Descriptor

The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Course Entry Descriptor:

Ed-Fi Code Value	Short Description	Description
N	New enrollment	New enrollment
R	Re-entry	Re-entry
T	Transfer	Transfer

This table describes the Ed-Fi Value mapped and reported for Course Exit Descriptors:

Code Value	Short Description	Description
CF	Content Complete - Full Credit	Content Complete - Full Credit
CP	Content Complete - Partial Credit	Content Complete - Partial Credit
CN	Content Complete-No Credit/Academic Progress	Student failed or otherwise did not receive any credit for this course becaue no academic progress was made no credit was offered or no credit was earned.
SC	Schedule Change	This course was dropped to accommodate a schedule change for another course or student activity/need.
LS	Left the School	Student is no longer in the school, so all courses have been dropped.
OE	Open Ended Course	Student is enrolled in computer-based course(AOI-online) that is open entry/open exit and does not follow a traditional school calendar begin or end dates. Content is delivered online and instructional setting must be marked CB (Computer based)

Student

Provide a summary of what the report/function will cover and the logistics around the data collection or reporting.

The Student Resource is a shared record among all districts. If two districts have the same student in the same year, the last district to trigger data to Ed-Fi is the data stored in Ed-Fi.

For example, if one district put in a first name of "Robert" and the second district put in a first name of "Rob", the last district to update the student record is what will appear in Ed-Fi and on both District's reports. This is true for all field logic in the Student Resource.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action

Trigger

Post

When an enrollment is created and saved for a person.

Do not send a student record for an enrollment that is marked as State Exclude.
Do not send a record if enrollment is in a calendar marked as State Exclude.
Do not send a record if the Student has an enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY!

Put

When any student data is edited for the person in the Data Elements fields below.

When the person’s identity record is changed.
When one of the person’s household locations is changed.
When one of the person’s household memberships is changed.

Delete

Student records are never deleted because Student records are a shared resource among all districts.

Scope Year Logic

This table describes scope year logic of this object.

Logic

A record will report when an enrollment is created and saved that is aligned to a scoped year.

The enrollment must overlap with the scope year to report.

Data will only send for the years that have valid configuration.

When using data in Campus that has an effective date, the following logic will be applied to determine the scope year(s) to report the data to.

Current Year: Records will be compared to today's date to determine if the record is eligible to report.
Previous Years: The record's date must be on or before the schools year's end date defined in the School Years editor. If blank, the default date of 6/30/xxxx is used.
Future Years: The record's date must be on or after the schools year's start date defined in the School Years editor. If blank, the default date of 7/01/xxxx is used.

When using data in Campus that have start and end dates, the following logic will be applied to determine the scope year(s) to report the data to.

Current Year: The records start date must be on or before today's date and the records end date must be on or after today's date.
Previous Years: The record's start date must be on or before the school year's end date and the record's end date must be after the school year's end date defined in the School Years editor. If blank, the default date of 6/30/xxxx is used.
Future Years: The record's start date must be on or before the schools year's start date and the record's end date must be on or after the school year's start date defined in the School Years editor. If blank, the default date of 7/01/xxxx is used.

Object Data Elements

This table describes data elements sent within the Student resource.

Data Element	Description			Campus Database Field	Campus GUI Location
id	The unique identifier of the resource.		M	N/A	N/A
studentUniqueId	A unique alpha-numeric code assigned to a student. This element reports the Ed-Fi ID of the student.		M	Derson.edFiId	Census >People >Demographics > EdFi ID
personalTitlePrefix	A prefix used to denote the title, degree, position or seniority of the person. This element is currently not reported or collected.		C	N/A	N/A
firstName	The reporting student's first name. This is reported from the person's most recent identity record. If Legal First and Last name fields are blank, the First Name reports.		M	Identity.legalFirstName Identity.firstName	Census > People > Identities > Protected Identity Information > Legal First Name Census > People > Identities > First Name
middleName	The reporting student's middle name. This is reported from the person's most recent identity record. If Legal First Name and Legal Last Name are populated and Middle Name is blank, a blank value reports. If all legal name fields are blank, value reports from the Middle Name field.		O	Identity.legalMiddleName Identity.middleName	Census > People > Identities > Protected Identity Information > Legal Middle Name Census > People > Identities > Middle Name
lastSurname	The reporting student's last name. This is reported from the person's most recent identity record. Reports first from the Legal Last Name field. If Legal First and Last name fields are blank, value reports from the Last Name field.		M	Identity.legalLastName Identity.lastName	Census > People > Identities > Protected Identity Information > Legal Last Name Census > People > Identities > Last Name
generation CodeSuffix	An appendage, if any, used to denote an individual's generation in his family (e.g., Jr., Sr., III). This is reported from the person's most recent identity record. Reports first from the Legal Suffix field. If Legal First Name and Legal Last Name are populated and Legal Suffix is blank, a blank value reports. If Legal First and Last name fields are blank, value reports from the Suffix field, if populated.		C	Identity.legalSuffix Identity.suffix	Census > People > Identities > Protected Identity Information > Legal Suffix Census > People > Identities > Suffix
maidenName	The person's maiden name, if applicable. This element is currently not reported or collected.		O	N/A	N/A
sexType	The student's gender. This is reported from the person's most recent identity record. Reports the Legal Gender from the student's current identity record. If Legal Gender is not populated, the value reports from the student's Gender from the current Identity record. Reports the following based on the value selected in the Gender or Legal Gender field: Female Male Not Selected (Gender not populated)		M	Identity.legalGender Identity.gender	Census > People > Identity > Protected Identity Fields > Gender Census > People > Identity > Gender
birthDate	The month, day, and year on which an individual was born. The Birth Date from the student's currently Identity record is reported.		M	Identity.birthDate	Census > People > Identities > Birth Date
cityOfBirth	The set of elements that capture relevant data regarding a person's birth, including birth date and place of birth. This element is currently not reported or collected.		O	N/A	N/A
birthState AbbreviationType	The abbreviation for the name of the state (within the United States) or extra-state jurisdiction in which an individual was born. Logic determines the Birth State from the student's current identity record. If blank, look for default value to report. Report the Code selected. If the Code does not equal an Ed-Fi Code or the Birth State field is blank with no default value, a null value is reported.		C	Identity.birthState	Census > People > Identities > Birth State
birthCountry CodeType	The name of the country in which an individual was born. Logic determines the Birth Country code from the student's current identity record. If blank, look for default value Report the short description from the countryCodeType mapping.		C	Identity.birthCountry	Census > People > Identities > Birth Country
dateEnteredUS	For students born outside of the US, the date the student entered the US. This element reports the value entered in the Date Entered US field.		C	Identity. dateEnteredUS	Census > People > Identities > Date Entered US
multipleBirthStatus	Indicator of whether the student was born with other siblings (i.e., twins, triplets, etc.) This element is currently not reported or collected.		O	N/A	N/A
profileThumbnail	File name for the ProfileThumbnail photograph. This element is currently not reported or collected.		O	N/A	N/A
hispanicLatino Ethnicity	An indication that the individual traces his or her origin or descent to Mexico, Puerto Rico, Cuba, Central and South America, and other Spanish cultures, regardless of race. This element reports based on the value in the Is the individual Hispanic/Latino? field on the student's identity record.		M	Identity. hispanicEthnicity	Census > People > Identities > Is the individual Hispanic/Latino?
oldEthnicityType	No longer reports data.		O	N/A	N/A
economic Disadvantaged	An indication of inadequate financial condition of an individual''s family, as determined by family income, number of family members/dependents, participation in public assistance programs, and/or other characteristics considered relevant by federal, state, and local policy. This field currently does not report in Arizona.		O	PosEligibility.eligibility	FRAM > Eligibility > Eligibility
schoolFoodServices EligibilityDescriptor	Describes the student's Eligibility Type. This field currently does not report in Arizona.		C	N/A	N/A
limitedEnglish ProficiencyDescriptor	No longer reports data.		O	N/A	N/A
displacementStatus	Indicates a state health or weather related event that displaces a group of students, and may require additional funding, educational, or social services. This element is currently not reported or collected.		O	N/A	N/A
loginId	The login ID for the user; used for security access control interface. This element is currently not reported or collected.		O	N/A	N/A
internationalProvince OfBirth	For students born outside of the US, the Province or jurisdiction in which an individual is born. This element is currently not reported or collected.		O	N/A	N/A
citizenshipStatus Type	A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. This element is currently not reported or collected.		O	N/A	N/A
learningStyle	This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program. A student is a person who has been enrolled in a school or other educational institution. This element is currently not reported or collected.		O	N/A	N/A
addresses	Reports the student's address(es). Logic reports the most current Primary address that is marked as "Mailing". If more than 1 Primary Address marked as Mailing, report address with most recent Household Membership Start Date Else, report the address with most recent Address Start Date If the Address Location Detail or Household Membership is marked as "Private" the address will not report This element is an array that reports the following data:		O	HouseholdLocation. mailing HouseholdMember. startDate Householdlocation. startDate	Household Addresses > Mailing Household Membership > Start Date Household Addresses > Start Date
	addressType	All addresses will report as 'Home'. This will report the Ed-Fi mapped value in the Address Type table in the section below.	M	N/A	N/A
	streetNumberName	The street number and street name or post office box number of an address. Reports the Address PO Box + Number + Street + Tag + Prefix + Dir.	M	Address.postOfficeBox Address.number Address.street Address.tag Address.prefix Address.dir	Households > Address Info
	apartmentRoomSuiteNumber	The apartment, room, or suite number of an address.	O	Address.apt	Households > Address Info > Apt
	buildingSiteNumber	The number of the building on the site, if more than one building shares the same address. This field is optional and does not report.	O	N/A	N/A
	city	The name of the city in which an address is located.	M	Address.city	Households > Address Info > City
	stateAbbreviationType	The abbreviation for the state (within the United States) or outlying area in which an address is located.	M	Address.state	Households > Address Info > State
	postalCode	The five or nine digit zip code portion of an address.	M	SAddress.zip	Households > Address Info > Zip
	nameOfCounty	The name of the county, parish, borough, or comparable unit (within a state) in which an address is located. This field is optional and does not report.	O	N/A	N/A
	countyFIPSCode	5 digit code consisting of the two digit state code followed by the three digit FIPS code for the county. This field is optional and does not report.	O	N/A	N/A
	latitude	The geographic latitude of the physical address. This field is optional and does not report.	O	N/A	N/A
	longitude	The geographic longitude of the physical address. This field is optional and does not report.	O	N/A	N/A
	beginDate	The first date the address is valid. For physical addresses, the date the person moved to that address. This field is optional and does not report.	O	N/A	N/A
	endDate	The last date the address is valid. For physical addresses, this would be the date the person moved from that address. This field is optional and does not report.	O	N/A	N/A
characteristics	An unordered collection of studentCharacteristics. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program.		O	N/A	N/A
characteristics	Student Characteristic Descriptor	Parent in Military: Report if the student has a relationship with a Guardian that has an active Military Connections record within the configured year. Status must be mapped to an Ed-Fi Code of '08: Parent in Military'. Reported code: 'Parent in Military (ID = 8)'. BeginDate: Report Start Date value, if one exists. EndDate: Report End Date value, if one exists. DesignatedBy: Report 'LEA'.	C		Census > People > Military Connections
cohortYears	An unordered collection of studentCohortYears. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program.		O	N/A	N/A
disabilities	An unordered collection of studentDisabilities. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program. This does not report		O	N/A	N/A
electronicMails	An unordered collection of studentElectronicMails. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program. This does not report		O	N/A	N/A
identificationCodes	An unordered collection of studentIdentificationCodes. This element reports the Local Student Number, if populated. This element is an array that reports the following data:		O	Person. studentNumber	Census > People > Demographics > Local Student Number
	studentIdentificationSystemDescriptor	Reports the short description from the Student Identification Code mapping listed in the table and section below. Always reports as District.	M	N/A	N/A
	Assigning Organization Identification Code	The organization code or name assigning the assessment identification code.	O	District.entityID	Student Information > General> Resource > District Information> Entity ID
	Identification Code	A unique number or alphanumeric code assigned to a student by a school, school system, a state, or other agency or entity.	M	Person. studentNumber	Census > People > Demographics > Local Student Number
identification Documents	An unordered collection of studentIdentificationDocuments. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program. A student is a person who has been enrolled in a school or other educational institution. This element is currently not reported or collected.		O	N/A	N/A
indicators	An unordered collection of studentIndicators. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program. A student is a person who has been enrolled in a school or other educational institution. This element is currently not reported or collected.		O	N/A	N/A
international Addresses	An unordered collection of studentInternationalAddresses. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program. A student is a person who has been enrolled in a school or other educational institution. This element is currently not reported or collected.		O	N/A	N/A
languages	An unordered collection of studentLanguages. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program. This elements reports based on the following logic: Determine the Home Primary Language student's current identity record. Use the standard code value for mapping. Report Default Value if populated and student does not have a different language saved. Report the short description from the LanguageType mapping. If Default Value and Home Primary Language is NULL, do not report a record. This element is an array that reports the following data:		O	Identity. homePrimaryLanguage	Census > People > Demographics > Home Primary Language
	languageDescriptor	An unordered collection of studentLanguageUses. Language(s) the individual uses to communicate. This reports the Ed-Fi mapped value in the Language Type table in the section below.	M	Identity. homePrimaryLanguage	Census > People > Demographics > Home Primary Language
	uses	An unordered collection of studentLanguageUses. Language(s) the individual uses to communicate. This element is not collected or reported.	O	N/A	N/A
otherNames	An unordered collection of studentOtherNames. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program. A student is a person who has been enrolled in a school or other educational institution. This element reports the student's name from a previous Identity record. This element is an array that reports the following data:		O	N/A	Census > People > Identities
	otherNameType	This reports the Other Name Type Ed-Fi value mapped in the Other Name Type table in the section below.	M	N/A	N/A
	personalTitlePrefix	A prefix used to denote the title, degree, position or seniority of the person. This element is not collected or reported.	C	N/A	N/A
	firstName	A name given to an individual at birth, baptism, or during another naming ceremony, or through legal change.	M	Identity.firstName	Census > People > Identities > First Name
	middleName	A secondary name given to an individual at birth, baptism, or during another naming ceremony.	C	Identity.middleName	Census > People > Identities > Middle Name
	lastSurname	The name borne in common by members of a family.	M	Identity.lastName	Census > People > Identities > Last Name
	generationCodeSuffix	An appendage, if any, used to denote an individual's generation in his family (e.g., Jr., Sr., III).	C	Identity.suffix	Census > People > Identities > Suffix Name
programParticipations	An unordered collection of studentProgramParticipations. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program. A student is a person who has been enrolled in a school or other educational institution. This element is currently not reported or collected.		O	N/A	N/A
races	An unordered collection of studentRaces. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program. A student is a person who has been enrolled in a school or other educational institution. Logic reports based on the following: Determine the Race/Ethnicity(s) that are checked on the student's current identity record. Use the Identity Race Ethnicity table to determine all of the check boxes checked for the students current identity id. Do not report if the person does not have a Race/Ethnicity checked. This element is an array that reports the following data:		O	IdentityRaceEthnicity and Racethnicity.raceId	Census > People > Identities > Race/Ethnicity
races	raceType	The general racial category which most clearly reflects the individual's recognition of his or her community or with which the individual most identifies. This reports the Ed-Fi value mapped in the Race Type table in the section below.	M	IdentityRaceEthnicity and Racethnicity.raceId	Census > People > Identities > Race/Ethnicity
telephones	An unordered collection of studentTelephones. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program. This does not report		O	N/A	N/A
visas	An unordered collection of studentVisas. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program. This element is currently not reported or collected.		O	N/A	N/A
etag	A unique system-generated value that identifies the version of the resource.		O	N/A	N/A
effectiveDate	This element is currently not reported or collected.		O	N/A	N/A
primaryNightTime ResidenceDescriptor	Reports the student's Primary Night Time Residence. This element reports the value in the Homeless Residence field. The code value from the Primary Night Time Residence Descriptor mapping described in the table and section below is reported.		O	EnrollmentAZ. homelessResidence	Student Information > General > Enrollments > Homeless Residence
tribalName	Report the Tribe the student is affiliated with. If the field is populated within Campus, this value must be reported.		C	N/A	Census > People > Tribal Name
previousSchoolState AbbreviationType	Only reports when a student is new to the school for the first time and comes from a school in the US. Report state code from Previous School State field on enrollment. If blank, do not report a record. If the student has more than 1 enrollment in the same school, report the enrollment with the most recent start date. If the start dates are the same, report the enrollment with highest enrollmentID. Students enrollment start status must be = E6: 1st AZ enroll, from other state.		O	EnrollmentAZ. previousSchoolState	Student Information > General > Enrollments > Previous School State
economicDisadvantaged	The state does not want the Ed-Fi core values to report in the student object for this field. This element is currently not reported.		N/A	N/A	N/A

Type/Descriptor

The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Address Type:

Code in Campus	Ed-Fi Type ID	Ed-Fi Code Value	Ed-Fi Short Description	Ed-Fi Description
All address report as "Home"	1	Home	Home	Home
	2	Physical	Physical	Physical
	3	Mailing	Mailing	Mailing
	4	Other	Other	Other
	5	Work	Work	Work
	6	Billing	Billing	Billing
	7	Temporary	Temporary	Temporary
	8	Father Address	Father Address	Father Address
	9	Guardian Address	Guardian Address	Guardian Address
	10	Mother Address	Mother Address	Mother Address
	11	Shipping	Shipping	Shipping
	12	Shelters	Shelters, Transitional housing, Awaiting Foster Care	Shelters, Transitional housing, Awaiting Foster Care
	13	Doubled	Doubled - up (i.e., living with another family)	Doubled - up (i.e., living with another family)
	14	Unsheltered	Unsheltered (e.g. cars, parks, campgrounds, temp trailers including FEMA trailers, or abandoned buildings)	Unsheltered (e.g. cars, parks, campgrounds, temp trailers including FEMA trailers, or abandoned buildings)
	15	HotelMotel	Hotels/Motels	Hotels/Motels

This table describes the Ed-Fi Value mapped and reported for School Food Services Eligibility Type:

Code in Campus	Ed-Fi Short Description	Ed-Fi Description
F	Free	Free
S	Full price	Full price
A	Full price	Full price
R	Reduced price	Reduced price
R	Unknown	Unknown

This table describes the Ed-Fi Value mapped and reported for Other Name Type:

Code in Campus	Ed-Fi Type ID	Ed-Fi Code Value	Ed-Fi Short Description	Ed-Fi Description
All report as "Other Name"	1	Alias	Alias	Alias
	2	Nickname	Nickname	Nickname
	3	Other Name	Other Name	Other Name
	4	Previous Legal Name	Previous Legal Name	Previous Legal Name

This table describes the Ed-Fi Value mapped and reported for Race Type:

Code in Campus	Race/Ethnicity in Campus	Ed-Fi Type ID	Ed-Fi Code Value	Ed-Fi Short Description	Ed-Fi Description
3	Black or African American	3	Black - African American	Black - African American	Black - African American
1	American Indian or Alaska Native	1	American Indian - Alaskan Native	American Indian - Alaskan Native	American Indian - Alaskan Native
4	Native Hawaiian or Other Pacific Islander	4	Native Hawaiian - Pacific Islander	Native Hawaiian - Pacific Islanders	Native Hawaiian - Pacific Islander
5	White	5	White	White	White
2	Asian	2	Asian	Asian	Asian

This table describes the Ed-Fi Value mapped and reported for Language Type:

Campus Code	Ed-Fi Code Value	Ed-Fi Short Description	Ed-Fi Description
eng	English	English	English
spa	Spanish	Spanish	Spanish
All other codes	Other	Other	Other

This table describes the Ed-Fi Value mapped and reported for Student Identification Type:

Identification Code in Campus	Ed-Fi Code Value	Ed-Fi Short Description	Ed-Fi Description
Local Student Number	Canadian SIN	Canadian SIN	Canadian SIN
	District	District	District
	Family	Family	Family
	Federal	Federal	Federal
	Local	Local	Local
	National Migrant	National Migrant	National Migrant
	Other	Other	Other
	School	School	School
	SSN	SSN	SSN
Student State ID	State	State	State
Student State ID	State Migrant	State Migrant	State Migrant

This table describes the Ed-Fi Value mapped and reported for Primary Nighttime Residence Descriptor:

Campus Code	Name in Campus	Ed-Fi Code Value	Ed-Fi Short Description	Ed-Fi Description
1	Sheltered	1	Sheltered	Sheltered
2	Doubled Up	2	Doubled Up	Doubled Up
3	Unsheltered	3	Unsheltered	Unsheltered
4	Hotels/motels	4	Hotels/motels	Hotels/motels

This table describes the Ed-Fi Value mapped and reported for County Code Type:

Ed-Fi Code Value	Ed-Fi Short Description	Ed-Fi Description
UNK	UNKNOWN	UNKNOWN
AD	ANDORRA	ANDORRA
AE	UNITED ARAB EMIRATES	UNITED ARAB EMIRATES
AF	AFGHANISTAN	AFGHANISTAN
AG	ANTIGUA AND BARBUDA	ANTIGUA AND BARBUDA
AI	ANGUILLA	ANGUILLA
AL	ALBANIA	ALBANIA
AM	ARMENIA	ARMENIA
AO	ANGOLA	ANGOLA
AQ	ANTARCTICA	ANTARCTICA
AR	ARGENTINA	ARGENTINA
AS	AMERICAN SAMOA	AMERICAN SAMOA
AT	AUSTRIA	AUSTRIA
AU	AUSTRALIA	AUSTRALIA
AW	ARUBA	ARUBA
AX	Aland Islands	Aland Islands
AZ	AZERBAIJAN	AZERBAIJAN
BA	BOSNIA AND HERZEGOVINA	BOSNIA AND HERZEGOVINA
BB	BARBADOS	BARBADOS
BD	BANGLADESH	BANGLADESH
BE	BELGIUM	BELGIUM
BF	BURKINA FASO	BURKINA FASO
BG	BULGARIA	BULGARIA
BH	BAHRAIN	BAHRAIN
BI	BURUNDI	BURUNDI
BJ	BENIN	BENIN
BL	Saint Barthelemy	Saint Barthelemy
BM	BERMUDA	BERMUDA
BN	BRUNEI DARUSSALAM	BRUNEI DARUSSALAM
BO	BOLIVIA, PLURINATIONAL STATE OF	BOLIVIA, PLURINATIONAL STATE OF
BQ	BONAIRE, SINT EUSTATIUS AND SABA	BONAIRE, SINT EUSTATIUS AND SABA
BR	BRAZIL	BRAZIL
BS	BAHAMAS	BAHAMAS
BT	BHUTAN	BHUTAN
BV	BOUVET ISLAND	BOUVET ISLAND
BW	BOTSWANA	BOTSWANA
BY	BELARUS	BELARUS
BZ	BELIZE	BELIZE
CA	CANADA	CANADA
CC	COCOS (KEELING) ISLANDS	COCOS (KEELING) ISLANDS
CD	CONGO, THE DEMOCRATIC REPUBLIC OF THE	CONGO, THE DEMOCRATIC REPUBLIC OF THE
CF	CENTRAL AFRICAN REPUBLIC	CENTRAL AFRICAN REPUBLIC
CG	CONGO	CONGO
CH	SWITZERLAND	SWITZERLAND
CI	COTE D'IVOIRE	COTE D'IVOIRE
CK	COOK ISLANDS	COOK ISLANDS
CL	CHILE	CHILE
CM	CAMEROON	CAMEROON
CN	CHINA	CHINA
CO	COLOMBIA	COLOMBIA
CR	COSTA RICA	COSTA RICA
CU	CUBA	CUBA
CV	CAPE VERDE	CAPE VERDE
CW	Curacao	Curacao
CX	CHRISTMAS ISLAND	CHRISTMAS ISLAND
CY	CYPRUS	CYPRUS
CZ	CZECH REPUBLIC	CZECH REPUBLIC
DE	GERMANY	GERMANY
DJ	DJIBOUTI	DJIBOUTI
DK	DENMARK	DENMARK
DM	DOMINICA	DOMINICA
DO	DOMINICAN REPUBLIC	DOMINICAN REPUBLIC
DZ	ALGERIA	ALGERIA
EC	ECUADOR	ECUADOR
EE	ESTONIA	ESTONIA
EG	EGYPT	EGYPT
EH	WESTERN SAHARA	WESTERN SAHARA
ER	ERITREA	ERITREA
ES	SPAIN	SPAIN
ET	ETHIOPIA	ETHIOPIA
FI	FINLAND	FINLAND
FJ	FIJI	FIJI
FK	FALKLAND ISLANDS (MALVINAS)	FALKLAND ISLANDS (MALVINAS)
FM	MICRONESIA, FEDERATED STATES OF	MICRONESIA, FEDERATED STATES OF
FO	FAROE ISLANDS	FAROE ISLANDS
FR	FRANCE	FRANCE
GA	GABON	GABON
GB	UNITED KINGDOM	UNITED KINGDOM
GD	GRENADA	GRENADA
GE	GEORGIA	GEORGIA
GF	FRENCH GUIANA	FRENCH GUIANA
GG	GUERNSEY	GUERNSEY
GH	GHANA	GHANA
GI	GIBRALTAR	GIBRALTAR
GL	GREENLAND	GREENLAND
GM	GAMBIA	GAMBIA
GN	GUINEA	GUINEA
GP	GUADELOUPE	GUADELOUPE
GQ	EQUATORIAL GUINEA	EQUATORIAL GUINEA
GR	GREECE	GREECE
GS	SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS	SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS
GT	GUATEMALA	GUATEMALA
GU	GUAM	GUAM
GW	GUINEA-BISSAU	GUINEA-BISSAU
GY	GUYANA	GUYANA
HK	HONG KONG	HONG KONG
HM	HEARD ISLAND AND MCDONALD ISLANDS	HEARD ISLAND AND MCDONALD ISLANDS
HN	HONDURAS	HONDURAS
HR	CROATIA	CROATIA
HT	HAITI	HAITI
HU	HUNGARY	HUNGARY
ID	INDONESIA	INDONESIA
IE	IRELAND	IRELAND
IL	ISRAEL	ISRAEL
IM	ISLE OF MAN	ISLE OF MAN
IN	INDIA	INDIA
IO	BRITISH INDIAN OCEAN TERRITORY	BRITISH INDIAN OCEAN TERRITORY
IQ	IRAQ	IRAQ
IR	IRAN, ISLAMIC REPUBLIC OF	IRAN, ISLAMIC REPUBLIC OF
IS	ICELAND	ICELAND
IT	ITALY	ITALY
JE	JERSEY	JERSEY
JM	JAMAICA	JAMAICA
JO	JORDAN	JORDAN
JP	JAPAN	JAPAN
KE	KENYA	KENYA
KG	KYRGYZSTAN	KYRGYZSTAN
KH	CAMBODIA	CAMBODIA
KI	KIRIBATI	KIRIBATI
KM	COMOROS	COMOROS
KN	SAINT KITTS AND NEVIS	SAINT KITTS AND NEVIS
KP	KOREA, DEMOCRATIC PEOPLE'S REPUBLIC OF	KOREA, DEMOCRATIC PEOPLE'S REPUBLIC OF
KR	KOREA, REPUBLIC OF	KOREA, REPUBLIC OF
KW	KUWAIT	KUWAIT
KY	CAYMAN ISLANDS	CAYMAN ISLANDS
KZ	KAZAKHSTAN	KAZAKHSTAN
LA	LAO PEOPLE'S DEMOCRATIC REPUBLIC	LAO PEOPLE'S DEMOCRATIC REPUBLIC
LB	LEBANON	LEBANON
LC	SAINT LUCIA	SAINT LUCIA
LI	LIECHTENSTEIN	LIECHTENSTEIN
LK	SRI LANKA	SRI LANKA
LR	LIBERIA	LIBERIA
LS	LESOTHO	LESOTHO
LT	LITHUANIA	LITHUANIA
LU	LUXEMBOURG	LUXEMBOURG
LV	LATVIA	LATVIA
LY	LIBYAN ARAB JAMAHIRIYA	LIBYAN ARAB JAMAHIRIYA
MA	MOROCCO	MOROCCO
MC	MONACO	MONACO
MD	MOLDOVA, REPUBLIC OF	MOLDOVA, REPUBLIC OF
ME	MONTENEGRO	MONTENEGRO
MF	SAINT MARTIN (FRENCH PART)	SAINT MARTIN (FRENCH PART)
MG	MADAGASCAR	MADAGASCAR
MH	MARSHALL ISLANDS	MARSHALL ISLANDS
MK	MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF	MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF
ML	MALI	MALI
MM	MYANMAR	MYANMAR
MN	MONGOLIA	MONGOLIA
MO	MACAO	MACAO
MP	NORTHERN MARIANA ISLANDS	NORTHERN MARIANA ISLANDS
MQ	MARTINIQUE	MARTINIQUE
MR	MAURITANIA	MAURITANIA
MS	MONTSERRAT	MONTSERRAT
MT	MALTA	MALTA
MU	MAURITIUS	MAURITIUS
MV	MALDIVES	MALDIVES
MW	MALAWI	MALAWI
MX	MEXICO	MEXICO
MY	MALAYSIA	MALAYSIA
MZ	MOZAMBIQUE	MOZAMBIQUE
NA	NAMIBIA	NAMIBIA
NC	NEW CALEDONIA	NEW CALEDONIA
NE	NIGER	NIGER
NF	NORFOLK ISLAND	NORFOLK ISLAND
NG	NIGERIA	NIGERIA
NI	NICARAGUA	NICARAGUA
NL	NETHERLANDS	NETHERLANDS
NO	NORWAY	NORWAY
NP	NEPAL	NEPAL
NR	NAURU	NAURU
NU	NIUE	NIUE
NZ	NEW ZEALAND	NEW ZEALAND
OM	OMAN	OMAN
PA	PANAMA	PANAMA
PE	PERU	PERU
PF	FRENCH POLYNESIA	FRENCH POLYNESIA
PG	PAPUA NEW GUINEA	PAPUA NEW GUINEA
PH	PHILIPPINES	PHILIPPINES
PK	PAKISTAN	PAKISTAN
PL	POLAND	POLAND
PM	SAINT PIERRE AND MIQUELON	SAINT PIERRE AND MIQUELON
PN	PITCAIRN	PITCAIRN
PR	PUERTO RICO	PUERTO RICO
PS	PALESTINIAN TERRITORY, OCCUPIED	PALESTINIAN TERRITORY, OCCUPIED
PT	PORTUGAL	PORTUGAL
PW	PALAU	PALAU
PY	PARAGUAY	PARAGUAY
QA	QATAR	QATAR
RE	Reunion	Reunion
RO	ROMANIA	ROMANIA
RS	SERBIA	SERBIA
RU	RUSSIAN FEDERATION	RUSSIAN FEDERATION
RW	RWANDA	RWANDA
SA	SAUDI ARABIA	SAUDI ARABIA
SB	SOLOMON ISLANDS	SOLOMON ISLANDS
SC	SEYCHELLES	SEYCHELLES
SD	SUDAN	SUDAN
SE	SWEDEN	SWEDEN
SG	SINGAPORE	SINGAPORE
SH	SAINT HELENA, ASCENSION AND TRISTAN DA CUNHA	SAINT HELENA, ASCENSION AND TRISTAN DA CUNHA
SI	SLOVENIA	SLOVENIA
SJ	SVALBARD AND JAN MAYEN	SVALBARD AND JAN MAYEN
SK	SLOVAKIA	SLOVAKIA
SL	SIERRA LEONE	SIERRA LEONE
SM	SAN MARINO	SAN MARINO
SN	SENEGAL	SENEGAL
SO	SOMALIA	SOMALIA
SR	SURINAME	SURINAME
SS	SOUTH SUDAN	SOUTH SUDAN
ST	SAO TOME AND PRINCIPE	SAO TOME AND PRINCIPE
SV	EL SALVADOR	EL SALVADOR
SX	SINT MAARTEN (DUTCH PART)	SINT MAARTEN (DUTCH PART)
SY	SYRIAN ARAB REPUBLIC	SYRIAN ARAB REPUBLIC
SZ	SWAZILAND	SWAZILAND
TC	TURKS AND CAICOS ISLANDS	TURKS AND CAICOS ISLANDS
TD	CHAD	CHAD
TF	FRENCH SOUTHERN TERRITORIES	FRENCH SOUTHERN TERRITORIES
TG	TOGO	TOGO
TH	THAILAND	THAILAND
TJ	TAJIKISTAN	TAJIKISTAN
TK	TOKELAU	TOKELAU
TL	TIMOR-LESTE	TIMOR-LESTE
TM	TURKMENISTAN	TURKMENISTAN
TN	TUNISIA	TUNISIA
TO	TONGA	TONGA
TR	TURKEY	TURKEY
TT	TRINIDAD AND TOBAGO	TRINIDAD AND TOBAGO
TV	TUVALU	TUVALU
TW	TAIWAN, PROVINCE OF CHINA	TAIWAN, PROVINCE OF CHINA
TZ	TANZANIA, UNITED REPUBLIC OF	TANZANIA, UNITED REPUBLIC OF
UA	UKRAINE	UKRAINE
UG	UGANDA	UGANDA
UM	UNITED STATES MINOR OUTLYING ISLANDS	UNITED STATES MINOR OUTLYING ISLANDS
US	UNITED STATES	UNITED STATES
UY	URUGUAY	URUGUAY
UZ	UZBEKISTAN	UZBEKISTAN
VA	HOLY SEE (VATICAN CITY STATE)	HOLY SEE (VATICAN CITY STATE)
VC	SAINT VINCENT AND THE GRENADINES	SAINT VINCENT AND THE GRENADINES
VE	VENEZUELA, BOLIVARIAN REPUBLIC OF	VENEZUELA, BOLIVARIAN REPUBLIC OF
VG	VIRGIN ISLANDS, BRITISH	VIRGIN ISLANDS, BRITISH
VI	VIRGIN ISLANDS, U.S.	VIRGIN ISLANDS, U.S.
VN	VIET NAM	VIET NAM
VU	VANUATU	VANUATU
WF	WALLIS AND FUTUNA	WALLIS AND FUTUNA
WS	SAMOA	SAMOA
YE	YEMEN	YEMEN
YT	MAYOTTE	MAYOTTE
ZA	SOUTH AFRICA	SOUTH AFRICA
ZM	ZAMBIA	ZAMBIA
ZW	ZIMBABWE	ZIMBABWE

Student Need

This resource identifies a student's program participation needs.

Reporting Logic

Logic will report a single record and if the student has multiple enrollment records, report the enrollment record based on the Enrollment > Local Service Type hierarchy.

Logic applies the hierarchy only to Student Need records stemming from the following locations:
- Flags
- FRAM
- English Learners (EL)
Logic applies the hierarchy for multiple non-excluded enrollments as follows:
- If any enrollments are 'P: Primary', then report based on them.
- If there are no 'P: Primary' enrollments, then report based on the 'T: AOI' enrollments.
- If there are no 'T: AOI' enrollments, then report based on the 'A: Ancillary' enrollments.
- If there are no 'A: Ancillary' enrollments, then report based on the 'O: Program Only' enrollments.
If a student has any Student Need resources in a scope year, and the enrollment it is tied to is either Deleted or marked as No Show, the Student Need resource ignores those records and looks to see if there are any other eligible enrollments to report under:
- - If there are, the previous Student Need is deleted, and a new one reported, associated with the updated enrollment record.
  - If there are not, the previous Student Need continues to be deleted.
Logic will not send a record if the Need value on Flags is not tied to an Ed-Fi code.

Object Triggering Logic for Program Flags

This table describes logic for triggering Flag syncing of this object.

Enrollment Service Type is = P: Primary
- If a student has two enrollments with a Service Type = T: AOI and a Service Type = A: Ancillary, only a record for the Service Type = T: AOI enrollment is reported.
- If the student only has one enrollment record, a record is reported regardless of Service Type value.
- Do not send a student record for an enrollment that is marked as No Show.
- Do not send a record if the Student has an enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY!
- Do not send a record if the Grade Level Exclude checkbox is checked in the grade level record tied to the calendar in which the student is enrolled.

Action	Trigger
Post	When a Flag is created and saved for a student with a need populated. Flag start date must be on or after enrollment start date.
Post	When a Need is changed on an existing Flag for a student with a need populated.
Post	When a new enrollment is created for a student that has an active Flag Enrollment start date must be after Flag start date. Flag end date must be NULL or after enrollment start date.
Delete and Post	When a start or end date is entered or changed for an existing record. If Need was posted from Flag, update if start or end date was changed. If Need was posted from Enrollment update if start or end date was changed.
Delete and Post	When an enrollment end date is entered for a student with a valid enrollment end status: W1-W13
Delete	Delete the existing need if a need is changed on an existing flag.
Delete	Flag is deleted for a student.
Delete	When a student's enrollment Start Status is changed from a valid code to E: NON-SAIS DISTRICT USE ONLY! and saved
Delete	When an existing enrollment is marked as State Exclude or No Show.

Scope Year Logic for Flags

This table describes scope year logic of this object.

Logic

When a new Flag is created, the record will report in the Scope Year that the record start date overlaps with.

The start date must be on or before the School Year End Date. If School Year End Date is NULL, 6/30/XXXX will be used as the default date
Data will only send for the years that have valid configuration

Data will only send for the years that have valid configuration.

When the record is triggered from enrollments, the record will send to the scope year for the school year the enrollment is associated with.

Object Triggering Logic for Homeless

This table describes logic for triggering Homeless syncing of this object.

Data is reported from the Homeless tab (Student Information > Program Participation > Homeless)

Action	Trigger
Post	When a Homeless record is created and tied to a valid Enrollment record. If a student has multiple enrollments, report from the most recent enrollment with a Service Type of 'P: Primary' If the student has multiple enrollments, but no 'P: Primary' enrollment, report the most recent 'T: AOI' enrollment. If the student has multiple enrollments, but no 'P: Primary' or 'T: AOI' enrollment, report the most recent 'A: Ancillary' enrollment. If the student has multiple enrollments, but no 'P: Primary', 'T: AOI', or 'A: Ancillary' enrollment, report the most recent 'O: Program Only' enrollment Do not send a student record for an enrollment that is marked as No Show. Do not send a record if the Student has an enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY!
Post	When a Homeless record overlaps the student's Enrollment record for that school. The Homeless record start date is on or after enrollment start date. The Homeless record start date is before enrollment start date, and the Homeless record end date is either null or after the enrollment start date.
Post	When a new enrollment for the same school indicated in a pre-existing Homeless record is created for a student, which had not previously had an eligible enrollment record (either didn't have one in that school, didn't have one that overlapped, or didn't have one that wasn't excluded)
Delete and Post	When a start or end date is entered or changed on an existing Homeless record
Delete and Post	When an enrollment end date is entered for a student with a valid enrollment end status: W1-W13
Delete and Post	When the Homeless program is changed on an existing record
Delete and Post	When the enrollment tied to the Homeless record is deleted or made ineligible, and there is another eligible enrollment in the student's record (another overlapping one with perhaps a lower ranked Status value, non-excluded)
	Homeless record is deleted. If the student has two or more Homeless records with the same Homeless Residence and Start Date, do not delete the record unless all programs or needs associated with the primary keys are deleted
Delete	Title 1 record's start date or end date is changed, such that it no longer overlaps an eligible enrollment
Delete	When there is a delete/edit to the eligible enrollment reporting is based on, such that there are no longer any eligible enrollments

Scope Year Logic for Homeless

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.

Object Triggering Logic for Title 1

This table describes logic for triggering Title 1 syncing of this object.

Data is reported from the Title 1 tab (Student Information > Program Participation > Title 1)

Action	Trigger
Post	When a Title 1 record is created and tied to a valid Enrollment record. Send for each unique overlap between any enrollment records and any Title 1 records, where both are tied to the same calendar. Do not send a student record for an enrollment that is marked as No Show. Do not send a record if the student's enrollment Start Status is E: NON-SAIS DISTRICT USE ONLY!
Post	When a Title 1 record overlaps the student's Enrollment record for that school. The Title 1 record start date is on or after enrollment start date. The Title 1 record start date is before enrollment start date, and the Title 1 record end date is either null or after the enrollment start date.
Post	When a new enrollment for the same school indicated in a pre-existing Title 1 record is created for a student, which had not previously had an eligible enrollment record (either didn't have one in that school, didn't have one that overlapped, or didn't have one that wasn't excluded).
Delete and Post	When a start or end date is entered or changed on an existing Title 1 record.
Delete and Post	When an enrollment end date is entered for a student with a valid enrollment end status: W1-W13.
Delete and Post	When the Title 1 service is changed on an existing record.
Delete and Post	When the enrollment tied to the Title 1 record is deleted or made ineligible, and there is another eligible enrollment in the student's record (another overlapping one with perhaps a lower ranked Status value, non-excluded).
Delete and Post	Title 1 record is deleted. If the student has two or more Title 1 records with the same Start Date and End Date, do not delete the record unless all programs or needs associated with the primary keys are deleted.
Delete	Title 1 record's start date or end date is changed, such that it no longer overlaps an eligible enrollment.
Delete	When there is a delete/edit to the eligible enrollment reporting is based on, such that there are no longer any eligible enrollments.

Scope Year Logic for Title 1

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.

Object Triggering Logic for Eligibility

This table describes logic for triggering Eligibility syncing of this object.

Enrollment Service Type is = P: Primary
- If a student has two enrollments with a Service Type = T: AOI and a Service Type = A: Ancillary, only a record for the Service Type = T: AOI enrollment is reported.
- If the student only has one enrollment record, a record is reported regardless of Service Type value.
- Do not send a student record for an enrollment that is marked as State Exclude or No Show
- Do not send a record if enrollment is in a calendar marked as State Exclude
- Do not send a record if the Student has an enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY!

Action	Trigger
Post	When an Eligibility (FRAM) is created and saved for a student that is mapped to a state program code of 4 or 5 and overlaps the student's Enrollment record for that school. Flag start date must be on or after enrollment start date.
Post	When an Eligibility is changed on an existing Eligibility record for a student mapped to a state program code of 4 or 5.
Post	When a new enrollment is created for a student that has an active Eligibility. Enrollment start date must be after Eligibility start date. Eligibility end date must be after enrollment start date.
Delete and Post	When a start or end date is entered or changed for an existing record. If Need was posted from Eligibility, update if start or end date was changed. If Need was posted from Enrollment update if start or end date was changed
Delete and Post	When an enrollment end date is entered for a student with a valid enrollment end status: W1 - W13
Delete	Delete the existing need if Eligibility status is changed to a status not mapped to a state program code of 4 or 5.
Delete	Eligibility is deleted for a student.
Delete	When a student's enrollment Start Status is changed from a valid code to E: NON-SAIS DISTRICT USE ONLY! and saved
Delete	When an existing enrollment is marked as State Exclude or No Show

Scope Year Logic for Eligibility

This table describes scope year logic of this object.

Logic

A record will report when an Eligibility is created and saved that is aligned to a scoped year.

Data will only send for the years that have valid configuration.

When using data in Campus that have start and end dates, the following logic will be applied to determine the scope year(s) to report the data to.

Current Year: The records start date must be on or before today's date and the records end date must be on or after today's date.
Previous Years: The record's start date must be on or before the school year's end date and the record's end date must be after the school year's end date defined in the School Years editor. If blank, the default date of 6/30/xxxx is used.
Future Years: The record's start date must be on or before the schools year's start date and the record's end date must be on or after the school year's start date defined in the School Years editor. If blank, the default date of 7/01/xxxx is used.

Object Triggering Logic for IEP

This table describes logic for triggering IEP syncing of this object.

Enrollment Service Type is = P: Primary
- If a student has two enrollments with a Service Type = T: AOI and a Service Type = A: Ancillary, only a record for the Service Type = T: AOI enrollment is reported.
- If the student only has one enrollment record, a record is reported regardless of Service Type value.
- Do not send a student record for an enrollment that is marked as State Exclude or No Show
- Do not send a record if enrollment is in a calendar marked as State Exclude
- Do not send a record if the Student has an enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY!

Action	Trigger
Post	When an IEP is created and saved for a student and locked. IEP start date must be on or after enrollment start date.
Post	When a new enrollment is created for a student that has an active IEP. Enrollment start date must be after IEP start date. IEP end date must be NULL or after Enrollment start date. If the student has more than 1 IEP started in previous schools years, only report the most recent IEP
Post	When a Disability is changed in an existing IEP.
Delete and Post	When a start or end date is entered or changed for an existing record. If Need was posted from IEP, update if start or end date was changed. If Need was posted from Enrollment, update if start or end date was changed.
Delete and Post	When an enrollment end date is entered for a student with a valid enrollment end status: W1 - W13
Delete	IEP is deleted for a student.
Delete	A disability is changed for a student.
Delete	When a student's enrollment Start Status is changed from a valid code to E: NON-SAIS DISTRICT USE ONLY! and saved.
Delete	When an existing enrollment is marked as State Exclude or No Show.
Delete	When a Exit Evaluation is added for a student and a future record was already created. The Exit Date on the Evaluation must be on or before the start date of the future record.
Delete	If the IEP Start or End Dates OR the Enrollment Start or End Dates have been updated so the IEP and Enrollment no longer overlap, delete the record if one was created.
Delete	If the IEP is unlocked.

Scope Year Logic for IEP

This table describes scope year logic of this object.

Logic
When a new IEP is created, the record will report in the Scope Year that the IEP Start Date overlaps with.
Data will only send for the years that have valid configuration.
The start date must be on or before the School Year End Date. If School Year End Date is NULL, 6/30/XXXX will be used as the default date.
When the record is triggered from enrollments, the record will send to the scope year for the school year the enrollment is associated with.

Object Triggering Logic for EL Services

This table describes logic for triggering EL Services syncing of this object.

Enrollment Service Type is = P: Primary
- If a student has two enrollments with a Service Type = T: AOI and a Service Type = A: Ancillary, only a record for the Service Type = T: AOI enrollment is reported.
- If the student only has one enrollment record, a record is reported regardless of Service Type value.
- Do not send a student record for an enrollment that is marked as No Show.
- Do not send a record if the Student has an enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY!

Action	Trigger
Post	When an EL Service is created and saved for a student that is mapped to a state program code and overlaps the student's Enrollment record for that school. The EL Service record start date is on or after enrollment start date. The EL Service record start date is before enrollment start date, and the EL Service record end date is either null or after the enrollment start date.
Post	When an EL Service is changed on an existing record for a student mapped to a state program code.
Post	When a new enrollment is created for a student that overlaps an active EL Service. The enrollment start date is on or after the EL Service start date. The enrollment start date is before the EL Service start date, and the enrollment end date is either null or after the EL Service start date.
Delete and Post	When a start or end date is entered or changed for an existing record. If Need was posted from EL Service, update if start or end date was changed. If Need was posted from Enrollment update if start or end date was changed.
Delete and Post	When an enrollment end date is entered for a student with a valid enrollment end status: W1 - W13.
Delete	Delete the existing need if EL Service is changed to a status not mapped to a state program code.
Delete	EL Service is deleted for a student.
Delete	When a student's enrollment Start Status is changed from a valid code to E: NON-SAIS DISTRICT USE ONLY! and saved.
Delete	When an existing enrollment is marked as State Exclude or No Show.

Scope Year Logic for EL Services

This table describes scope year logic of this object.

Logic
When a new EL Service is created, the record will report in the Scope Year that the record start date overlaps with.
The start date must be on or before the School Year End Date. If School Year End Date is NULL, 6/30/XXXX will be used as the default date.
Data will only send for the years that have valid configuration.
When the record is triggered from enrollments, the record will send to the scope year for the school year the enrollment is associated with.

Object Data Elements

This table describes data elements sent within the Student Need resource.

Data Element

Description

Campus Database Field

Campus GUI Location

The unique identifier of the resource

N/A

Education
OrganizationReference

Reports the fields that are part of the Natural Key for the Schools resource:

entityID

school.entityid

System Administration > Resources > School editor > Entity ID

schoolReference

Reports the fields that are part of the Natural Key for the Student resource :

studentUniqueId

N/A

descriptor

The program descriptor of the student need.

Flags:

Report the Ed-Fi value field from the Campus Dictionary from the Need selected in the drop list

ProgramParticipation.
need

Student Information > General > Flags > Need

Homeless:

Report the code '6' for Homeless when a Needs record stems from a Homeless Tab record.

Student Information > Program Participation > Homeless

Title 1:

Report the code based on the following chart:

Title 1 Program Droplist (Code: Name)	studentNeedDescriptor	code
28: Title I Math	Math	13
29: Title I Other	Other Academic Services	19
30: Title I Reading	Language Arts (reading and/or writing)	14
31: Title I Science	Science	15
32: Title I Social Studies	Social Studies	18

Student Information > Program Participation > Title 1 > Title 1 Service

Eligibility:

State Eligibility Code	Post-Amble 2019 (and future)	Post-Amble 2018 (and older)
'5' (Free)	'28' (Income Eligibility 1)	'5' (NCLB Indicator 1)
'4' (Reduced)	'29' (Income Eligibility 2)	'4' (NCLB Indicator 2)
anything else	do not report	do not report

N/A

FRAM > Eligibility > State Eligibility Code

EL:

Report the code value 'LEPS' for an EL Service that is mapped to a state code.
- Only report 1 need for the student regardless of the number of services.

LepServiceType.code

Student Information > Program Participation > English Learners (EL)

IEP:

Report the value from the Ed-Fi mapping field on the Disability selected on the locked IEP

If the student has more than 1 Disability, 1 need record for each distinct Disability selected

PlanState.disability1

PlanState.disability2

PlanState.disability3

PlanState.disability4

PlanState.disability5

AZ locked Plan > Enrollment Status > Primary Disability

entryDate

The date the student was identified with the need.

Flags:

Report the start date from the Flag if:

Flag Start Date must be after enrollment Start Date
Enrollment End Date must be NULL or after Flag start date

Report the Enrollment Start Date if:

Enrollment Start Date is after the Flag Start Date
Flag End Date is NULL or after Enrollment Start Date

Programparticipation.
startDate

Enrollment.startDate

Student Information > General > Flags > Start Date

Student Information > General > Enrollment > Start Date

Homeless:

Report the latest date of the following date fields:

Homeless Start Date
Enrollment Start Date (for enrollment tied to Homeless record)

ic_Homeless.startDate

enrollment.startdate

Student Information > Program Participation > Homeless > Start Date

Student Information > General > Enrollments > Start Date

Title 1:

Report the latest date of the following date fields:

Title 1 Start Date
Enrollment Start Date (for enrollment tied to Title 1 record)

Title1.startDate

enrollment.startdate

Student Information > Program Participation > Title 1 > Start Date

Student Information > General > Enrollments > Start Date

Eligibility:

Report the start date from the Eligibility if:

Eligibility Start Date is after enrollment Start Date
Enrollment End Date must be NULL or after Eligibility start date

Report the Enrollment Start Date if:

Enrollment Start Date is after the Eligibility Start Date
Eligibility End Date is after the Enrollment Start Date

Eligibility.startDate

Enrollment.startDate

FRAM > Eligibility > Start Date

Student Information > General > Enrollments > Start Date

EL:

Report the start date from the EL Service if:

EL Service Start Date is after enrollment Start Date
Enrollment End Date must be NULL or after EL Service start date

Report the Enrollment Start Date if:

Enrollment Start Date is after the EL Service Start Date
EL Service End Date is after the Enrollment Start Date

LepService.startDate

Enrollment.startDate

Student Information > General > Program Participation > English Learners (EL) > EL Services > Start Date

Student Information > General > Enrollments > Start Date

IEP:

Report the start date from the IEP if:
- IEP Start Date is after enrollment Start Date
- Enrollment End Date must be NULL or after IEP start date
Report the Enrollment Start Date if:
- Enrollment Start Date is after the IEP Start Date
- IEP End Date is after the Enrollment Start Date

Plan.startDate

Enrollment.startdate

AZ locked Plan > Education Plan > IEP Start Date

Student Information > General > Enrollments > Start Date

exitDate

The date the student is not longer identified with the need.

Flags:

Report the end date from Flag if populated.

Flag End Date must be before Enrollment End Date or before last instructional day of the calendar

Report Enrollment End Date if End Status is = W1 - W13

Enrollment End date must be after Flag Start Date and before Flag End Date and before last instructional day

Else, report the last instructional date from the calendar where the student is enrolled.

ProgramParticipation.
endDate

Enrollment.endDate

Student Information > General > Flags > End Date

Student Information > General > Enrollment > End Date

Homeless:

Report the earliest date of the following date fields:

Homeless End Date
Enrollment End Date (for enrollment tied to Homeless record)
The last instructional day of the calendar the student is enrolled

ic_Homeless.endDate

enrollment.enddate

Student Information > Program Participation > Homeless > End Date

Student Information > General > Enrollments > End Date

Title 1:

Report the earliest date of the following date fields:

Title 1 End Date
Enrollment End Date (for enrollment tied to Title 1 record)
The last instructional day of the calendar the student is enrolled

Title1.endDate

enrollment.enddate

Student Information > Program Participation > Title 1 > End Date

Student Information > General > Enrollments > End Date

Eligibility:

Report the end date from Eligibility if populated
1. Eligibility End Date must be before Enrollment End Date or before last instructional day of the calendar
Report Enrollment End Date
1. Enrollment End date must be after Eligibility Start Date and before Eligibility End Date and before last instructional day
Else, report the last instructional date from the calendar where the student is enrolled

Eligibility.endDate

Enrollment.endDate

FRAM > Eligibility > End Date

Student Information > General > Enrollments > End Date

EL:

Report the end date from EL Service if populated
1. EL Service End Date must be before Enrollment End Date or before last instructional day of the calendar
Report Enrollment End Date
1. Enrollment End date must be after EL Service Start Date and before EL Service End Date and before last instructional day
Else, report the last instructional date from the calendar where the student is enrolled

LepService.endDate

Enrollment.endDate

Student Information > General > Program Participation > English Learners (EL) > EL Services > End Date

Student Information > General > Enrollments > End Date

IEP:

Report the Exit Date from AZ ESR yyyy Format (current) Evaluation.
1. Look for the most recent Evaluation where Evaluation Exit Date is later than the IEP start date and before enrollment end date or last instructional day
Report Enrollment End Date
1. Enrollment End must be on or after IEP Start Date and on or before IEP End Date
2. Enrollment End date must be on or before Exit Date from Evaluation and on or before last Instructional Day
Report the IEP End Date if the end date falls in within the school year being reported.
1. If the IEP end date is NULL or after the last instructional day of the year, report last instructional day of calendar
Report the following if an IEP does not have an end date and a new IEP is created:
1. Report the last instructional day that occurs right before the start date of the new IEP

Special Education records are set to end when an Exit Evaluation is created and locked.

Evaluation.exitDate

Enrollment.endDate

AZ locked Evaluation > Exit Evaluation > Exit Date

Student Information > General > Enrollments > End Date

primaryStudent
NeedIndicator

Indicate if this is a primary need for the student.

Flags:

Not reported or required for Flags.

N/A

Homeless:

Not reported or required for Homeless.

N/A

Title 1:

Not reported or required for Title 1.

N/A

Eligibility:

Not reported or required for Eligibility.

N/A

EL:

Not reported or required for EL.

N/A

IEP:

Report 'Y' (True) when the need reported is the Primary Disability
Report 'N' (False) when the need reported is not the Primary Disability

N/A

AZ locked Plan > Enrollment Status > Primary, Secondary, Tertiary

primaryNightTime
ResidenceDescriptor

Reports the student's Primary Night Time Residence

Homeless:

Report from the Homeless Residence field on student's Homeless record:

If blank, do not report.
Report the Ed-Fi code value.

enrollmentaz.homelessResidence

Student Information > Program Participation > Homeless > Homeless Residence

_etag

A unique system-generated value that identifies the version of the resource.

N/A

Student Program Associations

Reporting Logic

Logic reports a single record and if the student has multiple enrollment records, reports the enrollment record based on the Enrollment > Local Service Type hierarchy.

Logic applies the hierarchy only to Student Program Association records stemming from the following locations:
- Flags
- Title 1
- EL
Logic applies the hierarchy for multiple non-excluded enrollments as follows:
- If any enrollments are 'P: Primary', then report based on them
- If there are no 'P: Primary' enrollments, then report based on the 'T: AOI' enrollments
- If there are no 'T: AOI' enrollments, then report based on the 'A: Ancillary' enrollments
- If there are no 'A: Ancillary' enrollments, then report based on the 'O: Program Only' enrollments
If a student has any Student Program Association resources in a scope year, and the enrollment it is tied to is either Deleted or marked as No Show, the Student Program Association resource ignores those records and looks to see if there are any other eligible enrollments to report under:
- If there are, the previous Student Program Association is deleted, and a new one reported, associated with the updated enrollment record.
- If there are not, the previous Student Program Association continues to be deleted.

Object Triggering Logic for Flags

This table describes logic for triggering Eligibility syncing of this object.

Enrollment Service Type is = P: Primary
- If a student has two enrollments with a Service Type = T: AOI and a Service Type = A: Ancillary, only a record for the Service Type = T: AOI enrollment is reported.
- If the student only has one enrollment record, a record is reported regardless of Service Type value.
- Do not send a student record for an enrollment that is marked as State Exclude or No Show
- Do not send a record if enrollment is in a calendar marked as State Exclude
- Do not send a record if the Student has an enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY!
- Do not send a record if the Grade Level Exclude checkbox is checked in the grade level record tied to the calendar in which the student is enrolled.

Action	Trigger
Post	When a Flag is created and saved for a student that is mapped to a state program code. Flag start date must be on or after enrollment start date.
Post	When a Program is changed on an existing Flag for a student mapped to a state program code.
Post	When a new enrollment is created for a student that has an active Flag mapped to a state program code. Enrollment start date must be after Flag start date. Flag end date must be NULL or after enrollment start date.
Put	When a start or end date is entered or changed for an existing record.
Put	When an enrollment end date is entered for a student with a valid enrollment end status: W1 - W13
Delete	Delete the existing need if a Program is changed on an existing flag.
Delete	Flag is deleted for a student.
Delete	When a student's enrollment Start Status is changed from a valid code to E: NON-SAIS DISTRICT USE ONLY! and saved
Delete	When an existing enrollment is marked as State Exclude or No Show

Scope Year Logic for Flags

This table describes scope year logic of this object.

Logic
When a new Flag is created, the record will report in the Scope Year that the record start date overlaps with.
The start date must be on or before the School Year End Date. If School Year End Date is NULL, 6/30/XXXX will be used as the default date.
When the record is triggered from enrollments, 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.

Data Setup

To create a new or modify an existing Reason Exited for GDC or DRP:

Create an Exit Reason under System Administration > Custom > Attribute Dictionary > Program Participation > Exit Reason
1. Enter in the Ed-Fi Code Value for each corresponding Exit Reason Descriptor
Go to the record in the student's Flag and select the proper Exit reason and Date.

Object Triggering Logic for Title 1

This table describes logic for triggering Eligibility syncing of this object.

Action	Trigger
Post	Report a record based on a Title 1 record being saved and overlapping the students enrollment record Send for each unique overlap between any enrollment records and any Title 1 records, where both are tied to the same calendar. Do not send a student record for an enrollment that is marked as State Exclude or No Show. Do not send a record if enrollment is in a calendar marked as State Exclude. Do not send a record if the Student has an enrollment Start Status of 'E: NON-SAIS DISTRICT USE ONLY!'.
Post	When a new enrollment for the same school indicated in a pre-existing Title 1 record is created for a student, which had not previously had an eligible enrollment record (either didn't have one in that school, didn't have one that overlapped, or didn't have one that wasn't excluded).
Delete/Post	When a start or end date is entered or changed on an existing Title 1 record.
Delete/Post	When an enrollment end date is entered for a student with a valid enrollment end status: W1-W13.
Delete/Post	When the Title 1 service is changed on an existing record.
Delete/Post	When the enrollment tied to the Title 1 record is deleted or made ineligible, and there is another eligible enrollment in the student's record (another overlapping one with perhaps a lower ranked Status value, non-excluded).
Delete	The Title 1 record is deleted. If the student has two or more Title 1 records with the same Title 1 program value and Start Date, do not delete the record unless all programs or needs associated with the primary keys are deleted.
Delete	The Title 1 record's start date or end date is changed, such that it no longer overlaps an eligible enrollment.
Delete	When there is a delete or edit to the eligible enrollment reporting is based on, such that there are no longer any eligible enrollments.

Scope Year Logic for Title 1

This table describes scope year logic of this object.

Logic
When a new Title 1 record is created, the record reports in the Scope Year that the record start date overlaps with.
The start date must be on or before the School Year End Date. If School Year End Date is NULL, 6/30/XXXX will be used as the default date.
The end date must be on or after the School Year Start Date. If School Year Start Date is NULL, 07/01/XXXX will be used as the default date.
Data will only send for the years that have valid configuration.

Object Triggering Logic for Special Ed

A Student Program Association record will generated automatically based on the Student Special Education Association record being generated.

Object Triggering Logic for EL

This table describes logic for triggering EL Services syncing of this object.

Enrollment Service Type is = P: Primary
- If a student has two enrollments with a Service Type = T: AOI and a Service Type = A: Ancillary, only a record for the Service Type = T: AOI enrollment is reported.
- If the student only has one enrollment record, a record is reported regardless of Service Type value.
- Do not send a student record for an enrollment that is marked as State Exclude or No Show
- Do not send a record if enrollment is in a calendar marked as State Exclude
- Do not send a record if the Student has an enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY!
A default value of ELL06 is reported for all ELL/EL records.

Action	Trigger
Post	When an EL Service is created and saved for a student that is mapped to a state program code and overlaps the student's Enrollment record for that school. The EL Service record start date is on or after enrollment start date. The EL Service record start date is before enrollment start date, and the EL Service record end date is either null or after the enrollment start date
Post	When an EL Service is changed on an existing record for a student mapped to a state program code.
Post	When a new enrollment is created for a student that overlaps an active EL Service. The enrollment start date is on or after the EL Service start date. The enrollment start date is before the EL Service start date, and the enrollment end date is either null or after the EL Service start date.
Put	When a start or end date is entered or changed for an existing record.
Put	When an enrollment end date is entered for a student with a valid enrollment end status: W1 - W13
Delete	Delete the existing Service if the Service is changed.
Delete	EL Service is deleted for a student.
Delete	When a student's enrollment Start Status is changed from a valid code to E: NON-SAIS DISTRICT USE ONLY! and saved
Delete	When an existing enrollment is marked as State Exclude or No Show

Scope Year Logic for EL

This table describes scope year logic of this object.

Logic
When a new EL Service is created, the record will report in the Scope Year that the record start date overlaps with.
The start date must be on or before the School Year End Date. If School Year End Date is NULL, 6/30/XXXX will be used as the default date.
When the record is triggered from enrollments, 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.

Object Data Elements

This table describes data elements sent within the Student Program Associations resource.

Data Element	Description		Campus Database Field	Campus GUI Location
id	The unique identifier of the resource.	M	N/A	N/A
educationOrganizationReference	The School Entity ID is reported.	M	N/A	System Administration > Resources > School > Entity ID
programReference	Reports the Program Reference. Programs are preloaded by AZ. This will match the program in Ed-Fi based on the district	M	N/A	N/A
	Flags Report 'Support Program' when the Ed-Fi Code is in: 22, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 38, 29, 40, 41, IM, 21st Century Community Learning Centers Cont-Yr2, 21st Century Community Learning Centers Cont-Yr3, 21st Century Community Learning Centers Cont-Yr4, 21st Century Community Learning Centers Cont-Yr5, 21st Century Community Learning Centers Cycle 14 - New Program Type ID = 59 Report 'Grand Canyon Diploma' when the Ed-Fi code is = Grand Canyon Diploma Program Type ID = 60 Report 'Dropout Recovery Program' when the Ed-FI Code is = Dropout Recovery Program Program Type ID = 61 Program Education Organization Id: Report the District Entity ID from the School Editor if populated If NULL, report the District Entity ID Program Name: Reports the Program Code + Program Name	M	Program.code Customschool. districtentityid Customdistrict. entityid	Programs > Flags > State Program Code System Administration > Resources > Resources > School Editor > District Entity ID OR System Administration > Resources > Resources > District Information > Entity ID
	Title 1 Report 'Support Program' when the Ed-Fi Code is in: 22, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 38, 29, 40, 41, IM Program Type ID = 59 Program Education Organization Id: Report the District Entity ID from the School Editor if populated If NULL, report the District Entity ID Program Name: Reports the Program Code + Program Name	M	Program.code Customschool. districtentityid Customdistrict. entityid	Student Information > General > Programs Participation > Title 1 > Title 1 record > Title 1 Service > Ed-Fi Code System Administration > Resources > Resources > School Editor > District Entity ID OR System Administration > Resources > Resources > District Information > Entity ID
	EL The Program Type = 'ELL' Program Type ID = 1 Program Education Organization Id: Report the District Entity ID from the School Editor if populated If NULL, report the District Entity ID Program Name: Reports the Program Code + Program Name	M
studentReference	The Student Reference is reported.	M	N/A	N/A
beginDate	The month, day, and year on which the student first received services.	M
	Flags Report the start date from the Flag if: Flag Start Date must be after enrollment Start Date Enrollment End Date must be NULL or after Flag start date The Flag record is tied to any of the '21st Century Community Learning Centers...' codes (codes 42-46). Report the Enrollment Start Date if: Enrollment Start Date is after the Flag Start Date Flag End Date is NULL or after Enrollment Start Date	M	ProgramParticipation. startDate	Student Information > General > Flags > Start Date OR Student Information > General > Enrollments > Start Date
	Title 1 Report the Start Date from the Title 1 record	M	programparticipation.StartDate	Student Information > General > Programs Participation > Title 1 > Title 1 record > Start Date
	EL Report the start date from the EL Service if: EL Service Start Date is after enrollment Start Date Enrollment End Date must be NULL or after EL Service start date Report the Enrollment Start Date if: Enrollment Start Date is after the EL Service Start Date EL Service End Date is after the Enrollment Start Date	M	LepService.startDate Enrollment.startDate	Student Information > General > Program Participation > English Learners (EL) > EL Services > Start Date Student Information > General > Enrollments > Start Date
endDate	The month, day, and year on which the student exited the program or stopped receiving services.	C
	Flags Report the end date from Flag if populated Flag End Date must be before Enrollment End Date or before last instructional day of the calendar Report Enrollment End Date if End Status is = W1 - W13 Enrollment End date must be after Flag Start Date and before Flag End Date and before last instructional day Else, report the last instructional date from the calendar where the student is enrolled	C	ProgramParticipation. endDate	Student Information > General > Flags > End Date OR Student Information > General > Enrollment > End Date
	Title 1 Report the end date from the Title 1 record if populated.	C	programparticipation.EndDate	Student Information > General > Programs Participation > Title 1 > Title 1 record > End Date
	EL Report the end date from EL Service if populated EL Service End Date must be before Enrollment End Date or before last instructional day of the calendar Report Enrollment End Date if End Status is = W1 - W13 Enrollment End date must be after EL Service Start Date and before EL Service End Date and before last instructional day Else, report the last instructional date from the calendar where the student is enrolled	C	LepService.endDate Enrollment.endDate	Student Information > General > Program Participation >English Learners (EL) > EL Services > End Date Student Information > General > Enrollments > End Date
reasonExitedDescriptor	Report the reason the student exited from the program.	O
	Flags When Flag > State Code > Ed-Fi code = GCD or DRP, report EdFi code from Flags > Exit reason. See the resasonExtiedDescripted table in the Type/Description section below.	O	N/A	N/A
	Title 1 Optional, does not report	O	N/A	N/A
	EL Report the Ed-Fi Code from the Exit Reason selected on the EL Service if populated Report ELL02 if Enrollment End Date is populated and End Status = W1-13 Program End Date must be null or on or after the Enrollment End Date Report ELL08 if Enrollment End Date is populated and End Status = WK Program End Date must be null or on or after the Enrollment End Date Else, report ELL06	O	N/A	Student Information > General > Program Participation > English Learners (EL) > EL Services > Exit Reason
servedOutsideOfRegularSession	Indicates whether the student received services during the summer session or between sessions.	O	N/A	N/A
services	An unordered collection of studentProgramAssociationServices. This association represents the program(s) that a student participates in or is served by.	O	N/A	N/A
_etag	A unique system-generated value that identifies the version of the resource.	O	N/A	N/A

Type/Descriptor

The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Reason Exited Descriptor (Flags ONLY):

Campus Code	Ed-Fi Code Value	Ed-Fi Short Description	Ed-Fi Description
DRP01	DRP01	Awarded diploma	Student has completed the requirements of the Dropout Recovery Program and has been awarded his/her high school diploma
DRP02	DRP02	Enrolled in LEA	Student has withdrawn from the Dropout Recovery Program and has re-enrolled in any LEA as a traditional student
DRP03	DRP03	Withdrawn by LEA	The LEA offering the DRP program has withdrawn the student from the Dropout Recovery Program
DRP04	DRP04	Withdrew from DRP program	Student has withdrawn from the Dropout Recovery Program. Future plans unknown

This table describes the Ed-Fi Value mapped and reported for the State Program Codes (Flags ONLY):

Code	Name	Ed-Fi Code
DRP	Dropout Recovery Program	DRP
GCD	Grand Canyon Diploma	GCD
IM	Immigrant Need program	IM
21	21st Century program	21
22	Homeless	22
23	Migrant Academic Support	23
24	Migrant Health, Eye and Dental Services	24
25	Migrant Support Services-Nonacademic	25
26	Neglected or Delinquent Program Services	26
27	School Improvement Supplemental Education Services	27
34	Transportation/School Choice	34
35	Gifted Program	35
36	Johnson-O'Malley Indian Education	36
42	21st Century Community Learning Centers Cont-Yr2	21st Century Community Learning Centers Cont-Yr2
43	21st Century Community Learning Centers Cont-Yr3	21st Century Community Learning Centers Cont-Yr3
44	21st Century Community Learning Centers Cont-Yr4	21st Century Community Learning Centers Cont-Yr4
45	21st Century Community Learning Centers Cont-Yr5	21st Century Community Learning Centers Cont-Yr5
46	21st Century Community Learning Centers Cycle 14 - New	21st Century Community Learning Centers Cycle 14 - New

This table describes the Ed-Fi Value mapped and reported for Reason Exited Descriptor (EL ONLY):

Ed-Fi Code	Short Description	Description
ELL01	Reclassified as FEP by Reassessment	Reclassified as FEP by Reassessment
ELL02	Withdrawn from school	Withdrawn from school
ELL05	Transferred to a different program	Transferred to a different program
ELL06	End of school year	End of school year
ELL07	Reclassified due to IEP team decision
ELL08	Transferred to different track

Student Program Attendance Event

This event entity represents the recording of whether a student is in attendance for a class that takes place during a specific program. This resource depends on a student being rostered into a course with Positive Attendance enabled and the "21st CCLC" droplist selected on the Course level.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	When a new positive attendance event is verified for a student in a course section with the "21st CCLC" droplist is selected on the Course editor. The student must have a Student Section Association record to report. Unknown attendance events do not send an event to ed-fi. The original post will not trigger until an excuseID is entered in the attendance table. Do not send a record if the student's enrollment is marked as a No Show. Do not send a record if attendance records are associated with a Calendar when the Exclude checkbox is checked. A record send for each distinct Date, Section and Attendance Event Category Descriptor. Do not send a record if attendance records are associated with a School when the Exclude checkbox is checked. When a previously null 21st CCLC droplist is updated with a value. When an attenanceUnit record that is tied to a CCLC-reportable course is updated to delete='0'.
Delete/Repost	When a previously null 21st CCLC droplist is updated with a different value.
Put	N/A - Only deletes and posts are sent for this resource. If an attendance status is changed, the first event must be deleted from ed-fi and a new record sent. The Attendance Event Category Descriptor is a primary key and does now allow updates in Ed-Fi.
Delete	Delete attendance record if all attendance is removed for the day.
Delete	When an enrollment is deleted or the No Show or State Exclude check boxes are checked.
Delete	If the student is removed from the course section.
Delete	When a previously null 21st CCLC droplist is updated to null.
Delete	When the attenanceUnit record that is tied to the Student Program Attendance Events record is updated to delete='1'.

Scope Year Logic

This table describes scope year logic of this object.

Logic
Attendance will send to the scope year for the school year the attendance dates are associated with based on the student's enrollment.
Data only sends for the years that have valid configuration.

Object Data Elements

This table describes data elements sent within the Student Program Attendance Association resource.

Data Element	Description			Campus GUI Location
id	The unique identifier of the resource.		M
educationOrganizationReference	Reports the educationOrganizationId: EducationOrganization Identity Column.		M
programReference	Reports the Natural Keys of the Program resource. educationOrganizationId: EducationOrganization Identity Column type: Key for Program name: The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies Reports the following values: Name: '21 21st Century Program' Type: 'Support Program'		M
studentReference	Reports the Natural Keys for Students resource. studentUniqueId: A unique alphanumeric code assigned to a student.		M
attendanceEventCategoryDescriptor	A code describing the attendance event, for example: Present Unexcused absence Excused absence Tardy. Always reports a code value of '3', tied to 'In Attendance', as positive attendance only captures this type of event.		M
attendanceEventReason	The reason for the absence or tardy. This field is optional and does not report.		O
educationalEnvironmentType	The setting in which a child receives education and related services. This attribute is only used if it differs from the EducationalEnvironment of the Section. This is only used in the AttendanceEvent if different from the associated Section. This field is optional and does not report.		O
eventDate	Reports the date for this attendance event.		M
timeLogs	An unordered collection of studentProgramAttendanceEventTimeLogs. This event entity adds the time component to a student program attendance participating.		O
	attendanceBeginTime	The time the student began attending this program service. Reports the "Time In" value of each positive attendance record tied to the section.	M	Student Information > General > Attendance > Positive Attendance > positive attendance record
	attendanceEndTime	The time the student stopped attending this program service. Reports the "Time Out" value of each positive attendance record tied to the section, corresponding to a reported "Time In" value, if it exists.	O	Student Information > General > Attendance > Positive Attendance > positive attendance record
_etag	A unique system-generated value that identifies the version of the resource.		O

Types/Description

This table describes the Ed-Fi Value mapped and reported for Attendance Event Category Descriptor:

Ed-Fi Code Value	Ed-Fi Short Description	Ed-Fi Description
1	Excused	Excused
2	Unexcused	Unexcused
3	In Attendance	In Attendance

Student School Association Local Education Agencies

Reports the data on any relationship between a student and an education organization other than how.ever the state views enrollment. Enrollment relationship semantics are covered by Student School Association.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	When an enrollment is saved with Resident District field populated OR When an additional Resident District is saved to the split enrollment editor and saved Do not send a student record for an enrollment that is marked as State Exclude or No Show. Do not send a record if enrollment is in a calendar marked as Exclude. Do not send a record if the Student has an enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY! When a record is updated so that any of the above "Do not..." enrollment conditions is no longer in effect.
Post	When an enrollment start date is changed on an existing enrollment.
Put	When the end date for an enrollment is added or changed.
Delete	When an enrollment start date is changed on an existing enrollment.
Delete	When the enrollment is deleted.
Delete	When a student's enrollment Start Status is changed from a valid code to E: NON-SAIS DISTRICT USE ONLY! and saved
Delete	When a student's Resident District field in any of the split enrollment records is changed to NULL.
Delete	When an existing enrollment is marked as State Exclude or No Show.

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.

Object Data Elements

This table describes data elements sent within the Student School Association Local Agencies resource.

Data Element	Description		Campus Database Field	Campus GUI Location
LocalEducationAgencyID	A reference to the related EducationOrganization resource. (The identifier assigned to a local education agency by the State Education Agency (SEA).) AZ reports the entity ID for the district selected in the Resident District drop list. The list of districts is stored in the Custom District table. Logic reports the Entity ID that corresponds with the District selected in the Resident District table. This is a hard coded list so if changes to AZ district occur, both the District table and Custom District table would need to be updated to reflect a change.	M	Enrollment. residentdistrict	Student Information > General > Enrollments > Resident District
studentSchool AssociatonReference	A reference to the related StudentSchoolAssociation resource. Logic reports the elements of the natural key for the Student School Association record that corresponds to the associated enrollment. schoolReference studentReference entryDate	M	N/A	N/A
membership ResponsibilityDescriptor	The membership responsibility descriptor. Logic reports '03' for all records at this time.	M	N/A	N/A
startDate	Report the start date in which the students district association began. Reporting logic is as follows: 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	Enrollment.startDate	Student Information > General > Enrollments > Start Date or Effective Date
endDate	Report the end date in which the student's district association ended. If the default value is being reported, report the enrollment end date. If the 1st entered value is being reported, report the enrollment end date. If a split record is added, ignore the enrollment end date and report the end date that is the effective date of the new record -1 day. If the previous day is not an instructional day, report the last instructional day prior to the end date. If a new value from custom student is created, send an end date to the prior record that is the effective date of the new record -1 day. If the previous day is not an instructional day, report the last instructional day prior to the end date.	O	Enrollment.endDate	Student Information > General > Enrollments > End Date or Effective Date

Type/Description

This table describes the Ed-Fi Value mapped and reported for Responsibility Descriptor:

Ed-Fi Code Value	Ed-Fi Short Description	Ed-Fi Description
01	Accountability	Accountability
02	Attendance	Attendance
03	Funding	Funding
04	Graduation	Graduation
05	Individualized Education Program	Individualized Education Program
06	Transportation	Transportation

Student Special Education Program Association

Reports the Special Education data for a student.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	Report a record based on the student's Primary enrollment: Service Type = P If a student has multiple enrollments, report based on the most recent enrollment tied to following Local Service Type hierarchy: P: Primary T: AOI A: Ancillary C: Concurrent Course Work D: Dropout Recovery Program G: Grand Canyon Diploma If the student only has one enrollment, report a record regardless of Service Type. Do not send a student record for an enrollment that is marked as State Exclude or No Show. Do not send a record if enrollment is in a calendar marked as State Exclude. Do not send a record if the Student has an enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY!.
Post	When an IEP is created and saved for a student. IEP start date must be on or after enrollment start date.
Post	When a new enrollment is created for a student that has an active IEP. Enrollment start date must be after IEP start date . IEP end date must be NULL or after Enrollment start date. IEP start date must be on or before the last instructional day of the year.
Post	When a SPED Setting is changed in an existing IEP.
Delete and Post	When a start or end date is entered or changed for an existing record. If Program was posted from IEP, update if start or end date was changed. If Program was posted from Enrollment, update if start or end date was changed.
Delete and Post	When an enrollment end date is entered for a student with a valid enrollment end status: W1-W13
Delete	IEP is deleted for a student.
Delete	A SPED Setting is changed for a student.
Delete	If the No Show or State Exclude check boxes are checked OR the enrollment start status is changed to an E: NON-SAIS DISTRICT USE ONLY!
Delete	The Exit Date on the Evaluation must be on or before the start date of the future record. The Exit Date on the Evaluation must be on or before the start date of the future record.
Delete	If the IEP Start or End Dates OR the Enrollment Start or End Dates have been updated so the IEP and Enrollment no longer overlap, delete the record if one was created.
Delete	If the IEP is unlocked.

Scope Year Logic

This table describes scope year logic of this object.

Logic
When a new IEP is created, the record will report in the Scope Year that the IEP Start Date overlaps with.
The start date must be on or before the School Year End Date. If School Year End Date is NULL, 6/30/XXXX will be used as the default date.
When the record is triggered from enrollments, 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.

Object Data Elements

This table describes data elements sent within the Student Special Education Program Association resource.

Data Element	Description		Campus Database Field	Campus GUI Location
id	The unique identifier of the resource.	M	N/A	N/A
educationOrganization Reference	The education organization where the student is participating in or receiving the program services. Reports the Entity ID where the student is enrolled.	M	Customdistrict.attributeid	System Administration > Resources > District Information > Entity ID
programReference	The program associated with the student. Reports the Natural Key from the Programs resource.	M	N/A	N/A
studentReference	A unique alpha-numeric code assigned to a student. Reports the Natural Key from the Student resource.	M	N/A	N/A
beginDate	The month, day, and year on which the student first received services. Report the plan start date from the IEP if: IEP Start Date is after enrollment Start Date. Enrollment End Date must be NULL or after IEP start date. Also report the start date from the Amended IEP if the original plan has been amended, or the 2nd consecutive plan, but report it with the 2nd StudentSpecialEducationProgramAssocation record. Report the Enrollment Start Date if: Enrollment Start Date is after the IEP Start Date. IEP End Date is after the Enrollment Start Date.	M	Plan.startDate	Student Information > Special Ed > Documents > AZ locked Plan >Education Plan >IEP Start Date or Student Information > General > Enrollments > Start Date
endDate	The month, day, and year on which the student exited the program or stopped receiving services. Report the Exit Date from AZ ESR yyyy Format (current) Evaluation. Look for the most recent Evaluation where Evaluation Exit Date is later than the IEP start date and before enrollment end date or last instructional day Report Enrollment End Date Enrollment End must be on or after IEP Start Date and on or before IEP End Date Enrollment End date must be on or before Exit Date from Evaluation and on or before last Instructional Day Report the IEP End Date if the end date falls in within the school year being reported. If the IEP end date is after the last instructional day of the year, report last instructional day of calendar Report the following if an IEP does not have an end date and a new IEP is created: Report the last instructional day that occurs right before the start date of the new IEP. If the end date (minimum of plan end, exit evail or enrollment end date) being sent is not an instructional date, report the last instructional date prior to the end date. Special Education records are set to end when an Exit Evaluation is created and locked.	C	Enrollment.endDate	Student Information > General > Special Ed > Documents > Exit Evaluation > Exit Date or Student Information > General > Enrollment > End Date
reasonExited Descriptor	Reports the reason the student exited from SPED. Report the Ed-Fi code from the Exit Reason selected in the Exit Evaluation Evaluation Exit Date must be after enrollment start date Evaluation Exit Date must be before enrollment end date or last instructional day and before IEP End Date Report the following when a student's enrollment is ended with the following End Status or a new or amended plan is created and locked: Exit Reason: SPED02 Reports when a student has an active plan and their enrollment is ended on or before the last instructional day and has an end status of W7, W15, W17-W20, D2 Reports if the end status is NULL and the Graduation (Year End Status) is 'G'. Exit Reason: SPED03 Reports when a student has an active plan, their enrollment is ended on or before the last instructional day, has an end status of W6 and whose enrollment grade level is not mapped to one of the following state grade levels: 'PS, KG, UE'. Exit Reason: SPED04 Reports when a student has an active plan and their enrollment is ended on or before the last instructional day and has an end status of W8 Exit Reason: SPED05 Reports when a student has an active plan. Reports when a student has an enrollment that is ended on or before the last instructional day. Reports when a student has an end status of W1 or W10. Reports when a student has an end status of W9, is in a state mapped grade of PS, K, or UE and is not 3 to 5 years old. Exit Reason: SPED07 Reports when a student has an active plan and their enrollment is ended on or before the last instructional day and has an end status of W2, W3, W4, W5, W11, W12, W13 Exit Reason: SPED09 Reports when a plan is amended or replaced by a new plan where the disabilities did or did not change Reports when a student has an active plan and their enrollment is ended on or before the last instructional day and has an end status of WK, WD, WP. Reports when a SPED record is ended and a new locked IEP is created in the same scope year with different Disability values. Exit Reason: SPED10 Reports when a student has an active plan. Reports when a student has an enrollment that is ended on or before the last instructional day. Reports when a student has an end status of W9, is in a state mapped grade of PS, K, or UE and is 3 to 5 years old. Exit Reason: SPED13 Reports when the IEP or school year ends and none of the above applies. If a new IEP is added within the same school year, this should be changed based on the information in the new IEP . Special Education records are set to end when an Exit Evaluation is created and locked.	C		Student Information > General > Special Ed > Documents > Exit Evaluation > Exit Reason or Student Information > General > Enrollment > Exit Status
servedOutside OfRegularSession	Indicates whether the student received services during the summer session or between sessions. This is optional, do not report.	O	N/A	N/A
ideaEligibility	Indicator of the eligibility of the student to receive special education services according to the Individuals with Disabilities Education Act (IDEA). This is optional, do not report.	O	N/A	N/A
specialEducation SettingDescriptor	Reports the Special Education setting for the student. Report the code from the Campus Attribute Dictionary for the Special Ed Setting selected in the IEP being reported.	M		Student Information > General > Special Ed > Documents > Plan > Enrollments > Special Ed Setting
specialEducation HoursPerWeek	The number of hours per week for special education instruction and therapy. This is optional, do not report.	O	N/A	N/A
schoolHoursPerWeek	Indicate the total number of hours of instructional time per week for the school that the student attends. This is optional, do not report.	O	N/A	N/A
multiplyDisabled	Indicates whether the student receiving special education and related services has been designated as multiply disabled by the admission, review, and dismissal committee. This is optional, do not report	O	N/A	N/A
medicallyFragile	Indicates whether the student receiving special education and related services is: In the age range of birth to 22 years, and Has a serious, ongoing illness or a chronic condition that has lasted or is anticipated to last at least 12 or more months or has required at least one month of hospitalization, and that require.s daily, ongoing medical treatments and monitoring by appropriately trained personnel which may include parents or other family members, and Requires the routine use of medical device or of assistive technology to compensate for the loss of usefulness of a body function needed to participate in activities of daily living, and Lives with ongoing threat to his or her continued well-being. This is optional, do not report.	O	N/A	N/A
lastEvaluationDate	The date of the last special education evaluation. This is optional, do not report.	O	N/A	N/A
iepReviewDate	The date of the last IEP review. This is optional, do not report.	O	N/A	N/A
iepBeginDate	This is optional, do not report.	O	N/A	N/A
aiMsAEligible	This is optional, do not report.	O	N/A	N/A
alternateAcademic ContentStandardExposure	This is optional, do not report.	O	N/A	N/A
alternateAssessment EligibilityDecisionDate	This is optional, do not report.	O	N/A	N/A
contactMethodType	This is optional, do not report.	O	N/A	N/A
evidenceSCDOtherDetail	This is optional, do not report.	O	N/A	N/A
evidenceOfSignificant CognitiveDisability	.This is optional, do not report.	O	N/A	N/A
iepMeetingParent ParticipationIndicator	This is optional, do not report.	O	N/A	N/A
iepResultMethod InformedParent	This is optional, do not report.	O	N/A	N/A
iepResultParent ContactedByStaffId	This is optional, do not report.	O	N/A	N/A
iepResultParent ContactedDate	This is optional, do not report.	O	N/A	N/A
measureOfAcademic AchievementType	This is optional, do not report.	O	N/A	N/A
meetsCurricular Outcome	This is optional, do not report.	O	N/A	N/A
meetsEvidenceOfSCD	This is optional, do not report.	O	N/A	N/A
meetsIntensity OfInstruction	This is optional, do not report.	O	N/A	N/A
policyConsequenceExists	This is optional, do not report.	O	N/A	N/A
policyConsequence ExistsExplanation	This is optional, do not report.	O	N/A	N/A
mainSPEDSchool	Report "True" if SPED Concurrency Type is = Primary or NULL Report "False" if SPED Concurrency Type is = Secondary	C	Plan. spedConcurrencyType	N/A
services	This is optional, do not report.	O	N/A	N/A
iepAssessment Attendees	This is optional, do not report.	O	N/A	N/A
serviceProviders	This is optional, do not report.	O	N/A	N/A
_etag	N/A	O	N/A	N/A

Type/Description

This table describes the Ed-Fi Value mapped and reported for Reason Exited Descriptor :

Code Value	Short Description	Description
SPED01	Transferred to Regular Education	Transferred to Regular Education
SPED02	Graduated with regular high school diploma	Graduated with regular high school diploma
SPED03	Reached maximum age	Reached maximum age
SPED04	Died	Died
SPED05	Moved, known to be continuing	Moved, known to be continuing
SPED06	Moved, notknown to becontinuing.	Moved, notknown to becontinuing.
SPED07	Dropped out	Dropped out
SPED08	Transition to kindergarten	Transition to kindergarten
SPED09	Exited due to intended change in SAIS data element(s) only	Exited due to intended change in SAIS data element(s) only
SPED10	Withdrawn by Parent and no Longer enrolled	Withdrawn by Parent and no Longer enrolled
SPED11	Expelled but still receiving services	Expelled but still receiving services
SPED13	School is Out	School is Out

This table describes the Ed-Fi Value mapped and reported for Special Education Setting Descriptor :

Student School Association Membership FTE

Reports the enrollment percentage for a student.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	When a FTE value is saved to a students enrollment. Use default value if populated . When a student has two enrollments in the same school for the same date report from the enrollment service type in the following order: P: Primary Enrollment T: AOI A: Ancillary O: Program When a student has two enrollments in the same school with the same date and same service type, report the highest enrollment id. When a student has two enrollments in two different schools, a record should report for each school regardless of date or service type. Do not send a student record for an enrollment that is marked as State Exclude or No Show. Do not send a record if enrollment is in a calendar marked as State Exclude. Do not send a record if the Student has an enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY!
Post	When an enrollment start date is changed.
Put	When a FTE value is changed or a split enrollment record is added or an enrollment end date is added or changed.
Delete	When and enrollment is deleted
Delete	When an enrollment start date is changed.
Delete	When a student's enrollment Start Status is changed from a valid code to E: NON-SAIS DISTRICT USE ONLY! and saved.
Delete	When an existing enrollment is marked as State Exclude or No Show.

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.

Object Data Elements

This table describes data elements sent within the Student School Association Membership FTE resource.

If a default value is populated on the School Membership FTE attribute, that value is saved to the percentEnrolled field if no other FTE value is entered for the student.
The first FTE value saved for a student will populate the percent enrolled field on the enrollment table.
Any additional FTE values saved for a student, will populate the custom student table.

Data Element	Description		Campus Database Field	Campus GUI Location
id	The unique identifier of the resource.	M	N/A	N/A
studentSchool AssociationReference	Reports the fields that are part of the Natural Key for the Student School Association resource. schoolReference studentReference entryDate	M	N/A	N/A
fteStartDate	The start date of the student's membership. 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	Enrollment.startDate OR Customstudent. effectiveDate	Student Information > General > Enrollments > Start Date
fteEndDate	The end date of the student's membership. If the default value is being reported, report the enrollment end date. If the 1st entered value is being reported, report the enrollment end date. If a new value from custom student is created, send an end date to the prior record that is the effective date of the new record -1 day.	O	Enrollment.endDate OR Customstudent. effectiveDate	Student Information > General > Enrollments > End Date
membership FTEDescriptor	The student's membership FTE. If Enrollment.percentEnrolled is not NULL, report based on the value entered in the record. If Enrollment.percentEnrolled is NULL, 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'. Membership FTE Descriptor values: 0.00 = Student's course load is part time, equivalent to 0% of a full-time program 0.25 = Student's course load is part time, equivalent to 25% of a full-time program 0.50 = Student's course load is part time, equivalent to 50% of a full-time program 0.75 = Student's course load is part time, equivalent to 75% of a full-time program 1.00 = 1.00 Student's course load is full time, equivalent to 100% of a full-time 1.25 = Student's course load exceeds full time, equivalent to 125% of a full-time program	M	Enrollment. percentEnrolled or Customstudent.value	System Administration > Custom > Attribute Dictionary > Enrollment > School Membership FTE > Default Value OR Student Information > General > Enrollments > FTE %
_etag	N/A	O	N/A	N/A

Student School Association Tuition Payers

This entity represents the organization that pays tuition.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	When a Tuition Payer value is saved to a students enrollment. When a student has two enrollments in the same school for the same date report from the enrollment service type in the following order: P: Primary Enrollment T: AOI A: Ancillary O: Program When a student has two enrollments in the same school with the same date and same service type, report the highest enrollment id. When a student has two enrollments in two different schools, a record should report for each school regardless of date or service type Default values are reported (if populated). Do not send a student record for an enrollment that is marked as State Exclude or No Show. Do not send a record if enrollment is in a calendar marked as State Exclude. Do not send a record if the Student has an enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY!
Post	When an enrollment start date is changed.
Put	When a Tuition Payer value is changed.
Put	When a split enrollment is added after the current record.
Delete	When a FTE value is change to NULL..
Delete	When an enrollment is deleted.
Delete	When an enrollment start date is changed.
Delete	When a student's enrollment Start Status is changed from a valid code to E: NON-SAIS DISTRICT USE ONLY! and saved.
Delete	When an existing enrollment is marked as State Exclude or No Show.

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.

Object Data Elements

This table describes data elements sent within the Student School Association Tuition Payers resource.

If a default value is populated on the Special Enrollment attribute, that value is saved to the Tuition Payer field if no other Tuition Payer value is entered for the student.
The first Tuition Payer value saved for a student will populate the stateAid enrollment field on the enrollment table.
Any additional Tuition Payer values saved for a student, will populate the custom student table.

Data Element	Description		Campus Database Field	Campus GUI Location
id	The unique identifier of the resource.	M	N/A	N/A
studentSchool AssociationReference	Reports the fields that are part of the Natural Key for the Student School Association resource. schoolReference studentReference entryDate	M	N/A	N/A
Tuition PayerStartDate	The start date for the Student School Association Tuition Payer. 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	Enrollment.startDate OR Customstudent. effectiveDate	Student Information > General > Enrollments > Start Date or Effective Date
Tuition PayerEndDate	The end date for the Student School Association Tuition Payer. If the default value is being reported, report the enrollment end date If the 1st entered value is being reported, report the enrollment end date If a new value from custom student is created, send an end date to the prior record that is the effective date of the new record -1 day.	M	Enrollment.endDate OR Customstudent. effectiveDate	Student Information > General > Enrollments > End Date or calculated value
Tuition PayerDescriptor	The source of the tuition for the student. If Enrollment.stateAid is not NULL, report based on the value entered in the record 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	Enrollment.stateAid or Customstudent.value	System Administration > Custom > Attribute Dictionary > Enrollment > Special Enrollment > Default Value or Student Information > General > Enrollments > Special Enrollment
_etag	N/A	O	N/A	N/A

Type/Description

This table describes the Ed-Fi Value mapped and reported for Tuition Payer Descriptor:

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

Student School Association Special Enrollment

This entity represents special dispensation granted.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	When a FTE value is saved to a students enrollment. When a student has two enrollments in the same school for the same date report from the enrollment service type in the following order: P: Primary Enrollment T: AOI A: Ancillary O: Program When a student has two enrollments in the same school with the same date and same service type, report the highest enrollment ID. When a student has two enrollments in two different schools, a record should report for each school regardless of date or service type. Do not send a student record for an enrollment that is marked as State Exclude or No Show. Do not send a record if enrollment is in a calendar marked as State Exclude. Do not send a record if the Student has an enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY!.
Post	When an enrollment start date is changed.
Put	When a Special Enrollment value is changed or a split enrollment record is added or an enrollment end date is added or changed.
Delete	When an enrollment start date is changed.
Delete	When an enrollment is deleted.
Delete	When a Special Enrollment value is change to NULL.
Delete	When a student's enrollment Start Status is changed from a valid code to E: NON-SAIS DISTRICT USE ONLY! and saved.
Delete	When an existing enrollment is marked as State Exclude or No Show.

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.

Object Data Elements

This table describes data elements sent within the Student School Association Special Enrollment resource.

If a default value is populated on the Special Enrollment attribute, that value is saved to the special enrollment field if no other Special Enrollment value is entered for the student.
The first Special Enrollment value saved for a student will populate the special enrollment field on the enrollment table.
Any additional Special Enrollment values saved for a student, will populate the custom student table.

Data Element	Description		Campus Database Field	Campus GUI Location
id	The unique identifier of the resource.	M	N/A	N/A
studentSchool AssociationReference	Reports the fields that are part of the Natural Key for the Student School Association resource. schoolReference studentReference entryDate	M	N/A	N/A
specialEnrollmentStartDate	The start date for the Student School Association Spe cial enrollment. 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	Enrollment.startDate or Customstudent. effectiveDate	Student Information > General > Enrollments > Start Date OR Effective Date
specialEnrollmentEndDate	The end date for the Student School Association Spe cial enrollment. If the default value is being reported, report the enrollment end date. If the 1st entered value is being reported, report the enrollment end date. If a new value from custom student is created, send an end date to the prior record that is the effective date of the new record -1 day.	M	Enrollment.endDate or Customstudent. effectiveDate	Student Information > General > Enrollments > End Date OR Effective Date
specialEnrollmentDescriptor	If default value is entered and no other Special Enrollment record exists, report default value. If a Special Enrollment record is created, report the code selected in Special Enrollment.	M	Enrollment.nclbChoice or Customstudent.value	System Administration > Custom > Attribute Dictionary > Enrollment > Special Enrollment > Default Value or Student Information > General > Enrollments > Special Enrollment
_etag	N/A	O	N/A	N/A

Type/Description

This table describes the Ed-Fi Value mapped and reported for Special Enrollment Descriptor:

Ed-Fi Code Value	Short Description	Description
1	CECA	CECA
2	CECB	CECB
3	Open Enrollment	Open Enrollment
4	976-State Assistance	Per ARS 15-976, student's whose parents or legal guardians are employed and domiciled at State Institutions and stations.
5	823-Interstate Compact	Per ARS 15-823, IGA for students from Federally recognized Indian Tribe, on reservation spanning multiple states.

Tracks

This entity represents a school calendar

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	When a new calendar is created. Do not send a record if the Calendar Exclude checkbox is checked. Do not send a record if the School Exclude checkbox is checked. When the Tracks value is updated in a calendar, so that the Natural keys for that calendar are no longer identical to another calendar that already sent a Tracks value to the ODS.
Put	When calendar dates are changed.
Put	When the Number value is changed.
Put	When the Days Per Week value is changed.
Put/Delete	When the Track field changes.
Put/Delete	When the total number of instructional days in the calendar is changed.
Delete	When the Calendar is deleted.
Delete	When the Tracks value is updated in a calendar, so that the Natural keys for that calendar are no longer identical to another calendar that already sent a Tracks value to the ODS.

Scope Year Logic

This table describes scope year logic of this object.

Logic

Reports the calendar dates in the scope year in which the calendar is aligned.

Data will only send for the years that have valid configuration.

Future Years data will be suppressed until the Active Year is changed:

This allows the Schedule Wizard to be used and reducing the number of records sent until the final schedule is completed.
A resync must be done after the Active Year is changed to send data.

Object Data Elements

This table describes data elements sent within the Tracks resource.

Data Element	Description		Campus Database Field	Campus GUI Location
id	The unique identifier of the resource.	M	N/A	N/A
trackLocalEducationAgencyReference	The identifier assigned to a local education agency by the State Education Agency (SEA). Reports the value: localEducationAgencyId link Reports the override value on the School editor if it's filled in; if not, report the number on the District editor.	M	Calendar.districtID or School.districtEntityID	System Administration > Resources > District Information > district record > Entity ID or Override, if it exists: System Administration > Resources > School > school record > District Entity ID
schoolReference	The identifier assigned to a school by the State Education Agency (SEA). Reports the value: schooldId link	M	School.entityID	System Administration > Resources > School > school record > Entity ID
beginDate	Reports the first date of the track. Reports the first day marked as Instructional tied to the calendar.	M		System Administration > Calendar > Calendar > Days > date record > Instructional
endDate	Reports the last date of the track. Reports the last day marked as Instructional tied to the calendar.	M		System Administration > Calendar > Calendar > Days > date record > Instructional
numberOfInstructionalDaysInWeekDescriptor	The number of instructional days in a week descriptor (e.g. 3, 4, 5). Reports the code value from the Days Per Week droplist.	M		System Administration > Calendar > Calendar > Days Per Week
totalInstructionalDays	The total number of instructional days in the school calendar (National Education Data Model (NEDM): Total Days in Session). Calculates the total number of days with the "Instructional" checkbox marked, and reports that value.	M		Student Information > Calendar > Calendar > Day > Instructional
numberDescriptor	The track number descriptor (e.g. 01, 02, 03 etc.).	M	calendar.track	System Administration > Calendar > Calendar > Track
_etag	A unique system-generated value that identifies the version of the resource.	O	N/A	N/A

Type/Description

This table describes the Ed-Fi Value mapped and reported for Track Number Descriptor:

Ed-Fi Code Value	Description
01	A 5-day per week track for students in all grades UE, 1-12
02	A 4-day per week track for students in all grades UE, 1-12
03	Kindergarten Track 1
04	Kindergarten Track 2
05	Kindergarten Track 3
06	Preschool Track 1
07	Preschool Track 2
08	Preschool Track 3

This table describes the Ed-Fi Value mapped and reported for Instructional Days Per Week Descriptor:

Ed-Fi Code Value	Description
3	Three Days Per Week
4	Four Days Per Week
5	Five Days Per Week

Additional Logic and Considerations

The following describes additional logic and considerations to be aware of when working with Ed-Fi.

Attendance	Only attendance that is “verified” will send to Ed-Fi. Absent/Unknown records marked by a teacher will not send. Negative attendance will send when it is given an excuse code. NON-AOI Positive Attendance will send at midnight every night in batch to complete the calculation to determine a student’s total present minutes. AOI Positive Attendance will send a sum of all minutes entered for a day. If more than 1 record is entered on the same day, the record will update with a new sum of total minutes present for that day.
No Show/Excludes	When the State Exclude or No Show checkbox is marked on an Enrollment, a Delete will be sent from Ed-Fi. This behavior does not occur on other objects such as Calendars. Example: A Calendar is sync'd and now the district no longer wants the calendar to report from Ed-Fi. Marking the Calendar as 'Exclude' will not remove it or send a Delete from Ed-Fi.
Course Transcript Records	The Course Transcript resource will report grading data from Courses with a state reported grading task that is attached to a Course with a state code. It should be noted that the state course code is a part of the natural key and is used as a 'look up' or reference when data is reported, thus it must match the state coding system. The Attempted Credits and Earned Credits fields cannot report as blank in Ed-Fi so they will be defaulted to '1' to ensure all grading data with a state reported grading task is reported. The Course Attempt Result will reflect whether or not the student has passed based on the Score posted to the grading task that is marked state reported. Example 1: An Elementary Art Course will report '1' for Attempted Credits and '1' for Earned Credits for an Elementary student. Example 2: A High School Art Course will report '1' for Attempted Credits and '1' for Earned Credits, even if the student failed. The Course Attempt Result will reflect 'Fail'. This will continue to report until the posted grade is posted to the Transcript. When reporting from the Transcript; a High School Art Course will report '1' for Attempted Credits and '0' for Earned Credits when the student has failed. The Course Attempt Result will continue to reflect 'Fail'.
Tracks	Acceptable Tracks are pre-loaded by ADE. The track number for a calendar must be entered in the Track field in System Administration > Calendar > Calendar in order to report data. Student School Association records report based on the Track field, thus they must match to prevent errors. Data will report when student enrollments are not present in the calendar. Calendar tracks will send when students are not enrolled in the school, provided the track is properly filled in.
Required Fields	The Room number on the Section editor will become required once Ed-Fi is enabled. This data is required for the section data to send to Ed-Fi. Do a check on all course sections prior to doing a resynch on the Schedule Data to verify all sections have a Room number.
Dual Credit	In order for Sections or Courses to properly report Dual Credit information in the courseCharacteristics element of the Sections resource, the Dual Credit checkbox must be marked on the Course or Section editor. For the dualCredit element of the Student Section Association resource, the Dual Credit checkbox must be marked on the Course, Section, and Roster Batch Edit editors.

AzED

Was this helpful?

Code Value	Short Description	Description
A	A Inside Regular Class 80% or more of the day. (These are children who rece	Inside Regular Class 80% or more of the day. (These are children who received special education and related services outside the regular class for less than 21% of the school day.) This may include children placed in: regular class with special education/related services provided within regular classes; regular class with special education/related services provided outside the regular classes; or regular class with special education services provided in resource rooms.
B	B Inside Regular Class for no more than 79% of day and no less than 40% of	Inside Regular Class for no more than 79% of day and no less than 40% of the day. (These are children who received special education and related services outside the regular classroom for at least 21% but no more than 60% of the school day.) This may include children placed in: resource rooms with special education/related services provided within the resource room; or resource rooms with part-time instruction in a regular class.
C	C Inside Regular Class less than 40% of the day. (These are children who re	Inside Regular Class less than 40% of the day. (These are children who received special education and related services outside the regular classroom for more than 60% of the school day.) This may include children placed in: self-contained special classrooms with part-time instruction in a regular class; or self-contained special classrooms with full-time special education instruction on a regular school campus.
D	D Public or Private Separate Day School for greater than 50% of the school	Public or Private Separate Day School for greater than 50% of the school day. This may include children placed in: public and private day schools for students with disabilities; public and private day schools for students with disabilities for a portion of the school day (greater than 50%) and in regular school buildings for the remainder of the school day; or public and private residential facilities if the student does NOT LIVE at the facility.
E	E Public or Private Residential Facility for greater than 50% of the school	Public or Private Residential Facility for greater than 50% of the school day. Receives education programs and lives in the public or private residential facilities during the school week. This may include children placed in: public and private residential schools for students with disabilities; or public and private residential schools for students with disabilities for a portion of the school day (greater than 50%) and in separate day schools or regular school buildings for the remainder of the school day.
EA	EA Public or Private Residential Facility for greater than 50% of the schoo	Public or Private Residential Facility for greater than 50% of the school day - placed by another state agency (not an IEP team decision) with code A. Placed in public or private residential facility receiving services inside regular class 80% or more of the day. Receives education programs and lives in the public or private residential facilities during the school week. This may include children placed in: public and private residential schools for students with disabilities; or public and private residential schools for students with disabilities for a portion of the school day (greater than 50%) and in separate day schools or regular school buildings for the remainder of the school day.
EB	EB Public or Private Residential Facility for greater than 50% of the schoo	Public or Private Residential Facility for greater than 50% of the school day - placed by another state agency (not an IEP team decision) with code B. Placed in public or private residential facility receiving services inside regular class 40-79% of the day. Receives education programs and lives in the public or private residential facilities during the school week. This may include children placed in: public and private residential schools for students with disabilities; or public and private residential schools for students with disabilities for a portion of the school day (greater than 50%) and in separate day schools or regular school buildings for the remainder of the school day.
EC	EC Public or Private Residential Facility for greater than 50% of the schoo	Public or Private Residential Facility for greater than 50% of the school day - placed by another state agency (not an IEP team decision) with code C. Placed in public or private residential facility receiving services inside regular class less than 40% of the day. Receives education programs and lives in the public or private residential facilities during the school week. This may include children placed in: public and private residential schools for students with disabilities; or public and private residential schools for students with disabilities for a portion of the school day (greater than 50%) and in separate day schools or regular school buildings for the remainder of the school day.
FA	FA Correctional Facilities with code A. Receives special education inside r	Correctional Facilities with code A. Receives special education inside regular class 80% or more of the day in: short-term detention facilities (community-based or residential); or correctional facilities.
FB	FB Correctional Facilities with code B. Receives special education inside r	Correctional Facilities with code B. Receives special education inside regular class 40-79% of the day in: shortterm detention facilities (community-based or residential); or correctional facilities.
FC	FC Correctional Facilities with code C. Receives special education inside r	Correctional Facilities with code C. Receives special education inside regular class less than 40% of the day in: short-term detention facilities (community-based or residential); or correctional facilities.
H	H Homebased/homebound/hospital program. Receives education programs in home	Homebased/homebound/hospital program. Receives education programs in homebased/homebound/hospital environment that includes children with disabilities placed in and receiving special education and related services in: hospital programs; homebound or homebased programs.
I	I Services provided in a regular classroom. The only disability categories	Services provided in a regular classroom. The only disability categories that can be reported here are MD, A, SID, and OI.
J	J Private School placement, enrolled by parent(s). Students enrolled by par	Private School placement, enrolled by parent(s). Students enrolled by parents or guardians in regular parochial or other private schools who receive special education and related services under a service plan. There is no entitlement to special education and related services. However, PEA must expend proportionate amount of federal funding on students in this type of private placement. This also includes children that are homeschooled.
PA1	PA1 Attending Regular Early Childhood Program AT LEAST 10 hours per week; r	Attending Regular Early Childhood Program AT LEAST 10 hours per week; receiving majority of special education and related services in REGULAR EARLY CHILDHOOD PROGRAM. A program that includes at least 50% nondisabled children. This may include, but is not limited to: Head Start; kindergarten; preschool classes offered to an eligible prekindergarten population by the public school system; private kindergarten 9 or preschool; group child development center or child care.
PA2	PA2 Attending Regular Early Childhood Program AT LEAST 10 hours per week; r	Attending Regular Early Childhood Program AT LEAST 10 hours per week; receiving majority of special education and related services in SOME OTHER LOCATION. A program that includes at least 50% nondisabled children. This may include, but is not limited to: Head Start; kindergarten; preschool classes offered to an eligible pre-kindergarten population by the public school system; private kindergarten 9 or preschool; group child development center or child care.
PB1	PB1 Attending Regular Early Childhood Program LESS THAN 10 hours per week;	Attending Regular Early Childhood Program LESS THAN 10 hours per week; receiving majority of special education and related services in REGULAR EARLY CHILDHOOD PROGRAM. A program that includes at least 50% nondisabled children. This may include, but is not limited to: Head Start; kindergarten; preschool classes offered to an eligible prekindergarten population by the public school system; private kindergarten 9 or preschool; group child development center or child care.
PB2	PB2 Attending Regular Early Childhood Program LESS THAN 10 hours per week;	Attending Regular Early Childhood Program LESS THAN 10 hours per week; receiving majority of special education and related services in SOME OTHER LOCATION. A program that includes at least 50% nondisabled children. This may include, but is not limited to: Head Start; kindergarten; preschool classes offered to an eligible pre-kindergarten population by the public school system; private kindergarten 9 or preschool; group child development center or child care.
PD	PD Separate Class.	Separate Class. Attends a special education program in a class intended primarily for children with disabilities (less than 50% nondisabled children). This may include, but is not limited to classrooms in: regular school buildings, trailers, or portables outside regular school buildings; child care facilities; hospital facilities on an outpatient basis; or other community-based settings. (Do not include children who also attended a Regular Early Childhood Program.)
PE	PE Separate School	Separate School. l. Receives all special education and related services in public or private day schools designed specifically for children with disabilities. (Do not include children who also attended a Regular Early Childhood Program.)
PG	PG Residential Facility	Residential Facility. Receives all special education and related services in public or private residential schools or residential medical facilities on an inpatient basis. (Do not include children who also attended a Regular Early Childhood Program.)
PH1	PH1 Home AT LEAST 360 minutes per week.	PH1 Home AT LEAST 360 minutes per week.
PH2	PH2 Home LESS THAN 360 minutes per week.	Home LESS THAN 360 minutes per week. Receives all special education and related services in the principal residence of the child’s family or caregiver and attended neither a regular early childhood program nor a special education program provided in a separate class, separate school, or residential facility. Include children who received special education both at the home and in a service provider location or some other location that is not in any other category. The term caregiver includes babysitters.
PJ	PJ PJ-Private School placement, enrolled by parent(s). Students enrolled by	Private School placement; enrolled by parent(s). Student enrolled by parents or guardians in a regular parochial or other private school that meets the definition of a common school district. 6 There is no entitlement to special education and related services. However, a PEA must expend a proportionate amount of federal funding on students in this type of private placement from IDEA 611 and preschool 619 funds.
PS	PS Service Provider Location or some other location that is not in any othe	Service Provider Location or some other location that is not in any other category for. less than 360 minutes per week. Receives all special education and related services from. a service provider and who attended neither a regular early childhood program nor a special education program provided in a separate class, separate school, or residential facility; and did not receive special education and related services in the home. This includes services received at a private clinician’s office; clinician’s office located in a school building; or hospital facility on an outpatient basis.