Last Updated
Field Name Description Length Format Note
ID 10-digit National Provider Identifier (NPI) 10    
Pharmacy_NPI 10-digit National Provider Identifier (NPI) 10    
Pharmacy_Vendor_Number 6-digit contract number assigned by HHSC 6    
Pharmacy_name Trade or DBA Name of the pharmacy 25    
Pharmacy_alternate_Name Legal name of the pharmacy 25    
Pharmacy_State_Lic State pharmacy license number 6    
Pharmacy_Address Physical address of the pharmacy (line #1) 25    
Pharmacy_Address2 Physical address of the pharmacy (line #2) 25    
Pharmacy_City Physical address city 16    
Pharmacy_State Physical address state 2    
Pharmacy_Zip Physical address ZIP code 10 XXXXX-XXXX  
Pharmacy_region HHSC region code 2    
Pharmacy_Region_Cat HHSC region code description 25   Refer to the valid values for pharmacy region description
Pharmacy_Subregion HHSC-defined sub-region code 2   Refer to the valid values for pharmacy region description
Pharmacy_Subregion_Cat HHSC-defined sub-region description 25   Refer to the valid values for pharmacy sub-region description
Pharmacy_County 3-digit county code plus county name 20   Refer to the valid values for pharmacy sub-region description
Pharmacy_Phone_Number Physical address phone number 10 XXXXXXXXXX  
Pharmacy_khc Identifies whether the pharmacy is enrolled in the KHC Program 3    
Pharmacy_khc_EffDate The effective date of the pharmacy's enrollment in the KHC program 10 MM/DD/CCYY  
Pharmacy_khc_EndDate 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 The effective date of the pharmacy's enrollment in Medicaid 10 MM/DD/CCYY  
Pharmacy_medicaid_EndDate 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 The effective date of the pharmacy's enrollment in CHIP 10 MM/DD/CCYY  
Pharmacy_chip_EndDate 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 The effective date of the pharmacy's enrollment in the CSHCN Services program 10 MM/DD/CCYY  
Pharmacy_cshcn_EndDate 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 The effective date of the pharmacy's enrollment in the HTW program 10 MM/DD/CCYY  
Pharmacy_htw_EndDate 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