ETL for note talbe

[ildonglee]

Dear sir,

we are considering a note data ETL. Even though, I reviewed the discussion ahead here, I couldn’t get sufficient understanding about note table now. Therefore, i’m here for asking your kind help.

Specifically, we are planning to start converting from diabetes note, however, i’m still in vague about the concept of note_id and note_type_concept_id. could you help me to find right use case of those concept?

in addition, the note is mostly written in Korean. is it capable to use Korean for the note_table? or it is just decision up to converting organization?

thank you for your time and help in advance.

[Dymshyts (Dmytry Dymshyts)]

Hi @ildonglee!

note_id

Is just a row number in the table.

note_type_concept_id

A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the type, origin or provenance of the Note.
These belong to the ‘Note Type’ vocabulary

in addition, the note is mostly written in Korean.

There’s no restriction of language:
You can fill it in Korean and set language_concept_id = Korean language.

[ildonglee]

@Dymshyts thank you sir. your reply resolved everything i wondered. I appreciate it
hope you are doing fine!