Related Experiment Video
Updated: May 28, 2026
Comparison of Predictive Performance of Three Lymph Node Staging Systems in Colorectal Signet Ring Cell Carcinoma Based on Machine Learning Model
Published on: April 18, 2025
Use of administrative data to identify colorectal liver metastasis
Daniel A Anaya1, Natasha S Becker, Peter Richardson
1VA HSR & D Houston Center of Excellence, Michael E. DeBakey Veterans Affairs Medical Center, Baylor College of Medicine, Houston, Texas 77030, USA. danaya@bcm.edu
Background:
The ability to identify patients with colorectal cancer (CRC) liver metastasis (LM) using administrative data is unknown. The goals of this study were to evaluate whether administrative data can accurately identify patients with CRCLM and to develop a diagnostic algorithm capable of identifying such patients.
Materials And Methods:
A retrospective cohort study was conducted to validate the diagnostic and procedural codes found in administrative databases of the Veterans Administration (VA) system. CRC patients evaluated at a major VA center were identified (1997-2008, n = 1671) and classified as having liver-specific ICD-9 and/or CPT codes. The presence of CRCLM was verified by primary chart abstraction in the study sample. Contingency tables were created and the positive predictive value (PPV) for CRCLM was calculated for each candidate administrative code. A multivariate logistic-regression model was used to identify independent predictors (codes) of CRCLM, which were used to develop a diagnostic algorithm. Validity of the algorithm was determined by discrimination (c-statistic) of the model and PPV of the algorithm.
Results:
Multivariate logistic regression identified ICD-9 diagnosis codes 155.2 (OR 9.7 [95% CI 2.5-38.4]) and 197.7 (84.6 [52.9-135.3]), and procedure code 50.22 (5.9 [1.3-25.5]) as independent predictors of CRCLM diagnosis. The model's discrimination was 0.89. The diagnostic algorithm, defined as the presence of any of these codes, had a PPV of 87%.
Conclusions:
VA administrative databases reliably identify patients with CRCLM. This diagnostic algorithm is highly predictive of CRCLM diagnosis and can be used for research studies evaluating population-level features of this disease within the VA system.
