Schools (Texas v4.0)

Tool Search: 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.

Object Triggering Logic

Action	Trigger
Post	When a new School is created and saved OR the Ed-Fi School Number or State School Number Changes. Do not send if the Exclude checkbox is marked. Do not send if the Schools resource is toggled 'OFF' in the Schools Resource Preferences.
Put	When any of the fields not part of the Natural Key changes: Name of Institution Addresses Institution Telephones Grade Levels School Type Grade Type
Delete	Schools can only be deleted using the Delete Tool only if all dependent data for a school has been removed from the ODS.

Action

Trigger

Post

When a new School is created and saved OR the Ed-Fi School Number or State School Number Changes.

Do not send if the Exclude checkbox is marked.
Do not send if the Schools resource is toggled 'OFF' in the Schools Resource Preferences.

Put

When any of the fields not part of the Natural Key changes:

Name of Institution
Addresses
Institution Telephones
Grade Levels
School Type
Grade Type

Delete

Schools can only be deleted using the Delete Tool only if all dependent data for a school has been removed from the ODS.

School Exclude, Calendar Exclude, Resource Toggle and Resync Logic

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

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 are deleted and reposted.
Dependent Resources	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
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

Business Rules
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.

Identity Mapping Object Key

campusObjectType	Object Key Data Source
School	school.number

Event Queue Detail

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

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.
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.
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.

Object Data Elements

This table describes data elements sent within the Schools resource. Required data elements are listed in bold.

Click here to expand...

Data Element Label	Business Requirement	Business Rules	M, C or O	Location
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
educationOrganization Categories	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 identifier assigned to a school.	Reports the Ed-Fi School ID. Reports the State School Number if the Ed-Fi School ID is blank.	M	System Administration > Resources > School school.entityID or school.number
charterApprovalSchool YearTypeReference	Key for School Year.	This is optional, does not report.	O
localEducation AgencyReference	A reference to the related Local Education Agency resource.	Reports the fields that are part of the Natural Key for the resource.	O
administrativeFunding ControlDescriptor	The type of education institution as classified by its funding source, for example public or private.	This is optional, does not report.	O
charterApprovalAgency TypeDescriptor	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.	This is optional, does not report.	O
institutionTelephones	The 10-digit telephone number, including the area code, for the education entity.	This is optional, does not report.	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
magnetSpecialProgram EmphasisSchoolDescriptor	A school that has been designed to: Attract students of different racial/ethnic backgrounds for the purpose of reducing, preventing, or eliminating racial isolation and / or 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.	Reports the School Name.	M	System Administration > Resources > School school.name
operationalStatus Descriptor	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.	This is optional, does not report.	O
schoolType Descriptor	The type of education institution as classified by its primary focus.	This is optional, does not report.	O
shortNameOfInstitution	A short name for the institution.	Reports the School Name	O	System Administration > Resources > School school.name
titleIPartASchool DesignationDescriptor	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
PKFullDayWaiver	Indicates whether the campus has received an exemption from offering a full-day pre-kindergarten program.	Reports 'True' if the checkbox is marked. Does not report if the checkbox is not marked.	O	System Administration > Resources > School > PKFullDayWaiver
AdditionalDaysProgram	Indicates whether the campus implemented an Additional Days School Year (ADSY) program for any students in prekindergarten through fifth grades as described in TEC §48.0051	Reports 'True' if the checkbox is marked. Does not report if the checkbox is not marked.	O	System Administration > Resources > School > School History
NumberOfBullyingIncidents	Indicates the number of reported incidents of bullying at each campus as defined in TEC §37.0832.	Resync Tool ONLY - Reports SUM of behavior incidents that have a State Event Code = 61	O	Behavior > Behavior Management > Events and Participants > Event Type State Code
NumberOfCyberbullyingIncidents	Indicates the number of reported incidents of cyberbullying at each campus as defined in TEC §37.0832	*This data is not currently collected in Infinite Campus.	O
ExpandedLearningOpportunity	Indicates if a campus offers any expanded learning opportunity (ELO) as listed in TEC §33.252	Reports 'True' if the school has an ELO record that is active at any time during the scope year.	O	System Administration > Resources > School > Expanded Learning Opportunity
CampusEnrollmentTypeSet		See Array section for field logic.	O
NSLPTypeSet		See Array section for field logic.	O
CharterWaitlistSet		This is optional, does not report.	O
ELOSet		See Array section for field logic.	O
etag			O

Array Data Elements

Click here to expand...

Education Organization Address

Data Element Label	Business Requirement	Business Rules	M, C or O	Location
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
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 reports 'School'	M

School Grade Level

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

Campus Enrollment Type Set

Data Element Label	Business Requirement	Business Rules	Location
CampusEnrollmentTypeDescriptor		Reports mapped Ed-Fi Code of Campus Enrollment Type.	System Administration > Resources > School
BeginDate	BeginDate is the first instructional day a campus is assigned to the CampusEnrollmentType descriptor.	Reports the Start Date of the School Year.	System Administration > Calendar > School Years
EndDate	EndDate is the first day after the last instructional day a campus is no longer assigned to the CampusEnrollmentType descriptor.	Reports the End Date of the School Year.	System Administration > Calendar > School Years

NSLP Type Set

Data Element Label	Business Requirement	Business Rules	Location
NSLPTypeDescriptor		If no values exist in the National School Lunch Program(NSLP) AND Provision field is NULL then report '00'. If National School Lunch Program(NSLP) field is checked AND Provision field is NULL then report '01'. If Provision value is 2: Provision 2 AND the NSLP field is checked AND reporting year falls within the Provision Base Year and the Provision End Year, then report '02'. If Provision value is 5: CEP AND the NSLP field is checked AND reporting year falls within the Provision Base Year and the Provision End Year, then report '03'.	System Administration > Resources > School > Original Record > USDA Programs
BeginDate	BeginDate is the first instructional day in the current school year a campus is assigned to the NSLPType descriptor.	Reports the Start Date of the School Year.	System Administration > Calendar > School Years
EndDate	EndDate is the first day after the last instructional day a campus is no longer assigned to the NSLPType descriptor.	Reports the End Date of the School Year.	System Administration > Calendar > School Years

Charter Waitlist Set

Data Element Label	Business Requirement
NumberCharterStudentsEnrolled	The number of students enrolled at a charter school’s campus as of the last Friday in September.
CharterEducationalEnrollmentCapacity	The number of students to which the charter school’s campus is able to provide instruction without exceeding staffing and facility limitations and the approved charter holder's maximum enrollment.
CharterAdmissionWaitlist	Indicates whether the charter school campus uses a waitlist for admission.

ELO Set

Data Element Label	Business Requirement	Business Rules	Namespace	Location
ELOTypeDescriptor	The type of expanded learning opportunity (ELO) program offered at the campus.	Reports the mapped Ed-Fi Code of the ELO Type.	uri://texas.tea.gov	System Administration > Resources > School > Expanded Learning Opportunities > ELO Type
BeginDate	The month, day, and year for the specified data element becomes true of the school.	Reports the Start Date of the School Year.		System Administration > Calendar > School Years
EndDate	The month, day, and year for the specified data element becomes false of the school.	Reports the End Date of the School Year.		System Administration > Calendar > School Years
ELOActivitySet		See Array logic below.

ELO Activity Set

Data Element Label	Business Requirement	Business Rules	Namespace	Location
ELOActivity Descriptor	The specific Expanded Learning Opportunity (ELO) activity offered at the campus.	If the checkbox is marked, reports the indicated code: Rigorous Coursework = 01 Mentoring = 02 Tutoring= 03 Physical Activity= 04 Academic Support = 05 Educational Enrichment = 06	uri://texas.tea.gov	System Administration > Resources > School > Expanded Learning Opportunities
ELODaysScheduledPerYear		Reports ELO Days Per Year.		System Administration > Resources > School > Expanded Learning Opportunities
ELOMinutesScheduledPerDay		Reports ELO Minutes Per Day.		System Administration > Resources > School > Expanded Learning Opportunities

Descriptors / Types

Education Organization Categories

Code	Description	Namespace
01	Education Service Center	uri://tea.texas.gov/EducationOrganizationCategoryDescriptor#01
02	Local Educational Agency	uri://tea.texas.gov/EducationOrganizationCategoryDescriptor#02
03	School	uri://tea.texas.gov/EducationOrganizationCategoryDescriptor#03
04	State Education Agency	uri://tea.texas.gov/EducationOrganizationCategoryDescriptor#04