documentation:cdm:source_to_concept_map
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | Next revision Both sides next revision | ||
|
documentation:cdm:source_to_concept_map [2014/12/29 05:17] cgreich |
documentation:cdm:source_to_concept_map [2014/12/29 05:20] cgreich |
||
|---|---|---|---|
| Line 18: | Line 18: | ||
| * This table is no longer used to distribute mapping information between source codes and Standard Concepts for the Standard Vocabularies. Instead, the CONCEPT_RELATIONSHIP table is used for this purpose, using the relationship_id='Maps to'. | * This table is no longer used to distribute mapping information between source codes and Standard Concepts for the Standard Vocabularies. Instead, the CONCEPT_RELATIONSHIP table is used for this purpose, using the relationship_id='Maps to'. | ||
| * However, this table can still be used for the translation of local source codes into Standard Concepts. | * However, this table can still be used for the translation of local source codes into Standard Concepts. | ||
| + | * **Note: **This table should not be used to translate source codes to Source Concepts. The source code of a Source Concept is captured in its concept_code field. If the source codes used in a database doesn't follow the correct formatting, the ETL will have to perform this translation. For example, if an ICD-9-CM code in a database is recorded without a dot the ETL will have to perform a lookup function that allows identifying the correct ICD-9-CM Source Concept. | ||
| * The source_concept_id, or the combination of the fields source_code and the source_vocabulary_id uniquely identifies the source information. It is the equivalent to the concept_id_1 field in the CONCEPT_RELATIONSHIP table. | * The source_concept_id, or the combination of the fields source_code and the source_vocabulary_id uniquely identifies the source information. It is the equivalent to the concept_id_1 field in the CONCEPT_RELATIONSHIP table. | ||
| * If there is no source_concept_id available because the source codes are local and not supported by the Standard Vocabulary, the content of the field is 0 (zero, not null) encoding an undefined concept. However, local Source Concepts are established (concept_id values above 2,000,000,000). | * If there is no source_concept_id available because the source codes are local and not supported by the Standard Vocabulary, the content of the field is 0 (zero, not null) encoding an undefined concept. However, local Source Concepts are established (concept_id values above 2,000,000,000). | ||
documentation/cdm/source_to_concept_map.txt ยท Last modified: 2017/09/25 14:59 by clairblacketer
Page Tools
