CCDA Export Error

OpenEMR Development
#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

#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.

#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.

1 Like
#4

how to import snomed codes?

#5

Hi @anusha_madugula try administration - other - external dataload

#6

Please can you provide link for downloading this snomed codes.

#7

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

1 Like
#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
#9

Ya Thankyou friends.

#10

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

#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