A database coding system for vascular procedures

A coding system was developed to overcome the difficulties encountered in data registry and retrieval from a national audit. In vascular surgery operations are frequently combined, and neither the OHIP fee schedule of codes (Ontario, Canada) nor the ICD-9 system provides sufficient detail for most vascular surgeons to retrieve information for long-term follow-up. However, some wish to record minimal data on their operative procedures. A numeric classification system was developed. A five-digit number is used, the first two digits classifying the operative procedure and anatomic details. Two decimal digits code the classification of operation (e.g., aortic aneurysm, tube graft, aortoiliac, or aortobifemoral) and the final digit may be used as a modifier. "Holes" in the numeric system allow for new operations to be added as they develop. Codes are stored in a database with the following fields: 1) codes; 2) description of operation; 3) translation. The translation field may be modified to permit translation of any existing databases into the system. This database has been distributed with a data registry program free of charge to vascular surgeons in Canada to allow nationwide registry of vascular surgery patients. A numeric code eliminates spelling and abbreviation errors, and can be sufficiently broad-based to allow all surgeons to participate in a nationwide audit.