S_WA_SGR_X (ver 22.7.3)
This table is an extension of the [STOREDGRADES] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
StoredGradesDCID | 14.9.0 | Number(10,0) | Primary key that relates the extended table back to the StoredGrades table. |
APCode | 14.9.0 | Varchar2(10) | Indicates advanced placement course code for the stored grade record. |
| sgDesig_NonInstructional | 14.11.0 | Varchar2(1) | Indicates Non-Instructional (Z) (does not print on the transcript). |
| ALEFunded | 16.12.3 | Varchar2(1) | Indicates ALE Course Type. Migrated from [StoredGrades.WA_ALEFunded]. |
| AlternateLocationID | 16.12.3 | Number(11,0) | Location ID where the grade was earned (if unknown, 9999). Migrated from [StoredGrades.WA_Alternate_Location_ID]. |
| ContentAreaCode | 17.11.0 | Varchar2(3) | Migrated from [StoredGrades.WA_ContentAreaCode]. |
| Desig_TechPrep | 16.12.3 | Varchar2(1) | Indicates course designation code for Tech Prep (T). Migrated from [StoredGrades.TechPrepStatus]. |
| Desig_IB | 16.12.3 | Varchar2(1) | Indicates course designation code for International Baccalaureate (I). Migrated from [StoredGrades.WA_InternationalBaccalaureate]. |
| Desig_CollegeInHS | 16.12.3 | Varchar2(1) | Indicates course designation code for College in the High School (C). Migrated from [StoredGrades.WA_CollegeInHighSchool]. |
| Desig_Honors | 16.12.3 | Varchar2(1) | Indicates course designation code for Honors (H). Migrated from [StoredGrades.WA_HonorsOption]. |
| Desig_AP | 16.12.3 | Varchar2(1) | Indicates course designation code for Advanced Placement (A). Migrated from [StoredGrades.WA_AdvancedPlacement]. |
| Desig_RunningStart | 16.12.3 | Varchar2(1) | Indicates course designation code for Running Start (R). Migrated from [StoredGrades.WA_RunningStart]. |
| Desig_CADR | 16.12.3 | Varchar2(1) | Indicates course designation code for College Academic Distribution Requirements (B). Migrated from [StoredGrades.WA_HECBCore]. |
| Desig_Cambridge | 16.12.3 | Varchar2(1) | Indicates course designation code for Cambridge Program (K). Migrated from [StoredGrades.WA_CambridgeOption]. |
| Desig_Online | 16.12.3 | Varchar2(1) | Indicates course designation code for Online (O) (does not print on the transcript). Migrated from [StoredGrades.WA_OnlineOption]. |
| Desig_LocalTest | 16.12.3 | Varchar2(1) | Indicates course designation code for Local Competency Test (L). Migrated from [StoredGrades.WA_LocalCompTest]. |
| Desig_NationalTest | 16.12.3 | Varchar2(1) | Indicates course designation code for National Competency Test (N). Migrated from [StoredGrades.WA_NationalCompTest]. |
| Desig_Quantitative | 16.12.3 | Varchar2(1) | Indicates course designation code for Quantitative (Q). Migrated from [StoredGrades.WA_Quantitative]. |
| Desig_SciLab | 16.12.3 | Varchar2(1) | Indicates course designation code for Science Lab (S). Migrated from [StoredGrades.WA_SciLab]. |
| IBCode | 17.11.0 | Varchar2(6) | Indicates international baccalaureate course code for the StoredGrades record. Migrated from [StoredGrades.WA_IBCode]. |
| NonFTECredit | 17.11.0 | Varchar2(2) | Migrated from [StoredGrades.Non_FTE_Credit]. |
| OverrideSecTchID | 17.1.0 | Number(11,0) | Override for Section Teacher ID, affects CEDARS H report. Migrated from [StoredGrades.WA_OverrideSecTchID]. |
| SkillsProgram | 17.11.0 | Varchar2(1) | Migrated from [StoredGrades.Skills_Program]. |
| StateCourseCode | 17.11.0 | Varchar2(6) | Migrated from [StoredGrades.WA_StateCourseCode]. |
| State_ExcludeFromReporting | 17.11.0 | Number(1,0) | Excludes the record from state reports. Migrated from [StoredGrades.State_ExcludeFromReporting]. |
| WorkBased | 17.11.0 | Number(1,0) | Migrated from [StoredGrades.Work_Based]. |
| Desig_locCrsAssessment | 19.7.1.0 | Varchar2(1) | Indicates course designation code for Locally Determined Course – Locally Administered Assessment (X) |
| ApprovedOnlineProvider | 19.9.2.0 | Varchar2(2) | Identifies the online provider offering the course reported in Element E06 – Course ID. |
| ApprovedOnlineProgram | 19.9.2.0 | Varchar2(3) | Identifies the online program offering the course reported in Element E06 – Course ID. |
| Desig_YouthReengagement | 20.8.1.0 | Number(1,0) | Indicates the course designation code for 1418 Youth reengagement dual credit (Y). |
| Desig_DistrictOrLocal | 20.8.1.0 | Number(1,0) | Indicates course designation code for District or other local dual credit program (D). |
| Desig_locTransition | 20.8.1.0 | Number(1,0) | Indicates the course designation code for Local Transition (E). |
| Desig_CTE_CorePlus | 20.8.1.0 | Number(1,0) | Indicates the course designation code for CTE Core Plus (F). |
| CourseLevel | 20.8.1.0 | Varchar2(1) | Indicates the course's Course Level. |
Desig_CTE_CP_Adv_Manuf | 21.5.3 | Number(1,0) | Indicates the course designation code for CTE Core Plus - Advanced Manufacturing (G) |
| Desig_CTE_CP_Maritime | 21.5.3 | Number(1,0) | Indicates the course designation for CTE Core Plus-Maritime (U). |
| Desig_CTE_CP_Aerospace | 21.5.3 | Number(1,0) | Indicates the course designation for CTE Core Plus-Aerospace (V). |
| Desig_CTE_CP_Constr | 21.5.3 | Number(1,0) | Indicates the course designation for CTE Core Plus-Construction (W). |
| SgSequence | 21.6.2.0 | Number(2,0) | Indicates the historical grade's Sequence. |
| SgSequenceGroup | 21.6.2.0 | Varchar2(20) | Indicates the historical grade's Sequence Group. |
| Tribal_Lang_Competency | 22.7.3.0 | Number(1,0) | Indicates course designation code for J – Tribal Language Competency Test |