Calibration Scoring Detail View
View to get recording data from IR_QForm,IR_QAnswer,IR_QQuestion,IR_QGroup,IR_Questionnaire,IR_QDirectory,IR_RecordingMedia,IR_Event,Individual tables for Calibration Recording Summary report
| Column | Data Type (Size) | Is Nullable | Contains PII | Description | Last Change Version | Last Change Reason |
|---|---|---|---|---|---|---|
| RecordingId | uniqueidentifier | False | Unknown | ID of the recording that this form refers to |
17.4.0.0 | New View for crystal report |
| RecordingDate | datetime | True | Unknown | Time the recording was made |
17.4.0.0 | New View for crystal report |
| MediaType | varchar (7) | True | Unknown |
Media type of recording:
|
17.4.0.0 | New View for crystal report |
| InteractionIdKey | varchar (36) | True | Unknown | ID of the interaction of this recording |
17.4.0.0 | New View for crystal report |
| RecordingLength | int | True | Unknown | Duration of the recording in milliseconds |
17.4.0.0 | New View for crystal report |
| InitiationPolicyName | nvarchar (50) | True | Unknown | Name of the initiation policy that initiated this recording |
17.4.0.0 | New View for crystal report |
| Direction | tinyint | True | Unknown |
Direction of the interaction.
|
17.4.0.0 | New View for crystal report |
| RecordedUserIndivId | char (22) | True | Unknown | Recorded User Individual ID |
17.4.0.0 | New View for crystal report |
| RecordedUserLastName | nvarchar (50) | True | Unknown | Recorded User Last Name |
17.4.0.0 | New View for crystal report |
| RecordedUserFirstName | nvarchar (50) | True | Unknown | Recorded User First Name |
17.4.0.0 | New View for crystal report |
| RecordedUserMiddleName | nvarchar (50) | True | Unknown | Recorded User Middle Name |
17.4.0.0 | New View for crystal report |
| RecordedUserDisplayName | nvarchar (255) | True | Unknown | Recorded User Display Name |
17.4.0.0 | New View for crystal report |
| RecordedUserICUserId | nvarchar (50) | True | Unknown | Recorded User ID |
17.4.0.0 | New View for crystal report |
| WorkgroupQueue | nvarchar (255) | True | Unknown | Work Group Queue |
17.4.0.0 | New View for crystal report |
| QuestionnaireId | uniqueidentifier | False | Unknown | Questionnaire ID |
17.4.0.0 | New View for crystal report |
| QuestionnaireName | nvarchar (255) | False | Unknown | Questionnaire Name |
17.4.0.0 | New View for crystal report |
| QuestionnaireNote | nvarchar (1024) | True | Unknown | Questionnaire Note |
17.4.0.0 | New View for crystal report |
| QuestionnaireMinScore | numeric | True | Unknown | Minimum score of Questionnaire |
17.4.0.0 | New View for crystal report |
| QuestionnaireMaxScore | numeric | True | Unknown | Maximum score of Questionnaire |
17.4.0.0 | New View for crystal report |
| QDirectoryName | nvarchar (255) | True | Unknown | Directory Name |
17.4.0.0 | New View for crystal report |
| QGroupId | uniqueidentifier | False | Unknown | Group ID |
17.4.0.0 | New View for crystal report |
| QGroupSequence | int | False | Unknown | Group Sequence |
17.4.0.0 | New View for crystal report |
| QGroupName | nvarchar (255) | False | Unknown | Question Group Name |
17.4.0.0 | New View for crystal report |
| QGroupNote | nvarchar (1024) | True | Unknown | Question Group Note |
17.4.0.0 | New View for crystal report |
| IsOptional | tinyint | False | Unknown | Is Optional |
17.4.0.0 | New View for crystal report |
| QuestionId | uniqueidentifier | False | Unknown | Question ID |
17.4.0.0 | New View for crystal report |
| QuestionSequence | int | False | Unknown | Question Sequence |
17.4.0.0 | New View for crystal report |
| QuestionText | nvarchar (1024) | False | Unknown | Question Text |
17.4.0.0 | New View for crystal report |
| QuestionType | smallint | False | Unknown | Question Type |
17.4.0.0 | New View for crystal report |
| QuestionPromptType | smallint | False | Unknown | Importance of the question |
17.4.0.0 | New View for crystal report |
| QuestionWeight | numeric | False | Unknown | Weight of Question |
17.4.0.0 | New View for crystal report |
| QuestionMin | numeric | False | Unknown | Minimum Score given to a question |
17.4.0.0 | New View for crystal report |
| QuestionMax | numeric | False | Unknown | Maximum Score given to a question |
17.4.0.0 | New View for crystal report |
| QuestionMinAcceptableScore | numeric | False | Unknown | Minimum Acceptable score of a question |
17.4.0.0 | New View for crystal report |
| QuestionCanMarkNA | tinyint | False | Unknown | Flag to specify whether the question can be marked as N/A |
17.4.0.0 | New View for crystal report |
| FormId | uniqueidentifier | False | Unknown | Form ID |
17.4.0.0 | New View for crystal report |
| ScoredUserLastName | nvarchar (50) | True | Unknown | Scored User Last Name |
17.4.0.0 | New View for crystal report |
| ScoredUserFirstName | nvarchar (50) | True | Unknown | Scored User First Name |
17.4.0.0 | New View for crystal report |
| ScoredUserMiddleName | nvarchar (50) | True | Unknown | Scored User Middle Name |
17.4.0.0 | New View for crystal report |
| ScoredUserICUserId | nvarchar (50) | True | Unknown | Scored UserID |
17.4.0.0 | New View for crystal report |
| ScoredUserIndivID | char (22) | True | Unknown | Scored User IndividualID |
17.4.0.0 | New View for crystal report |
| ScoringUserLastName | nvarchar (50) | True | Unknown | Scoring User Last Name |
17.4.0.0 | New View for crystal report |
| ScoringUserFirstName | nvarchar (50) | True | Unknown | Scoring User First Name |
17.4.0.0 | New View for crystal report |
| ScoringUserMiddleName | nvarchar (50) | True | Unknown | Scoring User Middle Name |
17.4.0.0 | New View for crystal report |
| ScoringUserICUserId | nvarchar (50) | True | Unknown | Scoring UserID |
17.4.0.0 | New View for crystal report |
| ScoringUserIndivId | char (22) | True | Unknown | Scoring User IndividualID |
17.4.0.0 | New View for crystal report |
| CombinedMaxScore | numeric | True | Unknown | Combined Maximum Score |
17.4.0.0 | New View for crystal report |
| CombinedMinScore | numeric | True | Unknown | Combined Minimum Score |
17.4.0.0 | New View for crystal report |
| CombinedScore | numeric | False | Unknown | Combined Score |
17.4.0.0 | New View for crystal report |
| CombinedPercentileScore | numeric | True | Unknown | Combined Percentile Score of User |
17.4.0.0 | New View for crystal report |
| RankName | nvarchar (40) | True | Unknown | Rank Name of User |
17.4.0.0 | New View for crystal report |
| NonCriticalMaxScore | numeric | True | Unknown | Noncritical Maximum Score of the User |
17.4.0.0 | New View for crystal report |
| NonCriticalMinScore | numeric | True | Unknown | Noncritical minimum Score of the User |
17.4.0.0 | New View for crystal report |
| NonCriticalScore | numeric | True | Unknown | Noncritical Score of the User |
17.4.0.0 | New View for crystal report |
| NonCriticalPercentileScore | numeric | True | Unknown | Noncritical Percentile Score |
17.4.0.0 | New View for crystal report |
| TotalNumCriticalQuestions | int | False | Unknown | Total number of Critical Questions |
17.4.0.0 | New View for crystal report |
| NumAnsweredCriticalQstns | int | True | Unknown | Number of Answered Critical Questions |
17.4.0.0 | New View for crystal report |
| NumPosAnsweredCriticalQstns | int | True | Unknown | Number of positively answered critical questions |
17.4.0.0 | New View for crystal report |
| CriticalScore | numeric | True | Unknown | Critical Score of the User |
17.4.0.0 | New View for crystal report |
| IsFailed | tinyint | True | Unknown | Flag to display whether the user is passed or failed |
17.4.0.0 | New View for crystal report |
| UsingForCalibration | tinyint | False | Unknown | Flag to display whether the scorecard is marked for Calibration or not |
17.4.0.0 | New View for crystal report |
| AnswerScore | numeric | True | Unknown | Score of the given answer |
17.4.0.0 | New View for crystal report |
| RawAnswer | nvarchar (1024) | True | Unknown | Raw Answer of question |
17.4.0.0 | New View for crystal report |
| DisplayAnswer | nvarchar (255) | True | Unknown | Display answer for the question |
17.4.0.0 | New View for crystal report |
| UserComments | nvarchar (1024) | True | Unknown | User Comments |
17.4.0.0 | New View for crystal report |
| IsMarkedNA | tinyint | False | Unknown | Flag to determine whether Question is marked as N/A or not |
17.4.0.0 | New View for crystal report |
| QDirectoryId | uniqueidentifier | False | No | Directory ID |
17.4.0.0 | New View for crystal report |