Cindy

Column Name Definition Location in N-PEARS Helpful Notes external_story_id Unique numeric identifier for each story   Create any number that is unique to reference the Success Story.  NOTE: If you re-import the template for the same report, and reuse these identifiers, ensure the identifiers match the intended stories that were already imported. Any story with … Read more

Column Name Definition Location in N-PEARS Helpful Notes project Project name Project and Activity Results > Project Name If this does not exactly match projects in the system, it will create a new project. languages Language(s) used to deliver this program Project and Activity Results > Project > Indirect Education Channels > Languages Enter the … Read more

Column Name Definition Location in N-PEARS Helpful Notes project Project name  Project and Activity Results > Project Name This name must match the project name for this campaign in the Social Marketing sheet. If the project does not match exactly, it will create a new project. external_campaign_id Unique numeric identifier for each campaign   This … Read more

Column Name Definition Location in N-PEARS Helpful Notes project Project name  Project and Activity Results > Project Name This name must match the project name for this campaign in the Social Marketing sheet.  If the project does not match exactly, it will create a new project.  external_campaign_id Unique numeric identifier for each campaign   This … Read more

Column Name Definition Location in N-PEARS Helpful Notes project Project name  Project and Activity Results > Project Name If this does not exactly match projects in the system, it will create a new project.  external_campaign_id Unique numeric identifier for each campaign   Create any number that is unique to reference this campaign throughout the template. … Read more

This information will filter into Active Partners within a Project in the Projects and Activities module. Column Name Definition Location in N-PEARS Helpful Notes project Project name Project and Activity Results > Project Name If this does not exactly match projects in the system, it will create a new project.  partner_type Type of partner organization … Read more

Only Adopted PSE Changes can be imported into the system. To add or update Maintained PSE Changes, navigate to the PSE Changes Maintained section of National PEARS.  Each row in Excel represents one PSE Change. To report multiple PSE changes for a site, create a new row for each PSE Change. Column Name Definition Location … Read more

This information will filter into Direct Education within a Project in the Projects and Activities module. * denotes required field Column Name Definition  Location in N-PEARS Helpful Notes project Project name Project and Activity Results > Project Name If this does not exactly match projects in the system, it will create a new project.  method_in_person … Read more

This sheet continues the information for the project sites section within a Project in the Project and Activity Results module.  * denotes required fields Column Name Definition Location in N-PEARS Helpful Notes project * Project name Project and Activity Results > Project Name If this does not exactly match projects in the system, it will … Read more

In order to assist with data entry, N-PEARS offers the OPTIONAL ability to import data using an Excel template. This document explains each field in the Excel template and where that data is imported into the annual report.  The current version of the Import Template is 2.0. Click each link below to learn more. Sheets Within … Read more