S_CA_CRS_X (ver 16.2.2)
This table is an extension of the [Courses] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
CoursesDCID | 16.2.2 | Number(10,0) | A foreign key that relates the extended table to the Courses table. |
| AP_IB_Code_Reference | 19.7.1.0 | Varchar2(4) | AP/IB course code cross reference. |
| Charter_Prep_Ind | 19.7.1.0 | Varchar2(1) | Charter non-core, non-college prep indicator. |
| Content_Std_Alignment | 19.7.1.0 | Varchar2(1) | Content standards alignment code. |
| Content_Subcategory_Code | 19.7.1.0 | Varchar2(7) | Course content area subcategory code. |
ContentCode | 16.2.2 | Varchar2(3) | Content code. Migrated from [Courses.CA_ContentCode]. |
CourseLevel | 16.2.2 | Varchar2(2) | Academic course level. Migrated from [Courses.CA_CourseLevel]. |
CourseType | 16.2.2 | Varchar2(2) | Course type. Migrated from [Courses.CA_CourseType]. |
CTECapstone | 16.2.2 | Varchar2(1) | CTE Capstone Course. Migrated from [Courses.CA_CTECapstone]. |
CTEProvider | 16.2.2 | Varchar2(1) | CTE Provider Code. Migrated from [Courses.CA_CTEProvider]. |
CTETechPrep | 16.2.2 | Varchar2(1) | CTE Technical Preparation Indicator. Migrated from [Courses.CA_CTETechPrep]. |
| Dept_Grade_Lvl_Range | 19.7.1.0 | Varchar2(3) | Departmentalized course standards grade level range code. |
DistanceLearning | 16.2.2 | Varchar2(1) | Distance/Online Learning Indicator. Migrated from [Courses.CA_DistanceLearning]. |
EdServiceCode | 16.2.2 | Varchar2(1) | Education Service Code. Migrated from [Courses.CA_EdServiceCode]. |
FundingSource | 16.2.2 | Varchar2(3) | Education Program Funding Source Code. Migrated from [Courses.CA_FundingSource]. |
| GSSMD_Subject | 18.3.0 | Varchar2(1) | Golden State Seal Merit Diploma Subject (History, Science, Math, ELA, etc.). |
| High_Quality_CTE_Ind | 19.7.1.0 | Varchar2(1) | High-quality CTE course indicator. |
IndependentStudy | 16.2.2 | Varchar2(1) | Independent Study Indicator. Migrated from [Courses.CA_IndependentStudy]. |
InstStrategy | 16.2.2 | Varchar2(3) | Instructional Strategy Code. Migrated from [Courses.CA_InstStrategy]. |
LangInstruction | 16.2.2 | Varchar2(2) | Language of Instruction Code. Migrated from [Courses.CA_LangInstruction]. |
| Local_Assignment_Opt_Code | 19.7.1.0 | Varchar2(2) | Local assignment option code. |
| Middle_School_Ind | 19.7.1.0 | Varchar2(1) | Middle school core indicator. |
NCLBCoreCourse | 16.2.2 | Varchar2(1) | NCLB core course. Migrated from [Courses.CA_NCLBCoreCourse]. |
NS_Instructional_Lvl | 16.2.2 | Varchar2(2) | Instructional level code. Migrated from [Courses.CA_NS_Instructional_Lvl]. |
| Online_Instruction_Type | 19.7.1.0 | Varchar2(1) | Online course instruction type code. |
| PathwayCode | 17.11.0 | Varchar2(3) | The CTE Pathway Code for the course. Local use only, not reported to CALPADS. |
State_ExcludeFromReporting | 16.2.2 | Number(1,0) | Exclude From State Reporting Indicator. Migrated from [Courses.State_ExcludeFromReporting]. |
TranscriptCourseName | 16.2.2 | Varchar2(25) | Course Name to use on Transcripts. Migrated from [Courses.CA_TranscriptCourseName]. |
UCCSU_Area | 16.2.2 | Varchar2(2) | UC/CSU Approved Course Subject Area (Grades 7-12). Migrated from [Courses.CA_UCCSU_Area]. |
| Subject_area | 22.5.3 | Varchar2(10) | The subject area for CASSPP group information. |