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
No Available Build
Action Completed Externally
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
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 Tooth
Endoscopy Procedures
Patient Address History
Scheduling Data
Endoscopy Findings
Complication of Procedure
Complication Phase
Anesthesia Procedure Type
Anesthesia Record
Delivery-Based SDE
Pregnancy-Based SDE
Labor Exam Flowsheet
Labor Exam Fetal Station
Fetal Heart Rate Categorization
Panel Anesthesia Type
Case Classification
Registry Metric
Anesthesia Registry Metric
Anesthesia Type
Surgical Patient Class
Surgical Case
C-Section Type
Wound Class
Surgical Approach
Implant Action
Surgical Service
Race
Ethnicity
Language
Marital Status
Postal Code
Country
State
County
Encounter Provider Assignment
Dental Finding
Dental Procedure
Dental Implants
Endoscopy Diagnoses
Endoscopy Indication
Endoscopy Procedure Diagnosis
Provider Internal ID
Treatment Team Specialty
Treatment Team Role
Audiology Order
ADT Events
Endoscopy Suggested Findings
Audiogram
Tympanogram
Acoustic Reflex Result
Speech Audiometry Result
Medication Administration
Preoperative Acuity Level
Intraoperative Acuity Level
PACU Acuity Level
Phase II Acuity Level
Med Admin Dose Unit
Med Admin Concentration Unit
Surgical Laterality
Operative Region
Procedure Anesthesia Type
Last Immunization Registry Instant
Flowsheet Pain Group
Flowsheet Pain Row
Flowsheet Pain Row Answers
Hospital Service
Level of Care
Leave of Absence Reason
Line Placement
Drain Placement
Surgical Panel Procedure
Flowsheet Intake Group
Flowsheet Intake Row
Flowsheet Output Group
Flowsheet Output Row
Flowsheet Pain Severity
Flowsheet Pain Wong-Baker Scale
Flowsheet Pain Location
Flowsheet Pain Location Orientation
Flowsheet Pain Radiation
Flowsheet Pain Descriptors
Flowsheet Pain Frequency
Flowsheet Pain Interventions
Flowsheet Pain Onset Speed
Breast Imaging Lesions
Breast Imaging Findings
Breast Imaging Pathology Result
Breast Imaging Recommendation
Med Admin Mapped Action
Med Admin Route
Patient Scan Override Reason
Medication Scan Override Reason
Patient-Specific Package Scan Override Reason
Dental Procedure Completing Provider
Line LDA Type
Breast Imaging Lesion Assessment
Breast Imaging Finding Type
Line Placed Region
Drain Placed Region
Surgery Registry Metric
Drain LDA Type
Associated Procedure
Surgical Procedure
Preoperative Diagnosis
Postoperative Diagnosis
Breast Overall Assessment
Breast Right Assessment
Breast Left Assessment
Breast Overall Density
Breast Right Density
Breast Left Density
Breast Image Guidance Type
Breast Procedure Laterality
Breast Procedure Modality
Breast Lesion Classification
Breast Pathology Code
Breast Malignancy Type
Breast Biopsy Repeat Reason
Breast Recommendation Value
Audiology Order Diagnosis
Audiology Order Billing Provider
Audiology Order Authorizing Provider
Dental Finding Diagnosis
Dental Procedure Diagnosis
Dental Procedure EAP
Flowsheet Intake Type
Flowsheet Output Type
Acoustic Reflex SDE
Speech Audiometry SDE
Tympanogram Type
Audiology Order Procedure
Custom Mapped Value
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
Dermatology Finding
Dermatology Procedure
Dermatology Specimen
Dermatology SmartData
Dermatology Specimen Tracking
Dermatology Diagnosis
Dermatology Procedure Type
Dermatology Specimen Interpretation
Dermatology Region
Dermatology Specimen Source
Dermatology Specimen Type
Dermatology Specimen Coll Prov
Dermatology Specimen Auth Prov
Dermatology Finding Type
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.