Aeries Software

IMPORTANT:

Texas State Reporting - Code Translations
Code Set: Special Ed Disability Types (CSE.D12). 

• C053-03 > DC142-06
• C053-05 > DC142-02

If the student's CSE.D1, CSE.D2, or CSE.D3 is mapped to a valid DC142 value, the <Disability> element in the extract file will display the Code Translation from the DC142 table.

<LocalEducationAgency id="LEA_CCCDDD">

<StateOrganizationId>CCCDDD</StateOrganizationId>

</LocalEducationAgency>

where CCC = LOC.CC and DDD = LOC.DC 

 <ProgramReference ref="PGRM_33" />

</LocalEducationAgency>

where CCC = LOC.CC and DDD = LOC.DC; included when SPR.CD = 33 exists

(Entered at each applicable school, then aggregated by the program at district level)

<StateOrganizationId>CCCDDDSSS</StateOrganizationId>

<LocalEducationAgencyReference ref="LEA_ID_CCCDDD"/>

</School>

where CCC = LOC.CC and DDD = LOC.DC and SSS = LOC.SC

<Program id="PGRM_33">

<ProgramType>Special Education</ProgramType>

</Program>

included when SPR.CD = 33 exists

NOTE: Be sure a Code Translation is entered for Program Type (SPR.CD) for Special Education code 33.

<StudentUniqueStateId>UUUUUUUUUU</StudentUniqueStateId>

</Student>

where SSS = LOC.SC and UUUUUUUUUU = STU.CID

<StudentIdentificationCode IdentificationSystem="State">

<IdentificationCode>CCCCCCCCC</IdentificationCode>

</StudentIdentificationCode>

</Student>

where SSS = LOC.SC and UUUUUUUUUU = STU.CID and and CCCCCCCCC = ESD.ED

<StudentIdentificationCode IdentificationSystem="State">

<IdentificationCode>CCCCCCCCC</IdentificationCode>

</StudentIdentificationCode>

</Student>

where SSS = LOC.SC and UUUUUUUUUU = STU.CID and CCCCCCCCC = ESD.ED

<StudentIdentificationCode IdentificationSystem="District">

<IdentificationCode>DDDDDD</IdentificationCode>

</StudentIdentificationCode>

</Student>

where SSS = LOC.SC and UUUUUUUUUU = STU.CID and DDDDDD = STU.ID

<Student id="SCID_SSS_UUUUUUUUUU">

<Name>

<FirstName>First</FirstName>

</Name>

</Student>

where SSS = LOC.SC and UUUUUUUUUU = STU.CID and First = STU.FN

<Student id="SCID_SSS_UUUUUUUUUU">

<Name>

<MiddleName>Middle</MiddleName>

</Name>

</Student>

where SSS = LOC.SC and UUUUUUUUUU = STU.CID and Middle = STU.MN

<Student id="SCID_SSS_UUUUUUUUUU">

<Name>

<LastSurname>Last</LastSurname>

</Name>

</Student>

where SSS = LOC.SC and UUUUUUUUUU = STU.CID and Last = STU.LN

</Name>

</Student>

<Student id="SCID_SSS_UUUUUUUUUU">

<TX-Sex>Male/Female</TX-Sex>

</Student>

where SSS = LOC.SC and UUUUUUUUUU = STU.CID and Male/Female = STU.GN

IMPORTANT: Full DC119 Code Translation is used rather than code. 

<Student id="SCID_SSS_UUUUUUUUUU">

<BirthData>

<BirthDate>YYYY-MM-DD</BirthDate>

</BirthData>

</Student>

where SSS = LOC.SC and UUUUUUUUUU = STU.CID and YYYY-MM-DD = STU.BD

<Student id="SCID_SSS_UUUUUUUUUU">

<TX-HispanicLatinoEthnicity>true/false</TX-HispanicLatinoEthnicity>

</Student>

where SSS = LOC.SC and UUUUUUUUUU = STU.CID and true/false = true if STU.ETH=Y; otherwise false

<Student id="SCID_SSS_UUUUUUUUUU">

<TX-Race>

<RacialCategory>Race</RacialCategory>

</TX-Race>

</Student>

where SSS = LOC.SC and UUUUUUUUUU = STU.CID and Race = 

• 'American Indian - Alaskan Native' if STU.RC=01
• 'Asian' if STU.RC=02
• 'Black - African American' if STU.RC=03
• 'Native Hawaiian - Pacific Islander' if STU.RC=04
• 'White' if STU.RC1=05

<Student id="SCID_SSS_UUUUUUUUUU">

<LimitedEnglishProficiency>Description</LimitedEnglishProficiency>

</Student>

where SSS = LOC.SC and UUUUUUUUUU = STU.CID and Description = 

• 'NotLimited' if STU.LF = 0, 01, or blank
• 'Limited' if STU.LF = 1 or 02
• 'Limited Monitored 1' if STU.LF = 03 or F
• 'Limited Monitored 2' if STU.LF = 04 or 5

<Student id="SCID_SSS_UUUUUUUUUU">

<Disabilities>

<TX-EffectiveDateDisabilities>YYYY-MM-DD</TX-EffectiveDateDisabilities>

</Disabilities>

</Student>

where SSS = LOC.SC and UUUUUUUUUU = STU.CID and YYYY-MM-DD = CSE.ED

Business Rule (FATAL):

• 40100-0205: If age is less than 9 on September 1, and DISABILITY is "Deaf-Blindness (Deaf-Blind)" or "Hearing/Auditory Impairment (Auditory Impairment)", then EFFECTIVE-DATE must not be blank.

<Student id="SCID_SSS_UUUUUUUUUU">

<Disabilities>

<Disability>Description</Disability>

</Disabilities>

</Student>

where SSS = LOC.SC and UUUUUUUUUU = STU.CID and Description = 

• 'Hearing/Auditory Impairment (Auditory Impairment)' if CSE.DI/D2/D3=03, and code is mapped to TSDS/PEIMS Code 06.
• 'Deaf-Blindness (Deaf-Blind)' if CSE.DI/D2/D3=05, and code is mapped to TSDS/PEIMS Code 02.
  

Business Rules (FATAL):

• 40100-0204: If age is less than 9 on September 1, and DISABILITY is "Deaf-Blindness (Deaf-Blind)" or "Hearing/Auditory Impairment (Auditory Impairment)", there must be a Special Education program association reported with a matching TX-UNIQUE-STUDENT-ID, including INSTRUCTIONAL-SETTING-CODE, LANG-ACQ-SERVICES-PROVIDED, FREQUENCY-OF-SERVICES, HOURS-SPENT-RECEIVING-SERVICES, and PREFERRED-HOME-COMMUNICATION-METHOD.
• 40100-0205: If age is less than 9 on September 1, and DISABILITY is "Deaf-Blindness (Deaf-Blind)" or "Hearing/Auditory Impairment (Auditory Impairment)", then EFFECTIVE-DATE must not be blank.

<Student id="SCID_SSS_UUUUUUUUUU">

<TX-LEAReference>

<EducationalOrgIdentity>

<StateOrganizationId>CCCDDD</StateOrganizationId>

</EducationalOrgIdentity>

</TX-LEAReference

</Student>

<StudentSpecialEdProgramAssociationExtension>

<StudentReference>

<StudentIdentity>

<StudentUniqueStateId>UUUUUUUUUU</StudentUniqueStateId>

</StudentIdentity>

</StudentReference>

</StudentSpecialEdProgramAssociationExtension>

where UUUUUUUUUU = STU.CID

Business Rule (FATAL):

• 40100-0204: If age is less than 9 on September 1, and DISABILITY is "Deaf-Blindness (Deaf-Blind)" or "Hearing/Auditory Impairment (Auditory Impairment)", there must be a Special Education program association reported with a matching TX-UNIQUE-STUDENT-ID, including INSTRUCTIONAL-SETTING-CODE, LANG-ACQ-SERVICES-PROVIDED, FREQUENCY-OF-SERVICES, HOURS-SPENT-RECEIVING-SERVICES, and PREFERRED-HOME-COMMUNICATION-METHOD.

<StudentSpecialEdProgramAssociationExtension>

<ProgramReference>

<ProgramIdentity>

<ProgramType>Special Education</ProgramType>

<StateOrganizationId>CCCDDDSSS</StateOrganizationId>

</ProgramIdentity>

</ProgramReference>

</StudentSpecialEdProgramAssociationExtension>

where CCC = LOC.CC and DDD = LOC.DC and SSS = LOC.SC

For the SELA collection, PROGRAM-TYPE is "Special Education" (See DR1).

<StudentSpecialEdProgramAssociationExtension>

<EducationOrganizationReference>

<EducationalOrgIdentity>

<StateOrganizationId>CCCDDD</StateOrganizationId>

</EducationalOrgIdentity>

</EducationOrganizationReference>

</StudentSpecialEdProgramAssociationExtension>

where CCC = LOC.CC and DDD = LOC.DC

<StudentSpecialEdProgramAssociationExtension>

<EducationOrganizationReference>

<EducationalOrgIdentity>

<TX-InstructionalSetting>XX</TX-InstructionalSetting>

</EducationalOrgIdentity>

</EducationOrganizationReference>

</StudentSpecialEdProgramAssociationExtension>

where XX = CHS.INS

• 40100-0204: If age is less than 9 on September 1, and DISABILITY is "Deaf-Blindness (Deaf-Blind)" or "Hearing/Auditory Impairment (Auditory Impairment)", there must be a Special Education program association reported with a matching TX-UNIQUE-STUDENT-ID, including INSTRUCTIONAL-SETTING-CODE.

<StudentSpecialEdProgramAssociationExtension>

<TX-SpecialEducationLanguageAcquisition>

<SchoolReference>

<EducationalOrgIdentity>

<StateOrganizationId>CCCDDDSSS</StateOrganizationId>

</EducationalOrgIdentity>

</SchoolReference>

</TX-SpecialEducationLanguageAcquisition>

</StudentSpecialEdProgramAssociationExtension>

where CCC = LOC.CC and DDD = LOC.DC and SSS = LOC.SC

<StudentSpecialEdProgramAssociationExtension>

<TX-SpecialEducationLanguageAcquisition>

<TX-PreferredHomeCommunicationMethod>Description</TX-PreferredHomeCommunicationMethod>

</TX-SpecialEducationLanguageAcquisition>

</StudentSpecialEdProgramAssociationExtension>

where Description = CSE.HC; omitted if null/blank

IMPORTANT: Full DC155 Code Translation is used rather than code.

• 40100-0204: If age is less than 9 on September 1, and DISABILITY is "Deaf-Blindness (Deaf-Blind)" or "Hearing/Auditory Impairment (Auditory Impairment)", there must be a Special Education program association reported with a matching TX-UNIQUE-STUDENT-ID, including PREFERRED-HOME-COMMUNICATION-METHOD.

<TX-SpecialEducationLanguageAcquisition>

<TX-LanguageAcquisitionServicesProvided>

<TX-LangAcqServicesProvided>Description</TX-LangAcqServicesProvided>

</TX-LanguageAcquisitionServicesProvided>

</TX-SpecialEducationLanguageAcquisition>

</StudentSpecialEdProgramAssociationExtension>

where Description = LAV.SV; omitted if null/blank

IMPORTANT: Full DC156 Code Translation is used rather than code.

Business Rules (FATAL):

• 40100-0204: If age is less than 9 on September 1, and DISABILITY is "Deaf-Blindness (Deaf-Blind)" or "Hearing/Auditory Impairment (Auditory Impairment)", there must be a Special Education program association reported with a matching TX-UNIQUE-STUDENT-ID, including LANG-ACQ-SERVICES-PROVIDED.
• 41163-0062: If LANG-ACQ-SERVICES-PROVIDED is "Services not Provided", then FREQUENCY-OF-SERVICES must be "None" and HOURS-SPENT-RECEIVING-SERVICES must be "0 Hours".
• 41163-0063: If FREQUENCY-OF-SERVICES is "None", then LANG-ACQ-SERVICES-PROVIDED must be "Services not Provided".
• 41163-0064: If HOURS-SPENT-RECEIVING-SERVICES is "0 Hours", then LANG-ACQ-SERVICES-PROVIDED must be "Services not Provided".
• 41163-0065: If LANG-ACQ-SERVICES-PROVIDED is "Services not Provided", then this student must not be reported with any other LANG-ACQ-SERVICES-PROVIDED value.

<TX-SpecialEducationLanguageAcquisition>

<TX-LanguageAcquisitionServicesProvided>

<TX-FrequencyOfServices>Description</TX-FrequencyOfServices>

</TX-LanguageAcquisitionServicesProvided>

</TX-SpecialEducationLanguageAcquisition>

</StudentSpecialEdProgramAssociationExtension>

where Description = LAV.FR; omitted if null/blank

IMPORTANT: Full DC157 Code Translation is used rather than code.

Business Rules (FATAL):

• 40100-0204: If age is less than 9 on September 1, and DISABILITY is "Deaf-Blindness (Deaf-Blind)" or "Hearing/Auditory Impairment (Auditory Impairment)", there must be a Special Education program association reported with a matching TX-UNIQUE-STUDENT-ID, including FREQUENCY-OF-SERVICES.
• 41163-0062: If LANG-ACQ-SERVICES-PROVIDED is "Services not Provided", then FREQUENCY-OF-SERVICES must be "None".
• 41163-0063: If FREQUENCY-OF-SERVICES is "None", then LANG-ACQ-SERVICES-PROVIDED must be "Services not Provided" and HOURS-SPENT-RECEIVING-SERVICES must be "0 Hours".
• 41163-0064: If HOURS-SPENT-RECEIVING-SERVICES is "0 Hours", then LANG-ACQ-SERVICES-PROVIDED must be "Services not Provided".

<TX-SpecialEducationLanguageAcquisition>

<TX-LanguageAcquisitionServicesProvided>

<TX-HoursSpentReceivingServices>Description</TX-HoursSpentReceivingServices>

</TX-LanguageAcquisitionServicesProvided>

</TX-SpecialEducationLanguageAcquisition>

</StudentSpecialEdProgramAssociationExtension>

where Description = LAV.HR; omitted if null/blank

IMPORTANT: Full DC158 Code Translation is used rather than code.

• 40100-0204: If age is less than 9 on September 1, and DISABILITY is "Deaf-Blindness (Deaf-Blind)" or "Hearing/Auditory Impairment (Auditory Impairment)", there must be a Special Education program association reported with a matching TX-UNIQUE-STUDENT-ID, including HOURS-SPENT-RECEIVING-SERVICES.
• 41163-0062: If LANG-ACQ-SERVICES-PROVIDED is "Services not Provided", then HOURS-SPENT-RECEIVING-SERVICES must be "0 Hours".
• 41163-0063: If FREQUENCY-OF-SERVICES is "None", then HOURS-SPENT-RECEIVING-SERVICES must be "0 Hours".
• 41163-0064: If HOURS-SPENT-RECEIVING-SERVICES is "0 Hours", then LANG-ACQ-SERVICES-PROVIDED must be "Services not Provided" and FREQUENCY-OF-SERVICES must be "None".

<TX-SpecialEducationLanguageAcquisition>

<TX-HearingAmplification>

<TX-HearingAmplificationType>Description</TX-HearingAmplificationType>

</TX-HearingAmplification>

</TX-SpecialEducationLanguageAcquisition>

</StudentSpecialEdProgramAssociationExtension>

where Description = HAM.TY; omitted if null/blank
IMPORTANT: Full DC159 Code Translation is used rather than code.

• 41163-0057: If HEARING-AMPLIFICATION-TYPE is a value other than blank or "Not Applicable", then HEARING-AMPLIFICATION-ACCESS must not be blank.
• 41163-0066: If HEARING-AMPLIFICATION-TYPE is "Not Applicable", the student must not be reported with any other HEARING-AMPLIFICATION-TYPE value.
• 41163-0070: If HEARING-AMPLIFICATION-TYPE is "Not Applicable", then HEARING-AMPLIFICATION-ACCESS and HEARING-AMPLIFICATION-AVERAGE-DAILY-USE must be blank/not reported.

<TX-SpecialEducationLanguageAcquisition>

<TX-HearingAmplification>

<TX-HearingAmplificationAccess>Description</TX-HearingAmplificationAccess>

</TX-HearingAmplification>

</TX-SpecialEducationLanguageAcquisition>

</StudentSpecialEdProgramAssociationExtension>

where Description = HAM.AC; omitted if null/blank

IMPORTANT: Full DC160 Code Translation is used rather than code.

• 41163-0057: If HEARING-AMPLIFICATION-TYPE is a value other than blank or "Not Applicable", then HEARING-AMPLIFICATION-ACCESS must not be blank.
• 41163-0059: If HEARING-AMPLIFICATION-ACCESS is "Partial Day", then HEARING-AMPLIFICATION-AVERAGE-DAILY-USE must not be blank.
• 41163-0060: If HEARING-AMPLIFICATION-AVERAGE-DAILY-USE is not blank, then HEARING-AMPLIFICATION-ACCESS must be "Partial Day".
• 41163-0070: If HEARING-AMPLIFICATION-TYPE is "Not Applicable", then HEARING-AMPLIFICATION-ACCESS must be blank/not reported.

<TX-SpecialEducationLanguageAcquisition>

<TX-HearingAmplification>

<TX-HearingAmplifAvgDailyUse>Description</TX-HearingAmplifAvgDailyUse>

</TX-HearingAmplification>

</TX-SpecialEducationLanguageAcquisition>

</StudentSpecialEdProgramAssociationExtension>

where Description = HAM.AD; omitted if null/blank

IMPORTANT: Full DC161 Code Translation is used rather than code.

• 41163-0058: If HEARING-AMPLIFICATION-ACCESS is "Full Day", then HEARING-AMPLIFICATION-AVERAGE-DAILY-USE must be blank.
• 41163-0059: If HEARING-AMPLIFICATION-ACCESS is "Partial Day", then HEARING-AMPLIFICATION-AVERAGE-DAILY-USE must not be blank.
• 41163-0060: If HEARING-AMPLIFICATION-AVERAGE-DAILY-USE is not blank, then HEARING-AMPLIFICATION-ACCESS must be "Partial Day".
• 41163-0070: If HEARING-AMPLIFICATION-TYPE is "Not Applicable", then HEARING-AMPLIFICATION-AVERAGE-DAILY-USE must be blank/not reported.

<TX-SpecialEducationLanguageAcquisition>

<TX-LanguageAcquisitionAssessmentReportingCategory>

<TX-ToolOrAssessmentUsed>Description</TX-ToolOrAssessmentUsed>

</TX-LanguageAcquisitionAssessmentReportingCategory>

</TX-SpecialEducationLanguageAcquisition>

</StudentSpecialEdProgramAssociationExtension>

where Description = LAA.TA; omitted if null/blank

IMPORTANT: Full DC162 Code Translation is used rather than code.

• 41163-0061: If TOOL-OR-ASSESSMENT-USED is a value other than blank or "Not Assessed", then ASSESSMENT-RESULTS-OBTAINED must not be blank.
• 41163-0067: If TOOL-OR-ASSESSMENT-USED is "Not Assessed", the student must not be reported with any other TOOL-OR-ASSESSMENT-USED value.
• 41163-0069: If TOOL-OR-ASSESSMENT-USED is "Not Assessed", then ASSESSMENT-RESULTS-OBTAINED must be blank/not reported.

<TX-SpecialEducationLanguageAcquisition>

<TX-LanguageAcquisitionAssessmentReportingCategory>

<TX-AssessmentResultsObtained>Description</TX-AssessmentResultsObtained>

</TX-LanguageAcquisitionAssessmentReportingCategory>

</TX-SpecialEducationLanguageAcquisition>

</StudentSpecialEdProgramAssociationExtension>

where Description = LAA.RE; omitted if null/blank

IMPORTANT: Full DC163 Code Translation is used rather than code.

• 41163-0061: If TOOL-OR-ASSESSMENT-USED is a value other than blank or "Not Assessed", then ASSESSMENT-RESULTS-OBTAINED must not be blank.
• 41163-0069: If TOOL-OR-ASSESSMENT-USED is "Not Assessed", then ASSESSMENT-RESULTS-OBTAINED must be blank/not reported.