S_NC_COURSEINFO (ver 14.6.0)
This table is an extension of the Courses table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
Academic_Level_Code | 13.6.0 | Varchar2(60) | Indicates the academic level of the course. |
Academic_Program_Indicator | 13.6.0 | Varchar2(10) | Indicates if the course is CCP or not. |
Career_Prep_IND | 13.6.0 | Varchar2(1) | Indicates if a course is a Career Prep course or not. |
COURSESDCID | 13.6.0 | Number(19,0) | The DCID identifier linking this table to the COURSES table. |
Course_External_Provider | 13.6.0 | Varchar2(1) | Indicates if the course is provided by NCVPS, NCSSM or not. |
Course_Gender | 13.6.0 | Varchar2(1) | The typically common gender for this course. |
Course_Grade_Level | 14.5.0 | Varchar2(15) | |
Course_Grade_Level_Range_High | 13.6.0 | Number(11,0) | Highest grade level course is designed for. |
Course_Grade_Level_Range_Low | 13.6.0 | Number(11,0) | Lowest grade level course is designed for. |
Course_Length_Code | 14.5.0 | Number(11,0) | Indicates the length the course is taught - all year, one semester,one quarter, etc. |
Course_Name_PostSecondary | 13.6.0 | Varchar2(160) | College course name. |
Course_Name_State | 13.6.0 | Varchar2(160) | State course Number. |
Course_Number_ESIS | 14.5.0 | Varchar2(44) | The state course Number is the legacy student information system - ESIS. |
Course_Number_PostSecondary | 13.6.0 | Varchar2(44) | College course Number. |
Course_Number_State | 13.6.0 | Varchar2(44) | State course Number. |
Course_Thirdparty_Provider | 13.6.0 | Varchar2(30) | Values are 'None', 'Odysseyware', etc. |
Credit_Hours_PostSecondary | 13.6.0 | Number(15,10) | The Number of post-secondary credit hours earned for this course. |
Credit_Value_Multiplier | 13.6.0 | Number(15,10) | The credit value multiplier for weighted credit. |
CTE_Level_Indicator | 13.6.0 | Varchar2(1) | CTE level |
Delivery_Mode | 13.6.0 | Varchar2(1) | Values include: classroom, online, blended, internship, cooperative education. |
End_Date | 14.5.0 | Date | The Date that the course code was deprecated at the state. |
Exam | 13.6.0 | Varchar2(1) | |
High_School_Credit | 13.6.0 | Varchar2(1) | Indicates the Number of high school credits that can be earned for this course. |
High_School_Credit_Apply | 13.6.0 | Varchar2(1) | |
Honors | 13.6.0 | Varchar2(1) | Indicates if this is an honors course. |
How_Taken_Code | 13.6.0 | Number(11,0) | Indicates how this course is typically taken - Regular Day School, Extended Day School, Correspondence, Summer School, etc. |
No_Of_Repeats | 13.6.0 | Number(11,0) | Indicates the Number of times the course can be repeated by a student. |
Post_Sec_Institution_Code | 13.6.0 | Varchar2(5) | Indicates the code for the post-secondary institution where this course is taught. |
Reserved_Boolean | 14.5.0 | Number(1,0) | |
Reserved_Float | 14.5.0 | Number(25,10) | |
Reserved_Number | 14.5.0 | Number(11,0) | |
Reserved_String | 14.5.0 | Varchar2(500) | |
School_Mode | 13.6.0 | Varchar2(1) | Indicates level of school taught at MS for HS. |
Select_Blended_Content | 13.6.0 | Varchar2(1) | Designation for blended content. |
Select_Credit_Recovery | 13.6.0 | Varchar2(1) | Credit recovery flag. |
Select_Nonstate_Course | 13.6.0 | Varchar2(1) | Indicates a local course. |
Select_Pilot_Course | 13.6.0 | Varchar2(1) | Course is a pilot instance. |
Select_State_Test | 13.6.0 | Varchar2(1) | Indicates if this course is associated to an assessment such as EOC or MSL. |
Short_Name | 13.6.0 | Varchar2(10) | Indicates the abbreviated course name assigned by the state. |
Start_Date | 14. 5.0 | Date | The Date the course code was added at the state. |
Sub_Department_ID | 13.6.0 | Number(11,0) | |
Traditional_Gender | 13.6.0 | Varchar2(1) | The typically common gender for this course. |