Skip to content

DATA_SOURCE

Robert Miller edited this page May 28, 2019 · 2 revisions

The DATA SOURCE table records metadata about external data sets.

Field Required Type Description
data_source_id Yes varchar(100) A unique string identifier. Similar pattern of 'vocabulary_id'
data_source_name Yes varchar(255) The name of the data source
data_source_description No varchar(max) A short description of the data source.
data_source_type_id Yes varchar(255) (TODO) A foreign key to a Standard Concept ID of the type of data source
data_source_type_name Yes varchar(255) Text representation of type
document_url No varchar(100) A link to documentation for the data source.
source_version No varchar(50) Specifies which version or release of the source data was used.
collection_start_date No date The date the data started being collected.
collection_end_date No date The date the data ended being collected.
timeframe_concept_id No integer A foreign key to a Standard Concept ID of time intervals in the Standardized Vocabularies. Used in conjunction with timeframe_value to specify the length of time the data represents.
timeframe_name No varchar(100) text representation of timeframe. 'Year', 'Month', etc.
timeframe_value No float A numeric qualifier used in conjunction with timeframe_concept_id to specify the length of time the data represents.
last_updated_date No date The date of the last edit of the data set
Clone this wiki locally