S_NC_RPT_CTE_STUDENTS (Ver 20.11.0)
Column Name | Version | Data Type | Description |
|---|---|---|---|
| RPT_RUN_ID | 20.11.0 | NUMBER(22) | Report Run ID. |
| SCHOOL_NUMBER | 20.11.0 | NUMBER(10) | Student's current schoolid. |
| STUDENT_NUMBER | 20.11.0 | NUMBER(22) | Student's student_number. |
| LAST_NAME | 20.11.0 | VARCHAR2(50) | Student's Last Name. |
| FIRST_NAME | 20.11.0 | VARCHAR2(50) | Student's First Name. |
| SEX | 20.11.0 | VARCHAR2(2) | Student's sex. |
| GRADE_LEVEL | 20.11.0 | NUMBER(10) | Student's current grade level. |
| OCS_ECS_FLAG | 20.11.0 | VARCHAR2(1) | OCS/ECS flag (S_NC_EC.EC_REFERRED) |
| CAREER_CLUSTER | 20.11.0 | VARCHAR2(50) | Student's Career Cluster (S_NC_GP_BASE_REQ.BASE_SUBJECT) |
| CAREER_PATHWAY | 20.11.0 | VARCHAR2(20) | Student's Career Pathway (S_NC_GP_PATH_REQ.PATH_DESCRIPTION) |
| CONCENTRATOR_YN | 20.11.0 | VARCHAR2(1) | Calculated based on Student's progress in Cluster/Pathway. |
| OVERRIDE_YN | 20.11.0 | VARCHAR2(1) | CTE Override flag (S_NC_ACADEMIC.CTE_OVERRIDE) |