Skip to main content
Skip table of contents

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.
CourseEquivalencyIdent16.8.0Varchar2(1)Course equivalency for CTE courses.
CTECreditEquivalency16.8.0Varchar2(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_Manuf21.5.3Number(1,0)This is a CTE Core Plus-Advanced Manufacturing course.
Desig_CTE_CP_Maritime21.5.3Number(1,0)This is a CTE Core Plus-Maritime course.
Desig_CTE_CP_Aerospace21.5.3Number(1,0)This is a CTE Core Plus-Aerospace course.
Desig_CTE_CP_Constr21.5.3Number(1,0)This is a CTE Core Plus-Construction course.
J – Tribal Language Competency Test22.7.3Number(1,0)This is a Tribal Language Competency Test course.



JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.