Reporting With Audit Trails

Question 1

True or False: No Add single Response item in chronicles will only store the single current value for an item?

Answer 1

True, an example of this is the legal sex of a patient. When a patient legally changes their sex, the value stored in EPT 130 will be change to reflect the current sex of the patient for all contacts on that patients record.

Question 2

In Caboodle, what type of columns track changes to the data?

Answer 2

A snapshot table will have one or more snapshot columns which track changes.

Question 3

A report requiring historical data can be written using caboodle’s snapshot data when all of the following are true:

Answer 3

• There is no other audit trail available
• A snapshot column exists for the data in question
• The column has been regularly extracted during the time period covered by the report.
• It is not important to have the full change history of the data.
• It is sufficient to say values at the end of the day.

Question 4

True or False: All audit trails are stored inside caboodle?

Answer 4

False, some audit trails are stored outside of chronicles items.

Question 5

Why could audit trails be purged.?

Answer 5

some audit trails are stored outside of chronicles items. These audit trails are often large. As a result, once enough data has accumulated in the audit trail, it may be purged from the operational server, after which it can only be found in clarity.

Question 6

True or False: Audit_ITM table is in chronicles?

Answer 6

False, this table is in clarity.

Question 7

(Video) When can’t an audit report be done using caboodle’s snapshot data?

Answer 7

• The snapshot column is too new or does not exist
  *ETL disruptions at critical points
• Someone wants to know the source of the change
  *Someone wants a full list of changes

Question 8

If you are told “I need to see what a specific user is doing in the system” what table would you use?

Answer 8

ACCESS_Log and ACCESS_WRKF

Question 9

Snapshot data in Caboodle:

Answer 9

Some columns in caboodle will track changes using snapshot columns. A snapshot table allows for the storage of current and historical data. If you are trying to audit using caboodle, you are the grace of the ETL process

Question 10

Audit Item Tables:

Answer 10

Some audit trails are stored only in clarity and those tables are Aufit_ITM. These tables begin with audit_itm and are designed to audit any item in chronicles for which auditing is turned on.

Question 11

ACCESS_LOG and ACCESS_WRKF

Answer 11

These tables are event auditing tables. The information in these tables allow you to look at what users are doing or to see who has accessed a certain persons data.

Question 12

Find an audit trail that is extracted from Chronicles items.

Answer 12

1. You would open the patient most recent contact in the record viewer.
2. To the right in the text search, you would put the item you want to audit.
3. Now, when looking at the item, in the related group you can see the change history of the item.

Question 13

When a report request can or can’t be met with Caboodle’s change tracking

Answer 13

When CAN you use Caboodle:
* There is no other audit trail available
* A snapshot column exists for the data in question
* The column has been regularly extracted during the time period covered by the report.
* It is not important to have the full change history of the data.
* It is sufficient to say values at the end of the day.

When can you NOT use caboodle?
* The snapshot column is too new or does not exist
*ETL disruptions at critical points
* Someone wants to know the source of the change
*Someone wants a full list of changes

Question 14

Why some audit trail reporting cannot be done from Chronicles or Caboodle

Answer 14

Some audit trains are stored outside of chronicles because they get too big. As a result it gets thrown into clarity. The tables are all tables that start with AUDIT_ITEM, ACCESS_LOG, and ACCESS_WRKF.