S_NC_RPT_CTE_COURSES (ver 21.2.2)
This table is a stand alone table that stores information about the CTE level requirement for courses that are reported on the CTE Concentrator Calculation (CTE) collection .
Column Name | Version | Data Type | Description |
|---|---|---|---|
| CAREER_CLUSTER | 21.2.2 | VARCHAR2(50 CHAR) | CTE Cluster Name |
| CAREER_PATHWAY | 21.2.2 | VARCHAR2(20 CHAR) | CTE Pathway Name |
| CAREER_PATHWAY_LEVEL | 21.2.2 | VARCHAR2(200 CHAR) | Pathway category (4,5,6 etc..) |
| CAREER_PATHWAY_NAME | 21.2.2 | VARCHAR2(100 CHAR) | Pathwar description |
| COURSE_ASSOC_ID | 21.2.2 | NUMBER | Association ID. |
| COURSE_CODE | 21.2.2 | VARCHAR2(11 CHAR) | It indicate first 7 Character from Course Number. |
| COURSE_NAME | 21.2.2 | VARCHAR2(40 CHAR) | Course name |
| COURSE_NUMBER | 21.2.2 | VARCHAR2(11 CHAR) | Course number |
| PATH_REQ_STR5 | 21.2.2 | VARCHAR2(500 CHAR) | This data is taken from S_NC_GP_PATH_REQ.STR5. |
| RPT_RUN_ID | 21.2.2 | NUMBER | Indicates the unique report run ID for this run. This links to the S_NC_RPT_RUN table to identify the LEA, School, Report Type, Instance ID, and Year ID. |
| SCHOOL_NUMBER | 21.2.2 | NUMBER | The school number. |