Data Mart

The PEARS data mart is a read-only nightly copy of the entire set of PEARS data for your organization(s), transformed into a more readable and usable database schema. You can connect directly to your data mart database using tools like TablePlus (TablePlus | Modern, Native Tool for Database Management.) or MySQL Workbench (MySQL :: MySQL … Read more

PSE Site Activities

PSE site activities in PEARS feed into the PSE Change Initiatives section of Project and Activity Results in National PEARS. Logic Applied Records Included: Only records attached to the selected Reporting Year (i.e., 2023) Only records with the “SNAP-Ed” Program Area attached Only records that are marked as complete Records Excluded: Any record entered by Canopy staff or … Read more

Sites

Sites in PEARS feed into the Project Sites section of Project and Activity Results in National PEARS. Logic Applied Records Included: Any site linked to a Program Activity, PSE Site Activity, or Success Story meeting the logic criteria for those modules will be included. Field Mapping PEARS Field Location in PEARS N-PEARS Field Location in N-PEARS Calculation … Read more

Social Marketing Campaigns

Program activities in PEARS feed into the Social Marketing Campaigns section of Project and Activity Results in National PEARS. Logic Applied Records Included: Only records attached to the selected Reporting Year (i.e., 2023) Only records with the “SNAP-Ed” Program Area attached Only records that are marked as complete Records Excluded: Any record entered by Canopy staff or … Read more

Partnerships

Partnerships in PEARS feed into the PSE Change Initiatives section of Project and Activity Results in National PEARS. Logic Applied Records Included: Only records attached to the selected Reporting Year (i.e., 2023) Only records with the “SNAP-Ed” Program Area attached Only records that are marked as complete Only records that are attached to a PSE Site Activity as described … Read more

Mapping PEARS Data to N-PEARS

In order to assist with the transfer of data from PEARS to National PEARS (N-PEARS), the PEARS Team will be building a N-PEARS Annual Report Export from PEARS for importation into N-PEARS. Details about the new export will be forthcoming, but this documentation serves to detail out what data points from what records will map to … Read more

Program Activities

Program activities in PEARS generally feed into the Direct Education section of Project and Activity Results in National PEARS. Logic Applied Records Included: Only records attached to the selected Reporting Year (i.e., 2023) Only records with the “SNAP-Ed” Program Area attached Only records that are marked as complete Records Excluded: Any record entered by Canopy staff or … Read more

Success Stories

Success stories in PEARS feed into the Success Stories section in National PEARS. Logic Applied Records Included: Only records attached to the selected Reporting Year (i.e., 2023) Only records with the “SNAP-Ed” Program Area attached Only records that are marked as complete Records Excluded: Any record entered by Canopy staff or test users Additional Logic: Respect … Read more

Indirect Activities

Indirect activities in PEARS feed into the Indirect Education Channels section in National PEARS. Logic Applied Records Included: Only records attached to the selected Reporting Year (i.e., 2023) Only records with the “SNAP-Ed” Program Area attached Only records that are marked as complete Records Excluded: Any record entered by Canopy staff or test users Additional Logic: … Read more

Coalitions

Coalitions in PEARS feed into the Multisector Partnerships and Coalitions sub-section (in Coordination and Collaboration) of N-PEARS. Logic Applied Records Included: Only records attached to the selected Reporting Year (i.e., 2023) Only records with the “SNAP-Ed” Program Area attached Only records that are marked as complete Only records with at least 5 distinct sectors represented … Read more