Contents
Changes in this guide
Release 7.0.1�Summary of changes
The Reporting and Analysis database
Overview of the Reporting and Analysis database
Naming conventions
Locales in the Reporting and Analysis module
Operational view descriptions
Study design metadata
IRV_STUDYVERSIONS
IRV_STUDYVERSION_VISITS
IRV_STUDYVERSION_FORMS
IRV_FORM_REVS
IRV_SECTION_REVS
IRV_ITEM_REVS
IRV_ITEMSET_REVS
IRV_CONTROL_REVS
IRV_MD_FORMS_CONTROLS
IRV_FORM_ASSOC
IRV_FORM_ASSOC_HISTORY
IRV_CUR_VISIT
IRV_SITE_STUDYVERSION_TIMES
IRV_VISIT_HELPTEXT
IRV_VISIT_NAME
IRV_VISIT_REVS
Study objects and administrative data
IRV_CUR_CONFIG
IRV_CUR_RULE
IRV_CUR_RULEITEM
IRV_CUR_SITE
IRV_CUR_SPONSOR
IRV_CUR_SUBJECT
IRV_CUR_SUBJECT_DIM
IRV_SUBJECT_STATE_CHANGES
IRV_CUR_SYSTEMVERSION
IRV_SYSTEMVERSIONS
IRV_CUR_USER
IRV_CUR_USERLIST
IRV_USERS_SITES
IRV_USER_ACTIVESTATE_CHANGES
RT_USER_BLINDED_ITEMS
IRV_SITE_REVS
IRV_SUBJECT_REVS
IRV_USER_REVS
Study operational data
IRV_SUBJECT_DROPOUT_REASON
IRV_SV_SUBJECTVISITS
IRV_AF_SUBJECT_FORMS
IRV_SV_SUBJECT_FORMS
IRV_CRF_STATUS_REPORT
IRV_FORM_ITEMS
IRV_CUR_COMMENT
IRV_CUR_QUERY
IRV_QUERY_STATE_CHANGES
IRV_ACTIVATED_FORMS
IRV_COMMENT_REVS
IRV_QUERY_REVS
Summary views
Form summaries
IRV_AF_ROLLUP_SITES
IRV_AF_ROLLUP_STUDY
IRV_AF_ROLLUP_STUDYVERSIONS
IRV_AF_ROLLUP_SUBJECTS
IRV_AF_ROLLUP_VISITS
Visit summaries
IRV_CSV_ROLLUP_SITES
IRV_CSV_ROLLUP_STUDY
IRV_CSV_ROLLUP_STUDYVERSIONS
IRV_CSV_ROLLUP_SUBJECTS
Item summaries
IRV_IC_ROLLUP_FORMS
IRV_IC_ROLLUP_SITES
IRV_IC_ROLLUP_STUDY
IRV_IC_ROLLUP_STUDYVERSIONS
IRV_IC_ROLLUP_SUBJECTS
IRV_IC_ROLLUP_VISITS
Subject summaries
IRV_SUBJ_ROLLUP_SITES
IRV_SUBJ_ROLLUP_STUDY
IRV_SUBJ_ROLLUP_STUDYVERSIONS
Identifying keys
Clinical view descriptions
Clinical metadata
RT_MD_DATADICTIONARY
RT_CV_MODELDICTIONARY
Clinical data table generation
CT_<FormRefname/Itemset> and CV_<FormRefname/Itemset> tables
RT_ELEMENTLABELS
RT_UNITS
RT_CONTROLDATA
RT_ACTIVATED_FORMS
RT_NOTDONE_CONTROL
RT_ITEMSTATE
Clinical data audit information
Study versioning
Alternate forms
Cognos models
Data model security
Auto-generated mappings
Structural mappings
Naming conventions for mappings
Built-in columns for views
Key columns
Metric columns
Additional columns
Visits
Forms
Sections
Itemsets
Items
Controls
Simple controls
Text controls
Drop-down lists
Calculated controls
Date controls
Radio controls
Checkbox controls
Group controls
Examples of auto-generated mappings
Form definition in the Central Designer Project Explorer
Display in the InForm application
Clinical view schema
Reporting Data Extracts (RDEs)
RDE design
RD_DATADICTIONARY
RT_MD_VIEWDICTIONARY
RD_VIEWDICTIONARY
About RD views
Columns in RD views
Column naming conventions for RD views
Creating a custom RDE
Creating a customization script
Running the customization script
Example: Drop a view
Example: Drop a column from an existing view
Example: Change a column name
Example: Change a view name
Example: Add a where clause to a view
Example: Add a column to a view
Requesting the extract�Hosted customers only
Appendix
Mapping Central Designer terms to InForm terms
Revision History