CRA Creator Report
Available columns:
| Term | Definition |
| Employee Id | Column data is from client HR data. |
| Employee First Name |
Employee’s first name. Column data is from client HR data. |
| Employee Last Name |
Employee’s last name Column data is from client HR data. |
| Employee Email |
Employee’s email address Column data is from client HR data. |
| Employee Type | Column data is from client HR data. |
| Employee Position | Data is from the PositionTitle column in client HR data. |
| Is Employee Active |
True/False - Identifies whether this is a current employee
Column data is from client HR data. |
| Employee Manager Id | Column data is from client HR data. |
| Employee Manager Name | Column data is from client HR data. |
| Employee Location Id | Data is from the SiteCode column in client HR data. |
| Employee Work Address1 |
Employee’s work address Column data is from client HR data. |
| Employee Work Address2 |
Employee’s work address (continued) Column data is from client HR data. |
| Employee Work City |
City where employee works Column data is from client HR data. |
| Employee Work State |
State where employee works Column data is from client HR data. |
| Employee Work Zip Code |
Postal code for employee’s work location Column data is from client HR data. |
| Employee Work Country |
Country where employee works Column data is from client HR data. |
| Employee Region | Column data is from client HR data. |
| Employee Division | Column data is from client HR data. |
| Employee Market | Column data is from client HR data. |
| Employee Business Unit | Column data is from client HR data. |
| Employee Custom Fields1 | Column data is from client HR data. |
| Employee Custom Fields2 | Column data is from client HR data. |
| Employee Custom Fields3 | Column data is from client HR data. |
| Employee Custom Fields4 | Column data is from client HR data. |
| Employee Custom Fields5 | Column data is from client HR data. |
| Employee Custom Fields6 | Column data is from client HR data. |
| Employee Custom Fields7 | Column data is from client HR data. |
| Employee Custom Fields8 | Column data is from client HR data. |
| Employee Custom Fields9 | Column data is from client HR data. |
| Employee Custom Fields10 | Column data is from client HR data. |
| Employee Custom Fields11 | Column data is from client HR data. |
| Employee Custom Fields12 | Column data is from client HR data. |
| Employee Custom Fields13 | Column data is from client HR data. |
| Employee Custom Fields14 | Column data is from client HR data. |
| Employee Custom Fields15 | Column data is from client HR data. |
| Employee Custom Fields16 | Column data is from client HR data. |
| Board Membership Role | If employee has recorded board membership in My Account, the role appears here. |
| Event Id | ID for the event |
| Event Status | Status of the event:
- Draft - Live - Declined - Pending - Request Change Status of a project: - Draft - Published - In Progress - Closed - Null |
| Event Classification | The type of event: - Team - Project |
| Event Origin |
Definition is forthcoming. |
| Show In Search | Identifier for whether the event is set to appear in Search Opportunities |
| Name | Name of the event |
| Description | Event description |
| Event Created Date | Date the event was created |
| Event Start Date | The event's start date and time |
| Event End Date | The event's end date and time |
| Is Event Recurring |
Is this a recurring event?
|
| Occurrence Number | Number of times this event was held |
| Event Address1 | Event location's address |
| Event Address2 | Event location's address (continued) |
| Event City | Event location's city |
| Event State | Event location's state |
| Event Postal Code | Event location's postal code |
| Event County | Event location's county |
| Event Country | Event location's country |
| Event MSA Code | Event's Metropolitan Statistical Area code |
| Event Tract Code | Numeric county subdivision code for the event |
| Event County Code | Event's county code |
| Event State Code | Event's state code |
| Is Virtual |
Was this a virtual event?
|
| Event Types | Event types the event is associated with |
| Event Categories | Event categories the event is associated with |
| General Event Tags | What general tags were selected for this event? |
| Shift Name | Name of the shift |
| Charity ID | The internal ID for YourCause per organization from NPOconnect |
| Charity Registration Number | The charity's official ID. Also referred to as Tax ID, BIN, registration number, or Government ID. |
| Charity Name | Charity's name from NPOconnect |
| Charity Mission | Charity's self-reported mission statement in NPOconnect |
| Charity Category | Charity’s category based off of the National Taxonomy of Exempt Entitites (NTEE) code from NPOconnect |
| Cause Area | Cause areas of focus, including health, environment, education, human services, and more |
| Charity Address | Charity’s address from NPOconnect |
| Charity City | Charity’s city from NPOconnect |
| Charity State | Charity’s state from NPOconnect |
| Charity Postal Code | Charity’s postal code from NPOconnect |
| Charity Country | Charity’s country code from NPOconnect |
| Charity MSA Code | Charity's Metropolitan Statistical Area code from NPOconnect |
| Charity Tract Code | Numeric county subdivision code for the charity from NPOconnect |
| Charity County Code | Charity's county code from NPOconnect |
| Charity State Code | Charity's state code from NPOconnect |
| Sign Up Date | Date the employee signed up for the event |
| Participation Date | Date of employee's participation in the event |
| Volunteer Participation ID | Participant ID |
| Total Hours | Total number of hours for this event |
| Status Change Date | Date of decision on participation approval or denial |
| Status Comment | Any additional note relating to the status set |
| Participation Modified Date | Date of last update to participation record |
| CRA Creator Question Set Response Id | ID assigned to question set responses tied to the CRA Creator question set |
| Custom Question Set Name | Name of custom question set |
| Is Custom Question Set Active |
True/False - Identifies whether this is an active custom question set
|
| Question Name | Question asked to the employee |
| Answer | Employee's response to the question asked |