Set up a pivot table with CDD data mappings

The target key type specifies the composition of the primary key columns of the target table. Each time a component of the primary key changes from the previous primary key submitted, InForm inserts a new row in the target table.

Create a data set for the target table.
In the Properties Browser, select a Target Key Type value that begins with Pivot, and press Enter.
Create a data series for each column in the target table.
In the Properties Browser, select True as the value of the Pivot Column property for the data series to use as the pivot column, and press Enter.
For each text data series, in the Properties Browser, specify the maximum length of the target column as the value of the Target Column Max Length property, and press Enter.

CDD mapping properties

CDD data mapping properties

Study object	Option	Description
Item	Data Label	User-defined string to use for searching on data in the column. Maximum length is 30 characters. This label is included in the CDD data mapping control path definition in the InForm database. For CDD data mappings, it also appears in target CDD data mapping tables that have any of the following key types: Patient to Control, Pivot Patient, Pivot Visit, Pivot Form, and Pivot Section.
Data set	Associated Forms	Names of pairs of forms for which associations have been created. Selecting a pair of associated forms results in the generation of CDD data mappings for that association.
	Target Key Type	For the following key types, the target key type specifies the composition of the primary key columns of the target table. Each time a component of the primary key changes from the previous primary key submitted, the InForm application inserts a new row in the target table. Primary keys consist of the following DBUIDs and indexes: Patient Only—PatientID, FormIndex, ItemsetIndex. Patient Visit (default)—PatientID, VisitID, FormIndex, ItemsetIndex, and VisitIndex. Patient to Form—PatientID, VisitID, FormIndex, ItemsetIndex, VisitIndex, and FormID. Patient to Section—PatientID, VisitID, FormIndex, ItemsetIndex, VisitIndex, FormID, and SectionID. Patient to Itemset—PatientID, VisitID, FormIndex, ItemsetIndex, VisitIndex, FormID, SectionID, and ItemsetID. Patient to Item—PatientID, VisitID, FormIndex, ItemsetIndex, VisitIndex, FormID, SectionID, ItemsetID, and ItemID. Patient to Control—PatientID, VisitID, FormIndex, ItemsetIndex, VisitIndex, FormID, SectionID, ItemsetID, ItemID and five ControlIDs. A target table with this key type also contains a data label that can be used for data selection. For the following key types, the primary key columns are PatientID, VisitID, ItemsetIndex, VisitIndex, FormID, SectionID, ItemsetID, ItemID and five ControlIDs. The key type selection determines the composition of a pivot set. Within a pivot set, data points mapped to non-pivot columns are repeated in each row. Target tables with these key types also contain a data label that can be used for data selection. Pivot set keys consist of the following DBUIDs and indexes: 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
Data series	Pivot Column	Identifies the column to use as the pivot column, if the key type is Pivot Form, Pivot Patient, Pivot Section, or Pivot Visit. Note: Only one column can be the pivot column, and it must be the first column in the table.
	Target Column Max Length	Maximum length of a column, in the range 1-255. This property is applicable for columns with a type of STRING.