Target key types for tables that do not pivot

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 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.

Copyright © 2013 Oracle and/or its affiliates. All rights reserved.