CCDA Export Error


(Amir Eltaweel) #1

Hi there,

I’m using openemr 5. i registered the carecoordination module no problem. but when trying view or download the CCDA , i get this error

ERROR :
Exception: Statement could not be executed (42S02 - 1146 - Table ‘openemr.sct_descriptions’ doesn’t exist)
Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘openemr.sct_descriptions’ doesn’t exist

please help


(Sherwin Gaddis) #2

When enabling a form, it is a three-step process.

Go back to the forms in administration forms. Look in the fifth column from the left. It should say DB installed. If it does not say DB installed but rather install DB. Click on the words install DB.


(Jerry P) #3

CCM requires the snomed codes to be present. Many aspects of ccda require snomed. Import codes if you have them and give it another shot.


(Anusha Madugula) #4

how to import snomed codes?


(Stephen Waite) #5

Hi @anusha_madugula try administration - other - external dataload


(Anusha Madugula) #6

Please can you provide link for downloading this snomed codes.


(Stephen Waite) #7

hi @anusha_madugula, please see this https://ihtsdo.freshdesk.com/support/solutions/articles/4000039015-how-do-i-obtain-a-snomed-ct-affiliate-license-


(Jerry P) #8

Before going through all the hassle, try just creating an empty table for the sct_descriptions. Get the structure from database.sql in openemr/sql. You’ll also need ccdaservice installed to generate ccda’s.


How To Add New Code SNOMED
(Anusha Madugula) #9

Ya Thankyou friends.


(Amir Eltaweel) #10

Thanks Guys, Sorry for the late thank you, i was travelling


(Aaron M) #11

Thanks Jerry! This worked for me. I found the table structure in openemr\library\standard_tables_capture.inc for the 3 tables: sct_concepts, sct_descriptions, and sct_relationships


How To Add New Code SNOMED