Using VistA electronic medical record data extracts to calculate the waiting time for total knee arthroplasty

This is a retrospective database study of veterans who had total knee arthroplasty (TKA) at Veterans Affairs Connecticut Healthcare System. The objective of this study is to determine if VistA medical records data can be used to create a methodology for accurate assessment of waiting times for TKAs performed at Veterans Affairs facilities. The average waiting period from date of "initial consult" to date TKA was performed was greater than two years. The average waiting period from "most recent consult" to TKA was less than a year. This new approach and methodology has great impact as it provides an electronic method for calculating the TKA wait time which is broadly generalizable for similar analysis at the VISN (Veteran Integrated Services Network) or regional level.