|
|
|
|
Key types
In each mapping definition, you specify the target table and column where each value of the data point goes. Additionally, the InForm application and the InForm Architect application provide a variety of options for grouping transferred data. These options fall into the following categories, and are identified in a CDD table definition by the Key Type property:
- Pivot table key types—These 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 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 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 non-pivot columns in each of those rows.
For more information and for examples, see Pivot table key types.
- Non-pivot table key types—These key types enable you to define CDD tables in which data is grouped by a portion of the source data point’s control path. 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 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 key type.
Insertion into CDD target tables is determined by the primary key of the target table. 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.
For more information and for examples, see Pivot table key types.
