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 |
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 |
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_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 |
Upcoming_Donation_Type |
Specifies whether the upcoming donation is recurring or one-time. |
ONE-TIME |
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 |
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 |
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. |
|
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 |
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 |
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 |
Giving_Opportunity_Source |
The source of the giving opportunity. |
Company |
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. |
|
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 |
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:
|
£10.0K |
Paid Amount |
Sum of the payment amount where:
|
€100.0K |
Payment_ID |
Unique identifier of the payment |
1214646 |
Payment_Status |
Status of the payment to the cause.
|
*Initiated |
Payment_Method |
How the payment to the cause was made (e.g. check, EFT).
|
ETF |
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 |
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. |
|
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 |
Volunteer_Opportunity_Publish_State |
Current publish state of the volunteer opportunity. |
Active |
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 |
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 |
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 |
Volunteer_Opportunity_Signup_Notify |
Whether the owner gets a notification when users sign up. |
Notify of Signups |
Volunteer_Opportunity_Waiver |
Whether the volunteer opportunity requires a waiver. |
No waiver 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 |
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 |
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 |
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 |
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 |
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 |
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 |
Varchar(255) |
Activity_Effort |
The level of effort associated with the Mission activity. |
Easy |
Varchar(255) |
Activity_Savings_Type |
The type of savings that is associated with the Mission activity. |
Water |
Varchar(255) |
Activity_Savings_Unit |
The unit of measure used to measure the amount of savings associated with the Mission activity. |
None |
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 |
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 |
Cause_Type_Code |
Code type of the cause. |
A0 |
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. |
|
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. |
|
User_Status |
Status of the user. Active: Any user that currently has access to Spark. |
Active |
User_Accepted_Legal |
Flag to indicate if the user has accepted the terms of use. |
Yes |
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 |
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!