Pharmacy Filter Import

The Pharmacy Filter allows you to import filter data on pharmacies based on either their NPI or NCPDPID.

The purpose of this page is to define data and fields that may be imported into MIE systems (Webchart, Enterprise Health) using the WC Pharmacy Filter Import.

Specifications

Quick Reference Specificiations

  • File format: Data files shall be formatted in Comma Separated Values (CSV)
  • The first row of the file shall contain column header information.
  • Each subsequent row shall represent an encounter order(s).

Field Definitions by Table

FILTER_NAME

  • This is the name you give to your filter.

NPI

  • Provider specific id consisting of 9 numeric digits with 1 check digit.

NCPDPID

  • Provider specific id consisting of 7 numeric digits assigned to every licensed pharmacy.

Column Definition

  • R = Required
  • O = Optional
NameTypeRequiredComments
FILTER_NAMEcharRName of the Filter
NPIintegerO*National Provider Identifier
NCPDPIDintegerO**National Council for Prescription Drug Programs ID
``` *Optional when NCPDPID is present in row. **Optional when NPI is present

## Examples of CSV

Import with 2 records: one record with a NPI identifier and another with a NCPDPID identifier.

FILTER_NAME,NPI,NCPDPID MyFilter1,1234567890, MyFilter2,,1234567




Import with an additional record that contains both an NPI & NCPDPID. When this occurs, the NCPDPID identifier takes precedence.

FILTER_NAME,NPI,NCPDPID MyFilter1,1234567890, MyFilter2,,1234567, FilterWithBoth,1234212, 1251254150




## Sampe CSV Files

[File:Pharmacy Filter Example.csv](https://miewiki.med-web.com/wiki/index.php/File:Pharmacy_Filter_Example.csv)

## Related Pages

* [Data Import Master List](data-import-master-list.md)

Enterprise Health Documentation

Last Updated:

Last Build: Fri, 07 Jun 2024 13:13:36 EDT
WikiGDrive Version: dd69069d725fca5f553df7ded62e130a49d49ca6