Understanding the Intelligence Data Feed

Use the Intelligence Data Feed to automate the extraction of data from across the Quantum Workplace platform for business intelligence analysis.

In this article: 

 

Overview

A Data Feed reliably and automatically extracts data from across our platform for external reporting.

Use this article to understand how to set up and get the most value from a Data Feed.

Is a Data Feed Right for Me?

Data Feed is for data professionals. If you manage a data warehouse or repository for business intelligence reporting, then you can use it to make Quantum Workplace data available with other business data or as a stand-alone data mart.

Data are exported in flat files as often as daily and accessed via SFTP and can be incorporated into your ETL pipeline.

The data are exported using several files keyed with our user id. One of the files exported is our users table.  The users table contains the attributes you supply from your HRIS along with Quantum Workplace’s user id key.  This lets you connect what happens across our system to an employee ID in your system – an exception being when a survey or feedback confidentiality setting prevents this association. 

Quantum Workplace will not identify confidential survey or feedback data. You can learn more about confidential surveys here and confidentiality settings here.

Suppose you are strictly interested in being able to analyze data from across the Quantum Workplace platform (cross-cycle, cross-template, or cross-tool analysis) without looking at external business data. In that case, you might also consider Intelligence Dashboards. If you plan to analyze only Quantum Workplace data but prefer to use your own data visualization / BI tool, then you can use Data Feed files to create a data mart of Quantum Workplace data.

Use Cases

Just some of the use cases for a Data Feed are given for inspiration below:

Describing the Impact of Employee Engagement

  • What is the impact of employee engagement on performance?
  • What is the impact of employee engagement on goals?
  • What is the impact of employee engagement on revenue/safety/billable hours?

Focusing & Monitoring Your DEI Initiatives

  • Do underrepresented groups have a different employee experience? 
  • Do underrepresented groups term at a different rate than most?
  • Do our efforts to address areas of concern have the desired impact?

Ensure Employee Compliance & Effectiveness 

  • Are employees receiving the appropriate feedback on time?
  • When employees receive feedback, does it positively affect goal progress?
  • When employees receive feedback, does it positively affect safety?

Setting Up Your Data Feed

Quantum Workplace admins can access the configuration settings for Data Feed by navigating to Administration > Integrations > Data Feed.

On the Data Feed page, you can configure your Data Feed for a nightly, weekly, or monthly refresh frequency.  You can also specify which data you would like to include: 1-on-1s, Feedback, Goals, Recognition, and/or Survey.

Note that when the data are refreshed, they include all historical data, not just new data since the last refresh.

How to Access the Data

Data Feed files are accessed via SFTP on a server provided by Quantum Workplace.  This is the same server used for HRIS integration “sftp.quantumworkplace.com”.  Your Username and Password are given to you by the Customer Success Manager for your organization.

Data Feed files will be in your “/outbound/DataFeed/” directory.

Sample Data

We make sample data available so you can see which files are available with a Data Feed and how they are formatted.  You can use the sample files to develop your data model and explore how they can be used in reporting.  Click here to download sample data.

Recommended Data Model

We recommend using a reverse star schema as illustrated below.  Because all data can be mapped back to the Users file, it serves as the common link across all data. Additionally, it contains the employee ID that you provide. This employee ID allows you to connect Quantum Workplace data with other internal data, assuming that data also contains the employee ID.

  

Data Dictionary

Included in the Data Dictionary: 

FeedbackRequest

This contains data related to the Feedback feature in Quantum Workplace. Specifically, it contains information about those who were requested to provide Feedback. GiverUserID is NULL if the Feedback responses are anonymous unless the provider is the manager of the recipient.

  • FeedbackRequestID
    Numeric
    Identifies a particular Feedback Request.
  • CycleID
    Numeric

    Identifies a Feedback cycle, which is a client-defined group of Feedback templates.

  • CycleName
    String

    The name given to the Feedback cycle. 
  • TemplateID
    String
    Identifies a particular Feedback template.
  • TemplateName
    String
    The name given to the Feedback template. 
  • ConversationID
    Numeric
    Identifies a particular Feedback instance.
  • ConversationParticipantID
    Numeric
    Identifies a particular participant in a Feedback instance.
  • ParticipantTypeID
    Numeric

    Describes if the participant is Self (1), Manager (2), Provider (3), Peers (4), Direct Reports (5), or Administrator (6).

  • StatusDetail
    String
    Describes the current progress of a Feedback instance.
  • GiverUserID
    GUID
    The Quantum Workplace UserID for the employee giving the Feedback.
  • RecipientUserID
    GUID (Users.UserID)
    The Quantum Workplace UserID for the employee receiving the Feedback.
  • Created
    Date
    The date the Feedback was created.
  • Shared
    Date
    The date the Feedback was shared (if applicable).

FeedbackResponse

This contains data related to the Feedback feature in Quantum Workplace. Specifically, it contains responses to Feedback that was requested. UserID is NULL if the Feedback responses are anonymous unless the provider is the manager of the recipient.

  • FeedbackGiverResponseID
    Numeric
    Identifies a particular Feedback Response.

  • CycleID
    Numeric
    Identifies a Feedback cycle, which is a client-defined group of Feedback templates.
  • ConversationID
    Numeric
    Identifies a particular Feedback instance.
  • GiverConversationParticipantID
    Numeric
    Identifies a particular Feedback giver in a Feedback Instance.
  • UserID
    GUID (Users.UserID)

    The Quantum Workplace UserID for the employee giving the Feedback.

  • FeedbackProviderTemplateSegmentName
    String

    Describes the template segment the Feedback provider belongs to.

  • GuestEmailAddress
    String

    The email address for the provider if the Feedback provider is not logged into Quantum Workplace, but instead provides Feedback using a link sent to them.

  • ProviderStatusDetail
    String

    Describes the current progress of a Feedback provider, i.e. Not Started, Started, Shared, Finalized, Opt Out, or Pending Approval.

  • ProviderCreated
    Date

    The date the provider was assigned to the conversation.

  • ProviderShared
    Date

    The date the provider shared the Feedback, if applicable. 

  • QuestionID
    Numeric

    Identifies the question used in the Feedback conversation. 

  • QuestionText
    String

    Describes the question used in the One-on-One conversation.

  • AnswerCode
    Numeric

    The number value assigned to a response, if applicable. 

  • AnswerCodeText
    String

    Describes the number value assigned to a response, if applicable. 

  • FreeFormAnswerOrCommentText
    String

    The text entered by the One-on-One participant, if applicable.

Goals

This contains data related to the Goals feature in Quantum Workplace. Specifically, it contains goal-level data.

  • GoalsID
    Numeric (GoalRoles.GoalsID)
    Identifies a particular goal.
  • GoalName
    String
    Describes a particular goal.
  • CreateDate
    Date
    The date the goal was created.
  • DueDate
    Date
    The date the goal is due. 
  • CompleteDate
    Date
    The date the goal was completed, if applicable.
  • GoalType
    String
    Describes the goal type, i.e. Individual, Organizational, Departmental, or Developmental.
  • PrivacyLevels
    String
    Describes the privacy (to other users) level, i.e. Private or Public.

GoalRoles

This contains data related to the Goals feature in Quantum Workplace. Specifically, it contains data that describes a User’s association to a goal, i.e., Owner, Contributor, or Follower.

  • GoalRolesID
    Numeric
    Identifies a goal-role combination.
  • GoalsID
    Numeric (Goals.GoalsID)
    Identifies a particular goal. 

  • GoalName
    String
    Describes a particular goal.
  • GoalRole
    String
    Describes the User's role on the particular goal, i.e. Owner, Contributor, Follower.
  • UserID
    GUID
    The Quantum Workplace UserID for the goal-role combination.

GoalUpdates (Preview; Prototype)

This contains data related to the Goals feature in Quantum Workplace. Specifically, it contains data that describe progress updates to a goal.

  • GoalUpdatesID
    Numeric
    Identifies a goal update.
  • GoalsID
    Numeric (Goals.GoalsID)
    Identifies a particular goal.
  • GoalName
    String
    Describes a particular goal. 
  • KeyResultID
    Numeric
    Identifies a user-defined important result (key result) that is tracked in the Quantum Workplace Goals feature.
  • KeyResultStartingProgress
    Numeric
    The initial progress of the key result, specified by the user who created the key result.
  • KeyResultCurrentProgress
    Numeric
    The progress provided during an update of the key result.
  • KeyResultTargetProgress
    Numeric
    The target progress for a key result, specified by the user who created the key result. 
  • KeyResultCreateDate
    Date
    The date and time the key result was created.
  • PreviousOnTrackStatus
    String
    Contains the goal status immediately preceding the current progress update.
  • NewOnTrackStatus
    String
    Contains the goal status provided during a progress update.
  • KeyResultProgressUpdateID
    ID
    Identifies a particular progress update to a key result
  • KeyResultUpdateDateCreated
    Date
    The date and time the progress was created.

OneOnOneRequest

This contains data related to the One-On-One feature in Quantum Workplace. Specifically, it contains information about One-On-Ones that were created.

  • OneOnOneRequestID
    String
    Identifies a particular scheduled One-On-One
  • CycleID
    Numeric
    Identifies a One-On-One cycle, which is a client-defined group of One-On-One templates.
  • CycleName
    String
    The name given to the One-On-One cycle. 
  • TemplateID
    Numeric
    Identifies a particular One-On-One template.
  • TemplateName
    String
    The name given to the One-On-One template.
  • ConversationID
    Numeric
    Identifies a particular One-On-One instance.
  • ParticipantType
    String
    Describes if the participant is the Employee or the Facilitator of the One-On-One.
  • CreateDate
    Date
    The date the One-On-One instance was created.
  • ConversationParticipantID
    Numeric
    Identifies a particular participant in a One-On-One instance.
  • UserID
    GUID (Users.UserID)
    The Quantum Workplace UserID for the users participating in the One-On-One.
  • ProgressStatus
    String
    Describes the status of the participant of the One-On-One, i.e. Not Started, Started, Shared, or Finalized.
  • DateShared
    Date
    The date the One-On-One was shared, if applicable.
  • LastChangeDate
    Date
    The date of the last update to the One-On-One ProgressStatus

OneOnOneResponse

This contains data related to the One-On-One feature in Quantum Workplace. Specifically, it contains responses, from both the Employee and the Facilitator, gathered during the One-On-One.

  • OneOnOneResponseID
    Numeric
    Identifies a particular response during a One-On-One.
  • CycleID
    Numeric
    Identifies a One-On-One cycle, which is a client-defined group of One-On-One templates.
  • CycleName
    String
    The name given to the One-On-One cycle.
  • TemplateID
    Numeric
    Identifies a particular One-On-One template.
  • TemplateName
    String
    The name given to the One-On-One template.
  • ConversationID
    Numeric
    Identifies a particular One-On-One instance.
  • ConversationParticipantID
    Numeric
    Identifies a particular participant in a One-On-One instance.
  • ParticipantType
    String
    Describes if the participant is the Employee or the Facilitator of the One-On-One.
  • UserID
    GUID (Users.UserID)
    The Quantum Workplace UserID for the users participant in the One-On-One.
  • DateShared
    Date
    The date the One-On-One was shared, if applicable. 
  • QuestionID
    Numeric
    Identifies the question used in the One-On-One conversation.
  • QuestionText
    String
    Describes the question used in the One-On-One conversation.
  • AnswerCode
    Numeric
    The number value assigned to a response, if applicable.
  • AnswerCodeText
    String
    Describes the number value assigned to a response, if applicable.
  • FreeFormAnswerorCommentText
    String
    The text entered by the One-On-One participant, if applicable. 

RecognitionComments

This contains data related to the Recognitions feature in Quantum Workplace. Specifically, it contains data describing comments made on a Recognitions post.

  • RecognitionCommentID
    Numeric
    Identifies a particular comment on a Recognitions post.
  • PostID
    Numeric
    Identifies a particular Recognition post.
  • DateCreated
    Date
    The date the comment was made.
  • Comment
    String
    The comment the User gave. 
  • CommenterUserID
    GUID (Users.UserID)
    The Quantum Workplace UserID for the one who made the comment.

RecognitionPostLikes

This contains data related to the Recognitions feature in Quantum Workplace. Specifically, it contains data describing likes made on a Recognitions post.

  • PostLikeID
    Numeric
    Identifies a particular like on a Recognition post.
  • DatePosted
    Date
    The date the Recognition post was made.

  • RecognitionText
    String
    The text provided by the user who gave the recognition.
  • GivenByUserID
    GUID (Users.UserID)
    The Quantum Workplace UserID for the user who gave the recognition. 

RecogntionPosts

This contains data related to the Recognitions feature in Quantum Workplace. Specifically, it contains data describing a Recognitions post.

  • RecognitionPostID
    Numeric
    Identifies a particular Recognition post.
  • DatePosted
    Date
    The date the Recognition post was made.
  • RecognitionText
    String
    The text provided by the user who gave the recognition.
  • GivenByUserID
    GUID (Users.UserID)
    The Quantum Workplace UserID for the user who gave the recognition.

RecognitionRecipients

This contains data related to the Recognitions feature in Quantum Workplace. Specifically, it contains data describing the recipient(s) of a Recognitions post.

  • RecognitionRecipientsID
    Numeric
    Identifies a particular Recognition post-the Recipient combination.
  • PostID
    Numeric
    Identifies a particular Recognition post.
  • DatePosted
    Date
    The date the Recognition post was made.
  • UserID
    GUID (Users.UserID)
    The Quantum Workplace UserID for the recipient of the Recognition post.

SurveyGoalpostRequest

This contains data related to the Pulse, Exit, and New-Hire Surveys feature in Quantum Workplace.  It may also contain your Engagement Survey data. (If it does not contain your Engagement Survey data you will find it in SurveySurveyRequest.) Specifically, it contains data describing requests to a User to complete a Pulse Survey. UserID will not be provided for confidential surveys.

  • SurveyGoalpostRequestID
    Numeric
    Identifies a particular request for a User to complete a Pulse Survey.
  • CycleID
    Numeric
    Identifies a particular Pulse Survey.
  • CycleName
    String
    The name of the Pulse Survey.
  • LaunchDate
    Date
    The date the Pulse Survey was launched.
  • ConversationID
    Numeric
    Identifies a particular Pulse Survey instance.
  • ConversationParticipantID
    Numeric
    Identifies a particular participant in a Pulse Survey instance.
  • UserID
    GUID (Users.UserID)
    The Quantum Workplace UserID for the one who was assigned to complete the Pulse Survey.
  • GuestEmailAddress
    String
    The email address for the Pulse Survey taker if the Pulse Survey taker is not logged into Quantum Workplace, but instead had a link sent to them. 
  • ConsideredResponder
    Numeric
    Describes if the Pulse Survey taker was considered a survey responder (1) or not (0).

SurveyGoalpostResponse

This contains data related to the Pulse, Exit, and New-Hire Surveys feature in Quantum Workplace.  It may also contain your Engagement Survey data. (If it does not contain your Engagement Survey data you will find it in SurveySurveyRequest.) Specifically, it contains data describing responses to Pulse Surveys. UserID will not be provided for confidential surveys.

  • SurveyGoalpostResponseID
    Numeric
    Identifies a particular response to a Pulse Survey.
  • CycleID
    Numeric
    Identifies a particular Pulse Survey.
  • CycleName
    String

    The name of the Pulse Survey.
  • LaunchDate
    Date
    The date the Pulse Survey was launched.
  • ConversationID
    Numeric

    Identifies a particular Pulse Survey instance.
  • ConversationParticipantID
    Numeric

    Identifies a particular participant in a Pulse Survey instance.
  • UserID
    GUID (Users.User ID)

    The Quantum Workplace UserID for the one who was assigned to complete the Pulse Survey.
  • GuestEmailAddress
    String

    The email address for the Pulse Survey taker if the Pulse Survey taker is not logged into Quantum Workplace, but instead had a link sent to them. 
  • QuestionID
    Numeric

    Identifies the question used on the Pulse Survey conversation.
  • QuestionText
    String

    Describes the question used on the Pulse Survey conversation.
  • AnswerCode
    Numeric

    The numeric value assigned to a response. 
  • AnswerCodeText
    String

    Describes the numeric value assigned to a response.
  • Favorable
    Numeric

    Flags responses considered favorable, when responses can be considered favorable.
  • FreeFormAnswerOrCommentText
    String

    Contains the text response to the question from the user. 

SurveySurveyRequest

This contains data related to the Engagement Surveys feature in Quantum Workplace. Specifically, it contains data describing requests to a User to complete an Engagement Survey. UserID is NULL if the client chose the confidential survey option during the survey-build process.

  • SurveySurveyRequestID
    Numeric
    Identifies a particular request for a User to complete an Engagement Survey.
  • CycleID
    Numeric
    Identifies a particular Engagement Survey. 
  • CycleName
    String
    The name of the Engagement Survey. 
  • LaunchDate
    Date
    The date the Engagement Survey was launched.
  • ConversationID
    Numeric
    Identifies a particular Engagement Survey instance. 
  • UserID
    GUID (Users.UserID)
    The Quantum Workplace UserID for the one who was assigned to complete the Engagement Survey. 
  • ConsideredResponder
    Numeric
    Describes if the Engagement Survey taker was considered a survey responder (1) or not (0).

SurveySurveyResponse 

This contains data related to the Engagement Surveys feature in Quantum Workplace. Specifically, it contains data describing responses to Engagement Surveys. UserID is NULL if the client chose the confidential survey option during the survey-build process.

  • SurveySurveyResponseID
    String
    Identifies a particular response to an Engagement Survey.
  • CycleID
    Numeric
    Identifies a particular Engagement Survey.
  • CycleName
    String
    The name of the Engagement Survey.
  • LaunchDate
    Date
    The date the Engagement Survey was launched.
  • ConversationID
    Numeric
    Identifies a particular Engagement Survey instance. 
  • UserID
    GUID (Users.UserID)
    The Quantum Workplace UserID for the one who was assigned to complete the Engagement Survey.
  • QuestionID
    Numeric
    Identifies the question used on the Engagement Survey.
  • QuestionText
    String
    Describes the question used on the Engagement Survey.
  • AnswerCode
    Numeric
    The numeric value assigned to a response.
  • AnswerCodeText
    String
    Describes the numeric value assigned to a response.
  • Favorable
    Numeric
    Flags responses considered favorable, when responses can be considered favorable.
  • FreeFormAnswerOrCommentText
    String
    Contains the text responses to the question from the user.

Demographics (Preview; Prototype)

The current employee demographics that have been provided to Quantum Workplace via an integration with the client. These are not point-in-time demographics gathered during surveys or conversations.

  • DemographicID
    String
    The identifier for a demographic record.
  • DemographicAttribute
    String
    The categorization of a particular demographic, e.g. Age, Location, Department.

  • ValueOption
    String
    The value for a particular demographic, e.g. 30 Years, Denver, Sales.
  • UserID
    GUID (Users.UserID)
    The identifier for a user of Quantum Workplace. 

Users

All data can be mapped back to this file, so it serves as the common link across all data. Additionally, it contains the employee ID that is provided by the client. This employee ID will allow the client to connect Quantum Workplace data to the client’s internal data, assuming the client’s internal data also contains the employee ID.

  • UserID
    GUID (Users.UserID)
    The identifier for a user of Quantum Workplace.
  • EmployeeID
    String (Key to your internal data)
    The employee ID provided by the client.
  • Title
    String
    The employee's work title.
  • UserName
    String
    The username used by the User to log in to Quantum Workplace.