Clarity Tables
Below the list of the EPIC Clarity tables needed to assemble the CAP forms and the pathology reports. The table name contains the link for the full public description of the table including the columns of each one and the description of the columns.
| Table Name | Table Description | URL |
|---|---|---|
| clarity_component | The CLARITY_COMPONENT table contains basic information about the standard result components that can constitute your procedures. For example, the components of a lab panel are usually the tests performed on a single specimen. | https://open.epic.com/EHITables/GetTable/CLARITY_COMPONENT.htm |
| clarity_concept | The CLARITY_CONCEPT table contains information pertaining to SmartData elements and concepts. SmartData elements are discrete data elements that can have data stored against them. Concepts are used as reference terminology, but should not be used for data storage. Each concept and element has a unique identifier (CUI), which is used as the primary key for the table. | https://open.epic.com/EHITables/GetTable/CLARITY_CONCEPT.htm |
| clarity_eap | The CLARITY_EAP table contains basic information about the procedure records in your system. This does include both A/R and clinical procedures. | https://open.epic.com/EHITables/GetTable/CLARITY_EAP.htm |
| concept_comment | The CONCEPT_COMMENT table records the comments entered via SmartForms. | https://open.epic.com/EHITables/GetTable/CONCEPT_COMMENT.htm |
| order_proc | The ORDER_PROC table enables you to report on the procedures ordered in the clinical system. We have also included patient and contact identification information for each record. | https://open.epic.com/EHITables/GetTable/ORDER_PROC.htm |
| order_proc_2 | The ORDER_PROC_2 table enables you to report on the procedures ordered in the clinical system. This procedure table has the same basic structure as ORDER_PROC, but was created as a second table to prevent ORDER_PROC from getting any larger. | https://open.epic.com/EHITables/GetTable/ORDER_PROC_2.htm |
| order_proc_3 | The ORDER_PROC_3 table enables you to report on the procedures ordered in the clinical system. This procedure table has the same basic structure as ORDER_PROC, but was created as a third table to prevent ORDER_PROC_2 from getting any larger. | https://open.epic.com/EHITables/GetTable/ORDER_PROC_3.htm |
| order_rad_acc_num | This stores the accession numbers associated with the order. | https://open.epic.com/EHITables/GetTable/ORDER_RAD_ACC_NUM.htm |
| order_res_comp_cmt | This table contains result component value comments for orders that are populated by the Incoming Results Interface. These result component value comments are not populated through Enter/Edit Results. The data in this table is only populated if the result component value normally stored in the Value_Internal (I ORD 2010) item (ORDER_RESULTS.ORD_VALUE or ORDER_RESULTS.ORD_NUM_VALUE) is too long to be stored in that item. | https://open.epic.com/EHITables/GetTable/ORDER_RES_COMP_CMT.htm |
| order_results | This table contains information on results from clinical system orders. This table extracts only the last Orders (ORD) contact for each ORD record. | https://open.epic.com/EHITables/GetTable/ORDER_RESULTS.htm |
| patient | The PATIENT table contains one record for each patient in your system. The data contained in each record consists of demographics, PCP and primary location information, registration information, and other information. | https://open.epic.com/EHITables/GetTable/PATIENT.htm |
| res_db_main | The RES_DB_MAIN is the primary table for storing results data. | https://open.epic.com/EHITables/GetTable/RES_DB_MAIN.htm |
| result_synoptic | Synoptic result record table. | https://open.epic.com/EHITables/GetTable/RESULT_SYNOPTIC.htm |
| smrtdta_elem_data | The SMRTDTA_ELEM_DATA table stores metadata (context, linked records, time of entry, etc.) concerning SmartData element values entered by users through SmartForms, SmartTools or other documentation tools that file discrete data to SmartData elements. The actual element values entered by end users are stored in the SMRTDTA_ELEM_VALUE table. | https://open.epic.com/EHITables/GetTable/SMRTDTA_ELEM_DATA.htm |
| smrtdta_elem_value | Description not available in public EPIC documentation | https://open.epic.com/EHITables/GetTable/SMRTDTA_ELEM_VALUE.htm |
| spec_containers | The specimen container ID for specimens with multiple containers. | https://open.epic.com/EHITables/GetTable/SPEC_CONTAINERS.htm |
| spec_db_main | The SPEC_DB_MAIN table contains basic information about your specimen records. These include clinical pathology, anatomic pathology, and quality control specimens. One row in this table represents one specimen. | https://open.epic.com/EHITables/GetTable/SPEC_DB_MAIN.htm |
| spec_test_rel | The SPEC_TEST_REL table contains information stored on each specimen record that relates to the tests performed on the specimen. Each test appears as a distinct row in this table. | https://open.epic.com/EHITables/GetTable/SPEC_TEST_REL.htm |
| synoptic_result_main | This table contains synoptic information for a patient or a requisition grouper. | https://open.epic.com/EHITables/GetTable/SYNOPTIC_RESULT_MAIN.htm |
| zc_lab_data_type | Description not available in public EPIC documentation | https://open.epic.com/EHITables/GetTable/ZC_LAB_DATA_TYPE.htm |
| zc_lab_status | Description not available in public EPIC documentation | https://open.epic.com/EHITables/GetTable/ZC_LAB_STATUS.htm |
| zc_order_status | Description not available in public EPIC documentation | https://open.epic.com/EHITables/GetTable/ZC_ORDER_STATUS.htm |
| zc_order_type | Description not available in public EPIC documentation | https://open.epic.com/EHITables/GetTable/ZC_ORDER_TYPE.htm |
| zc_ordering_mode | Description not available in public EPIC documentation | https://open.epic.com/EHITables/GetTable/ZC_ORDERING_MODE.htm |
| zc_result_flag | Description not available in public EPIC documentation | https://open.epic.com/EHITables/GetTable/ZC_RESULT_FLAG.htm |
| zc_result_status | Description not available in public EPIC documentation | https://open.epic.com/EHITables/GetTable/ZC_RESULT_STATUS.htm |
| zc_specimen_source | Description not available in public EPIC documentation | https://open.epic.com/EHITables/GetTable/ZC_SPECIMEN_SOURCE.htm |
| zc_specimen_type | Description not available in public EPIC documentation | https://open.epic.com/EHITables/GetTable/ZC_SPECIMEN_TYPE.htm |