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	NUMERIC	No
	This item stores the mapped procedure in the internal system.
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	NUMERIC	No
	Stores the mapped LOINC ID for a result 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 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 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 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 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 Blood Bank Molecular Diagnostics Embryology
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)