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
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
In order to assist with the transfer of data from PEARS to National PEARS (N-PEARS), the PEARS Team has built an N-PEARS Annual Report Export from PEARS for importation into N-PEARS. The current version of the N-PEARS export is 2.0. Known Issues: None at this time. Record Types Included This documentation serves to detail out … Read more
Partnerships in PEARS feed into the PSE Change Initiatives section of Project and Activity Results in National PEARS. A video walkthrough of this mapping document is provided here: 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 … Read more
Program activities in PEARS feed into the Social Marketing Campaigns section of Project and Activity Results in National PEARS. A video walkthrough of this mapping document is provided here: 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 … Read more
Sites in PEARS feed into the Project Sites section of Project and Activity Results in National PEARS. A video walkthrough of this mapping document is provided here: 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 … Read more
PSE site activities in PEARS feed into the PSE Change Initiatives section of Project and Activity Results in National PEARS. A video walkthrough of this mapping document is provided here: 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 … Read more
Coalitions in PEARS feed into the Multisector Partnerships and Coalitions sub-section (in Coordination and Collaboration) of N-PEARS. A video walkthrough of this mapping document is provided here 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 … Read more
Indirect activities in PEARS feed into the Indirect Education Channels section in National PEARS. A video walkthrough of this mapping document is provided here: 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 … Read more
Success stories in PEARS feed into the Success Stories section in National PEARS. A video walkthrough of this mapping document is provided here: 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 a … Read more