S_MA_CRS_X (ver 15.11.0)
This table is an extension of the Courses table.
Column Name | Version | Data Type | Description |
---|---|---|---|
CoursesDCID | 15.11.0 | Number(10,0) | Primary key that relates the extended table to the [Courses] table. |
AdvancedPlacement | 15.11.0 | Number(1,0) | Indicates if the course is an advance placement course. Migrates from [Courses]MA_AP. |
CoreCourseIndicator | 15.11.0 | Number(1,0) | Indicates for SIF that the course is considered a core course. Migrates from [Courses]MA_CoreAcademicIndicator. |
CourseLevel | 15.11.0 | Varchar2(2) | Indicates the level of the curriculum of the course such as general or advanced. Migrates from [Courses]MA_course_level. |
GradeLevel | 15.11.0 | Varchar2(4) | Indicates the highest grade level student allowed in the class. Migrates from [Courses]MA_grade_level. |
MarkNotRequired | 15.11.0 | Number(1,0) | Indicates the course does not receive a grade or a mark. Migrates from [Courses]MA_marknotrequired. |
NCESCode | 15.11.0 | Varchar2(10) | The NCES code that best describes the course and course curriculum. Migrates from [Courses]MA_nces_code. |
NoPercent | 15.11.0 | Number(1,0) | Indicates the course receives a Pass/Fail mark but not a numeric/percentage grade. Migrates from [Courses]MA_nopercent. |
OverrideSchoolCode | 15.11.0 | Varchar2(8) | Overrides the school code associated with the course. Can be used to designate online or college courses or other courses taken outside the school that need to be reported. Migrates from [Courses]MA_SchoolCode. |
State_ExcludeFromReporting | 15.11.0 | Number(1,0) | Indicates whether or not the course is excluded from state reporting (1 = excluded). Migrates from [Courses]MA_exclude_from_epims. |
Ungraded | 15.11.0 | Number(1,0) | Indicates whether or not the course is an ungraded course. Migrates from [Courses]MA_ungraded. |
PathwaysCourse | 20.7.2 | Varchar2(2) | A field to collect Pathway Course value and to add it to the report extract. |