What is the difference between data mappings, data sets, and data series?
You use data mappings, data sets, and data series to group items into abstract associations. The associations that you create are independent of the way that you collect data values in forms.
- Data mappings—A data grouping that provides an alternate data view of a study. For example, you can group data sets to form an SDTM (Study Data Tabulation Model) data mapping.
- Data mappings are not affected when you move items between forms.
- You can create a data mapping before you design your study or as part of the study design process.
- You can create one or more mappings in a study or library, but they are not required for any project.
In a data mapping, items are added to a data series. The association remains with the item whenever it is used. You can compare the parts of a data mapping to database concepts with which you are already familiar.
Comparison of mappings to database and Microsoft Excel concepts
Compare a mapping to |
Compare a data set to |
Compare a data series to |
---|---|---|
A database schema |
A database table |
A column in a table |
A Microsoft Excel workbook |
A worksheet |
A column in a worksheet |
- Data sets—A grouping of one or more related data series. For example, the Temperature data series and Weight data series might comprise a Vital Signs data set.
When you create a data set, you can specify standard and custom dimensions.
- Data series—A grouping of one or more items with the same clinical meaning, such as one or more items that measure weight.
When you create a data series, you choose a data type for it.
Example—Data mapping: Grouping items to measure vital signs
Vital signs mapping example
Data set: Vital signs initial |
Data set: Vital signs final |
|
|