Reporting with Audit Trails Flashcards

1
Q

A manager needs to know who has made changes to patient demographics in the last six months.Will Caboodle likely be able to meet this report request?

A

No. snapshot change tracking does not track who made a change

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

How can data from two related groups in Chronicles be joined together in Clarity?

A

One related group can contain an item that stores the line number of a separate related group.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

T/F Chronicles uses one structure for all audit trails.

A

False. Although audit trails are often stored in related groups, the structures of audit trails vary.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Where should you begin your Clarity research when you have a sample data point?

A

The Record Viewer is an excellent place to investigate for more information.(Aug. 2021, 6.4)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What tables are designed to audit any item in Chronicles for which auditing is turned on?

A

Audit item tables.(Aug. 2021, 6.11)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is the prefix for audit item tables?

A

AUDIT_ITM(Aug. 2021, 6.11)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What do audit item tables store?

A

Audits of items. (Aug. 2021, 6.11)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is the general strategy for audit reporting?

A

To use items in chronicles for audit reporting if they are available.The item auditing tables should be used as a last resort.(Aug. 2021, 6.12)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What do tables ACCESS_LOG and ACCESS_WRKF store?

A

Epic’s generic event auditing structure.

-May 2022, 7.11

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What stores audit trails?

A
  1. Chronicles items (if set up to be audited)
  2. AUDIT_ITM tables (the set of tables that begin with AUDIT_ITM)

(Aug. 2021, 6.11)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

List the 6 steps that are involved in writing a query that requires joining tables:

A
  1. Identify the entities and relationships
  2. Define the cardinality of the relationships
  3. Identify the logical expressions for those relationships
  4. Determine whether to include entities for which the logical expression are never satisfied
  5. Write the FROM clause
  6. Write the SELECT clause

(6.5)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Why would a table ever be joined to itself?

A

If both entities are found in the same table.This is also an example of when table aliases are required.(6.25)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly