Link native fields to CDM fields
To start field mapping:
- Use double click on a pair of native and cdm tables
- Or "Go To Link Fields" button
The value from the source field will be moved to the CDM field as it is without modification.
The entered value will be used in the CDM field
The entered SQL function will be applied to the source field value prior to the transition to the CDM field
A configured lookup will be used for mapping value from the source field to concept ID prior to the transition to the CDM field
An SQL function transformation can be used together with Vocabulary lookup transformation
Use ctrl key to select multiple source fields and create a group
Fields settings can be cloned (fields mappings will be copied to the new clone). A CDM entity will be created for each clone.
You can add a condition for each clone; the CDM entity will be created only when the entered condition expression is TRUE.
Fields with the same names are available in Similar tab. All actions with the similar fields will be repeated on the corresponding fields.
Concept configuration dialog is for main concepts (condition occurrence, procedure occurrence, drug exposure concepts...). Main concept has:
- Source value - original(native) value, original value + sql transformation or constant
- Concept Id - original(native) value, original value + sql transformation or constant or lookup (source to standard)
- Source Concept Id - lookup (source to source)
- Type Concept Id - original(native) value, original value + sql transformation or constant
What is concept? In CDM data tables the content of each record is fully normalized and represented through Concepts. Concepts are stored in Event tables with their CONCEPT_ID values, which are foreign keys to the CONCEPT table, which serves as the general reference table. All CDM instances use the same CONCEPT table as a reference of the Concepts, which together with the Common Data Model is a key mechanism of interoperability and the foundation of the OHDSI research network.
For each concept field a separate CDM entity will be created.
