Data Cleaning Tool – Registration

Periodically, the table where all the registration data is housed needs to be reviewed and cleaned to both (1) make sure the Site Name is correct, and (2) to input the associated Site ID (found in the Site Table). Use the instructions linked below to manage cleaning site names in the registration table. Scroll down further to use the cross-checker tool to look up site IDs in the Site Table.

DATA CLEANING INSTRUCTIONS site cleaning registration table.docx

Cross-Check with Site Table:

To see if the site entered exists, search for it in the site table. If it doesn’t yet exist in the site table, Add New Site here (opens in a new tab).