| Data Review | Pharmacy Search

The Pharmacy Search page allows you to compare data for a pharmacy in a single view. The main panel of the page contains two panes that populate with your chosen data types. For example, you can compare drug accumulations to drug purchases.

To view a video of how to use some of the features in Pharmacy Search, click here.

Filter Options

Filter unmatched items by Pharmacy type, Account type, and  Start and End Dates using the Filter Options panel:

• Enter Start and End Dates to for the data comparison.
• Select the data for the left and right panes of the page in the Left Side and Right Side fields:

• Hospital Charges
• Retail Dispense
• Purchases
• Crosswalk
• Accumulations

§        Click the Export icon, and select a file format: Excel 2003, Excel 2007, PDF, or CSV. 

Main Panel

The Main panel displays the sets of data you selected in the Filter Options panel :

• Click View Exclusions to view the Utilization Exclusion List. Go to the View Exclusions topic.
• Enter full or partial information in the Search fields to narrow the display or to search for a specific item.

More options are available in left panel FILTER OPTIONS.  Combined with Column Filtering, Pharmacy Search is a more robust, focused researching tool.  The advantage with Pharmacy Search is you can compare data side-by-side.  Review the details of the new options below.

FILTER OPTIONS

The left panel FILTER OPTIONS remains expanded by default. You can collapse the FILTER OPTIONS by clicking the drop-down arrow.

GROUP BY

The GROUP BY option allows you to filter data by DAY, MONTH or YEAR.  The system will return a maximum of 25,000 records at a time.  When you select a GROUP BY option, and there are greater than 25,000 records available for a given DAY, MONTH, or YEAR, a WARNING message appears to alert you. In addition, in the LEFT and RIGHT SUMMARY panels the total count will display in red.  When this happens, you will only be able to filter through the first available 25,000 records.

DATE RANGE – START DATE & END DATE

The START and END DATE create a date range. After clicking the Generate button, data will generate for a date range less than or equal to 365 days. If you choose a date range greater than 365 days, 340B Architect will display a Warning message. Correct the date range, and then click Generate.

SEARCH TEXT

The Search field has moved from the main panel to the left panel within FILTER OPTIONS. You can reduce the number of records returned by using the features SEARCH OPTION and SEARCH TEXT.  Select a SEARCH OPTION, and then type all or partial information to search by in the SEARCH TEXT field. Click Generate to load the specified data.

Column Filters

You can further filter the searched data in one or more columns. 

To add a filter, type the filter value in an appropriate filter value field, click the filter button, and then select a filter option to reload the page. You can continue to add filters until you are satisfied with the results.

To remove a filter, click the filter button, and select the No Filter option. This will remove the filter and reload the page.

You can clear all the filters by clicking Clear Column Filter Values in the main panel above the column headings.  NOTE: this does not clear contents in the SEARCH TEXT field in the left panel.

DATA EXPORT

You can export data by selecting the  located next to the Generate button in the left panel under the FILTER OPTIONS heading. You can export a summary, selected section, filtered section or the entire report for both left and right main panels.

Maximum number of records

The maximum number of records returned is 25,000. If more than 25,000 records are available, you will receive a WARNING message.  This means your search and filtering is limited to the first 25, 000 records. To increase your return of records first, make all your FILTER OPTION selections, and click Generate. Next, use the LEFT and/or RIGHT SUMMARY to select which line of data to view, and then continue to narrow your search with column filters.

ICON LEGEND

Upon loading the DATA REVIEW/Pharmacy Search page, the bottom left panel named ICON LEGEND is collapsed. You can display the ICON LEGEND listing by clicking the drop-down arrow.