Extra and Co-curricular Activities (ECC) Extract

Contents:

Introduction

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.-

Field	Description
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 ID	Select Yes/No.
Run Now	Select this option if the user wants to run the report immediately.
Schedule	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	Description	[Table]FieldName
School ID	The school number.	[Schools]School_Number [Schools]Alternate_School_Number
School Name	The school name.	[Schools]Name
Local Student Number	The student number.	[Students]Student_Number
Last Name	The student's Last Name	[Students]Last_Name
First Name	The student's First Name	[Students]First_Name
Grade Level	The Grade Level of the student.	[Students]Grade_Level
School Year	The School Year to which the activity record belongs; stored as the two-digit Term ID such as 31 for the 2021-22 school year.	[S_TX_STU_ECC_C]YearID
Reporting Period	The reporting period for the record.	[S_TX_STU_ECC_C]Reporting_Period
Campus ID	The student's campus of enrollment for the ECC record.	[S_TX_STU_ECC_C]CampusID
ECC Indicator	The TEA ECC Indicator Code for the activity.	[S_TX_STU_ECC_C]ECC_Indicator
Comments	Optional comments for the record.	[S_TX_STU_ECC_C]Comments