DOCS_RCVD_MAPPING_MISC

Description: |
This table stores mapping information associated with discrete data received from outside sources. This table only contains types of mappings which are not in the tables specific to their data type.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
DOCUMENT_ID | 1 |
CONTACT_DATE_REAL | 2 |
LINE | 3 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | DOCUMENT_ID | NUMERIC | No |
This item stores the Received Document record ID.
2 | CONTACT_DATE_REAL | FLOAT | No |
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3 | LINE | INTEGER | No |
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4 | CONTACT_DATE | DATETIME | No |
The date of this contact in calendar format.
5 | MAP_DATA_REF_ID | VARCHAR | No |
This item stores the data reference ID.
6 | MAP_DATA_TYPE_C_NAME | VARCHAR | No |
This item stores the mapping data type.
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
BH Flowsheet Assessment
BH Flowsheet Question
BH Flowsheet Question Response
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 Single Order Reason
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
7 | MAP_CODE | VARCHAR | No |
This item stores the mapping code associated with the coding system to represent the data.
8 | MAP_CODING_SYSTEM | VARCHAR | No |
This item stores the mapping coding system associated with the code to represent the data.
9 | MAP_DISPLAY_NAME | VARCHAR | No |
The display name of the mapping code in its code system