|
|
|
|
Pivot table key types
In tables defined with pivot table key types, each key type specifies how much of the control path of a mapped control is used to compose the matching key components of a pivot set in the target table. For example, a pivot set in a table with the Pivot Visit key type consists of rows in which the PatientID, VisitID, and VisitIndex of each data point match. Tables with the following key types operate in this way:
- Pivot Patient
- Pivot Visit
- Pivot Form
- Pivot Section
You might choose one of these key types in order 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.
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 pivot key type, any Data Label defined for a data point mapped to a pivot column becomes a column in the target pivot table. This enables you to select data without knowing the sequence of IDs that makes up the target table’s key columns.
