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.
* denotes required field

Column 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 *optional if sensitive site selected
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