User Tools

Site Tools


Sidebar

Table of Contents

academy:ecds_kg

Core Collection: Early Childhood Data System - KG Submission (Updated 2023-2024)


The Early Childhood Data System (ECDS) collection is one of the TSDS Core Collections. This guide covers the submission of kindergarten (KG) data. (Pre-kindergarten data is submitted separately.) The reporting of KG program data for ECDS is mandatory for all public school districts and open-enrollment charter schools that administer a test from the Commissioner’s List of Approved Kindergarten Assessment Instruments.

LEAs are required to submit specific demographic, classroom link, and special program data elements for the ECDS KG collection. All elements will be submitted in the TSDS Core Collections.

The ECDS KG submission is due January 25, 2024.

NOTE: The assessment vendor will provide the ECDS KG assessment data directly to TEA. LEAs should contact their assessment vendor for any issues or for the specific timeframe for when their results will be provided to TEA.


Extract Rules and Edits for 2023-2024

IMPORTANT: Each LEA will have unique situations. Some of the dates, images, and examples provided in this document are for informational and instructional purposes only and may not completely represent your LEA's process.

Prerequisites

  • Verify that all roles and users are correct in ASCENDER Security Administration.

  • For Student-only districts, the campus must have either entered staff information in District Administration or used the Staff Import utility in State Reporting.

I. Verify ASCENDER Data

Verify data for each element on the following pages and reports. It is suggested that you run reports first, and then use the maintenance pages to update data where needed.

NOTE: ORGANIZATION-CATEGORY (E1240) is the classification of the education agency according to the level of administrative and operational control granted by the state. This is hard coded in the program as “LEA,” or “School” according to the county-district number.


Verify Staff Data

Personnel > Maintenance > Staff Demo > Demographic Information

snippet of Demographic Information tab with ECDS elements highlighted

Reported Elements from Demographic Information:

ElementCode TableData ElementASCENDER Name
E0703—-FIRST-NAMELegal - First
E0704—-MIDDLE-NAMELegal - Middle
E0705—-LAST-NAMELegal - Last
E1524—-TX-UNIQUE-STAFF-IDTexas Unique Staff ID
E0505—-STAFF-IDStaff ID



RUN REPORT FOR VERIFYING DATA:

Staff demo data can be verified by running the following report:

Personnel > Reports > User Created Reports

snippet of Create HR Report with ECDS elements highlighted


Student

Grade Reporting > Maintenance > Master Schedule > Campus Schedule > Section

Section tab with ECDS elements highlighted

Reported Elements from Section:

ElementCode TableData ElementASCENDER Name
E1440—-HOMEROOM-INDICATORHome Room Ind
E1065—-ASSIGNMENT-BEGIN-DATEEntry Date
E1066—-ASSIGNMENT-END-DATEWithdraw Date

IMPORTANT: Be sure Home Room Ind is selected for at least one class for all KG students, and that the student was enrolled in this class on the reading assessment date.

  • A student can only have one home room selected.

The home room indicator identifies the instructor in the ECDS KG system who will be used in the ECDS KG reports. For each KG home room Instructor, verify the following on Grade Reporting > Maintenance > Master Schedule > Campus Schedule > Instructor:

  • The instructor must not be excluded from PEIMS Reporting. Be sure Exclude from PEIMS is not selected.
  • The instructor must have a valid Staff ID or SSN.

Use SGR0400 and SGR0900 to ensure that all students are enrolled in a specific homeroom course.


ElementCode TableData ElementASCENDER Name
E1454—-CLASSROOM-POSITIONClass Role

NOTE: Only Class Role 01 (Teacher of Record) will be extracted. Class Roles 02 and 03 are not reported in the ECDS KG submission. All homeroom classes must have a Teacher of Record.



RUN REPORT FOR VERIFYING DATA:

Master schedule data can be verified by running the following reports:

Grade Reporting > Reports > Grade Reporting Reports > Master Schedules > SGR0110 - Master Schedule PEIMS (Grd Rpting)

SGR0110


Registration > Maintenance > Student Enrollment > Demo1

Demo1 tab with ECDS elements highlighted

Reported Elements from Demo1:

ElementCode TableData ElementASCENDER Name
E0703—-FIRST-NAMEName - First
E0704—-MIDDLE-NAMEName - Middle
E0705—-LAST-NAME Name - Last
E0001—-STUDENT-ID SSN
E1325DC119SEX-CODE Sex
E0006—- DATE-OF-BIRTHDOB
E1375—-HISPANIC-LATINO-CODEHispanic/Latino
E1343DC097WHITE-CODE White
E1343DC097BLACK-AFRICAN-AMERICAN-CODEBlack/African American
E1343DC097ASIAN-CODEAsian
E1343DC097AMERICAN-INDIAN-ALASKA-NATIVE-CODEAmerican Indian/ Alaskan Native
E1343DC097NATIVE-HAWAIIAN-PACIFIC-ISLANDER-CODE Hawaiian/Pacific Isl
E1517DC063GRADE-LEVEL-CODEGrade

RUN REPORT FOR VERIFYING DATA:

❏ Demo1 data can be verified by running the following reports:

Registration > Reports > Create Registration Report

snippet of Create Registration Report with ECDS elements highlighted


Registration > Maintenance > Student Enrollment > Demo2

Demo2 tab with ECDS Assessments section highlighted

The date, if entered, is used by the ECDS Interchanges in State Reporting. If left blank, the ECDS KG Student interchange extract logic will default to the As-Of Date entered on State Reporting > Utilities > Create TSDS Core Collections Interchanges > ECDS KG.

KG Beginning of YearEnter the date the beginning-of-year reading assessment was administered to the student.

NOTE: This field is optional and can be left blank.

Registration > Maintenance > Student Enrollment > Bil/ESL

Bil ESL tab with ECDS element highlighted

Reported Elements from Bil/ESL:

ElementCode TableData ElementASCENDER Name
E1390DC079EMERGENT-BILINGUAL-INDICATOR-CODEEB Cd

RUN REPORT FOR VERIFYING DATA:

❏ The EB indicator can be verified by running the following report:

Registration > Reports > Create Registration Report

snippet of Create Registration Report with ECDS element highlighted

II. Create Interchanges


State Reporting > Utilities > Create TSDS Core Collections Interchanges

Collection

Select the submission. For the ECDS KG submission, select Early Childhood Data System - KG.

Ending School Year

(Display only) The submission year, as entered in the Submission Year field on State Reporting > Options, is displayed.

For example, for the 2022-2023 ECDS KG submission, the field would display 2023.

Campus

Type the three-digit campus ID. Leave blank to select all campuses in the district.

As-Of Date

(Required) Enter the as-of date for running this utility.

NOTE: This date is only used as the reading assessment date if the corresponding ECDS Assessment date on Registration > Maintenance > Student Enrollment > Demo2 is blank.

However, this date is required regardless, because it is used as the staff association date as well as for determining the course-section in the the master schedule.


❏ Select the following individual interchanges for the ECDS KG submission.

  • All TSDS Early Childhood Data System - KG Interchanges
  • Education Organization Interchange
  • Master Schedule Interchange
  • Staff Association Interchange
  • Student Enrollment Interchange
  • Student Parent Interchange



Courses with the following service IDs are included:

  • 01020000
  • 02520004
  • 02530002
  • 02540005
  • 02550020
  • 02560005
  • 02640005
  • 02650000
  • 02660009
  • 02670000
  • 02562005
  • 02625001
  • 02562005 Added/New
  • 02625001 Added/New



Selected Students

The field is enabled if you selected all interchanges or a student-related interchange. Type or click the ellipsis to select the students for whom you want to create an interchange. Separate multiple students (Texas unique student IDs) with a comma (e.g., 6895409515,1628657282,2986961713). Leave blank to select all students.

Note: The As-Of Date field must be completed in order for this field to retrieve students.

Selected Staff

The field is enabled if you selected all interchanges or a staff-related interchange. Type or click the ellipsis to select the employees for whom you want to create an interchange. Separate multiple employees (Texas unique staff IDs) with a comma (e.g., 4732877094,2568052155). Leave blank to select all staff.

Note: The As-Of Date field must be completed in order for this field to retrieve staff.


❏ Click Run.

When the process is complete, you are prompted to save a .zip file containing the individual files for the completed interchanges.

The default name of the zipped folder is District_YYYY-MM-DD.HH-MM-SS.TSDS.zip, where:

  • District is the six-digit county-district number
  • YYYY-MM-DD is the date when the folder was created
  • HH-MM-SS is the hour, minute, and second when the folder was created

Example: 015102-2020-01-15.15-30-22.TSDS.zip


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
  • 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: 015102_000_2021TSDS_202001151420_InterchangeStudentProgramExtension.xml



❏ If errors are encountered:

  1. Correct the data in ASCENDER.
  2. Re-run the interchange(s).
academy/ecds_kg.txt · Last modified: 2024/02/07 20:49 by apape