Element descriptions

The description of each element in this document might include the following:

• Data displayed—The type of data that is returned in the report. Possible values are:
  • Numeric
  • String (text)
  • Date/Time
  • Y/N
• Description—A brief description of the element.
• How calculated—Information about how data is calculated. (Included only for counts.)
• Data source—A description of where the data came from.

  Data source

  Data source	Description
  Replicated from the InForm Transactional database to the Reporting and Analysis database (not a derived value).	This data resides in both the InForm Transactional database and in the Reporting and Analysis database.
  Replicated from the InForm Transactional database to the Reporting and Analysis database. Database value has been decoded for display.	This data resides in both the InForm Transactional database and in the Reporting and Analysis database. The value has been derived for display. For example, a Y/N value that displays in a report may be stored as a 0/1 value in the database.
  Derived by the InForm Ad Hoc Reporting workspace. Not stored in the Reporting and Analysis database.	This data is derived when you run a report. The data does not appear in any InForm database.
  Derived and stored in the Reporting and Analysis database.	This data is derived by the InForm Ad Hoc Reporting workspace and resides only in the Reporting and Analysis database.

• Date type—A description of the type of date displayed. (Included only for dates.)

  Data type

  Date type	Description
  System date (GMT).	A date recorded by the InForm application at data entry. All Oracle production servers are set to GMT time.
  System date and time (GMT).	A date and time recorded by the InForm application at data entry.
  System date (GMT), derived for display.	A date recorded by the InForm application, but derived for display. For example, the Form Status by Month, Year report element returns only the Month and Year portion of the date.
  Reporting and Analysis database system date and time.	A system date on the Reporting and Analysis database server.
  Clinical.	A date entered by an InForm user in local time.
  Specified in study design code.	A date specified in the study MedML.
  May be specified in study design code. If not, this is a system date.	A date that may be specified in the study MedML. If it is not, the date is a date recorded by the InForm application at data entry.

• Example—An example to help illustrate a calculation or concept.

For more information, see Reporting on study management data.