a. Quick Start Video

This video introduces the basic functionalities of the Query Tool through building a series of simple queries.

b. What is a Query?

  i. Definition of a Query

  ii. Life Cycle of a Query

  iii. Results of a Query

      1) Patient Number is the default result

      2) Other Options are available (see 3. Finding Patients (Query Tool))

      3) Detailed medical data are not part of the results the Query Tool can provide. Other steps are required.

c. Building a New Query

    i. Including Terms

       1) Dragging and Dropping

       2) Including a Previous Query

       3) Including a Query Result (Patient Set/ Patient)

       4) Including a Folder in Workplace

    ii. AND/OR Operators

       Order of Precedents

    iii. How to use a lab test (terms with values)

    iv. Run Query and Clear buttons

d. Resetting the Query Tool (Clear)

e. What Happens when a query gets queued?

f.  Rerun a Previous Query

g. Advanced Query Options

    i.Output Options

        1) Patient Set

        2) Encounter Set

        3) Number of Patients

        4) Gender Patient Breakdown

        5) Vital Status Patient Breakdown

        6) Race Patient Breakdown

        7) Age Patient Breakdown

        8) Timeline

        9) Length of Stay Breakdown

        10) Top 20 Medications Breakdown

        12) Top 20 diagnoses Breakdown

        13) Inpatient and Outpatient Breakdown

    ii. Managing Groups

        1) Additional Groups

        2) Shifting Group Order

        3) Delete Groups

    iii. Specifying Constraints

        1) Date Constraints  (Panel-level and Term-level)

        2) Negation (Exclude)

        3) Occurrences

    iv. Value Constraints

    v. Modifiers

        1) What are they?

        2) Has Value Constraints like Labs

        3) How are they represented in Navigate/Find Terms

            - Modifier

            - Modifier Container

    vi. Query Timing

        1) Treat all groups independently (default)

        2) Select Groups occur in the same financial encounter

        3) Define sequence of events (Temporal Query)

            - Simple

            - Advanced

            - Some Concepts do not make sense here (Put them in the Population )

h. Example Queries

  i. Simple Query: "Finding patients with a diagnosis A or a diagnosis B or has lab test C."

  ii. Running a Previous Query

  iii. Temporal Query (Simple)

  iv.  How to find Patients with >1 diagnosis X OR >1 diagnosis Y  (Using nested queries)