Reporting with Audit Trails Flashcards
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?
No. snapshot change tracking does not track who made a change
How can data from two related groups in Chronicles be joined together in Clarity?
One related group can contain an item that stores the line number of a separate related group.
T/F Chronicles uses one structure for all audit trails.
False. Although audit trails are often stored in related groups, the structures of audit trails vary.
Where should you begin your Clarity research when you have a sample data point?
The Record Viewer is an excellent place to investigate for more information.(Aug. 2021, 6.4)
What tables are designed to audit any item in Chronicles for which auditing is turned on?
Audit item tables.(Aug. 2021, 6.11)
What is the prefix for audit item tables?
AUDIT_ITM(Aug. 2021, 6.11)
What do audit item tables store?
Audits of items. (Aug. 2021, 6.11)
What is the general strategy for audit reporting?
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)
What do tables ACCESS_LOG and ACCESS_WRKF store?
Epic’s generic event auditing structure.
-May 2022, 7.11
What stores audit trails?
- Chronicles items (if set up to be audited)
- AUDIT_ITM tables (the set of tables that begin with AUDIT_ITM)
(Aug. 2021, 6.11)
List the 6 steps that are involved in writing a query that requires joining tables:
- Identify the entities and relationships
- Define the cardinality of the relationships
- Identify the logical expressions for those relationships
- Determine whether to include entities for which the logical expression are never satisfied
- Write the FROM clause
- Write the SELECT clause
(6.5)
Why would a table ever be joined to itself?
If both entities are found in the same table.This is also an example of when table aliases are required.(6.25)
