Available Report Columns for TeamRaiser Performance By Team Report

The following tables contain the available columns you can add to the TeamRaiser Performance By Team report type.

Company Information

Company
Ask Date of SponsorshipDate on which this sponsor was contacted for the contribution
CompanyName of the donating company
Company Fiscal Year Accounting period to which the funds raised will be applied
Company Goal How much money company hopes to raise
Company NotesDetails about this company that other administrators may need to know
Company Thermometer AdjustmentHow much was subtracted from the fundraising Thermometer status indicator for registration subsidies, matching gifts, and so on
Company URLThe Web address of the homepage for the site that the company uses as their public Web site
Company Volunteer ManagerName of the volunteer who will work with the company
Internal Company Name Alternative label, such as a short name, to identify a company to administrators
Is Archived CompanySetting that determines whether the company is active or is no longer on the active list
Is National CompanySetting that determines whether a company supports teams in all events across a type of TeamRaiser
Is Only SponsorWhether or not the company is the only sponsor
Is Regional Company 
Participant Recruiting Goal The number of participants the company hopes to recruit for the event
Projected Close Date of SponsorshipProjected date for receiving the money pledged by this sponsor
Public Company Name Name of the company who will be a sponsor
Sponsor Amount CommittedTotal monetary amount this sponsor has agreed to contribute
Sponsor Amount PaidMonetary amount that has been received from this sponsor so far
Sponsor Amount PendingMonetary amount yet to be collected from this sponsor
Sponsor Ask AmountMonetary amount that this sponsor has been (or will be) asked to contribute to this TeamRaiser event
Sponsor Contact EmailEmail address where the contact person at the sponsor company will accept email
Sponsor Contact NameName of the person at the sponsor company with whom to communicate
Sponsor Contact PhoneTelephone number of the contact person at the sponsor company
Sponsor Gift Type

Type of gift that this sponsor will provide:

  • Cash

  • Volunteer

  • Other

Sponsor NotesDetails 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 NameName 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 NameName of the volunteer who will work with the sponsor
Sponsorship Type

Type of company teams for this sponsor:

  • National

  • Regional

  • Local

  • Other

Staff Name Name of the person from your organization who contacted (or, will contact) this sponsor
Team Recruiting Goal The number of teams the company hopes to recruit for the event
Team Captain Biographical Information
Team Captain 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

Team Captain 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.

Team Captain Constituent IDSystem-generated identifier that is unique to this person (also called ConsID)
Team Captain Created ByName of the administrator who created the contact record
Team Captain Creation TimeMonth, day, year, and time when the contact record was created
Team Captain Date of BirthMonth, day, year entered as the date of birth for this person
Team Captain Donor Status

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

  • Never

  • Undefined

  • Indirect

  • Direct

  • Unknown

  • Non-donor

Team Captain Exchange IDSystem-generated identification number used for importing data about this person into the BlackBaud Raiser's Edge offline donor database
Team Captain First NameThe constituent's first name
Team Captain GenderMale or Female
Team Captain Last Modified ByName of the administrator who last modified the contact record
Team Captain Last NameThe constituent's last name
Team Captain Matched DonorIndicates whether any gifts made by this person are matched by an employer
Team Captain Member IDMember identification number typically uploaded from an offline database if organization uses member numbers
Team Captain Middle NameExtra name information entered for this person. Can be a middle name, maiden name, nickname, and so on
Team Captain Modification TimeMonth, day, year, and time when the contact record was modified
Team Captain Origin Application Reference IDSystem-generated string that identifies the feature through which the person became a registered user of the site
Team Captain Origin Application Type 
Team Captain Origin Source CodeA string defined by an administrator identifying a page or campaign that generated the user's registration
Team Captain Origin Subsource CodeA string defined by an administrator qualifying the Origin Source Code
Team Captain 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

Team Captain Professional SuffixAbbreviated respect/education label selected to follow the last name of the person (for example, MD or Esq)
Team Captain SuffixAbbreviated label selected to follow the last name of the person (for example, Jr)
Team Captain TitleIntroductory title that appears before the first name of the person (for example, Mr. or Mrs.)
Team Captain User NameString 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.
Team Captain Email
Team Captain Accept Email Yes or No- Typically enabled by default, for whether the email recipient will accept other email from the site
Team Captain Email The constituent's email address
Team Captain Hard-Bounce CountNumber of coaching emails that were sent back as undeliverable because of an invalid email address
Team Captain Opt-Out DateMonth, 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
Team Captain Opt-Out Method

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

  • Undefined

  • Admin

  • User (constituent)

  • Link

  • Exchange

Team Captain Opt-Out Reference IDSystem-generated identifier that tracks the opt-in/opt-out status change of this person
Team Captain 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

Event Settings 
Allow DonationsSetting on the Fundraising Options page for whether donations will be accepted
Allow GoalSetting that lets participants specify fundraising goals (on the Event Options page)
Allow Multiple RegistrantsSetting 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 PagesSetting (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 GiftsEvent Options page setting to display a link on the Team pages allowing donations in support of the entire team
Allow TeamsSetting that permits teams to be formed in the event
AreaThe geographical area in which an event will take place
CityThe city in which an event will take place
CountryThe country in which an event will take place
CountyThe county in which an event will take place
Include Team CompaniesSetting 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 UnconfirmedEvent Options page setting to display unconfirmed gifts in the Gift History lists (on participant's Progress pages)
Location NameLabel that specifies the name of the site where the event will take place
Max Captains Per TeamSetting for whether a team has more than one captain, as well as the maximum number of co-captains allowed
National Companies OnlySetting 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 ThresholdAdministrator configuration that determines the step, in percentage of goal raised or dollar amount raised, at which the progress meter display changes
RegionLabel that specifies a geographical area in which an event will take place
StateLabel that specifies the state in which an event will take place
Street AddressLabel that specifies the number and name of the street on which an event will take place
Zip CodeLabel that specifies the ZIP Code in which an event will take place