ABCDEFGHIJK
1
ObjectField LabelField ApiField TypePicklist ValuesDefault valueShould be Populated?NotesHelp/DefinitionEditableIntegration
2
ContactAccepts InvitationsHOC__Accepts_Invitations__cbooleanRECOMMENDEDThis field indicates whether or not a volunteer will accept invitations from Skilled Based Volunteer Searches. Yes
3
ContactBackground Check CompletedHOC__Background_Check_Completed__cbooleanRECOMMENDEDThis field is checked by the affiliate when an contact has completed their background check. No
4
ContactCourt Ordered VolunteerHOC__Court_Ordered_Volunteer__cbooleanRECOMMENDEDThis field is marked when a Contact is volunteering to complete court ordered service. No
5
ContactDisabled PersonHOC__Disabled_Person__cbooleanRECOMMENDEDIs marked when the contact has identified that they have a disability. Yes
6
ContactMinor Wavier on FileHOC__Minor_Wavier_on_File__cbooleanRECOMMENDEDThis field is checked when a minor waiver has been received. The data is recorded in the field "Minor Waiver Received Date."No
7
ContactOrientation CompletedHOC__Orientation_Completed__cbooleanRECOMMENDEDThis Checkbox is checked when a volunteer has completed an on-line or in-person orientation with the affiliate. No
8
ContactSkill Profile CompletedHOC__Skill_Profile_Completed__cbooleanRECOMMENDEDWhen checked it identifies that the Volunteer has completed their Skill Profile. Yes
9
ContactCalculated BirthdateHOC__Calculated_Birthdate__cbooleanOPTIONALOnly mark "true" if you entered a value in "Age"This checkbox is checked if the DOB has been calculated from data entered during team registration or when the contact was created by affiliate staff. Yes
12
ContactDate Minor Waiver ReceivedHOC__Date_Minor_Waiver_Received__cdateRECOMMENDEDFormat MM/DD/YYYYShows the date that the Minor Waiver was received by the affiliate. No
13
ContactOrientation Completed DateHOC__Orientation_Completed_Date__cdateRECOMMENDEDFormat MM/DD/YYYYThis field reflects the date that the orientation was completed by the volunteer.No
17
ContactLastModifiedDateSkillRatingHOC__LastModifiedDateSkillRating__cdatetimecurrent dateOPTIONALFormat MM/DD/YYYY HH:MM:SS Shows the date when the contact last updated their skills profile. Recommended if importing skills ratingNo
22
ContactAgeHOC__Age__cdoubleOPTIONALdo not populate if you provided the DoBThis field displays the individuals age. The age will be calculated from the DOB entered or as entered during team registration.No
23
ContactHours ServedHOC__Hours_Served__cdoubleOPTIONALThis is a rollup, calculated field and should not be editedDisplays the number of hours served by the contact across all recorded connections to volunteer opportunities. (Calculated field based on connections, can't be edited).No
25
Contact UsernameHOC__Username__cemailunique email addressHIGHLY RECOMMENDED -
MUST BE BLANK FOR 3.0 USERS
Us their e-mail address. Make sure that e-mail addresses are properly formatted. Every contact is given a UNIQUE username in order to be able to access the system. The Username is unique and is based on the e-mail provided during registration. Yes
26
ContactAlternate Email (sometimes renamed to Alternate Volunteer Email)HOC__Alternate_Email__cemailOPTIONAL - has no automation or function in HOC but can be used to track a secondary email addressMake sure that e-mail addresses are properly formatted. Volunteers are able to associate an alternative e-mail address with their account.Yes
27
ContactVolunteer TypeHOC__Volunteer_Type__cmultipicklistVolunteer; Volunteer Leader; Team Captain; Disaster Response; RSVP; National ServiceVolunteer (see note)OPTIONALAn optional field if you want to differentiate contacts used in HandsOn Connect from other contacts you may have populated in Salesforce.This field further defines the role the volunteer plays in your system.YES (as of 9/1/2016) No
28
ContactAvailabilityHOC__Availability__cmultipicklistSunday Morning; Sunday Afternoon; Sunday Evening; Monday Morning; Monday Afternoon; Monday Evening; Tuesday Morning; Tuesday Afternoon; Tuesday Evening; Wednesday Morning; Wednesday Afternoon; Wednesday Evening; Thursday Morning; Thursday Afternoon; Thursday Evening; Friday Morning; Friday Afternoon; Friday Evening; Saturday Morning; Saturday Afternoon; Saturday EveningRECOMMENDEDIndividuals are able to set the days & times that they are available to volunteer. These do not limit individuals from signing up for opportunities. Staff can run a report based on volunteer availability. This list can not be altered. DO NOT EDITYes
29
ContactCommunication PreferencesHOC__Communication_Preferences__cmultipicklistOpt in for Affiliate communications; Opt in for National communicationRECOMMENDEDThis field is completed during the volunteer registration process and identifies if the volunteer has selected to receive mail or e-mail communications from the local affiliate or from HandsOn Network. DO NOT EDITYes
30
ContactContact TypeHOC__Contact_Type__cmultipicklistEmployee; Chief Executive; Volunteer Coordinator; Other Contact; Board Member; Technology Contact; Donor; Fundraising ContactStaff - "Employee"RECOMMENDEDThis field is selected by staff to identify a contact as the type of contact from the list. YesNo
31
ContactInterestsHOC__Interests__cmultipicklistAdult Education; Animals; Arts & Culture; Children & Youth Education; Civic & Community; Disaster & Emergency Services; Environment; Faith-Based Service; Health & Wellness; Family Services; Hunger & Homelessness; International Service; Internships & Employment; Justice & Legal Services; Immigrant & Refugee Services; Schools; Senior Services; Sports & Recreation; Technology; OtherRECOMMENDEDVolunteers are able to identify their interests as part of their volunteer profile. This field identifies that interests that they have indicated. This list can not be altered. Yes (as of 9/1/2016)Yes
32
ContactTarget PopulationHOC__Target_Population__cmultipicklistAnimals; Families; Homeless; Immigrants, Refugees or Ethnic Groups; LGBT(Lesbian, Gay, Bisexual,Transgender); Low-income Communities; Military/Veterans; Offenders/Ex-offenders; People with Disabilities; People with Health-based Concerns; Visitors & Travelers; Other
"Other"RECOMMENDEDEvery Volunteer can indicate the population that they wish to serve in their profile. Their choice(s) are included in this field.Yes (as of 9/1/2016)Yes (as of 9/1/2016)
33
ContactVolunteer Activity TypeHOC__Volunteer_Activity_Type_National__cmultipicklistAdministrative Support/Clerical; Building/Construction; Caring for Animals; Caring for People; Cleaning; Collecting; Sorting & Packaging; Consulting & Professional Services; Counseling; Disaster Services; Event Organizing; Food Preparation & Meal Services; Fundraising & Campaigning; Gardening/Planting; Hotline/Information Center Support; Mentoring/Youth Development; Painting; Public Relations/Marketing; Sports & Recreation; Tutoring; Other"Other"RECOMMENDEDVolunteers are able to select from this list the types of activities that they are interested in performing.Yes (as of 9/1/2016)Yes
34
ContactGoods and ServicesHOC__Goods_and_Services__cmultipicklistMedia -TV; Media - Radio; Media - Newspaper; Food - Catering; Food - Coffee; Food - Special Event; Food - FeedingOPTIONALAffiliates can use this to identify goods and services that a business or organization can provide to the affiliate. The picklist can not be modified. YesYes
41
ContactPrimary PhoneHOC__Primary_Phoneno__cphoneOPTIONAL(Format (###) ###-####) Identifies what the Primary phone number is for the Contact. No
42
ContactPrimary Address?HOC__Primary_Address__cpicklistHome; BusinessHomeREQUIREDAllows Contacts to identify their primary address as either their Home or Business Address.DO NOT EDITNo
43
ContactPrimary Phone?HOC__Primary_Phone__cpicklistBusiness; Mobile; Home; OtherOtherREQUIREDIdentifies which phone number (Business, Mobile, Home, or Other) is the primary phone number for this contact. DO NOT EDITNo
44
ContactRegistration Status. (Sometimes renamed to Volunteer Registration Status)HOC__Registration_Status__cpicklistRegistered; Not Registered; Pending (Team Registration)HIGHLY RECOMMENDEDEvery contact is given a status to identify the status of their Registration. Public sign-ups (Registered), Admin Sign-ups (Not Registered), Team Invites (Pending (Team Registration). This list can not be altered. DO NOT EDITYes
45
ContactEducation LevelHOC__Education_Level__cpicklistSome high school; High school graduate; Some college; Technical/Associate degree; 4 year college degree; Graduate degree; OtherRECOMMENDEDIdentifies the education level as identified by the contact. Yes (as of 9/1/2016)Yes
46
ContactEmployment StatusHOC__Employment_Status__cpicklistFull Time; Part Time; Not Employed; Retired; OtherRECOMMENDEDIdentifies the employment status as identified by the contact. YesNo
47
ContactEthnicity/RaceHOC__Ethnicity_Race__cpicklistAfrican-American; Asian/Pacific Islander; Hispanic/Latino; Native American; White/Caucasian; Multi-Racial; OtherRECOMMENDEDIdentifies the ethnicity/race as identified by the contact. Yes (as of 9/1/2016)Yes
48
ContactGenderHOC__Gender__cpicklistMale; Female; UnknownRECOMMENDEDIdentifies the gender as identified by the contact. Yes (as of 9/1/2016)Yes
49
ContactHeard About Us?HOC__Heard_About_Us__cpicklistWebsite; Search Engine; Facebook; Family or Friend; Email/Newsletter; OtherRECOMMENDEDAllows volunteers to indicate how they heard about your volunteer centerYesNo
50
ContactMarital StatusHOC__Marital_Status__cpicklistSingle; Married; Partnered; Divorced; WidowedRECOMMENDEDIdentifies the marital status as indicated by the contact. Yes (as of 9/1/2016)Yes
51
ContactMax Distance for InvitationsHOC__Max_Distance_for_Invitations__cpicklistNational; Within 1 mile; Within 5 miles; Within 10 miles; Within 20 miles; Within 30 milesRECOMMENDEDDuring the registration process, volunteer are able to identify if they wish to receive invitations to projects and from how far out they will accept them. Values include: National, Within 1,5, 10, 20, or 30 miles. This list can not be altered. DO NOT EDITYes
54
ContactReferral SourceHOC__Referral_Source__cpicklistValues Reqd.OPTIONALIdentifies the source of the referral that recommended the Contact to register. YesNo
62
Contact IDVaries based on form of ID (Import ID, Record ID, HOC__Import_ID__c)stringREQUIREDThis is the unique ID used to associate updates with this organization and/or link this organization to other objects, such as Contacts, Vol Opportunities, and Locations. When working with data already in HandsOn Connect, this ID is the Salesforce 15- or 18-digit ID that can be found in reports, exports, or the object's URL. When importing data from outside the system, it is recommended that you provide a unique ID either from your current system or one that you set (suggested format: OR#####).No
69
ContactEmployerHOC__Employer__cstringRECOMMENDEDShows the employer as entered by the contact. No
74
ContactMiddle NameHOC__Middle_Name__cstringRECOMMENDEDProvides the middle name for the contact. Yes
86
ContactPrimary CityHOC__Primary_City__cstringOPTIONALIdentifies the Primary City for the Contact.No
87
ContactPrimary StateHOC__Primary_State__cstringOPTIONALIdentifies the Primary State for the Contact.No
88
ContactPrimary StreetHOC__Primary_Street__cstringOPTIONALIdentifies the Primary Street for the Contact.No
89
ContactPrimary ZipHOC__Primary_Zip__cstringOPTIONALIdentifies the Primary Zip Code for the Contact.No
99
HOC__Connection__cEnd Date & TimeHOC__End_Date_Time__cdatetimeREQUIREDFormat MM/DD/YYYY HH:MM:SS Shows the end date and time for the related object.Yes
100
HOC__Connection__cStart Date & TimeHOC__Start_Date_Time__cdatetimeREQUIREDFormat MM/DD/YYYY HH:MM:SS Every Connection in the system is given a start date & time and an end date & time. Yes
104
HOC__Connection__cGuest Hours ServedHOC__Guest_Hours_Served__cdoubleRECOMMENDEDWhen a registered volunteer brings unregistered volunteer(s) with them to an occurrence, these individuals are considered guests. This field allows you to record the hours provided by the guests of the registered volunteer for the said occurrence. Yes
105
HOC__Connection__cGuest VolunteersHOC__Guest_Volunteers__cdoubleRECOMMENDEDAllows you to record the # of guests brought by a registered volunteer to an occurrence. Note: if a guest is a registered contact, it is recommended that you add them to the occurrence so the hours can be associated with the volunteer's history.Yes
106
HOC__Connection__cHours ServedHOC__Hours_Served__cdoubleRECOMMENDEDDisplays the number of hours served by the volunteer during a specific connection. Yes
107
HOC__Connection__cTotal VolunteersHOC__Total_Volunteers__cdoubleOPTIONALIndicates the total number of volunteers associated with the related connection. No
108
HOC__Connection__cOpportunity Coordinator EmailHOC__Volunteer_Coordinator_Email__cemailNOT NECESSARYProvides the Email address for the Opportunity Coordinator at the Partner Agency. The Opportunity Coordinator receives notices of volunteer sign-ups at this e-mail address.No
109
HOC__Connection__cVolunteer EmailHOC__Volunteer_Email__cemailNOT NECESSARYProvides the Volunteers Email when they make a connection to an opportunity. This e-mail is used to send the volunteer notifications, confirmations, and reminders about the connection. No
110
HOC__Connection__cRecord IDIdidNOT NECESSARYID used within Salesforce to identify the entry within this object.No
111
HOC__Connection__cRoleHOC__Role__cmultipicklistVolunteer; Team Captain; Volunteer Leader"Volunteer"REQUIREDEvery Contact with a Connection is identified by the role they play for the occurrence as either Volunteer Leader, Team Captain, or Volunteer. This list can not be altered.DO NOT EDITYes
112
HOC__Connection__cAttendance StatusHOC__Attendance_Status__cpicklistAttendance Declined; Please Verify; Attended (and Hours Verified); Not Attended"Please Verify"REQUIREDConnections to a date & time specific opportunity are marked as "Please Verify." After the occurrence, it is marked as "Attended", "Not Attended", or "Attendance Declined" for tracking participation & hours. This list can not be altered. DO NOT EDITYes
113
HOC__Connection__cStatusHOC__Status__cpicklistPending Approval; Confirmed; Declined; Waitlisted"Pending Approval"REQUIREDWhen a volunteer signs-up for any occurrence a connection is made. This field shows the status of that connection. Connections marked as Confirmed identify volunteers that are counted in the total. This list can not be altered.DO NOT EDITYes
114
HOC__Connection__cDecline ReasonHOC__Decline_Reason__cpicklistRemoved Themselves; Declined Invitation; Opportunity Full; Failed Background Check; Skills not a match; Age inappropriate; No response from VolunteerRECOMMENDEDWhen a volunteer expresses interest and ends up not being a good fit for the opportunity, the affiliate or agency partner can mark the reason the volunteer was declined. Volunteers can also remove themselves from an opportunity. Yes (as of 9/1/2016)No
115
HOC__Connection__cRatingHOC__Rating__cpicklist1;2;3;4;5RECOMMENDEDEvery volunteer is able to rate their experience at a Volunteer Opportunity. The rating system is 1-5 stars. This list can not be altered.DO NOT EDITYes
116
HOC__Connection__cSourceHOC__Source__cpicklistPublic; AdminRECOMMENDEDIdentifies if the Connection was made via the public site or by an Admin. YesNo
117
HOC__Connection__c ContactHOC__Contact__creferenceREQUIREDThis field needs to be populated with the ID, NOT their nameThis field is used to identify the Contact associated with the Connection. Yes
118
HOC__Connection__c Occurrence HOC__Occurrence__creferenceREQUIREDThis field needs to be populated with the ID, NOT their nameThis field is used to relate the connection to the related occurrence. Yes
119
HOC__Connection__c Volunteer Opportunity HOC__Volunteer_Opportunity__creferenceREQUIREDThis field needs to be populated with the ID, NOT their nameIndicates the Volunteer Opportunity associated with the related object. Yes
120
HOC__Connection__cTeam MemberHOC__Team_Member__creferenceRECOMMENDEDThis field needs to be populated with the ID, NOT their nameIf a Connection/Contact is associated with a Team, the association and related link will be listed in this field. No
123
HOC__Connection__c IDVaries based on form of ID (Import ID, Record ID, HOC__Import_ID__c)stringREQUIREDThis is the unique ID used to associate updates with this organization and/or link this organization to other objects, such as Contacts, Vol Opportunities, and Locations. When working with data already in HandsOn Connect, this ID is the Salesforce ID that can be found in reports, exports, or the object's URL. When importing data from outside the system, it is recommended that you provide a unique ID either from your current system or one that you set (suggested format: OR#####).No
124
HOC__Connection__cStar RatingHOC__Star_Rating__cstringOPTIONALThis field identifies the star rating provided by the volunteers when they rated their experience following the occurrence. No
125
HOC__Connection__cTeam NameHOC__Team_Name__cstringOPTIONALIf a Connection/Contact is associated with a Team, the Team Name will be listed in this field. No
126
HOC__Connection__cVO LocationHOC__VO_Location__cstringOPTIONALThis should be populated with the ID, NOT the nameIndicates the location that is associated with the Connection. No
127
HOC__Connection__cVO Volunteer EventHOC__VO_Volunteer_Event__cstringOPTIONALThis should be populated with the ID, NOT the nameIndicates if this connection is with an opportunity that is associated with a Volunteer Event. No
129
HOC__Connection__cContact EmailHOC__Contact_Email__cstringNOT NECESSARYThis field is populated with the Contact's e-mail when a Connection is made. No
130
HOC__Connection__cContact PhoneHOC__Contact_Phone__cstringNOT NECESSARYThis field is populated with the Contact's phone number when a Connection is made. No
131
HOC__Connection__cHOC IDHOC__HOC_ID__cstringNOT NECESSARYID used to identify the object within the related lists in HandsOn Connect, displayed in the form of CO-#######. No
132
HOC__Connection__cPartner Staff EmailHOC__Partner_Staff_Email__cstringNOT NECESSARYLists the staff member's email at the partner agency associated with this Connection. No
133
HOC__Connection__cPartner Staff NameHOC__Partner_Staff_Name__cstringNOT NECESSARYLists the staff member at the partner agency associated with this Connection. No
134
HOC__Connection__cSerial NumberHOC__Serial_Number__cstringNOT NECESSARYNo
135
HOC__Connection__cFeedbackHOC__Feedback__ctextareaRECOMMENDEDVolunteers are able to provide feedback about an opportunity after completing the project or activity. This feedback is reported in this field. No
141
HOC__Location__cLatitudeHOC__Latitude__cdoubleHIGHLY RECOMMENDEDIf you don't have the formula for calculating this field, please refer to the HandsOn Connect support desk for directionsThis field is automatically filled based on information associated with the zip code. It is used to determine distance to the project for searches.Yes
142
HOC__Location__cLongitudeHOC__Longitude__cdoubleHIGHLY RECOMMENDEDIf you don't have the formula for calculating this field, please refer to the HandsOn Connect support desk for directionsThis field is automatically filled based on information associated with the zip code. It is used to determine distance to the project for searches.Yes
143
HOC__Location__cRecord IDIdidNOT NECESSARYID used within Salesforce to identify the entry within this object.No
144
HOC__Location__cOrganizationHOC__Organization__creferenceREQUIREDThis field needs to be populated with the ID, NOT their name. Locations without a related organization will not be imported.Relates the organization or business that the Location is associated with. When performing the import/update this needs to be populated with the ID for the organization not the name.No
145
HOC__Location__cZip/Postal CodeHOC__Zip_Postal_Code__creference5 digit zip onlyREQUIREDThis needs to be a duplicate of the Zip Code Column because it is used to associate the location for the "distance from" calculations. This identifies the zip code associated with the location. This field is used for determining the "distance from" for search results.No
149
HOC__Location__cIDVaries based on form of ID (Import ID, Record ID, HOC__Import_ID__c)stringREQUIREDThis is the unique ID used to associate updates with this organization and/or link this organization to other objects, such as Contacts, Vol Opportunities, and Locations. When working with data already in HandsOn Connect, this ID is the Salesforce ID that can be found in reports, exports, or the object's URL. When importing data from outside the system, it is recommended that you provide a unique ID either from your current system or one that you set (suggested format: OR#####).No
151
HOC__Location__cZip CodeHOC__Zip_Code__cstring5 digit zip onlyREQUIREDThis should be an exact copy of the Zip/Postal Code ColumnThis identifies the zip code associated with the location. Yes
152
HOC__Location__c CityHOC__City__cstringREQUIREDThis field indicates the city associated with the location of a volunteer opportunityYes
153
HOC__Location__c CountryHOC__Country__cstring"USA"REQUIREDThis field indicates the country associated with the location of a volunteer opportunityYes
154
HOC__Location__c State/ProvinceHOC__State_Province__cstringREQUIREDThis field indicates the State or Province for the location in the related object. Yes
155
HOC__Location__c StreetHOC__Street__cstringREQUIREDThis field indicates the street for the location in the related object. Yes
156
HOC__Location__cHOC IDHOC__HOC_ID__cstringNOT NECESSARYID used to identify the object within the related lists in HandsOn Connect, displayed in the form of LO-#######. Yes
157
HOC__Location__cSerial NumberHOC__Serial_Number__cstringNOT NECESSARYNo
158
HOC__Location__c Special DirectionsHOC__Special_Directions__ctextareaHIGHLY RECOMMENDEDEvery Location comes with a text field for special directions. This field can be used to provide driving and/or transit directions as well as other instruction such as bring work gloves and a water bottle. Yes
159
HOC__Location__cGoogle Map URLHOC__Google_Map_URL__curlHIGHLY RECOMMENDEDIf you don't have the URL, you can use this formula to create the URL: http://maps.google.com/?q=City, State, zip, street, plug in the cell (A2, B2, C2, etc) where the values for City, State, Zip, and Street are locatedShows the URL to the Google map to help find the location and provide directions. Yes
160
HOC__Occurrence__cVolunteer Leader NeededHOC__Volunteer_Leader_Needed__cbooleanRECOMMENDEDOnly for Affiliate Managered projectsThis Checkbox is checked when a volunteer leader is needed to lead the occurrence. No
162
HOC__Occurrence__cIsUpdateableHOC__IsUpdateable__cbooleanNOT NECESSARYIs checked when an occurrence can be updated. The default setting is that occurrences are updateable.No
163
HOC__Occurrence__cRegistration Start DateHOC__Registration_Start_Date__cdateHIGHLY RECOMMENDEDFormat MM/DD/YYYYBy default, volunteers can sign up for an occurrence as soon as it is put in active status. If you wish to have the opportunity appear, and yet not be available yet for sign-up, set a "registration start date.”Yes
165
HOC__Occurrence__cEnd Date & TimeHOC__End_Date_Time__cdatetimeREQUIREDFormat MM/DD/YYYY HH:MM:SS Shows the end date and time for the related object.Yes
166
HOC__Occurrence__cStart Date & TimeHOC__Start_Date_Time__cdatetimeREQUIREDFormat MM/DD/YYYY HH:MM:SS Every Occurrence in the system is given a start date & time and an end date & time. Yes
170
HOC__Occurrence__cRegistration Cutoff (hours)HOC__Registration_Deadline__cdouble"0"REQUIREDThe number of hours before the start of an occurrence at which time public sign-up for the occurrence ends. Yes
171
HOC__Occurrence__cGuest Volunteer Hours ServedHOC__Guest_Volunteer_Hours_Served__cdoubleRECOMMENDEDAllows you to record the # of hrs provided by guests brought by a registered volunteer. If a guest is a registered contact, it is recommended that you add them to the occurrence so the hours can be associated with the volunteer's history.No
172
HOC__Occurrence__cGuest Volunteers AttendedHOC__Guest_Volunteers_Attended__cdoubleRECOMMENDEDAllows you to record the # of guests brought by a registered volunteer to an occurrence. Note: if a guest is a registered contact, it is recommended that you add them to the occurrence so the hours can be associated with the volunteer's history.No
173
HOC__Occurrence__cMaximum AttendanceHOC__Maximum_Attendance__cdouble"500"RECOMMENDEDAffiliates and Partners can use this field to set the maximum number of volunteers that wish to have for this occurrence. Yes
174
HOC__Occurrence__cMinimum AttendanceHOC__Minimum_Attendance__cdouble"1"RECOMMENDEDAffiliates and Partners can use this field to set the minimum number of volunteers that wish to have for this occurrence. Yes
175
HOC__Occurrence__cTotal AttendedHOC__Total_Attended__cdoubleOPTIONALIndicated the total number of volunteers that attended the related occurrence. No