SPAP/ADAP Quarterly Ad-Hoc Extract for Quarter 2 2026

The SPAP/ADAP Quarterly Ad-Hoc Data Extract consists of the following files downloaded from the HPMS Repository:

readme_June_CY2026_ADAPs_Qualified_SPAPs.txt
June_CY2026_ADAPs_Qualified_SPAPs.xlsx                                                          

  ******

CHANGE LOG:
07/26/2019  Added - A_BIN, A_PCN, A_BIN_EFFECTIVE_START_DATE, A_BIN_EFFECTIVE_END_DATE, B_BIN, B_PCN, B_BIN_EFFECTIVE_START_DATE, B_BIN_EFFECTIVE_END_DATE, C_BIN, C_PCN, C_BIN_EFFECTIVE_START_DATE, C_BIN_EFFECTIVE_END_DATE, PROGRAM_WEBSITE
  
07/26/2019  Removed - BIN, PCN, TERMINATION_DATE, COVERAGE_COSTSHARE_ALL_YN, COVERAGE_COSTSHARE_DED, COVERAGE_COSTSHARE_ICL, COVERAGE_COSTSHARE_GAP, COVERAGE_COSTSHARE_CAT

07/26/2019  Renamed - PROG_TYPE to ADAP_OR_SPAP, STATUS_ID to STATUS_INFORMATION

04/01/2020  Added - PROG_STATE

03/11/2026  Renamed BIN to BIN_IIN for these A_BIN_IIN, A_BIN_IIN_EFFECTIVE_START_DATE, A_BIN_IIN_EFFECTIVE_END_DATE, B_BIN_IIN, B_BIN_IIN_EFFECTIVE_START_DATE, B_BIN_IIN_EFFECTIVE_END_DATE, C_BIN_IIN, C_BIN_IIN_EFFECTIVE_START_DATE, C_BIN_IIN_EFFECTIVE_END_DATE

  ******

June_CY2026_ADAPs_Qualified_SPAPs.xlsx is an excel file containing State Pharmaceutical Assistance Program (SPAP)/AIDS Drug Assistance Program (ADAP) information.
The file contains the following columns:

PROG_ID                                      Attestation Number
PROG_YEAR                                    Program year
PROG_STATE                                   Program State
ADAP_OR_SPAP                                 Program Type
GROUP_ID                                     Group Identification
A_BIN_IIN                                    Bank Information Number 1
A_PCN                                        Processor Control Number 1
A_BIN_IIN_EFFECTIVE_START_DATE               Bank Information Number Effective Start Date 1
A_BIN_IIN_EFFECTIVE_END_DATE                 Processor Control Number Effective End Date 1
B_BIN_IIN                                    Bank Information Number 2
B_PCN                                        Processor Control Number 2
B_BIN_IIN_EFFECTIVE_START_DATE               Bank Information Number Effective Start Date 2
B_BIN_IIN_EFFECTIVE_END_DATE                 Processor Control Number Effective End Date 2
C_BIN_IIN                                    Bank Information Number 3
C_PCN                                        Processor Control Number 3
C_BIN_IIN_EFFECTIVE_START_DATE               Bank Information Number Effective Start Date 3
C_BIN_IIN_EFFECTIVE_END_DATE                 Processor Control Number Effective End Date 3
PROG_NAME                                    Program Name
PROGRAM_WEBSITE                              Program Website
STATUS_INFORMATION                           Status Information
CREATE_DATE                                  Created Date
LAST_MOD_DATE                                Last Update Date
FIRST_NAME                                   First Name
LAST_NAME                                    Last Name
PHONE                                        Phone Number
PHONE_EXT                                    Phone Extension
EMAIL                                        Email
URL                                          URL