Hi. Is there a way to define a cohort with only PERSON_ID and fixed COHORT_START/END_DATE? I have specific groups of people with known PERSON_ID, and I want to build a cohort out of this.
Particularly, in the Atlas, I want to write a sql code for the export-Oracle-sql. How can I go about this?
Thank you for your help ahead.
I have studied a little bit about export-Oracle-sql, and I think I need to manipulate the following code.
DELETE FROM @target_database_schema.@target_cohort_table where cohort_definition_id = @target_cohort_id;
INSERT INTO @target_database_schema.@target_cohort_table (cohort_definition_id, subject_id, cohort_start_date, cohort_end_date)
SELECT @target_cohort_id as cohort_definition_id, person_id, start_date, end_date FROM @temp_database_schema.sue1g2nsfinal_cohort CO;
So, I think, instead of
@temp_database_schema.sue1g2nsfinal_cohort, I need to put my table, say named
@CDM_2020_VIEW.my_cohort (the schema that I’m using is
CDM_2020_VIEW) with the entity of cohort_definition_id, person_id, start_date, end_date.
However, I think
@target_cohort_id is an automatic number defined by atlas. (Am I right?) And if so, then I need to careful about putting value in cohort_definition_id in
@CDM_2020_VIEW.my_cohort table. How can I go about this?
I just found out that I cannot manipulate the SQL code. I could only change Json code; but unfortunately, I don’t know how to use them. As @Chris_Knoll said, is there a way to upload csv file in the cohort definition tab?