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
Ignored Actionable
Ignored Unactionable
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
Procedure Orders
Endoscopy Diagnoses
Endoscopy Indication
Endoscopy Procedure Diagnosis
Cardiology Measurement
Cardiology Finding
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
Blood Product Administration
Preoperative Acuity Level
Intraoperative Acuity Level
PACU Acuity Level
Phase II Acuity Level
Blood Order Reasons
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
Blood Product Scan Override Reason
Blood Patient Scan Override Reason
Blood Admin Mapped Action
Dental Procedure Completing Provider
Compass Rose Episode
Line LDA Type
Breast Imaging Lesion Assessment
Breast Imaging Finding Type
Line Placed Region
Drain Placed Region
Surgery Registry Metric
Drain LDA Type
Surgical Procedure ICD Code
Blood Type
Associated Procedure
Surgical Procedure
Preoperative Diagnosis
Postoperative Diagnosis
Blood Product Type
Blood Order Reasons Old
Associated ICD Procedure
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
Compass Rose Episode Management Type
Compass Rose Episode Class
Compass Rose Episode Encounters
Compass Rose Episode Social Driver of Health
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
Discharge Planning
Compass Rose Episode SDOH Domains
Discharge Delays
Compass Rose Program Category
Tympanogram Type
Audiology Order Procedure
Fertility
Embryology Specimen
Embryology Procedure
Fertilization Method
ART Procedure
Lab Procedure
Cycle Complication
Cycle Outcome
Cycle Status
Specimen State
Specimen Type
Oocyte Maturity
Procedure Insemination Method
Embryo Stage
Blastocyst Grade
Respiratory Support
Respiratory Support Episode
Skin Risk Assessment
Skin Risk Assessment Value
Parental Height
Insulin Instructions
Growth Chart Events
Fertility Race
Fertility Reason For Treatment
Fertility Sperm Collection Method
Insulin Instructions Medication
Insulin Instructions Provider
Fertility Procedure Type
Custom Mapped Value
Infection Control Reporting Locations
Infection Control Metric Data
Census Reporting Location
LDA Metric Reporting Location
Census Metric Reporting Location
Days Present Reporting Location
AU Admin Reporting Location
Abstraction Reporting Location
Abstraction Reporting Hospital
Fall Risk Assessment
Fall Risk Assessment Value
Morse Fall Risk History
Morse Fall Risk Mental
Morse Fall Risk IV
Morse Fall Risk Gait
Morse Fall Risk Secondary Diagnosis
Morse Fall Risk Ambulatory Aid
Hester-Davis Fall Risk Toileting Needs
Hester-Davis Fall Risk Sensory
Hester-Davis Fall Risk Last Known Fall
Hester-Davis Fall Risk Mobility
Hester-Davis Fall Risk Mental Status
Hester-Davis Fall Risk Medications
Hester-Davis Fall Risk Behavior
Hester-Davis Fall Risk Electrolyte Balance
Consciousness Assessment
Consciousness Assessment Value
GCS Eye Response
GCS Verbal Response
GCS Motor Response
PGCS Eye Response
PGCS Verbal Response
PGCS Motor Response
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
Cardiology Finding Type
Cardiology Subfinding Type
Cardiology Stage
Cardiology Repeatable Finding Type
Cardiology Annotation Type
Cardiology Intervention Type
Cardiology Pre-Stenosis Grade Type
Cardiology Coronary Dominance
Cardiology Wallscoring Diagram
Cardiology Post-Stenosis Grade Type
Result Component Unit
Element ID Concept
Wound LDA
Wound LDA Region
Documented Primary Wound Type
Documented Secondary Wound Type
Concept Primary Wound Type
Concept Secondary Wound Type
Legacy Primary Wound Type
Legacy Secondary Wound Type
FLO Name Primary Wound Type
FLO Name Secondary Wound Type
Wound Outcome
Type of Wound LDA
Wound Assessment
Wound Assessment Row
Wound Assessment Value
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
Braden Sensory Perception
Braden Moisture
Braden Activity
Braden Mobility
Braden Nutrition
Braden Friction and Shear
Braden Q Friction and Shear
Braden Q Tissue Perfusion and Oxygenation
Braden QD Sensory Perception
Braden QD Mobility
Braden QD Nutrition
Braden QD Friction and Shear
Braden QD Tissue Perfusion and Oxygenation
Braden QD Repositionability
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.