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 |
|
|
| 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