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 |