Introduction
The Teacher Course Student (TCS) validation report for section data verifies the information on the Teacher Course Student (TCS) report. Use this to extract the data need to validate the Connecticut State TCS Report.
Selection Criteria
Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.
Student Selection
-
The student must not be excluded from state reporting.
-
The student enrollment must be in a school selected on the report parameter page.
Report Input
|
Field |
Description |
|
Select Schools |
Select the current school. |
|
Run Now |
Select Run Now to run the report, and click Submit. |
Report Output
|
Item # |
Data Element |
Description |
[Table]FieldName |
Field Type |
Field Length |
|
1 |
Override School Were Taught |
The school where the course is taught. |
[sections]WhereTaught |
NA |
|
|
2 |
District Where Taught |
The district where the course is taught. |
[sections]WhereTaughtDistrict |
|
|
|
3 |
Course Number |
The course number. |
[courses]Course_Number |
Numeric |
|
|
4 |
Course name
|
The course name. |
[courses]Course_Name |
|
|
|
5 |
Section Number
|
The section number. |
[Sections]Section_Number |
|
|
|
6 |
Section ID |
The section ID. |
[Sections]ID |
Numeric |
|
|
7 |
Section DCID |
The Section DCID |
[Sections]DCID |
Numeric |
|
|
8 |
State Assigned Student ID (SASID) |
The student’s state-assigned identifier. The report will trim spaces from the value. |
[Students]State_StudentNumber Spaces are trimmed but published as blank if the resulting value is larger than 10 characters. |
Numeric |
10 |
|
9 |
SCED Course Code
|
The SCED Course Code |
[S_CRS_X]SCED_COURSE_CODE from course level only |
|
|
|
10 |
TermID |
The term ID |
[Term]ID |
|
|
|
11 |
Term Start Date |
The term start date. |
[S_CT_TRM_X]ClassFirstDayDate if it is null then reports [Terms]firstday |
Date |
|
|
12 |
Term End Date
|
The term end date. |
*[S_CT_TRM_X]ClassLastDayDat*e if it is null then reports *[Terms]lastda*y [S_CT_TRM_X]ClassLastDayDate if it is null then reports [Terms]lastday |
Date |
|
|
13 |
Course Dual Enrolment Program Code
|
The Course Dual Enrolment Program Code |
[S_CT_SEC_X]dualEnrollPrgmCode |
|
|
|
14 |
Section Dual Enrolment Program Code |
The Section Dual Enrolment Program Code |
[S_CT_SEC_X]dualEnrollPrgmCode |
|
|
|
15 |
Distance Learning status |
The distance learning status. |
[Students]Distance_Learning_Status |
|
|
|
16 |
Exclude from TCS
|
Exclude the student from TCS. |
[Courses]exclude_state_rpt_yn
|
|
|