Setting up a pivot table with CDD data mappings

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.