Question about note table

[Vines (Wang Man)]

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.

[Dymshyts (Dmytry Dymshyts)]

@Vines

What is “character encoding type”?And how can I find its Concept ID?

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

@Vines

Another question is about “note_id

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

[Vines (Wang Man)]

Thanks for your help!

@Dymshyts

If you have other than UTF-8, please tell us.

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.

@Dymshyts

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

Got it!

[gil.frenkel]

Hi @Dymshyts!

I’m dealing with clinical documents which are written in Hebrew and English.
So except UTF-8 we also have ISO-8859-8.

Thanks,

Gil.