Survey Question Score DMO

SurveyQuestionScore stores pre-aggregated scores and counts (score, response count, skip count, score type) per survey question and invitation. It’s used so reporting and analytics can use these aggregates instead of recomputing from raw question responses.

Object API Name: std__SurveyQuestionScoreDmo__dlm
Category: Unassigned
Availability: Available in 262 and later versions
Primary Key Field: Id

• SurveyQuestionId has a FOREIGNKEY relationship with the Survey Question DMO Id field.
• SurveyVersionId has a FOREIGNKEY relationship with the Survey Version DMO Id field.
• SurveyId has a FOREIGNKEY relationship with the Survey DMO Id field.
• SurveyInvitationId has a FOREIGNKEY relationship with the Survey Invitation DMO Id field.
• SurveyQuestionChoiceId has a FOREIGNKEY relationship with the Survey Question Choice DMO Id field.

• cdp_sys_record_currency
• CreatedById
• CreatedDateTime
• CumulativeScoreNbr
• DataSourceId
• DataSourceObjectId
• Id
• InternalOrganizationId
• KQ_Id
• KQ_SurveyId
• KQ_SurveyInvitationId
• KQ_SurveyQuestionChoiceId
• KQ_SurveyQuestionId
• KQ_SurveyVersionId
• LastModifiedById
• LastModifiedDateTime
• QuestionDeveloperName
• QuestionName
• QuestionScoreType
• QuestionSkippedCount
• ResponseCount
• ResponseDateTime
• ResponseValueNbr
• ScoreName
• ScoreNbr
• SurveyId
• SurveyInvitationId
• SurveyQuestionChoiceId
• SurveyQuestionId
• SurveyVersionId

• Field API Name: std__cdp_sys_record_currency__c
• Data Type: TEXT
• Description: System-generated metadata field that stores a 3-letter ISO currency code.

• Field API Name: std__CreatedById__c
• Data Type: TEXT
• Description: The user who created this record.

• Field API Name: std__CreatedDateTime__c
• Data Type: DATETIME
• Description: The date and time when this record was created.

• Field API Name: std__CumulativeScoreNbr__c
• Data Type: DOUBLE
• Description: The cumulative score value.

• Field API Name: std__DataSourceId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__DataSourceObjectId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__Id__c
• Data Type: TEXT
• Description: Required. A unique, system-generated identifier for this SurveyQuestionScore record. Maximum size is 15 characters.

• Field API Name: std__InternalOrganizationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__KQ_Id__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__KQ_SurveyId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__KQ_SurveyInvitationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__KQ_SurveyQuestionChoiceId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__KQ_SurveyQuestionId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__KQ_SurveyVersionId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__LastModifiedById__c
• Data Type: TEXT
• Description: The user who last modified this record.

• Field API Name: std__LastModifiedDateTime__c
• Data Type: DATETIME
• Description: The date and time when a user last modified this record.

• Field API Name: std__QuestionDeveloperName__c
• Data Type: TEXT
• Description: The developer name of the question.

• Field API Name: std__QuestionName__c
• Data Type: TEXT
• Description: The name of the question.

• Field API Name: std__QuestionScoreType__c
• Data Type: TEXT
• Description: The type of question score.

• Field API Name: std__QuestionSkippedCount__c
• Data Type: DOUBLE
• Description: The number of times the question was skipped.

• Field API Name: std__ResponseCount__c
• Data Type: DOUBLE
• Description: The count of responses.

• Field API Name: std__ResponseDateTime__c
• Data Type: DATETIME
• Description: The date and time of the response.

• Field API Name: std__ResponseValueNbr__c
• Data Type: DOUBLE
• Description: The response value.

• Field API Name: std__ScoreName__c
• Data Type: TEXT
• Description: The name of the score.

• Field API Name: std__ScoreNbr__c
• Data Type: DOUBLE
• Description: The score value.

• Field API Name: std__SurveyId__c
• Data Type: TEXT
• Description: The ID of the survey.

• Field API Name: std__SurveyInvitationId__c
• Data Type: TEXT
• Description: The ID of the survey invitation.

• Field API Name: std__SurveyQuestionChoiceId__c
• Data Type: TEXT
• Description: The ID of the survey question choice.

• Field API Name: std__SurveyQuestionId__c
• Data Type: TEXT
• Description: The ID of the survey question.

• Field API Name: std__SurveyVersionId__c
• Data Type: TEXT
• Description: The ID of the survey version.