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.