DOCS_RCVD_ACTN_AUD

Description:

This table stores the action audit performed on the discrete data.

Primary Key

Column Name	Ordinal Position
DOCUMENT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	DOCUMENT_ID	NUMERIC	No
	This item stores the Received Document record ID.
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	ACT_AUD_REF_ID	VARCHAR	No
	This item stores the reference identifier associated with the discrete data.
4	ACT_AUD_ACT_TYPE_C_NAME	VARCHAR	No
	This item stores the type of action performed on the discrete data. May contain organization-specific values: No Category Entries: Filed Ignored Restored Partially Filed Reconciled Discontinued Updated Created Not Current Canceled Link Prescription Paused Unpaused Discarded Permanently By Cleanup Utility Discarded Once By Cleanup Utility Historical Marked Historical By Cleanup Utility Removed By Claims Datalink Updated By Claims Datalink Removed By Claims Cleanup Utility Updated By Remap Utility Marked Historical by DXO setting 85513 Auto Discarded Updated By Code Replacement Utility Excluded From Composite Removed at Source Organization Updated By Cosmos Update Mapping Batch Job Filtered For Demographics By Claims Datalink Filtered For Transplant By Claims Datalink Removed By Cosmos Result Component Purge Utility Hidden Auto Restored Discarded By Negative Allergy Names Filter Discarded Due To Similarity With A Prior Discard Marked Historical By User Discarded For History Reconciliation Discarded By Medication Grouper Discarded By Medication Name Filter Discarded by Problems Grouper Marked Historical by Acute Problems Grouper Ignored as History Conflict or Duplicate Ignored as Internal Duplicate Auto Reconciled Error Sending Discontinue Filed by Patient Ignored by Patient Dispense Cancelled By Outside Pharmacy Auto-Reconciliation Reverted By Cleanup Utility Auto Merged Accepted Deferred Returned Replaced Completed Expired Masked by Cosmos Result Procedure Name Utility Deleted Cosmos unreconciled data Replaced by Claims Exchange Filed by Automatic Conversion Utility New Pend New Sign Reorder Pend Reorder Sign Change Pend Change Sign Audit Action Reverted
5	ACT_AUD_ACT_USER_ID	VARCHAR	No
	This item stores the ID of the user performing the action on discrete data.
6	ACT_AUD_ACT_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
7	ACT_AUD_ACT_INST	DATETIME (Local)	No
	This item stores the instant of the audit action on the discrete data.
8	ACT_AUD_ASSC_CSN	NUMERIC	No
	This item stores the associated contact where the discrete data resides.
9	ACT_AUD_LPL_ID	NUMERIC	No
	This item stores the ID of the Problem List record if the discrete data was filed into the Problem List.
10	ACT_AUD_ORD_ID	NUMERIC	No
	This item stores the ID of the Orders record if the discrete data was filed into an Order record.
11	ACT_AUD_ACT_DESC	VARCHAR	No
	This item stores additional description about the action being taken.
12	ACT_AUD_DATA_TYPE_C_NAME	VARCHAR	No
	This item stores the data type associated with the audit action. May contain organization-specific values: No Category Entries: Allergy Problem Medication Ingredient Dispense Immunization Vital Diagnosis Medical History Medication Dispensed Procedure OB Hx Delivery Encounter Goal Department Specialty PCC Note Health Maintenance Care Team Relationship Provider Specialty and Type Result Procedure Result Component Result Value Result Specimen Type Result Specimen Source Social History Type Social History Value Surgical History Family History Relationship Family History Problem Assessment Scale Type Procedure Target Site Procedure Laterality Allergy Reaction Type Medication Route Medication Form Allergy Reaction Allergy Reaction Severity Allergy Criticality Allergy Severity Cause of Death Goal Type Result Type Billing Diagnoses Billing Procedure Pediatric Vital Pediatric Vital Delivery Method Immunization Route Reason For Visit Body Location Medication Discontinue Reason Medication Indication of Use Payer Kanta Social Care Customer Type Medication Dose Unit Mode of Arrival Discharge Disposition Acuity Level ED Disposition Antibiotic Organism Susceptibility Interpretation Antibiotic Test Method Research Study Identifier Study Association Identifier Peer Group Obstetric History Delivery Method Obstetric History Anesthesia Obstetric History Complication Immunization Deferral Duration Immunization Product Immunization External Admin SmartData Value SmartData SmartData Source Note Type SmartData Element Infection Result Component Abnormality Flag Medication Frequency CRQ Data Flowsheet Ventilator Episodes Oxygen Delivery Method Ventilator Mode Ventilator Device Associations Ventilator Class Intubations LDA Type ICU Stay ICU Stay Department Specialty Questionnaire Clinical Note Clinical Note Status Clinical Note Patient Awareness Clinical Note Author Specialty Clinical Note Author Type Treatment Code Status Treatment Permitted Treatment Restriction Verified With Genomic Indicator Respiratory Support Flowsheet Values Respiratory Support Oxygen Delivery Method Assessment Question Assessment Answer Social Driver Domain Social Driver of Health SDOH Intervention SDOH Intervention Service Recommended Abstractions Coding Status Immunization Dose Unit Reportability Reportability eICR Information Quality Measure Intervention Medication Order Medication Order Indication of Use Growth Chart Codes Clinical Note Sections Timing Cancer Stage Cancer Type Histopathologic Type Questionnaire Answer Questionnaire Question Questionnaire SDE Problem Laterality Transplant Info Transplanted Organ Info Department Ingredient Type Obstetric History Augmentation Obstetric History Augmentation Indication Obstetric History Cervical Ripening Obstetric History Rupture Obstetric History Episiotomy Obstetric History Induction Obstetric History Induction Indication Obstetric History Laceration Obstetric History Adoption Type Obstetric History Placenta Method Obstetric History Presentation Type Obstetric History Cesarean Indication Obstetric History Living Status at Birth Pregnancy Dating Pregnancy Dating Event Basis Breast Imaging Lesion Breast Imaging Finding Breast Imaging Pathology Research Study Type Research Study Area of Research Risk Score Breast Imaging Study Data Order Breast Imaging Study Data Pathology Reference Payer Reference Plan Place of Service ADT Event History Eye Exams Transplant Info Status Transplant Info Reason Transplant Info Managing Center Episode Risk Adjustment Data Risk Adjustment Data Diagnosis Home Care Episode Home Care Visit Home Care Visit Diagnosis Mental Status Generic Order Medication Dispense Query Treatment Plan Treatment Plan Day Patient Order Template
13	ACT_AUD_PROC_ID_PROC_NAME	VARCHAR	No
	The name of each procedure.
14	ACT_AUD_ERX_ID_MEDICATION_NAME	VARCHAR	No
	The name of this medication record.
15	ACT_AUD_DC_RSN_C_NAME	VARCHAR	No
	This item stores the discontinue reason for the discontinue action made on an external medication. May contain organization-specific values: Yes
16	ACT_AUD_DC_RSN_FT	VARCHAR	No
	This item stores the free-text discontinue reason for the discontinue action made on an external medication.
17	ACT_AUD_LOC_UPD_TYP_C_NAME	VARCHAR	No
	This item stores the type of action performed on local data using external data. May contain organization-specific values: No Category Entries: Added as Inactive (Primary) Added as Inactive (Secondary) Local Updated With Active Local Made Inactive (Primary) Local Made Inactive (Secondary) Local Kept Inactive (Generic) Local Kept Inactive (Primary to Secondary) Local Kept Inactive (Secondary to Primary) Simultaneously Added and Made Inactive (Primary) Checksum Version Updated Simultaneously Updated Local With Active And Made Inactive (Primary) Added as Inactive (Tertiary) Local Made Inactive (Tertiary) Local Kept Inactive (Tertiary to Primary)
18	ACT_AUD_INF_ID	NUMERIC	No
	This item stores the ID of the Infections record if the discrete data was filed into an Infections record.
19	ACT_AUD_EDG_DX_ID_DX_NAME	VARCHAR	No
	The name of the diagnosis.
20	ACT_AUD_ORD_CONTACT_DATE	NUMERIC	No
	This item stores the DAT of the ORD record if the discrete data was filed into ORD.
21	ACT_AUD_NOTE_ID	VARCHAR	No
	The unique ID of the a note which was auto-reconciled from a C-CDA document and was later deleted by the Auto-Reconciled Notes Cleanup Utliity.