Queries: Properties

Queries: Properties report elements let you report on different types of queries.

Report element	Description
Query Type	Data type: String Description: The type of query. Valid values are: Automatic—An automatic query is a query that the Oracle InForm application automatically generates when a rule in the study design detects a discrepancy in entered data. Manual—A manual query is a query that an Oracle InForm user enters. Conflict—A conflict query is a query that the Oracle InForm application automatically generates when it detects a discrepancy between different copies of the same study when users synchronize them, or that is entered in the Oracle InForm Adapter query interface. This query type exists only when the Oracle InForm application is used with the CIS application. Data source: Replicated from the Oracle InForm transactional database to the Reporting and Analysis database and decoded for display.
Is Automatic	Data type: Y/N Description: Indicates whether the Oracle InForm application automatically generated the query. Valid values are: Y—The query is automatic. N—The query is either a manual or conflict query. Data source: Replicated from the Oracle InForm transactional database to the Reporting and Analysis database and decoded for display.
Is Manual	Data type: Y/N Description: Indicates whether an Oracle InForm user entered the query manually. Valid values are: Y—The query is manual. N—The query is either an automatic or a conflict query. Data source: Replicated from the Oracle InForm transactional database to the Reporting and Analysis database and decoded for display.