# The Reporting and Analysis database

All data used for reporting resides in the Reporting and Analysis database, a database schema that is replicated from the InForm transactional database schema. Because data for reports is stored separately from InForm transactional data, you can write and run reports in the Reporting and Analysis module without affecting the performance of the InForm application.

Data in the Reporting and Analysis database is updated in real time, allowing you to access up-to-date information for your study.

The Reporting and Analysis database contains two types of data:

- Study management data

  Study management data includes metrics and status data for a study. Use study management data to report on the completion status of your study. You can report on such things as the number of visits that are complete for a study or the number of forms that are frozen or locked.

  The Reporting and Analysis database study management schema is installed with each InForm installation. It is not specific to your study.

- Clinical reporting data

  Clinical data for reports includes data about each subject visit. Use clinical data to report on specific clinical questions and responses. You can report on such things as adverse events, vital signs information, and dosing records.

  The Reporting and Analysis database clinical schema is built from the forms that are installed with your study. Therefore, the clinical data available for reports is unique for each study.

Copyright © 2013 Oracle and/or its affiliates. All rights reserved.