S_CRS_X (ver 19.2.0)
This table is an extension of the [Courses] table. This table is available for all states/provinces and may or may not be utilized for your state/province.
| Column Name | Version | Data Type | Description |
|---|---|---|---|
| CoursesDCID | 19.2.0 | Number(10,0) | Primary Key |
| AcademicSubject | 19.11.1.0 | Varchar2(50) | Ed-Fi academicSubject descriptor. |
| CourseLevel | 19.11.1.0 | Varchar2(50) | Ed-Fi levelCharacteristics descriptor, e.g. AP, IB, Dual Credit, CTE etc. |
| ExcludeFromEdFi | 19.11.1.0 | Number(1,0) | Exclude course, course sections, and related data from Ed-Fi publishing. |
| Fitness_Assessment | 19.2.0 | Varchar2(1) | Indicate additional courses beyond the normal PE courses for Fitness Assessment. For example: For inclusion in the FitnessGram extract. |
| InstructionMode | 20.10.1 | Varchar2(3) | Mode of Instruction for the Courses. |
| MaxCompletionsForCredit | 19.11.1.0 | Number(11,0) | Ed-Fi maxCompletionsForCredit. The number of times course may be taken for credit - typically blank unless > 1. |
| NumberOfParts | 19.11.1.0 | Number(11,0) | Ed-Fi numberOfParts. The number of parts identified for a course - typically blank unless > 1. |
| SCED_AP_Type | 19.8.2.0 | Varchar2(30) | Required for CRDC while counting aggregates of students enrolled and passed in a particular AP type. |
| SCED_Carnegie_Credit | 19.8.2.0 | Varchar2(4) | The amount of credit available to a student who successfully meets the objectives of the course. |
| SCED_CompleteCourseCode | 20.1.2.0 | Varchar2(12) | The complete SCED course code. Derived from SCED_Course_Code, SCED_Carnegie_Credit or SCED_Grade_Span, and SCED_Sequence. |
| SCED_Course_Code | 19.8.2.0 | Varchar2(5) | The federally assigned SCED code. Typically a five-digit number. |
| SCED_Course_Level | 19.8.2.0 | Varchar2(1) | The SCED course level. |
| SCED_Grade_Span | 19.8.2.0 | Varchar2(4) | The grade span for which the course is appropriate. The grade span is represented as a four-character code with no decimals |
| SCED_Sequence | 19.8.2.0 | Varchar2(2) | Represents the sequential position of a specific course when the course is part of a consecutive sequence of courses. Updated from one character to two characters in version 20.1.2.0. |
| SCED_Subject_Type | 19.8.2.0 | Varchar2(30) | Required for CRDC while counting aggregates of students enrolled and passed in a particular subject type. |