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 | Version | Data Type | Description |
|---|---|---|---|
| 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 | DATE | Indicates 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 | CHAR | Indicates 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. |