The following entities are included in the Alternative and Supplemental Services domain:


Entity: Program

Entity: StudentCTEProgramAssociation (In Development)

Entity: StudentTitleIPartAProgramAssociation (In Development)

Entity: StudentSpecialEducationProgramAssociation

Entity: StudentLanguageInstructionProgramAssociation


Level 1 Errors - Alternative and Supplemental Services



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

  • Each program is reported only once with the district EducationOrganization ID.
  • A program is only included if Program Start and End date are within current school year.
  • IMPORTANT: Only programs in the C303 table are sent. See below.

Element ID
(Code Table)
Data Element NameAeries PageLabel &
Aeries Table.Field
ReferenceEducationOrganization
(multiple allowed)
See Education Organization domain > LocalEducationAgency entity (LocalEducationAgencyID element)
Only included if program start/end dates are within current school year
E3049ProgramNameSchool Programs (district or school)Program Type
SPR.CD
Each program is reported once per district EdOrg ID.
E1337 (C303)ProgramTypeSchool ProgramsHard-coded
Only the following programs are sent:
  • Bilingual (04)
  • Career and Technical Education (05)
  • English as a Second Language (ESL) (12)
  • Special Education (33)
  • Title I Part A (38)



Entity: StudentCTEProgramAssociation (In Development)

The following information is subject to change.

Element ID
(Code Table)
Data Element NameAeries PageLabel & 
Aeries Table.Field
ReferenceEducationOrganizationSee Education Organization domain > School entity (SchoolID element)
ReferenceStudentSee Student Identification and Demographics domain > Student entity
ReferenceProgramSee Alternative and Supplemental Services domain > Program entity
E3010BeginDateJuly 1 (current school year)
E3020EndDateJune 30 (current school year)
.CTEProgramService (multiple allowed)
E3012 (C064)CTEProgramServiceSpecial ProgramsProgram Type
PGM.TY
Special Programs
Program Code
PGM.CD
Free and Reduced
CTE Transportation
FRE.CTR
Hard-coded:
  • 2 if PGM.CD = 163 and PGM.TY = 2
  • 7 if PGM.CD = 163 and PGM.TY = 7
  • 8 if PGM.CD = 154
  • 9 of FRE.CTR = Yes
E3055ServiceBeginDateSpecial ProgramsStart Date
PGM.PSD
Course Attendance
Start Date
CAR.DS
PGM.PSD for codes 2, 7,and 8.
CAR.DS for code 9.
E3056ServiceEndDateSpecial ProgramsEnd Date
PGM.PED
Course Attendance
Stop Date

CAR.DE

PGM.PED for codes 2, 7,and 8.
CAR.DE for code 9.



Entity: StudentTitleIPartAProgramAssociation

Element ID
(Code Table)
Data Element NameAeries PageLabel & 
Aeries Table.Field
ReferenceEducationOrganizationSee Education Organization domain > School entity
Enrollment HistorySchool
ENR.SC
Enrollment HistoryCampus of Accountability
ENR.HS
LOC.CC + LOC.DC + ENR.HS if present; otherwise ENR.SC
ReferenceStudentSee Student Identification and Demographics domain > Student entity
ReferenceProgramSee Alternative and Supplemental Services domain > Program entity (Title I Part A code 38)
E3010BeginDateEnrollment History, or
Enter Date
ENR.ED
Special ProgramsStart Date
PGM.PSD
Only sent if within current school year
E3020EndDate
Not Synced as not in Ed-Fi database structure.

E0894 (C122)TitleIPartAParticipantSchool Options (school), orTitle I Part A
LOC.T1
Special ProgramsType
PGM.TY
Special ProgramsCode
PGM.CD
  • PGM.TY if PGM.CD = 121 or 122, or
  • LOC.T1
    • 6 - If all students attend a Title I, Part A schoolwide program school
    • 7 - If all students are receiving Title I, Part A services at a targeted assistance school
E0894 (C122)TitleIPartAParticipantSchool Options (school), orTitle I Part A
LOC.T1
Special Programs
Type
PGM.TY
Special Programs
Code
PGM.CD
  • PGM.TY if PGM.CD = 121 or 122, or
  • LOC.T1
    • 6 - If all students attend a Title I, Part A schoolwide program school
    • 7 - If all students are receiving Title I, Part A services at a targeted assistance school
E3066

StudentTitleIPartAProgramAssociationSetBeginDate

Enrollment History, or
Enter Date
ENR.ED

Special Programs
Start Date
PGM.PSD
First instructional day in current school year where the student was assigned to TitleIPartAParticipant descriptor
E3067

StudentTitleIPartAProgramAssociationSetEndDate

Enrollment History, or
Leave Date

ENR.LD

Special Programs
End Date
PGM.PED
Last instructional date in current school year on which the student was assigned to TitleIPartAParticipant descriptor



Entity: StudentSpecialEducationProgramAssociation

Element ID
(Code Table)
Data Element NameAeries PageLabel & 
Aeries Table.Field
ReferenceEducationOrganizationSee Education Organization domain > School entity
Enrollment HistorySchool
ENR.SC
LOC.CC + LOC.DC + ENR.SC
ReferenceStudentSee Student Identification and Demographics domain > Student entity
ReferenceProgramSee Alternative and Supplemental Services domain > Program entity (Special Education code 33)
E3010BeginDateSpecial EducationEntry Date
CSE.ED
E3020EndDateSpecial EducationExit Date
CSE.XD
E1661 (C313)

PreferredHomeCommunicationMethod

Special Education (Language Acquisition tab)Preferred Home Communication
CSE.HC
.StudentSPEDProgramAssociationSet
E0999MedicallyFragileSpecial Education (Instructional Settings tab)Medically Fragile
CSH.MF
1 if CSH.MF = Yes  
0 if CHS.MF = No
E0882MultiplyDisabledSpecial Education (Instructional Settings tab)Multiply Disabled
CSH.MD
1 if CSH.MD = Yes
0 if CHS.MD = No 
E1527LEAOfRDSPDServiceSpecial Education (Student Services tab)Dist of Service
CSV.DS
Code
CSV.CD = 801
Special Education (Instructional Settings tab)Start Date/End Date
CSH.SD/CSH.ED
The student's most recent record where CSV.CD = 801 within the CSH.SD/CSH.ED date range
E0832 (C066)ChildCountFundingSpecial Education (Instructional Settings tab)Child Funding Type
CHS.CFT
Omitted if 0 or blank.
E1077 (C184)PPCDServiceLocationSpecial Education (Instructional Settings tab)ECSE Serv Location (PPCD)
CSH.FP
E3047ProgramBeginDateSpecial Education (Instructional Settings tab)Start Date
CSH.SD
If active anytime during the current school year
E3048ProgramEndDateSpecial Education (Instructional Settings tab)End Date
CSH.ED
If active anytime during the current school year
.InstructionalSettingSet
E0173 (C035)InstructionalSettingSpecial Education (Instructional Settings tab)Instructional Setting
CSH.INS
E3025InstructionalSettingBeginDateSpecial Education (Instructional Settings tab)Start Date
CSH.SD
E3026InstructionalSettingEndDateSpecial Education (Instructional Settings tab)End Date
CSH.ED
.Disability
E3015 (C053)DisabilitySpecial Education (Disabilities History tab)Primary Disability
DHS.D1
Special Education (Disabilities History tab)Secondary Disability
DHS.D2
Special Education (Disabilities History tab)Tertiary Disability
DHS.D3
.DisabilitySet
E3039OrderOfDisabilitySpecial Education (Disabilities History tab)Primary Disability
DHS.D1
Secondary Disability
DHS.D2
Tertiary Disability
DHS.D3
DHS.D1 = 1
DHS.D2 = 2
DHS.D3 = 3
Omitted if 0
E1723

EligibilityDateDisabilities

Special Education (Disabilities History tab)Start Date
DHS.SD
Only reported if:
  • Student is deaf or hard of hearing (i.e., if DHS.D1, DHS.D2, or DHS.D3 = 03 or 05), and 
  • SHS.SD is in current school year
E3016

DisabilitySetBeginDate

Special Education (Disabilities History tab)Start Date
DHS.SD
  • If Start Date is before the school year, the school start date for that school is used. 
  • Only disabilities active at some time during the current school year are sent.
E3017

DisabilitySetEndDate

Special Education (Disabilities History tab)Ending Date
DHS.ED
.SpecialEducationProgramService
E3058 (C341)SpecialEducationProgramServiceSpecial Education (Student Services tab)Service
CSV.CD *
Ed-Fi Descriptor Code Set Mapping: Special Education Program Service Descriptor (CSV.CD) *

If multiple records exist with the same active CSV.CD within the school year, only the most recent is sent.
E3055ServiceBeginDateSpecial Education (Student Services tab)Start Date
CSV.DT
E3056ServiceEndDateSpecial Education (Student Services tab)Ending Date
CSV.ED
.LanguageAcquisition (IN DEVELOPEMENT, subject to change) 
E1662 (C314)LangAcqServicesProvidedSpecial Education (Language Acquisition tab)Language Acquisition Services - Service
LAV.SV
Start Date/End Date
LAV.SD/LAV.ED
LAV.SV if extract date is within LAV.SD and LAV.ED
  • 00 if not receiving service
  • If multiple records exist with the same code, the most recent is used
E1663 (C315)FrequencyOfServicesSpecial Education (Language Acquisition tab)Language Acquisition Services - Frequency
LAV.FR
E1664 (C316)HoursSpentReceivingServicesSpecial Education (Language Acquisition tab)Language Acquisition Services - Hrs Rcd
LAV.HR
.HearingAmplification  (IN DEVELOPEMENT, subject to change)
E1665 (C317)HearingAmplificationTypeSpecial Education (Language Acquisition tab)Hearing Amplification - Type
HAM.TY
If multiple records exist with the same code, the most recent is used.
E1666 (C318)HearingAmplificationAccessSpecial Education (Language Acquisition tab)Hearing Amplification - Access
HAM.AC
Start Date/End Date
HAM.SD/HAM.ED
If extract date is within HAM.SD and HAM.ED
E1667 (C319)HearingAmplificationDailyUseSpecial Education (Language Acquisition tab)Hearing Amplification - Avg Daily Use
HAM.AD
.Assessment (IN DEVELOPEMENT, subject to change)
E1668 (C320)ToolOrAssessmentUsedSpecial Education (Language Acquisition tab)Language Acquisition Assessment - Tool/Assessment
LAA.TA
If multiple records exist with the same code, the most recent is used.
E1669 (C321)AssessmentResultsObtainedSpecial Education (Language Acquisition tab)Language Acquisition Assessment - Result
LAA.RE
.StudentResidentialFacilityAssociation (IN DEVELOPEMENT, subject to change)
E1627ResidentialFacilityIdSpecial Education (Residential Facility tab)Facility ID
RFH.FID
E1630DateEnteredRFSpecial Education (Residential Facility tab)Entry Date
RFH.ED
E1631DateExitedRFSpecial Education (Residential Facility tab)Leave Date
RFH.LD
..StudentResFacAssocSet  (IN DEVELOPEMENT, subject to change)
E3064

StudentResFacAssocSetBeginDate

Special Education (Residential Facility tab, click Add Details)Effective Start Date
RFD.ESD
E3065

StudentResFacAssocSetEndDate

Special Education (Residential Facility tab)Leave Date
RFH.LD 
E1633

AttendanceZoneCampus

Special Education (Residential Facility tab, click Add Details)School of Attendance Zone
RFD.SAZ
E1634

EducatedAtResidentialFacility

Special Education (Residential Facility tab, click Add Details)Educated at Facility
RFD.EF
E1635

SurrogateParentAssigned

Special Education (Residential Facility tab, click Add Details)Surrogate Parent
RFD.SP
E1636

NumberOtherStudentsAssigned
SameSurrogateParent

Special Education (Residential Facility tab, click Add Details)Other Students w/same Surrogate
RFD.OSS
E1637

ResidentialFacilityStudentSchoolDayLength

Special Education (Residential Facility tab, click Add Details)RF Day Length
RFD.RDL
E1638

CampusIdOfEnrollmentSchoolDayLength

Special Education (Residential Facility tab, click Add Details)School Day Length
RFD.SDL

 


Entity: StudentLanguageInstructionProgramAssociation

  • Only includes students in the Bilingual or English as a Second Language (ESL) Program with an active PGM.CD = 146 or 147 within current school year. 


Element ID
(Code Table)
Data Element NameAeries PageLabel & 
Aeries Table.Field
ReferenceEducationOrganizationSee Education Organization domain > School entity
Enrollment HistorySchool       ENR.SC
LOC.CC + LOC.DC + ENR.SC
ReferenceStudentSee Student Identification and Demographics domain > Student entity
ReferenceProgramSchool ProgramsProgram Type
SPR.CD
Special ProgramsProgram Code
PGM.CD
See Alternative and Supplemental Services domain > Program entity
  • (Bilingual 04) if PGM.CD = 146
  • (English as a Second Language ESL 12) if PGM.CD = 147
E3010BeginDateSpecial ProgramsStart Date
PGM.PSD
  • PGM.PSD for that PGM.CD at that school. 
  • The earliest record is sent for students who have an active PGM record.
E3020EndDateSpecial ProgramsEnd Date
PGM.PED
If blank, a blank is submitted.
.ParentalPermissionSet
E0896 (C093)ParentalPermissionAuthorizations

Code

AUT.CD

AuthorizationsType
AUT.TY

AUT.CD IF AUT.TY = 4

E3042ParentalPermissionSetBeginDateAuthorizations

Status Date

AUT.SDT

Status Dates cannot overlap and cannot be blank.
E3043ParentalPermissionSetEndDateAuthorizations

End Date

AUT.EED

.LanguageInstructionProgramService
E3034 (C335)LanguageInstructionProgramServiceSpecial ProgramsProgram Code
PGM.CD
Special ProgramsProgram Type
PGM.TY
Special ProgramsAlt Lang Prgm
PGM.ALP
PGM.TY if PGM.CD = 146 or 147
Not sent if PGM.TY indicates no services received.
Hard-coded:
  • 146 (Bilingual)
    • Not sent if PGM.TY = 0 (no services received)
    • 042 if PGM.TY = 2
    • 043 if PGM.TY = 3
    • 044 if PGM.TY = 4
    • 045 if PGM.TY = 5
  • 147 (ESL)
    • Not sent if PGM.TY = 0 (no services received)
    • 002 if PGM.TY = 2
    • 003 if PGM.TY = 3
  • Alternative Language Program
    • If PGM.ALP is populated, the code is used and PGM.CD is ignored
    • Not sent if PGM.ALP = 00 (no services received)
    • 046 if PGM.TY = 01
    • 004 if PGM.TY = 02
E3055ServiceBeginDateSpecial ProgramsStart Date
PGM.PSD
Can be in a prior school year
E3056ServiceEndDateSpecial ProgramsEnd Date
PGM.PED

 



Level 1 Errors - Alternative and Supplemental Services

See Also: Ed-Fi - Troubleshooting Errors.


TSDS ErrorRecommendation

400 BAD_REQUEST

{message: “Validation of 'StudentCTEProgramAssociation' failed.\n\tStudent reference could not be resolved.\n.”}

Verify that the student is loaded into the ODS.

400 BAD_REQUEST

{message: “Validation of 'StudentLanguageInstructionProgramAssociation' failed. Student reference could not be resolved.”}

Verify that the student is loaded into the ODS.


400 BAD_REQUEST

{message: “Validation of 'StudentSpecialEducationProgramAssociation' failed. Student reference could not be resolved. ”}

Verify that the student is loaded into the ODS.


400 BAD_REQUEST

{message: “Validation of 'StudentSpecialEducationProgramAssociation' failed.\n\tUnable to resolve value 'uri:/tea.texas.gov/ToolOrAssessmentUsedDescriptor#01' to an existing 'ToolOrAssessmentUsedDescriptor' resource.\n.”}

Verify Language Acquisition Assessment - Tool/Assessment (LAA.TA) on Special Education > Language Acquisition

400 BAD_REQUEST

{message: “Validation of 'StudentSpecialEducationProgramAssociation' failed. Validation of 'AggregateExtensions' failed. Validation of

'StudentSpecialEducationProgramAssociationStudentResidentialFacilityAssociations (TX)' failed.”}

Review Residential Facility data.


400 BAD_REQUEST

{message: “Validation of 'StudentTitleIPartAProgramAssociation' failed. Student reference could not be resolved.”}

Verify that the student is loaded into the ODS.


409 CONFLICT

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

Verify that the student is loaded into the ODS.


Exception has been thrown by the target of an invocation., Exception has been thrown by the target of an invocation., Error calling PostStudentLanguageInstructionProgramAssociation: { "message": "An unexpected error occurred on the server.

There are overlapping Parental Permission Records or Authorizations without a status or end date.

Delete one of the overlapping parental permission records from the Authorizations or Language Assessment page or edit the dates so they are no longer overlapping.
Enter all Authorization Status dates (AUT.SDT)