DOCS_RCVD_DEDUP_LNK
Description:
This table contains the logical link between data elements in the de-duplicated Received Documents (DXR) and the composite DXR record. An example of a data element can be an allergy or a reaction.

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 LOG_LNK_DDUP_REFIDS VARCHAR No
This item stores the unique reference ID for a deduplicated data element.
4 LOG_LNK_CMP_REFIDS VARCHAR No
This item stores the unique reference ID for data in the composite external document record.
5 LOG_LNK_DATA_TYPE_C_NAME VARCHAR No
This item stores what type of data the reference IDs correspond to.
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
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
Questionnaire
Clinical Note
Clinical Note Status
Clinical Note Patient Awareness
Clinical Note Author Specialty
Clinical Note Author Type
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 Study Data Order
Breast Imaging Study Data Pathology
Reference Payer
Reference Plan
Place of Service
ADT Event History
Eye Exams
Transplant Info Status
Transplant Info Reason
Transplant Info Managing Center
Episode
Risk Adjustment Data
Risk Adjustment Data Diagnosis
Home Care Episode
Home Care Visit
Home Care Visit Diagnosis
Mental Status
Generic Order
Medication Dispense Query
Treatment Plan
Treatment Plan Day
Patient Order Template
6 LOG_LNK_COMP_CSN NUMERIC No
The source document Contact Serial Number (CSN) for the corresponding data on the composite external document record.
7 LOG_LNK_CODE_SRC_YN VARCHAR No
Signifies whether the Contact Serial Number (CSN) stored in I DXR 7110 should be used for code-lookup for this reference ID.
May contain organization-specific values: No
Category Entries:
No
Yes
8 LOG_LNK_SRC_ORG_ID NUMERIC No
This item stores the organization this line of data originated from.
9 LOG_LNK_SRC_ORG_ID_EXTERNAL_NAME VARCHAR No
Organization's external name used as the display name on forms and user interfaces.