When the Annual Report launched in 2024, maintained PSE changes could only be updated manually. However, now the system supports importing maintained PSE Changes similarly to importing adopted changes. The following article details how to use the data importer to add or update your PSE Changes Maintained. To jump to a specific section, click one … Read more
Overview National PEARS offers a data importer to ease data entry. When an error prevents the document from importing, the system will provide a variety of notifications to assist with completion of the document. Clicking Download file with errors will download a spreadsheet that notates the issues preventing the importer from completing. Hovering over the red … Read more
Column Name Definition Location in N-PEARS Helpful Notes external_coalition_id Unique numeric identifier for each coalition Create any number that is unique to reference the Coalition throughout the template. It does not matter what number you use, as long as it is not already used in this sheet. name Name of the coalition Coordination and … Read more
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