OHDSI Home | Forums | Wiki | Github

Question about note table


(Wang Man) #1

Hi,guys!Sorry to bother you again,but I am a little confused about the field “encoding_concept_id” in the note table.It means “A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the note character encoding type”.What is “character encoding type”?And how can I find its Concept ID?
Another question is about “note_id”.It’s “A unique identifier for each note”.But where might I find its Concept ID?Or how to generate the “note_id”?
Thank you guys in advance.


(Dmytry Dymshyts) #2

http://athena.ohdsi.org/search-terms/terms/32678
If you have other than UTF-8, please tell us.

it is not a concept. it is A unique identifier for each note. in other words - row id.


(Wang Man) #3

Thanks for your help!

I’ve asked our computer engineer.We also use UTF-8,and most system in Chian are using UTF-8.So I think “32678” is good.

Got it!


t