S_WA_CRS_X (ver 22.7.3)
This table is an extension of the [COURSES] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
CoursesDCID | 14.11.0 | Number(10,0) | Foreign Key |
| CourseEquivalencyIdent | 16.8.0 | Varchar2(1) | Course equivalency for CTE courses. |
CrsDesig_NonInstructional | 14.11.0 | Varchar2(1) | Non-Instructional (Z) (does not print on the transcript). |
| CTECourseEquivalency | 17.5.0 | Varchar2(2) | Course equivalency designation for Career and Technical Education (CTE) courses. |
| CTECreditEquivalency | 16.8.0 | Varchar2(2) | Course credit equivalency for Career and Technical Education (CTE) courses. |
IsHomeroom | 16.7.0 | Number(1,0) | Homeroom Course (Used in K-3 Class Size Report). |
SingleSexCode | 14.11.0 | Varchar2(1) | CRDC SCH 36. Is this restricted to a single gender? |
| Non_FTE_Credit | 16.12.3 | Varchar2(2) | Indicates Non-FTE Course. Migrated from [Courses.Non_FTE_Credit]. |
| SkillsProgram | 16.12.3 | Varchar2(1) | Indicates Skills Program Course. Migrated from [Courses.Skills_Program]. |
| State_ExcludeFromReporting | 16.12.3 | Number(1,0) | Indicates whether course record is excluded from CEDARS reporting. Migrated from [Courses.State_ExcludeFromReporting]. |
| Desig_TechPrep | 16.12.3 | Number(1,0) | Indicates course designation code for Tech Prep (T). Migrated from [Courses.TechPrepStatus]. |
| Desig_IB | 16.12.3 | Number(1,0) | Indicates course designation code for International Baccalaureate (I). Migrated from [Courses.WA_InternationBaccalaureate]. |
| Desig_CollegeInHS | 16.12.3 | Number(1,0) | Indicates course designation code for College in the High School (C). Migrated from [Courses.WA_CollegeInHighSchool]. |
| Desig_Honors | 16.12.3 | Number(1,0) | Indicates course designation code for Honors (H). Migrated from [Courses.WA_HonorsOption]. |
| Desig_AP | 16.12.3 | Number(1,0) | Indicates course designation code for Advanced Placement (A). Migrated from [Courses.WA_Advanced]. |
| Desig_RunningStart | 16.12.3 | Number(1,0) | Indicates course designation code for Running Start (R). Migrated from [Courses.WA_RunningStart]. |
| Desig_CADR | 16.12.3 | Number(1,0) | Indicates course designation code for College Academic Distribution Requirements (B). Migrated from [Courses.WA_HECBCore]. |
| Desig_Cambridge | 16.12.3 | Number(1,0) | Indicates course designation code for Cambridge Program (K). Migrated from [Courses.WA_CambridgeOption]. |
| Desig_Online | 16.12.3 | Number(1,0) | Indicates course designation code for Online (O) (does not print on the transcript). Migrated from [Courses.WA_OnlineOption]. |
| Desig_LocalTest | 16.12.3 | Number(1,0) | Indicates course designation code for Local Competency Test (L). Migrated from [Courses.WA_LocalCompTest]. |
| Desig_NationalTest | 16.12.3 | Number(1,0) | Indicates course designation code for National Competency Test (N). Migrated from [Courses.WA_NationalCompTest]. |
| Desig_Quantitative | 16.12.3 | Number(1,0) | Indicates course designation code for Quantitative (Q). Migrated from [Courses.WA_Quantitative]. |
| Desig_SciLab | 16.12.3 | Number(1,0) | Indicates course designation code for Science Lab (S). Migrated from [Courses.WA_SciLab]. |
| APCode | 16.12.3 | Varchar2(6) | Indicates advanced placement course code for the course record. Migrated from [Courses.WA_AdvancedPlacement]. |
| IBCode | 16.12.3 | Varchar2(6) | Indicates international baccalaureate course code for the course record. Migrated from [Courses.WA_IBCode]. |
| ALEFunded | 16.12.3 | Varchar2(1) | Indicates ALE Course Type. Migrated from [Courses.WA_ALEFunded]. |
| ContentAreaCd | 16.12.3 | Varchar2(3) | Indicates Content Area Code. Migrated from [Courses.WA_ContentAreaCode]. |
| StateCourseCd | 16.12.3 | Varchar2(6) | Indicates State Course Code. Migrated from [Courses.WA_StateCourseCode]. |
| WorkBased | 16.12.3 | Number(1,0) | Indicates Work Based Course. Migrated from [Courses.Work_Based]. |
| Desig_YouthReengagement | 18.5.0 | Number(1,0) | Indicates course designation code for 1418 Youth reengagement dual credit (Y) |
| Desig_DistrictOrLocal | 18.5.0 | Number(1,0) | Indicates course designation code for District or other local dual credit program (D) |
| Desig_locCrsAssessment | 19.7.1.0 | Varchar2(1) | Indicates course designation code for Locally Determined Course – Locally Administered Assessment (X) |
| DualLangInstructionType | 19.7.1.0 | Varchar2(1) | Dual Language Instruction Type |
| DualLangInstructionLang | 19.7.1.0 | Varchar2(3) | Dual Language Instruction Language |
| ApprovedOnlineProvider | 19.8.2.0 | Varchar2(2) | Identifies the online provider offering the course reported in Course ID. |
| ApprovedOnlineProgram | 19.8.2.0 | Varchar2(3) | Identifies the online program offering the course reported in Course ID. |
| 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.2 | Number(1,0) | Indicates the course designation for CTE Core Plus-Advanced Manufacturing (G). |
| Desig_CTE_CP_Maritime | 21.5.3.2 | Number(1,0) | Indicates the course designation for CTE Core Plus-Maritime (U). |
| Desig_CTE_CP_Aerospace | 21.5.3.2 | Number(1,0) | Indicates the course designation for CTE Core Plus-Aerospace (V). |
| Desig_CTE_CP_Constr | 21.5.3.2 | Number(1,0) | Indicates the course designation for CTE Core Plus-Construction (W). |
| IndustryCertOffered | 20.8.1.0 | Varchar2(100) | Indicates the course's CTE Certifications offered. |
| CrsSequence | 21.6.2.0 | Number(2,0) | Indicates the course's Sequence |
| CrsSequenceGroup | 21.6.2.0 | Varchar2(20) | Indicates the course's Sequence Group |
| Tribal_Lang_Competency | 22.7.3.0 | Number(2,0) | Indicates course designation code for J – Tribal Language Competency Test |