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
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:
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:
|
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. |
Parent topic: CDD mappings