Reporting with Audit Trails

Question 1

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

Answer 1

The Record Viewer is an excellent place to investigate for more information.

(Aug. 2021, 6.4)

Question 2

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

Answer 2

Audit item tables.

Aug. 2021, 6.11

Question 3

What is the prefix for audit item tables?

Answer 3

AUDIT_ITM

Aug. 2021, 6.11

Question 4

What do audit item tables store?

Answer 4

Audits of items.

Aug. 2021, 6.11

Question 5

What is the general strategy for audit reporting?

Answer 5

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)

Question 6

What do tables ACCESS_LOG and ACCESS_WRKF store?

Answer 6

Epic’s generic event auditing structure.

Aug. 2021, 6.12

Question 7

What stores audit trails?

Answer 7

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)

Question 8

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

Answer 8

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)

Question 9

Why would a table ever be joined to itself?

Answer 9

If both entities are found in the same table.

This is also an example of when table aliases are required.

(6.25)