S_WA_CBY_X (ver 22.7.3)
This table is an extension of the [COURSESBYYEAR] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
CoursesByYearID | 16.2.2 | Number(10,0) | Foreign Key |
ALEFunded | 16.2.2 | Varchar2(1) | The ALE type for this course, or blank for non-ALE courses. |
APCode | 16.2.2 | Varchar2(6) | Advanced Placement Subject Code. |
ContentAreaCd | 16.2.2 | Varchar2(3) | The primary content area for the course. |
| CourseEquivalencyIdent | 16.8.0 | Varchar2(1) | Course equivalency for CTE courses. |
| CTECreditEquivalency | 16.8.0 | Varchar2(2) | Course credit equivalency for Career and Technical Education (CTE) courses |
Desig_AP | 16.2.2 | Number(1,0) | This is an Advanced Placement course. |
Desig_CADR | 16.2.2 | Number(1,0) | This is a CADR course. |
Desig_Cambridge | 16.2.2 | Number(1,0) | This is a Cambridge Program Course. |
Desig_CollegeInHS | 16.2.2 | Number(1,0) | This is a College in High School course. |
Desig_Honors | 16.2.2 | Number(1,0) | This is an Honors course. |
Desig_IB | 16.2.2 | Number(1,0) | This is an International Baccalaureate course. |
Desig_LocalTest | 16.2.2 | Number(1,0) | This is a Local Competency Test course. |
Desig_NationalTest | 16.2.2 | Number(1,0) | This is a National Competency Test course. |
Desig_NonInstructional | 16.2.2 | Number(1,0) | This is a non-instructional course. |
Desig_Online | 16.2.2 | Number(1,0) | This is an Online course. |
Desig_Quantitative | 16.2.2 | Number(1,0) | This is a Quantitative course. |
Desig_RunningStart | 16.2.2 | Number(1,0) | This is a Running Start course. |
Desig_SciLab | 16.2.2 | Number(1,0) | This is a Science Lab course. |
Desig_TechPrep | 16.2.2 | Number(1,0) | This is a Tech Prep course. |
IBCode | 16.2.2 | Varchar2(6) | International Baccalaureate Subject Code. |
Non_FTE_Credit | 16.2.2 | Number(1,0) | This is a non-FTE credit course. |
SkillsProgram | 16.2.2 | Varchar2(1) | Skills Program course code. |
StateCourseCd | 16.2.2 | Varchar2(6) | The unique course code assigned by the state. CEDARS “State Course Code” element. |
State_ExcludeFromReporting | 16.2.2 | Number(1,0) | Exclude the course from certain state reports. |
WorkBased | 16.2.2 | Number(1,0) | This is a work-based course. |
| Desig_CTE_CP_Adv_Manuf | 21.5.3 | Number(1,0) | This is a CTE Core Plus-Advanced Manufacturing course. |
| Desig_CTE_CP_Maritime | 21.5.3 | Number(1,0) | This is a CTE Core Plus-Maritime course. |
| Desig_CTE_CP_Aerospace | 21.5.3 | Number(1,0) | This is a CTE Core Plus-Aerospace course. |
| Desig_CTE_CP_Constr | 21.5.3 | Number(1,0) | This is a CTE Core Plus-Construction course. |
| J – Tribal Language Competency Test | 22.7.3 | Number(1,0) | This is a Tribal Language Competency Test course. |