Creating a CDD mapping definition table

To create a CDD mapping table definition:

In the Data Mappings window, right-click the CDD mapping RefName, and select New Table.
A new table line is added to the Data Mappings node in the Data Mappings window.
In the Data Mappings window, select the table name.
Edit the CDD mapping table property values in the Properties window.

The following table describes the properties of a CDD mapping table definition:

Property	Description
Name	Name of the data mapping target table. When you update this name, the new name is reflected in the Data Mappings window. This name can have a maximum of 30 characters. REQUIRED..
Key Type	For the following key types, this 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 VisitIndexOPTIONAL.
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.

Property

Description

Name

Name of the data mapping target table. When you update this name, the new name is reflected in the Data Mappings window. This name can have a maximum of 30 characters.

REQUIRED..

Key Type

For the following key types, this 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 VisitIndexOPTIONAL.

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: A table that has mappings for controls within an itemset cannot have any of the pivot key types. Additionally, a pivot column must be the first column in a data mapping table. When you select a pivot column, if it is not the first column, the InForm Architect application prompts you to reorder the column. If you do not choose to reorder the column to the first position in the table, the InForm Architect application does not make the column the pivot column.