This shows you the differences between two versions of the page.
Next revision | Previous revision Next revision Both sides next revision | ||
documentation:cdm:cohort_definition [2014/11/17 18:40] cgreich created |
documentation:cdm:cohort_definition [2014/12/02 01:51] jduke |
||
---|---|---|---|
Line 3: | Line 3: | ||
^Field^Required^Type^Description^ | ^Field^Required^Type^Description^ | ||
- | ^cohort_definition_id^Yes^integer^A unique identifier for each Cohort.^ | + | |cohort_definition_id|Yes|integer|A unique identifier for each Cohort.| |
- | ^cohort_definition_name^Yes^varchar(255)^A short description of the Cohort.^ | + | |cohort_definition_name|Yes|varchar(255)|A short description of the Cohort.| |
- | ^cohort_definition_description^No^CLOB^A complete description of the Cohort definition^ | + | |cohort_definition_description|No|CLOB|A complete description of the Cohort definition| |
- | ^definition_type_concept_id^Yes^integer^Type to define what kind of Cohort definition the record represents and how the syntax may be executed^ | + | |definition_type_concept_id|Yes|integer|Type defining what kind of Cohort Definition the record represents and how the syntax may be executed| |
- | ^cohort_definition_syntax^No^CLOB^Syntax to operationalize the Cohort definition^ | + | |cohort_definition_syntax|No|CLOB|Syntax or code to operationalize the Cohort definition| |
- | ^subject_concept_id^Yes^integer^A foreign key to the Concept to which defines the domain of subjects that are members of the cohort (e.g., person, provider, visit).^ | + | |subject_concept_id|Yes|integer|A foreign key to the Concept to which defines the domain of subjects that are members of the cohort (e.g., Person, Provider, Visit).| |
- | ^cohort_instantiation_date^No^Date^A date to indicate when the Cohort was instantiated in the COHORT table^ | + | |cohort_instantiation_date|No|Date|A date to indicate when the Cohort was instantiated in the COHORT table| |
==== Conventions ==== | ==== Conventions ==== | ||
- | * The cohort_definition_syntax does not define the used syntax. It can be SQL, a cohort definition language, or a free-text description of the algorithm. | + | * The cohort_definition_syntax does not prescribe any specific syntax or programming language. Typically, it would be any flavor SQL, a cohort definition language, or a free-text description of the algorithm. |
- | * The subject_cocnept_id determines what the individual subjects or entities of the cohort consists of. In most cases, that would be a person (patient). But cohorts could be constructed for providers, visits and any other domain. Note that the domain is not codified using the alphanumerical domain_id like in the CONCEPT table. Instead, the corresponding Concept is used. The Concepts for each domain can be obtained from the DOMAIN table in the domain_concept_id. | + | * The subject_concept_id determines what the individual subjects or entities of the Cohort consists of. In most cases, that would be a Person (patient). But cohorts could also be constructed for Providers, Visits or any other Domain. Note that the Domain is not codified using the alphanumerical domain_id like in the CONCEPT table. Instead, the corresponding Concept is used. The Concepts for each domain can be obtained from the DOMAIN table in the domain_concept_id. |
- | ~~DISQUS~~ |