What are the target key types for tables that do not pivot?

Target key types for tables that do not pivot—These target key types enable you to define CDD tables in which data is grouped by a portion of the control path of the data point in the InForm application. For example, to capture all of the data for a single patient in one row, you might define a target table with the Patient Only target key type. To capture the data for each form in a single row, with a new row for each patient and visit, you might define a target table with the Patient to Form target key type.

The primary key of the target table determines how data is inserted into CDD target tables. When you create a CDD target table definition, the primary key of the table is a set of database IDs (DBUIDs) and indexes that correspond to the components of a data point’s control path or a subset of the control path. When the InForm application loads data into a CDD table, it creates a new row each time the value of the primary key changes.

In tables that do not pivot, each target key type specifies the components of the primary key of the target table. For example, the primary key of a table with a target key type of Patient to Form consists of columns containing the PatientID, VisitID, ItemsetIndex, VisitIndex, and FormID.

Target key types for tables that do not pivot

Target key type	Primary key components	Data grouping in target table
Patient Only	PatientID, FormIndex, ItemsetIndex.	All data for a patient in one row.
Patient Visit	PatientID, VisitID, FormIndex, ItemsetIndex, and VisitIndex.	All data for a visit in one row, with a new row for each patient or visit.
Patient to Form	PatientID, VisitID, FormIndex, ItemsetIndex, VisitIndex, and FormID.	All data for a form in one row, with a new row for each patient, visit, or form.
Patient to Section	PatientID, VisitID, FormIndex, ItemsetIndex, VisitIndex, FormID, and SectionID.	All data for a section in one row, with a new row for each patient, visit, form, or section.
Patient to Itemset	PatientID, VisitID, FormIndex, ItemsetIndex, VisitIndex, FormID, SectionID, and ItemsetID.	All data for an itemset instance in one row, with a new row for each patient, visit, form, section, or itemset row.
Patient to Item	PatientID, VisitID, FormIndex, ItemsetIndex, VisitIndex, FormID, SectionID, ItemsetID, and ItemID.	All data for an item in one row, with a new row for each patient, visit, form, section, itemset, or item.
Patient to Control	PatientID, VisitID, FormIndex, ItemsetIndex, VisitIndex, FormID, SectionID, ItemsetID, ItemID and five ControlIDs. Note: A target table with the Patient to Control key type also contains a data label that can be used for data selection. The data label is specified in the Data Label custom property of the item.	Each control on a separate row.