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