Skip to main content

Data field and filter descriptions

    Team Competencies data field and filter descriptions

    • Updated

    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

    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

    Get the latest apps and email integrations

    iOS App Store Google Play Store Microsoft Store