S_CT_SGR_TCS_X (ver 15.6.0)
This table is an extension of the [StoredGrades] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
StoredGradesDCID | 15.6.0 | Number (10,0) | Primary key that relates the extended table back to the [StoredGrades] table. |
| ExcludeFromTCS | 15.6.0 | Number (1,0)) | Indicates whether or not this stored grade record should be excluded from the TCS report. |
| O_CourseFacilityCode | 15.6.0 | VarChar2 (7) | The state assigned/defined facility code for where the course is taught. |
O_DualEnrollPrgmCode | 15.6.0 | VarChar2 (10) | Indicates the course section qualifies as a Dual Enrollment Program course that allows students to earn higher education credits in the designated Dual Enrollment Program. |
| O_OutcomeStatus | 15.6.0 | VarChar2 (10) | The status that correlates to the outcome/grade awarded to the student for the course. |
O_TeacherEIN | 15.6.0 | VarChar2 (10) | The state assigned Employee Identification Number of the teacher teaching this course. |
| O_TeacherType | 15.6.0 | VarChar2 (3) | The type or classification of the teacher teaching this course section. |
| O_SectionCode | 15.6.0 | VarChar2 (30) | Information that uniquely identifies the section of the course this record is for. |
| O_SessionBeginDate | 15.6.0 | VarChar2 (10) | The date the course section begins based on the term of the course section. |
| O_SessionEndDate | 15.6.0 | Date | The date the course section ends based on the term of the course section. |
| O_NCESCourseCode | 15.6.0 | VarChar2 (12) | The NCES Course Code that most aligns with the content and curriculum of the course offered by the school or district. |
O_TeacherNumber | 16.8.0 | VarChar2 (20) | The Teacher Credential ID of the teacher teaching this course. |
| O_MembershipSessions | 17.7.0 | Integer | Indicates grades not associated with a section, or an override for grades that are associated with a section. |
| O_SessionsAttended | 17.7.0 | Integer | Indicates grades not associated with a section, or an override for grades that are associated with a section. |
| O_SummerGrade | 20.5.0 | Number (1,0)) | This indicates whether or not this grade was entered in the summer. |