We are working in our company with an external KPI software(BOARD7) to show data from ServiceDeskPlus version 8108 we are gathering data directly from database ssql. 

So ill explain a little our system so you can make an idea:

We work with 8 different Sites but all the groups are assigned to every site so that means we get for every "SITEID" a new "QUEUEID" for each group but all with the same "QUEUENAME" for example "Finance" and when we take data from WORKORDER table we get 8 different Finance groups to merge for getting KPIs so we thought on using CIID to get this data since it is unique for all the rest of groups see table below.

QUEUEID	QUEUENAME	QUEUEDESCRIPTION	SITEID	CIID
7205	Finance	NULL	NULL	1318749
9006	Finance	NULL	16203	1318749
9043	Finance	NULL	16501	1318749
9080	Finance	NULL	16502	1318749
9117	Finance	NULL	16204	1318749
9154	Finance	NULL	16801	1318749
9194	Finance	NULL	16201	1323857
9231	Finance	NULL	16202	1318749

The thing is that with every other group the "CIID" has been unique and we have used that field to show the Name and the whole QUEUE of tickets assigned to them in KPIs. Now the problem is that on the start all CIID were OK since this last one in the Finance Support Group CIID= 1323857

Since CIID field is not correlated to any other table other than "WORKORDER" i was thinking on updating this CIID directly from SQL querry and assigning the same CIID as the other Finance Support Group but i wanted to ask if this field is really unique or with time it will create other "IDs" to the same group. That way we might look for another solution or if this one is the right solution. 

Hope to hear soon from you 

Best Regards,

MathiasK.