The following entities are included in the Teaching and Learning domain:


Entity: Course

Entity: Course Offering

Entity: Section

Entity: StaffSectionAssociation

Entity: StudentSectionAssociation


Level 1 Errors - Teaching and Learning


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: Course

All State Course Codes are pre-loaded into your IODS by TEA.  This entity only syncs local Services ID's. These Service ID's will load into your IODS as a Level 1.5 filter and will NOT promote unless you map them in your DMC to a State Course Codes. See TWEDS Course Code list for the most recent Service Id's pre-loaded by TEA.

NOTE:  If you do not use any local Service ID's, when you sync the Course Entity the results box will indicate: There are no results


Element ID
(Code Table)
Data Element NameAeries PageLabel & 
Aeries Table.Field
ReferenceEducationOrganizationSee Education Organization domain > LocalEducationAgency entity (LocalEducationAgencyID element)
E3071CourseCodeCourses (Other tab)Service ID
CRS.SVC
Only custom service IDs are sent
E3073CourseTitleCoursesTitle
CRS.CO
.CourseIdentificationCode (multiple allowed)
E3075 (C350)CourseIdentificationSystemHard-coded as 02 - Local Course Code
E3076IdentificationCodeCourses (Other tab)Service ID
CRS.SVC

Entity: Course Offering


Element ID
(Code Table)
Data Element NameAeries PageLabel & 
Aeries Table.Field
ReferenceSchoolSee Education Organization domain > School entity (SchoolID element)
ReferenceCourseSee Teaching and Learning domain > Course entity
E1194LocalCourseCodeCoursesCrsID#
CRS.CN


Note:  All courses with a Course Attendance (CAR) or Transcript (HIS) record in the current school year are sent in the Course Offering entity.  If the course or sections are inactive and this course offering record should not be sent,  CAR and HIS records for the current school year related to that course should be deleted.


Entity: Section

(multiple allowed)


Element ID
(Code Table)
Data Element NameAeries PageLabel & 
Aeries Table.Field
ReferenceCourseOfferingSee Teaching and Learning domain > CourseOffering entity
E1056SectionIdentifierCourse AttendanceSchool
CAR.SC
Course AttendanceCrs ID
CAR.CN
Course AttendanceSection
CAR.SE
CAR.SC+CAR.CN+CAR.SE
.SectionSet (multiple allowed)
E0747 (C030)PopulationServedMaster SchedulePopulation Served
MST.PSV
Courses > OtherPopulation Served
CRS.PSV *
Ed-Fi Descriptor Code Set Mapping: Population Served Descriptor (CRS.PSV) *

MST.PSV if populated; otherwise
CRS.PSV if populated;
otherwise blank
E3059 (C342)SPEDStudentAgeRange
*This is a required data element
Master SchedulePopulation Served
MST.PSV
Courses > OtherPopulation Served
CRS.PSV
Master ScheduleGrd Range
MST.LO
MST.PSV if populated; otherwise
CRS.PSV if populated;
otherwise blank

If PSV is blank or <> 06 = 00 Not Providing Services to SPED Students

If PSV = 06 AND MST.LO is EE or PK* = 01
Otherwise 02.

*Based on grades mapped in the Grade Level Descriptor (STU.GR)
E0948 (C135)CourseSequenceCourses > OtherCrs Seq
CRS.CSQ *
Ed-Fi Descriptor Code Set Mapping: Tx Course Sequence Descriptor (CRS.CSQ) *
E1072 (C182)NonCampusBasedInstructionMaster ScheduleNon-Campus Inst
MST.NCI
Courses > OtherNon-Campus Inst
CRS.NCI *
Ed-Fi Descriptor Code Set Mapping: Tx Non Campus Based Instruction Descriptor (CRS.NCI) *

MST.NCI if populated; otherwise
CRS.NCI if populated;
otherwise blank
E1579 (C206)PKCurriculaMaster SchedulePK Curricula
MST.CT *
Early Childhood DevelopmentCurriculum
EDC.CT
Ed-Fi Descriptor Code Set Mapping: Tx Pk Curricula Descriptor (MST.CT) *

MST.CT if populated; otherwise
EDC.CT;
otherwise blank
E1580 (C311)HighQualityPKProgramMaster ScheduleHigh Quality PK Program
MST.HQP
Master ScheduleInstruction Type
MST.SIT *
Early Childhood DevelopmentInstruction TYpe
EDC.SIT *
Ed-Fi Descriptor Code Set Mapping: Tx Pk Student Instruction Descriptor (MST.SIT) *

1 if selected; otherwise 0
E1555 (C310)PKSchoolTypeMaster SchedulePK Schl Type
MST.PKT *
School OptionsPK School Type
LOC.PKT *
Early Childhood DevelopmentPK School Type
ECD.PKT *
In Development

Ed-Fi Descriptor Code Set Mapping: Tx Pk School Type Descriptor (MST.PKT) *

MST.PKT if populated; otherwise
LOC.PKT if populated; otherwise
ECD.PKT
E1055 (C179)ClassTypeMaster ScheduleClass Type
MST.CTY *
Courses > OtherClass Type
CRS.CTY *
Staff > Job AssignmentsInstruction Type
STJ.IT *
Ed-Fi Descriptor Code Set Mapping: Tx Class Type Descriptor (CRS.CTY) *

MST.CTY if populated; otherwise
CRS.CTY; otherwise
If no course section association exists then STJ.IT
E3011CTEHoursMaster ScheduleCTE V-Code
MST.CH
E3010BeginDate
Calendar
date (unlabeled)
DAY.DT
The minimum (i.e., earliest) date of the school year for the school
E3020EndDate
Calendar
date (unlabeled)
DAY.DT
The first day after the last instructional day in the current school year the data elements in the SectionSet were associated to the section
If the EndDate is the last day of school, the next date is extracted. 
E1726ChildCareOperationNumberMaster ScheduleChild Care Operation Number
MST.CCO
Course History InstitutionsPartnering Childcare Facility
CHI.PCF
Course History InstitutionsID Number
CHI.ID
In Development
when CHI.PCF = 1 (selected) for the corresponding CHI.ID




Entity: StaffSectionAssociation


Element ID
(Code Table)
Data Element NameAeries PageLabel & 
Aeries Table.Field
ReferenceStaffSee Staff domain > Staff entity (StaffUniqueID element)
Staff ID from SIS/Vendor must match.
ReferenceSectionSee Teaching and Learning domain > Section entity
E3010BeginDate
Master Schedule - Section Staff Members
Start Date
SSE.SD
Course AttendanceStart Date
CAR.DS
  • Flex scheduling: SSE.SD
  • Traditional scheduling: CAR.DS
First record

Note:  NULL values in SSE.SD will default to the start of school date from the school calendar (DAY).
E3020EndDateMaster Schedule - Section Staff Members
End Date
SSD.ED
Course AttendanceEnd Date
CAR.DE
  • Flex scheduling: SSE.ED
  • Traditional scheduling: CAR.DE
Most recent record.  

Note:  NULL values in SSE.ED will default to the End of school date from the school calendar (DAY).


  • If EndDate exists for a section in SSE.ED or CAR.DE, the EndDate is sent as the next instructional date.
  • If EndDate is last day of school, 'null' is sent.
  • If EndDate is not present, 'null' is sent.
E1454 (C309)ClassroomPositionMaster Schedule, ORPosition
MST.TP1
Master Schedule - Section Staff MembersPosition
SSE.TP
  • Traditional scheduling: MST.TP1
  • Flex scheduling: SSE.TP if State Rpt (SSE.STR) = Y

Most recent record
E0170NumberofStudentsinClassMaster ScheduleTotal
MST.TS
Staff > Job AssignmentsNumber of Students
STJ.NOS
If no course section association exists then STJ.NOS
E1057MonthlyMinutesMaster ScheduleMonthly Minutes
MST.MMN
StaffMST.MMN
MST.MMN is populated when district clicks Calculate Monthly Minutes on Master Schedule.
Omitted if 0.
See Texas- Calculate Monthly Minutes.
E1604
E1605
E1606
E1607
NumberDaysTaughtWeek1
NumberDaysTaughtWeek2
NumberDaysTaughtWeek3
NumberDaysTaughtWeek4
CoursesPE
CRS.PE = 1 (selected)
Master Schedule

MST

School OptionsBEL
CalendarBEL, DAY
Calculated for 1st, 2nd, 3rd, and 4th weeks of the 4 weeks in October that include the last Friday in October, only if CRS.PE = 1
E1608
E1609
E1610
E1611
NumberMinutesTaughtWeek1
NumberMinutesTaughtWeek2
NumberMinutesTaughtWeek3
NumberMinutesTaughtWeek4
CoursesPE
CRS.PD = 1 (selected)
Master ScheduleMST
School OptionsBEL
CalendarBEL, DAY
Calculated for 1st, 2nd, 3rd, and 4th weeks of the 4 weeks in October that include the last Friday in October, only if CRS.PE = 1
E1015SharedServiceArrangementStaff
Not extracted from Aeries

E1763AdditionalDaysProgramTeacherNot Developed



Entity: StudentSectionAssociation

Element ID
(Code Table)
Data Element NameAeries PageLabel & 
Aeries Table.Field
ReferenceStudentSee Student Identification and Demographics domain > Student entity
ReferenceSectionSee Teaching and Learning domain > Section entity
E3010BeginDateCourse AttendanceStart Date
CAR.DS
E3020EndDateCourse AttendanceStop Date
CAR.DE
The date after the last instructional date the student was assigned to the section is extracted.
E1440HomeroomIndicatorCourses > Other

Service ID

CRS.SVC


Course Attendancesequence number - not displayed
CAR.SQ

(ECDS-KG) true if CRS.SVC= 01020000

(ECDS-PK) true if CRS.SVC = 01010000


  • Based on course enrollment on the day extract is run.
  • If student has multiple CRS.SVC = 01020000/01010000 sections, the section with the lowest CAR.SQ is indicated as Homeroom.
  • For PK, the extract automatically attaches the homeroom indicator to sections that meet the ECDS PK criteria.
E1068CourseCompletionIndicatorTranscriptsMark
HIS.MK
1 if HIS.MK contains a grade (whether passing or not); otherwise 0
NOTE: Grade X does not count toward course completion. 


Level 1 Errors - Teaching and Learning


See Also: Ed-Fi - Troubleshooting Errors.


TSDS ErrorRecommendation

{message: “The value supplied for the related 'course' resource does not exist.”}

Verify that course was loaded to ODS in the Course entity.  
If the course referenced for this error is an inactive course and/or section, then ensure all CAR and HIS records for the current school year related to that course are deleted. 

400 BAD_REQUEST

{message: “Unable to resolve value 'uri:/tea.texas.gov/GradeLevelDescriptor#5' to an existing

'GradeLevelDescriptor' resource.”}

Verify that grade level has leading 0.

409 CONFLICT

{message: “The value supplied for the related 'session' resource does not exist.”}

Verify that session was loaded to ODS.

400 BAD_REQUEST

{message: “Validation of 'Section' failed. Validation of 'AggregateExtensions' failed. Validation of 'SectionSets (TX)' failed. SectionSet[0]: The field CTEHours must be between 1 and 3.”}

Verify that CTE Hours is between 1 and 3.

400 BAD_REQUEST

A natural key conflict occurred when attempting to update a new resource with a duplicate key. 

This is caused by multiple resources with the same key in the same file. Exactly one of these resources was updated.
400 BAD_REQUEST

Validation of ‘StaffSectionAssociation’ failed. ClassroomPositionDescriptorID is required.


The Classroom Postion’s are hardcoded so there is no descriptor mapping for this code set.  This record has a missing or blank classroom position on the Master Schedule in the Section Staff Members section.


Select a valid Position for the Staff Role


409 CONFLICT

{message: “The value supplied for the related 'courseOffering' resource does not exist.”}

Verify that a course exists for the section in course offerings.

403 FORBIDDEN

{message: “Authorization denied. No relationships have been established between the caller's education organization id claim (194902) and one or more of the following properties of the resource item: 'SchoolId', 'StaffUniqueId'.}

Verify that staff member was loaded to ODS.

409 CONFLICT

{message: “The value supplied for the related 'section' resource does not exist.”}

Verify that section was loaded to ODS.

409 CONFLICT

{message: “Access to the resource item could not be authorized because the 'Staff' was not found.”}

Verify that staff member was loaded to ODS.

409 CONFLICT

{message: “The value supplied for the related 'section' resource does not exist.”}

Verify that section was loaded to ODS.

403 FORBIDDEN

{message: “Authorization denied. No relationships have been established between the caller's education organization id claim (194902) and one or more of the following properties of the resource item: 'SchoolId', 'StudentUniqueId'.”}

Verify that student is associated with school.
"There are no Results’ and 0 records uploaded" (when syncing the course entity)

If you do not use any local course codes, this is the expected result.  The TEA preloads the Course Entity information into each LEA's individual operational data store (IODS) on a yearly basis. Only state course codes are loaded by the TEA.