The following entities are included in the Education Organization domain:
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 Name | Aeries Page | Label & 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) * | |||
E3037 | NameOfInstitution | School Options (district) | District Name LOC.NM |
E0212 | LocalEducationAgencyId | School Options (district) | County + District LOC.CC + LOC.DC |
E3036 (C337) | LocalEducationAgencyCategory | School Options (district) | Charter Status LOC.CHS |
E1556 | TotalNumSchoolBoardRequests | School Options (district) | Total Number of School Board Requests DPT.NM = TX-TotalNumSchoolBoardRequests |
E1557 | TotalCostSchoolBoardRequests | School Options (district) | Total Cost of School Board Requests DPT.NM = TX-TotalCostSchoolBoardRequests |
E1583 | FamilyEngagementPlanLink | School Options (district) | Family Engagement Plan Link DPT.NM = TX-FamilyEngagementPlanLink |
E1625 (C217) | ArmedServicesVocAptBattery | School 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) | GiftedTalentedProgram | School 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) | PKProgramEvaluationType | School Options (district) | PK Program Evaluation Type DPT.NM = TX-ProgramEvaluationType |
Entity: School ↑
Criteria for inclusion:
Aeries Page | Label & 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 Name | Aeries Page | Label & 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) * | |||
E3037 | NameOfInstitution | School Options (district) | District Name LOC.NM |
Reference | LocalEducationAgency | See Education Organization domain > LocalEducationAgency entity (LocalEducationAgencyID element) | |
E0266 | SchoolId | School 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 | |||
E1646 | PKFullDayWaiver | School 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 | |||
E1671 | AdditionalDaysProgram | Attendance Reporting Periods | Instructional Program ARP.IP = 16 |
Reporting Period ARP.RP = 9 | |||
Only applies to grade levels PK-05 NOT CURRENTLY USED. | |||
E1727 | NumberOfBullyingIncidents | School Options (school) | Bullying Incidents OPT.NM = NumberofBullyingIncidents |
E1728 | NumberOfCyberbullyingIncidents | School Options (school) | Cyber Bullying Incidents OPT.NM = NumberofCyberbullyingIncidents |
E1613 | ExpandedLearningOpportunity | Expanded Learning Opportunities | ELO Type ELO.TY |
True if ELO.TY is not blank | |||
.CampusEnrollmentTypeSet (multiple sets allowed) | |||
E1641 (C219) | CampusEnrollmentType | School Options (school) | Campus Enrollment Type LOC.ET * |
Ed-Fi Descriptor Code Set Mapping: Tx Campus Enrollment Type Descriptor (LOC.ET) * | |||
E3010 | BeginDate | first day of the current school year | |
E3020 | EndDate | last day of the current school year | |
.NSLPTypeSet (multiple sets allowed) | |||
E1591 (C212) | NSLPType | School Options (school) | NSLP LOC.NLP * |
Ed-Fi Descriptor Code Set Mapping: Tx NSLP Type Descriptor (LOC.NLP) * | |||
E3010 | BeginDate | first day of the current school year | |
E3020 | EndDate | last day of the current school year | |
.CharterWaitlistSet | |||
E1674 | NumberCharterStudentsEnrolled | Enrollment History | Calculated ENR |
Total number of students enrolled when the data is synced (nightly or on demand) | |||
E1675 | CharterEducationalEnrollmentCapacity | School Options (school) | Enrollment Capacity LOC.EC |
E1676 | CharterAdmissionWaitlist | School Options (school) | Utilize Waitlist LOC.UW |
.ELOSet (multiple sets allowed) | |||
E1614 (C218) | ELOType | Expanded Learning Opportunities (school) | ELO Type ELO.TY * |
.ELOActivity Set (multiple sets allowed) | |||
E1719 (C229) | ELOActivity | Expanded Learning Opportunities (school) | Activity Code ELO.CD * |
Ed-Fi Descriptor Code Mapping: Tx Elo Activity Descriptor (ELO.CD) * | |||
E1720 | ELODaysSchedule | Expanded Learning Opportunities (school) | Days per Year ELO.DPY |
Valid values are 1-210 | |||
E1621 | ELOMinutesScheduledPerDay | Expanded 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 Error | Recommendation |
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 |