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 |