Pharmacy File Layout

This layout document describes the fields in the pharmacy search data file.

Field Name Description Length Format Note
ID Identifies the 10-digit National Provider Identifier (NPI) 10    
Pharmacy_NPI Identifies the 10-digit NPI 10    
Pharmacy_Vendor_Number Identifies the 6-digit contract number assigned by HHSC 6    
Pharmacy_name Identifies the pharmacy's trade or doing-business-as name 25    
Pharmacy_alternate_Name Identifies the pharmacy's legal name 25    
Pharmacy_State_Lic Identifies the pharmacy's license number 6    
Pharmacy_Address Identifies the pharmacy's physical address (line #1) 25    
Pharmacy_Address2 Identifies the pharmacy's physical address (line #2) 25    
Pharmacy_City Identifies the pharmacy's physical address city 16    
Pharmacy_State Identifies the pharmacy's physical address state 2    
Pharmacy_Zip Identifies the pharmacy's physical address ZIP code 10 XXXXX-XXXX  
Pharmacy_region Identifies the HHSC region code of the pharmacy 2    
Pharmacy_Region_Cat Identifies the HHSC region code description 25   Refer to the valid values for pharmacy region description
Pharmacy_Subregion Identifies the HHSC-defined sub-region code 2   Refer to the valid values for pharmacy region description
Pharmacy_Subregion_Cat Identifies the HHSC-defined sub-region description 25   Refer to the valid values for pharmacy sub-region description
Pharmacy_County Identifies the 3-digit county code plus county name 20   Refer to the valid values for pharmacy sub-region description
Pharmacy_Phone_Number Identifies the pharmacy's physical address phone number 10 XXXXXXXXXX  
Pharmacy_khc Identifies whether the pharmacy is enrolled in the KHC Program 3    
Pharmacy_khc_EffDate Identifies the effective date of the pharmacy's enrollment in the KHC program 10 MM/DD/CCYY  
Pharmacy_khc_EndDate Identifies the termination date of the pharmacy's enrollment in the KHC program 10 MM/DD/CCYY  
Pharmacy_medicaid Identifies whether the pharmacy is enrolled in Medicaid 3    
Pharmacy_medicaid_EffDate Identifies the effective date of the pharmacy's enrollment in Medicaid 10 MM/DD/CCYY  
Pharmacy_medicaid_EndDate Identifies the termination date of the pharmacy's enrollment in Medicaid 10 MM/DD/CCYY  
Pharmacy_chip Identifies whether the pharmacy is enrolled in CHIP 3    
Pharmacy_chip_EffDate Identifies the effective date of the pharmacy's enrollment in CHIP 10 MM/DD/CCYY  
Pharmacy_chip_EndDate Identifies the termination date of the pharmacy's enrollment in CHIP 10 MM/DD/CCYY  
Pharmacy_cshcn Identifies whether the pharmacy is enrolled in the CSHCN Services Program 3    
Pharmacy_cshcn_EffDate Identifies the effective date of the pharmacy's enrollment in the CSHCN Services program 10 MM/DD/CCYY  
Pharmacy_cshcn_EndDate Identifies the termination date of the pharmacy's enrollment in the CSHCN program 10 MM/DD/CCYY  
Pharmacy_Delivers Identifies whether HHSC certified the pharmacy to provide free delivery service to Medicaid clients 3    
Pharmacy_htw Identifies whether the pharmacy is enrolled in the HTW program 3    
Pharmacy_htw_EffDate Identifies the effective date of the pharmacy's enrollment in the HTW program 10 MM/DD/CCYY  
Pharmacy_htw_EndDate Identifies the termination date of the pharmacy's enrollment in the HTW program 10 MM/DD/CCYY  
Pharmacy_Mail_order_identifier Identifies whether the dispenser type of pharmacy is mail order 3    
Pharmacy_Self_Reported_Type Identifies the type of pharmacy, self-reported at the time of its enrollment 20  
  • Retail
  • Long Term Care
  • Specialty
Pharmacy_340b Identifies whether pharmacy self-reported as 340B pharmacy at the time of its enrollment 3    

Pharmacy File Valid Values

Pharmacy Region Description

  • 0 = Out of State
  • 1 = High Plains
  • 2 = North West
  • 3 = Metroplex
  • 4 = Upper East Texas
  • 5 = South East Texas
  • 6 = Gulf Coast
  • 7 = Central Texas
  • 7 = Central Texas
  • 8 = Upper South Texas
  • 9 = West Texas
  • 10 = Upper Rio Grande
  • 11 = Lower South Texas

Pharmacy Sub-region Description

  • 0 = Out of State
  • 1 = Houston
  • 2 = Gilmer
  • 3 = Austin
  • 4 = West San Antonio
  • 5 = Fort Worth
  • 6 = Midland
  • 7 = Dallas
  • 8 = McAllen
  • 9 = Abilene
  • 10 = East San Antonio
  • 11 = Lubbock
  • 12 = South Fort Worth
  • 13 = Beaumont
  • 14 = North Houston