Values X and S in table CI_TREATMENT_CHAR_UDF of SAS Customer Intelligence (CI) 6.6

[Eitan123]

Hey, 

I'm using SAS Customer Intelligence (CI) 6.6 in order to create campaigns, and i have a SQL Server database to which the generated population of these campaigns are are inserted. there are also a number of SAS system tables in SQL Server, one of which is called CI_TREATMENT_CHAR_UDF.
In this table there's a column named TREATMENT_HASH_VAL which, to my understanding, is supposed to be a unique identifier for treatments (for example D3C9EE9A7B6D09F537FF890E268D8336).

However, it sometimes receives either the value S or X.

Does anyone please know the reason(s) for these values?

Kind Regards,

Eitan

[Bet_ty · Accepted solution]

 Hello Eitan,

to answer your question. For dynamic treatments, you can have two types of data.  The Static type will have a treatment_hash_val = 'S' and the dynamic type will have a treatment_hash_val = 'X' record. For the dynamic type, there should be an additional record in the CI_TREATMENT_CHAR_UDF table with the treatment_hash_val = "some long hash string" which uniquely ties this dynamic treatment back to the contact history record.  

I hope this helps,

Thanks,

Beate