|
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 |
| 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) |
|
|
| 45 |
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 |
|
|
