The following entities are included in the Education Organization domain:


Entity: LocalEducationAgency

Entity: School


Level 1 Errors - Education Organization



Most TEA Ed-Fi codes are hard-coded in Aeries and do not need to be mapped.

* An asterisk in the Label & Aeries Table.Field column indicates a code set where local codes can be used. Any local codes used by the district must be mapped to TEA Ed-Fi codes on School Info > Imports and Exports > Ed-Fi Code Mappings.


Entity: LocalEducationAgency

Element ID
(Code Table)
Data Element NameAeries PageLabel & 
Aeries Table.Field
E0319 (C331)EducationOrganizationCategory
(multiple allowed)
School Options (district)Org Category
LOC.CSA *
Ed-Fi Descriptor Code Set Mapping: Education Organization Category Descriptor (LOC.CSA) *
E3037NameOfInstitutionSchool Options (district)District Name
LOC.NM
E0212LocalEducationAgencyIdSchool Options (district)County + District
LOC.CC + LOC.DC
E3036 (C337)LocalEducationAgencyCategorySchool Options (district)Charter Status
LOC.CHS
E1556TotalNumSchoolBoardRequestsSchool Options (district)Total Number of School Board Requests
DPT.NM = TX-TotalNumSchoolBoardRequests
E1557TotalCostSchoolBoardRequestsSchool Options (district)Total Cost of School Board Requests
DPT.NM = TX-TotalCostSchoolBoardRequests
E1583FamilyEngagementPlanLinkSchool Options (district)Family Engagement Plan Link
DPT.NM = TX-FamilyEngagementPlanLink
E1625 (C217)ArmedServicesVocAptBatterySchool Options (district)Armed Services Voc Apt Indicator
DPT.NM = TX-ArmedServicesVocAptBatteryIndicator
E1643 (C220)ProgramOfStudy
(multiple allowed)
Programs of Study (district)Program Code
DPS.CD *
End Date
DPS.ED
Ed-Fi Descriptor Code Set Mapping: Tx Program Of Study Descriptor (DPS.CD) *

DPS.CD where DPS.ED is blank

Programs of study are pulled if entered on the Programs of Study page regardless of start/end dates. A program of study must be deleted if no longer offered.
E1645 (C223)GiftedTalentedProgramSchool Programs (district)Program Type
SPR.CD *
Begin Date
SPR.SD in within the current school year
End Date
SPR.ED is BlankNull
Ed-Fi Descriptor Code Set Mapping: Tx Gifted Talented Program Descriptor (SPR.CD) *

SPR.CD = 01-05 where SPR.ED is blank
E1626 (C216)PKProgramEvaluationTypeSchool Options (district)PK Program Evaluation Type
DPT.NM = TX-ProgramEvaluationType


Entity: School

Criteria for inclusion:

Aeries PageLabel & 
Aeries Table.Field
School Options Session
LOC.U = 0, 1, or 2
Tag
LOC.TG = Null (i.e., Active)
DNR (Do not report)
LOC.DNR = Null
County + District + Campus
LOC.CC + LOC.DC + LOC.SC = state-assigned numbers 



Element ID
(Code Table)
Data Element NameAeries PageLabel & 
Aeries Table.Field
E0319 (C331)EducationOrganizationCategory
(multiple allowed)
School Options (district)Org Category
LOC.CSA *
Ed-Fi Descriptor Code Set Mapping: Education Organization Category Descriptor (LOC.CSA) *
E3037NameOfInstitutionSchool Options (district)District Name
LOC.NM
ReferenceLocalEducationAgencySee Education Organization domain > LocalEducationAgency entity (LocalEducationAgencyID element)
E0266SchoolIdSchool Options (school)County + District + Campus
LOC.CC + LOC.DC + LOC.SC
E0017 (C050)GradeLevel
(multiple allowed)
School Options (school)Low Grade
LOC.LO *
High Grade
LOC.HI *
Ed-Fi Descriptor Code Set Mapping: Grade Level Descriptor (STU.GR) *

Any grades above 12 (e.g., TR & 14-18) must be mapped to Grade 12 
E1646PKFullDayWaiverSchool Options (school)PK Full Day Waiver
OPT.NM = PK_Full_Day_Waiver
Low Grade/High Grade
LOC.LO/LOC.HI
Only extracted for schools where LOC.LO/LOC.HI indicate a PK school
E1671AdditionalDaysProgramAttendance Reporting PeriodsInstructional Program
ARP.IP = 16
Reporting Period
ARP.RP = 9
Only applies to grade levels PK-05
NOT CURRENTLY USED.
E1727NumberOfBullyingIncidentsSchool Options (school)Bullying Incidents
OPT.NM = NumberofBullyingIncidents
E1728NumberOfCyberbullyingIncidentsSchool Options (school)Cyber Bullying Incidents
OPT.NM = NumberofCyberbullyingIncidents
E1613ExpandedLearningOpportunityExpanded Learning OpportunitiesELO Type
ELO.TY
True if ELO.TY is not blank
.CampusEnrollmentTypeSet (multiple sets allowed)
E1641 (C219)CampusEnrollmentTypeSchool Options (school)Campus Enrollment Type
LOC.ET *
Ed-Fi Descriptor Code Set Mapping: 

Tx Campus Enrollment Type Descriptor (LOC.ET) *

E3010BeginDate
first day of the current school year
E3020EndDate
last day of the current school year
.NSLPTypeSet (multiple sets allowed)
E1591 (C212)NSLPTypeSchool Options (school)NSLP
LOC.NLP *
Ed-Fi Descriptor Code Set Mapping: Tx NSLP Type Descriptor (LOC.NLP) *
E3010BeginDate
first day of the current school year
E3020EndDate
last day of the current school year
.CharterWaitlistSet
E1674NumberCharterStudentsEnrolledEnrollment HistoryCalculated
ENR
Total number of students enrolled when the data is synced (nightly or on demand)
E1675CharterEducationalEnrollmentCapacitySchool Options (school)Enrollment Capacity
LOC.EC
E1676CharterAdmissionWaitlistSchool Options (school)Utilize Waitlist
LOC.UW
.ELOSet (multiple sets allowed)
E1614 (C218)ELOTypeExpanded Learning Opportunities (school)ELO Type
ELO.TY *
.ELOActivity Set (multiple sets allowed)
E1719 (C229)ELOActivityExpanded Learning Opportunities (school)Activity Code
ELO.CD *
Ed-Fi Descriptor Code Mapping: Tx Elo Activity Descriptor (ELO.CD) *
E1720ELODaysScheduleExpanded Learning Opportunities (school)Days per Year
ELO.DPY
Valid values are 1-210 
E1621ELOMinutesScheduledPerDayExpanded Learning Opportunities (school)Minutes Scheduled per Day
ELO.MD
Valid values are 45-480 


Level 1 Errors - Education Organization

See Also: Ed-Fi - Troubleshooting Errors.


TSDS ErrorRecommendation

400 BAD_REQUEST

{message: “Validation of 'School' failed.\n\tSchoolGradeLevels requires at least one object in the collection.\n.”}

Verify Low Grade (LOC.LO) and High Grade (LOC.HI) on School Options