Student Data Cleanup Process

This article will walk you through the process of identifying and correcting enrollment records missing from the state, duplicate student records, and duplicate student IDs.

This article describes functionality only accessible for users using a version of Campus connected to a State Edition of Campus.

Identifying and Correcting Student Enrollment Records Missing at the State

The following steps will guide you in identifying and correcting missing student enrollment data:

Step 1. Verify and Review Enrollment Data

Tool Search: Verification Summary

The first step in identifying enrollment records missing at the state is to verify enrollment data using the Verification Summary tool. 

Select the Verify (or Re-Verify), select Enrollment, and select the Verify Selected Objects button to have Campus compare and verify enrollment data between the district and the state (Image 1).

screenshot of selecting the re-verify button

Image 1: Re-Verifying Enrollment Data

Before you can generate the Verification Summary Report, re-verification must first be completed. Processing time will depend on various factors, including bandwidth limitations, state-level settings, and pending requests. The Timestamp column of the Verification Results table will display a "(!)" after an existing date or an N/A value for the column of the requested verification while the process completes. You can hover your mouse over each object timestamp to see its current status (Image 2).

screenshot of the verification result pending

Image 2: Identifying Verification Processing Status

Once verification is completed, select the Verification Summary Report button, select Enrollment, and click Generate Report (Image 3). Then, proceed to Step 2.

screenshot of running the verification summary report for the enrollment object

Image 3: Generating the Enrollment Verification Summary Report

Step 2. Identify/Correct Data and Resync Specific Enrollment Records

Tool Search: Enrollments, Resync State Data - Selective Sync

Review the Enrollment Verification Report and identify which student records are missing at the state and must be corrected/resynced.

Image 4: Identifying District Enrollment IDs

Once data for identified students has been corrected, their enrollment records must be resynced via the Selective Sync tool (Image 5).

screenshot of resyncing select enrollment records

Image 5: Resyncing Specific District Enrollment IDs

To resync specific enrollment records (see Image 3):

  1. Go to the Resync State Data tool (System Administration > Data Utilities > Resync State Data).
  2. Select the Selective Sync tab.
  3. Select the Enrollment object.
  4. Enter each identified student's District Enrollment ID number. The District Enrollment ID column of the Enrollment Verification Summary Report will list each number.
  5. Select the Sync button. Enrollment records matching the District Enrollment ID values entered will be synced from district to state.
  6. Review the Sync Request History report to see if the data is correctly synced to the state.

To see the sync progress and view which enrollments successfully or unsuccessfully synced, select the View History link found at the bottom of the editor (see Image 6).

screenshot of viewing resync progress

Image 6: Resyncing Specific District Enrollment IDs

Once the resync process has been completed, click the blue Complete hyperlink (Image 7). To generate a report displaying all records that successfully and unsuccessfully (re)synced for the event, click the blue Keys hyperlink (Image 7). 

If you see errors within the Sync Request History, contact Campus Support for additional assistance.

Image 7: Viewing the Sync Request History Report

Step 3. Re-verify and Review Enrollment Data

Tool Search: Verification Summary

Now that enrollment records have been identified, corrected, and resynced to the state, the Enrollment Verification Summary Report needs to be re-run to ensure the records are successfully synced to the state.

Select the Re-Verify button. Once verification is completed, select the Verification Summary Report button, select Enrollment and click Generate Report (Image 8). 

reverifying and viewing resynced enrollment data

Image 8: Re-verify Data and Review the Enrollment Verification Summary

Review the Enrollment Verification Summary Report, compare the old Verification Report to the new one, and see if student records were corrected.

Identifying and Correcting Duplicate Students

The following steps will guide you in identifying and correcting duplicate students:

Step 1. Identify Duplicate Students Using the Duplicate Student Search Report

Tool Search: Duplicate Students Search

The first step in identifying duplicate students is to generate and review the Duplicate Student Search Report (Image 9). 

Campus recommends marking all criteria boxes when first generating this report. Once students who match all criteria are identified, work backward, unmarking one criteria box and generating the report so that you see the full spectrum of potentially duplicate students.

screenshot of the duplicate student search tool

Image 9: Generating the Duplicate Students Search Report

Step 2. Correct Duplicate Information

Review the Duplicate Students Search Report and correct erroneous information for each identified student (Image 10). If students are identified as duplicates, move on to Step 3.

screenshot of a duplicate identity record

Image 10: Identifying and Correcting Duplicate Student Information

Step 3. Combine Duplicate Students

Tool Search: Combine Person

Students who appeared on the report because they are duplicates of another student with Campus should be combined using the Combine Person tool (Image 11). 

screenshot of combining duplicate people via the combine person tool

Image 11: Combining Duplicate Students via Combine Person Tool

Identifying and Correcting Duplicate Student ID Numbers

The following steps will guide you in identifying and correcting duplicate students ID numbers:

Step 1. Generate the Duplicate IDs Report

Tool Search: Duplicate IDs

The first step in identifying and correcting duplicate Student State ID and Local Student Numbers is to generate and analyze the Duplicate ID's Report (Image 12). 

Screenshot of the duplicate IDs tool

Image 12: Generating the Duplicate IDs Report

Step 2. Correct Duplicated Student ID Numbers

Tool Search: Duplicate IDs, Demographics

Review the Duplicate ID Report and determine whether the two people are duplicates or two separate people who need two separate State IDs.  

If Two People are Identified as Duplicates

If, after reviewing the report, it is determined that two people are duplicates of the same person, they should be combined via the Combine Person tool (Image 13). 

Image 13: Correcting Duplicate Student ID Data

If Two People are Identified as Separate People with Identical IDs

If, when reviewing the report, two people are identified as separate people with identical State IDs, you should contact Campus Support for additional assistance.