The note type concept ID is not very useful and should be replaced with a more standardized terminology such as LOINC ontology
Replace the current single element with 5 elements (pls see presentation for details)
Extend the note source value field to 255 varchar
In terms of the type of service, LOINC ontology is very complicated, A flat architecture would be better for the current purpose. Comparison with another institution should be carried out.
The note table in the OMOP CDM has a note type field with about 10 or so note types
Next steps:
Comparison of what aspects of LOINC is being used across different institutions.
One of the deliverable is to build a system that can map the institutional note type to the LOINC note types.
Update the note type field of the note table in OMOP CDM. Should a subset of LOINC document types be used for this purpose? this would depend on the real-world data from various institutions.
Ontologies such as CP, ICD-9 etc. that include more clinical terminologies should also be explored.