Previous Topic

Next Topic

Book Contents

Book Index

AD_QueryList

This view contains each query and identifies which entity (patient, visit, form, or item) the query applies to, whether the query is system-generated or manual, query status, and who issued the query and when it was issued.

AD_QueryList report view

Column

Description

ID

Database identifier of the query.

QUERY_ID

Identifier of the query as it appears in the user interface.

PATIENT_ID

Unique identifier for the patient.

PATIENT_DISPLAY_ID

Identifier of the patient as displayed in the user interface.

OBJECTID

Visit name.

OBJECT_LEVEL

Identifier of the object level.

QUERYELEMENT

Element type on which query has been issued:

  • Patient
  • Visit
  • Form
  • Item

VISIT_NAME

Name of the visit as displayed in the user interface. Visit name associated with the query. (Could be NULL if manual query is raised against visit or patient.)

FORM_NAME

Form that the query was issued against. (Could be NULL if manual query is raised against visit or patient.)

ITEM_TEXT

Label of the item on which the query was issued.

DATAVALUE

Data value of the item on which the query was issued.

QUERY_TEXT

Text that appears in the query.

QUERY_STATE_ID

Identifier of the query state.

QUERYSTATE

Query status:

  • Open
  • Answered
  • Approved
  • Closed
  • Candidate
  • Deleted

AUTHOR

Account name of the user who issued the query.

If the query is an autoquery, this column is populated with System.

ORIGINATOR

Account name of the user who first created the query.

QUERYTYPE

Type of query:

  • System
  • Manual

FTIMESTAMP

For system-issued queries, the date and time that the query was issued.

CREATE_TIME

Date and time when the query was issued.

MODIFY_TIME

Date and time the query was last updated.

SITE_DISPLAYID

ID of the site as displayed in the user interface.

SITE_NAME

Name of the site as displayed in the user interface.

STAFF_ID

Staff ID.

LISTVALUEVALUE_ID

List value ID.

VISIT_ID

Database identifier of the visit.

FORM_ID

Database identifier of the form.

TRANSLATETEXT

Translation of the query text, if the study is translated into multiple languages.

VALIDATIONACTION_ID

Validation action identifier associated with the query.

RESPONSE

Query response text.

RESPONDENT

First and last name of the user responding to the query.

SITEID

Database identifier of the site. (Can be NULL.)

LAN_ID

Identifier of the language, enabling you to filter the view by language.

Copyright © 2011 - 2014 Oracle and/or its affiliates. All rights reserved.