Summary
Use the DR08 - Expulsion Audits worksheet in the (NC) Dropout Data Collection report to review expulsion evidence, enrollment history, and related Dropout records.
The audit may identify a missing or inconsistent record or a situation where the school or PSU must review the available information before deciding which Dropout Reason applies. The EXPL actions in this worksheet concern the Dropout Reason, not the Exemption Code.
Purpose
Expulsion Audits identifies conditions involving expulsion evidence and Dropout records. It checks for:
- Expulsion evidence when the student has no qualifying reporting year enrollment
- Expulsion evidence and a CCAHS condition that require school or PSU review
- A missing active EXPL Dropout record when the audit identifies one to add
- An active Dropout record whose reason may need to be updated to EXPL
- An EXPL Dropout Reason without matching expulsion evidence at the PSU and school that own the record.
Severity
Warning
What to Review
Run the (NC) Dropout Data Collection report and open the DR08 - Expulsion Audits worksheet in Excel output. Review the Issue Code, owning PSU and school, student enrollment history, and related Dropout record.
| Issue Code | What the result indicates |
|---|---|
| EXPULSION_WITHOUT_PRIOR_ENROLLMENT | Expulsion evidence is present, but the audit does not find qualifying reporting year enrollment to establish the student's Prior Enrollment Type. The report directs the user to review enrollment history. |
| CCASH_EXPL_REVIEW | CCAHS conditions and expulsion evidence are both present. The audit does not choose between CCASH and EXPL; the school or PSU must review the record. |
| ADD_DROPOUT_RECORD_EXPL | The audit identifies evidence at the reporting school and does not find an active EXPL Dropout record for the reporting context. |
| UPDATE_DROPOUT_REASON_EXPL | An active Dropout record is present with expulsion evidence, but its current Dropout Reason is not EXPL. |
| EXPL_REEASON_WITHOUT_EXPULSION | The Dropout record has the EXPL reason, but the audit does not find matching expulsion evidence at the PSU and school that own the record. |
Report Content
The worksheet includes student, ownership, enrollment, Dropout record, and issue information. The owning PSU and school fields identify where the result should be reviewed. For EXPL_REASON_WITHOUT_EXPULSION, the evidence check is limited to the PSU and school that own the Dropout record.
| 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. |
| cleanupType | Identifies the edit check group. For this worksheet, the value is EXPULSION. |
| issueCode | Identifies the expulsion condition. See the issue descriptions above. |
| owningPSUCode, owningPSUName | PSU responsible for reviewing the result. |
| owningSchoolCode, owningSchoolName | School responsible for reviewing the result. |
| lastEnrollmentYear | Most recent enrollment year available for the student; use as research context. This may be blank when the audit cannot establish an enrollment context. |
| priorEnrollmentType, priorEnrollmentExitCode | Prior enrollment type and exit code, when available. These may be blank when there is no qualifying enrollment context. |
| recordDropoutYear, dropoutType | Dropout record year and type or reason, when available. These may be blank when the result concerns a record that may need to be added. |
| subsequentEnrollmentPeriod | Subsequent enrollment period, when applicable. This field is generally blank for DR08 results. |
| currentValue | Describes the condition found, such as expulsion evidence without prior enrollment, the current Dropout Reason, or the absence of an active EXPL record. |
| expectedValue | Describes the condition or review indicated by the audit, such as reviewing enrollment history, reviewing whether CCAHS or EXPL applies, or adding/updating the Dropout Reason to EXPL. |
| suggestedDate | Suggested date, when provided. This field is generally blank for DR08 results. |
| evidencePSUCode, evidencePSUName | PSU associated with evidence, when applicable. These fields are generally blank for DR08 results. |
| evidenceSchoolCode, evidenceSchoolName | School associated with evidence, when applicable. These fields are generally blank for DR08 results. |
| evidenceStartDate, evidenceEndDate | Evidence dates, when applicable. These fields are generally left blank for DR08 results. |
Recommended Action (need to expand and add screenshots)
- Review the results and identify the Issue Code.
- Locate the related enrollment records, expulsion information, and Dropout records in NCSIS.
- Confirm that the enrollment history and expulsion information match the student and reporting context shown in the result.
- For EXPULSION_WITHOUT_PRIOR_ENROLLMENT, review the enrollment history before determining whether a Dropout record is appropriate. Do not add an EXPL record automatically based on this result.
- For CCAHS_EXPL_REVIEW, review the student's CCAHS and expulsion information together. The audit does not select the final Dropout Reason. Consult the Dropout Data Manual to determine the appropriate reporting treatment.
- For ADD_DROPOUT_RECORD_EXPL or UPDATE_DROPOUT_REASON_EXPL, verify the expulsion information and related Dropout record before adding a record or changing the Dropout Reason.
- For EXPL_REASON_WITHOUT_EXPULSION, confirm whether matching expulsion information exists in the PSU and school that own the Dropout record. If it does not, review whether the information is incomplete or the Dropout Reason needs correction.
- Correct the source data when the review confirms that the information is inaccurate.
- Rerun the report after the nightly refresh and review the updated result.
Use the Dropout Data Manual to confirm reporting treatment and whether EXPL applies. The audit identifies a condition to review; it does not replace the policy determination.
NEXT: Continue to Verify Reported Dropout Detail. Return to Dropout Edit Checks. Return to Dropout Reporting.
