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
Flowsheet Assessment
Flowsheet Assessment Answer
Flowsheet Assessment Answer Group
Phenotype
Dental
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
Endoscopy Diagnoses
Endoscopy Indication
Endoscopy Procedure Diagnosis
Provider Internal ID
Treatment Team Specialty
Treatment Team Role
ADT Events
Endoscopy Suggested Findings
Preoperative Acuity Level
Intraoperative Acuity Level
PACU Acuity Level
Phase II Acuity Level
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
Line LDA Type
Line Placed Region
Drain Placed Region
Drain LDA Type
Associated Procedure
Surgical Procedure
Preoperative Diagnosis
Postoperative Diagnosis
Flowsheet Intake Type
Flowsheet Output Type
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
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