Event Codes

One of the things I am often asked for by clients particularly when writting their own reports is a list of the event codes in VQSM. Although there is not a published list there is code in the standard call report used to print calls that contains the breakdown. The code can be copied from the report installed on the server but for those who want it, this is it:

if ({call_event.Eventcode} = 1 ) then "Call Logged"
else if ({call_event.Eventcode} = 2 ) then "Call Allocated"
else if ({call_event.Eventcode} = 3 ) then "Call Assigned"
else if ({call_event.Eventcode} = 4 ) then "Call Fixed"
else if ({call_event.Eventcode} = 5 ) then "Call Re-Opened"
else if ({call_event.Eventcode} = 6 ) then "Call Returned Unallocated)"
else if ({call_event.Eventcode} = 7 ) then "Call Picked Up"
else if ({call_event.Eventcode} = 8 ) then "Call Signed Off"
else if ({call_event.Eventcode} = 9 ) then "SLT1 Response"
else if ({call_event.Eventcode} = 10 ) then "Auto-Escalation"
else if ({call_event.Eventcode} = 11 ) then "External Group Targets Set"
else if ({call_event.Eventcode} = 12 ) then "External Group Response"
else if ({call_event.Eventcode} = 13 ) then "External Group Fix"
else if ({call_event.Eventcode} = 14 ) then "External Group Allocation"
else if ({call_event.Eventcode} = 15 ) then "Manual Escalation"
else if ({call_event.Eventcode} = 16 ) then "External Person Assign"
else if ({call_event.Eventcode} = 17 ) then "Call Targets Changed"
else if ({call_event.Eventcode} = 18 ) then "Call Placed On Hold"
else if ({call_event.Eventcode} = 19 ) then "Call Linked To Other Calls"
else if ({call_event.Eventcode} = 20 ) then "Auto-Escalation Resumed"
else if ({call_event.Eventcode} = 21 ) then "Manual release of call from Hold"
else if ({call_event.Eventcode} = 22 ) then "Call Unlinked"
else if ({call_event.Eventcode} = 23 ) then "Call Priority Changed"
else if ({call_event.Eventcode}= 24 ) then "External Group Targets Changed"
else if ({call_event.Eventcode} = 25 ) then "SLT1 Code Changed"
else if ({call_event.Eventcode} = 26 ) then "Mail Sent"
else if ({call_event.Eventcode}= 27 ) then "Mail Received"
else if ({call_event.Eventcode} = 28 ) then "Reply Sent"
else if ({call_event.Eventcode} = 29 ) then "OutBox Mail"
else if ({call_event.Eventcode} = 30 ) then "QLink Create Transmission"
else if ({call_event.Eventcode} = 31 ) then "QLink Create Acknowledge"
else if ({call_event.Eventcode} = 32 ) then "Qlink Update Transmission"
else if ({call_event.Eventcode} = 33 ) then "QLink Update Receive"
else if ({call_event.Eventcode} = 55 ) then "Client Linked"
else if ({call_event.Eventcode} = 56 ) then "Client Unlinked "
else if ({call_event.Eventcode} = 57 ) then "Config Linked "
else if ({call_event.Eventcode} = 58 ) then "Config Unlinked "
else if ({call_event.Eventcode} = 59) then "Logon Linked "
else if ({call_event.Eventcode} = 60 ) then "Logon Unlinked "
else if ({call_event.Eventcode} = 61 ) then "Item Linked "
else if ({call_event.Eventcode} = 62 ) then "Item Unlinked "
else if ({call_event.Eventcode} = 63 ) then "Client Updated"
else if ({call_event.Eventcode} = 64 ) then "Config Updated"
else if ({call_event.Eventcode} = 65 ) then "Logon Updated"
else if ({call_event.Eventcode} = 66 ) then "Item Updated"
else if ({call_event.Eventcode}= 67 ) then "Location Linked"
else if ({call_event.Eventcode} = 68 ) then "Location Unlinked"
else if ({call_event.Eventcode} = 69 ) then "Call Subject1 Added"
else if ({call_event.Eventcode}= 70 ) then "Call Subject1 Changed"
else if ({call_event.Eventcode} = 71 ) then "Call Subject2 Added"
else if ({call_event.Eventcode} = 72 ) then "Call Subject2 Changed"
else if ({call_event.Eventcode} = 73 ) then "Call Subject3 Added"
else if ({call_event.Eventcode} = 74 ) then "Call Subject3 Changed"
else if ({call_event.Eventcode} = 75 ) then "Comments Updated"
else if ({call_event.Eventcode} = 76 ) then "Organization Linked"
else if ({call_event.Eventcode} = 77 ) then "Organization Unlinked"
else if ({call_event.Eventcode} = 78 ) then "Organization Updated"
else if ({call_event.Eventcode} = 79 ) then "Call Subject2 Removed"
else if ({call_event.Eventcode} = 80 ) then "Call Subject3 Removed"
else if ({call_event.Eventcode} = 81 ) then "File Attached"
else if ({call_event.Eventcode} = 82 ) then "File Detached"
else if ({call_event.Eventcode} = 34 ) then "SLT2 Set Event"
else if ({call_event.Eventcode} = 35 ) then "SLT2 Changed"
else if ({call_event.Eventcode} = 36 ) then "SLT2 Removed"
else if ({call_event.Eventcode} = 37 ) then "Downtime Event "
else if ({call_event.Eventcode} = 83 ) then "Release Datetime Changed"

Posted by: David Bland (Transforme Associates Limited)
Software: VQSM (Datawatch)
Version: 7.x
Database: Microsoft SQL, Oracle