S_NC_RPT_CFU_COURSES (ver 13.6.0)
This table is a stand alone table that stores information about the courses the student has taken that are reported on the Common Followup Collection.This is only extracted for F1 grades in Stored Grades.
Column Name | Version | Data Type | Description |
---|---|---|---|
ACADEMIC_LEVEL | 13.6.0 | CHAR | Indicates the academic level of the course. This is the fifth digit of the course code. |
CAREER_TECHNICAL_IND | 13.6.0 | CHAR | Indicates if the course is a CTE course. If the course code begins with a letter then it is a CTE course. |
COURSE_END_DATE | 13.6.0 | DATE | The student's exit date from the course enrollment. |
COURSE_START_DATE | 13.6.0 | DATE | The student's entry date into the course enrollment. |
CREDITS_EARNED | 13.6.0 | FLOAT | The number of credits earned for this course. Only store codes of F1 are used. |
FIRST_NAME | 13.6.0 | VARCHAR2(50) | The student's first name. |
LAST_NAME | 13.6.0 | VARCHAR2(50) | The student's last name. |
LEA_ID | 13.6.0 | VARCHAR2(10) | The LEA where the student took the course. |
NUM_CREDITS | 13.6.0 | FLOAT | The potential number of credits for the course. |
REPORTING_YEAR | 13.6.0 | NUMBER(10,0) | The year the student took the course. |
RPT_RUN_ID | 13.6.0 | 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. |
SCHOOLID | 13.6.0 | NUMBER(10,0) | The school id where the course was taken. |
STATE_COURSE_CODE | 13.6.0 | VARCHAR2(10) | The first 7 characters of the course number. |
STUDENTID | 13.6.0 | NUMBER(,) | The internal student id. |
WISE_STUDENT_ID | 13.6.0 | VARCHAR2(20) | Indicates the state student number for the student. |