AUTO_TASK_AUDIT

Description:

This table contains the audit history for tasks that have been created or updated by the Event Engine. This table stores the following audit history for a task: triggering event, event source, event contact serial number (CSN), event time, and action taken on the task.

Primary Key

Column Name	Ordinal Position
TASK_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	TASK_ID	VARCHAR	No
	The unique identifier for the task instance record.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	ADT_EVENT_C_NAME	VARCHAR	No
	Audit table for automatically created outpatient tasks - the event that created the task. May contain organization-specific values: No Category Entries: Inpatient Hospital Admission Undo Inpatient Hospital Admission Basic Hospital Admission Undo Basic Hospital Admission External Hospital Admission Hospital Discharge Undo Hospital Discharge External Hospital Discharge Emergency Department Arrival Undo Emergency Department Arrival Emergency Department Dismissal Undo Emergency Department Dismissal External Emergency Department Visit External Emergency Department Visit End
4	EVENT_SOURCE_C_NAME	VARCHAR	No
	The category ID for the source of the event that triggered the automatic task change. May contain organization-specific values: No Category Entries: Internal Internal External
5	EVENT_CSN_ID	NUMERIC	No
	The unique contact serial number of the patient encounter that corresponds with the event that triggered the automatic task change.
6	EVENT_TIME_UTC_DTTM	DATETIME (UTC)	No
	Audit table for automatically created outpatient tasks - the timestamp of the event that created the task.
7	ACTION_C_NAME	VARCHAR	No
	Audit table for automatically created outpatient tasks - the action the event took on the task. May contain organization-specific values: No Category Entries: Created Created Deleted Added Medication Removed Medication
8	RX_FILL_ACTION_TYPE_C_NAME	VARCHAR	No
	Audit table for automatically created outpatient tasks - the prescription fill status that created the task. May contain organization-specific values: Yes Category Entries: New Pending Rx Entry Scheduled Fill Pending Fill Fill Rejected Waiting For Approval Ready to Fill Fill Initiated Filled Ready to Verify Fill Rejected Verified Ready to Package Ready to Transport In Transit Received Waiting for Filling Pharmacies Ready to Dispense Dispense Documented Dispense Received from External System Dispensed Shipped Delivered Consult Completed Approved Refill Request Denied Refill Request Profiled Canceled Order Edited Flag Removed Fill Returned Fill Wasted Clinically Reviewed Clinical Changes Reviewed Charge Payment Bagged Toted Trucked Boxed Packaged Sealed Barcode Scan Patient Notification Abandoned Rx Sale Needs Tracking Number No Sale Completed Authentication Payment Amount Changed Invalidated Billing Item Prescription Revision Needed Prescription Revised IP Dispense Prepared IP Dispense Prep Started IP Dispense Prep Saved Work IP Dispense Prep Pending Final Review IP Reused For Another Dose Dispense Prep IP Reused From Previous Dose Dispense Prep IP Dispense Prep Partial Complete IP Dispense Prep Resumed IP Dispense Prep Stopped IP Dispense Prep Saved on Admin IP Dispense Checked IP Dispense Prep Partial Check IP Dispense Prep Revise IP Dispense Prep Requeued IP Dispense Rejected IP Dispense Check Removed IP Dispense Check Started IP Second Dispense Check IP Dispense Final Label Check IP Final Label Check Deferred IP Added to Dispense Queue IP Printed From Dispense Queue IP Automatically Removed From Dispense Queue IP Manually Removed From Dispense Queue Rx Dispense Sent Rx Dispense Received Rx Cancel Tracking Action IP Dispense Prepared via Interface Download Request Pending Download Request Submitted Download Successful Download Request Rejected Download Request Canceled Download Error Download Not Attempted Sale Completed Sale Updated Sale Canceled Sale Price Override Approved Sale Pending Fee Sold in POS Waiting on Third Party Tax Exemption Applied Tax Exemption Removed Tax Charge Rx Inv Stock Location Overridden Rx Inv Stock Location Override Removed Not Dispensed HI Shipment Started HI Shipment Audited HI Dispensed HI Worksheet Printed HI New Revision HI Meds Staged HI Supplies Staged HI Meds Stage Checked HI Supplies Stage Checked HI Staged HI Stage Checked HI Meds Packed HI Supplies Packed HI Packed HI Ready To Ship HI Post Shipment Change HI In Transit HI Delivered HI Complete HI Canceled
9	SRC_MEDICATION_ID	NUMERIC	No
	Audit table for automatically created outpatient tasks - the medication that triggered a prescription fill status event.