Wednesday, November 1, 2017

V35 Test Data Set

We have put up the V35 test data on our etail site: http://www.drggroupers.net/about/ as a free download in case you need the data to debug any of our products.

Specifically, we offer testdbv35.zip which contains our catalog, the CMS data set in the original fixed-width format (testdbv35.txt) and also in comma-separated value (CSV) format.

Archive:  testdbv35.zip
  Length     Date   Time    Name
 --------    ----   ----    ----
   169339  10-30-17 12:52   drgmanv35.pdf
 13407058  10-30-17 12:52   testdbv35.txt
  1055839  10-30-17 12:52   testdbv35.csv
 --------                   -------
 14632236                   3 files

The DRGFilt .INI file groups which correspond to these files are these:

[fixed]
format = fixed          ; input file format
verbose = 0             ; 0 = no debugging information, 1 = debugging information
blip = 1000             ; give progress report every 1,000 records
blipeol = 0             ; 1=newline for progress report, 0=carriage return
batchver = 35           ; assign version 35 DRGs to this batch
maskdir = .             ; directory in which to find drgmasks.v35

; fixed-width input variables: name = length@offset
age =   3@0
sex = 1@3
ds =  2@4
dxl=8           ; dx length does not require an offset
poa= 7
dx = 200@23
mnh@jackal-n2:/drbd/mnh/src/drgs/v35/src$ cat v35.ini
; new format DRGFilt control file, with different groups for different purposes
; Tue Oct 11 09:52:42 EDT 2016 BFH change path in [cgi] to match new server
; Sun Oct  2 10:19:10 EDT 2016 BFH set to v34
; Thu Oct 12 11:34:36 EDT 2017 BFH set to v35

;---------------
; this group is to process the standard fixed-width input file from CMS
;---------------
[fixed]
format = fixed          ; input file format
verbose = 0             ; 0 = no debugging information, 1 = debugging information
blip = 1000             ; give progress report every 1,000 records
blipeol = 0             ; 1=newline for progress report, 0=carriage return
batchver = 35           ; assign version 35 DRGs to this batch
maskdir = .             ; directory in which to find drgmasks.v35

; fixed-width input variables: name = length@offset
age =   3@0
sex = 1@3
ds =  2@4
dxl=8           ; dx length does not require an offset
poa= 7
dx = 200@23
sgl=7@0         ; pr length, offset is optional & ignored
surg= 175@223
exmp = 1@6
; -----
; these are already present from the CMS grouper:
; you could overwrite the incoming values if you wanted to
; drg = 3@603
; mdc = 2@600
; rc = 2@598
; -----

; these are written out by DRGFilt
rc  = 2@1760
mdc = 2@1762
drg = 3@1764

[csv-validate]
format = csv (,) ; separator character is in parens
base = 0 ; indices are zero-based
;base = 1 ; indices are one-based
inheaders = 1           ; 1=input column headers, 0=no input column headers
outheaders = 0 ; 1=want column headers, 0=no headers
crlf = 0 ; type of end-of-line: either crlf or lf
blip = 1000
blipeol = 0 ; 1=newline for progress report, 0=carriage return
maskdir = .
batchver = 35
infile = testdbv35.csv
outfile = testdb.validate.csv
verbose = 1

; input variables: name = index
inid = 0
age =  1
sex = 2
exmp = 3
ds =  4
dx = 5-29
poa = 30-54
surg= 55-79

; these are written out by DRGFilt
outid = 0 ; patient ID from input
drg = 1

Tuesday, October 31, 2017

V35 Released!

Our etail site is now live with the v35 versions of all our products.

http://www.drggroupers.net/

Monday, October 30, 2017

Sunday, October 22, 2017

V35 Windows Products Validated

Our Windows-based products passed validation. The only issue was the ever-annoying leading zeroes problem in MS-Excel. We find that importing the test database CSV always raises this issue: if imported as a CSV, leading zeroes are stripped from procedure codes which mangles those procedure codes.

V35 Linux Products Validated

The v35 Linux products, both 32-bit and 64-bit, have passed validation. On to the Windows products.

Wednesday, October 18, 2017

V35 Basic Validation Done

Our DRG Assignment Engine (DAE) has passed validation.

We found our bug: handling a few of the new attributes was buggy. Specifically attributes in byte 27 and above.

So now our basic v35 engine works and we are busy embedding it in all our products.

Thursday, October 12, 2017

V35 Validation Hiccup

We have hit a snag validating our v35 implementation. We have a single case in the test database which does not group correctly. We are doing a deep dive into our implementation.