documentation:cdm:attribute_definition
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
|
documentation:cdm:attribute_definition [2014/11/17 18:47] cgreich |
documentation:cdm:attribute_definition [2017/08/17 15:21] clairblacketer |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ===== ATTRIBUTE_DEFINITION ===== | + | ===== ATTRIBUTE_DEFINITION table ===== |
| + | **The CDM documentation is now being housed on [[https://github.com/OHDSI/CommonDataModel/wiki|github]]. The most recent release is [[https://github.com/OHDSI/CommonDataModel/releases/tag/v5.2.-bugfix.1|v5.2]]** | ||
| The ATTRIBUTE_DEFINITION table contains records defining Attributes, or covariates, to members of a Cohort through an associated description and syntax and upon instantiation (execution of the algorithm) placed into the COHORT_ATTRIBUTE table. Attributes are derived elements that can be selected or calculated for a subject in a Cohort. The ATTRIBUTE_DEFINITION table provides a standardized structure for maintaining the rules governing the calculation of covariates for a subject in a Cohort, and can store operational programming code to instantiate the Attributes for a given Cohort within the OMOP Common Data Model. | The ATTRIBUTE_DEFINITION table contains records defining Attributes, or covariates, to members of a Cohort through an associated description and syntax and upon instantiation (execution of the algorithm) placed into the COHORT_ATTRIBUTE table. Attributes are derived elements that can be selected or calculated for a subject in a Cohort. The ATTRIBUTE_DEFINITION table provides a standardized structure for maintaining the rules governing the calculation of covariates for a subject in a Cohort, and can store operational programming code to instantiate the Attributes for a given Cohort within the OMOP Common Data Model. | ||
| Line 6: | Line 8: | ||
| |attribute_name|Yes|varchar(255)|A short description of the Attribute.| | |attribute_name|Yes|varchar(255)|A short description of the Attribute.| | ||
| |attribute_description|No|CLOB|A complete description of the Attribute definition| | |attribute_description|No|CLOB|A complete description of the Attribute definition| | ||
| - | |attribute_type_concept_id|Yes|integer|Type to define what kind of Attribute definition the record represents and how the syntax may be executed| | + | |attribute_type_concept_id|Yes|integer|Type defining what kind of Attribute Definition the record represents and how the syntax may be executed| |
| - | |attribute_syntax|No|CLOB|Syntax to operationalize the Attribute definition| | + | |attribute_syntax|No|CLOB|Syntax or code to operationalize the Attribute definition| |
| ==== Conventions ==== | ==== Conventions ==== | ||
| - | * Like the definition syntax field for the COHORT-DEFINITION table, the attribute_definition_syntax does not prescribe the used syntax. It can be any flavor of SQL, or a cohort definition language, or a free-text description of the algorithm. | + | * Like the definition syntax field for the COHORT_DEFINITION table, the attribute_definition_syntax does not prescribe any specific syntax or programming language. Typically, it would be any flavor SQL, or a cohort definition language, or a free-text description of the algorithm. |
| - | * The Attribute Definition is generic and not necessarily related to a specific Cohort Definition, however the instantiated Attribute is linked to the Cohort records (see below the [[http://ohdsi.org/web/wiki/doku.php?id=documentation:cdm:cohort|COHORT]] table. For example, the Attribute "Age" can be defined as the amount of time between the cohort_start_date of the COHORT table and the year_of_birth, month_of_birth and day_of_birth of the PERSON table. Thus, such a Attribute definition can be applied and instantiated with any Cohort. belonging to the same Domain. | + | * The Attribute Definition is generic and not necessarily related to a specific Cohort Definition, however the instantiated Attribute is linked to the Cohort records (see below the [[http://ohdsi.org/web/wiki/doku.php?id=documentation:cdm:cohort|COHORT]] table. For example, the Attribute "Age" can be defined as the amount of time between the cohort_start_date of the COHORT table and the year_of_birth, month_of_birth and day_of_birth of the PERSON table. Thus, such a Attribute Definition can be applied and instantiated with any Cohort, as long as it is applied to a Cohort of the same Domain (Person in this case), as it is defined in the subject_concept_id in the COHORT_DEFINITION table. |
| - | ~~DISQUS~~ | ||
documentation/cdm/attribute_definition.txt · Last modified: 2017/09/25 14:59 by clairblacketer
Page Tools
