domain

Vocabulary Tables

Table Columns

field	type	required	phi	phi scrubbing operation
domain_id	STRING	Yes
domain_name	STRING	Yes
domain_concept_id	INTEGER	Yes
load_table_id	STRING	No
load_row_id	STRING	No

Columns Description

domain_id

A unique key for each domain.

domain_name

The name describing the Domain, e.g. “Condition”, “Procedure”, “Measurement” etc.

domain_concept_id

A Concept representing the Domain Concept the DOMAIN record belongs to.

load_table_id

Is the name of the primary Clarity table in Clarity where most of the information for a given row is sourced

load_row_id

A reference to the position in the ETL code responsible for bringing in this row level data