S_NJ_CRS_X (ver 15.7.3)
This is an extension of the [Courses] table.
Column Name | Version | Data Type | Description |
---|---|---|---|
CoursesDCID | 15.7.3 | Number(10,0) | Primary key that relates the extended table to the [Courses] table. |
CTE_Test_Name_Code | 15.7.3 | VarChar2(32) | The code representing the CTE Test Name. |
Block_Schedule_Session | 16.12.3 | VarChar2(1) | Used by PARCC & State Assessment Registration to indicate if a Course is Block Scheduled. |
Course_Level | 17.2.0 | Varchar2(1) | Migrated from: [Courses]NJ_Course_Level |
Course_Sequence_code | 17.2.0 | Varchar2(2) | Migrated from: [Courses]NJ_Course_Sequence |
Course_Span | 17.2.0 | Varchar2(4) | Migrated from: [Courses]NJ_Course_Span |
Course_Type | 17.2.0 | Varchar2(2) | Migrated from: [Courses]NJ_Course_Type |
NCES_Course_Id | 17.2.0 | Varchar2(3) | Migrated from: [Courses]NJ_NCES_Course_Id |
NCES_Subject_Area | 17.2.0 | Varchar2(2) | Migrated from: [Courses]NJ_NCES_Subject_Area |
Exclude_Course_Submission_TF | 17.2.0 | Number(1,0) | Migrated from: [Courses]NJ_Exclude_Course_Submission |
AP_Course_Subject | 17.2.0 | Varchar2(2) | Migrated from: [Courses]NJ_AP_Course_Subject |
CTECollegeCredits | 17.2.0 | Varchar2(2) | Migrated from: [Courses]NJ_CTECollegeCredits |
CTETestDeveloperCode | 17.2.0 | Varchar2(1) | Migrated from: [Courses]NJ_CTETestDeveloper |
CTETestName | 17.2.0 | Varchar2(3) | Migrated from: [Courses]NJ_CTETestName |
County_Code_Override | 17.4.0 | Varchar2(2) | Used for CTE and possible other reports in the future. |
District_Code_Override | 17.4.0 | Varchar2(4) | Used for CTE and possible other reports in the future. |
School_Code_Override | 17.4.0 | Varchar2(3) | Used for CTE and possible other reports in the future. |
SLA_Include_TF | 17.12.1 | Number(1,0) | Whether to include this Course in the NJ SLA-S assessment |