S_MI_SGR_TSDL_X (ver 15.8.0)
This table is an extension of the [StoredGrades] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
StoredGradesDCID | 15.8.0 | Number(10,0) | Primary key that relates the extended table back to the [StoredGrades] table. |
| academicYear | 22.5.3.0 | VarChar2(10) | Override for the academic year in which the student was enrolled in the course (e.g. 2021-2022). |
collegeCredits | 15.8.0 | Number(25,10) | Override for potential college credit hours the course is worth. |
| completionStatus | 22.5.3.0 | VarChar2(4) | Override for the completion status code identifying the student's course completion status. |
| courseID_TSDL | 22.5.3.0 | VarChar2(11) | The stored grade course number for the course. |
| courseType | 23.9.3.0 | VarChar2(12) | Override for Course Type (23.9.3.0). |
| CrsFundingPrgm | 22.5.3.0 | VarChar2(5) | Override for the course funding program code. |
| excludeTSDL | 23.9.3.0 | Number(10,0) | Currently Not Used (23.9.3.0). |
| mSIXCourseSectionID | 22.5.3.0 | VarChar2(12) | Override for MSIX Clock Hours (22.5.3.0). |
| mSIXClockHours | 23.9.3.0 | Number(10,0) | Override for MSIX Clock Hours (23.9.3.0). |
Out_of_District_Identifier | 22.3.2.0 | VarChar2(15) | Out of district identifier used for Ed-Fi to identify and out of district course. |
| repPIC1 | 22.5.3.0 | VarChar2(12) | Override for the Staff PIC. |
| repPIC2 | 22.5.3.0 | VarChar2(12) | Override for an additional co-teacher PIC. |
| repPIC3 | 22.5.3.0 | VarChar2(12) | Override for an additional co-teacher PIC. |
| virtualDelivery | 22.5.3.0 | VarChar2(4) | Override for the virtual delivery method of the section. |
| vmPIC1 | 22.5.3.0 | VarChar2(12) | Override for the mentor teacher PIC. |
| vmPIC2 | 22.5.3.0 | VarChar2(12) | Override for an additional mentor teacher PIC. |
| vmPIC3 | 22.5.3.0 | VarChar2(12) | Override for an additional mentor teacher PIC. |