Teacher Course Student (TCS) Report

Field

Description

Select Schools

If run at the district level, choose one of the following:

• Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included.

• All Schools – Run the report for the entire district.

If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.

Select Students

• All Students – Includes all students included in the selected school(s) who meet the student selection criteria.

• The Selected # Students Only – Includes only those students from the current selection of students and the selected school(s) who meet the student selection criteria.

Course Code

Choose one of the following based on where the state-defined course number is entered on the Edit Course District Information page (Start Page > District Setup > Courses):

• SCED Course Code – Choose this value if your school stores the state-defined course number in the SCED Course Code field.

• Alt Course Code – Choose this value if your school stores the state-defined course number in the Alternate Course Number field.

Section Number

Choose one of the following based on where the state-defined section number is entered on the Edit Section page (Start Page > School Setup > Sections):

• Section Number – Choose this value if your school stores the state-defined section number in the Section Number field.

• State Section Number – Choose this value if your school stores the state-defined course number in the Section Number (Teacher Course Student Record) field.

Dropped Courses

Choose one of the following:

• Exclude All Drop courses – choose this option if you don’t want any drop courses, including those with posted final grades, included in the report.

• Include Only Dropped Course w/ TCS Store Code Final Grade – choose this option if you want to exclude all dropped courses except those that have a final grade posted using a store code that is configured as a final grade store code for the TCS report.

• Include All Dropped Courses – choose this option if you want to include dropped courses for verification purposes.

Enrollment Duration

Choose one of the following:

• Include only students who have been enrolled at least 90 calendar days

• Include all students who have been enrolled

Final Grades

Choose one of the following:

• Exclude courses without a Final Grade

• Include courses without a Final Grade

Display Headers?

Select Yes or No if you want to turn headers on or off in the report.

Include identifying information with each record for troubleshooting*

Select Yes to include students’ and teachers’ last name and first name at the end of the record to help identify problems.

Do NOT use when generating a marking period report.

When you run the report with "Include identifying information with each record for troubleshooting" selected, the following information is displayed:

The student Grade_Level, EnrollmentSchoolID; section Course Name, course Potential Credit; adjacent column holding just the credit value from the SCED code, when is a secondary code structure; “Group” or “Group Code”, student CC most recent Date Enrolled and Date Left and a total of days enrolled in the class. This helps you verify if the data is correct.

Include Session Membership Attended*

Select Yes or No if you want to include the session membership attended in the report.

Include Session Membership*

Select Yes or No if you want to include session membership in the report.

Summer Grades

Date from which summer grades to be included.

This runtime parameter filters the data from Historical grades having met the below criteria:

1. Historical Grade → Summer Grade flag set to 1

2. Date stored field in Historical grade is on or after the defined summer Grades Date

Item #

Data Element

Description

[Table]FieldName

Field Type

Field Length

1

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

2

Reporting District

The three-digit code identifying the district reporting the teacher course student data.

[Prefs]Value where [Prefs]Name = districtnumber

Numeric

3

3

District Student ID

The locally assigned student number.

[Students] Student_Number

Alpha numeric

20

4

Date of Birth

The student’s birth date.

[Students]DOB

Date

8

5

Educator Identification Number (EIN)

The state-assigned teacher number used to identify the teacher who taught this course.

The report will trim spaces from the value.

For historical grade records with no associated section (SectionID=0), the report will pull from the StoredGrades extension table as specified in the [Table]FieldName column.

[Teachers]SIF_StatePrid

Spaces are trimmed but published as blank if the resulting value is larger than 10 characters.

When [StoredGrades]SectionID= 0: [S_CT_SGR_TCS_X]O_TeacherEIN

Numeric

10

6

Teacher Type

The three-digit code indicating the type of teacher assigned to the student for a given course.

For historical grade records with no associated section (SectionID=0), the report will pull from the StoredGrades extension table as specified in the [Table]FieldName column.

[S_CT_SSF_X] TeacherType

When [StoredGrades]SectionID= 0: [S_CT_SGR_TCS_X]O_TeacherType

If the role of the teacher is defined as co-teacher in a section, then the co-teacher type will be 103, 203, 303, 403 based on the level of the teacher defined in teacher's profile.

Numeric303

3

7

District Teacher ID

The district-assigned teacher number used to identify the teacher that taught this course.

[Teachers]TeacherNumber

Alpha numeric

20

8

Course Facility Code

The school number for the school where this course is taught.

For historical grade records with no associated section (SectionID=0), the report will pull from the StoredGrades extension table as specified in the [Table]FieldName column.

[Sections]WhereTaught

[Schools] Alternate_School_Number

[Schools]School_Number

When [StoredGrades]SectionID= 0: [S_CT_SGR_TCS_X]O_CourseFacilityCode

Numeric

7

9

SCED Course Code

The state-assigned completed SCED course code for this course record.

Note: The value is extracted from either the Alternate Course Number field or the SCED Course Code field, based on the SCED Code parameter selection at report runtime.

For historical grade records with no associated section (SectionID=0), the report will pull from the StoredGrades extension table as specified in the [Table]FieldName column.

[S_CT_CRS_X] SCEDCourseCode

[Courses]Alt_Course_Number

When [StoredGrades]SectionID= 0: [S_CT_SGR_TCS_X]O_SCEDCourseCode

Alpha numeric

12

10

District Course Code

The district course code assigned to this course record.

[Courses]Course_Number

Alpha numeric

20

11

Section Code

The section number assigned to this course section record.

Note: The value is extracted from either the Section Number field or the State Section Number (Teacher Course Student Extract) field, depending on the selection at report runtime.

For historical grade records with no associated section (SectionID=0), the report will pull from the StoredGrades extension table as specified in the [Table]FieldName column.

[S_CT_SEC_X]TCSSectionNumberOverride

[Sections]Section_Number

When [StoredGrades]SectionID= 0: [S_CT_SGR_TCS_X]O_SectionCode

Alpha numeric

30

12

Outcome/ Grade

The grade the student earned upon completion of this course.

Notes:

The grade records included in the extract are determined by the store codes defined on the Edit School page.

For students who are assigned Standards instead of Stored Grades a default value set on the Edit School page is used as a default.

An override option is available under the students All Enrollments page.

Sections that should not be included can be excluded on the Sections page.

[StoredGrades]Grade

[S_CT_GradeLevelOutcome_S]TCSOutcome

[S_CT_CC_X]TCSOutcomeOverride

Alpha numeric

10

13

Facility 1 Code

The seven-digit Facility 1 Code for the student as reported in the Public School Information System (PSIS).

[S_CT_STU_X] FacilityCode1

[Schools]Alternate_School_Number

[Schools]School_Number

Numeric

7

14

Session Start Date

The date the class/section began, in the format MMDDYYYY

For historical grade records with no associated section (SectionID=0), the report will pull from the StoredGrades extension table as specified in the [Table]FieldName column.

[S_CT_TRM_X]ClassFirstDayDate or

[Terms]FirstDay

When [StoredGrades]SectionID= 0: [S_CT_SGR_TCS_X] O_SessionBeginDate

Date

8

15

Session End Date

The date the class/section ended, in the format MMDDYYYY

For historical grade records with no associated section (SectionID=0), the report will pull from the StoredGrades extension table as specified in the [Table]FieldName column.

[S_CT_TRM_X]ClassLastDayDate or

[Terms]LastDay

When [StoredGrades]SectionID= 0: [S_CT_SGR_TCS_X] O_SessionEndDate

Date

8

16

Outcome/ Grade Status

An indicator to clarify the Outcome/Grade field that describes the circumstances under which the student exited from membership in a class section.

For historical grade records with no associated section (SectionID=0), the report will pull from the StoredGrades extension table as specified in the [Table]FieldName column.

[S_CT_CC_X]TCSOutcomStatusOverride

[S_CT_GSI_X]TCSGradeStatus

[S_CT_GradeLevelOutcome_S]TCSOutcomeStatus

When [StoredGrades]SectionID= 0: [S_CT_SGR_TCS_X] O_OutcomeStatus

Alpha numeric

20

17

Course Credits Earned

The number of Carnegie credits the student earned in the course, expressed as a number with 2 decimal places.

[StoredGrades]EarnedCrHrs

Set to 0.00 for Standards based grades or withdrawn courses.

Set to 0.00 for co-teachers

Numeric

4

18

Number of Membership Sessions

The number of times the class met. If the [S_CT_SGR_TCS_X]O_MembershipSessions field is empty then the value is derived from the number of times the class met between "ClassFirstDayDate" and "ClassLastDayDate" override fields from S_CT_TRM_X table, if available. Otherwise, these counts will be based on days between the Session Start Date and Session End Date.

[S_CT_SGR_TCS_X]O_MembershipSessions, if populated.

Otherwise:

[S_CT_TRM_X]ClassFirstDayDate

[S_CT_TRM_X]ClassLastDayDate

Numeric

3

19

Number of Membership Sessions Attended

The number of membership sessions a student in the course attended.

[S_CT_SGR_TCS_X]O_SessionsAttended , if populated.

Otherwise:

Calculated based on the school calendar, periods, section schedule, and daily attendance.

Note: If a course section meets for more than one period on the same day, the multiple periods are calculated as a single session for the day. Absence in any one of those periods is counted as an absence for that session.

Numeric

3

20

Dual Enrollment Code

The code associated with the higher learning dual enrollment program for which the student is earning college credit.

For historical grade records with no associated section (SectionID=0), the report will pull from the StoredGrades extension table as specified in the [Table]FieldName column.

[S_CT_SEC_X]DualEnrollPrgmCode

When [StoredGrades]SectionID= 0: [S_CT_SGR_TCS_X]O_DualEnrollPrgmCode

Alpha numeric

10

21

CSDE Use

This field is not currently used.

N/A

Alpha numeric

20

22

End of Record Marker

X displays in this field.

Set to “X”

Alpha numeric

1