fact_relationship
Standard Clinical Data Table
Table Columns
| field | type | required | phi | phi scrubbing operation |
|---|---|---|---|---|
| domain_concept_id_1 | INTEGER | Yes | ||
| fact_id_1 | INTEGER | Yes | ||
| domain_concept_id_2 | INTEGER | Yes | ||
| fact_id_2 | INTEGER | Yes | ||
| relationship_concept_id | INTEGER | Yes | ||
| trace_id | STRING | No | Del | |
| unit_id | STRING | No | ||
| load_table_id | STRING | No |
Columns Description
domain_concept_id_1
The concept representing the domain of fact one, from which the corresponding table can be inferred.
fact_id_1
The unique identifier in the table corresponding to the domain of fact one.
domain_concept_id_2
The concept representing the domain of fact two, from which the corresponding table can be inferred.
fact_id_2
The unique identifier in the table corresponding to the domain of fact two.
relationship_concept_id
A foreign key to a Standard Concept ID of relationship in the Standardized Vocabularies.
trace_id
A json string with the primary keys of the table in Clarity where most of the information for a given row is sourced
unit_id
Is a reference for the position in the ETL code responsible for bringing in this row level data
load_table_id
A json string with the primary keys of the table in Clarity where most of the information for a given row is sourced