Export Summary

The Export Summary (the downloaded file is labeled as the Event Participation Summary) is accessed through the Manage Participants feature. In the Community environment, navigate to Volunteer, Manage Opportunities, select the event, Manage Event, Manage Participants, Export Summary.

The following columns are available within the Export Summary:

Term	Definition
Employee ID	Column data is from client HR data.
Employee First Name	Employee’s first name Column data is from client HR data.
Employee Last Name	Employee’s last name Column data is from client HR data.
Employee Email	Employee’s email address Column data is from client HR data.
Employee Location ID	Data is from the SiteCode column in client HR data.
Employee Work Address1	Employee’s work address Column data is from client HR data.
Employee Work Address2	Employee’s work address (continued) Column data is from client HR data.
Employee Work City	City where employee works Column data is from client HR data.
Employee Work State	State where employee works Column data is from client HR data.
Employee Work ZipCode	Postal code for employee’s work location Column data is from client HR data.
Employee Work Country	Country where employee works Column data is from client HR data.
Employee Region	Column data is from client HR data.
Employee Division	Column data is from client HR data.
Employee Market	Column data is from client HR data.
Employee Business Unit	Column data is from client HR data.
Guest First Name	Guest's first name that the employee entered
Guest Last Name	Guest's last name that the employee entered
Guest Email	Guest's email address that the employee entered
Guest Note	Participant-added note for this specific guest
Role	Employee's role for this event
Participation ID	Participation ID assigned to the participant for this event
Participation Date	Date of participation in the event
SignUp Date	Date signed up for the event
Shift Name	Name of the shift
Shift Start Time	Start time for the shift
Shift End Time	End time for the shift
Hours	Number of hours for this event
Sign Up Source	Method used for employee's signup
Checked In Updated Date	Date and time (based on the event's time zone) when the event organizer updated the participant’s check-in If the participant was on a waitlist, this column will be empty.
Checked In Status	Participant’s most recent status - Checked In – Check-in completed - Check-in Removed – Event organizer removed the participant’s check-in using Manage Participants - Not Checked In – Participant did not check in If the participant was on a waitlist, this column will be empty.
Checked In Date	Date and time (based on the event's time zone) when the participant was checked in If the participant was on a waitlist, this column will be empty.
Check In Source	Participant's check-in source QR Code - Participant checked in using the QR code Organizer - Organizer or administrator checked the participant in using Manage Participants If the participant was on a waitlist, this column will be empty.
On Waitlist	Was employee on the waitlist for this event? - TRUE - FALSE
Was Waitlist	Had the employee been on the waitlist for this event? - TRUE - FALSE
Added From Waitlist Date	If the employee was on the waitlist and then added to the event, this is the date and time that they were added.
TShirt Size	Requested T-shirt size (if applicable)
Skills	Skills listed on the employee's profile
Custom Event Questions	If applicable, these are the question(s) tied to participants in the sign up flow.