Skip to main content
Skip table of contents

S_NC_RPT_GDV_DETAIL (ver 13.6.0)

This table is a stand alone table that stores information used in the student Graduation Verification reports in both the fall and summer views. The Report Run ID links to the S_NC_RPT_RUN table that stores the Report Type of GDV for the summer collection and GDV2 for the fall final collection.

Column Name


Data Type


COURSE_CLASSIF 13.6.0 VARCHAR2(100)Indicates the classification of the graduate (i.e. Summer Graduate, Mid-Year Graduate, Regular Graduate)
COURSE_OF_STUDY 13.6.0 VARCHAR2(100)Indicates the code for the student's course of study.
ETHNIC_DESC 13.6.0 VARCHAR2(50)The description of the state ethnicity code.
FIRST_NAME 13.6.0 VARCHAR2(50)Indicates the student's first name.
GENDER 13.6.0 VARCHAR2(2)Indicates the student's gender.
GRADE_CODE 13.6.0 VARCHAR2(4)Indicates the state grade level code.
GRADE_LEVEL 13.6.0 VARCHAR2(4)Indicates the student's grade level.
GRADUATED_SCHOOLID 13.6.0 NUMBER(10,0)Indicates the number of the school that the student graduated from.
GRADUATED_SCHOOLNAME 13.6.0 VARCHAR2(60)Indicates the name of the school that the student graduated from.
GRAD_DATE 13.6.0 DATEIndicates the student's date of graduation.
GRAD_DOC 13.6.0 VARCHAR2(30)Indicates if the student received a certificate or diploma.
HAS_FATALS 13.6.0 CHARIndicates if the record has data that causes a fatal exception. This record will not be included in the final summary reports.
LAST_NAME 13.6.0 VARCHAR2(50)Indicates the student's last name.
POST_GRAD_INT 13.6.0 VARCHAR2(100)Indicates the student's post graduate intention.
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.
STATE_ETHNIC_CODE 13.6.0 VARCHAR2(1)The code for the state ethnicity.
STATE_STUDENTID 13.6.0 VARCHAR2(20)Indicates the state student number.
STUDENTID 13.6.0 NUMBER(,)Indicates the student number.

JavaScript errors detected

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

If this problem persists, please contact our support.