Key columns

Key columns are not customizable and should only be used by advanced users. These columns serve as a key to the Reporting and Analysis operational tables and views, and include the following.

Key columns

View column name	View column type	Report element name	Element folder
SUBJECTID	NUMBER	SUBJECTID	Internal IDs
SITEID	NUMBER	SITEID	Internal IDs
STUDYVERSIONID	NUMBER	STUDYVERSIONID	Internal IDs
SUBJECTVISITID	NUMBER	SUBJECTVISITID	Internal IDs
SUBJECTVISITREV	FLOAT	SUBJECTVISITREV	Internal IDs
VISITID	NUMBER	VISITID	Internal IDs
VISITINDEX	FLOAT	VISITINDEX	Internal IDs
FORMID	NUMBER	FORMID	Internal IDs
FORMINDEX	FLOAT	FORMINDEX	Internal IDs
FORMREV	FLOAT	FORMREV	Internal IDs

The following examples illustrate generated key columns and items.

Figure 3-1 Database view

Figure 3-2 Cognos model