This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Next revision Both sides next revision | ||
documentation:vocabulary:data_etl [2015/01/24 13:09] cgreich |
documentation:vocabulary:data_etl [2015/01/24 14:23] cgreich |
||
---|---|---|---|
Line 7: | Line 7: | ||
^domain_id^CDM table^Field^Comment^ | ^domain_id^CDM table^Field^Comment^ | ||
- | |Generic|Any|Any|Generic Concepts can be in any field that ends in concept_id.| | + | |[[documentation:vocabulary:generic|Generic]]|Any|Any|Generic Concepts can be in any field that ends in concept_id.| |
- | |Gender|[[documentation:cdm:person|PERSON]]|gender_concept_id| | | + | |[[documentation:vocabulary:gender|Gender]]|[[documentation:cdm:person|PERSON]]|gender_concept_id| | |
- | |Race|[[documentation:cdm:person|PERSON]]|race_concept_id| | | + | |[[documentation:vocabulary:race|Race]]|[[documentation:cdm:person|PERSON]]|race_concept_id| | |
- | |Ethnicity|[[documentation:cdm:person|PERSON]]|ethnicity_concept_id| | | + | |[[documentation:vocabulary:ethnicity|Ethnicity]]|[[documentation:cdm:person|PERSON]]|ethnicity_concept_id| | |
- | |Visit|[[documentation:cdm:visit_occurrence|VISIT_OCCURRENCE]]|visit_concept_id| | | + | |[[documentation:vocabulary:visit|Visit]]|[[documentation:cdm:visit_occurrence|VISIT_OCCURRENCE]]|visit_concept_id| | |
- | |Procedure|[[documentation:cdm:procedure_occurrence|PROCEDURE_OCCURRENCE]]|procedure_concept_id| | | + | |[[documentation:vocabulary:procedure|Procedure]]|[[documentation:cdm:procedure_occurrence|PROCEDURE_OCCURRENCE]]|procedure_concept_id| | |
- | |Modifier|[[documentation:cdm:procedure_occurrence|PROCEDURE_OCCURRENCE]]|modifier_concept_id| | | + | |[[documentation:vocabulary:modifier|Modifier]]|[[documentation:cdm:procedure_occurrence|PROCEDURE_OCCURRENCE]]|modifier_concept_id| | |
- | |Drug|[[documentation:cdm:drug_exposure|DRUG_EXPOSURE]]|drug_concept_id| | | + | |[[documentation:vocabulary:drug|Drug]]|[[documentation:cdm:drug_exposure|DRUG_EXPOSURE]]|drug_concept_id| | |
- | |Route|[[documentation:cdm:drug_exposure|DRUG_EXPOSURE]]|route_concept_id| | | + | |[[documentation:vocabulary:route|Route]]|[[documentation:cdm:drug_exposure|DRUG_EXPOSURE]]|route_concept_id| | |
- | |Unit|[[documentation:cdm:measurement|MEASUREMENT]] or [[documentation:cdm:observation|OBSERVATION]] or [[documentation:cdm:specimen|SPECIMEN]]|unit_concept_id|Units are used in different contexts. *| | + | |[[documentation:vocabulary:unit|Unit]]|[[documentation:cdm:measurement|MEASUREMENT]] or [[documentation:cdm:observation|OBSERVATION]] or [[documentation:cdm:specimen|SPECIMEN]]|unit_concept_id|Units are used in different contexts. *| |
- | |Device|[[documentation:cdm:device_exposure|DEVICE_EXPOSURE]]|device_concept_id| | | + | |[[documentation:vocabulary:device|Device]]|[[documentation:cdm:device_exposure|DEVICE_EXPOSURE]]|device_concept_id| | |
- | |Condition|[[documentation:cdm:condition_occurrence|CONDITION_OCCURRENCE]]|condition_concept_id| | | + | |[[documentation:vocabulary:condition|Condition]]|[[documentation:cdm:condition_occurrence|CONDITION_OCCURRENCE]]|condition_concept_id| | |
- | |Measurement|[[documentation:cdm:measurement|MEASUREMENT]]|measurement_concept_id| | | + | |[[documentation:vocabulary:measurement|Measurement]]|[[documentation:cdm:measurement|MEASUREMENT]]|measurement_concept_id| | |
- | |Meas Value Operator|[[documentation:cdm:measurement|MEASUREMENT]]|operator_concept_id| | | + | |[[documentation:vocabulary:meas_value_operator|Meas Value Operator]]|[[documentation:cdm:measurement|MEASUREMENT]]|operator_concept_id| | |
- | |Meas Value|[[documentation:cdm:measurement|MEASUREMENT]]|value_as_concept_id| | | + | |[[documentation:vocabulary:meas_value|Meas Value]]|[[documentation:cdm:measurement|MEASUREMENT]]|value_as_concept_id| | |
- | |Observation|[[documentation:cdm:observation|OBSERVATION]]|observation_concept_id| | | + | |[[documentation:vocabulary:observation|Observation]]|[[documentation:cdm:observation|OBSERVATION]]|observation_concept_id| | |
- | |Relationship|[[documentation:cdm:fact_relationship|FACT_RELATIONSHIP]]|relationship_concept_id| | | + | |[[documentation:vocabulary:relationship|Relationship]]|[[documentation:cdm:fact_relationship|FACT_RELATIONSHIP]]|relationship_concept_id| | |
- | |Place of Service|[[documentation:cdm:care_site|CARE_SITE]]|place_of_service_concept_id| | | + | |[[documentation:vocabulary:place_of_service|Place of Service]]|[[documentation:cdm:care_site|CARE_SITE]]|place_of_service_concept_id| | |
- | |Provider Specialty|[[documentation:cdm:provider|PROVIDER]]|specialty_concept_id| | | + | |[[documentation:vocabulary:provider_specialty|Provider Specialty]]|[[documentation:cdm:provider|PROVIDER]]|specialty_concept_id| | |
- | |Currency|[[documentation:cdm:visit_cost|VISIT_COST]] or [[documentation:cdm:procedure_cost|PROCEDURE_COST]] or [[documentation:cdm:drug_cost|DRUG_COST]] or [[documentation:cdm:device_cost|DEVICE_COST]]|currency_concept_id|Currency values appear in any of the *_COST tables. *| | + | |[[documentation:vocabulary:currency|Currency]]|[[documentation:cdm:measurement|MEASUREMENT]] or [[documentation:cdm:observation|OBSERVATION]] or [[documentation:cdm:specimen|SPECIMEN]]|currency_concept_id|Currency values appear in any of the *_COST tables. *| |
- | |Revenue Code|[[documentation:cdm:procedure_cost|PROCEDURE_COST]]|revenue_code_concept_id| | | + | |[[documentation:vocabulary:revenue_code|Revenue Code]]|[[documentation:cdm:procedure_cost|PROCEDURE_COST]]|revenue_code_concept_id| | |
- | |Specimen|[[documentation:cdm:specimen|SPECIMEN]]|specimen_concept_id| | | + | |[[documentation:vocabulary:specimen|Specimen]]|[[documentation:cdm:specimen|SPECIMEN]]|specimen_concept_id| | |
- | |Spec Anatomic Site|[[documentation:cdm:specimen|SPECIMEN]] or [[documentation:cdm:measurement|MEASUREMENT]] or [[documentation:cdm:observation|OBSERVATION]]|anatomic_site_concept_id or value_as_concept_id or value_as_concept_id|Anatomical Site Concepts are used to characterize the origin of a Specimen, but also the result of a Measurement or Observation. *| | + | |[[documentation:vocabulary:spec_anatomic_site|Spec Anatomic Site]]|[[documentation:cdm:specimen|SPECIMEN]] or [[documentation:cdm:measurement|MEASUREMENT]] or [[documentation:cdm:observation|OBSERVATION]]|anatomic_site_concept_id or value_as_concept_id or value_as_concept_id|Anatomical Site Concepts are used to characterize the origin of a Specimen, but also the result of a Measurement or Observation. *| |
- | |Spec Disease Status|[[documentation:cdm:specimen|SPECIMEN]]|disease_status_concept_id| | | + | |[[documentation:vocabulary:spec_disease_status|Spec Disease Status]]|[[documentation:cdm:specimen|SPECIMEN]]|disease_status_concept_id| | |
* If there is more than one potential destination table the ETL needs to identify the context in which a Standard Concept is used, and select the right table from this table. | * If there is more than one potential destination table the ETL needs to identify the context in which a Standard Concept is used, and select the right table from this table. |