Data Cleaning Checklist

Review this checklist before running the N-PEARS Export to ensure your PEARS data is ready.

Review each item below before running the N-PEARS Export to ensure your data imports correctly into N-PEARS.

1

Project Names

Project names in PEARS must exactly match the corresponding project names in N-PEARS. Mismatched names will cause N-PEARS to create new projects instead of matching to existing ones. Data Managers can update project names in bulk if needed.

Affected record types: Program Activities, PSE Site Activities, Social Marketing Campaigns, Indirect Activities, Success Stories

2

Mark Records as Complete

Only completed records are included in the N-PEARS Export. Review your data for any records still in draft status and mark them as complete before running the export. Data Managers can mark records complete in bulk once all required fields are filled.

3

Program Activity Session Length

Program Activities must have at least one session or module that is 20 minutes or longer to be included. Review session data for accuracy and correct any apparent data entry errors (e.g., sessions recorded as 1 minute).

4

Age Subcategories (5-17)

The 5-17 age subcategories (5-7, 8-10, 11-13, 14-17) are required for FY24 and later. If subcategory data is missing, the export will estimate by evenly distributing the 5-17 total across the four subcategories. For more accurate reporting, enter the actual subcategory counts before running the export.

5

PSE Reach and Implementation Stages

PSE changes require reach data (greater than 0) and an implementation stage of Started implementation of changes or higher to be included. Review PSE records to ensure reach is reported for all adopted changes.

6

PSE Partners

Both the PSE Site Activity and the associated Partnership record must be marked as complete for partnership data to be included in the export.

7

Coalition Sectors

Coalitions must have at least 5 distinct sectors represented among their members to be included. Review coalition membership to ensure sectors are assigned and that the minimum threshold is met.

8

Success Story Projects

A project must be selected on each Success Story in SNAP-Ed Custom Data. Stories without a project are excluded from the export.