DOCS_RCVD_RSLTS

Description: |
This table stores discrete results received from outside sources.

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 | RESULT_INST_DTTM | DATETIME (Local) | No |
Local instant for the result
6 | RESULT_PROC_NAME | VARCHAR | No |
Free text name of the procedure
7 | RESULT_PROC_ID_PROC_NAME | VARCHAR | No |
The name of each procedure.
8 | PROC_LOINC | VARCHAR | No |
The LOINC code associated with this procedure.
9 | RESULT_ENC_IDENT | VARCHAR | No |
Link to the ordering encounter
10 | RESULT_KEY | VARCHAR | No |
Key to link the other result information to this order
11 | RESULT_STATUS_C_NAME | VARCHAR | No |
Status for this result
May contain organization-specific values: No
Category Entries:
Aborted
Active
Cancelled
Completed
Held
New
Suspended
Nullified
Obsolete
12 | RESULT_ABNORMAL_C | VARCHAR | No |
Indicates whether this result was flagged as abnormal
13 | SPECIMEN_DISP | VARCHAR | No |
The displayable specimen name(s) for this result.
14 | RESULT_SOURCE_CSN | NUMERIC | No |
The unique ID of the Document Received record contact originally storing this result.
15 | RSLT_LST_UPD_INST_DTTM | DATETIME (UTC) | No |
Stores the last update instant of the result in UTC.
16 | RESULT_RESULTING_STATUS_C_NAME | VARCHAR | No |
This items stores the resulting status of the result.
May contain organization-specific values: No
Category Entries:
In process
Preliminary result
Final result
Edited
Edited Result - FINAL
17 | RSLT_ABNORMAL_ID_C_NAME | VARCHAR | No |
This item stores the mapped result abnormality.
May contain organization-specific values: No
Category Entries:
Abnormal
Normal
18 | RESULT_LOINC_ID_LNC_LONG_NAME | VARCHAR | No |
The more readable format than the fully specified name in Logical Observation Identifiers Names and Codes (LOINC®) code.
19 | EXTERNAL_RESULT_TYPE_C_NAME | VARCHAR | No |
This item stores the type of the result.
May contain organization-specific values: No
Category Entries:
Unknown
Medication
Code Status
Consult
Culture
Diet
ECG
Image
Immunization
Isolation
Microbiology
Nursing
Procedure
Radiology
Referral
E-Consult
Lab
Genomic Result
Microbiology - Non culture based
20 | RESULT_INVALID_YN | VARCHAR | No |
This item indicates whether or not this line of result data is invalid.
May contain organization-specific values: No
Category Entries:
No
Yes
21 | RESULT_UTC_DTTM | DATETIME (UTC) | No |
Stores the UTC instant of the moment this order was resulted.
22 | SPECIMEN_COLLECTION_UTC_DTTM | DATETIME (UTC) | No |
UTC Instant of collection for this order's specimen(s)
23 | RSLT_UNSUCCESSFUL_FLG_C_NAME | VARCHAR | No |
Indicates whether a result was an unsuccessful attempt
May contain organization-specific values: No
Category Entries:
Unsuccessful Attempt
Documented on Wrong Patient
24 | RSLT_UNSUCCESS_INST_UTC_DTTM | DATETIME (UTC) | No |
Instant the result unsuccessful flag was set
25 | RSLT_PT_SRC_APP_C_NAME | VARCHAR | No |
If this result is a patient-entered result, this item stores the application which was used to submit it for the contact (e.g. MyChart).
May contain organization-specific values: Yes
Category Entries:
MyChart
Welcome
26 | RSLT_SRC_WPR_ID | VARCHAR | No |
Stores the ID of the MyChart user who edited the result for the contact.
27 | RSLT_SRC_ORG_ID | NUMERIC | No |
Stores the Data Exchange Organization record ID of the source organization for this order.
28 | RSLT_SRC_ORG_ID_EXTERNAL_NAME | VARCHAR | No |
Organization's external name used as the display name on forms and user interfaces.
29 | RSLT_AUTH_PROV_NAME | VARCHAR | No |
The full name of the provider responsible for authorizing this result.
30 | RESULT_CONTACT_SRC_C_NAME | VARCHAR | No |
Stores the source of the result from the sending system.
May contain organization-specific values: No
Category Entries:
Unknown
Enter/Edit Results
Result Orders Visit Navigator
Results Console Visit Navigator
Anticoag Tracker Visit Navigator
Lab Auto Verification
Lab Manual Verification
Study Review
Procedure Notes
Begin/End Exam
Media Manager
Prior Status
Update Assessment and Recommendation
Validation Queue
Change Procedure
Change Imaging Study Status
Track Result
In Basket
ED Narrator
Wet Read
External Results Entry
HH Remote Client Lab Result
Donor Organ Editor
UNOS Import
Historical Cervical Cytology
Automatically Reconciled Lab Result
Link Health Maintenance
Dermatology Exam
Automatically Reconciled Image Result
Mobile POCT Results Entry
Document Batch Editor
Imaging and Procedures
Imaging and Procedures Mobile
Stability
Interfaces
Transcription Utility
3rd Party Result Entry
Bulk Ordering Utility
Utilities
31 | RSLT_IMAGE_TYPE_C_NAME | VARCHAR | No |
This item stores the type of the imaging result.
May contain organization-specific values: No
Category Entries:
Cupid
Lumens
Stork
Radiant
32 | RSLT_EXAM_BEGIN_UTC_DTTM | DATETIME (UTC) | No |
This item stores the exam begin instant of the result.
33 | RSLT_EXAM_END_UTC_DTTM | DATETIME (UTC) | No |
This item stores the exam end instant of the result.
34 | RSLT_RPT_TYPE_C_NAME | VARCHAR | No |
This item stores the report type for the result.
May contain organization-specific values: No
Category Entries:
Trendable Exception
Culture
Blood Bank Unit
Non-Trendable
Colonoscopy
EGD
EUS (Upper)
ERCP
Antegrade Enteroscopy
Sigmoidoscopy
Lower EUS
Retrograde Enteroscopy
Pouchoscopy
Ileoscopy
Bronchoscopy
Generic Lumens Procedure
Molecular
Generic Radiology Procedure
Generic Interventional Radiology Procedure
Point of Care Ultrasound
Cardiac Catheterization
Cardiac Ventriculography
Aortography Catheterization
Coronary Angiography
Coronary Catheterization
Left Heart Catheterization
Right Heart Catheterization
Transcatheter Mitral Valve Repair
Transcatheter Aortic Valve Replacement
Percutaneous Coronary Intervention
Pericardiocentesis
Cardiac Catheterization Intervention
Cardiac Catheterization Intervention with Implant
Structural Heart Procedure
Pediatric Cardiology Conference
Congenital Catheterization
Invasive Vascular
Invasive Vascular - Lower Extremity Arteries
Computed Tomography Angiography - Lower Extremity Arteries
Invasive Vascular - Abdominal Arteries
Computed Tomography Angiography - Abdominal Arteries
Invasive Vascular - Carotid Arteries
Computed Tomography Angiography - Carotid Arteries
Invasive Vascular - Whole Body Arteries
Computed Tomography Angiography - Whole Body Arteries
Extremity Invasive Vascular Diagnostic
Extremity Invasive Vascular Intervention
Extremity Invasive Vascular Intervention with Implant
Abdominal Invasive Vascular Diagnostic
Abdominal Invasive Vascular Intervention
Abdominal Invasive Vascular Intervention with Implant
Carotid Invasive Vascular Diagnostic
Carotid Invasive Vascular Intervention
Carotid Invasive Vascular Intervention with Implant
Whole Body Invasive Vascular Diagnostic
Whole Body Invasive Vascular Intervention
Whole Body Invasive Vascular Intervention with Implant
Electrophysiology
Electrophysiology Study
Implantable Cardiac Device
Ablation
Implantable Loop Recorder
ICD Implant/Upgrade
ICD Generator Change/Removal
Lead Implant/Replacement
Lead Revision/Removal
PPM Implant/Upgrade
PPM Generator Change/Removal
Occlusion Device Implant/Upgrade
Other Cardiac Device Implant/Replacement
Other Cardiac Device Revision/Removal
Arm Invasive Vascular Diagnostic
Arm Invasive Vascular Intervention
Arm Invasive Vascular Intervention with Implant
Echocardiography
Stress Echocardiography
Doppler Echocardiography
2D Echocardiography
Transthoracic Echocardiography
Transesophageal Echocardiography
Congenital Echocardiography
Congenital Transthoracic Echocardiography
Congenital Transesophageal Echocardiography
Fetal Echocardiography
Fetal Doppler Echocardiography
Fetal 2D Echocardiography
Vascular Ultrasound
Non-Invasive Peripheral Vascular
Cardiac Nuclear Medicine
Stress Nuclear Medicine
Cardiac Computed Tomography
Computed Tomography Angiography
Cardiac Magnetic Resonance Imaging
Magnetic Resonance Angiography
Multigated Acquisition Scan
Cardiac Positron Emission Tomography
Cardiac Single-Photon Emission Computed Tomography
Electrocardiogram
Cardiac X-Ray
Cardiac Event Monitoring
Holter
Tilt Table
Cardioversion
Cardiac Device Check
Cardiac Stress Test
Phonocardiogram
Generic Cardiovascular Procedure
Genomic
Tumor Profiling with Companion Biomarkers
Cardiology Non-Invasive Grouper
Cardiology Invasive Grouper
Generic Imaging Grouper
35 | RSLT_LATERALITY | VARCHAR | No |
This item stores the laterality for the result.
36 | RSLT_READING_ACTIVITY_ID | NUMERIC | No |
This item stores the reading activity for the result.
37 | RSLT_READING_ACTIVITY_ID_ADV_ACTIVITY_NAME | VARCHAR | No |
Internal name of the Advantage Activity record
38 | LAB_RSLT_TYPE_C_NAME | VARCHAR | No |
This item stores the type of lab result
May contain organization-specific values: No
Category Entries:
Standard
Component
Free Text
Hematology - CBC
Hematology - Diff
Microbiology - Identification
Microbiology - General Workcard
Microbiology - Susceptibility
Microbiology - Stain
Microbiology - Organism Workcard
Hematology Differential
Hematology Auto
Microbiology - Culture and Workup
Anatomic Pathology - General
Anatomic Pathology - Cytology
External Blood Bank
Molecular Diagnostics
Embryology
Donor-Recipient Compatibility - Blood
Antigen / Antibody ID
39 | RSLT_HAS_VAR_YN | VARCHAR | No |
This item is set to Yes if the result has any associated Genomic Variants
The category values for this column were already listed for column: RESULT_INVALID_YN
40 | RSLT_STUDY_UID | VARCHAR | No |
The DICOM Study Instance Unique Identifier (UID) as recorded by the image archive.
41 | RSLT_LAB_REF_IDENT | VARCHAR | No |
This item stores the lab reference ID for the result.
42 | RSLT_SRC_ORG_HSI | VARCHAR | No |
Stores the HSI of the source organization for this order
43 | SPECIMEN_COLLECTION_INST_DTTM | DATETIME (Local) | No |
Local Instant of collection for this order's specimen(s).
44 | SPECIMEN_COLLECTION_DATE | DATETIME | No |
Date of collection for this order's specimen(s)
45 | RESULT_BULK_STAT_C_NAME | VARCHAR | No |
The status of this data element within DINE.
May contain organization-specific values: No
Category Entries:
Invalid
Valid
Inactive
46 | RSLT_HAS_SEQDATA_YN | VARCHAR | No |
This item is set to Yes if the result has any associated sequencing data
The category values for this column were already listed for column: RESULT_INVALID_YN
47 | RSLT_BULK_INCL_DATE | DATETIME | No |
The date to compare to the change tracking window when loading flat files in bulk via DINE. If the date is within the window, but the data element is missing from the load, then the data element is invalidated.