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	Description
  Replicated from the Oracle InForm Transactional database to the Reporting and Analysis database (not a derived value).	This data resides in both the Oracle InForm Transactional database and in the Reporting and Analysis database.
  Replicated from the Oracle InForm Transactional database to the Reporting and Analysis database. Database value has been decoded for display.	This data resides in both the Oracle 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 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 Oracle InForm database.
  Derived and stored in the Reporting and Analysis database.	This data is derived by the Cognos 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.)

  Date type	Description
  System date (GMT).	A date recorded by the Oracle 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 Oracle InForm application at data entry.
  System date (GMT), derived for display.	A date recorded by the Oracle 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 Oracle 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.