S_CA_SGR_X (ver 14.12.0)
This table is an extension of the StoredGrades table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
StoredGradesDCID | 14.12.0 | Number(10,0) | Primary key that relates the extended table to the StoredGrades table. |
AlternateClassID | 14.12.0 | Number(11,0) | CALPADS Alternate Class ID. |
AlternateCourseNumber | 14.12.0 | Varchar2(11) | Alternate Course Number. |
AlternateSectionId | 14.12.0 | Number(11,0) | Alternate Section ID. |
AlternateTeacherId | 14.12.0 | Number(11,0) | Alternate Teacher ID. |
AlternateTeacherNumber | 14.12.0 | Varchar2(20) | Alternate Teacher Number. |
AlternateTeacherSEID | 14.12.0 | Varchar2(10) | Alternate Teacher SEID. |
ApexFlag | 14.12.0 | Number(1,0) | APEX Indicator. |
BlockCourseFlag | 14.12.0 | Number(1,0) | Block Course Indicator. |
EndOfYearFlag | 14.12.0 | Number(1,0) | End of Year Indcator. |
ExcludeFromCALPADS | 14.12.0 | Number(1,0) | CALPADS Exclude from Reporting. |
| GSSMD_IsQualifyingGrade | 18.3.0 | Number(1,0) | Signifies that the record should be used to qualify for Golden State Seal Merit Diploma, regardless of grade value. |
| GSSMD_Subject | 18.3.0 | Varchar2(1) | Golden State Seal Merit Diploma Subject Area. Overrides Course/Section values. |
| PathwayCode | 18.5.0 | Varchar2(3) | The CTE Pathway Code for the associated course. |
| UCCSU_Area | 18.5.0 | Varchar2(2) | UC/CSU Approved Course Subject Area of the associated course. |