DRG Weight Tables

A DRG weight table contains for each DRG group a relative weight that can be used as a productivity indicator or as a basis for pricing. In addition, the weight tables include the following supplementary information:

  • outlier cost limits, where cases with lower or higher PLICS costs are typically invoiced based on intermediate‑service costs; outlier limits may also be defined only as an upper limit, in which case no lower limit is applied
  • alternatively outlier length‑of‑stay limits, which in some cases are applied to distinguish outlier cases
  • in some weight tables there may also be partial weights by type of intermediate service: what share of the total weight consists of vos/pkl care, surgeries, laboratory tests, imaging examinations, overhead costs, and other costs (this information is rare in weight tables)

On this page you can see the DRG weight tables loaded into VD and you can manage them.

In the table you see the following information:

  • Name: the name of the weight table as shown in menus
  • Description: a longer description, e.g., describing the source of the weight table
  • DRG version: the DRG version to which the weight table is linked. On the grouping page, you can select only a weight table that is linked to the chosen DRG version.
  • Visibility: Public = visible to all users, or a specific organisation, e.g., a hospital that sees it, and it is usually that organisation’s “own” weight table.
  • Row count: the number of weights, i.e., how many different DRG groups have an assigned weight

In the Actions column you can use the following functions:

  • The “...” menu functions are:

    • Edit settings: allows you to modify the name, description, DRG version, and visibility.
    • Base rates: allows you to define the base price for the weight table, i.e., the price for a weight factor of 1.000, e.g., 800 eur/point. This is used in the pricing function. You can also define multiple different base rates using “+ Add base rate”. Each rate is given a name, and a rate for the weight point and for an additional care day (if an outlier LOS upper limit is used). For example, you may set a different point price for other public hospitals than insurance companies. If you have defined multiple base rates, you can choose in the pricing function which rate to use.
    • Download file: allows you to download the weight table into a file, either as a text file in the same format used when importing into VisualDRG, or as an Excel file, which cannot be imported back into VD.
    • Delete: deletes the weight table and all of its weights and prices.

  • With the “->” option you can open the weight table for browsing.

Weight tables browsing

In this page you can browse the selected weight table. You can see the columns (outlier limits) that exists as non-zero values in the table, the other columns are hidden. The functions are:

  • You can sort the table by clicking header or via "..." menu (-> Sort ascsending, Descending). Also you can pin columns, if needed.
  • You can filter the table. Open filters top right.
    • Use text entry fields to filter by part of DRG code or name.
    • Use sliders to set filtering criteria for the numeric fields.
    • Use eraser to reset all filters. You can view filters by category, alphabetical order or the recently used ones. Also Fiters can be pinned (pin symbol)
  • You can select visible columns using Coloumns selection

Weight Table Import File Format

You can import your own weight tables into VD by using VD’s import format.

The file is a text file where the columns are TAB‑separated. You can easily save such a file e.g. from Excel. Make sure that there are no extra spaces at the beginning or end of the codes.

If the weight table is expressed directly in absolute euros, set the DRG point price to 1.0.

Missing data is marked as zero (0).

The file columns are:

  • DRG, full code with leading zeros
  • weight factor, decimal number with a dot as the separator, 1–7 decimals
  • lower LOS limit (not used in the Finnish pricing model no. 1, mark as 0)
  • lower cost limit (if used), EUR
  • upper LOS limit (not used in the Finnish pricing model no. 1, mark as 0)
  • upper cost limit, EUR
  • average length of stay, days
  • percentage share of inpatient care costs
  • percentage share of outpatient care costs
  • percentage share of procedure costs
  • percentage share of imaging costs
  • percentage share of laboratory costs
  • percentage share of pathology costs
  • percentage share of other costs

Costs must be marked in euros. Thousand separators are not allowed, and the decimal separator must always be a dot, regardless of locale settings.

VisualDRG formats the UI and printed outputs according to locale settings.

------ Example file (a few first rows, empty spaces represent one TAB) ------------------------- 

001A    26.121    0    6163.76    0    21456.97    0    0    0    0    0    0    0    0  
001B    41.003    0    0.00    0    67071.96    0    0    0    0    0    0    0    0  
001C    37.953    0    3124.38    0    37638.82    0    0    0    0    0    0    0    0  
001D    19.672    0    0.00    0    36291.66    0    0    0    0    0    0    0    0

results matching ""

    No results matching ""