S_WA_SEC_X (ver 22.7.3)
This table is an extension of the [SECTIONS] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
SectionssDCID | 14.11.0 | Number(10,0) | Foreign Key |
IsHomeroom | 16.7.0 | Number(1,0) | Homeroom Course (Used in K-3 Class Size Report) |
SecDesig_NonInstructional | 14.11.0 | Varchar2(1) | Non-Instructional (Z) (does not print on the transcript) |
| Non_FTE_Credit | 16.12.3 | Varchar2(2) | Indicates Non-FTE Course. Migrated from [Sections.WA_Sec_Non_FTE_Credit]. |
| SkillsProgram | 16.12.3 | Varchar2(1) | Indicates Skills Program Course. Migrated from [Sections.WA_Sec_Skills_Program]. |
| State_ExcludeFromReporting | 16.12.3 | Number(1,0) | Indicates whether section record is excluded from CEDARS reporting. Migrated from [Sections.WA_Sec_State_ExcludeFromReporting]. |
| Desig_TechPrep | 16.12.3 | Number(1,0) | Indicates course designation code for Tech Prep (T). Migrated from [Sections.WA_Sec_TechPrepStatus]. |
| Desig_IB | 16.12.3 | Number(1,0) | Indicates course designation code for International Baccalaureate (I). Migrated from [Sections.WA_Sec_IntlBaccalaureate]. |
| Desig_CollegeInHS | 16.12.3 | Number(1,0) | Indicates course designation code for College in the High School (C). Migrated from [Sections.WA_Sec_CollegeInHighSchool]. |
| Desig_Honors | 16.12.3 | Number(1,0) | Indicates course designation code for Honors (H). Migrated from [Sections.WA_Sec_HonorsOption]. |
| Desig_AP | 16.12.3 | Number(1,0) | Indicates course designation code for Advanced Placement (A). Migrated from [Sections.WA_Sec_Advanced]. |
| Desig_RunningStart | 16.12.3 | Number(1,0) | Indicates course designation code for Running Start (R). Migrated from [Sections.WA_Sec_RunningStart]. |
| Desig_CADR | 16.12.3 | Number(1,0) | Indicates course designation code for College Academic Distribution Requirements (B). Migrated from [Sections.WA_Sec_HECBCore]. |
| Desig_Cambridge | 16.12.3 | Number(1,0) | Indicates course designation code for Cambridge Program (K). Migrated from [Sections.WA_Sec_CambridgeOption]. |
| Desig_Online | 16.12.3 | Number(1,0) | Indicates course designation code for Online (O) (does not print on the transcript). Migrated from [Sections.WA_Sec_OnlineOption]. |
| Desig_LocalTest | 16.12.3 | Number(1,0) | Indicates course designation code for Local Competency Test (L). Migrated from [Sections.WA_Sec_LocalCompTest]. |
| Desig_NationalTest | 16.12.3 | Number(1,0) | Indicates course designation code for National Competency Test (N). Migrated from [Sections.WA_Sec_NationalCompTest]. |
| Desig_Quantitative | 16.12.3 | Number(1,0) | Indicates course designation code for Quantitative (Q). Migrated from [Sections.WA_Sec_Quantitative]. |
| Desig_SciLab | 16.12.3 | Number(1,0) | Indicates course designation code for Science Lab (S). Migrated from [Sections.WA_Sec_SciLab]. |
| APCode | 16.12.3 | Varchar2(6) | Indicates advanced placement course code for the section record. Migrated from [Sections.WA_Sec_AdvancedPlacement]. |
| IBCode | 16.12.3 | Varchar2(6) | Indicates advanced placement course code for the section record. Migrated from [Sections.WA_Sec_IBCode]. |
| ALEFunded | 16.12.3 | Varchar2(1) | Indicates ALE Course Type. Migrated from [Sections.WA_ALEFunded]. |
| ContentAreaCd | 16.12.3 | Varchar2(3) | Indicates Content Area Code. Migrated from [Sections.WA_Sec_ContentAreaCode]. |
| StateCourseCd | 16.12.3 | Varchar2(6) | Indicates State Course Code. Migrated from [Sections.WA_Sec_StateCourseCode]. |
| WorkBased | 16.12.3 | Number(1,0) | Indicates Work Based Course. Migrated from [Sections.WA_Sec_Work_Based]. |
| Desig_YouthReengagement | 18.5.0 | Number(1,0) | Indicates course designation code for 1418 Youth reengagement dual credit (Y) |
| Desig_DistrictOrLocal | 18.5.0 | Number(1,0) | Indicates course designation code for District or other local dual credit program (D) |
| Desig_locCrsAssessment | 19.7.1.0 | Varchar2(1) | Indicates course designation code for Locally Determined Course – Locally Administered Assessment (X) |
| DualLangInstructionType | 19.7.1.0 | Varchar2(1) | Dual Language Instruction Type |
| DualLangInstructionLang | 19.7.1.0 | Varchar2(3) | Dual Language Instruction Language |
| ApprovedOnlineProvider | 19.8.2.0 | Varchar2(2) | Identifies the online provider offering the course reported in Course ID. |
| ApprovedOnlineProgram | 19.8.2.0 | Varchar2(3) | Identifies the online program offering the course reported in Course ID. |
| Desig_locTransition | 20.8.1.0 | Number(1,0) | Indicates the course designation code for Local Transition (E). |
| Desig_CTE_CorePlus | 20.8.1.0 | Number(1,0) | Indicates the course designation code for CTE Core Plus (F). |
| IndustryCertOffered | 20.8.1.0 | Varchar2(100) | Indicates the course's CTE Certifications offered. |
| CourseLevel | 20.8.1.0 | Varchar2(1) | Indicates the course's Course Level. |
| CourseEquivalencyIdent | 20.8.1.0 | Varchar2(1) | Course equivalency for CTE courses. |
| CTECourseEquivalency | 20.8.1.0 | Varchar2(2) | Course equivalency designation for Career and Technical Education (CTE) courses. |
| CTECreditEquivalency | 20.8.1.0 | Varchar2(2) | Course credit equivalency for Career and Technical Education (CTE) courses. |
| Desig_CTE_CP_Adv_Manuf | 21.5.3 | Number(1,0) | Indicates the course designation for CTE Core Plus-Advanced Manufacturing (G). |
| Desig_CTE_CP_Maritime | 21.5.3 | Number(1,0) | Indicates the course designation for CTE Core Plus-Maritime (U). |
| Desig_CTE_CP_Aerospace | 21.5.3 | Number(1,0) | Indicates the course designation for CTE Core Plus-Aerospace (V). |
| Desig_CTE_CP_Constr | 21.5.3 | Number(1,0) | Indicates the course designation for CTE Core Plus-Construction (W). |
| SecSequence | 21.6.2.0 | Number(2,0) | Indicates the section's Sequence. |
| SecSequenceGroup | 21.6.2.0 | Varchar2(20) | Indicates the section's Sequence Group. |
| Tribal_Lang_Competency | 22.7.3.0 | Number(1,0) | Indicates course designation code for J – Tribal Language Competency Test |