The following documentation describes the data dictionary for Bridge Perform Data. This is a work in progress, is subject to update/change based on new and upcoming releases.
The following files are covered in this guide:
This guide also covers:
Export Custom Questions
The following data dictionary is your guide for the Bridge Export Questions File from the Performance Conversations tab in Insights.
| Column Name | Description |
|---|---|
|
reviewee_id |
ID of employee from the Manage Users page |
|
reviewee_name |
Name of employee from the Manage Users page |
|
reviewer_id |
ID of manager/reviewer in the PC cycle |
|
reviewer_name |
Name of manager/reviewer from the Manage Users page |
|
pc_id |
ID of manager or employee PC agenda |
|
pc_state |
The completion status of manager agenda or employee/self agenda (see PC completion state definitions) |
|
question_id |
ID of question in PC cycle |
|
question_type |
Question type in PC cycle = FREEFORM, MULTI-SELECT, RATING SCALE, MULTIPLE CHOICE |
|
question_section_name |
Section name in PC cycle (ex. Wins, Plans, Other, Rating) |
|
who_answered_user_id |
ID of the employee from the Manage Users page that responded to the question |
|
who_answered |
Responder = REVIEWEE, REVIEWER, PEER |
|
question |
Question text in PC cycle |
|
question_response |
The responder's answer Note: applicable to all question types |
|
question_comment |
The responder's comment Note: applicable to all question types (excludes free response question type) |
|
peer_reviewer_id* |
ID of the peer agenda |
|
peer_reviewer_state* |
The status of peer reviewer (see PC completion state definitions) |
|
peer_review_state* |
The completion status of the peer agenda (see PC completion state definitions) |
|
peer_review_uuid* |
UUID of the Peer agenda |
|
peer_id* |
ID of the peer from the Manage Users page |
|
peer_name* |
Name of the peer from the Manage Users page |
|
rating_reviewee** |
The rating provided by employee |
|
rating_reviewee_comment** |
The comments for rating provided by employee |
|
rating_reviewer** |
The rating provided by manager/reviewer |
|
rating_reviewer_comment** |
The comments for rating provided by manager |
|
rating_calibration** |
The calibrated rating provided by manager/reviewer during Calibration phase |
|
rating_calibration_comment** |
The calibrated rating comment provided by manager/reviewer during Calibration phase |
* if the admin hasn't enabled peer reviews for the cycle, this field will be hidden in the CSV export
** if the admin hasn't enabled the rating section for the cycle
FAQ:
- The CSV export will pull the submitted question responses and ratings for the PC cycle, selected on the Insights page
- Blank columns mean that the question hasn't been answered by the user or the PC agenda hasn't started
- The CSV export will show data in real time
- Answer hint is not included in the CSV export
- Goals and other perform and learn data (ex: feedback, learnables) that are pulled into PC agenda are not included in the CSV export
- If user's name or ID is not added in the Manage Users page, then the name and ID will return blank in the export
PC Completion State Definitions
pc_state: This is the completion progress tracker for the manager agenda and the employee agenda.
| Status | Definition |
|---|---|
| NOT STARTED | Either agenda has not started |
| IN PROGRESS | One or more of the PC agendas has been submitted |
| COMPLETED | Performance conversation has been closed by manager |
peer_review_state: This is the completion progress for peer agendas.
| Status | Definition |
|---|---|
| NOT STARTED | The peer agenda has not started |
| IN PROGRESS | The peer reviewer is actively working on peer agenda but hasn't submitted the peer agenda yet |
| COMPLETED | The peer reviewer has submitted the peer agenda |
peer_reviewer_state: This is the peer reviewer list status tracker.
| Status | Definition |
|---|---|
| PROPOSED | The peer list has been submitted but not approved by manager/reviewer |
| APPROVED | The peer list has been submitted and approved by manager/reviewer |
| REJECTED | A peer was removed from peer list by employee or manager/reviewer |