Overview

When using the Exclude by BIN Filter Type on the Qualification Filters page, you can make bulk BIN exclusions and apply them to multiple HIDs/PIDs. This is helpful when you want to prevent multiple BINS from qualifying for 340B. 

How to Make Bulk BIN Exclusions 

1. Select the desired BINS from the left side of the Qualification Filter page by clicking the checkboxes. 

2. Click the Bulk BIN Exclusion button at the top of the page. 

3. A window will appear showing the previously selected BINs. Click Next in the lower left corner. 

4. Select the HIDs/PIDS to which the exclusions will be applied.  You can filter by pharmacy type, search for a pharmacy, or click the boxes to the left of the HIDs/PIDs to designate where you want to apply the excluded BINS. Click Next. 

5. Review your changes and click Apply Updates in the top left corner. If you made a mistake, you can click Back and fix the error. 

You can also apply bulk BIN exclusions through a Manual Entry. 

1. Click the Bulk BIN Exclusion button. 

2. The Exclude By BIN Batch Update window will appear. Select Manual Entry, then click the blue plus sign to add an entry. 

3. Manually add BINs and exclusion details into the window. 

The required fields are:

• BIN: number must be 6 digits
• Exclusion Type: Medicaid, Medicare Part B, Custom Plan
• Effective Date: the date the exclusion will be applied 

4. Click Next and follow steps 4-5 above 

The third way to do a Bulk BIN Exclusion is through a File Upload: 

1. Click the Bulk BIN Exclusion button. 

2. The Exclude By BIN Batch Update window will appear. Select File Upload, then click Download Template.

3. Fill out the Manual Upload Template and save the file as a .csv. 

• Date Format in MM/DD/YYYY
• File should contain the following headers
  • BIN: 6 characters (*required*)
  • PCN 
  • GRP: Group 
  • Exclusion Type: must enter 1, 2, or 3 (*required*)
    • Medicaid = 1
    • Medicare Part B = 2
    • Custom Plan = 3
  • Effective: Effective date (*required*)
    • effective date is not greater than term date
  • Terminated: Terminated date
  • Notes 

4. Click Upload BIN Exclusions List, then Browse to search for your manual upload .csv file. 

5. Click Upload File. 

6. The data from your file will appear in the window. You can edit this data, but no changes will be until you complete the remaining steps. 

7. Click Next and follow steps 4-5 above 

8. After making a manual upload, you can check the status of the upload in the Bulk Bin Exclusions table, which shows the user ID, file name, and file content. After successful upload, this file will also save in the transaction log.