In pivot tables, the target key type determines the composition of a pivot set. Within a pivot set, data points mapped to the columns that are not in the pivot set are repeated in each row. You might choose one of these target key types to be able to select all data values that have some related data value in common, for example, to select all lab values for a specific test that were collected on the same date.
The primary key columns are PatientID, VisitID, ItemsetIndex, VisitIndex, FormID, SectionID, ItemsetID, ItemID, and five ControlIDs. Pivot target tables also contain a data label that can be used for data selection. The data label is specified in the Data Label custom property of the item.
Target key types for pivot tables
Target key type | Pivot set components |
---|---|
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 |
Copyright © 2013 Oracle and/or its affiliates. All rights reserved. |
---|