Intelligence Data Feeds
      Back to home
      1. Help Library
      2. Intelligence
      3. Intelligence Data Feeds

      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 Quantum Workplace 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?

      The 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 once a day, 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. Learn more about confidential surveys and confidentiality settings.

      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

      As a Quantum Workplace admin, to access Data Feed settings:

      1. Click and expand Administration in the left-hand navigation menu
      2. Click Integrations
      3. Click the Data Feed card

      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: Talent Review data is collected via a specialized Feedback cycle and can be found under Feedback.

      When data are refreshed, they include all historical data, not just the 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. 
      • Title
        String
        The name given to an instance of feedback. Users can, but are not required to, use the CycleName or TemplateName as the Title.
      • 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.
      • Title 
        String
        The name given to an instance of feedback. Users can, but aren't required to, use the CycleName or TemplateName as the Title.
      • 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.
      • GoalStatus
        String
        Describes the status of a goal. May have a value of Draft, Active, or Abandoned.
      • GoalCategory
        String
        Describes the goal category if one is assigned, will be NULL if not assigned.

      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 (Deprecated)

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

      This table is deprecated and has been replaced with GoalProgress and GoalKeyResultProgress. 

      • 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.
      • KeyResultsName
        Numeric 
        The name of a Key Result, defined by the user, associated with a goal. 
      • 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 a progress update was created.

      GoalProgress

      This contains data related to the Goals feature in Quantum Workplace. Specifically, it is a log of every addition or updates to the on-track status of a goal, independent of any updates to key results. 

      • GoalsID
        Numeric (Goals.GoalsID)
        Identifies a particular goal.
      • PreviousOnTrackStatus
        String
        Contains the goal status immediately preceding the current progress update.
      • NewOnTrackStatus
        String
        Contains the goal status provided during a progress update.
      • ProgressUpdateID
        Numeric
        Identifies a goal progress update.
      • ProgressUpdateDateCreated
        Date
        The date and time a progress update was created. 

      GoalKeyResultProgress

      This contains data related to the Goals feature in Quantum Workplace. Specifically, it is a log of every addition or update to the goal of a key result, independent of any updates to the overall goal progress. 

      • GoalsID
        Numeric (Goals.GoalsID)
        Identifies a particular goal.
      • KeyResultsID
        Numeric
        Identifies a user-defined important result (key result) that is tracked in the Quantum Workplace Goals feature. 
      • KeyResultsName
        Numeric
        The name of a Key Result, defined by the user, associated with a goal. 
      • ProgressUpdateID
        Numeric

        Identifies a goal progress update. If a key result is updated without updating the goal progress, then ProgressUpdateID is 0.

      • 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 a key result was created.
      • KeyResultProgressDateCreated
        Date
        The date of a key result was updated.

      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.
      • Title 
        String
        The name given to a One-On-One template. Users can, but aren't required to, use the CycleName or TemplateName as the Title.
      • 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.
      • Title 
        String
        The name given to a One-On-One instance. Users can, but aren't required to, use te CycleName or TempalteName as the Title.
      • 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.
      • PostID
        Numeric
        Identifies a particular Recognition post. 

      • DateCreated
        Date
        The date when the like was given on a Recognition post.

      • LikedByUserID
        GUID (Users.UserID)
        The Quantum Workplace UserID for the one who liked the Recognitions post.

      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.
      • BadgeName
        String
        The badge assigned to the Recognition post, by the sure 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.