Arizona Ed-Fi Data v3.1 - Schools | Infinite Campus Test

Classic View: System Administration > Ed-Fi

Search Terms: Ed-Fi

This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups. This field only accepts numeric values for the School ID so some states may implement a different State School Number for Ed-Fi. See state specific logic for more information.

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 Entity ID to determine reporting school.

School Exclude, Calendar Exclude, Resource Toggle and Resync Logic

This table describes the School Exclude, Calendar Exclude, Resource Toggle and Resync logic of this object.

Action	Business Rule
None	No data will send for a school after it is marked as excluded.
None	If the School is marked as exclude after the School or any dependent data is sent, the data will remain in the ODS. The user must use the Delete tool to delete any dependent data that as sent for that school.
None	If a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS and no new data will send.
Resync	If an Ed-Fi Code mapping is changed to a new code or made NULL, a resync must be performed for the data to be updated in the ODS

Natural Key Changes, Cascading Updates, and Delete Logic

This table describes the Natural Key Changes/Cascading Updates and Delete logic of this object.

Action	Business Rule
Post	Natural Key change: Ed-Fi School ID or State School Number: If the School Number/Ed-Fi School Number changes, a delete/post will occur with the cascading deletes from the School ID/Ed-Fi ID Change triggers.
Delete	If the School ID changes all dependent resources will be deleted and re-posted: Calendars, Class Periods, Courses, Course Offerings, Discipline Incidents, Grading Periods, Locations, Sessions, Staff Education Organization Assignment Associations, Staff Education Organization Employment Associations, Staff School Associations, Student School Associations, Student School Attendance Events
Delete	Resources with SchoolID Reference from a Dependent Resource: Calendar Dates, Staff Section Associations, Student Section Associations, Student Section Attendance Events, Grades, Student Discipline Incident Associations, Discipline Actions, Course Transcripts

Action

Business Rule

Post

Natural Key change: Ed-Fi School ID or State School Number:

If the School Number/Ed-Fi School Number changes, a delete/post will occur with the cascading deletes from the School ID/Ed-Fi ID Change triggers.

Delete

If the School ID changes all dependent resources will be deleted and re-posted:

Calendars, Class Periods, Courses, Course Offerings, Discipline Incidents, Grading Periods, Locations, Sessions, Staff Education Organization Assignment Associations, Staff Education Organization Employment Associations, Staff School Associations, Student School Associations, Student School Attendance Events

Delete

Resources with SchoolID Reference from a Dependent Resource:

Calendar Dates, Staff Section Associations, Student Section Associations, Student Section Attendance Events, Grades, Student Discipline Incident Associations, Discipline Actions, Course Transcripts

Scope Year Logic

Data does not send for any of the resources if they reference a school that is marked as Exclude on the School editor.

Logic
Schools are not aligned to a year so all schools send to each scoped year with a valid configuration.
A resync must be completed on the resource when a new scope year is connected in order for this data to send.

Resource Preferences

This table describes the Resource Preferences of this object.

Data Element Label	Campus Object/Field
gradeLevelDescriptor	Uses the overall 'Grade Levels' mapping
schoolCategoryDescriptor	School > Grade Type
schoolTypeDescriptor	School> School Type

Identity Mapping Object Key

This table describes the Identity Mapping Object Key of this object.

campusObjectType	Object Key Data Source
School	school.number

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus Table	Ed-Fi Action	Fields
school	Post/Put/Delete	The primary table used for sending data for this resource
grade	Put	Will update the Grade Levels field if a grade level is added/removed to the school and a mapping exists for that grade level

Error Log

This table describes the Error logic of this object.

Error	Possible Causes/How to Fix
403 Forbidden: {"message": "Access to the resource could not be authorized for the requested action 'http://ed-fi.org/odsapi/actions/create'."}	This is usually caused by a security set up error in the ODS. Contact the Ed-Fi Alliance for assistant on correct security setup in the ODS.
Ed-Fi. 400: [message:Validation of 'School' failed. EducationOrganizationAddresses requires at least one object in the collection. ].	The physical address fields must be populated on the School editor as address is a mandatory field to send the Schools resource.
Ed-Fi. 400: [message:Validation of 'School' failed. SchoolGradeLevels requires at least one object in the collection. ].	At least 1 grade level must be created under System Administration> Calendar> Calendar> Grade Levels.
The School ID being sent is non-numeric. Enter a numeric Ed-Fi School Number or State School Number on the Schools editor to correct this issue.	Ed-Fi does not accept alpha-values in the School ID field. If the State School Number has any alpha characters, use the Ed-Fi School ID field to create a numeric school number to send.

Object Data Elements

This table describes data elements sent within the Schools resource.

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
id	The unique identifier of the resource.		M
addresses	The set of elements that describes the physical location of the education entity, including the street address, city, state, ZIP code, and ZIP code + 4.	Reports the Physical Address entered for the School. See Array section for field logic.	O
educationOrganizationCategories	The classification of the education agency within the geographic boundaries of a state according to the level of administrative and operational control granted by the state.	See Array section for field logic.	O
gradeLevels	The grade levels served at the school.	See Array section for field logic.	M
schoolId	The School Identity Column.	Look up using the School Entity ID.	M	System Administration> Resources> School> Entity ID	school.entityID
charterApprovalSchoolYearTypeReference	Key for School Year.	This is optional, does not report.	O
localEducationAgencyReference	A reference to the related Local Education Agency resource.	Reports the fields that are part of the Natural Key for the resource.	O
administrativeFundingControlDescriptor	The type of education institution as classified by its funding source, for example public or private.	This is optional, does not report.	O
charterApprovalAgencyTypeDescriptor	The type of agency that approved the establishment or continuation of a charter school.	This is optional, does not report.
charterStatusDescriptor	A school or agency providing free public elementary or secondary education to eligible students under a specific charter granted by the state legislature or other appropriate authority and designated by such authority to be a charter school	This is optional, does not report.	O
identificationCodes	A unique number or alphanumeric code assigned to an education organization by a school, school system, a state, or other agency or entity.	See Array section for field logic.	O
institutionTelephones	The 10-digit telephone number, including the area code, for the education entity.	See Array section for field logic.	O
internationalAddresses	The set of elements that describes the international physical location of the education entity.	This is optional, does not report.	O
internetAccessDescriptor	Indicates the type of Internet access that is available.	This is optional, does not report.	O
magnetSpecialProgramEmphasisSchoolDescriptor	A school that has been designed: 1) to attract students of different racial/ethnic backgrounds for the purpose of reducing, preventing, or eliminating racial isolation; and/or 2) to provide an academic or social focus on a particular theme (e.g., science/math, performing arts, gifted/talented, or foreign language).	This is optional, does not report.	O
nameOfInstitution	The full, legally accepted name of the institution.	Report the School Name.	M	System Administration> Resources> School	school.name
operationalStatusDescriptor	The current operational status of the education organization (e.g., active, inactive).	This is optional, does not report.	O
schoolCategories	The one or more categories of school. For example: High School, Middle School, and/or Elementary School.	See Array section below.	O
schoolTypeDescriptor	The type of education institution as classified by its primary focus.	Report the type of school from the mapped value in school type if populated on the reporting school.	O	System Administration> Resources> School> School Type	school.type
shortNameOfInstitution	A short name for the institution.	Report the School Name.	O	System Administration> Resources> School	school.name
titleIPartASchoolDesignationDescriptor	Denotes the Title I Part A designation for the school.	This is optional, does not report.	O
webSite	The public web site address (URL) for the educational organization.	This is optional, does not report.	O
etag			O

Array Data Elements

Education Organization Address

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
addressTypeDescriptor	Key for Address.	All addresses will report as 'Physical'.	M
stateAbbreviationDescriptor	The abbreviation for the state (within the United States) or outlying area in which an address is located.	Reports the State for the address being reported.	M	System Administration> Resources> School Information	school.physicalstate
apartmentRoomSuiteNumber	The apartment, room, or suite number of an address.	This is optional, does not report.	O
buildingSiteNumber	The number of the building on the site, if more than one building shares the same address.	This is optional, does not report.	O
city	The name of the city in which an address is located.	Reports the Physical City for the address being reported.	M	System Administration> Resources> School Information	school.physicalcity
countyFIPSCode	5 digit code consisting of the two digit state code followed by the three digit FIPS code for the county.	This is optional, does not report.	O
doNotPublishIndicator	An indication that the address should not be published.	This is optional, does not report.	O
latitude	The geographic latitude of the physical address.	This is optional, does not report.	O
longitude	The geographic longitude of the physical address.	This is optional, does not report.	O
nameOfCounty	The name of the county, parish, borough, or comparable unit (within a state) in which an address is located.	This is optional, does not report.	O
postalCode	The five or nine digit zip code portion of an address.	Reports the Zip Code for the address being reported.	M	System Administration> Resources> School Information	school.physicalzip
streetNumberName	The street number and street name or post office box number of an address.	Reports the Physical Address	M	System Administration> Resources> School Information	school.physicaladdress
periods	The time periods for which the address is valid. For physical addresses, the periods in which the person lived at that address.	This is optional, does not report.

Education Organization Category

Data Element Label	Business Requirement	Business Rules	M,C,O	Localized Logic	Data Source GUI Path	Database Field	Format
educationOrganizationCategoryDescriptor	The classification of the education agency within the geographic boundaries of a state according to the level of administrative and operational control granted by the state.	Always report 'School'	M				string

School Grade Level

Data Element Label	Business Requirement	Business Rules	M,C,O	Data Source GUI Path	Database Field
gradeLevelDescriptor	The grade levels served at the school.	Report all unique Grade Levels for the school that are mapped to an Ed-Fi Grade Level. Report all distinct grades from all eligible calendars/schedule structures in the school. Do not report if the Grade Level is in a Calendar marked as Exclude. If a grade level is not mapped, do not report.	M	System Administration> Calendar> Calendar> Grade Levels	gradelevel.name

Education Organization Identification Code

Data Element Label

Business Requirement

Business Rules

M,C,O

Data Source GUI Path

Database Field

educationOrganizationIdentificationSystemDescriptor

This descriptor defines the originating record system and code that is used for record-keeping purposes by education organizations.

Always Report 'SEA'

identificationCode

A unique number or alphanumeric code assigned to a space, room, site, building, individual, organization, program, or institution by a school, school system, a state, or other agency or entity.

Report the Ed-Fi School Number
If the Ed-Fi School Number is blank, report the State School Number

System Administration> Resources> School

school.entityID

school.number

Education Organization Institution Telephone

Data Element Label	Business Requirement	Business Rules	M,C,O	Data Source GUI Path	Database Field
institutionTelephoneNumberTypeDescriptor	Type of Phone Number.	Always report 'Main'.	M
telephoneNumber	The telephone number including the area code, and extension, if applicable.	Report the Phone Number entered. If blank, do not report.	M	System Administration> Resources> School Information	school.phone

Data Element Label

Business Requirement

Business Rules

M,C,O

Data Source GUI Path

Database Field

institutionTelephoneNumberTypeDescriptor

Type of Phone Number.

Always report 'Main'.

telephoneNumber

The telephone number including the area code, and extension, if applicable.

Report the Phone Number entered.

If blank, do not report.

System Administration> Resources> School Information

school.phone

School Categories

Data Element Label	Business Requirement	Business Rules	M,C,O	Data Source GUI Path	Database Field
schoolCategoryDescriptor	The category of school. For example: High School, Middle School, Elementary School.	Reports if the Grade Type is mapped to a School Category Descriptor in Schools preferences. If the Grade Type is blank or not mapped, do not report.	M	System Administration> Resources> Schools> Grade Type	schools.gradeType

Type/Descriptor Layout

Address Type Descriptor

Code Value	Short Description	Name Space	Description
Billing	Billing	uri://ed-fi.org/AddressTypeDescriptor	Billing
Doubled - up (i.e., living with another family)	Doubled - up (i.e., living with another family)	uri://ed-fi.org/AddressTypeDescriptor	Doubled - up (i.e., living with another family)
Father Address	Father Address	uri://ed-fi.org/AddressTypeDescriptor	Father Address
Guardian Address	Guardian Address	uri://ed-fi.org/AddressTypeDescriptor	Guardian Address
Home	Home	uri://ed-fi.org/AddressTypeDescriptor	Home
Hotels/Motels	Hotels/Motels	uri://ed-fi.org/AddressTypeDescriptor	Hotels/Motels
Mailing	Mailing	uri://ed-fi.org/AddressTypeDescriptor	Mailing
Mother Address	Mother Address	uri://ed-fi.org/AddressTypeDescriptor	Mother Address
Other	Other	uri://ed-fi.org/AddressTypeDescriptor	Other
Physical	Physical	uri://ed-fi.org/AddressTypeDescriptor	Physical
Shelter, Transitional housing, Awaiting Foster	Shelter, Transitional housing, Awaiting Foster	uri://ed-fi.org/AddressTypeDescriptor	Shelter, Transitional housing, Awaiting Foster
Shipping	Shipping	uri://ed-fi.org/AddressTypeDescriptor	Shipping
Temporary	Temporary	uri://ed-fi.org/AddressTypeDescriptor	Temporary
Unsheltered	Unsheltered	uri://ed-fi.org/AddressTypeDescriptor	Unsheltered
Work	Work	uri://ed-fi.org/AddressTypeDescriptor	Work

Education Organization Category Descriptor

Ed-Fi Code Value	Description	Name Space	Short Description
Education Organization Network	Education Organization Network	uri://ed-fi.org/EducationOrganizationCategoryDescriptor	Education Organization Network
Education Service Center	Education Service Center	uri://ed-fi.org/EducationOrganizationCategoryDescriptor	Education Service Center
Local Education Agency	Local Education Agency	uri://ed-fi.org/EducationOrganizationCategoryDescriptor	Local Education Agency
Other	Other	uri://ed-fi.org/EducationOrganizationCategoryDescriptor	Other
Post Secondary Institution	Post Secondary Institution	uri://ed-fi.org/EducationOrganizationCategoryDescriptor	Post Secondary Institution
School	School	uri://ed-fi.org/EducationOrganizationCategoryDescriptor	School
State Education Agency	State Education Agency	uri://ed-fi.org/EducationOrganizationCategoryDescriptor	State Education Agency

Grade Level Descriptor

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

Education Organization Identification System Descriptor

Code Value	Description	Namespace	Short Description
ACT	ACT	uri://ed-fi.org/EducationOrganizationIdentificationSystemDescriptor	ACT
DUNS	DUNS	uri://ed-fi.org/EducationOrganizationIdentificationSystemDescriptor	DUNS
Federal	Federal	uri://ed-fi.org/EducationOrganizationIdentificationSystemDescriptor	Federal
IPEDS	IPEDS	uri://ed-fi.org/EducationOrganizationIdentificationSystemDescriptor	IPEDS
LEA	LEA	uri://ed-fi.org/EducationOrganizationIdentificationSystemDescriptor	LEA
NCES	NCES	uri://ed-fi.org/EducationOrganizationIdentificationSystemDescriptor	NCES
Other	Other	uri://ed-fi.org/EducationOrganizationIdentificationSystemDescriptor	Other
Other Federal	Other Federal	uri://ed-fi.org/EducationOrganizationIdentificationSystemDescriptor	Other Federal
School	School	uri://ed-fi.org/EducationOrganizationIdentificationSystemDescriptor	School
SEA	SEA	uri://ed-fi.org/EducationOrganizationIdentificationSystemDescriptor	SEA
USDE - OPE	USDE - OPE	uri://ed-fi.org/EducationOrganizationIdentificationSystemDescriptor	USDE - OPE

Institution Telephone Number Type Descriptor

Code Value	Description	Namespace	Short Description
Administrative	Administrative	uri://ed-fi.org/InstitutionTelephoneNumberTypeDescriptor	Administrative
Attendance	Attendance	uri://ed-fi.org/InstitutionTelephoneNumberTypeDescriptor	Attendance
Fax	Fax	uri://ed-fi.org/InstitutionTelephoneNumberTypeDescriptor	Fax
Food Service	Food Service	uri://ed-fi.org/InstitutionTelephoneNumberTypeDescriptor	Food Service
Health Clinic	Health Clinic	uri://ed-fi.org/InstitutionTelephoneNumberTypeDescriptor	Health Clinic
Main	Main	uri://ed-fi.org/InstitutionTelephoneNumberTypeDescriptor	Main
Other	Other	uri://ed-fi.org/InstitutionTelephoneNumberTypeDescriptor	Other

School Category Descriptor

Code Value	Description	Namespace	Short Description
Adult School	Adult School	uri://ed-fi.org/SchoolCategoryDescriptor	Adult School
All Levels	All Levels	uri://ed-fi.org/SchoolCategoryDescriptor	All Levels
Elementary School	Elementary School	uri://ed-fi.org/SchoolCategoryDescriptor	Elementary School
Elementary/Secondary School	Elementary/Secondary School	uri://ed-fi.org/SchoolCategoryDescriptor	Elementary/Secondary School
High School	High School	uri://ed-fi.org/SchoolCategoryDescriptor	High School
Infant/toddler School	Infant/toddler School	uri://ed-fi.org/SchoolCategoryDescriptor	Infant/toddler School
Intermediate School	Intermediate School	uri://ed-fi.org/SchoolCategoryDescriptor	Intermediate School
Junior High School	Junior High School	uri://ed-fi.org/SchoolCategoryDescriptor	Junior High School
Middle School	Middle School	uri://ed-fi.org/SchoolCategoryDescriptor	Middle School
Other Combination	Other Combination	uri://ed-fi.org/SchoolCategoryDescriptor	Other Combination
Other Secondary	Other Secondary	uri://ed-fi.org/SchoolCategoryDescriptor	Other Secondary
Preschool/early childhood	Preschool/early childhood	uri://ed-fi.org/SchoolCategoryDescriptor	Preschool/early childhood
Primary School	Primary School	uri://ed-fi.org/SchoolCategoryDescriptor	Primary School
SecondarySchool	SecondarySchool	uri://ed-fi.org/SchoolCategoryDescriptor	SecondarySchool
Ungraded	Ungraded	uri://ed-fi.org/SchoolCategoryDescriptor	Ungraded

School Type Descriptors

Code Value	Description	Namespace	Short Description
Alternative	Alternative	uri://ed-fi.org/SchoolTypeDescriptor	Alternative
Career and Technical Education	Career and Technical Education	uri://ed-fi.org/SchoolTypeDescriptor	Career and Technical Education
Regular	Regular	uri://ed-fi.org/SchoolTypeDescriptor	Regular
Special Education	Special Education	uri://ed-fi.org/SchoolTypeDescriptor	Special Education

Arizona Ed-Fi Data v3.1 - Schools