What do the RDE Analytics tables in the Annotated Study Book contain?

RDE Analytics tables are listings of the column names that are generated when study data is extracted to the InForm reporting database.

Field	Description
Data Variable	Title of the item for which the column names are generated, or RefName if Show Object RefNames is selected in the Annotated Study Book Options dialog box.
RD Column Name	Name of the column in the reporting database where the data will be inserted. Column names consist of the item RefName or the RefName concatenated with a suffix. All types of top-level items have a column with the suffix _ND to hold the reason that an item is not done or incomplete. The format of the other column names generated for an item depends on the type of item. For child items of compound items, the RefName of the parent and child items are concatenated before the suffix. If the RefName part of the generated column name exceeds 25 characters, an asterisk appears in front of the column name to indicate that it will not match the actual RDE output. A footnote explains the asterisk. If an item is used multiple times on a form, an asterisk appears in front of the column name to indicate that it might not match the actual RDE output. A footnote explains the asterisk.
Column Data Type	Data type of the column.
-	Note: For each form, items that are outside of a section on a form and items that are in a nonrepeating section are included in a table. If a form contains a repeating section, each repeating section has its own table and the items in the repeating section are listed in the corresponding table for the repeating section.

Example of an RDE Analytics table and its annotated form

Description

Illustration

1—Study object RefName or Title. 2—Column name as it is generated in the InForm reporting database. a—Complete date time item. No suffix. b—Date time item with only date parts. c—Comment on item, reason why item was not done, or reason why item is incomplete. d—In an item with radio or checkbox controls or a drop-down list, the coded value for the selected control. e—In an item with radio or checkbox controls or a drop-down list, the label for the selected control. f—Child item in a compound or conditional item. RaceOther is a text item within the Race radio group. The column name contains the RefName of the parent item, a hyphen, and the RefName of the child item. g—Entered value of an item with units. h—Normalized value of an item with units. i—Unit symbol for an item with units. j—Normalized unit symbol for an item with units.