Overview

Security

Data Maintenance

Configurations

Steps


Overview

The TSDS Special Education Language Acquisition (SELA) Submission is one of the Core Collection Submissions required by the Texas Education Agency (TEA). LEAs must collect and report information about the language acquisition of children eight years of age or younger who are deaf or hard of hearing, based on DISABILITY-TYPE codes 02-Deaf-Blindness (Deaf-Blind) or 06-Hearing/Auditory Impairment (Auditory Impairment).


SELA is only reported if there are eligible students as of the 2020-2021 school year. The submission is not required if there are no eligible students.


Aeries provides tools to extract the appropriate data for the SELA Submission from the district's Student Information System (SIS) database. The extract programs create the files that can be submitted to TEA.


For SELA Submission Timelines, see TWEDS Data Submission Timelines - Special Education Language Acquisition.


For a complete list of extract rules and edits, see TSDS Web-Enabled Data Standards (TWEDS).


Security

The following permissions must be set in Security for users who will be managing TSDS submissions.


Table/Program AreaPermissionDescription
Other - State ReportingAdminRun Texas State Reporting extracts


Additionally, users will need appropriate permission to view or update the individual tables that are used for maintaining data fields used in Texas state reporting.


Data Maintenance

Most state reporting data elements are directly correlated to a field on an Aeries page. Each correlation is documented so you know exactly where the data is maintained in Aeries



Inclusion in the extract file is determined as follows:


CriteriaAeries Table.FieldAeries PageLabel
AgeSTU.BD
DemographicsBirthdate
Determines if the student is 8 or younger on September 1 of the current school year
DisabilityCSE.DI/CSE.D2/CSE.D3 = 03 or 05 


Special Education > Disabilities HistoryPrimary Disability/Secondary Disability/Tertiary Disability 


Determines if the student has values 02 or 06 according to the mapped state codes from TSDS Code Table DC142.
The Primary Disability (CSE.DI), Secondary Disability (CSE.D2), and Tertiary Disability (CSE.D3) fields list values from the TSDS C053 table. These values must be mapped to valid DC142 values. Only those related to SELA (deaf-blind or auditory impairment) need to be added to Code Translations:

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.

Special Education ParticipationCSE.ED/CSE.XD
Special EducationEnter/Exit
Determines if the student is active in special education on date of extract.
Special Ed Program at School
Special Ed Program at District

SPR.CD = 33
School ProgramsProgram Type
Determines that a special education program exists at the school and district. This must be entered for each applicable school; aggregated at district level.
 

A Code Translation must be entered for Program Type (SPR.CD) for code 33.
Texas State Reporting - Code Translations
Code Set: Program Type (SPR.CD). 


Configurations

  • Any local codes used for SELA fields must be added from Update Code Table. The local codes will need to be translated to TSDS codes, described below.


Steps

School Info > Imports and Exports > Texas State Reporting

Before creating extracts, verify the settings on the TSDS/PEIMS Options, Code Translations, and Schools tabs on the Texas State Reporting page. The Snapshot Date is not used for the SELA submission.


Options Tab

Expand the TSDS/PEIMS Options tab to set various options before creating extracts.



Code Translations Tab

From the Code Translations, certain fields in Aeries can have custom local codes and descriptions mapped to the required TSDS codes.


For the SELA Submission, the following Code Set should be reviewed and updated if needed:

  • Language Fluency (STU.LF)
  • Program Type (SPR.CD)
  • Special Ed Disability Types (CSE.D12)
  • Student Gender (STU.GN)
  • Student Race (STU.RC1)
  • Student Suffix (STU.SF)



  1. Click Add Default Translations to automatically add any translations that are predefined in the program.
  2. Select a Code Set, and then click Add Local Codes to retrieve all codes that have been defined on Update Code Table (COD). The Aeries (left) column is populated with these codes.

    WARNING: If the TSDS/PEIMS Description (right column) is left blank, the code will be extracted as blank. It is recommended that you co not click Add Local Codes unless ALL COD values will be translated. Clicking Add Local Codes is optional and may not be needed if the district does not need to translate many codes. In this case, rows can be added individually as described in the next step.

  3. Click Add New Record
    • In the Aeries (left) column, select the local Code to be translated.
    • In the TSDS/PEIMS (right) column, select the TSDS/PEIMS Code that the selected local code should be translated to.
  4. Click the Save icon.
  5. To update an existing mapping, click the Pencil icon.  Make changes, and then click the Save icon.
    Or, click the Cancel icon to revert to the original values.


Schools Tab

From the Schools tab you can select the schools to include when extracting data. 



SELA Tab

From the SELA tab you can create the XML extract files for the SELA Submission.


 

  1. The files required for the SELA Submission are automatically selected. You can modify the selections.
  2. Click Create Selected SELA Files.

    Once created, the XML files are listed individually in the File Download section and can be downloaded individually by clicking the Download icon.



The default name for the individual files is District_Campus_Collection_TimeStamp_Interchange.xml, where:

  • District is the six-digit county-district number
  • Campus is the three-digit campus ID (or 000 if district wide)
  • Collection is the nine-character collection (ending school year & submission)
  • TimeStamp is the 12-digit date-time-stamp when the interchange was created (YYYYMMDDHHMM)
  • Interchange is the name of the interchange created

Example:
111222_000_2022TSDS_202221050901_ InterchangeEducationOrganizationExtension.xml