Tool Search: NC Graduation Data Verification
The Graduation Data Verification Collection contains demographic, graduation, and post-graduate intentions information for high school graduates, providing school districts with an authoritative list of their graduates. This data is used for the annual North Carolina Public Schools Statistical Profile and the State Archives.
Generate the Data Validation Report for the Data Validation Group of Graduation Data Verification to review data prior to generating the report.
NC Graduation Data Verification Extract
Report Logic
For all report types:
- Students must be aged 16 or older.
- Only students who have an Enrollment End Status of W4: Early Completer/Midyear Grad or W6: High School Graduate are included on the report.
- The student's Diploma Date must fall between the dates of 08/07/XX, where XX is the beginning year of the reporting enrollment, and 08/06/XX, where XX is the end year of the reporting enrollment. For example, a 23-24 enrollment uses the dates 08/07/23 and 08/06/24.
- The student's most recent Primary Enrollment that has a Start Date that is before or equal to the Diploma Date reports.
- When a student is a summer graduate (has a summer enrollment and a graduation Diploma Date during the summer period) AND has an enrollment in the next calendar where No Show is marked, the student's record from their summer graduation continues to report, so long as the summer calendar is selected on the extract editor.
Students do not report when:
- The Enrollment is marked as No Show or State Exclude.
- The Calendar of Enrollment is marked as State Exclude.
Each report type included specific logic to generate, as noted in the Report Layouts section.
Graduate Classifications
The Diploma Period selection (entered on the Graduation record) determines the classification reported for the student (e.g., “XXth Grade Mid-Year,” “XXth Grade Regular,” “XXth Grade Summer”).
See the NCSIS Graduation article for additional information.
| Classification | Requirements |
|---|---|
| Summer School Graduates | These students must meet the following requirements:
These students will display as XX Grade Summer (e.g., 12th Grade Summer). |
| Mid-Year/Early Graduates | These students must meet the following requirements:
|
| Regular Program Graduations | These students must meet the following requirements:
|
Report Editor
| Data Element | Description |
|---|---|
| Setup | |
| Search Calendars | Use the search field to narrow the list of calendars to select. Use the Expand All/Collapse All option. Place a checkbox next to the desired school and calendars.
As noted, all calendars are automatically selected because this is a school-wide report. |
| Show Active Year Only |
Only those calendars for the school year are available for selection when set to ON.
When set to OFF, all calendars from all school years are available for selection based on the user's tool rights. |
| Report Options | |
| Report Type |
Determines which Graduation Data Verification report generates. Options:
|
| Ad hoc Filter | Allows selection of a filter that was previously created. Only students included on the selected filter return on the report.
This option is available with the Extract Types of PMR Detail, Students Not Included in PMR Summary, and GRS Detail. |
| Output Options | |
| Report Processing | This is a complex report and requires several minutes to create the data snapshot. Because of this, it always needs to be generated using the Submit to Batch option.
The Batch Queue processing can be used for both the report generation and the report review, allowing results to be reviewed at a later time. The Snapshot being compared is taken at the same time as the PMR summary and only students who report on the PMR summary are used in the counts. Submitting to Batch is useful when generating the report for several calendars or for more significant amounts of reported data. See the Batch Queue article for more information. |
| Format Type | Determines in which format the report generates - CSV or HTML. |
Generate the Report
- Search for and select the desired Calendars.
- Select the desired Report Type from the dropdown list. Only one can be selected.
- Select an Ad hoc Filter to only report data for students included in the filter.
- Select the desired Report Processing option of Generate Now or Submit to Batch Queue.
- Select the desired Format Type.
- Click Generate. The report displays in the selected format.
See the Report Layout section for report examples for each Report Type.
Report Layouts
Student Detail
This report lists students who are Summer Graduates, Early/Mid-Year Graduates, and Regular Program Graduates. It includes student demographic data, course of study, and what the student plans to do post-graduation (college, work, etc.).
Student Detail Report - HTML Format| Data Element | Description | Location |
|---|---|---|
| School Number | Reports the School Number assigned to the student's School of Enrollment.
Numeric, 6 digits |
School Information > State School Number
School.number |
| School Name | Reports the name of the school in which the student is enrolled.
Alphanumeric, 30 characters |
School Information > School Detail > School Name
School.name |
| Student ID | Reports the student's State ID.
Numeric, 9 digits |
Demographics > Person Identifiers > Student State ID
Person.stateID |
| Last Name | Reports the student's Last Name.
The Legal Last Name value reports when populated in the Protected Identity Information. Alphanumeric, 30 characters |
Identities > Identity Information > Last Name
Identities.lastName Identities > Person Information > Protects Identity Information > Legal Last Name Identity.legalLastName |
| First Name | Reports the student's First Name.
The Legal First Name value reports when populated in the Protected Identity Information. Alphanumeric, 30 characters |
Identities > Identity Information > First Name
Identities.firstName Identities > Person Information > Protects Identity Information > Legal First Name Identity.legalFirstName |
| Sex | Reports the student's designated sex.
The Birth Sex value reports when populated in the Protected Identity Information.
|
Identities > Identity Information > Sex
Identities.gender Identities > Identity Information > Protected Identity Information > Birth Sex
Identities.legalGender |
| Ethnicity | Reports the student's Race/Ethnicity.
Alphanumeric, 10 characters |
Demographics > Person Information > Race/Ethnicity
Identity.raceEthnicity |
| Course of Study | Reports the student's Graduation Plan from the Diploma Type field assigned on the student's Graduation record.
Alphanumeric, 30 characters |
Graduation > Diploma Type
Graduation.diplomaType |
| Graduation Program | Reports whether the student graduates with a Certificate or a Diploma based on the value assigned in the Diploma Type field.
Alphanumeric, 12 characters |
Graduation > Diploma Type
Graduation.diplomaType |
| Diploma Issue Date | Reports the date the student's diploma was issued. | Graduation > Diploma Date
Graduation.diplomaDate |
| Classification | Indicates whether the student is a Summer, Mid-Year, or Regular Program graduate.
See the Graduation Classifications section for additional information. Alphanumeric, 20 characters |
Graduation > Diploma Period
Graduation.diplomaPeriod Graduation > Diploma Date Graduation.diplomaDate |
| Bound For | Indicates what the student is doing after high school graduation - school, employment, military, etc.
Alphanumeric, 20 characters |
Graduation > Post Grad Plans
Graduation.postGradPlans |
Certificates by Course of Study
This report provides a count of students who graduated with a Certificate by sex (male, female) and Race/Ethnicity.
The Diploma Type on the student's Graduation record must be set to GWC: Graduation with Certificate.
Certificates by Course of Study - HTML Format| Data Element | Description | Location |
|---|---|---|
| School Number | Reports the School Number assigned to the student's School of Enrollment.
Numeric, 6 digits |
School Information > State School Number
School.number |
| School Name | Reports the name of the school in which the student is enrolled.
Alphanumeric, 30 characters |
School Information > School Detail > School Name
School.name |
| Sex | Lists separate rows for Female and Male, followed by a row for Total Females and Total Males. Each row is totaled at the end of the report in the TOTAL column, as well as in the row for School Totals and LEA Total.
Alphanumeric, 10 characters |
Identities > Identity Information > Protected Identity Information >Legal Sex
Identities.legalGender
Identities.gender |
| Course of Study | Reports the student's Graduation Plan from the Diploma Type field assigned on the student's Graduation record when the value is set to GWC: Graduated with Certificate.
Alphanumeric, 30 characters |
Graduation > Diploma Type
Graduation.diplomaType |
| American Indian | Reports a count of students who have a Race/Ethnicity of I: American Indian or Alaska Native and who graduated with a Diploma Type of GWC: Graduated with Certificate.
Numeric, 3 digits |
Identities > Identity Information > Race/Ethnicity > Race Ethnicity > I: American Indian or Alaska Native
Identity.raceEthnicity Graduation > Diploma Type > GWC: Graduated with Certificate Graduation.diplomaType |
| Asian | Reports a count of students who have a Race/Ethnicity of A: Asian and who graduated with a Diploma Type of GWC: Graduated with Certificate.
Numeric, 3 digits |
Identities > Identity Information > Race/Ethnicity > Race Ethnicity > A: Asian
Identity.raceEthnicity Graduation > Diploma Type > GWC: Graduated with Certificate Graduation.diplomaType |
| Black | Reports a count of students who have a Race/Ethnicity of B: Black or African American and who graduated with a Diploma Type of GWC: Graduated with Certificate.
Numeric, 3 digits |
Identities > Identity Information > Race/Ethnicity > Race Ethnicity > B: Black or African American
Identity.raceEthnicity Graduation > Diploma Type > GWC: Graduated with Certificate Graduation.diplomaType |
| White | Reports a count of students who have a Race/Ethnicity of W: White and who graduated with a Diploma Type of GWC: Graduated with Certificate.
Numeric, 3 digits |
Identities > Identity Information > Race/Ethnicity > Race Ethnicity > W: White
Identity.raceEthnicity Graduation > Diploma Type > GWC: Graduated with Certificate Graduation.diplomaType |
| Native Hawaiian or Other Pacific Islander | Reports a count of students who have a Race/Ethnicity of P: Native Hawaiian or Other Pacific Islander and who graduated with a Diploma Type of GWC: Graduated with Certificate.
Numeric, 3 digits |
Identities > Identity Information > Race/Ethnicity > Race Ethnicity > P: Native Hawaiian or Other Pacific Islander
Identity.raceEthnicity Graduation > Diploma Type > GWC: Graduated with Certificate Graduation.diplomaType |
| Hispanic | Reports a count of students who have a Race/Ethnicity of H: Hispanic or Latino Ethnicity and who graduated with a Diploma Type of GWC: Graduated with Certificate.
Numeric, 3 digits |
Identities > Identity Information > Race/Ethnicity > Race Ethnicity > H: Hispanic or Latino Ethnicity
Identity.raceEthnicity Graduation > Diploma Type > GWC: Graduated with Certificate Graduation.diplomaType |
| Two or More | Reports a count of students who have a Race/Ethnicity of M: Two or More Races and who graduated with a Diploma Type of GWC: Graduated with Certificate.
Numeric, 3 digits |
Identities > Identity Information > Race/Ethnicity > Race Ethnicity > M: Two or More Races
Identity.raceEthnicity Graduation > Diploma Type > GWC: Graduated with Certificate Graduation.diplomaType |
| TOTAL | Reports separate counts for the following:
|
Calculation, data not stored |
| Total Females | Count of female students across all race/ethnicities who graduated with a certificate. | Calculation, data not stored |
| Total Males | Count of male students across all race/ethnicities who graduated with a certificate. | Calculation, data not stored |
| LEA Total | Count of both male and female students per school across all race/ethnicities who graduated with a certificate. | Calculation, data not stored |
Diplomas by Course of Study
This report provides a count of students who graduated with a Diploma by sex (male, female), ethnicity, and Course of Study.
The Diploma Type on the student's Graduation record must be set to FRC: Future Ready Core.
Diplomas by Course of Study - CSV Format| Data Element | Description | Location |
|---|---|---|
| School Number | Reports the School Number assigned to the student's School of Enrollment.
Numeric, 6 digits |
School Information > State School Number
School.number |
| School Name | Reports the name of the school in which the student is enrolled.
Alphanumeric, 30 characters |
School Information > School Detail > School Name
School.name |
| Sex | Lists separate rows for Female and Male, followed by a row for Total Females and Total Males.
Alphanumeric, 10 characters |
Identities > Identity Information > Protected Identity Information >Legal Sex
Identities.legalGender
Identities.gender |
| Course of Study | Reports the student's Graduation Plan from the Diploma Type field assigned on the student's Graduation record when the value is set to FRC: Future Ready Core.
Alphanumeric, 30 characters |
Graduation > Diploma Type > FRC: Future Ready Core
Graduation.diplomaType |
| American Indian | Reports a count of students who have a Race/Ethnicity of I: American Indian or Alaska Native and who graduated with a Diploma Type of FRC: Future Ready Core.
Numeric, 3 digits |
Identities > Identity Information > Race/Ethnicity > Race Ethnicity > I: American Indian or Alaska Native
Identity.raceEthnicity Graduation > Diploma Type > FRC: Future Ready Core Graduation.diplomaType |
| Asian | Reports a count of students who have a Race/Ethnicity of A: Asian and who graduated with a Diploma Type of FRC: Future Ready Core.
Numeric, 3 digits |
Identities > Identity Information > Race/Ethnicity > Race Ethnicity > A: Asian
Identity.raceEthnicity Graduation > Diploma Type > FRC: Future Ready Core Graduation.diplomaType |
| Black | Reports a count of students who have a Race/Ethnicity of B: Black or African American and who graduated with a Diploma Type of FRC: Future Ready Core.
Numeric, 3 digits |
Identities > Identity Information > Race/Ethnicity > Race Ethnicity > B: Black or African American
Identity.raceEthnicity Graduation > Diploma Type > FRC: Future Ready Core Graduation.diplomaType |
| White | Reports a count of students who have a Race/Ethnicity of W: White and who graduated with a Diploma Type of FRC: Future Ready Core.
Numeric, 3 digits |
Identities > Identity Information > Race/Ethnicity > Race Ethnicity > W: White
Identity.raceEthnicity Graduation > Diploma Type > FRC: Future Ready Core Graduation.diplomaType |
| Native Hawaiian or Other Pacific Islander | Reports a count of students who have a Race/Ethnicity of P: Native Hawaiian or Other Pacific Islander and who graduated with a Diploma Type of FRC: Future Ready Core.
Numeric, 3 digits |
Identities > Identity Information > Race/Ethnicity > Race Ethnicity > P: Native Hawaiian or Other Pacific Islander
Identity.raceEthnicity Graduation > Diploma Type > FRC: Future Ready Core Graduation.diplomaType |
| Hispanic | Reports a count of students who have a Race/Ethnicity of H: Hispanic or Latino Ethnicity and who graduated with a Diploma Type of FRC: Future Ready Core.
Numeric, 3 digits |
Identities > Identity Information > Race/Ethnicity > Race Ethnicity > H: Hispanic or Latino Ethnicity
Identity.raceEthnicity Graduation > Diploma Type > FRC: Future Ready Core Graduation.diplomaType |
| Two or More | Reports a count of students who have a Race/Ethnicity of M: Two or More Races and who graduated with a Diploma Type of FRC: Future Ready Core.
Numeric, 3 digits |
Identities > Identity Information > Race/Ethnicity > Race Ethnicity > M: Two or More Races
Identity.raceEthnicity Graduation > Diploma Type > FRC: Future Ready Core Graduation.diplomaType |
| TOTAL | Reports separate counts for the following:
|
Calculation, data not stored |
| Total Females | Count of female students across all race/ethnicities who graduated with a certificate. | Calculation, data not stored |
| Total Males | Count of male students across all race/ethnicities who graduated with a certificate. | Calculation, data not stored |
| LEA Total | Count of both male and female students per school across all race/ethnicities who graduated with a certificate. | Calculation, data not stored |
Certificates by Post Graduate Intention
This report provides a list of students who graduated with a Certificate. It includes student demographic data, course of study, and what the student is planning to do post-graduation (college, work, etc.).
The following fields on the student's Graduation record are required:
- Post Grad Plans MUST be populated with any of the available options.
- Diploma Type must be set to GWC: Graduation with Certificate.
Certificates by Post Graduate Location - CSV Format| Data Element | Description | Location |
|---|---|---|
| School Number | Reports the School Number assigned to the student's School of Enrollment.
Numeric, 6 digits |
School Information > State School Number
School.name |
| School Name | Reports the name of the school in which the student is enrolled.
Alphanumeric, 30 characters |
School Information > School Detail > School Name
School.number |
| Sex | Lists separate rows for Female and Male, followed by a row for Total Females and Total Males.
Alphanumeric, 10 characters |
Identities > Identity Information > Protected Identity Information >Legal Sex
Identities.legalGender
Identities.gender |
| Bound For |
Reports the student's Graduation Plan from the Diploma Type field assigned on the student's Graduation record when the value is set to GWC: Graduated with Certificate.
Alphanumeric, 30 characters |
Graduation > Post Grad Plans
Graduation.postGradPlans |
| American Indian | Reports a count of students who have a Race/Ethnicity of I: American Indian or Alaska Native and who graduated with a Diploma Type of GWC: Graduated with Certificate.
Numeric, 3 digits |
Identities > Identity Information > Race/Ethnicity > Race Ethnicity > I: American Indian or Alaska Native
Identity.raceEthnicity Graduation > Diploma Type > GWC: Graduated with Certificate Graduation.diplomaType |
| Asian | Reports a count of students who have a Race/Ethnicity of A: Asian and who graduated with a Diploma Type of GWC: Graduated with Certificate.
Numeric, 3 digits |
Identities > Identity Information > Race/Ethnicity > Race Ethnicity > A: Asian
Identity.raceEthnicity Graduation > Diploma Type > GWC: Graduated with Certificate Graduation.diplomaType |
| Black | Reports a count of students who have a Race/Ethnicity of B: Black or African American and who graduated with a Diploma Type of GWC: Graduated with Certificate.
Numeric, 3 digits |
Identities > Identity Information > Race/Ethnicity > Race Ethnicity > B: Black or African American
Identity.raceEthnicity Graduation > Diploma Type > GWC: Graduated with Certificate Graduation.diplomaType |
| White | Reports a count of students who have a Race/Ethnicity of W: White and who graduated with a Diploma Type of GWC: Graduated with Certificate.
Numeric, 3 digits |
Identities > Identity Information > Race/Ethnicity > Race Ethnicity > W: White
Identity.raceEthnicity Graduation > Diploma Type > GWC: Graduated with Certificate Graduation.diplomaType |
| Native Hawaiian or Other Pacific Islander | Reports a count of students who have a Race/Ethnicity of P: Native Hawaiian or Other Pacific Islander and who graduated with a Diploma Type of GWC: Graduated with Certificate.
Numeric, 3 digits |
Identities > Identity Information > Race/Ethnicity > Race Ethnicity > P: Native Hawaiian or Other Pacific Islander
Identity.raceEthnicity Graduation > Diploma Type > GWC: Graduated with Certificate Graduation.diplomaType |
| Hispanic | Reports a count of students who have a Race/Ethnicity of H: Hispanic or Latino Ethnicity and who graduated with a Diploma Type of GWC: Graduated with Certificate.
Numeric, 3 digits |
Identities > Identity Information > Race/Ethnicity > Race Ethnicity > H: Hispanic or Latino Ethnicity
Identity.raceEthnicity Graduation > Diploma Type > GWC: Graduated with Certificate Graduation.diplomaType |
| Two or More | Reports a count of students who have a Race/Ethnicity of M: Two or More Races and who graduated with a Diploma Type of GWC: Graduated with Certificate.
Numeric, 3 digits |
Identities > Identity Information > Race/Ethnicity > Race Ethnicity > M: Two or More Races
Identity.raceEthnicity Graduation > Diploma Type > GWC: Graduated with Certificate Graduation.diplomaType |
| TOTAL | Reports separate counts for the following:
|
Calculation, data not stored |
| Total Females | Count of female students across all race/ethnicities who graduated with a certificate. | Calculation, data not stored |
| Total Males | Count of male students across all race/ethnicities who graduated with a certificate. | Calculation, data not stored |
| LEA Total | Count of both male and female students per school across all race/ethnicities who graduated with a certificate. | Calculation, data not stored |
Diplomas by Post Graduate Intention
This report provides a list of students who graduated with a Diploma. It includes student demographic data, course of study, and what the student is planning to do post-graduation (college, work, etc.).
The following fields on the student's Graduation record are required:
- Post Grad Plans MUST be populated with any of the available options.
- Diploma Type must be set to FRC: Future Ready Core.
| Data Element | Description | Location |
|---|---|---|
| School Number | Reports the School Number assigned to the student's School of Enrollment.
Numeric, 6 digits |
School Information > State School Number
School.number |
| School Name | Reports the name of the school in which the student is enrolled.
Alphanumeric, 30 characters |
School Information > School Detail > School Name
School.name |
| Sex | Lists separate rows for Female and Male, followed by a row for Total Females and Total Males.
Alphanumeric, 10 characters |
Identities > Identity Information > Protected Identity Information >Legal Sex
Identities.legalGender
Identities.gender |
| Bound For |
Reports the student's Graduation Plan from the Diploma Type field assigned on the student's Graduation record when the value is set to FRC: Future Ready Core.
Alphanumeric, 30 characters |
Graduation > Post Grad Plans
Graduation.postGradPlans |
| American Indian | Reports a count of students who have a Race/Ethnicity of I: American Indian or Alaska Native and who graduated with a Diploma Type of FRC: Future Ready Core.
Numeric, 3 digits |
Identities > Identity Information > Race/Ethnicity > Race Ethnicity > I: American Indian or Alaska Native
Identity.raceEthnicity Graduation > Diploma Type > FRC: Future Ready Core. Graduation.diplomaType |
| Asian | Reports a count of students who have a Race/Ethnicity of A: Asian and who graduated with a Diploma Type of FRC: Future Ready Core.
Numeric, 3 digits |
Identities > Identity Information > Race/Ethnicity > Race Ethnicity > A: Asian
Identity.raceEthnicity Graduation > Diploma Type > FRC: Future Ready Core Graduation.diplomaType |
| Black | Reports a count of students who have a Race/Ethnicity of B: Black or African American and who graduated with a Diploma Type of FRC: Future Ready Core.
Numeric, 3 digits |
Identities > Identity Information > Race/Ethnicity > Race Ethnicity > B: Black or African American
Identity.raceEthnicity Graduation > Diploma Type > FRC: Future Ready Core Graduation.diplomaType |
| White | Reports a count of students who have a Race/Ethnicity of W: White and who graduated with a Diploma Type of FRC: Future Ready Core.
Numeric, 3 digits |
Identities > Identity Information > Race/Ethnicity > Race Ethnicity > W: White
Identity.raceEthnicity Graduation > Diploma Type > FRC: Future Ready Core Graduation.diplomaType |
| Native Hawaiian or Other Pacific Islander | Reports a count of students who have a Race/Ethnicity of P: Native Hawaiian or Other Pacific Islander and who graduated with a Diploma Type of FRC: Future Ready Core.
Numeric, 3 digits |
Identities > Identity Information > Race/Ethnicity > Race Ethnicity > P: Native Hawaiian or Other Pacific Islander
Identity.raceEthnicity Graduation > Diploma Type > FRC: Future Ready Core Graduation.diplomaType |
| Hispanic | Reports a count of students who have a Race/Ethnicity of H: Hispanic or Latino Ethnicity and who graduated with a Diploma Type of FRC: Future Ready Core.
Numeric, 3 digits |
Identities > Identity Information > Race/Ethnicity > Race Ethnicity > H: Hispanic or Latino Ethnicity
Identity.raceEthnicity Graduation > Diploma Type > FRC: Future Ready Core Graduation.diplomaType |
| Two or More | Reports a count of students who have a Race/Ethnicity of M: Two or More Races and who graduated with a Diploma Type of FRC: Future Ready Core.
Numeric, 3 digits |
Identities > Identity Information > Race/Ethnicity > Race Ethnicity > M: Two or More Races
Identity.raceEthnicity Graduation > Diploma Type > FRC: Future Ready Core Graduation.diplomaType |
| TOTAL | Reports separate counts for the following:
|
Calculation, data not stored |
| Total Females | Count of female students across all race/ethnicities who graduated with a certificate. | Calculation, data not stored |
| Total Males | Count of male students across all race/ethnicities who graduated with a certificate. | Calculation, data not stored |
| LEA Total | Count of both male and female students per school across all race/ethnicities who graduated with a certificate. | Calculation, data not stored |