we try to convert our German billing data to OMOP v3.5.1. In doing so, we identified two problems:
First, we have special DRG codes in Germany which are not equal to DRG US codes. For this reason, we want to create a new vocabulary for German DRG. Until this is achieved, it would be sufficient for us to write the DRG source code to OMOP. Unfortunately the German DRG codes have a length of six. In OMOP only strings of length three are possible in the cost table for drg_source_value. Is a manual adjustment of the length of the data type possible to solve the problem?
The second problem focuses on a special coding in Germany, which is used for billing services (diagnoses, procedures) - the uniform assessment standard (german: Einheitlicher Bewertungsmaßstab (EBM)). Again, we would like to create a new vocabulary for this. However, the OMOP specification for v3.5.1 does not provide a suitable place in the cost table for such information. For US data there are the fields revenue_code_concept_id and revenue_code_source_value. How can we convert our German data into the cost table?