Extra and Co-curricular Activities (ECC) Extract

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 OnceStart Date and Start Time to run the report.

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

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