On the h= ome page users can find:

·      = Current aler= ts and notices

·      = A list of th= e most recent enhancements made to the site

·      = User manuals=

·  &n= bsp;    Link for providing feedback to HRSA on the site and its contents

The 340B Database Website Home Page Menu offers the following selections:

·      =    DSH Hospitals Spreadsheet - provided to the Office of Pharmacy Affairs (OPA) by the Centers for Medicare and Medicaid Services (C= MS) and is the official source used to verify a hospital’s DSH adjustment percentage

·      =    Termination Reports and Codes- Numeric termination cod= es and the text explanations for the corresponding code

·      =    Medicaid Exclusion Files- help States and manufacturers avoid the application of the 340B discount and the Medicaid rebate to the s= ame drug purchases (a duplicate discount)

·      =    Covered Entity Database Acronyms- 340B ID Prefix lette= rs and the list of entity types/grantees for each corresponding code

·      =    Database Notes- Updates, explanations and reference information relating to data in the 340B Drug Pricing Database
Using the Contracted Entity Data Extract<= /a>

The Covered En= tity Tab

Step 1. Enter the following data (optional):=

·     340B ID numb= er

·     Entity Name<= o:p>

·     City

·     State

·     Zip Code

·     Program Type=

·     Participatin= g (yes or no)

Step 2. Select Output type (required):

·     Look up R= 11; electronic list

·     Report File-= file in Excel

Step 3. Select Advanced Query Options (optional):

·     Quarter when= Entity was added

·     Quarter when= Entity was terminated

·     When Entity = record was edited



    Step 4.= Click Submit Query button to view results.

Wild Card Searches:

Wild card searches are activ= ated by inserting an * in any search criteria field.

For example: To search for a CE whose names begin with Health and ends with Services, you would enter Health * Services into the CE Name search field. Results would include: Health Care Services, Health Prov= ider Services, Health Rehabilitation Services, etc.

Where you place the wild card is critical. When you use = the * at the beginning of the search criteria (i.e. * Care) the system will retrieve all records where additional text appears before the word Care. For example: Senior Care, Health Care, Patient Care, etc.

Wild card searches will work in Covered Entity, Contract= ed Pharmacy and Manufacturer searches.

Note: The search engine uses each fie= ld as an “and”. The fewer criteria you enter, the wider your search will be and the more results will be returned.

Viewing the Covered Entity Query Results<= /a>

Output Type as Lookup disp= lays electronic results.=

1.      = Click on any column heading to sort the data in that column (ascending order)

2.      = Click on the 340B ID for detailed Contract Record

Covered Entity Detail Includes:

·      =    Entity Name

·      =    Sub-division Name

·      =    Address

·      =    Billing Address

·      =    Shipping Address

·      =    Comments

·      =    340B Program Information

·      =    Additional Shipping Addresses=

·      =    Authorizing Official

·      =    Contact Information

·      =    Other Related Entities (view related entity details by clicking on the Detail option)

On the Covered Entity Detail Screen:

1.&n= bsp;   View the Entity Information

2.&n= bsp;   View the Contr= acted Pharmacy data (click link to view Pharmacy r= ecord)

3.&n= bsp;   View 340B information

<= span style=3D'font-size:11.0pt;font-family:Verdana;mso-fareast-font-family:Verda= na; mso-bidi-font-family:Verdana;mso-no-proof:yes'>4.     View detailed information on Related Entities <= /b>(click detail)

Viewing the Covered Entity Query Results (continued)

Output as Repo= rt File displa= ys results in an Excel file. Depending upon which options the user selects, the output will reflect their selections. The legacy report file* is no longer available as of 3/31/2006.

Select Report = File, then choose from the established options, or customize the report with any fields you choose.

The customizab= le fields allow selection of any available field.

* As a substitute for the le= gacy report that is no longer available, users may run the Report file and select the option to Print All Fields (excluding bill= ing, shipping and contracted pharmacy information.) <= o:p>

Excel spreadsh= eet format allows you to view and sort the Covered Entity data.

Covered Entity= data in an Excel spreadsheet can be saved on your computer for future reference.=

Using the Medicaid Provider Number Search=

Output Type as Lookup disp= lays electronic results. Output Type as Report File displays results in an Excel file.

Step 1. Enter the following data (optional):=

· Medicaid State Code

· Program Type=

· Participatin= g (yes or no)

Step 2. Select Output type (required):

· Look up R= 11; electronic list

Report File- Excel file=

Step 3. Select Advanced Query Options (optional):

· Quarter when= Entity was added

· Quarter when= Entity was terminated

· When Entity = record was edited

Step 4. Click Submit Query button to view results.

Using= the Contracted Pharmacy Data Extract

The Contracted Pharmacy Tab

Step 1. Enter the following data (optional):=

· 340B ID numb= er

· Entity Name<= o:p>

· Entity City

· Entity State

· Pharmacy Nam= e

· Pharmacy City

· Pharmacy State

Step 2. Select Output type (required):

· Look up R= 11; electronic list

· Report File-= more detailed file in Excel

Step 3. Select Advanced Query Options (optional):

· Contracted P= harmacy begin date

· Contracted P= harmacy termination date

· When Pharmac= y record was edited

    Step 4.= Click Submit Query button to view results.

Note: The search engine uses each fie= ld as an “and”. The fewer criteria you enter, the wider your search will be and the more results will be returned.

<= img width=3D278 height=3D159 src=3D"PublicUserInstructionManual_HTML_103006_files/image007.gif" v:shapes= =3D"_x0000_s1192">

Viewing the Contracted Pharmacy Query Results

Output Type as Lookup disp= lays electronic results.=

1.    Click on any column heading to sort the data in that column (ascending order)

2.    Click on the 340B ID number to view the contract detail page.

3.    Click on the Pharmacy Name to view the detail page for only the selected Pharmacy.

View Detail on= a Contract Look up

ContractDetail Include= s:

·      =    Pharmacy Name

·      =    Pharmacy Address

·      =    Pharmacy Contact

·      =    340B ID Number

·      =    Covered Entity Name

·      =    Sub-division Name

·      =    Grant/Provider Number

·      =    Relevant Dates

·      =    Address

·      =    Contract Information

·      =    Entity Contact

·      =    Signing Information

On the Contracted Pharmacy Detail screen:

1.&n= bsp;   View the Contr= acted Pharmacy Information

2.&n= bsp;   View detailed information on the Contract

3.&n= bsp;   View the Main Pharmacy record

<= span style=3D'font-size:11.0pt;font-family:Verdana;mso-fareast-font-family:Verda= na; mso-bidi-font-family:Verdana'>4.     View the Covered Entity record

Viewing the Contracted Pharmacy Query Results

View Detail on= a Contract Look up

Contracted Pharmacy Detail Includes:

·      =    Pharmacy Name

·      =    Pharmacy Address

·      =    Contact Information

·      =    Contracts

View detailed information on Contracts (click detail) to display= the contract specific details

View Covered E= ntity Record from Pharmacy Look up

Covered Entity Detail Includes:=

·      =    Entity Name

·      =    Sub-division Name

·      =    Address

·      =    Billing Address

·      =    Shipping Address

·      =    Comments

·      =    Alternate Shipping Addresses<= /p>
·      =    Contracted Pharmacies

·      =    340B Program Information

·      =    Authorizing Official

·      =    Contact Information

On the Covered Entity Detail screen:

5.&n= bsp;   View the Cover= ed Entity Information

6.    View additional address information

<= span style=3D'font-size:11.0pt;font-family:Verdana;mso-fareast-font-family:Verda= na; mso-bidi-font-family:Verdana'>7.     View other Contracted Pharmacy records (click link to return to the primary Contracted Pharmacy record)

8.&n= bsp;   View 340B and Contact Information

Viewing the Contracted Pharmacy Query Results

Output Type as Report File displays results in an Excel file.

Excel spreadsheet allows you to view and sort the Contracted Pharm= acy data.

Contracted Pharmacy data in an Excel spreadsheet can be saved on y= our computer for future reference.

Using the Manufacturer Data Extract

The Manufactur= er Tab

Step 1. Enter the following data (optional):=

· Label Code

· Manufacturer= Name

· City

· State

· Zip Code

· Contact Name=

Step 2. Select Output type (required):

· Look up R= 11; electronic list

· Report File-= text file in Excel

Step 3. Select Advanced Query Options (optional):

· OPA Terminat= ion Date

· CMS Terminat= ion Date

· Date Manufac= turer was signed

· Date the rec= ord was most recently edited

Step 4. Click Submit Query button to view

Note: The search engine uses each fie= ld as an “and”. The fewer criteria you enter, the wider your search will be and the more results will be returned.

Viewing the Manufacturer Query Results

Output Type as Lookup disp= lays electronic results.=

1.    Click on any column heading to sort the data in that column (ascending order)

2.    Click on the Label Code number to view the Manufacturer detail page.

View Detail on a Manufacturer Look up

Manufacturer Detail Includes:

·      =    Label Code

·      =    Manufacturer Name

·      =    Manufacturer Address

·      =    OPA Term

·      =    CMS Term

·      =    Comments

·      =    Corporate Information

·      =    Contact Information

Viewing the Manufacturer Query Results

Output Type as Report File displays results in an Excel file.

Ex= cel spreadsheet allows you to view and sort the data and can be saved on your computer for future reference.

Reports Tab

Select from Available Reports

Daily Reports*= Do= wnload a file of the whole database using the Daily Reports options. The reports t= ab provides the option to select and run all available reports listed below.

Quarterly Repo= rts Information is updated on a quarter= ly basis including new additions and terminations in Excel or PDF format.=

Statistical Re= ports Historical data reflecting changes = in the 340B Drug Pricing Program

Charts and Gra= phs Basic data representing data in the= 340B Drug Pricing Program

The Daily Reports Menu provi= des the option to select and run all available file downloads. Select the Daily Report or Real-Time Excel spreadsheet report to download.=

The Daily Report and Real-Time Repo= rt are Excel files. Excel spreadsheets allow you to view and sort the data. All fi= les can be saved on your computer for future reference.

*The Daily Report is udpated each day.