Data Mart: Setting up R

The PEARS data mart can be used in combination with R and RStudio as follows. Prerequisites Setup R can connect directly to the data mart using the RMariaDB library. Please follow these instructions carefully as the PEARS data mart requires a custom configuration file to support the required encryption. First, install the binary packages within … Read more

Data Mart Overview

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

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 has built a N-PEARS Annual Report Export from PEARS for importation into N-PEARS. This documentation serves to detail out what data points from what records will map to what data points in N-PEARS.  The current version of the … 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

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