concept_relationship
Vocabulary Tables
Table Columns
| field | type | required | phi | phi scrubbing operation |
|---|---|---|---|---|
| concept_id_1 | INTEGER | Yes | ||
| concept_id_2 | INTEGER | Yes | ||
| relationship_id | STRING | Yes | ||
| valid_start_date | DATE | Yes | ||
| valid_end_date | DATE | Yes | ||
| invalid_reason | STRING | No |
Columns Description
concept_id_1
A foreign key to a Concept in the CONCEPT table associated with the relationship. Relationships are directional, and this field represents the source concept designation.
concept_id_2
A foreign key to a Concept in the CONCEPT table associated with the relationship. Relationships are directional, and this field represents the destination concept designation.
relationship_id
A unique identifier to the type or nature of the Relationship as defined in the RELATIONSHIP table.
valid_start_date
The date when the instance of the Concept Relationship is first recorded.
valid_end_date
The date when the Concept Relationship became invalid because it was deleted or superseded (updated) by a new relationship. Default value is 31-Dec-2099.
invalid_reason
Reason the relationship was invalidated. Possible values are ‘D’ (deleted), ‘U’ (replaced with an update) or NULL when valid_end_date has the default value.