Non-pivot table key types

In tables with non-pivot table key types, each key type specifies how much of the control path of a mapped control is used to make up the primary key of the target table. For example, the primary key of a table with the Patient to Form key type consists of columns containing the PatientID, VisitID, ItemsetIndex, VisitIndex, and FormID. Tables with the following key types operate in this way:

Key type	You might choose this key type if you want...
Patient Only	All data for a patient in one row
Patient Visit (default)	All data for a visit in one row, with a new row for each patient or visit
Patient to Form	All data for a form in one row, with a new row for each patient, visit, or form
Patient to Section	All data for a section in one row, with a new row for each patient, visit, form, or section
Patient to Itemset	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	All data for an item in one row, with a new row for each patient, visit, form, section, itemset, or item
Patient to Control	Each control on a separate row

Because the pivot table key types do not support transfer of itemset data, you must choose one of the non-pivot table key types in order to create CDD mappings for data in an itemset.

When you create a control path definition, you can specify a Data Label as a property of the control path. When the target table has a key type of Patient to Control, the Data Label becomes a column in the target table. This enables you to select data without knowing the sequence of IDs that makes up the target table’s key columns. For other key types, the Data Label text has a documentation function and is not transferred to the CDD target table.