Data Sets

Named data sets contain stored encounter information and DRG grouping results.

Maximum number of rows per data set is one million. Maximum total number of rows for all data sets is set by organization according to SaaS agreement.

All data sets have owner and visibility. Owner is the original creator or importer of the data. Visibility can be:

  • Private: Usable (RW) only to the owner
  • Own organization: Usable as RW for all users in the same organization as the owner.
  • Public: RW only to the owner and visible (R) to all other users. Typically demo and training data sets are public.

Each data set also includes information about primary grouping version which is used for grouping in DRG 1 (MDC1, RTC1) fields and secondary grouping that indidates which version is in DRG2, MDC2 and RTC2 fields.

On this page you see listing of all data sets you have access to:

  • Name
  • Owner
  • Visibility
  • Row count
  • Import or created date and time
  • Primary DRG version
  • Secondary DRG (2) version

At the top right you have functions to Add an empty dataset (plus sign) and Import a data set from a file (arrow and a box).

When adding an empty data set you must just give a name for the data set. It will be Your Private empty data set by default. When importing from a file, you must also set:

  • Owner (You by default)
  • Visibility
  • Primary and secondary grouping
  • Data set import file (drag-and-drop or select using File Explorer from your PC)

File format must be a tab separated text file, as described below.

The functions for each data set can be executed by selecting the data set (row) and then using buttongs on the row:

  • "..." opens menu with
    • Edit settings: you can change name, owner, visibility and re-group the data set with different primary and/or secondary DRG version
    • Download file: you can download the data set either as a text file in VisualDRG import format (tab separated) or as an Excel file
    • Trashcan: Delete data set (if you have RW access to the data set)
  • (i) Info: opens a window with data set attributes
  • ==> arrow: opens the data set in Data Set Browsing page.

File format (tab separated text) for DRG encounter case data

A encounter case file is a text file (.txt) that contains 70 or 67 tab-separated fields, depending on whether it contains grouping results. Independently how number of diagnosis and procedures are set in settings the number of diagnosis and procedures must always be 20 in the files.

DRG case data files are TAB separated text files containing the following fields.

Encounter ID is the unique case identifier in this file. Updates are performed by this key only and uniqueness violation results in erroneous updates. The length of this field must be at most 20 characters. You can use both numbers and text. The fields are:

  • Case ID, text string
  • 20 x 2 diagnoses fields (DG1A, DG1D, DG2A,...): use diagnosis codes excluding any punctuation (+,*,.,&,#). So called diagnosis pairs are stored as asterisk-dagger pairs where the first code is the asterisk code and the second is the dagger code. If you have only one diagnosis code, you can save it in VisualDRG either in A or D field.
  • 20 procedures codes: use procedures codes excluding any punctuation.
  • Sex of the patient: 1=male, 2=female, 3=unknown.
  • Age of the patient in days: integer value.
  • Discharge type of the patient: This depends on the country version of DRG. Please see the codes from Grouping page drop-down (the 1st character)
  • Length of stay, integer value, in “gross days”, for example 1.1.2006-1.1.2006 = 1 day, 1.1.2006-2.1.2006 = 2 days, etc.
  • Free text comments, at most 200 characters, reserved for own use, can be viewed and edited in VisualDRG but doesn’t affect DRG. You can store for example real encounter number, ward unit’s organization code and/or doctor’s id or name here.

  • Actual patient case cost, integer value. Use 0, if this in unknown. The following fields must be included in input data file only if you use option “Upload file” in VisualDRG. If you use option “Upload and group file” then these fields must not exist in the file and thus the number of fields is thus less.

  • DRG (DRG code)

  • MDC (MDC code)
  • RTC (grouping error return code)

Sample DRG case data file including fields DRG, MDC and RTC with just two sample lines from the beginning of the file. Lines might be wrapped in this sample but in actual file each record must be in one line. Tab characters are presented as > characters in this example.

304>K572>>C1879>>>>C1871>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>1>12243>1>2>Free text comment>189>6>0 305>N40>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>XKD00>XKW99>>>>>>>>>>>>>>>>>>>1>27324>1>4>Free text comment >49>12>0

You can also ask LOGEX DRG support to send an example of an import file for your reference.

results matching ""

    No results matching ""