Team Competencies data terms and filter descriptions Updated August 27, 2026 17:09 When you need to build, edit, or review a report or chart in the Report or Dashboard Builder, keep this article nearby as a quick reference. It outlines all the available datasets, data fields, and filters for Team Competencies reports. Team Competencies datasets and filters Assessments In Progress & Completed Assessments Not Started Assessment Scores & Comments Team Competencies filters Assessments In Progress & Completed This dataset provides a snapshot of assessments that are in progress or completed within a specified timeframe. It shows the latest assessment and review status for each user and manager, along with relevant dates and identifiers for tracking progress. Each row represents a unique assessment for a user in a competency role. Dimension Data Type Description Assessment Identifier Text Unique ID for the assessment in standard UUID format. Assessment Status Text Overall status of the assessment, reflecting the progress of both the user and their manager. Possible values: open: Either the user or the manager's review has a status of draft or no activity. closed: Both the user and the manager have submitted their reviews. Assessment Updated At Date Date and time when the most recent update was made to the assessment by either the user or manager. In ISO 8601 format. Select a date interval: Year Quarter Month Week Day Competency Role Text User's position in the organization, defined when setting up Team Competencies in the Admin App. Not the same as Showpad role. Competency Role Identifier Text Unique ID for the Competency Role in standard UUID format. Manager Email Address Text Email address of the manager responsible for the user group assigned to the role and competencies. Not the same as direct manager. Manager Full Name Text Name of the manager responsible for the user group assigned to the role and competencies. Not the same as direct manager. Manager Review Started At Date Date and time the manager began their review of the user in ISO 8601 format. Empty when Manager Review Status is no activity. Select a date interval: Year Quarter Month Week Day Manager Review Status Text Current status of the manager's review. Possible values: no activity draft submitted Manager Review Submitted At Date Date the manager submitted their review of the user in ISO 8601 format. Empty if not submitted. Select a date interval: Year Quarter Month Week Day Manager Status Text The current Showpad access status of the manager. Possible values: active deactivated deleted (anonymized data) Self-review Started At Date Date and time the user began their self-review in ISO 8601 format. Empty when the Self-review Status is no activity Select a date interval: Year Quarter Month Week Day Self-review Status Text Current status of the user's self-review. Possible values: no activity draft submitted Self-review Submitted At Date Date and time the user submitted their self-review in ISO 8601 format. Empty if not submitted. Select a date interval: Year Quarter Month Week Day User Email Address Text Email address of the user assigned to the role and competencies. User Full Name Text Name of the user assigned to the role and competencies. User Status Text The current Showpad access status of the user. Possible values: active deactivated deleted (anonymized data) Usergroup ID Text Unique ID for the user group in standard UUID format. Usergroup Name Text Name of the user group assigned to the competency role the user is part of. Back to Top Assessments Not Started This dataset lists users assigned to the selected competency roles and tracks whether their manager has started an assessment or updated a review. The data shows one row per user, per role, per user group, per date within the selected time range. For each date, the report indicates whether an assessment was started or a manager review was updated on that specific date. When an activity occurs, the status will show TRUE for that date. Dimension Data Type Description Competency Role Text User's position in the organization, defined when setting up Team Competencies in the Admin App. Not the same as Showpad role. Competency Role Identifier Text Unique ID for the Competency Role in standard UUID format. Date Date Date of the progress check in ISO 8601 format. Select a date interval: Year Quarter Month Week Day Has Assessment Or Manager Review Text Indicates if the user or manager has started a review by the given date. Possible values: TRUE: at least one has started FALSE: neither has started Manager Email Address Text Email address of the manager responsible for the user group assigned to the role and competencies. Not the same as direct manager. Manager Full Name Text Name of the manager responsible for the user group assigned to the role and competencies. Not the same as direct manager. User Email Address Text Email address of the user assigned to the role and competencies. User Full Name Text Name of the user assigned to the role and competencies. Usergroup ID Text Unique ID for the user group in standard UUID format. Usergroup Name Text Name of the user group assigned to the competency role the user is part of. Back to Top Assessment Scores & Comments This report shows scores and comments from completed assessments within a selected timeframe. Each row represents a competency assessed for a user, including both the self-review and manager review, along with submission dates and review comments. Dimension Data Type Description Assessment Identifier Text Unique ID for the assessment in standard UUID format. Assessment Updated At Date Date and time when the most recent update was made to the assessment by either the user or manager. In ISO 8601 format. Select a date interval: Year Quarter Month Week Day Competency Name Text Name of the competency being assessed. Competency Name Identifier Text Unique ID for the Competency Name in standard UUID format. Competency Role Text User's position in the organization, defined when setting up Team Competencies in the Admin App. Not the same as Showpad role. Competency Role Identifier Text Unique ID for the Competency Role in standard UUID format. Manager Email Address Text Email address of the manager responsible for the user group assigned to the role and competencies. Not the same as direct manager. Manager Full Name Text Name of the manager responsible for the user group assigned to the role and competencies. Not the same as direct manager. Manager Review Comment Text Manager's comment explaining the competency score. Empty if not submitted. Manager Review Score Number Score given by the manager for the competency. Empty if not submitted. Manager Review Submitted At Date Date and time the manager submitted their review of the user in ISO 8601 format. Empty if not submitted. Select a date interval: Year Quarter Month Week Day Manager Status Text The current Showpad access status of the manager. Possible values: active deactivated deleted (anonymized data) Self-review Comment Text User's comment explaining the competency score. Empty if not submitted. Self-review Score Number Score given by the user for the competency. Empty if not submitted. Self-review Submitted At Date Date and time the user submitted their self-review in ISO 8601 format. Empty if not submitted. Select a date interval: Year Quarter Month Week Day User Email Address Text Email address of the user assigned to the role and competencies. User Full Name Text Name of the user assigned to the role and competencies. User Status Text The current Showpad access status of the user. Possible values: active deactivated deleted (anonymized data) Usergroup ID Text Unique ID for the user group in standard UUID format. Usergroup Name Text Name of the user group assigned to the competency role the user is part of. Back to Top Team Competencies filters The following table lists all available filter options and usage instructions for Competencies reports: Filter Name How to Use Assessment updated Select a date range: Last 30 days Last 90 days Last year This year Custom Choose a date range from the calendar. Date Select a date range: Last 30 days Last 90 days Last year This year Custom Choose a date range from the calendar. Competency roles Choose whether to include (match ANY) or exclude (match NONE) the selected roles. Then select one or more Competency roles. User groups Choose whether to include (match ANY) or exclude (match NONE) the selected user groups. Then select one or more user groups. Assessment identifiers Choose whether to include (match ANY) or exclude (match NONE) the selected assessment ids. Then select one or more assessment ids. Assessment statuses Choose whether to include (match ANY) or exclude (match NONE) the selected statuses. Then select either: Open to view assessments where either the user or the manager's review status is draft or no activity. Closed to view assessments where both the user and the manager have submitted their reviews. Competency identifiers Choose whether to include (match ANY) or exclude (match NONE) the selected competency ids. Then select one or more competency ids. Competency names Choose whether to include (match ANY) or exclude (match NONE) the selected Competency names. Then select the name of one or more competencies. Has assessment or manager review Choose whether to include (match ANY) or exclude (match NONE) the selected assessments with or without reviews. Then select either: true to view assessments where at least one (user or manager) has started a review by the given date. fales to view assessments where neither the user or manager has started a review by the given date. Manager email addresses Choose whether to include (match ANY) or exclude (match NONE) the selected manager's email addresses. Then select one or more manager emails. Manager full names Choose whether to include (match ANY) or exclude (match NONE) the selected manager names. Then select one or more manager names. Manager review comments Choose whether to include (match ANY) or exclude (match NONE) the selected manager review comments. Then select one or more manager comments. Selet one or more manager comments. Manager reviews started at Select a date range: Last 30 days Last 90 days Last year This year Custom Choose a date range from the calendar. Manager review statuses Choose whether to include (match ANY) or exclude (match NONE) the selected manager review statuses. Then select one or more manager review statuses: draft No activity submitted Manager statuses Choose whether to include (match ANY) or exclude (match NONE) the selected manager statuses. Then select one or more manager Showpad access statuses: active deactivated deleted (anonymized data) N/A Manager review submitted at Select a date range: Last 30 days Last 90 days Last year This year Custom Choose a date range from the calendar. Self review comments Choose whether to include (match ANY) or exclude (match NONE) the selected self review comments. Then selet one or more self review comments. Self review started at Select a date range: Last 30 days Last 90 days Last year This year Custom Choose a date range from the calendar. Self review statuses Choose whether to include (match ANY) or exclude (match NONE) the selected self review statuses. Then select one or more self review statuses: draft No activity submitted Self review submitted at Select a date range: Last 30 days Last 90 days Last year This year Custom Choose a date range from the calendar. User email addresses Choose whether to include (match ANY) or exclude (match NONE) the selected user email addresses. Then selet one or more user emails. User full names Choose whether to include (match ANY) or exclude (match NONE) the selected user names. Then selet one or more user names. User group names Choose whether to include (match ANY) or exclude (match NONE) the selected user group names. Selet one or more user group names. User statuses Choose whether to include (match ANY) or exclude (match NONE) the selected user statuses. Then select one or more user Showpad access statuses: active deactivated deleted (anonymized data) N/A Back to Top Related articles Asset data terms and filter descriptions Create a custom dashboard with the Dashboard Builder Understand the Showpad Adoption dashboard Build custom charts in the Dashboard Builder to visualize your data Create Team Competency reports with the Report Builder