Benevity Reporting glossary

There's a lot of fields and measures available in Benevity Reporting, which also means a lot of terms. This glossary may be a helpful guide while you’re building your reports. 

Transactions

The Transactions fields contain information on the various transactions that are available within Benevity Reporting.

Field

Description

Sample Values

Transaction_Type

Indicates the type of transaction for the record.

Donation
Upcoming Donation
Internal Transfer
Manual Adjustment
Volunteering
Volunteer Signup
Mission Activity Completion
Mission Signup

Transaction_Date

Date of the transaction.

UTC Time

Tags

Spark reporting tags. Individual tags are separated by the | character, with no spaces. This feature is currently in Beta. To access it for your program, please contact your Client Success Manager.

givingseason22|westcan

Donation_Matching_Campaign

Name of the matching campaign providing the donation match amount.

Goodness - US - Matching Campaign - 2018

ARCHIVE_Donation_Giving_Opportunity

The giving opportunity name for the donation. This field has been archived and you should use the giving opportunity name found within the giving opportunity file.

Kids Help Phone

Donation_Type

Specifies whether the donation is recurring, one-time or unspecified.

Recurring
One-time
Unspecified

Donation_Source

Source of the funds.

Payroll

Donation_Currency

Currency of the transaction.

AUD

Donation_Description

Description of the donation transaction type.

Client Direct Donation

Donation_Country

Country of the donation.

Canada

Donation_Comment

Comment left by the user for the cause.

For the Kids

Donation_Transaction_Code

Donation and Internal Transfer identifier (not necessarily unique).

1MZX3ZPWWU

Donation_Reference_Code

The unique transaction reference.

056kss14utohghiql35lif2923-589b4199a65746.85705307

Donation_Comment_Name

Name left by the user for the cause.

Bob Smith

Rewards_Identifier

The identifier associated with the allocation of rewards.

vol_rewards

Rewards_Expiry_Date

Expiry date of My Rewards volunteer rewards or seeding.

2019-02-26 22:06:19

Donation_Committed_Date

Date that the donation was actually hit the Benevity system. For example, when a pay period was committed.

UTC Time

Donation_Privacy_Setting

Information being shared by the donor.

Name, Postal/ZIP and Email

Donation_Donor_Full_Name

Donor name for the transaction. This is what the user has opted to share with the cause.

Jane Smith

Donation_Donor_First_Name

Donor first name for the transaction. This is what the user has opted to share with the cause.

Jane

Donation_Donor_Last_Name

Donor last name for the transaction. This is what the user has opted to share with the cause.

Smith

Donation_Donor_Email

Donor email for the transaction. This is what the user has opted to share with the cause.

JaneSmith@example.com

Donation_Donor_Street_Address

Donor street address for the transaction. This is what the user has opted to share with the cause.

123 Street SE

Donation_Donor_City

Donor city for the transaction. This is what the user has opted to share with the cause.

Somerset

Donation_Donor_State_or_Province

Donor province or state for the transaction. This is what the user has chosen to share with the cause.

BC

Donation_Donor_Country

Donor country for the transaction. This is what the user has opted to share with the cause.

Canada

Donation_Postal_Code

Donor postal code or ZIP for the transaction. This is what the user has opted to share with the cause.

T2Q4L1

Donation_External_Donation_Date

Date that the user originally made the donation.

UTC Date

Donation_Reversal

Indicator for whether a transaction was adjusted (reversed) or if the transaction itself is the adjustment transaction (reversal).

Adjustment  Transaction Adjustment

Donation_Reversal_Type

What transactions were reversed (donation or match).

Donation
Donation and Match
Match

Donation_Reversal_Date

Date that the reversal occurred.

UTC Time

Donation_Reversal_Associated

_Transaction_Code

Transaction code of the associated transaction (for reversal transactions, the original donation and for transactions that were reversed, the reversal).

6PJC8HY6NG

User_Internal_Transfer_Amount

The amount of the internal transaction made by the user (e.g. when purchasing a gift card or topping up a giving account). These amounts are not given directly to a cause.

100.00

Corporate_Internal_Transfer_Amount

The amount of the internal transaction made by the client (e.g. seeding). These amounts are not given directly to a cause.

100.00

Donation_User_Donation_Amount

The user funds donated within Spark.

100.00

Donation_User_External_Donation

_Amount

The user funds of an external match request.

100.00

Donation_Corporate_Donation_Amount

The amount of corporate funds going to a cause from transactions such as direct corporate donations.

100.00

Donation_Corporate_Match_Amount

The match amount provided for a donation.

100.00

Donation_Total_User_Donation_Amount

The sum of user donation amount and user external donation amount.

100.00

Donation_Total_Corporate_Donation

_Amount

The total amount of corporate funds going to a cause. The sum of corporate donation amount and corporate match amount.

100.00

Donation_Rewards_Account_Donation

_Amount

The donation amount spent from the user rewards account.

100.00

Donation_Total_Donation_Amount

The sum of corporate and user donations (user donation amount + user external donation amount + corporate donation amount + corporate match amount + rewards account donation amount).

100.00

DR_Amount

The amount on the individual transactions that are attached to a donation report.

100.00

DR_Amount_(With_Fees)

DR Amount + Cause Support Fee (company-funded) + Merchant Fee (company-funded).

100.00

Fees_Cause_Support_Fee

Client-funded charity support fee.

100.00

Fees_Merchant_Fee

Client-funded merchant fee.

100.00

Adjustments_Adjustment_Match

_Amount

Amount that was manually drawn down on a user’s match cap, typically the amount used prior to implementation.

100.00

ARCHIVE_Upcoming_Donation_Giving

_Opportunity

The giving opportunity name for the upcoming donation. This field has been archived and you should use the giving opportunity name found within the giving opportunity file.

Kids Help Phone

Upcoming_Donation_Comment

Comment associated with the upcoming donation.

For the Kids

Upcoming_Donation_Matching_Opt_Out

Indicates whether the user has selected to opt-out of matching for the associated donation.

yes
no

Upcoming_Donation_Type

Specifies whether the upcoming donation is recurring or one-time.

ONE-TIME
RECURRING

Upcoming_Donation_Source

Indicates the source of an upcoming donation. Payroll donations are per pay period. Credit card and PayPal donations are monthly.

Payroll

Credit Card / PayPal

Upcoming_Donation_Status

Indicates the current status of an upcoming donation. Initiated indicates that the period has not yet closed, while in progress indicates that the period has closed, but the upcoming donation has not been committed yet.

Initiated
In Progress
Future Dated
Projected

Upcoming_Donation_Payroll_Period

_Name

Name of the payroll period attached to in progress or future dated upcoming donations.

2018-CAN-8

Upcoming_Donation_Payroll_Period

_End_Date

The end date of the payroll pledge period attached to in progress or future dated upcoming donations.

UTC Time

Upcoming_Donation_ID

Upcoming donation identifier (not necessarily unique).

sample_wpg_1234

Upcoming_Donation_Currency

The currency of the upcoming donation.

USD

User_Upcoming_Donation_Amount

The amount pledged for this transaction.

100.00

Upcoming_Donation_Custom_Match

_Amount

The custom match amount a user has applied for the upcoming donation.

100.00

Volunteer_Signup_ID

Unique identifier for the volunteer signup.

1N1ZVHW51F

Volunteer_Signup_Date

Date that the volunteer signed up for an event.

UTC Time

Volunteer_Signup_Reminder_Date

Date of the reminder for the volunteering event.

UTC Time

Volunteer_Signup_Waiver_Accepted

Whether the user has submitted a waiver, if required.

Yes

Volunteer_Signup_Tshirt_Size

The size that the user chose when signing up for the volunteer opportunity shift.

L, M, XL

Volunteer_Signup_Number_of_Guests

Number of guests that have been signed up to the event.

4

Volunteer_Submission_Status

Status of the volunteer submission.

Approved

Volunteer_Submission_Status_Change

_Date

The date and time when the status of a volunteer submission was changed (e.g. approved, denied).

UTC Time

Volunteer_Submission_Reward_Rejection

_Message

Message recorded by the admin when a volunteer hour submission is declined.

Rejected for reason 12

Volunteer_Submission_Reward_Type

Name of the type of the volunteering reward.

Donation Currency

Volunteer_Submission_During_Work

_Hours

Describes whether the hours were volunteered during work hours or during non-working hours. By default, hours are assumed to be non- working hours.

Non-Working Hours
During Work Hours

Volunteer_Submission_Comments_to

_Admin

Comments to admin provided by the user for their volunteer time submission.

Was fun

Volunteer_Submission_Date_of_Service

_Start

The start of the timeframe for when the volunteer hours occurred.

UTC Time

Volunteer_Submission_Opportunity

_Name

The user-entered volunteer opportunity or cause project and name.

CLEAN UP AND FEED TEENAGERS

Volunteer_Submission_Contact_Name

Contact name entered by the user for external tracked hours.

David Thomas

Volunteer_Submission_Contact_Email

Contact email entered by the user for external tracked hours.

David.thomas@abc.com

Volunteer_Submission_Contact_Phone

Contact phone number entered by the user for external tracked hours.

732-586-3954

Volunteer_Submission_ID

Unique volunteering submission identifier.

1MNZX4L20F

Volunteer_Submission_Approval_ID

Unique volunteering submission identifier for approved submissions.

56XVHP8G0Q

Volunteer_Submission_Date_of_Service

_End

The end of the timeframe for when the volunteer hours occurred.

UTC Time

Volunteer_Submission_Reward_Type

_Intended

Name of the type of the intended volunteering reward.

Donation Currency

Volunteer_Submission_User_Time

_Volunteered_Minutes

Volunteering time submitted in minutes.

180

Volunteer_Submission_User_Time

_Volunteered_Hours

User time volunteered in hours.

3

Volunteer_Submission_Reward_Amount

Amount of donation currency rewarded for volunteering.

100.00

Volunteer_Submission_Reward_Points

Non-donation currency credits awarded for volunteering (e.g. points).

100.00

Volunteer_Submission_Rating_Stars

Rating of the opportunity given by the user, represented as a number of stars from one to five. Unrated submissions show as blank or null and are not included in averages.

2

Missions_Challenge_Code

Identifier for the Missions challenge.

1P22B3DEX6_2HAMABM8Y9

Missions_Mission_Code

Identifier for the Mission.

1P22B3DEX6_2HAMAPLBSH

Missions_Activity_Code

Identifier for the Missions activity.

1P22B3DEX6_1MZZ4LVK1E

Missions_Completion_Type

Indicates if the user has completed, has stated that they do already or has opted out of a Missions activity.

Completed
Opt-Out
Do Already

Missions_Points_Earned

The number of points earned by completing the Mission’s activity. This measure will be 0 if the user has not completed the Mission’s activity or if the user has opted out of completing the Mission’s activity.

123

Missions_Kilograms_kg_Waste

The estimated amount of kilograms saved based on the timeframe specified in the Mission’s activity. This measure will be 0 if the user has not completed the missions activity or if the user has opted out of completing the Mission’s activity.

12.34

Missions_Kilograms_kg_CO2

The estimated amount of CO2 saved based on the timeframe specified in the Mission’s activity. This measure will be 0 if the user has not completed the Mission’s activity or if the user has opted out of completing the Mission’s activity.

12.34

Missions_Litres_L_Water

The estimated amount of water saved based on the timeframe specified in the Mission’s activity. This measure will be 0 if the user has not completed the Mission’s activity or if the user has opted out of completing the Mission’s activity.

12.34

Missions_Kilowatt_Hours_kWh

The estimated amount of kilowatt hours saved based on the timeframe specified in the Mission’s activity. This measure will be 0 if the user has not completed the Mission’s activity or if the user has opted out of completing the Mission’s activity.

12.34

Missions_Gallons_gal_Water

The estimated amount of water saved based on the timeframe specified in the Mission’s activity. This measure will be 0 if the user has not completed the Mission’s activity or if the user has opted out of completing the Mission’s activity.

12.34

Missions_Pounds_lb_Waste

The estimated amount of waste saved based on the timeframe specified in the Mission’s activity. This measure will be 0 if the user has not completed the Mission’s activity or if the user has opted out of completing the Mission’s activity.

12.34

Missions_Pounds_lb_CO2

The estimated amount of CO2 saved based on the timeframe specified in the Mission’s activity. This measure will be 0 if the user has not completed the Mission’s activity or if the user has opted out of completing the Mission’s activity.

12.34

System_User_ID

Unique identifier for the user.

1SVZQ0HBH2_3777-562fa2d0b5e22

Cause_ID

Unique identifier for cause.

840-750800605

Cause_Project_ID

Unique identifier for cause project.

1MNGJPTS3

Giving_Opportunity_Code

The unique giving opportunity identifier.

3PWM5GC3JT

Friendraiser_Code

The unique Friendraiser identifier.

434RH9H9KX

Foundation_Code

Unique code of the foundation.

1Z6C6Q8GGZ

Payment_ID

Unique identifier of the payment.

1214646

DR_ID

Unique identifier of the donation report.

*Not Applicable
122457

Peer_Match_Code

Unique identifier of the peer match.

2FKC0XN310_2L4FDMQSC9

Exchange_Rate_Code

Unique code for the exchange rate.

2020-03_CAD

Volunteer_Opportunity_ID

Unique code associated with the volunteer opportunity.

1TFXKJPTS3_5KMNRJPTS3

Shift_ID

Unique code associated with the shift.

1MNXF9UR69_5VBPIA09NM- GDSALA1C0B

Giving opportunities

This contains information on giving opportunities created within Spark. Only giving opportunities that have causes that have a donation transaction attached will be available in Benevity Reporting.

Field

Description

Sample Values

Giving_Opportunity_Code

The unique giving opportunity identifier.

3PWM5GC3JT

Giving_Opportunity_Title

The title of the giving opportunity.

2018 Make A Wish CT Campaign

Giving_Opportunity_Status

The current status of the giving opportunity.

 

Giving_Opportunity_Published

The current published state of the giving opportunity.

Unpublished
Published

Giving_Opportunity_Source

The source of the giving opportunity.

Company
User

Giving_Opportunity_Deadline

The deadline date of the giving opportunity, if provided.

UTC Time

Giving_Opportunity_Summary

The short description of the giving opportunity or Friendraising opportunity.

Passionate about supporting global development and relief programs

Giving_Opportunity_Creator_Email

The email of the creator of the giving opportunity.

Bob@example.com

Giving_Opportunity_Facebook

The Facebook address of the giving opportunity.

http://facebook.com/MakeAWishCT

Giving_Opportunity_Twitter

The Twitter address of the giving opportunity.

http://twitter.com/MakeAWishCT

Giving_Opportunity_WebAddress

The website for the giving opportunity.

http://ct.wish.org/

Giving_Opportunity_Created_Date

The date and time that the giving opportunity was created.

UTC Time

Giving_Opportunity_Changed_Date

The date and time that the giving opportunity was last changed.

UTC Time

Giving_Opportunity_End_Date

End date and time of the giving opportunity.

UTC Time

Giving_Opportunity_Description

The description of the giving opportunity.

 

Giving_Opportunity_Tags

The tags associated with the giving opportunity.

Disaster Relief

Giving_Opportunity_Url

The URL for user and company created giving opportunities in Spark.

/campaigns/123

Giving_Opportunity_Goal

The goal for the giving opportunity. This measure should not be summed across transactions associated with a giving opportunity.

10000.00

Friendraisers

This contains information on Friendraisers created by users in Spark.

Field

Description

Sample Values

Friendraiser_Code

The unique Friendraiser identifier.

42NY6E947T

Giving_Opportunity_Code

The unique giving opportunity identifier.

3PWM5GC3JT

Friendraiser_Name

Name of the Friendraiser.

Movember Madness

Friendraiser_Greeting

Friendraiser greeting.

Hello, please help us raise funds.

Friendraiser_Description

Friendraiser description.

This is a great opportunity to support fellow team members.

Friendraiser_End_Date

The end date of the Friendraiser.

UTC Time

Friendraiser_Created_Date

The created date of the Friendraiser.

UTC Time

Friendraiser_Cancelled_Date

The cancelled date of the Friendraiser.

UTC Time

Friendraiser_Creator_System_User_ID

Unique identifier for the creator of the Friendraiser.

1SVZQ0HBH2_3777-562fa2d0b5e22

Friendraiser_Creator_Email

The email address of the Friendraiser creator.

Person@example.com

Friendraiser_Country_Code

The country code (instance) of the Friendraiser.

840

Friendraiser_Goal

Friendraiser goal set by user.

5000.00

Foundations

This contains information on foundations.

Field

Description

Sample Values

Foundation_Code

Unique identifier for the foundation.

1Z6C6Q8GGZ

Foundation_Name

Name of the foundation

Canadian Online Giving Foundation

Foundation_Type

Foundation yype

Registered
Unregistered

Payments

This contains information on payments.

Field

Description

Sample Values

Allocated Amount

Sum of the payment amount for all payments (regardless of payment status) with application status Approved.

$200.0K

Committed Amount

Sum of the payment amount where: 

  • Application status = Approved, and
  • Payment status is not paid

£10.0K

Paid Amount

Sum of the payment amount where:

  • Application status = Approved, and
  • Payment status = Paid

€100.0K

Payment_ID

Unique identifier of the payment

1214646

Payment_Status

Status of the payment to the cause.

 

*Initiated
Paid
Cleared
In Progress
*Not Applicable

Payment_Method

How the payment to the cause was made (e.g. check, EFT).

 

ETF
Check
PayPal
*No Payable
*Not Applicable

Payment_Reference_Number

Reference number of the payment to the cause e.g. check number.

041111111111111

Payment End Date

The last day in the period for which donations that are part of this payment are made.

UTC Time

Payment_Code

Unique code of the payment to the cause.

1N02ZBGJ15

Payment_Status_Update_Date

The date that the payment status was updated.

UTC Time

Donation reports

This contains information on donation reports.

Field

Description

Sample Values

DR_ID

Unique identifier for the donation report.

10494

DR_Code

Unique donation report code.

1RS0AJQR09

DR_Date

Transactions up until this date are included on the donation report.

UTC Time

Exchange rates

These fields can be used to create custom measures that convert measures into a common currency

Field

Description

Sample Values

Exchange_Rate_Code

Unique identifier for the exchange rate.

2020-03_CAD

Exchange_Rate_CAD

Use this exchange rate in custom measures to convert donations into CAD.

1.0000

Exchange_Rate_EUR

Use this exchange rate in custom measures to convert donations into EUR.

0.7354

Exchange_Rate_GBP

Use this exchange rate in custom measures to convert donations into GBP.

0.5567

Exchange_Rate_USD

Use this exchange rate in custom measures to convert donations into USD.

0.9098

Exchange_Rate_AUD

Use this exchange rate in custom measures to convert donations into AUD.

0.9815

Exchange_Rate_JPY

Use this exchange rate in custom measures to convert donations into JPY.

0.827883

Peer matching

This contains information on peer matches.

Field

Description

Sample Values

Peer_Match_Code

The unique peer match identifier.

2FKC0XN310_2L4FDMQSC9

Peer_Match_Created_Timestamp

Creation date of the peer match pool.

UTC Time

Volunteer opportunities

This contains volunteer opportunity information that describes the opportunity including name, location, owner information, contact Information and start and end dates. It will include all volunteer opportunities, regardless of if there has been any user activity.

Field

Description

Sample Values

Volunteer_Opportunity_ID

Unique code associated with the volunteer opportunity.

1TFXKJPTS3_5KMNRJPTS3

Volunteer_Opportunity_Name

Title of the volunteer opportunity. These might not be unique, so use in conjunction with the volunteer opportunity start date.

Save Endangered Turtle Habitat

Volunteer_Opportunity_Source

Group who created the volunteer opportunity.

organization
organization_private
user
company
external

Volunteer_Opportunity_Start_Date

The start time stamp of the volunteering opportunity.

UTC Time

Volunteer_Opportunity_End_Date

The end time stamp of the Volunteering opportunity.

UTC Time

Volunteer_Opportunity_Contact_Name

Volunteer opportunity contact name.

David Taylor

Volunteer_Opportunity_Contact_Email

Volunteer opportunity contact Email.

d.taylor@abc.com

Volunteer_Opportunity_Contact_Phone

Volunteer opportunity contact Phone.

326-845-2876

Volunteer_Opportunity_Location_Name

Common display name of the volunteering location.

Duluth Vineyard Front Entrance

Volunteer_Opportunity_Location_Notes

The location notes of the volunteer opportunity.

Enter through left door

Volunteer_Opportunity_Location_City

City of the volunteer opportunity.

Des Moines

Volunteer_Opportunity_Location_State

State or province of the volunteer opportunity.

IA

Volunteer_Opportunity_Location_Country

Country of the volunteer opportunity.

United States

Volunteer_Opportunity_Location_PostCode

Postal code or ZIP code of the volunteering opportunity.

50314

Volunteer_Opportunity_Country_Code

The country code of the volunteer opportunity.

036

Volunteer_Opportunity_Summary

A short summary of the volunteer opportunity.

We will help the Malaysia Association

Volunteer_Opportunity_Description

Description of the volunteer opportunity.

 

Happy Hope Bags brings joy to children who endure long-term hospitalization

Volunteer_Opportunity_Internal_Notes

The internal notes associated with the volunteer opportunity.

One of Six to come

Volunteer_Opportunity_Scheduling_Information

The scheduling information associated with the volunteer opportunity.

Start and End time will vary depending of the activity you chose.

Archive_Volunteer_Opportunity_Giving_Opportunity

 

American Red Cross (ARC)

Volunteer_Opportunity_Reward_Name

The name of the rewards associated with the volunteer opportunity.

No Rewards

Volunteer_Opportunity_Status

The status of the volunteering opportunity.

Approved
Queued

Volunteer_Opportunity_Publish_State

Current publish state of the volunteer opportunity.

Active
Inactive

Volunteer_Opportunity_Featured

Whether the volunteer opportunity is featured.

Featured

Volunteer_Opportunity_Multiple_Locations

Whether the volunteer opportunity is occurring at multiple locations.

One Location
Multiple Locations

Volunteer_Opportunity_Override_Signup

Whether or not users can sign up past the maximum signup number.

Signup Override Not Allowed

Volunteer_Opportunity_Public

Whether the volunteer opportunity is open to the public.

Company-wide Event
By Invitation

Volunteer_Opportunity_Contact_2_Name

Volunteer opportunity contact name.

James Smith

Volunteer_Opportunity_Contact_2_Email

Volunteer opportunity contact email.

James Smith

Volunteer_Opportunity_Contact_2_Phone

Volunteer opportunity contact phone number.

(123)9806532

Volunteer_Opportunity_Contact_3_Name

Volunteer opportunity contact name.

Dillin Duo

Volunteer_Opportunity_Contact_3_Email

Volunteer opportunity contact email.

DillinDuo@example.com

Volunteer_Opportunity_Contact_3_Phone

Volunteer opportunity contact phone number.

123-980-6532

Volunteer_Opportunity_Contact_4_Name

Volunteer opportunity contact name.

Julia Sue

Volunteer_Opportunity_Contact_4_Email

Volunteer opportunity contact email.

JuliaSue@example.com

Volunteer_Opportunity_Contact_4_Phone

Volunteer opportunity contact phone number.

123 980 6532

Volunteer_Opportunity_Contact_5_Name

Volunteer opportunity contact name.

Elmo Right

Volunteer_Opportunity_Contact_5_Email

Volunteer opportunity contact email.

ElmoRight@example.com

Volunteer_Opportunity_Contact_5_Phone

Volunteer opportunity contact phone number.

1239806532

Volunteer_Opportunity_Recurring

Whether the volunteer opportunity is a recurring event.

One-Time Event
Recurring Event

Volunteer_Opportunity_Signup_Notify

Whether the owner gets a notification when users sign up.

Notify of Signups
No Signup Notifications

Volunteer_Opportunity_Waiver

Whether the volunteer opportunity requires a waiver.

No waiver required
Optional
Required

Volunteer_Opportunity_Waiver_URL

The URL to the waiver associated with the volunteer opportunity.

http://waiver.example.com

Volunteer_Opportunity_URL

The URL of the volunteer opportunity within Spark.

/node/123

Volunteer_Opportunity_Facebook

Volunteer opportunity Facebook address.

Facebook.com/example

Volunteer_Opportunity_Twitter

Volunteer opportunity Twitter address.

Twitter.com/example

Volunteer_Opportunity_WebAddress

Volunteer Opportunity web address.

www.cause.org

Volunteer_Opportunity_Descriptors

Event descriptors associated with the Volunteer Opportunity.

Good for Kids
Team Event

Volunteer_Opportunity_Interest_Tags

Interest tags associated with the volunteer opportunity.

Community Support,Arts and Culture,Education

Volunteer_Opportunity_Skill_Tags

Skill tags associated with the volunteer opportunity.

Children & Family,Food Service & Events

Volunteer_Opportunity_Owner_Name

Name of volunteer opportunity owner.

Janis Wu

Volunteer_Opportunity_Remote_Author_Name

Name of the volunteer opportunity author, if the opportunity was created externally.

Smithers Jones

Volunteer_Opportunity_Created_Date

Time stamp when the volunteer opportunity was created.

UTC Time

Volunteer_Opportunity_Changed_Date

Timestamp of when the status of the volunteer opportunity was last updated.

UTC Time

Volunteer_Opportunity_Location_Address

Street of the volunteer opportunity.

Street address

Volunteer_Opportunity_Owner_Email

The email of the owner of the volunteer opportunity.

Somebody@example.com

Volunteer_Opportunity_Lives_Impacted

Number of lives impacted by the volunteer opportunity. This measure should not be summed across shifts, signups or submissions associated with a volunteer opportunity.

200

Cause_ID

Unique identifier for causes.

840-750800605

Cause_Project_ID

Unique identifier for cause project.

1MNGJPTS3

Volunteer_Opportunity_Owner_System_User_ID

Unique identifier for the volunteer opportunity owner.

1SVZQ0HBH2_3777-562fa2d0b5e22

Volunteer shifts

This contains volunteer shift information. In the Transactions, Users, and Causes data set in Benevity Reporting, only shifts with user activity will show. To see all shifts, regardless of user activity, use the Volunteering Summary – by Shift dataset.

Field

Description

Sample Values

Volunteer_Opportunity_ID

Unique code associated with the volunteer opportunity.

1TFXKJPTS3_5KMNRJPTS3

Shift_ID

Unique code associated with the shift.

1MNXF9UR69_5VBPIA09NM- GDSALA1C0B

Shift_Name

Name of the shift.

Morning Shift

Shift_Accept_Waitlist

Whether the shift accepts a waitlist.

1

Shift_Allow_Guests

If the shift allows guests to be signed up.

Guests Allowed Guests Not Allowed

Shift_Start_Date

The start date and time of the shift.

UTC Time

Shift_End_Date

The end date and time of the shift.

UTC Time

Shift_Created_Date

The created time stamp of the shift.

UTC Time

Shift_Maximum_Signup

Maximum number of people that can sign up for the shift.

11

Shift_Length_Hours

Length of shift in hours.

4

Mission challenges

This contains details related to the challenges that a Mission is a part of.

Field

Description

Sample Values

Challenge_Code

The unique challenge identifier.

1TFXKJPTS3_5KMNRJPTS3

Challenge_Name

The name of the challenge.

Inclusion and Belonging

Challenge_Label

The label associated with the challenge.

Firm-Wide Challenge

Challenge_Status

The current status of the challenge.

Active
Inactive

Challenge_Creator_Email

The email of the creator of the challenge.

Someone@example.com

Challenge_Created_Date

The date and time the challenge was created.

UTC Time

Challenge_Updated_Date

The date and time the challenge was last updated.

UTC Time

Challenge_Archived_Status

The current archive status of the challenge.

Active
Archived

Missions

This contains details related to the Missions that users can sign up for.

Field

Description

Sample Values

Mission_Code

The unique Mission identifier.

1TFXKJPTS3_5KMNRJPTS3

Mission_Name

The name of the Mission.

Support Women

Mission_Status

The current status of the Mission.

Active
Inactive

Mission_Summary

The short description of the Mission.

Breast Cancer Awareness Month

Mission_Details

The details associated with the Mission.

 

<p>Breast cancer is by far the most common cancer in women ….</p>

Mission_Creator_Email

The email of the creator of the Mission.

Someone@example.com

Mission_Created_Date

The date and time the Mission was created.

UTC Time

Mission_Updated_Date

The date and time the Mission was last updated.

UTC Time

Mission_Archive_Status

The current archive status of the Mission.

Active
Archived

Missions activities

This contains details related to the Missions activities that users can complete.

Field

Description

Sample Values

Data Type

Activity_Code

The unique Mission activity identifier.

1TFXKJPTS3_5KMNRJPTS3

Varchar(21)

Activity_Name

The name of the Mission activity.

Lather Up

Varchar(1024)

Activity_Status

The current status of the Mission activity.

Active
Inactive

Varchar(20)

Activity_Description

Description of the Mission activity.

Turn off water while you shampoo

Varchar(140)

Activity_How_To

The instructions provided on how to complete the Mission activity.

<p>Turn off the water while shampooing for a full minute or more.</p> 

Longtext

Activity_Category

The category that is associated with the Mission activity.

Water
Awareness

Varchar(255)

Activity_Effort

The level of effort associated with the Mission activity.

Easy
Moderate
Difficult

Varchar(255)

Activity_Savings_Type

The type of savings that is associated with the Mission activity.

Water
Energy
Emissions
Waste

Varchar(255)

Activity_Savings_Unit

The unit of measure used to measure the amount of savings associated with the Mission activity.

None
Kilograms
litres

Varchar(20)

Activity_Creator_Email

The email of the creator of the Mission activity.

Someone@example.com

Varchar(200)

Activity_Created_Date

The date and time the Mission activity was created.

UTC Time

Datetime

Activity_Updated_Date

The date and time the Mission activity was last updated.

UTC Time

Datetime

Activity_Archive_Status

The current archive status of the Mission activity.

Active
Archived

Varchar(20)

Causes

This contains data points for any cause that your employees or your company have transacted against (performed a giving or volunteering transaction). This contains cause information that describes the cause, including name, address and category.

Field

Description

Sample Values

Cause_ID

Unique identifier for causes. Cause ID is a concatenation of the ISO country code and the unique government identifier (e.g. EIN in USA).

840-010448173

Cause_Name

Name of the cause.

CENTER FOR TEACHING AND LEARNING

Cause_Category

A top-level category name of a cause (e.g. Education). Category is based on NTEE code.

Education

Cause_Subcategory

The subcategory name of a cause (e.g. higher education institutions). Subcategory is based on NTEE code.

Primary Elementary Schools

Cause_Category_Code

Code that represents the category and subcategory of a cause (e.g. NTEE code, cause activity code).

A01
A11

Cause_Type_Code

Code type of the cause.

A0
A2

Cause_Type_Description

Provides information on whether the cause is a registered charitable organization.

Standard registered charitable organization

Cause_Address

Street address of the cause.

119 CROSS POINT RD

Cause_City

City where cause is located.

EDGECOMB

Cause_State_or_Province

State or province of cause.

Maine

Cause_Country

Country where the cause is located.

United States

Cause_Postal_Code

Postal code or ZIP code of cause.

04556-3226

Cause_Website

Website of the cause.

http://connecticutchildrensfoundation.org

Cause_Telephone

Phone number of cause.

(123) 999 9999

Cause projects

Cause projects are campaigns or chapters within a cause. This file contains basic cause project information that describes the project and its address.

Field

Description

Sample Values

Cause_Project_ID

Unique identifier for cause project.

ITJ389L2BV

Cause_ID

Unique identifier for causes. Cause ID is a concatenation of the country code and the unique government identifier (e.g. EIN in USA).

840-300108263

Cause_Project_Name

Name of the cause.

HELP EDUCATE 750 GIRLS IN RURAL INDIA

Cause_Project_Address

Street address of the cause.

117 BTM Layout

Cause_Project_City

City where cause project is located.

Bangalore

Cause_Project_State_or_Province

State or province of cause project.

Karnataka

Cause_Project_Country

State or Province of cause project.

India

Cause_Project_Postal_Code

Postal code or ZIP code of cause.

160059

Cause_Project_Operating_Organization

The true operating organization for the project. In some cases, a project may be associated with a parent cause for the purposes of receiving funds, but in reality belongs under a different organization, potentially in a different country.

Foundation for Life

Cause_Project_Telephone

Project-specific telephone number.

(123) 999 1234

Cause_Project_Website

Project-specific website.

http://www.cause.org

Project_Description

Project-specific description.

Our aim is to break the cycle of illiteracy that girls from socially and economically disadvantaged communities of India are mired in through local community-based Learning Centers.

Users

Users are sent to Benevity in the demographic file. This data contains information that describes the user, including name, address and email. It will include all users that have ever been eligible (had access to Spark during the selected timeframe), regardless of if they have made a donation, volunteer, or Missions transaction.

Field

Description

Sample Values

System_User_ID

Unique identifier for the user.

1SVZQ0HBH2_3777-562fa2d0b5e22

User_Country_Code

Country code of the user. These are based on the ISO numeric country codes.

840

User_Employee_ID

Employee ID from company.

000154

User_First_Name

First name of user.

Paul

User_Last_Name

Last name of user.

Smith

User_Full_Name

Full name of user (first and last name).

Paul Smith

User_Preferred_Name

Preferred name of user.

Pauly

User_Email

Email address of user.

paul.smith@abc.com

User_Status

Status of the user.

Active: Any user that currently has access to Spark.
Inactive: A user that no longer has access to Spark.

Active
Inactive

User_Accepted_Legal

Flag to indicate if the user has accepted the terms of use.

Yes
No

Accepted_Legal_Date

Date and time when the user accepted the terms of use.

UTC Time

User_Street_Address

Street address of the user.

119 CROSS POINT RD

User_City

City of the user.

EDGECOMB

User_State_Province

State or province of the user.

Maine

User_Country

Country of the user.

United States

User_PostalCode_Zip

Postal code or ZIP code of the user.

04556-3226

User_Last_Login

Date and time when the user last logged into Spark.

UTC Time

User_Activated_Date

Date and time the user was activated.

UTC Time

User_Deactivated_Date

Date and time when the user was deactivated.

UTC Time

Spark_User_ID

Unique Spark user identifier.

Sample_wpg_10002

Spark_Roles

Administrator roles that the user has assigned in Spark.

volunteer manager (no reporting)

User_Skills

The skills a user has selected in their profile.

Administrative & Clerical,Reception

User_Interests

The interests a user has selected in their profile.

Animals,Arts and Culture

User_Badges

The list of badges that the user has earned.

Impact Member, Captain

Spark_Username

Unique Spark username.

PaulSmith

User_Timezone

Time zone set in the user’s profile in Spark.

American/Los Angeles
Europe/Paris

User_Language

Language set in the user’s profile in Spark.

English

Calculated Fields

Participation Rate Participants (Any user that has taken action (donated, tracked volunteer time, completed a mission), displayed as a percentage of eligible or active users. 20%

 

Continue your learning—next article

To learn how to create ad hoc views and reports, check out the next article: creating ad hoc views and reports

Help make the B-Hive better! Take a few minutes to complete this survey to help us better understand how the B-Hive is being used and where we can improve. Thank you!

Was this article helpful?
6 out of 7 found this helpful

Articles in this section

We're enhancing B-Hive!
Take a quick survey and tell us what you think of the new experience.
Announcements
Stay up-to-date on what's happening at Benevity.