Contents

Calibration Recording Summary

The Calibration Recording Summary report aggregates scores across all the scorecards for a specific questionnaire and identifies anomalies in the responses.

The detailed information in the report includes:

Questionnaire Directory
Questionnaire Name
Questionnaire Notes
Media Type
Recorded Date
Recording ID
Interaction ID Key
Initiation Policy
Recording Length
Direction
Number of Scorecards of Questionnaire
Average Score of Questionnaire
Median Score of Questionnaire
Highest Score of Questionnaire
Lowest Score of Questionnaire
Score Variance of Questionnaire
Number of Scorecards by user for Group
Highest Score by user for Group
Average Score by user for Group
Lowest Score by user for Group
Median Score by user for Group
Score Variance by user for Group

Parameters

The following parameters can be specified for the Calibration Recording Summary report.

Required Parameters

Date Time Range
Directory
Questionnaire Name

Additional Parameters

Interaction ID Key
Media Type
Recording ID
Scored User
Scoring User
Workgroup Queue

Parameter Descriptions

Parameter	Parameter Type	Required/Optional	Description
Date Time Range	Filter	Required	The date and time range bounds
Directory	Filter	Required	Directory where Questionnaire resides
Questionnaire name	Filter	Required	Questionnaire Name to filter by
Interaction ID Key	Filter	Optional	Interaction ID Key to filter by
Media Type	Filter	Optional	Media type to filter by: Generic, Call, Chat, Email, Fax, Screen, Social Conversation, Social Direct Message, or <All>
Recording ID	Filter	Optional	Recording ID to filter by
Scored User	Filter	Optional	Scored User to filter by
Scoring User	Filter	Optional	Scoring user to filter by
Workgroup Queue	Filter	Optional	Workgroup queue to filter by

Sample Report

Click on the image below to view a sample of this report.

Report Element Descriptions

Report Element	Database Column or Computation	Details
Questionnaire Directory	QDirectoryname	Questionnaire Directory Name
Questionnaire Name	QuestionnaireName	Questionnaire name
Questionnaire Notes	QuestionnaireNote	Questionnaire notes
Media Type	MediaType	Media type for Recorder NONE = 0 CALL = 1 CHAT = 2 EMAIL = 3 FAX = 4 SCREEN = 5 CHATTRANSCRIPT = 6
Recorded Date	RecordingDate	Recorded date
Recording ID	RecordingId	Recorded ID
Interaction ID Key	InteractionIdKey	Interaction ID key
Initiation Policy	InitiationPolicyName	Initiation Policy
Recording length	RecordingLength	Recording Length is formatted by a CRUFL function MillisecondsToHHMMSS()
Direction	Direction	0 = UNKNOWN 1 = INBOUND 2 = OUTBOUND 3 = INTERCOM else INVALID_VALUE
Number of Scorecards of Questionnaire	Count(FormId), Questionnaire	Calculated based on formula
Highest Score of Questionnaire	Maximum(CombinedPercentileScore) of Questionnaire	Calculated based on formula
Average Score of Questionnaire	Average(ComginedPercentileScore) of Questionnaire	Calculated based on formula
Lowest Score of Questionnaire	Minimum(CombinedPercentileScore) of Questionnaire	Calculated based on formula
Median Score of Questionnaire	Median(CombinedPercentileScore) of Questionnaire	Calculated based on formula
Score Variance of Questionnaire	Variance(CombinedPercentileScore)of Questionnaire	Calculated based on formula
Number of Scorecards by user for Group	Count(FormId), Questionnaire/QuestionGroup	Calculated based on formula
Highest Score by user for Group	Highest Score by user calculated based on Score formula	Calculated based on formula
Average Score by user for Group	Average Score by user calculated based on Score formula	Calculated based on formula
Lowest Score by user for Group	Lowest Score by user calculated based on Score formula	Calculated based on formula
Median Score by user for Group	Median Score by user calculated based on Score formula	Calculated based on formula
Score Variance by user for Group	Score variance by user calculated based on Score formula	Calculated based on formula

Stored Procedure

SPRPT_CRQUESTIONGROUPSCORES

Tables/Views

ScoringDetail_viw
IR_RecordingMedia
IR_QGroup
IR_Event
IR_Questionnaire
IR_QDirectory
IR_QQuestionEnum