Out of State Data Exchange

From time to time we receive data files from other state registries with patient information for residents of Ky that were treated or diagnosed for cancer in the respective state. We have tried to automate the steps for processing these files by creating a batch file that executes a match of the input file against a file from our central database. This batch file is located on the J drive at \osde\match. Marilyn Wooten has written a document for using this batch file in processing the data files which can be read HERE.

There are two programs that were written to help in this processing. One is OSDEFLTR which excludes records from the out of state file if they meet the following criteria:

Exclude if not NAACCR record version 6-9.
Exclude cases prior to 1995.
Exclude non-KY cases.
Exclude skin cases Topo 440 - 449, histo 8000 - 8110.
Exclude cervix cases Topo 539 behavior code 2.
Exclude some brain cases Topo 710-719, behavior code 0.
Exclude duplicates cases.

The second program OSDERPT reads a recNum from a csv file and uses it to look up a record in a naaccr file and prints a report for that record. The first input file is the filtered out of state file, the second input file is the comma separated file that is created by AUTOMAT, and the third parameter is the name of the output report.

The batch file mentioned above has the following steps:

Runs FILESCAN which sets all record sizes of osde file to 5966.
Runs OSDEFLTR program to exclude unwanted and duplicate records.
Runs DCOMP to compile the dictionary file for the data from our central database.
Runs DCOMP to compile the dictionary file for the osde input.
Runs MCOMP to compile the match file.
Runs TREELD to create indexes needed for the match.
Runs FREQLD for each input file to analyze all fields of the input files.
Runs MTCH to match the files.
Runs REPGEN to create report files of matched records and residual(non-matched) records.
Runs EXTRACT to create extract files needed for the OSDERPT program.