Transcription
Interaction Quality ManagementData DictionaryTechnical Reference2019 R3Last updated September 2019AbstractThis Technical Reference provides a concise and detailed description of the database tables CIC uses tostore and generate reports on Interaction Recorder data. This document assists you in understandingthe structure and content of these tables.
IQ Data DictionaryThis document contains the data dictionaries for Quality Management products. Tableof Contents (detailed):RecorderIR AccessControl TableIndexesIR ArchiveContent TableIndexesIR ArchiveVolumeDescriptor TableIndexesIR Audit TableIndexesExplanation of AuditOperationDescription of Audit CommentsIR CustomAttribute TableIndexesIR CustomAttributeName TableIndexesIR Event TableIndexesExplanation of EventTypeIR EventKeywordInfo TableIndexesIR Keyword TableIndexesIR KeywordSet TableIndexesIR QAnswer TableIndexesIR QDirectory TableIndexesIR QForm TableIndexesExplanation of ScoringStateExplanation of IsFailedExplanation of SignoffStateExplanation of UsingForCalibrationIR QGroup TableIndexesIR QQuestion TableIndexesExplanation of QuestionTypeExplanation of QuestionPromptTypeIR QQuestionEnum TableIndexesIR Questionnaire TableIndexesIR RankDefn TableIndexesIR RankGroup TableIndexesIR RecordingMedia TableIndexesExplanation of MediaTypeExplanation of DirectionExplanation of CallTypeExplanation of RecordingTypeIR RecordingMediaSnippets TableIndexesIR RecordingWork TableIndexesIR SecurityPolicy TableIndexesIR SocialMediaRecording TableIndexesExplanation of PlatformIR Tag TableIndexes
IR TagMap TableIndexesRecorderThis is a Data Dictionary for PureConnect Interaction Recorder.IR AccessControl TableThe IR AccessControl table contains security policies that apply to a given recording.Column erNoID of the recording.GASecurityPolicyIdUniqueIdentifierNoID of the security policy.GAIndexesPrimary Key: RecordingId SecurityPolicyIdForeign Keys: RecordingIdAdditional Indexes:IR ArchiveContent TableThe IR ArchiveContent table contains the set of recordings that make up an archive volume.Column erNoID of the recording.SU03ArchiveIdUniqueIdentifierNoID of the archive volume.SU03ArchivedDateDateTimeNoDate that the recordingwas archived.SU03ArchivedDateOffsetIntegerNoUTC offset of the archivedate.SU03IndexesPrimary Key: RecordingId ArchiveId ArchivedDateForeign Keys: RecordingId, ArchiveIdAdditional Indexes:IR ArchiveVolumeDescriptor TableThe IR ArchiveVolumeDescriptor table contains the archive volumes.Column NoID of the archive volume.SU03VolumeNameNVarChar(128)NoName of the volume.SU03VolumeDTDateTime2(7)NoDate that the volume wascreated.SU03VolumeDTOffsetIntegerNoUTC offset of the volumecreated date.SU03ArchiveStartDTDateTime2(7)YesDate that archivingstarted.SU03
ArchiveEndDTDateTime2(7)YesDate that archivingended.SU03MediaURINVarChar(1024)YesURI where the volumewas created.SU03IndexesPrimary Key: ArchiveIdForeign Keys:Additional Indexes:IR Audit TableThe IR Audit table contains a history of audited events events in Interaction Recorder.Column ID of the audit record.GAIdUniqueIdentifierNoID of the entity beingaudited.GAAuditDateDateTimeNoTime that the auditedevent occured.GAAuditDateOffsetIntegerNoUTC offset of the auditdate.GAAuditOperationSmallIntNoOperation that occurred.(See below)GAIndivIdChar(22)YesIndividual ID of the userwho performed theoperation.GAICUIDNVarChar(255)YesThe IC User ID of theuser who performed theoperation.GAAuditedNameNVarChar(255)YesDisplay name of the userwho performed n of theoperation beingperformed.GAVersionIntegerNoVersion of the databaserow.GAIndexesPrimary Key: AuditIdForeign Keys: IndivId, IdAdditional Indexes:Explanation of AuditOperationAuditOperation can be one the following values:ValueDescription10Played recording.11Downloaded recording.12Emailed recording.14Modified recording.ReleaseHas Commentsyes
15Deleted recording.16Archived recordingSU317Retention Expiration modifiedoutside of retention policies2019R150Began scoring.52Updated scorecard.53Finished scoring.54Deleted scorecard.59Created master key.60Activated master key password.SU461Revoked master key password.SU462Changed master key password.SU463Added master key password.SU464Removed master key password.SU465Interaction was monitoredthrough recorderSU470Added a questionnaireSU671Updated a questionnaireSU672Deleted a questionnaireSU680Modify a policy2015r181Re-eval all retention policies2015r182Re-eval some retention policies2015r183Re-eval all security policies2015r184Re-eval some security policies2015r185Re-eval all retention policies(legacy)2015r186Re-eval some retention policies(legacy)2015r187Re-eval policies started2015r188Re-eval policies complete2015r189Re-eval retention policies startedCIC 2015 R490Re-eval retention policiescompleteCIC 2015 R491Re-eval retention policiescanceledCIC 2015 R492Re-eval security policies startedCIC 2015 R493Re-eval security policiescompleteCIC 2015 R494Re-eval security policiescanceledCIC 2015 R4Description of Audit CommentsyesSU5yesyesyesyes
CodeExampleDefinition T T AgentThe tag was added to the recording-T-T AgentThe tag was removed from the recording A A Age 15The attribute and value was added to therecording A A Age 20The attribute value was modified-A-A AgeThe attribute was removed V VOld00001The recording was archived to the volume ScSS ScSSScorecard signature state changed ScSC ScSCScorecard signature comments modified-MC-MCMonitored interaction was coaching-MJ-MJMonitored interaction was joined-ML-MLMonitored interaction was listened to-Sc-ScScorecard with audit event RR RR 20150101 04:00:00 2015020103:59:59 Retention policy re-evaluation range SR SR 20150101 04:00:00 2015020103:59:59 Security policy re-evaluation range RA RA 20150101 Retention re-evaluation after date P P Record all callsNamed policy was added P P Record all callsNamed policy was modified-P-P Record all callsNamed policy was deleted SPRC SPRC x,ySecurity Policy re-evaluation completingwhere x current policy and y total numberof policies B B x , y , [z]Bookmark was added to the recording wherex bookmark start time, y bookmark endtime and z bookmark text B B x , y , [z]Bookmark was modified on the recordingwhere x bookmark start time, y bookmarkend time and z bookmark text-B-B x , y , [z]Bookmark was remove from the recordingwhere x bookmark start time, y bookmarkend time and z bookmark text RRE RRE 2018-12-03 21:56:13Recording Retention Expiration date that thewas set for a recording outside of theretention policies from a client-sideapplicationIR CustomAttribute TableThe IR CustomAttribute table contains values for interaction attributes captured on recordings.Column erNoID of the recording who'sinteraction had the value.GA
CustomAttributeNameIdIntegerNoID of the name of thecustom attribute. Eachname is stored uniquelyin theIR ue of the attribute.GAVersionIntegerNoVersion of the databaserow.GAIndexesPrimary Key: RecordingId CustomAttributeNameIdForeign Keys: RecordingId, CustomAttributeNameIdAdditional Indexes:IR CustomAttributeName TableThe IR CustomAttributeName table contains the names of custom attributes captured on recordings. These names can be referenced by manyrecordings.Column gerNoID of the custom attributename.GANameNVarChar(255)NoName of the customattribute.GAIndexesPrimary Key: CustomAttributeNameIdForeign Keys:Additional Indexes: NameIR Event TableThe IR Event table contains events that happened during the recording of the interaction.Column NameTypeNullDescriptionSUEventIdIntegerNoID of the event.GARecordingIdUniqueIdentifierNoID of the recording wherethis event happened.GAEventTypeSmallIntNoType of event thathappened. (See below)GAEventDateDateTime2NoTime that the eventoccured.GAEventDateOffsetIntegerNoUTC offset of the eventdate.GADurationIntegerYesDuration of the event inmilliseconds.GAIndivIdChar(22)YesIndividual ID of the userassociated with thisevent.GAIntxIdChar(22)YesID of the interactionsegment associated withthis event.GA
Intx Part IdChar(22)YesID of the participantassociated with thisevent.GADisplayNameNVarChar(255)YesDisplay name of the userassociated with thisevent.GAIsInternalParticipantTinyIntNoIs the associatedparticipant internal? Oneif true else zero.GAConnValueNVarChar(255)YesFor the Connect andParty Added events. Theconnection value of p of the agenton who the recording wasinitiated.GAInitiatedForTinyIntNoFor the Connect event, isthis the participant therecording was initiatedfor. One if true else zero.GAVersionIntegerNoVersion of the databaserow.GANotesNVarChar(1024)YesNotes about the event.For annotations this is thetext body of theannotation.GAKeywordIdIntegerYesFor keyword spots. TheID of the keyword thatwas spotted. Each nameis stored uniquely in theIR Keyword table.GAKeywordChannelTinyIntYesFor keyword spots. Thechannel on which thekeyword was spotted.GAKeywordScoreSmallIntYesFor keyword spots. Thescore given to that spot.SU03KeywordUtteranceVarChar(1024)YesFor keyword spots. Theutterance detected forthat spotSU05KeywordConfidenceNumeric(19,15)YesFor keyword spots. Theconfidence level at whichthat spot was detectedSU05IndexesPrimary Key: EventIdForeign Keys: RecordingId, IndivId, IntxId, Intx Part Id, KeywordIdAdditional Indexes: EventDate, IndivId, Intx Part Id, IntxId, KeywordId, (RecordingId, EventType, Duration), (EventType, RecordingID,EventId), (EventType, KeywordConfidence, RecordingID)Explanation of EventTypeEventType can be one the following values:ValueDescriptionSUTime Auth0Participant connected.GAIC1Call went on hold.GAIC
2Bookmark on the recording.IC3Keyword spot on the recording.Media4Recording started on the mediaserver.SU02Media5Secure pauseSU03IC6Secure IVRSU03IC7Wrapup CodeSU04IC8TransferSU05IC9Snippet Request2016r3IC10Park2018r1ICIR EventKeywordInfo TableColumn NameTypeNullDescriptionSUEventIdIntegerNoThe EventId from thecorresponding IR Eventrow entry2015r4KeywordSetIdIntegerNoThe KeywordSetId fromthe correspondingIR KeywordSet row entry2015r4IndexesPrimary Key: EventIdForeign Keys: EventId, KeywordSetIdAdditional Indexes: KeywordSetIdIR Keyword TableThe IR Keyword table contains the names of keywords that were spotted on the recording. These names can be referenced by many recordings.Column NameTypeNullDescriptionSUKeywordIdIntegerNoID of the keyword.GAKeywordNameNVarChar(128)NoName of the keyword.GAIndexesPrimary Key: KeywordIdForeign Keys:Additional Indexes:IR KeywordSet TableColumn NameTypeNullDescriptionSUKeywordSetIdIntegerNoID the keyword set entry.2015r4DisplayNameNVarChar(128)NoDisplay Name of thekeyword set2015r4CategoryNVarChar(128)YesCategory of the keywordset2015r4Indexes
Primary Key: KeywordSetIdForeign Keys:Additional Indexes: DisplayName, CategoryIR QAnswer TableThe IR QAnswer table contains answers to a question on a questionnaire.Column NoID of the answer.GAQFormIdUniqueIdentifierNoID of the form thatcontains this answer.GAQQuestionIdUniqueIdentifierNoID of the question thatwas answered.GASequenceIntegerNoSequence number of theanswer within the form.GAScoreNumeric(19,6)YesScore given to theanswer.GARawAnswerNVarChar(1024)YesRaw text input of theanswer.GAUserCommentsNVarChar(1024)YesComments provided withthe answer.GAIsMarkedNATinyIntNoWas the answer markedN/A? One if true elsezero.GAVersionIntegerNoVersion of the databaserow.GAIndexesPrimary Key: QAnswerIdForeign Keys: QFormId, QQuestionIdAdditional Indexes: QFormId QQuestionId SequenceIR QDirectory TableThe IR QDirectory table contains questionnaires directories. Questionnaires are contained in these directories.Column ierNoID of the directory.GAQDirectoryNameNVarChar(255)YesName of the directory.GANoteNVarChar(1024)YesNotes about the directory.GAIsTemplateTinyIntNoIs the directory atemplate? One if true elsezero. (Reserved for lateruse)GAVersionIntegerNoVersion of the databaserow.GAIndexesPrimary Key: QDirectoryIdForeign Keys:Additional Indexes:
IR QForm TableThe IR QForm table contains saved and completed forms for a questionnaire.Column ID of the form.GAQuestionnaireIdUniqueIdentifierNoID of the questionnairethis form providesanswers to.GARecordingIdUniqueIdentifierYesID of the recording thatthis form refers to.GAScoringIndivIdChar(22)YesIndividual ID of the userwho is scoring therecording.GATargetIndivIdChar(22)YesIndividual ID of the userbeing scored.GATargetIntx Part IdChar(22)YesParticipant ID on theinteraction of the userbeing scored.GAScoringStateIntegerNoScoring state of the form.(See below)GAScoreNumeric(19,6)NoTotal score of the form.GARankNameNVarChar(40)YesName of the rank given tothe form based on it'sscore.GAMaxScoreNumeric(19,6)YesMaximum score of allanswers scored for theform.GAMinScoreNumeric(19,6)YesMinimum score of allanswers scored for theform.GAScoringDateDateTimeYesTime the form was lastscored and saved.GAScoringDateOffsetIntegerYesUTC offset of the scoringdate.GAAssignedDescNVarChar(1024)YesName of the RecorderPolicy that caused theform to be l maximum score ofall non-critical questionsanswered for the form.GANonCriticalMinScoreNumeric(19,6)YesTotal minimum score ofall non-critical questionsanswered for the form.GANonCriticalScoreNumeric(19,6)YesTotal score of allnon-critical questionsanswered for the form.GA
CriticalAccuracyScoreNumeric(19,6)YesStores the criticalaccuracy percentage(0.00 – 100.00) ofpositively answeredcritical questions dividedby the total number ofcritical questionsanswered within ber of criticalquestions mber of positivelyanswered criticalquestions.GAIsFailedTinyIntYesIndicates whether thescorecard has beenmarked Pass or Fail.NULL for non-pass/failquestionnaires. (Seebelow)GAUsingForCalibrationTinyIntNoWas this form used forcalibration. (See tablebelow)GASignoffStateTinyIntYesState of the sign-offprocess. (See below)SU03SignoffCommentsNVarChar(2000)YesComments about thesign-off.SU03VersionIntegerNoVersion of the databaserow.GAIndexesPrimary Key: QFormIdForeign Keys: QuestionnaireId, RecordingId, ScoringIndivId, TargetIndivId, TargetIntx Part IdAdditional Indexes:Explanation of ScoringStateScoringState can be one the following values:ValueDescription0None. Scoring has not yet started.1Assigned. Questionnaire Scorecard has been assigned but notstarted.2Incomplete. Questionnaire Scorecard has been saved but notfinished.3Finished.Explanation of IsFailedIsFailed can be one the following values:ValueDescriptionNULLNot marked passed or failed. Either the questionnaire is not pass/failor the scorecard has not been finished.0Scorecard passed.1Scorecard failed.
Explanation of SignoffStateSignoffState can be one the following values:ValueDescriptionNULLSign-off process has not yet started.0Sign-off process is in progress.1Sign-off process has completed.Explanation of UsingForCalibrationUsingForCalibration can be one of the following values:ValueDescription0Not marked for calibration.1Marked for calibration.2Required for calibration. Set via a policy or assigned via the recordermodule.Note: 0 Not marked for calibration and 0 Marked for calibration.IR QGroup TableThe IR QGroup table contains groups that hold questionnaire questions. Questionnaires are composed of groups. Those groups containquestions.Column oID of the group.GAQuestionnaireIdUniqueIdentifierYesID of the questionnairethat contains this group.GAGroupNameNVarChar(255)NoName of the group.GASequenceIntegerNoSequence number of thegroup within thequestionnaire.GANoteNVarChar(1024)YesNotes for the group.GAIsOptionalTinyIntNoIs the group optional?One if true else zero.GAIsTemplateTinyIntNoIs the group a template?One if true else zero.(Reserved for later use)GAVersionIntegerNoVersion of the databaserow.GAIndexesPrimary Key: QGroupIdForeign Keys: QuestionnaireIdAdditional Indexes:IR QQuestion TableThe IR QQuestion table contains questions in a questionnaire. Questions belong to groups (IR QGroup) who in turn belong to questionnaires.
Column erNoID of the question.GAQGroupIdUniqueIdentifierNoID of the group thatcontains this question.GAQuestionTextNVarChar(1024)NoQuestion text. Thequestion beingasked/stated.GAQuestionTypeSmallIntNoType of question. (Seebelow)GAQuestionPromptTypeSmallIntNoSpecifies if the questionis required. (See below)GAHelpTextNVarChar(1024)YesText to help clarify thequestion and how toanswer.GAWeightNumeric(19,6)NoWeight placed on thequestion (-100.00 to100.00)GASequenceIntegerNoSequence number of thequestion within the group.GAMaxScoreNumeric(19,6)NoMaximum score aninteger/decimal questioncan have.GAMinScoreNumeric(19,6)NoMinimum score aninteger/decimal questioncan have.GAMinAcceptableScoreNumeric(19,6)NoMinimum acceptablescore the question canhave. (Reserved for lateruse)GANoteNVarChar(1024)YesNotes about the question.GAIsTemplateTinyIntNoIs the question atemplate? One if true elsezero. (Reserved for lateruse)GAHasCommentFieldTinyIntNoShould a comment fieldbe displayed with thequestion? One if true elsezero.GACanMarkNATinyIntNoCan the question bemarked N/A? One if trueelse zero.GAVersionIntegerNoVersion of the databaserow.GAIndexesPrimary Key: QQuestionIdForeign Keys: QGroupIdAdditional Indexes:Explanation of QuestionTypeQuestionType can be one the following values:ValueDescription
1Free text question. (non-scoring)2Integer question.3Decimal question.10True / false question.11Multiple choice question.Explanation of QuestionPromptTypeQuestionPromptType can be one the following values:ValueDescription0None.1Optional question.2Required question.3Critical question.IR QQuestionEnum TableThe IR QQuestionEnum table contains enumerations for true/false and multiple choice questions. Also contains min/max values for numericquestions.Column erNoID of the questionassociated with thisenumeration.GASequenceIntegerNoSequence number of theenumeration within thequestion.GAEnumTextNVarChar(255)NoText displayed for theenumerated choice.GAHelpTextNVarChar(1024)YesHelp text displayed withthe enumerated choice.GAScoreNumeric(19,6)NoScore given if theenumerated choice isselected.GAVersionIntegerNoVersion of the databaserow.GAIndexesPrimary Key: QQuestionId SequenceForeign Keys:Additional Indexes:IR Questionnaire TableThe IR Questionnaire table contains questionnaires used to score recordings for quality assurance purposes.Column tifierNoID of the questionnaire.GAQDirectoryIdUniqueIdentifierNoID of the directory thisquestionnaire belongs to.GA
QuestionnaireNameNVarChar(255)NoName of D of the rank group usedto rank forms producedby this questionnaire.GAMaxScoreNumeric(19,6)YesMaximum score thequestionnaire can have.GAMinScoreNumeric(19,6)YesMinimum score thequestionnaire can have.GAMinAcceptableScoreNumeric(19,6)YesMinimum acceptablescore the questionnairecan have. (reserved forlater use)GANoteNVarChar(1024)YesNotes for thequestionnaire.GAIsTemplateTinyIntNoIs the questionnaire atemplate? One if true elsezero. (reserved for lateruse)GAIsLockedTinyIntNoIs the questionnairelocked? Called 'published'in the Recorder Client.Once a questionnaire ispublished it cannot beedited and can be usedfor scoring.GAShowRankWhileScoringTinyIntNoShould the rank bedisplayed while scoring?One if true else zero.GATotalNumCriticalQuestionsIntegerNoTotal number of criticalquestions in thequestionnaire.GAVersionIntegerNoVersion of the databaserow.GAIsActiveTinyIntNoIs the questionnaireactive? If thequestionnaire is notactive it is not editable orused for scoring. It is onlythere to be displayed withexiting forms. One if trueelse zero. (reserved forlater use)GAShowPassFailWhileScoringTinyIntNoWhile scoring the form,displays the pass/failoption on a scorecard.One if true else zero.GAIndexesPrimary Key: QuestionnaireIdForeign Keys: QDirectoryId, RankGroupIdAdditional Indexes:IR RankDefn TableThe IR RankDefn table contains an individual rank within a rank group. If a questionnaire form's score is less than the rank's percentage butgreater than any other rank then the form is assigned this rank. Interaction Feedback surveys also use these ranks.
Column D of the rank.GARankGroupIdUniqueIdentifierNoID of the rank group thatcontains this rank.GARankNameNVarChar(40)NoName of the rank.GARankPctNumeric(19,6)NoMaximum percentage tobe in this rank.GAVersionIntegerNoVersion of the databaserow.GAIndexesPrimary Key: RankIdForeign Keys: RankGroupIdAdditional Indexes:IR RankGroup TableThe IR RankGroup table contains rank groups used to rank questionnaire forms. Rank groups contain individual ranks. Interaction Feedbacksurveys also use these rank groups.Column erNoID of the rank group.GAGroupNameNVarChar(60)NoName of the rank group.GAVersionIntegerNoVersion of the databaserow.GAIndexesPrimary Key: RankGroupIdForeign Keys:Additional Indexes:IR RecordingMedia TableThe IR RecordingMedia table is the primary table for a recording. There is one row for every recording managed by Interaction Recorder.Column erNoID of the D of a related recording.Relates a recording of asegment to it's previoussegment or relates ascreen recording to it'sassociated interaction.More than one screenrecording can beassociated with aninteraction recording.GAMediaURINVarChar(1024)YesURI where the recordingis stored.GA
MediaKeyNVarChar(1024)YesA key that when appliedwith the Master Key Filecan decrypt therecording. Seedocumentation onInteraction Recorder'ssecurity for more details.GAMediaTypeSmallIntNoType of media recorded.(See below)GAFileSizeIntegerYesSize of the recording filein bytes.GARecordingDateDateTime2NoTime the recording wasmade.GARecordingDateOffsetIntegerNoUTC offset of therecording date.GAExpirationDateDateTimeYesExpiration date of therecording. When therecording expires it'sretention policies GADurationIntegerYesDuration of the interactionin milliseconds.GAServerIdNVarChar(64)YesReserved.GA, Removed in SU03FromConnValueNVarChar(255)YesConnection value of theinitiator of the n value of thereceiver of the interaction.GAMediaStatusNVarChar(56)YesKey that provideslicensed access to therecording. This is not forencryption. NULL if therecording is encumbered.GADirectionTinyIntYesDirection the interactionwas going. (See below)GAQueueObjectIdKeyVarChar(36)YesID of the interaction ofthis e of the initiationpolicy that initiated )YesIf this is a screenrecording this is the nameof the computer wherethe recording was made.GALineNameNVarChar(50)YesIf this is a call recordingthen this is name of theline that the call tookplace on.GANumAttachmentsSmallIntYesIf this is an emailrecording then this is thenumber of attachmentson that email.GACallTypeTinyIntYesFor call recordings thetype of call. (See below)GA
VersionIntegerNoVersion of the esTotal score of the positivekeywords spotted on thecustomer's tal score of thenegative keywordsspotted on the erYesTotal score of the positivekeywords spotted on theagent's channel.GAKeywordAgentScoreNegativeIntegerYesTotal score of thenegative keywordsspotted on the agent'schannel.GAIsArchivedTinyIntNoHas the recording beenarchived? One if true elsezero.SU03RecordingTypeSmallIntYesThe type of the recording(See "Explanation ofRecordingType" below)2016r3IndexesPrimary Key: RecordingIdForeign Keys: RelatedRecordingIdAdditional Indexes: ExpirationDate, KeywordAgentScorePositive, KeywordAgentScoreNegative, egative, QueueObjectIdKey, RecordingDateExplanation of MediaTypeMediaType can be one the following ax.5Screen.6Chat Transcript7Add Hoc Screen8Social Conversation9Social Direct MessageExplanation of DirectionDirection can be one the following values:ValueDescription0Invalid.1Inbound.
2Outbound.3Intercom.4Unknown.Explanation of CallTypeCallType can be one the following values:ValueDescription0Unknown.1External, Inbound or Outbound.2Intercom.3Conference.Explanation of RecordingTypeRecordingType can be one the following values:ValueDescriptionNULLRecordingType not specified. IR RecordingMedia rows that werecreated prior to 2016r3 will always have null entries for this columnsince the column didn't exist until 2016r3.0Policy-based recording.1Snippet recording.IR RecordingMediaSnippets TableThe IR RecordingMediaSnipppets table maps snippet recording IDs to corresponding policy recording IDs. Note that an entry will only exist inthis table for a snippet recording if a policy recording of an interaction was done at the same time as a snippet recording of the same interaction.Column dentifierNoID of the tifierNoID of the policy-basedrecording.2016r3IndexesPrimary Key: SnippetRecordingIdForeign Keys: SnippetRecordingId, PolicyRecordingIdAdditional Indexes: PolicyRecordingIdIR RecordingWork TableThe IR RecordingWork table contains temporary data used when a search is performed.Column NoID of the client's session.GARecordingIdUniqueIdentifierNoID of the recording.GARecordingDateDateTimeNoDate the recording wasmade.GAFetchStatusTinyIntNoFetch status.GA
IndexesPrimary Key:Foreign Keys:Additional Indexes: RecordingDate, RecordingId, SessionIdIR SecurityPolicy TableThe IR SecurityPolicy table contains the SQL to be used for all the criteria test of each security policy. This is to be used while updatingIR AccessControl table.Column ntifierNoID of the SecurityPolicy.2016r1ApplySqlNVarChar(MAX)YesSQL Select statement ofthe criteria selection forthis SecurityPolicy.2016r1IndexesPrimary Key: SecurityPolicyIdForeign Keys:Additional Indexes:IR SocialMediaRecording TableThe IR SocialMedia table contains the data related to the Social Media interactions (present for Media Types of Social Conversation (8) andSocial Direct Message (9).Column erNoID of the recording.2018r4PlatformSmallintNoPlatform id of theinteraction (see below)2018r4ChannelIdNVarChar(128)NoChannel id related to nnel name related tothe interaction2018r4PageNVarChar(128)YesPage related to theinteraction2018r4IndexesPrimary Key: RecordingIdForeign Keys: RecordingIdAdditional Indexes: IX IR SocialMediaRec Channel, IX IR SocialMediaRec ChannelId, IX IR SocialMediaRec Page,Explanation of PlatformRecordingType can be one the following values:ValueDescription1Facebook.2Twitter.IR Tag TableThe IR Tag table contains names of tags. These names can be referenced by many recordings.
Column NameTypeNullDescriptionSUTagIdIntegerNoID of the tag.GATagNameNVarChar(80)NoName of the tag.GAIndexesPrimary Key: TagIdForeign Keys:Additional Indexes: TagNameIR TagMap TableThe IR TagMap table contains entries for how tags are mapped to recordings. Tags can be mapped to recordings for search and other purposes.Column erNoID of the recording thetag is mapped to.GATagIdIntegerNoID of the tag that ismapped.GAKeywordSetNameNVarChar(128)YesIf non-NULL, this tag isbeing added to thisrecording due toInteraction Analyzerspotting a keyword in thisset.SU5IndexesPrimary Key: RecordingId TagIdForeign Keys: RecordingId, TagIdAdditional Indexes: TagId
52 Updated scorecard. 53 Finished scoring. 54 Deleted scorecard. SU5 59 Created master key. 60 Activated master key password. SU4 61 Revoked master key password. SU4 62 Changed master key password. SU4 63 Added master key password. SU4 64 Removed master key password. SU4 65 Interaction was .
