S_TX_STU_ECC_C (Version 22.3.2)
This table is a child of the Students table and is used to track student participation in Extra and Co-Curricular Activities.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 22.3.2 | Number(10,0) | Primary Key. |
| StudentsDCID | 22.3.2 | NUMBER(10,0) | The foreign key to link to the student table. |
| CampusID | 22.3.2 | VarChar2(9) | The student's campus of enrollment for the ECC record. |
| Comments | 22.3.2 | VarChar2(100) | Optional comments for the record. |
| ECC_Indicator | 22.3.2 | VarChar2(3) | The TEA ECC Indicator Code for the activity. |
| Reporting_Period | 22.3.2 | VarChar2(2) | The reporting period for the record. |
| YearID | 22.3.2 | Number(11,0) | 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. |