The public list of events can be accessed using the following endpoint: https://test.pears.io/events/<org_slug>/events-api/ To use the endpoint replace org_slug with your organization’s public slug (contact PEARS support if you don’t know what it is). Pagination Results will be paginated with a default page size of 20. The following query parameters can be used to navigate the paginated … Read more
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 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 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 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 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 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 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 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