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 Question Answered 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 Automatically Discarded Once By External Chart Correction Message Transmitted Automatically Replaced with Medication Treatment 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 Immunization Deferral Reason 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 Dialysis Episode Questionnaire Dialysis Treatment Type Clinical Note Clinical Note Status Clinical Note Patient Awareness Clinical Note Author Specialty Clinical Note Author Type Clinical Note Procedure Clinical Note Pre-Procedure Dx Clinical Note Post-Procedure Dx 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 Order Breast Imaging Outcome Reference Payer Reference Plan Predictive Model Values Predictive Model Department Specialty Place of Service ADT Event History Breast Imaging Overall Asssessment Breast Imaging Right Assessment Breast Imaging Left Assessment Breast Imaging Overall Density Breast Imaging Right Density Breast Imaging Left Density Breast Imaging Image Guidance Type Breast Imaging Procedure Laterality Breast Imaging Modality Eye Exams Transplant Info Status Transplant Info Reason Transplant Info Managing Center Transplant Info Organ Failure Diagnosis Transplant Score Episode Risk Adjustment Data Risk Adjustment Data Diagnosis Home Care Episode Home Care Visit Home Care Visit Diagnosis Mental Status Problem Category Generic Order Pediatric Vital Feeding Method Medication Dispense Query Medication Question Entity Event Identifier Event Class Event Reason Treatment Plan Treatment Plan Day Patient Order Template Patient Messages Patient Messaging Conversations Tobacco Use Implant Mammography History Surgical Log Vital Component Deceased Information Surgical Log Line Implant Type Implant Manufacturer Implant Area Implant Laterality Implant Action Laterality Implant Charge Code Flowsheet Assessment Flowsheet Assessment Answer Flowsheet Assessment Answer Group Phenotype Dental Endoscopy Procedures Patient Address History Scheduling Data Endoscopy Findings Anesthesia Record Registry Metric Race Ethnicity Language Marital Status Postal Code Country State County Treatment Plan Goal Treatment Plan Line of Treatment Treatment Plan Reason for Discontinue Treatment Plan Hold Reason Treatment Day Defer Reason Treatment Day Cancel Reason
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.