S_NM_CRS_X (ver 14.2.0)
This is an extension of the Courses table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
CoursesDCID | 14.2.0 | Number(10,0) | Primary Key |
EOCTestSub2 | 14.2.0 | Varchar2(100) | Additional end-of-course test subject |
EOCTestSub | 14.8.0 | Varchar2(100) | End-of-course test subject. Migrated from custom field [Courses.NM_eoctestsub]. |
SpecialProgramCode | 14.12.0 | Varchar2(10) | Special program code |
Advanced_TF | 15.7.0 | Number(1,0) | Migrated from custom field [Courses.NM_AdvancedInd]. |
AltCourse_YN | 15.7.0 | Varchar2(5) | Migrated from custom field [Courses.NM_Alt_Course_Flag]. |
AltCourseNum | 15.7.0 | Varchar2(10) | Migrated from custom field [Courses.NM_Alt_Course_Num]. |
AP_TF | 15.7.0 | Number(1,0) | Migrated from custom field [Courses.NM_APInd]. |
Basic_TF | 15.7.0 | Number(1,0) | Migrated from custom field [Courses.NM_BasicInd]. |
CarandTech_TF | 15.7.0 | Number(1,0) | Migrated from custom field [Courses.NM_CarandTechInd]. |
CourseContentCode | 15.7.0 | Varchar2(10) | Migrated from custom field [Courses.NM_CourseContentCode]. |
Elect_TF | 15.7.0 | Number(1,0) | Migrated from custom field [Courses.NM_ElectInd]. |
EOCTestSub | 15.7.0 | Varchar2(100) | Migrated from custom field [Courses.NM_EOCTestSub]. |
Gifted_TF | 15.7.0 | Number(1,0) | Migrated from custom field [Courses.NM_GiftedInd]. |
Honors_TF | 15.7.0 | Number(1,0) | Migrated from custom field [Courses.NM_HonorsInd]. |
IB_TF | 15.7.0 | Number(1,0) | Migrated from custom field [Courses.NM_IBInd]. |
LabComp_TF | 15.7.0 | Number(1,0) | Migrated from custom field [Courses.NM_LabCompInd]. |
Remedial_TF | 15.7.0 | Number(1,0) | Migrated from custom field [Courses.NM_RemedialInd]. |
SPED_TF | 15.7.0 | Number(1,0) | Migrated from custom field [Courses.NM_SPEDInd]. |
CourseDeliveryModelCode | 16.7.2 | Varchar2(5) | Course Delivery Model Code |
PreAPSBCrs | 16.8.2 | Varchar2(1) | Pre-AP / Springboard Course indicator |
State_ExcludeFromReporting | 17.1.0 | Number(1,0) | Exclude from Course Domain Extracts. |
ClassPeriod | 17.7.0 | Varchar2(5) | Class Period for Courses |
BEPCrs | 17.9.0 | Varchar2(3) | BEP Course Indicator Override |
PreAdvPlacementIndicator | 18.8.0 | Number(1,0) | Pre Advanced Placement Indicator |