Custom Question Report

Available columns:

Term Definition
EmployeeId Column data is from client HR data.
EmployeeFirstName

Employee’s first name

Column data is from client HR data.
EmployeeLastName

Employee’s last name

Column data is from client HR data.
EmployeeEmail

Employee’s email address

Column data is from client HR data.
EmployeePosition Data is from the PositionTitle column on the HR file.
OpportunityId The number associated with the team event, individual activity, or project
Name Event, individual activity, or project name
StartDate Opportunity's start date and time
EndDate Opportunity's end date and time
TimeZone Team event's time zone
ParticipationID Number assigned for each event participation occurrence
ParticipationDate Employee's date of participation
Types Client-assigned definition
Category Client-assigned definition
EventClassification What kind of volunteering was this?
IsEventVirtual

Was this a virtual event?

  • TRUE

  • FALSE
EventMSACode Event's Metropolitan Statistical Area code
EventTractCode Numeric county subdivision code for the event
EventCountyCode Event's county code
EventStateCode Event's state code
Address1 Event location's address
Address2 Event location's address (continued)
City Event location's city
State Event location's state
PostalCode Event location's postal code
Country Event location's country
County Event location's county
CharityMSACode Charity's Metropolitan Statistical Area code
CharityTractCode Numeric county subdivision code for the charity
CharityCountyCode Charity's county code
CharityStateCode Charity's state code
Status

Status of the opportunity:

  • Draft

  • Live
QuestionSetName Name of custom question set
IsCustomQuestionSetActive

True/False - Identifies whether this is an active custom question set

  • If active, TRUE

  • If inactive, FALSE
CRAStatus

Identifies status of CRA requests

  • 0 : Pending

  • 1 : Approved

  • 2 : Declined.
CRAStatusComment Comments tied to CRA requests
ResponseDate Date the custom question set response was created
LastModifiedDate Date the custom question set response was updated
OrganizationName Charity organization name
OrganizationRegistrationID Charity registration ID
EmployeeCustom1 Column data is from client HR data.
EmployeeCustom2 Column data is from client HR data.
EmployeeCustom3 Column data is from client HR data.
EmployeeCustom4 Column data is from client HR data.
EmployeeCustom5 Column data is from client HR data.
EmployeeCustom6 Column data is from client HR data.
EmployeeCustom7 Column data is from client HR data.
EmployeeCustom8 Column data is from client HR data.
EmployeeCustom9 Column data is from client HR data.
EmployeeCustom10 Column data is from client HR data.
EmployeeCustom11 Column data is from client HR data.
EmployeeCustom12 Column data is from client HR data.
EmployeeCustom13 Column data is from client HR data.
EmployeeCustom14 Column data is from client HR data.
EmployeeCustom15 Column data is from client HR data.
EmployeeCustom16 Column data is from client HR data.
EmployeeWorkPhone Employee's work phone number
OrganizationAddress1 Charity's address
OrganizationAddress2 Charity's address (continued)
OrganizationCity Charity's city
OrganizationStateProvince Charity's state or province
OrganizationCountry Charity's country
OrganizationPostalCode Charity's postal code
TotalParticipationHours Total number of hours employee participated in this opportunity
Description Description for this opportunity
ManagerEmployeeID Column data is from client HR data.
BoardMembershipRole Employee's board membership role (if applicable)
CustomQuestionSetResponseID ID assigned to custom question set responses
CRAQuestionSetResponseID ID assigned to CRA question set
QuestionName Question asked to the employee
Answer Employee's response to the question asked
DisplayName Lists the unlinked filename, in [FileName].[Filetype] format for the file containing a user’s responses. An example of this format is sampletext.pdf.