Development initiative #547

NordDRG logic versions combined to one table.

Added by Martti Virtanen over 3 years ago. Updated over 3 years ago.

Status:ActiveStart date:2017-03-08
Priority:MajorDue date:
Assignee:-% Done:


Spent time:-
Initiator:Nordic Casemix Centre Target year:
MDC: Owner / responsible:
Target Grouper: Old forum status:


As a preparation to the new NDMS developing process we have now changed the technical arrangement of NordDRG logic definition table. Instead of having a logic table for each national version the versions are in one combined table where a separate variable indicates which versions use the rule at issue. This variable has the structure Com/Den/Est/Fin/Ice/Lat/Nor/Swe. If the value is Swe only Swedish version uses the rule whereas Com/Den/Est/Fin/Ice/Lat/Nor means that all but Swedish version uses that rule.

To make the combination possible the 'ord' variable length has been extended with one character to 11 characters. The values of the 10 first characters have been change only on a few rows where there was a discrepance (error) between the versions. In all other cases the added character separates the rules of different versions.
In addition a variable 'id' has been added to each rule. It shall not be changed if the order of the rules is changed without changing the content of the rule. Minor corrections in the content (deletion, addition or correction of errorneous value of one or two variables) does neither demand a change of the 'id'. This is intended to help following the changes in the system.

The structure of the NordDRG_file_base, NDRG_technical_changes_base and NDRGchanges_repor_base have been changed accordingly to allow this information to be transferred.
In addition the 'dg' and 'proc' tables will now include the ICD+ and NCSP+ codes in addition to the national codes. This makes it possible to see which national codes are linked together on 'plus' level and affect each other and makes easier to check from ICD+ and NCSP+ tables what chagnes a national change might have on other versions.

With exception of the added columns (that do not affect grouping) the national version defintion tables have not been changed.

The Com version of the tables is now actually a combined version including the content of all national versions (on ICD+ and NCSP+ code level). It also includes all properties that are currently in use.
The _base files are on the 'Files' sheet of this forum. A model for the common NordDRG defintion table set is attached to this item.

NordDRG 2017 COM - model.xltx (5.12 MB) Martti Virtanen, 2017-03-08 11:14


#1 Updated by Martti Virtanen over 3 years ago

  • Description updated (diff)

#2 Updated by Martti Virtanen over 3 years ago

  • Description updated (diff)

#3 Updated by Ralph Dahlgren over 3 years ago

This developement of common is very good. It simplify when when creating technical Changes for cases and also makes it possible to see other countries sulotions to specific problems in the NordDRG system.
I do have a suggestion. That is for the DRGlogic table, column "ord". I Think it would be better and easier to see where to make a change/new ord if all "ord" has 11 positions. This means that the ord with ten positions will get a "0" in the end. That decrease the possibilities for mistakes. So if there are no objections from other countries I suggest that this change can be done without futher discussions and for the next produced tables.

#4 Updated by Kristiina Kahur over 3 years ago

Finnish National DRG-center 2017-4-4

The combination of all national versions in one table is very good and useful, especially when it comes to grouper development work (on national or Nordic level).
Ralph's suggestion makes sense and is supported. Hopefully the execution of it is easily doable.

#5 Updated by Ralph Dahlgren over 3 years ago

2017-04-27. This concerns the very much appreciated NordDRG 2017 COM – model2.xlsx”.
When doing the technical changes the common makes life much easier, also when going through the cases.
There are a detail that Sweden would like to be changed. That is the new order of columns in the table DRGlogic in common.
The way it is when looking at the first columns as follow:
Id ord nat_ver drg English

In the Excell-file “NDRG_technical_changes_file_base 20170308.xltx” the columns are like this:
IN/OUT Id ord nat_ver drg English

Sweden suggest the following look:
IN/OUT nat_ver Id ord drg English

Naturally the order of the columns must change in "Common" as well.
This due to the fact that the tables since long time have had the order of the column concerning “ord, drg, English” in that order and when making new rules it will make it a little less work with copy-paste. Particularly if it is a lot of rows to be done in the DRGlogic tabl and also when looking at the rows and compare between different tables.

Also available in: Atom PDF