W-5. Data Files

HHSC provides data files for use by the public. Each data file has an associated layout document, which identifies the fields and formatting within each file. Refer to the VDP website Downloads page (txvendordrug.com/resources/downloads) for the list of delimited files.

HHSC presents many of the files in a delimited format. Users must parse, or translate, the file to make the contents readable. The first line of each file contains headers, and each subsequent line is a row of data. Each data file has the following specifications:

  • Separates the data in each row by a vertical bar (|)
  • Encloses values between double quotes if present, but double quotes are not applied to fields when no character value exists
  • Does not populate null values with spaces

You must download and save the file to your computer before opening it.