What are the target key type for pivot tables?

Target key types for pivot tables enable you to define CDD tables in which you can map multiple data points to the same CDD table column or 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.

In pivot tables, the target key type determines the composition of a pivot set. Within a pivot set, data points mapped to the columns that are not in the pivot set are repeated in each row. You might choose one of these target key types to be able to select all data values that have some related data value in common, for example, to select all lab values for a specific test that were collected on the same date.

The primary key columns are PatientID, VisitID, ItemsetIndex, VisitIndex, FormID, SectionID, ItemsetID, ItemID, and five ControlIDs. Pivot target tables also contain a data label that can be used for data selection. The data label is specified in the Data Label custom property of the item.

Target key type	Pivot set components
Pivot Patient	PatientID and VisitIndex.
Pivot Visit	PatientID, VisitID, and VisitIndex.
Pivot Form	PatientID, VisitID, FormID, and VisitIndex
Pivot Section	PatientID, VisitID, FormID, SectionID, and VisitIndex