Find active treatments assigned to Decision Treatment Campaign

[dsadsad]

Hi All,

I would like to know only THE active treatments(currently assigned) assigned to any particular decision treatment campaign . Is it possible through CDM  data base ?

I am using the below code but it gives all the treatment codes (Current + History).

SELECT

   DISTINCT TREATMENT_CD

       FROM

CI_PACKAGE_X_TREATMENT CPXT

    INNER JOIN  CI_CELL_PACKAGE CP ON

    CPXT.CONTRIBUTING_CELL_PACKAGE_SK = CP.CELL_PACKAGE_SK

        INNER JOIN  CI_TREATMENT CIT

      ON CPXT.TREATMENT_SK=CIT.TREATMENT_SK

      INNER JOIN  CI_TREATMENT_EXT CITE

      ON CIT.TREATMENT_SK = CITE.TREATMENT_SK WHERE CP.CAMPAIGN_CD='CAMP506094'

Thanks in Advance.

[Kurt_Bremser]

What's the condition for an active treatment? Add that to the where clause.

[dsadsad]

Hi Kurt ,

Thanks for you response. i am not aware of any filter in CDM data base to use to get the currently assigned treatments to decision treatment campaign.

[JamesAnderson]

Hi,
I don't believe what you want (which to see an accurate reflection of what you can see in CI Studio for Treatments used in each Decision Treatment Campaign) is available in the CDM. Its important to distinguish that the CDM is a historical database that captures the outcomes of decision requests for RTDM, not a reflection of what is currently in metadata. This is evidenced by the fact that you only get a record in CI_PACKAGE_X_TREATMENT after a decision has been made, and the record will only represent the treatments in the outcome of the decision rather than the input treatments (i.e. the entire scope of all treatments used in the campaigns in the decision).
To get what you want you need to extract the information directly from metadata using the CI Integration Utilities.
Regards
James

[dsadsad]

Ok , Thanks James. Will Explore CI Utilities to achieve this.