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

Eitan123 — Mon, 24 Feb 2025 15:00:49 GMT

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

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

Bet_ty — Tue, 25 Feb 2025 15:44:21 GMT

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

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

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

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