Annual Report Data Import – Direct Education

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
This project was delivered in person
Project and Activity Results > Project > Direct Education > Mode of Delivery > In Person
Enter 1 for Yes or 0 for No
method_virtual_live_online
This project was delivered virtually live online
Project and Activity Results > Project > Direct Education > Mode of Delivery > Virtual, live online
Enter 1 for Yes or 0 for No
method_virtual_self_directed
This project was delivered virtually and was self-directed
Project and Activity Results > Project > Direct Education > Mode of Delivery > Virtual, self-directed, and interactive
Enter 1 for Yes or 0 for No
sessions_single
This project was delivered in a single session
Project and Activity Results > Project > Direct Education > Mode of Delivery > Single Session
Enter 1 for Yes or 0 for No
sessions_series_2_to_4
This project was delivered in a series of 2-4 sessions
Project and Activity Results > Project > Direct Education > Mode of Delivery > Series of 2-4 sessions
Enter 1 for Yes or 0 for No
sessions_series_5_to_9
This project was delivered in a series of 5-9 sessions
Project and Activity Results > Project > Direct Education > Mode of Delivery > Series of 5-9 sessions
Enter 1 for Yes or 0 for No
sessions_series_10_plus
This project was delivered in a series of 10 or more sessions
Project and Activity Results > Project > Direct Education > Mode of Delivery > Series of 10 or more sessions
Enter 1 for Yes or 0 for No
sessions_num_in_person
Number of sessions delivered in person
Project and Activity Results > Project > Direct Education > Mode of Delivery > Total in person sessions delivered
 
sessions_num_virtual
Number of sessions delivered virtually
Project and Activity Results > Project > Direct Education > Mode of Delivery > Total virtual sessions delivered
 
sessions_average_time_engaged
Average time engaged per session (minutes)
Project and Activity Results > Project > Direct Education > Mode of Delivery > What is the total estimated time participants engaged in the direct education series? If more than one direct education series was delivered, what is the average total series time?
 
languages
Languages used in project
Project and Activity Results > Project > Direct Education > Languages
Enter the key found in the languages section of the key mapping sheet.
Separate multiple languages with a comma.
languages_others
Other languages used in project
Project and Activity Results > Project > Direct Education > Languages > Other
 
reach_total
Total number of participants reached
Project and Activity Results > Project > Direct Education > Reach total
 
reach_gender_male_actual
Total actual count of participants reported gender as male
Project and Activity Results > Project > Direct Education > Reach: Gender > Actual count of Male participants
 
reach_gender_male_estimated
Total estimated count of participants reported gender as male
Project and Activity Results > Project > Direct Education > Reach: Gender > Estimated count of Male participants
 
reach_gender_female_actual
Total actual count of participants reported gender as female
Project and Activity Results > Project > Direct Education > Reach: Gender > Actual count of Female participants
 
reach_gender_female_estimated
Total estimated count of participants reported gender as female
Project and Activity Results > Project > Direct Education > Reach: Gender > Estimated count of Female participants
 
reach_gender_prefer_not_to_respond_actual
Total actual count of participants reported gender as prefer not to respond
Project and Activity Results > Project > Direct Education > Reach: Gender > Actual count of participants who prefer not to respond their gender
 
reach_gender_prefer_not_to_respond_estimated
Total estimated count of participants reported gender as prefer not to respond
Project and Activity Results > Project > Direct Education > Reach: Gender > Estimated count of participants who prefer not to respond their gender
 
reach_gender_unknown_actual
Total actual count of participants reported gender as unknown
Project and Activity Results > Project > Direct Education > Reach: Gender > Actual count of participants whose gender is unknown
 
reach_gender_unknown_estimated
Total estimated count of participants reported gender as unknown
Project and Activity Results > Project > Direct Education > Reach: Gender > Estimated count of participants whose gender is unknown
 
reach_age_under_5_actual
Total actual count of participants reported age under 5
Project and Activity Results > Project > Direct Education > Reach: Age > Actual count of participants who are under 5
 
reach_age_under_5_estimated
Total estimated count of participants reported age under 5
Project and Activity Results > Project > Direct Education > Reach: Age > Estimated count of participants who are under 5
reach_age_5_to_7_actual
Total actual count of participants reported age 5 to 7
Project and Activity Results > Project > Direct Education > Reach: Age > Actual count of participants who are between 5 and 7
 
reach_age_5_to_7_estimated
Total estimated count of participants reported age 5 to 7
Project and Activity Results > Project > Direct Education > Reach: Age > Estimated count of participants who are between 5 and 7
 
reach_age_8_to_10_actual
Total actual count of participants reported age 8 to 10
Project and Activity Results > Project > Direct Education > Reach: Age > Actual count of participants who are between 8 and 10
 
reach_age_8_to_10_estimated
Total estimated count of participants reported age 8 to 10
Project and Activity Results > Project > Direct Education > Reach: Age > Estimated count of participants who are between 8 and 10
 
reach_age_11_to_13_actual
Total actual count of participants reported age 11 to 13
Project and Activity Results > Project > Direct Education > Reach: Age > Actual count of participants who are between 11 and 13
 
reach_age_11_to_13_estimated
Total estimated count of participants reported age 11 to 13
Project and Activity Results > Project > Direct Education > Reach: Age > Estimated count of participants who are between 11 and 13
 
reach_age_14_to_17_actual
Total actual count of participants reported age 14 to 17
Project and Activity Results > Project > Direct Education > Reach: Age > Actual count of participants who are between 14 and 17
 
reach_age_14_to_17_estimated
Total estimated count of participants reported age 14 to 17
Project and Activity Results > Project > Direct Education > Reach: Age > Estimated count of participants who are between 14 and 17
 
reach_age_18_to_59_actual
Total actual count of participants reported age 18 to 59
Project and Activity Results > Project > Direct Education > Reach: Age > Actual count of participants who are between 18 and 59
 
reach_age_18_to_59_estimated
Total estimated count of participants reported age 18 to 59
Project and Activity Results > Project > Direct Education > Reach: Age > Estimated count of participants who are between 18 and 59
 
reach_age_60_to_75_actual
Total actual count of participants reported age 60 to 75
Project and Activity Results > Project > Direct Education > Reach: Age > Actual count of participants who are between 60 and 79
 
reach_age_60_to_75_estimated
Total estimated count of participants reported age 60 to 75
Project and Activity Results > Project > Direct Education > Reach: Age > Estimated count of participants who are between 60 and 79
 
reach_age_over_75_actual
Total actual count of participants reported age over 75
Project and Activity Results > Project > Direct Education > Reach: Age > Actual count of participants who are older than 75
 
reach_age_over_75_estimated
Total estimated count of participants reported age over 75
Project and Activity Results > Project > Direct Education > Reach: Age > Estimated count of participants who are older than 75
 
reach_age_unknown_actual
Total actual count of participants reported age unknown
Project and Activity Results > Project > Direct Education > Reach: Age > Actual count of participants whose age is unknown
 
reach_age_unknown_estimated
Total estimated count of participants reported age unknown
Project and Activity Results > Project > Direct Education > Reach: Age > Estimated count of participants whose age is unknown
 
reach_ethnicity_hispanic_actual
Total actual count of participants reported ethnicity hispanic
Project and Activity Results > Project > Direct Education > Reach: Ethnicity > Actual count of SNAP-Ed participants who were Hispanic/Latino
 
reach_ethnicity_hispanic_estimated
Total estimated count of participants reported ethnicity hispanic
Project and Activity Results > Project > Direct Education > Reach: Ethnicity > Estimated count of SNAP-Ed participants who were Hispanic/Latino
 
reach_ethnicity_not_hispanic_actual
Total actual count of participants reported ethnicity not hispanic
Project and Activity Results > Project > Direct Education > Reach: Ethnicity > Actual count of SNAP-Ed participants who were not Hispanic/Latino
 
reach_ethnicity_not_hispanic_estimated
Total estimated count of participants reported ethnicity not hispanic
Project and Activity Results > Project > Direct Education > Reach: Ethnicity > Estimated count of SNAP-Ed participants who not were Hispanic/Latino
 
reach_ethnicity_prefer_not_to_respond_actual
Total actual count of participants reported ethnicity prefer not to respond
Project and Activity Results > Project > Direct Education > Reach: Ethnicity > Actual count of SNAP-Ed participants who preferred to not report their ethnicity
 
reach_ethnicity_prefer_not_to_respond_estimated
Total estimated count of participants reported ethnicity prefer not to respond
Project and Activity Results > Project > Direct Education > Reach: Ethnicity > Estimated count of SNAP-Ed participants who preferred to not report their ethnicity
 
reach_ethnicity_unknown_actual
Total actual count of participants reported ethnicity unknown
Project and Activity Results > Project > Direct Education > Reach: Ethnicity > Actual count of SNAP-Ed participants whose ethnicity is unknown
 
reach_ethnicity_unknown_estimated
Total estimated count of participants reported ethnicity unknown
Project and Activity Results > Project > Direct Education > Reach: Ethnicity > Estimated count of SNAP-Ed participants whose ethnicity is unknown
 
reach_race_amerind_actual
Total actual count of participants reported race as American Indian or Alaska Native
Project and Activity Results > Project > Direct Education > Reach: Race > Actual count of SNAP-Ed participants whose race is American Indian or Alaska Native
 
reach_race_amerind_estimated
Total estimated count of participants reported race as American Indian or Alaska Native
Project and Activity Results > Project > Direct Education > Reach: Race > Estimated count of SNAP-Ed participants whose race is American Indian or Alaska Native
 
reach_race_asian_actual
Total actual count of participants reported race as asian
Project and Activity Results > Project > Direct Education > Reach: Race > Actual count of SNAP-Ed participants whose race is Asian
 
reach_race_asian_estimated
Total estimated count of participants reported race as asian
Project and Activity Results > Project > Direct Education > Reach: Race > Estimated count of SNAP-Ed participants whose race is Asian
 
reach_race_black_actual
Total actual count of participants reported race as black
Project and Activity Results > Project > Direct Education > Reach: Race > Actual count of SNAP-Ed participants whose race is Black
 
reach_race_black_estimated
Total estimated count of participants reported race as black
Project and Activity Results > Project > Direct Education > Reach: Race > Estimated count of SNAP-Ed participants whose race is Black
 
reach_race_hawpac_actual
Total actual count of participants reported race as Native Hawaiian or Other Pacific Islander
Project and Activity Results > Project > Direct Education > Reach: Race > Actual count of SNAP-Ed participants whose race is Native Hawaiian or Other Pacific Islander
 
reach_race_hawpac_estimated
Total estimated count of participants reported race as Native Hawaiian or Other Pacific Islander
Project and Activity Results > Project > Direct Education > Reach: Race > Estimated count of SNAP-Ed participants whose race is Native Hawaiian or Other Pacific Islander
 
reach_race_white_actual
Total actual count of participants reported race as white
Project and Activity Results > Project > Direct Education > Reach: Race > Actual count of SNAP-Ed participants whose race is White
 
reach_race_white_estimated
Total estimated count of participants reported race as white
Project and Activity Results > Project > Direct Education > Reach: Race > Estimated count of SNAP-Ed participants whose race is White
 
reach_race_prefer_not_to_respond_actual
Total actual count of participants reported race as prefer not to respond
Project and Activity Results > Project > Direct Education > Reach: Race > Actual count of SNAP-Ed participants who preferred to not respond with their race.
 
reach_race_prefer_not_to_respond_estimated
Total estimated count of participants reported race as prefer not to respond
Project and Activity Results > Project > Direct Education > Reach: Race > Estimated count of SNAP-Ed participants who preferred to not respond with their race.
 
reach_race_unknown_actual
Total actual count of participants reported race as unknown
Project and Activity Results > Project > Direct Education > Reach: Race > Actual count of SNAP-Ed participants whose race is unknown
 
reach_race_unknown_estimated
Total estimated count of participants reported race as unknown
Project and Activity Results > Project > Direct Education > Reach: Race > Estimated count of SNAP-Ed participants whose race is unknown
 

Languages

Key

Language

amharicAmharic
arabicArabic
armenianArmenian
cantoneseCantonese
chinese-simplifiedChinese (simplified)
chinese-traditionalChinese (traditional)
creoleCreole
englishEnglish
farsiFarsi
hindiHindi
hmongHmong
khmerKhmer
koreanKorean
laotianLaotian
mandarinMandarin
polishPolish
portuguesePortuguese
russianRussian
serbo-croatianSerbo-Croatian
somaliSomali
spanishSpanish
thaiThai
urduUrdu
vietnameseVietnamese