Skip to main content
Skip table of contents

Extra and Co-curricular Activities (ECC) Extract



This report extracts student participation records in extra and co-curricular activities for the TEA ECC pilot project for districts participating in the pilot collection.

Selection Criteria

Selection criteria determine which database records are used in the report. For the Campus Summary, student membership and attendance records are selected.

Report Input

For help with report navigation and generation, see Generate Reports.-



Select Schools

At the District Level:

  • Select All Schools to run the extract for all schools that are not excluded from state reporting.
  • Selecting Multiple Schools allows you to use the Ctrl or SHIFT key on your keyboard to click each school you want to run the extract.

At the School Level:

  • Select All Schools to run the extract for all schools not excluded from state reporting.
  • Select Current School Only to run the extract just for the current school.

Select Students

Indicate which students to include in the report by selecting one of the following options:

  • The selected [number] students only – Run the report for students in the current selection.
  • All students – Run the report for all students in the current school or district that meet the selection criteria.

Note: If running the report for a single student, or group of students, select the students prior to running the report.

School Year

Choose the school year for the student membership and attendance data you want to include on the report.

Reporting Period

Choose the reporting period:

  • Semester 1
  • Semester 2
  • Both Semesters

Sort Options

Choose the sort option:

  • By School, Student, ECC Indicator.
  • By ECC Indicator. School, Student,
Exclude Students with Missing Unique IDSelect Yes/No. 

Run Now

Select this option if the user wants to run the report immediately.


Select this option if the user wants to run this report on a scheduled basis. Once this option is selected the following choices are:

  • Run Once
    • Start Date and Start Time to run the report.
  • Repeat
    • Select Daily, Weekly, Monthly or Yearly for the appropriate re-occurrence for running the report.
      • If Daily is selected, check the Weekdays only box to limit to weekdays.
      • If Weekly is selected, check which weekday to run the report.
      • If Monthly is selected, check the month to run the report.
      • If Yearly is selected, select either the date or the weekday to run the report.
  • Date Range – Select No End Date or a date that the re-occurrence should end.

Report Output

Data Element


School IDThe school number.



School NameThe school name.[Schools]Name
Local Student NumberThe student number. [Students]Student_Number
Last NameThe student's Last Name [Students]Last_Name
First NameThe student's First Name[Students]First_Name
Grade LevelThe Grade Level of the student.[Students]Grade_Level
School YearThe School Year to which the activity record belongs; stored as the two-digit Term ID such as 31 for the 2021-22 school year.


Reporting PeriodThe reporting period for the record.[S_TX_STU_ECC_C]Reporting_Period
Campus IDThe student's campus of enrollment for the ECC record.[S_TX_STU_ECC_C]CampusID
ECC IndicatorThe TEA ECC Indicator Code for the activity.[S_TX_STU_ECC_C]ECC_Indicator
CommentsOptional comments for the record.[S_TX_STU_ECC_C]Comments
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.