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 create a new project. |
external_site_id * | Unique numeric identifier for each site | This number should be the same unique number you used to reference this site in the sites sheet | |
intervention_approaches * | Intervention approaches | Project and Activity Results > Project > Project sites >Intervention approaches | These values will need to match the keys indicated in the intervention_approaches section of the Key Mapping sheet. |
settings | Settings | Project and Activity Results > Project > Project sites > Settings | These values will need to match the keys indicated in the settings section of the Key Mapping sheet. |
settings_eat_other | Other eating settings | Project and Activity Results > Project > Project sites > eat other | You must enter eat-other into the settings field before using this field. |
settings_learn_other | Other learning settings | Project and Activity Results > Project > Project sites > learn other | You must enter learn-other into the settings field before using this field. |
settings_live_other | Other living settings | Project and Activity Results > Project > Project sites > live other | You must enter live-other into the settings field before using this field. |
settings_play_other | Other play settings | Project and Activity Results > Project > Project sites > play other | You must enter play-other into the settings field before using this field. |
settings_shop_other | Other shopping settings | Project and Activity Results > Project > Project sites > shop other | You must enter shop-other into the settings field before using this field. |
settings_work_other | Other working settings | Project and Activity Results > Project > Project sites > work other | You must enter work-other into the settings field before using this field. |
Intervention Approaches
Key |
Intervention Approach |
| direct-education | Direct Education |
| pse-planned | PSE (planned and prepared for implementation) |
| pse-adopted | PSE (adopted changes) |
| pse-maintained | PSE (maintained changes) |
| pse-conducted | PSE (conducted follow up assessments, evaluation, and/or monitoring) |
| social-marketing | Social Marketing |
Settings
Key | Setting |
| adult-education-work | Adult education, job training and work (e.g, SNAP E&T), TANF, and veteran services sites |
| before-after-school-program | Before- and afterschool programs |
| emergency-shelter-temp-housing | Emergency shelters and temporary housing sites |
| congregate-meal-sites | Congregate meal sites/senior nutrition centers |
| farmers-market | Farmers’ markets |
| bicycle-walking-path | Bicycle and walking paths |
| faith-based-center | Faith-based centers/places of worship |
| fast-food-chains | Fast-food chains |
| military-base | Military bases |
| early-care-and-education | Early care and education facilities (includes childcare centers, daycare homes, Head Start, preschool, and prekindergarten programs) |
| food-assistance | Food assistance sites (e.g, food banks, food pantries food shelves) |
| community-recreation-centers | Community and recreation centers |
| mobile-vending | Mobile vending/food trucks |
| snap-office | SNAP offices |
| gardens | Gardens (community/school) |
| group-living | Group living arrangements/homes |
| extension-office | Extension offices |
| food-distribution | Food distribution sites (e.g, FDPIR, TEFAP, CSFP) |
| family-resource-center | Family resource centers |
| restaurants | Restaurants |
| healthcare-clinic-hospital | Healthcare clinics and hospitals |
| parks-open-spaces | Parks and open spaces |
| large-food-store | Large food stores and retailers (four or more registers) |
| worksite-low-wage | Worksites with low-wage workers |
| libraries | Libraries |
| work-other | Other |
| small-food-store | Small food stores (up to three registers) |
| soup-kitchens | Soup kitchens |
| senior-centers | Senior centers |
| indian-reservations | Indian Reservations |
| mobile-education-site | Mobile education sites |
| state-county-fairground | State/county fairground |
| usda-summer-meal-sites | USDA Summer Meal sites |
| shop-other | Other |
| individual-homes | Individual homes |
| public-housing | Public housing sites (includes public housing for seniors and disabled individuals) |
| play-other | Other |
| college-and-university | Schools (colleges and universities) |
| eat-other | Other |
| residential-treatment-center | Residential treatment centers |
| k-12-school | Schools (K-12, elementary, middle, and high) |
| wic-clinics | WIC clinics |
| live-other | Other |
| learn-other | Other |