Annual Report Data Import – Sites

This sheet is an extension of the projects sites sheet. This information will filter into project sites within a Project in the Projects and Activities module.
 

Template Name

Definition

Location in N-PEARS

Helpful Notes

 External Site id
Unique identifier for each site
 
Create any number that is unique to reference the site 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 site
Project and Activity Results > Project > Project sites > Site name
 
 Address
Street address of site
Project and Activity Results > Project > Project sites > Address
Can be left empty if this is a sensitive site. 
 City
City of site
Project and Activity Results > Project > Project sites > City
 
 State
State of site
Project and Activity Results > Project > Project sites > State
State Abbreviation must be capitalized.
 Zip
Zip code of site
Project and Activity Results > Project > Project sites > Zip
 
 Tribal_jurisdiction
Name of Tribal Organization
Project and Activity Results > Project > Project sites > Name of Tribal Organization
 
 Is_sensitive_site
This site is a sensitive site
Project and Activity Results > Project > Project sites > Is this a sensitive site?
Any site(s) that should remain confidential to protect the privacy of SNAP-Ed participants (e.g., shelters for survivors of domestic abuse), are a Sensitive Site. For sensitive sites, provide an alias for the name of the site and leave the address blank.
Enter 1 for Yes or 0 for No