S_MD_SGR_X (ver 15.1.0)
This table is an extension of the [StoredGrades] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
StoredGradesDCID | 15.1.0 | Number (10,0) | Primary Key |
| Summer_School | 15.1.0 | Number (1,0) | Indicates the class was taken in summer school. |
| AP_Honors_Indicator | 16.12.3 | Varchar2 (5) | AP/Honors Indicator (Not Required for SCGT) |
| Course_Subject | 16.12.3 | Varchar2 (10) | Subject Code |
| Course_Term | 16.12.3 | Varchar2 (5) | Course Semester or Term |
| State_ExcludeFromReporting | 16.12.3 | Varchar2 (1) | Exclude this Historical Grade from State Reporting |
| Grade_Scale_Name | 16.12.3 | Varchar2 (100) | Grade Scale Name |
| HSA_Subject_Flag | 16.12.3 | Varchar2 (5) | HSA Subject Flag |
| International_Baccalaureate | 16.12.3 | Varchar2 (1) | International Baccalaureate (IB) (Not Required for SCGT) |
| MSA_Subject_Flag | 16.12.3 | Varchar2 (5) | MSA Subject Flag |
| Outside_Of_School | 16.12.3 | Varchar2 (1) | Instruction Outside of School Flag |
| Attempted_Course_Cert | 18.5.0 | Number (1,0) | Applies to CTE identified classes only. Indicates that the student attempted an associated course certification assessment. |
| Earned_Course_Cert | 18.5.0 | Number (1,0) | Applies to CTE identified classes only. Indicates that the student earned an associated course certification. |
| Rigorous_HS_Indicator | 19.4.1.0 | VarChar2 (1) | Indicates a student has earned at least two credits in specific areas of study with a grade of B or higher. |
| Concentrator_Designation | 19.7.1.0 | VarChar2 (1) | Concentrator Designation |