Control path

A sequence of IDs referring to the InForm software components that define the physical location of a data point in a trial and in the InForm software database. The control path of a data point consists of its patient, visit, visit index, form, section, itemset, itemset index, item, and controls.

DBUID

An ID that uniquely identifies a trial component (for example, an item) in the trial database. The primary key of a target table consists of a sequence of DBUIDs and indexes that correspond to the components of a control path.

Itemset index

A number that indicates a specific instance of an itemset row. If a data point is not in an itemset, its itemset index is 0.

Key type

A target table property that determines how the InForm software loads data into the target table. Two groups of key types are available: one group defines pivot tables, and the other defines non-pivot tables.

For more information, see Key types.

Pivot column

A column in a pivot table used to determine where to create duplicate entries of specified data points. When InForm software inserts data into a pivot table, it processes each pivot set in succession. In each pivot set, the InForm software creates a new row for each data point that is mapped to a pivot column. Then, it inserts the value of each data point that is mapped to a non-pivot column into each row of the pivot set. A pivot table can have only one pivot column.

For more information and for examples, see Pivot table key types.

Pivot set

A set of rows in a pivot table that are grouped by a portion of their composite key. The key type of the table specifies the parts of the table’s primary key used for the grouping. For example, if the table has a key type of Pivot Form, a pivot set consists of the rows inserted for all data points that have the same patient, visit, form, and visit index values in their control paths.

Pivot table

A type of target table in which the key type is Pivot Patient, Pivot Visit, Pivot Form, or Pivot Section, and in which one of the columns is defined as a pivot column.

Repeating form index

A number that indicates a specific instance of a repeating form row. If a data point is not in a repeating form, its repeating form index is 0.

Target column

A target table column that receives data from one or more data points in a trial database. Each data point from which data is transferred to a CDD is mapped to a specific target column. You can map multiple data points to the same target column.

Target table

A table in a CDD. Target tables receive the data that is transferred from a trial database. The target table parameter must be limited to 27 characters.

Visit index

A number that indicates a specific instance of a repeating visit. If a visit is not repeating, its visit index is 1.