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
Key columns in operational tables and views
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.
Database view
Cognos model