The "operation" field of the usp_kpi_ticket_data table in Service Desk Manager is used to record the operation types of the KPI data.
Very often system administrators would need to write reports using this field for the KPI reports. The tech doc explains what those
values mean.
what the values of operation field mean in usp_kpi_ticket_data table?
There are 5 values for this "operation" field. They are:
0: create/insert
1: delete
2: reopen
3: regular field updates
4: close and any update when the ticket is closed