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

Download a Summary Export

The Summary Export provides a high level compilation of data across most PEARS modules. Unlike other Exports in PEARS, not all related data points are included. Instead, the Summary Export provides key data points and links to records for further review. Review the instructions below for information on downloading and reviewing a Summary Export. Download … Read more

Collaborators

The following article outlines how to use the Collaborators section that is found within most PEARS modules. More information is provided in each section below. To jump to a specific section, click a link from the following list: Overview Add a Collaborator Edit a Collaborator Delete a Collaborator View Collaborator Data Overview In the Collaborators … Read more

Export Data

Under the Analyze menu, exports for each module are listed. Exports allows users to download data from PEARS into an Excel spreadsheet. Users can export data from records they have entered (or records they have access to view) into an Excel spreadsheet where they can perform additional analysis. Once the data is exported, users can … Read more

Export Survey Responses by Survey

Under the Analyze menu, exports for each module and for survey data are listed. Exports allows users to download data from PEARS into an Excel spreadsheet. Three types of survey exports are available in PEARS: Responses by Survey, Responses by Question, and Responses by Matched ID. Users can export data from surveys they have entered … Read more

Export Survey Responses by Question

Under the Analyze menu, exports for each module and for survey data are listed. Exports allows users to download data from PEARS into an Excel spreadsheet. Three types of survey exports are available in PEARS: Responses by Survey, Responses by Question, and Responses by Matched ID. Users can export data from surveys they have entered … Read more

Export Survey Responses by Matched ID

Under the Analyze menu, exports for each module and for survey data are listed. Exports allows users to download data from PEARS into an Excel spreadsheet. Three types of survey exports are available in PEARS: Responses by Survey, Responses by Question, and Responses by Matched ID. Users can export data from surveys they have entered … Read more

Export Site Data

Programming Managers and Organization Administrators can use the Manage Sites page to add, edit, merge, or delete sites. Staff with these roles can also mark sites inactive and export site data. Exporting site data allows you to review site details in bulk. The following article provides more information on exporting site data from PEARS. To jump … Read more

Export User Account Data

User Managers and Organization Administrators can use the Manage Users page to add, edit, or deactivate user accounts. Staff with these roles can also export user account data. Exporting user data allows you to check user account details and permissions in bulk. The following article provides more information on exporting user data from PEARS. To jump … Read more

COVID-19 Impact

The COVID-19 Impact field was created in April 2020 to help organizations track the impact of the novel coronavirus on planning programs and delivering activities. This field is optional and can be added or removed as needed. The following article outlines how to add the COVID-19 field for data entry, defines the drop-down options listed … Read more