S_CA_SEC_X (ver 16.2.2)
This table is an extension of the Sections table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
SectionsDCID | 16.2.2 | Number(10,0) | A foreign key that relates the extended table to the [Sections] table. |
AcademicTerm | 16.2.2 | Varchar2(2) | Academic Term Override. Migrated from [Sections.CA_AcademicTerm]. |
| AP_IB_Code_Reference | 19.7.1.0 | Varchar2(4) | AP/IB course code cross reference. |
CensusTeacherId | 16.2.2 | Varchar2(10) | Census Day Teacher SEID Override. Migrated from [Sections.CA_CensusTeacherId]. |
| Charter_Prep_Ind | 19.7.1.0 | Varchar2(1) | Charter non-core, non-college prep indicator. |
| Content_Subcategory_Code | 19.7.1.0 | Varchar2(7) | Course content area subcategory code. |
CTECapstone | 16.2.2 | Varchar2(1) | CTE Capstone Course. Migrated from [Sections.CA_CTECapstone]. |
CTEProvider | 16.2.2 | Varchar2(1) | CTE Provider Code. Migrated from [Sections.CA_CTEProvider]. |
DistanceLearning | 16.2.2 | Varchar2(1) | Distance/Online Learning Indicator. Migrated from [Sections.CA_DistanceLearning]. |
EdServiceCode | 16.2.2 | Varchar2(1) | Education Service Code. Migrated from [Sections.CA_EdServiceCode]. |
FundingSource | 16.2.2 | Varchar2(3) | Education Program Funding Source Code. Migrated from [Sections.CA_FundingSource]. |
| GSSMD_Subject | 18.3.0 | Varchar2(1) | Golden State Seal Merit Diploma Subject Area. Override for course-level value. |
| High_Quality_CTE_Ind | 19.7.1.0 | Varchar2(1) | High-quality CTE course indicator. |
HQTCompentency | 16.2.2 | Varchar2(1) | Highly Qualified Teacher Competency Code. Migrated from [Sections.CA_HQTCompentency]. |
IndependentStudy | 16.2.2 | Varchar2(1) | Independent Study Indicator. Migrated from [Sections.CA_IndependentStudy]. |
InstStrategy | 16.2.2 | Varchar2(3) | Instructional Strategy Code. Migrated from [Sections.CA_InstStrategy]. |
LangInstruction | 16.2.2 | Varchar2(2) | Language of Instruction Code. Migrated from [Sections.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. |
MultHQTCompentency | 16.2.2 | Varchar2(1) | If Multiple Teachers, Highly Qualified Teacher Competency Code. Migrated from [Sections.CA_MultHQTCompentency]. |
MultipleTeacherID | 16.2.2 | Varchar2(10) | If Multiple Teachers, Teacher SEID. Migrated from [Sections.CA_MultipleTeacherID]. |
MultipleTeacherStatus | 16.2.2 | Varchar2(2) | Multiple Teacher Status. Migrated from [Sections.CA_MultipleTeacherStatus]. |
NS_Instructional_Lvl | 16.2.2 | Varchar2(2) | Instructional Level Code. Migrated from [Sections.CA_NS_Instructional_Lvl]. |
| Online_Instruction_Type | 19.7.1.0 | Varchar2(1) | Online course instruction type code. |
| Subject_area | 20.12.1.0 | Varchar2(20) | The subject area for CASSPP group information. |