documentation:cdm:attribute_definition
This is an old revision of the document!
ATTRIBUTE_DEFINITION
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.
| Field | Required | Type | Description |
|---|---|---|---|
| attribute_definition_id | Yes | integer | A unique identifier for each Attribute. |
| attribute_name | Yes | varchar(255) | A short description of the Attribute. |
| 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_syntax | No | CLOB | Syntax to operationalize the Attribute definition |
Conventions
- Like the definition syntax field for the COHORT-DEFINITION table, the attribute_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 Attribute definition is generic and not necessarily related to a specific Cohort definition. 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.
~~DISQUS~~
documentation/cdm/attribute_definition.1416249860.txt.gz · Last modified: by cgreich