Skip to main content
Skip table of contents

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

CourseEquivalencyIdent16.8.0Varchar2(1)Course equivalency for CTE courses.

CrsDesig_NonInstructional

14.11.0

Varchar2(1)

Non-Instructional (Z) (does not print on the transcript).

CTECourseEquivalency17.5.0Varchar2(2)

Course equivalency designation for Career and Technical Education (CTE) courses.

CTECreditEquivalency16.8.0Varchar2(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_Credit16.12.3Varchar2(2)Indicates Non-FTE Course. Migrated from [Courses.Non_FTE_Credit].
SkillsProgram16.12.3Varchar2(1)Indicates Skills Program Course. Migrated from [Courses.Skills_Program].
State_ExcludeFromReporting16.12.3Number(1,0)Indicates whether course record is excluded from CEDARS reporting. Migrated from [Courses.State_ExcludeFromReporting].
Desig_TechPrep16.12.3Number(1,0)Indicates course designation code for Tech Prep (T). Migrated from [Courses.TechPrepStatus].
Desig_IB16.12.3Number(1,0)Indicates course designation code for International Baccalaureate (I). Migrated from [Courses.WA_InternationBaccalaureate].
Desig_CollegeInHS16.12.3Number(1,0)Indicates course designation code for College in the High School (C). Migrated from [Courses.WA_CollegeInHighSchool].
Desig_Honors16.12.3Number(1,0)Indicates course designation code for Honors (H). Migrated from [Courses.WA_HonorsOption].
Desig_AP16.12.3Number(1,0)Indicates course designation code for Advanced Placement (A). Migrated from [Courses.WA_Advanced].
Desig_RunningStart16.12.3Number(1,0)Indicates course designation code for Running Start (R). Migrated from [Courses.WA_RunningStart].
Desig_CADR16.12.3Number(1,0)Indicates course designation code for College Academic Distribution Requirements (B). Migrated from [Courses.WA_HECBCore].
Desig_Cambridge16.12.3Number(1,0)Indicates course designation code for Cambridge Program (K). Migrated from [Courses.WA_CambridgeOption].
Desig_Online16.12.3Number(1,0)Indicates course designation code for Online (O) (does not print on the transcript). Migrated from [Courses.WA_OnlineOption].
Desig_LocalTest16.12.3Number(1,0)Indicates course designation code for Local Competency Test (L). Migrated from [Courses.WA_LocalCompTest].
Desig_NationalTest16.12.3Number(1,0)Indicates course designation code for National Competency Test (N). Migrated from [Courses.WA_NationalCompTest].
Desig_Quantitative16.12.3Number(1,0)Indicates course designation code for Quantitative (Q). Migrated from [Courses.WA_Quantitative].
Desig_SciLab16.12.3Number(1,0)Indicates course designation code for Science Lab (S). Migrated from [Courses.WA_SciLab].
APCode16.12.3Varchar2(6)Indicates advanced placement course code for the course record. Migrated from [Courses.WA_AdvancedPlacement].
IBCode16.12.3Varchar2(6)Indicates international baccalaureate course code for the course record. Migrated from [Courses.WA_IBCode].
ALEFunded16.12.3Varchar2(1)Indicates ALE Course Type. Migrated from [Courses.WA_ALEFunded].
ContentAreaCd16.12.3Varchar2(3)Indicates Content Area Code. Migrated from [Courses.WA_ContentAreaCode].
StateCourseCd16.12.3Varchar2(6)Indicates State Course Code. Migrated from [Courses.WA_StateCourseCode].
WorkBased16.12.3Number(1,0)Indicates Work Based Course. Migrated from [Courses.Work_Based].
Desig_YouthReengagement18.5.0Number(1,0)Indicates course designation code for 1418 Youth reengagement dual credit (Y)
Desig_DistrictOrLocal18.5.0Number(1,0)Indicates course designation code for District or other local dual credit program (D)
Desig_locCrsAssessment19.7.1.0Varchar2(1)Indicates course designation code for Locally Determined Course – Locally Administered Assessment (X)
DualLangInstructionType19.7.1.0Varchar2(1)Dual Language Instruction Type
DualLangInstructionLang19.7.1.0Varchar2(3)Dual Language Instruction Language
ApprovedOnlineProvider19.8.2.0Varchar2(2)Identifies the online provider offering the course reported in Course ID.
ApprovedOnlineProgram19.8.2.0Varchar2(3)Identifies the online program offering the course reported in Course ID.
Desig_locTransition20.8.1.0Number(1,0)Indicates the course designation code for Local Transition (E).
Desig_CTE_CorePlus20.8.1.0Number(1,0)Indicates the course designation code for CTE Core Plus (F).
CourseLevel20.8.1.0Varchar2(1)Indicates the course's Course Level.
Desig_CTE_CP_Adv_Manuf21.5.3.2Number(1,0)Indicates the course designation for CTE Core Plus-Advanced Manufacturing (G).
Desig_CTE_CP_Maritime21.5.3.2Number(1,0)Indicates the course designation for CTE Core Plus-Maritime (U).
Desig_CTE_CP_Aerospace21.5.3.2Number(1,0)Indicates the course designation for CTE Core Plus-Aerospace (V).
Desig_CTE_CP_Constr21.5.3.2Number(1,0)Indicates the course designation for CTE Core Plus-Construction (W).
IndustryCertOffered20.8.1.0Varchar2(100)

Indicates the course's CTE Certifications offered.

CrsSequence21.6.2.0Number(2,0)Indicates the course's Sequence
CrsSequenceGroup21.6.2.0Varchar2(20)Indicates the course's Sequence Group
Tribal_Lang_Competency22.7.3.0Number(2,0)Indicates course designation code for J – Tribal Language Competency Test

 
 

JavaScript errors detected

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

If this problem persists, please contact our support.