Target keys in CDD data mappings

When you create a data set to use for CDD data mappings, you specify the target key type. Target key types control how data is grouped in a CDD. Target key types are used for tables that do not pivot and for pivot tables.

• Target key types for tables that do not pivot—These target key types enable you to define CDD tables in which data is grouped by a portion of the control path of the data point in the InForm application. For example, to capture all of the data for a single patient in one row, you might define a target table with the Patient Only target key type. To capture the data for each form in a single row, with a new row for each patient and visit, you might define a target table with the Patient to Form target key type.

  The primary key of the target table determines how data is inserted into CDD target tables. When you create a CDD target table definition, the primary key of the table is a set of database IDs (DBUIDs) and indexes that correspond to the components of a data point’s control path or a subset of the control path. When the InForm application loads data into a CDD table, it creates a new row each time the value of the primary key changes.

• Target key types for pivot tables—These target key types enable you to define CDD tables in which you can:
  • Map multiple data points to the same CDD table column.
  • Associate a particular data point with each row in the table.

  In pivot tables, insertion of data is organized around a set of rows called a pivot set. The data points that make up a pivot set share the same values in specified parts of their control paths. The target key type of a pivot table determines where each pivot set breaks by defining which parts of the control path are the same within a pivot set. For example, in a table with a target key type of Pivot Section, a pivot set is made up of all data points in which the patient, visit, form, and section components of the control path match.

  One of the columns in a pivot table is identified as the pivot column. Each time the InForm application loads one pivot set of data into a pivot table, it creates a new row for each data point mapped to the pivot column, and it duplicates data points mapped to nonpivot columns in each of those rows.