| Maintenance | Drug Catalog

The Drug Catalog contains the contents of your primary drug vendor's drug catalog. It is updated automatically once a week to reflect any changes from your vendor such as pricing and offering. You can complete the following tasks on the Drug Catalog page:

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

• Add an Item to the Catalog
• Exclude an Item from 340B Eligibility
• Add an Item to the GPO Exclusion Exempt List
• Update an Item's Pricing  

Filter Options

The Filter Options panel contains catalog and vendor options:

• Select the catalog type: Default or Direct.
• Select the vendor catalog to load on the main panel of the screen.

The FILTER OPTIONS panel remains visible by default on the MAINTENANCE/Drug Catalog page.  You can collapse the FILTER OPTIONS panel by clicking the drop-down arrow. 

Search Option/Search Text

The Search field is located on the left panel within FILTER OPTIONS on the MAINTENANCE/Drug Catalog page.

When the MAINTENANCE/Drug Catalog page loads, the first 25,000 NDCs of the DEFAULT catalog displays. From this point, your filtering is limited to the first 25,000 NDCs. You can utilize the following features, SEARCH OPTION and SEARCH TEXT, to expand your search over the whole catalog and narrow the result of records.  Select one of the SEARCH OPTIONS: NDC, NDC Description, or Item Number, and then type all or partial information in the SEARCH TEXT field.  Click Refresh to load the specified data.

Examples: Start with changing VENDOR: to ALL, SEARCH OPTION: NDC, SEARCH TEXT: 250, and click Refresh.  What displays are NDCs that contain the number 250 from all vendors.  NOTE: The maximum number of records returned is 25,000.

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

Within the left panel FILTER OPTIONS, you can export data by clicking . In addition to exporting the ENTIRE data set, you can export the FILTERED data set in the following formats: Excel 2003, Excel 2007, PDF, or CSV.

Main Panel

The Main panel contains the details of items in your drug catalog.

• Enter full or partial information in the Search field to narrow the display or search for a specific item.

Right-click Menu

The right-click menu also allows you to update pricing, exclude items from eligibility, and view drug details and accumulations:

• Update Pricing: Edit an item's pricing information. Go to the Update an Item's Pricing topic.
• Exclude from 340B Eligibility: Make an item ineligible for 340B pricing. Go to the Exclude an Item from Eligibility topic.
• Exempt from GPO Exclusion: Add an item to your site's GPO Exclusion Exempt List, preventing the item from order splitting to WAC. Go to the Add an Item to GPO Exclusion Exempt List topic.
• View Accumulation Details: View accumulation and purchase history for the selected item. Go to Accumulation Details topic.
• View Accumulation Tracker: View a visual representation of the accumulation history for the selected item. Go to Accumulation Tracker topic.
• Drug Savings: Generate the drug savings chart for the selected item. This chart displays pharmacy drug savings by month. Savings are calculated by subtracting the 340B price from the GPO price and multiplying the result by the number of available packages for a drug.
• Drug Spend: Generate the drug spend chart for the selected item. This chart compares drug spending by month for your pharmacy's 340B and GPO accounts (includes WAC account, if applicable).
• Pricing History: Generate the pricing history chart for the selected item. This chart displays dates when the pricing for the item changed and graphically depicts whether the pricing increased or decreased.