S_CC_X (ver 14.10.1)
This table is an extension of the [CC] 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 |
---|---|---|---|
CCDCID | 14.10.1 | Number(10,0) | Primary Key |
InstructionMode | 20.10.1 | Varchar2(3) | Mode of Instruction for student enrollment. |
IsAuditing | 14.10.1 | Number(1,0) | Indicates whether the student is auditing the class or not. |
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. |