Rep9o
Summary
Use DR01 - Reported Dropout Detail worksheet in the (NC) Dropout Data Collection report to review the potential Dropout records identified as reportable for the reporting year.
Each row represents a Dropout record included in the current reported population. A student may have more than one row. Review multiple rows for a student together, especially when the Record Edit Checks worksheet also identifies multiple qualifying or reportable records.
Purpose
Reported Dropout Detail provides student level detail for records the current data load identifies as reportable. Use it to verify the student, Dropout record, and reporting context before reviewing the Dropout Summary.
Severity
Information
What to Review
Run the (NC) Dropout Data Collection report and open the DR01 - Reported Dropout Detail worksheet in Excel output.
For each row:
- Confirm the reporting year and student identifier.
- Compare the Dropout record's dates, year, grade, reason, and exemption with the source record in NCSIS.
- Compare the Dropout record's PSU and school with the reporting PSU, school, and grade.
- Review the enrollment context fields, including the applicable Day 20 and the last entry and exit information.
- If a value appears unexpected, review the related Edit Checks worksheet and correction article before changing source data.
Reported Dropout Detail contains records classified as reportable by the current data load. It does not display every Dropout record considered during validation or include a separate "will be reported" indicator.
Report Content
| Column | How to use it |
|---|---|
| ReportEndYear | Identifies the reporting year covered by the result. |
| studentUID | Student identifier for matching the result to NCSIS records. |
| lastName, firstName | Student name. |
| sex, raceEthnicity | Student demographic values included in the report output. |
| lastEnrollmentYear | Most recent enrollment year available for the student. |
| priorEnrollmentType | Prior enrollment classification used in the reporting context. |
| dropoutPSUCode, dropoutPSUName | PSU associated with the Dropout record. |
| dropoutSchoolCode, dropoutSchoolName | School associated with the Dropout record. |
| recordGrade | Grade value on the Dropout record. |
| recordDropoutYear | Dropout Year value on the Dropout record. |
| recordStartDate, recordEndDate | Start and end dates on the Dropout record. A blank end date indicates that the record has no end date in the report output. |
| dropoutReason | Dropout Reason value on the record. Refer to the current Dropout Data Manual for policy guidance on the appropriate reason. |
| exemptionCode | Exemption Code value on the record. Refer to the current Dropout Data Manual for policy guidance on the appropriate exemption. |
| dropoutType | Reporting classification derived from the Dropout Reason or Prior Enrollment Type, when applicable. |
| reportingPSUCode, reportingPSUName | PSU associated with the student's reporting context. Compare with the Dropout PSU fields. |
| reportingSchoolCode, reportingSchoolName | School associated with the student's reporting context. Compare the Dropout School fields. |
| reportingGrade | Grade associated with the student's reporting context. Compare with recordGrade. |
| reportingStateGrade | State grade value associated with the reporting context. |
| lastEntryDate | Entry date for the student's last enrollment record used in the reporting context. |
| lastExitDate | Exit date for the student's last enrollment record used in the reporting context. |
| priorEnrollmentExitCode | Exit code associated with the prior enrollment context. Review it with the related entry and exit dates and source enrollment record. |
| applicable20thDay | Applicable Day 20 date used by the report logic for the student's reporting context. |
Recommended Action (does this need expansion?)
- Review all rows for the reporting year and confirm the student identifiers and reporting context.
- Locate the corresponding Dropout and enrolment records in NCSIS.
- Compare the source values with the report's Dropout record fields and reporting context fields.
- If the Dropout PSU or school differs from the reporting PSU or school, review the related Enrollment Edit Checks results.
- If multiple rows appear for a student, review the Record Edit Checks results and compare each record before deciding whether a correction is needed.
- Use the current Dropout Data Manual for policy decisions about Dropout Reasons, Exemption Codes, and reporting treatment.
- Correct source data only when the review confirms that the information is inaccurate.
- Rerun the report after the nightly refresh and confirm the updated detail.
NEXT: Continue to Review the Dropout Summary. Return to Dropout Reporting.
