Skip to main content
Skip table of contents

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


Data Type



Indicates the academic level of the course. This is the fifth digit of the course code.

CAREER_TECHNICAL_IND13.6.0 CHARIndicates if the course is a CTE course. If the course code begins with a letter then it is a CTE course.
COURSE_END_DATE13.6.0 DATEThe student's exit date from the course enrollment.
COURSE_START_DATE13.6.0 DATEThe student's entry date into the course enrollment.
CREDITS_EARNED13.6.0 FLOATThe number of credits earned for this course. Only store codes of F1 are used.
FIRST_NAME13.6.0 VARCHAR2(50)The student's first name.
LAST_NAME13.6.0 VARCHAR2(50)The student's last name.
LEA_ID13.6.0 VARCHAR2(10)The LEA where the student took the course.
NUM_CREDITS13.6.0 FLOATThe potential number of credits for the course.
REPORTING_YEAR13.6.0 NUMBER(10,0)The year the student took the course.
RPT_RUN_ID13.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.
SCHOOLID13.6.0 NUMBER(10,0)The school id where the course was taken.
STATE_COURSE_CODE13.6.0 VARCHAR2(10)The first 7 characters of the course number.
STUDENTID13.6.0 NUMBER(,)The internal student id.
WISE_STUDENT_ID13.6.0 VARCHAR2(20)Indicates the state student number for the student.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.