Report Columns for TeamRaiser Gift Details Report

The following tables contain the data you can include in the TeamRaiser Gift Details report.

Company Information

Company
Ask Date of Sponsorship Date on which this sponsor was contacted for the contribution
Company Name of the donating company
Internal Company Name Alternative label, such as a short name, that identifies the donating company to administrators
Is Only Sponsor Determines if the company will not display for selection when Team Captains form teams in this TeamRaiser event
Projected Close Date of Sponsorship Date projected for receiving the money pledged by this sponsor
Sponsor Amount Committed Total monetary amount this sponsor has agreed to contribute
Sponsor Amount Paid Monetary amount that has been received from this sponsor so far
Sponsor Amount Pending Monetary amount yet to be collected from this sponsor
Sponsor Ask Amount Monetary amount that this sponsor has been (or will be) asked to contribute to this TeamRaiser event
Sponsor Contact Email Email address where the contact person at the sponsor company will accept email
Sponsor Contact Name Name of the person at the sponsor company with whom to communicate
Sponsor Contact Phone Telephone number of the contact person at the sponsor company
Sponsor Gift Type

Type of gift that this sponsor will provide:

  • Cash

  • Volunteer

  • Other

Sponsor Notes Details about this sponsor that other administrators may need to know
Sponsor Payment Type

Method of payment that this sponsor will use:

  • Cash

  • Check

  • Credit

  • In Kind

  • Other

Sponsor Staff Name Name of the person from your organization who contacted (or, will contact) this sponsor
Sponsor Status

Phase in the sponsorship process that this sponsor has completed:

  • Ask

  • Committed

  • Contract

  • Paid

  • Prospect

  • Declined

Sponsor Volunteer Manager Name Name of the volunteer who will work with the sponsor
Sponsorship Type

Type of company teams for this sponsor:

  • National

  • Regional

  • Local

  • Other

Gifts
Acknowledged? Yes or No setting for whether the follow-up thank-you note has been sent from the Followups To-Do list (in the Participant Center)
Bank Name Name of the bank through which the payment is processed
Batch ID Letter and number string, optionally set by the person entering the gifts, to group all recorded gifts together for tracking in the system
Check Number Number off the check received for a gift payment
Date Recorded Date when the donation was made online or entered into the system
Donor Type Specified donor type
Facebook Donation ID System-generated ID for the donation
Gift Amount ($) Dollar amount of gift
Gift ID Identifying number the system set for the gift
Gift Payment Method Credit Card, Bank Account Withdrawal, Cash, or Check
Gift Type Indicates donation is 'offline' or 'online'
Is eCommerce Purchase? Specifies whether the gift is a purchase from an item in eCommerce
Is Registration? Specifies whether the gift is registration for an event.
Offline Status Indicates an offline donation is 'confirmed', 'unconfirmed' , 'rejected', or blank
Soft Credit Type Participant, Team, or Event, depending on whom the donor chose to support

Donor Information

Donor Data Privacy
Donor Global Privacy Control Opt-Out

  • Opted-Out Indicates that the Global Privacy Control setting in the constituent's browser was detected as enabled to opt-out.

  • No Preference (or blank) Indicates that the Global Privacy Control setting in the constituent's browser is not enabled.

This setting is not editable. The value is set automatically through detection of the browser setting. Once enabled, the option cannot be disabled.
Donor Targeted Ads Opt-Out

Indicates whether the constituent indicated that they want to opt out of targeted ads. This is a manual setting set by an administrator.
Donor Sale of Personal Data Opt-Out

Indicates whether the constituent indicated that they want to opt out of the sale of their personal data. This is a manual setting set by an administrator.
Donor Profiling Opt-Out

Indicates whether the constituent indicated that they want to opt out of profiling. This is a manual setting set by an administrator.
Donor Information
City The donor's city of residence
Country The donor's country of residence
County The donor's county of residence
Donor Constituent ID String that identifies a constituent registered on your site
Email The donor's email address
First Name The donor's first name
Last Name The donor's last name
Middle Name The donor's middle name
Phone The donor's ten digit phone number
Postal Code The donor's zip code
Professional Suffix Information added to the last name of a donor, such as MD, Esq, and so on
State/Province The donor's state or province
Street 1 The donor's street address
Street 2 The donor's street address
Street 3 The donor's street address
Suffix Information that displays after the last name of a donor, such as Jr or Sr
Title Courtesy title, such as Mr., displayed before the first name of a donor
Honor, Memorial and Joint Gifts
Is Anonymous Donor Yes or No setting, selected when completing a donation form, for whether the donor's name displays in the gift lists
Is Honor Gift Setting that determines if donation is on someone else's behalf
Is Joint Donor Setting that indicates whether a second person, not making a payment, will be recognized as a donor
Joint First Name First name of a donor who is not directly making a gift payment
Joint Last Name Last name of a donor who is not directly making a gift payment
Joint Title Courtesy form of address for a donor who is not directly making a gift payment

eCommerce Information

Gift Information

Gifts
Acknowledged? Yes or No setting for whether the follow-up thank-you note has been sent from the Followups To-Do list (in the Participant Center)
Bank Name Name of the bank through which the payment is processed
Batch ID Letter and number string, optionally set by the person entering the gifts, to group all recorded gifts together for tracking in the system
Check Number Number off the check received for a gift payment
Date Recorded Date when the donation was made online or entered into the system
Facebook Donation ID System-generated ID for the donation
Gift Amount ($) Dollar amount of gift
Gift ID Identifying number the system set for the gift
Gift Payment Method Credit Card, Bank Account Withdrawal, Cash, or Check
Gift Type Confirmed, unconfirmed, rejected, or blank
Is eCommerce Purchase? Specifies whether the gift is a purchase from an item in eCommerce
Is Registration? Specifies whether the gift is registration for an event.
Offline Status True or False to indicate offline donation
Soft Credit Type Participant, Team, or Event, depending on whom the donor chose to support

Participant Information

Participant Address
Participant Address The address of the participant
Participant Accept Mail Whether or not the participant accepts email
Participant Advocacy Information
Participant Congressional District (Automatic) Name of the federal legislative geographic area automatically assigned to this participant based on the residential address entered
Participant Congressional District (Manual Override) Name of the federal legislative geographic area to which this participant is manually reassigned to cover the cases where the address information is not exact or redistricting has occurred
Participant County (Manual Override) Name of the county legislative geographic area to which this participant is manually reassigned to cover the cases where the address information is not exact or redistricting has occurred
Participant Municipality (Automatic) Name of the municipality automatically assigned to this participant based on the residential address entered
Participant Municipality (Manual Override) Name of the municipality to which this participant is manually reassigned to cover the cases where the address information is not exact or redistricting has occurred
Participant State House District (Automatic) Name of the state house legislative geographic area automatically assigned to this participant based on the residential address entered
Participant State House District (Manual Override) Name of the state house legislative geographic area to which this participant is manually reassigned to cover the cases where the address information is not exact or redistricting has occurred
Participant State Senate District (Automatic) Name of the state senate legislative geographic area automatically assigned to this participant based on the residential address entered
Participant State Senate District (Manual Override) Name of the state senate legislative geographic area to which this participant is manually reassigned to cover the cases where the address information is not exact or redistricting has occurred
Participant Biographical Information
Participant Active Detail

One of the following:

  • Undefined

  • Unknown to Contact

  • Known to Contact

  • Accepted by Contact

  • Registered Contact

  • New Prospect

  • Interested Prospect

  • Removed by Administrator

  • Removed by Contact

  • Removed as Duplicate
Participant Active Status

Active if the person is a registered user of your site and can log in

Inactive if the person is no longer a registered user of your site.
Participant Constituent ID System-generated identifier that is unique to this person (also called ConsID)
Participant Created By Name of the administrator who created the contact record
Participant Creation Time Month, day, year, and time when the contact record was created
Participant Date of Birth Month, day, year entered as the date of birth for this person
Participant Donor Status

Indication of when this person last made a gift of money to the site:

  • Never

  • Undefined

  • Indirect

  • Direct

  • Unknown

  • Non-donor
Participant Exchange ID System-generated identification number used for importing data about this person into the BlackBaud Raiser's Edge offline donor database
Participant First Name The constituent's first name
Participant Gender Male or Female
Participant Last Modified By Name of the administrator who last modified the contact record
Participant Last Name The constituent's last name
Participant Matched Donor Indicates whether any gifts made by this person are matched by an employer
Participant Member ID Member identification number typically uploaded from an offline database if organization uses member numbers
Participant Middle Name Extra name information entered for this person. Can be a middle name, maiden name, nickname, and so on
Participant Modification Time Month, day, year, and time when the contact record was modified
Participant Origin Application Reference ID System-generated string that identifies the feature through which the person became a registered user of the site
Participant Origin Application Type  
Participant Origin Source Code A string defined by an administrator identifying a page or campaign that generated the user's registration
Participant Origin Subsource Code A string defined by an administrator qualifying the Origin Source Code
Participant Password Type

Indicates the method used to generate the password:

  • Undefined

  • DES (in the DB, DES encrypted)

  • LDAP (in an external DB)

  • Luminate Online SHA (SHA-256 encrypted)

  • Luminate Online RSA

Participant Professional Suffix Abbreviated respect/education label selected to follow the last name of the person (for example, MD or Esq)
Participant Suffix Abbreviated label selected to follow the last name of the person (for example, Jr)
Participant Title Introductory title that appears before the first name of the person (for example, Mr. or Mrs.)
Participant User Name String of letters and numbers that this person enters to log in to the site. Can be entered by the person when registering as a user on this site or generated by the system.
Participant Data Privacy
Participant Global Privacy Control Opt-Out

  • Opted-Out Indicates that the Global Privacy Control setting in the constituent's browser was detected as enabled to opt-out.

  • No Preference (or blank) Indicates that the Global Privacy Control setting in the constituent's browser is not enabled.

This setting is not editable. The value is set automatically through detection of the browser setting. Once enabled, the option cannot be disabled.
Participant Targeted Ads Opt-Out

Indicates whether the constituent indicated that they want to opt out of targeted ads. This is a manual setting set by an administrator.
Participant Sale of Personal Data Opt-Out

Indicates whether the constituent indicated that they want to opt out of the sale of their personal data. This is a manual setting set by an administrator.
Participant Profiling Opt-Out

Indicates whether the constituent indicated that they want to opt out of profiling. This is a manual setting set by an administrator.
Participant Email
Participant Accept Email Yes or No- Typically enabled by default, for whether the email recipient will accept other email from the site
Participant Email The constituent's email address
Participant Hard-Bounce Count Number of coaching emails that were sent back as undeliverable because of an invalid email address
Participant Opt-Out Date Month, day, year, and time that the Opt-out option was disabled by or for this person so they do not receive site email messages by default
Participant Opt-Out Method

Indicates who or how the Opt-Out option was disabled:

  • Undefined

  • Admin

  • User (constituent)

  • Link

  • Exchange

Participant Opt-Out Reference ID System-generated identifier that tracks the opt-in/opt-out status change of this person
Participant Preferred Format

HTML if the person can receive email messages with formatting in them

Plain Text if the person can only receive emails without formatting in them
Participant Employment
Participant Employer Name of the participant's employer
Participant Occupation The participant's occupation
Participant Phone
Participant Phone Ten-digit telephone number listed for contacting the participant
Participant Transaction Information  
Participant Engagement Factor 1 - 9 Relative ranking of this person who performed an interaction (defined to engage people with your site) with other constituents who performed the same interaction with your Web site
Participant Frequency PCTL Percentile ranking of the frequency at which this person made donations compared to your other donors. For example, 10% means that this person was in the top 90 percent of your most frequent donors; whereas, 90% means that this person was in the top 10 percent of your most frequent donors
Participant Lifetime Alert Response Count Total number of alerts to which this person responded since becoming a registered user of your site
Participant Monetary Value PCTL Percentile ranking of the amount of money this person has donated based on total dollar amount contributed relative to your other donors. For example, 10% means that this person was in the top 90 percent of actual dollars donated; whereas, 90% means that this person was in the top 10 percent of actual dollars
Participant Previous Year Alert Response Count Number of alerts to which this person responded during the previous calendar year
Participant Recency PCTL Percentile ranking of how recently this person made a donation relative to other donors
Participant YTD Alert Response Count Number of alerts to which this person responded so far this year

Participation Type Information

Participation Type
Participant Fee Amount ($) Event registration fee collected from registrants of this participation type
Participant Fee Payment Option  
Participant Minimum Goal Amount ($) The minimum amount expected to be raised by members of this participant type
Participant Promotion Code A code that registrants can enter for this participation type to receive promotional discounts or options
Participant Tax Deductible Amount ($) Dollar amount that a participant can deduct from their taxes when registered as this participant type
Participation Type Creation Date Date when the participation type was created
Participation Type Modified Date Date when an administrator last modified the participation type
Participation Type Name Label that identifies how a person can take part in an event
Participation Type Status Active if available on registration forms; Not Active if not available for display on registration forms
Participation Type Settings
Participant Anonymous Registration Allowed Indicates whether this participation type allows participants to register anonymously
Participant Waiver Required Setting that requires a participant to accept a waiver in order to register as this participation type

Registration Information

Online Check-In
Offline Fees Paid Amount ($) Registration fees collected from all registrants via offline payments
Online Check-In Flow Step Number of the step last completed by a participant in the online check-in process
Online Check-In Status Status that shows if a participant has started or completed the online check-in process, or if this is unknown.
Online Fees Paid Amount ($) Registration fees collected from all registrants via online payments
Registration
Company Name of company associated with this registration.
Facebook Fundraiser ID The system-generated Facebook Fundraiser ID that is linked to a registration.
Is Team Captain Setting that indicates whether the participant is a Team Captain
Participant Constituent ID String that identifies a constituent registered on your site
Personal Page Last Updated Date The last time the participant updated their personal page
Registration Active Status Active or Inactive to indicate the participant's status within your organization
Registration Date Date when this donor registered for the event
Registration Type Online if participant completes registration form and processes it online; Offline if an administrator registers the participant
Screen Name Name alias that the registrant is using instead of the First and Last Name. This name displays in place of their name on fundraising event pages.
Self Donor Indicates whether the registrant made a donation to self.
Registration Amounts
Additional Gift Amount ($) Dollar figure a registering participant can enter in the Additional Gift field on the Fundraising Options page, if that option is enabled
Discount Amount Dollar amount subtracted from registration fee when a participant applies a discount code
Discount Type Label that identifies the discount processed
Fees Paid Amount ($) Registration fees (including secondary ones) collected from all registrants
Participant Goal ($) The amount of money the participant hopes to raise for the event
Upsell Total Amount ($) Total money value of additional option purchases
Registration Settings
Anonymous Registration Indicates whether the participant has opted to register anonymously
Emergency Contact Name and telephone number of the person to contact on behalf of a participant in the event of an emergency
Gift Notification Configuration set by administrator indicating whether an email notice should be sent (to an address also specified by the administrator) when a gift is made
Has Private Page Setting that blocks a participant's Personal Page from displaying in public searches
Honorary Team Name Label for the special honorary team, if this option is enabled on the Team Options page
Is Photo Use Allowed Indicates whether a registrant will permit the hosting organization to display the registrant's photo online
Is Prior Participant Indicates whether the participant registered for this event the last time it occurred
Is Secondary Registration Indicates whether tge participant was registered by another participant
Race Number Personal ID number generated by the system for each appropriate participant if the Generate Race Numbers option is enabled on the Event Options page
Waiver Accepted Setting that confirms a participant checked the Accept Waiver Conditions checkbox
Registration Stats
Emails Sent How many email addresses to which the email was sent
Recruited Participants Count

How many participants registered for the TeamRaiser and joined this team captain or team member's team using the registration link found on the Personal Page of the participant identified in this report.

Tip: When a participant registers and joins a team from the Personal Page link of a team captain or team member, the registrant is considered a recruit.
Secondary Registrations
Secondary Registrations Setting that indicates a participant was registered by another participant as part of that individual's registration

Security Information

Security Category
Affiliate Abbreviation Abbreviated name of the organization's affiliate/chapter that created the email campaign
Security Category Name Setting that identifies who can modify the coaching email

Team Information

Team
Team The system generated identifier for the team
Team Creation Date Date when the Team Captain formed the team
Team Goal ($) The total amount that the team hopes to raise for this event
Team Members Goal The total amount that the members of the team hope to raise individually
Team Modified Date Date when changes were made to the team information
Team Name Label for a team competing in the event
Team Settings
Is Captainless Indicates whether the previous team did not have a captain
Is Honorary Team Setting that identifies whether the team is honorary
Is Private Setting that requires registrants to know the password of a team before joining it
Team Description Additional information about a team
Team Division Setting that identifies a group of teams competing against each other
Team ID String that identifies a team on your site

TeamRaiser Campaign Information

Event  
Campaign Tax ID The tax identification number for the TeamRaiser
Event The system generated identifier for the event
Event Created Date Date when the event was first created
Event Date Month, day, and year when an event will take place
Event Description Details about the TeamRaiser event that search engines can use to locate TeamRaiser pages
Event Local Company Recruitment Goal The number of local companies the organization hopes to recruit for the event
Event Modified Date Date when an administrator changed the date of an event
Event Online Goal($) The amount of money the organization hopes to raise online for the event
Event Participant Recruitment Goal The number of participants the organization hopes to recruit for the event
Event Sponsor Goal ($) The amount of money the organization hopes to raise from sponsors for the event
Event Status Published, Unpublished, or Archived
Event Team Recruitment Goal The number of teams the organization hopes to recruit for the event
Fiscal Year Accounting period to which the funds raised will be applied
Internal Event Name Short name of the event for administrators
Lead Event Name The name of the main community event with which smaller events may be affiliated
Previous Campaign ID The system generated identifier for the previous event
Public Event Name Label that identifies the event on pages accessible to site visitors and participants
Public Event Type Classification both for comparison reporting and for grouping this TeamRaiser with similar TeamRaisers associated with the same registration Upsells and national companies
Suggested Participant Goal ($) How much money the organization hopes each participant will try to raise for this event
Suggested Team Goal ($) How much money the team intends to raise
Type of Affiliation Specifies whether the event is a lead or affiliate event
Event Classification
Event Type 1 Classification both for comparison reporting and for grouping this TeamRaiser with similar TeamRaisers associated with the same registration upsells and national companies
Event Type 2 Secondary group for associating this TeamRaiser with other, similar TeamRaisers for reporting purposes
Event Type 3 Third way for associating this TeamRaiser with other, similar TeamRaisers for reporting purposes
Event Settings  
Allow Donations Setting on the Fundraising Options page for whether donations will be accepted
Allow Goal Setting that lets participants specify fundraising goals (on the Event Options page)
Allow Multiple Registrants Setting that indicates whether a person can register more people (typically, family members) and combine all registration fees and upsell purchases into one online payment
Allow Personal Pages Setting (on the Event Options page) that indicates whether participants can customize their Personal Page, as opposed to inheriting the default page or the page customized by the Team Captain
Allow Team Gifts Event Options page setting to display a link on the Team pages allowing donations in support of the entire team
Allow Teams Setting that permits teams to be formed in the event
Area The geographical area in which an event will take place
City The city in which an event will take place
Country The country in which an event will take place
County The county in which an event will take place
Include Team Companies Setting that, if enabled on the Team Options page, determines whether a Team Captain can enter or select a local company as a sponsor when forming a team during registration
Indicate Unconfirmed Event Options page setting to display unconfirmed gifts in the Gift History lists (on participant's Progress pages)
Location Name Label that specifies the name of the site where the event will take place
Max Captains Per Team Setting for whether a team has more than one captain, as well as the maximum number of co-captains allowed
National Companies Only Setting that, if enabled on the Team Options page, determines whether a Team Captain can select a sponsoring national company when forming a team during registration
Progress Meter Threshold Administrator configuration that determines the step, in percentage of goal raised or dollar amount raised, at which the progress meter display changes
Region Label that specifies a geographical area in which an event will take place
State Label that specifies the state in which an event will take place
Street Address Label that specifies the number and name of the street on which an event will take place
Zip Code Label that specifies the ZIP Code in which an event will take place

Transaction Information

Custom Data Fields
Additional Amount Dollar figure a registering participant can enter in the Additional Gift field on the Fundraising Options page, if that option is enabled
Appeal ID System-generated string identifying the Appeal to the operating software
Custom Amount 1-9 Dollar amount the user enters when completing a donation form
Custom String 1-9 Additional notation user types into a donation form
Date Pledged Date when user made a pledge (as opposed to when user was actually charged)
First Time Donor Status The status of donors with no recorded donation history, Active or Not Active
Fulfillment Complete True or False
Goal The amount the participant hopes to raise
Is Recognition Set Value set with a Recognition input in the donation form
Last Paid Date Most recent installment payment on record at time of report
Running Total Monetary amount raised by the participant to date
Tax Deductible Value Dollar amount that a participant can deduct from their taxes
Payment Method
Payment Method Credit Card, Bank Account Withdrawal, Cash, or Check
Tender Instance Name Code indicating Credit Card type
Tender Type Name Credit Card, Bank Account Withdrawal, Cash, or Check
Valued Transaction
Account Number The bank account, entered during the payment stage of the transaction, on which a gift payment should be drawn
Account Type  
AVS Decode Value  
AVS Response

One character code:

  • X - Exact match, 9 digit zip - Street Address, and 9 digit ZIP Code match

  • Y - Exact match, 5 digit zip - Street Address, and 5 digit ZIP Code match

  • A - Partial match - Street Address matches, ZIP Code does not

  • W - Partial match - ZIP Code matches, Street Address does not

  • Z - Partial match - 5 digit ZIP Code match only

  • N - No match - No Address or ZIP Code match

  • U - Unavailable - Address information is unavailable for that account number, or the card issuer does not support

  • G - Service Not supported, non-US Issuer does not participate

  • R - Retry - Issuer system unavailable, retry later

  • E - Not a mail or phone order

  • S - Service not supported
Billing Address The donor's billing address
Bank Name Name on the credit card used to make an online transaction or the name entered by the administrator when recording or processing a transaction offline
Billing Email The donor's email address
Billing Name Name on the credit card used to make an online transaction or the name entered by the administrator when recording or processing a transaction offline
Billing Phone The donor's phone number
Campaign Title Name of the donation campaign with which the donation form used to collect money is associated
Card Expiration Date Date when the credit card used to make a gift payment will expire
Card Number Number of the credit card used to make a gift payment
Check Number Number on the check received for a gift payment
Confirmation Code The letter/number code combination the system assigned to the transaction system
Creation Method

  • 0 = offline

  • 1 = online

  • 2 = recurring
Discount Value Dollar figure of a discount applied to the transaction
Employer Company for which the donor works
Gift Aid Status True or False if government will make partial match (UK only)
INV Number Invoice number returned by ecommerce gateway
Occupation Employment as indicated by person who will be billed for this transaction
Original Value Transacted The donation or registration fee paid online or recorded
Payment Installment A number that indicates which payment transaction this is in a sequence of payments
Processor Transaction ID Unique number and letter identifier assigned to the donation when it was processed in the system
Proxy ID Team ID, Event ID, or Constituent depending on for which of these the transaction was completed
Proxy Name

One of the following:

  • Constituent's name

  • TeamRaiser name

  • TeamRaiser team name

  • Administrator

  • No proxy
Proxy Type Team, Event, or Participant for which the transaction was completed
Real Reference Number Internal number to track original payment in a sustaining gift series (for Clear Commerce)
Receipt ID Generated by system to track PDF receipt
Reference Number Order number generated by Clear Commerce
Routing Number Specially encoded number that identifies the bank for an account withdrawal
Settlement Batch The settlement batch ID associated with this transaction
Settlement Date The date the transaction was settled as provided by the payment processor. If the payment processor does not return a date, the system will determine the date of the settlement.
Settlement Status Settled, Unsettled, or Submitted ACH only
Transaction Amount Monetary sum of all gift payments made in support of the participant (whether marked as confirmed or if they appear on the unconfirmed gift list) plus the monetary amount of registration fees that the participant paid
Transaction Date The date that the donation was processed in the system
Transaction ID Unique number and letter identifier assigned to the donation when it was processed in the system
User Confirmation Code The letter/number code combination the system assigned to the user