Attachment J-4 MTF Sites.xlsx

Notes

NOTES:

11/5/2019

* Added two new columns TYPE OF MARKET and NAME OF MARKET for DHA market alignment from Roger's report.

* Roger identified CCL MTF pharmacies in Active tab that did not have workload from April - October 2019. Rose contacted MTF and verified MTF which can get closed. Moving MTFs from Active Tab to Inactive Tab.

10/24/2019 RVM

* Added Parent DMIS, edited DMIS ID and DMIS Facility Name per latest Oct 2019 DMIS Table

10/09/2019 RVM

* Moved DoD WASH DC WNY ePhcy from active tab to inactive tab. Quantico Phcy Chiefe Kim-Nga Huynh confirms inactivation.

9/30/2019 RVM

* Moved DoD WEST KILLEEN ePhcy from active tab to inactive tab. Ft Hood confirms site not in use - RVM

9/23/2019 RVM

* Change DoD FT CAMPBELL ePhcy fax number from (270) 412-3026 to (270) 412-3234.

* New MTF Pharmacy / DoD INDIANHEAD ePhcy / NCPDP 2143422 / NPI 1184273195.

* New MTF Pharmacy / DoD DAHLGREN ePhcy / NCPDP 4850675 / NPI 1174172183.

8/20/2019 RVM

*New MTF Pharmacy / DoD SABAL PARK ePhcy / NCPDP 5742235 / NPI 1578119087

08/08/2019 RVM

-----Original Message----- From: Gonzalez, Rosemary CTR DHA PHARMACY OPS (USA) Sent: Wednesday, August 7, 2019 1:59 PM To: Maldonado, Regina V CTR DHA PHARMACY OPS (USA) <regina.v.maldonado.ctr@mail.mil> Subject: MACDILL PHARMACY NAME CHANGES

Gina, Name changes for MACDILL:

* MACDILL PHARMACARE CTR PHCY-NCPDP # 1087786-has changed to MACDILL CALL-IN AC PHCY

* MACDILL PHARMASSIT PHCY- NCPDP 5721534- has changed to MACDILL PHARMACARE PHCY

Change request from SMSgt Vaughn:

1. "Pharmacare" be changed "Call-in Refills (Audiocare)" for DHA reporting

2. "Pharmassist" be changed to "Pharmacare" for DHA reporting

05/31/2019 RVM

* New MTF Pharmacy BLISS DS CBPCC PHCY / NCPDP 5927871 / NPI 1225503105

* New MTF Pharmacy BRAGG ED DC PHCY / NCPDP 3471620 / NPI 1033775150

* New MTF Pharmacy BRAGG PACU PHCY / NCPDP 3471632 / 1356907471

05/21/2019 RVM

Per Rose, Change on ESI CCL only - MTF ePhcy Fax # Change Eglin and Tyndall

* DoD Eglin ePhcy / NCPDP 5720823 / NPI 1598177123 / New Fax (850) 883-9131

* DoD Tyndall ePhcy / NCPDP 57221632 / NPI 1962801928 / New Fax (850) 283-7013

04/17/2019 RVM

* New MTF Pharmacy EUSTIS CBPCC PHCY / NCPDP 4850461 / NPI 1609339340

03/26/2019 RVM

* Moving DoD Fairchild ePhcy to 'Working List Inactive' tab and 'E-Phcy Using Parent Codes' / NCPDP 4936247 / NPI 1922411529

* Name change from DoD Macdill ePhcy to MACDILL PHARMASSIT PHCY / NCPDP 5721534 / NPI 1104232214

* New MTF Pharmacy DoD MACDILL ePhcy / NCPDP 5740849 / NPI 1538629415

11/30/2018 RVM

Note from Rose, Spoke with Suzana Oh and she stated that the providers were still renewing prescriptions and the Pharmacy staff was still processing prescriptions from the Holding Queue and agrees that the NPI for DoD PORTS VA SCOTT CENTER ePhcy should stay active for a year.

Moved from spare code tab to active 1013319755 4845838 DoD PORTS VA SCOTT CENTER ePhcy

10/16/2018 RVM

Per Rosemary, Dr. Suzana Oh from Portsmouth has requested for the following sites to get republished. Moving these sites from Inactive tab to Active tab:

9/27/2018 RVM

The following Portsmouth epharmacies are no longer in service per Dr. Oh; PASS will move sites from Active listto Inactive list but will NOT deactivate at NCPDP in the event that Portsmouth wants to go back and open epharmacies:

1548664949 4845888 DoD PORTS VA NORTHWEST NSG ePhcy 1508270950 4845383 DoD PORTS VA TPC CHESAPEAKE ePhcy 1205249059 4845369 DoD PORTS VA BHC SEWELLS PT ePhcy 1205249075 4845357 DoD PORTS VA LITTLE CRK ePhcy 1548673205 4845371 DoD PORTS VA NMC PORTSMOUTH ePhcy 1114403961 4849886 DoD PORTS VA TPC SUFFOLK ePhc 1396158168 4845345 DoD PORTS VA DAM NECK ePhcy 1578977666 4845410 DoD PORTS VA BHC OCEANA ePhcy 1851704431 4845408 DoD PORTS VA TPC VA BEACH ePhcy 1952717472 4845460 DoD PORTS VA BHC YORKTOWN ePhcy 1013319755 4845838 DoD PORTS VA SCOTT CENTER ePhcy (never used [listed in spare codes])

* New MTF Pharmacy -> DoD ROCK ISLAND CC ePhcy / NCPDP 1494640 / NPI 1457835456

* New MTF Pharmacy -> ROCK ISLAND MAIN CC PHCY / NCPDP 1494638 / NPI 1942783246

9/19/2018 RVM

* Name change request per Capt Alexander Brown at Nellis / Change to DoD NELLIS AIR FORCE BASE ePhcy / NCPDP 2993459 / NPI 1942616057

8/20/2018 RVM

* New MTF Pharmacy -> DoD WEST KILLEEN ePhcy / NCPDP 5925473 / NPI 1699255901

* New MTF Pharmacy -> HOOD CBPCC WK PHCY / NCPDP 5925461 / NPI 1255811568

8/3/2018 RVM

* New MTF Pharmacy -> PORTS VA TPC SUFFOLK PHCY / NCPDP 4849913 / NPI 1831675420

* New MTF Pharmacy -> DoD PORTS VA TPC SUFFOLK ePhcy / NCPDP 4849886 / NPI 1831675420

* Change NMCPTSVA SCOTT CTR name / NCPDP 4834330 / NPI 1790884823 to PORTS VA SCOTT CTR REFILL PHCY

* Move DoD PORTS VA SCOTT CENTER ePhcy (previously in active tab) / NCPDP 4845838 / NPI 1013319755 to spare code tab - never used by site

* PORTS VA SCOTT CTR REFILL #2 PHCY NCPDP 4849937 / NPI 1366929069 added to spare code tab - never used by site; per Suzana Oh not needed

* Updated Fax Number DoD BULVERDE ePhcy to (210) 292-5567

7/10/18 RVM

* New MTF Pharmacy -> DoD REID ePhcy / NCPDP 5925067 / NPI 1699269852

* Update DMIS ID and DMIS Facility Name -> LACKLAND REID OP PHCY / NCPDP 4517605 / NPI 1790884856

* Update DMIS ID and DMIS Facility Name -> DoD BULVERDE ePhcy / NCPDP 5923467 / NPI 1184122749

6/18/18 RVM

Per Roger/Rose, need to change Temecula site name from Camp Pendleton to Temecula. New change code is 9EWP.

6/14/18 RVM

New MTF Pharmacy -> DoD TEMECULA NBHC ePhcy / NCPDP 5666702 / NPI 1992298764 New MTF Pharmacy -> TEMECULA NBHC PHCY / NCPDP 5666714 / NPI 1912490780

4/26/18 RVM

* Correct pharmacy name from DoD QUANTICO ePhcy to DoD QUANTICO MAIN ePhcy

* New MTF Pharmacy -> CARLISLE DUNHAM DDC PHCY / NCPDP 6006414 / NPI 1639667736

* New MTF Pharmacy -> CARLISLE DUNHAM TMC PHCY / NCPDP 6006426 / NPI 1457849556

03/23/18 SGR

Change CONUS regions for T17 per R. Williams.

03/01/18 update only applied to Active Sites. This change applied to Inactive sites.

03/01/18 SGR

Change CONUS regions for T17 per R. Williams.

The new East region is a combination of the current North and South regions. Therefore, all MTF Pharmacies in a North or South region will now be in the East region. The West, Europe and Pacific regions are not affected by the change.

02/06/2018 RVM

Name Change for the following MTF sites per Rose:

New MTF Pharmacies

LACKLAND GB CLINIC PHCY / NCPDP 5923481 / NPI 1508364258

DoD BULVERDE ePhcy / NCPDP 5923467 / NPI 1184122749

02/01/2018 RVM

New MTF Pharmacy -> DoD PANAMA CITY NBHC ePHCY / NCPDP 5736698 / NPI 1114425113

01/23/2018 RVM

Correcting site name for NCPDP 31419510 / NPI 1346349792 from LAKEHURST PHCY to NCA-LAKEHURST PHCY

12/14/2017 RVM

- Per Roger Williams, Capt Ha (Phcy Navy Consultant), and Dr. Vancheri (San Diego), SAN DG CENTRAL REFILL PHCY NCPDP 5659442 / NPI 1952765125 was listed as a Camp Pendleton site, but should be listed as a San Diego site. Making correction to Chain Code, Site, City, DMIS ID, DMIS Facility, and Zip

- Updating Los Angeles e-pharmacy fax number

10/2/2017 RVM

New MTF Pharmacy

CARSON CBPCC PHCY / NCPDP: 0625511 / NPI: 1639689904

9/11/2017 RVM

New CCL will only go to ESI since they request fax # info Updated fax numbers for the following MTF epharmacies per R. Gonzalez:

9/6/2017 RVM

- Changed chain code for Lakehurst pharmacy NCPDP 3141950

- Removed 7 MTF sites from Active tab to Inactive tab due to pharmacy closure and inactivated at NCPDP Everett Smokey Point BMC Phcy 4929672 / 1427157569 McChord POE Phcy (Main) 4927197 / 1366541401 McAlester Phcy 3723891 / 1982703245 Dugway HC Phcy 4609307 / 1689773707 Bethesda IDSI Phcy 2125688 / 1437258845 Willow Grove Phcy 3979082 / 1295834455 San DG San Clemente Phcy 5626974 / 1578762175

7/12/2017 RVM

Geoff Baker from ESI identified that NCA Lakehurst NPI 1437211844 was closed at NCPDP in 2007, yet prescriptions were processing recently. He wanted to verify if site is active or not. Rose investigated and verified that NCA Lakehurst ACTIVE on CCL and NCA Lakehurst INACTIVE on CCL need to get swapped. Unknown reason for mix up. I'll make the change and send out.

Roger Williams reported 5 sites that require Service Command updates:

CAMP SHELBY / NCPDP 2585872 / NPI 1609975036 from SRMC to RHC-A ILLESHEIM / NCPDP 8110190 / NPI 1508935792 from ERMC to RHC-E KATTERBACH / NCPDP 8110188 / NPI 1891864054 from ERMC to RHC-E LIVORNO / NCPDP 8110532 / NPI 1467521542 from ERMC to RHC-E FT. HAMILTON / NCPDP 3308120 / NPI 1912006362 from NRMC to RHC-A

Roger Williams identified Yokota was hidden and had incorrect chain code which should be PMG

4/18/2017 RVM

New MTF Pharmacy:

DRUM TMC REFILL PHCY / NCPDP 5819339 / NPI 1639603731

Inactive DMIS Facility ID changed to Active DMIS Facility ID:

Camp Pendleton OCEANSIDE TOC eRx PHCY / NCPDP 5651650 / NPI 1114330982 changed DMIS from 6216 to 0029 Camp Pendleton OCEANSIDE TOC PHCY / NCPDP 0549468 / NPI 1760589527 changed DMIS from 6216 to 0029 WCC San Diego OCEANSIDE TOC eRx WCC PHCY / NCPDP 5655090 / NPI 1750768990 changed DMIS from 6216 to 0029 WCC San Diego OCEANSIDE TOC WCC PHCY / NCPDP 5655127 / NPI 1821485145 changed DMIS from 6216 to 0029 HONOLULU / NCPDP 1204229 / NPI 1801995436 changed DMIS from 6513 to 0052 HAMILTON / NCPDP 3308120 / NPI 1912006362 changed DMIS from 0438 to 0086

4/11/2017 RVM

New MTF Pharmacies:

FAIRFAX HD PHCY / NCPDP 4847779 / NPI 1447783378

DUMFRIES HD PHCY / NCPDP 4847781 / NPI 1356874283

3/15/2017 RVM

Internal Update; no CCL will be forwarded to outside groups (CHC, DSC, ESI) Several USCG sites are NCPDP/NPI active, but not active in CHCS. In Feb 2016, all USCG sites were moved to Inactive tab. Following note added in the event the sites move back to CCL Active tab when MHS Genesis deploys: "3/15/17: Per Rose, this USCG site is active regardless that it is not CHCS active. It will remain in the inactive tab, but may be moved later when MHS Genesis deploys. RVM":

ALAMEDA USCG PHCY 1932206794

AGUADILLA USCG PHCY 1285733444

MOBILE USCG PHCY 1144327990

BALTIMORE USCG PHCY 1083711832

CLEARWATER USCG PHCY 1770682445

ELIZABETH CITY USCG PHCY 1568561884

PTSMTH USCG PHCY 1225135080

YORKTOWN USCG PHCY 1659470797

CAPE MAY USCG PHCY 1164529913

PETALUMA USCG PHCY 1114024973

WASH DC HHQ USCG PHCY 1831296680

NEW LONDON USCG PHCY 1578660320

KODIAK USCG PHCY 1104925262

CAPE CODE USCG PHCY 1932208352

OPA LOCKA USCG PHCY 1558468306

SEATTLE USCG PHCY 1770680530

3/7/2017 RVM

New MTF Pharmacy: BETHESDA WWRB PED PHCY / NCPDP 2140820 / NPI 1780124651 MTF Pharmacy Name Correction: STUTGART PATCH PHCY / NCPDP 8110405 / NPI 1467521518 => STUTTGART

1/26/2017 RVM

New MTF Pharmacy:

CARSON SRP PHCY / NCPDP 0624999 / NPI 1366988214

PTSMTH NBHC PHCY / NCPDP 2009125 / 1629515911

Moved WALTER REED MAIN PHCY 0904056 1295832046 from Active tab to Inactive tab

Changed fax number for the following sites:

DoD SAN DG NMC ePhcy DoD ANDREWS ePhcy DoD FT RILEY ePhcy DoD KANEOHE BAY ePhcy DoD LACKLAND ePhcy DoD FT POLK ePhcy DoD NHP PENSACOLA SATL ePhcy

Changed CCL Pharmacy Name to match name listed in NCPDP:

ALTUS PHCY 97TH MDG

DAVISMON MAIN PHCY 335TH MDG

DAVISMON SATL PHCY

JACKSNVLE REFILL PHCY

JACKSNVLE SATL PHCY

KIRTLAND MAIN OP PHCY 377TH MDG

FT SAM HEM ONC PHCY

LITTLE ROCK MAIN PHCY

MAXWELL MAIN PHCY 42ND MDG

BETHESDA HEM ONC PHCY

BELVOIR AP HILL RPH PHCY

BELVOIR ER ECC PHCY

BELVOIR NON-FORMULARY PHCY

WASH DC DTHC HLTH CLINIC PHCY PENT

NELLIS ALPHA PHCY MAIN

NMCPTSVA NORTHWEST NSG

PORTS VA TPC CHESAPEAKE

LANGLEY RIGHT PHCY

PORTS VA BHC SEWELLS PT

PORTS VA BHC LITTLE CRK

NMCPTSVA SCOTT CTR

PORTS VA NMC PORTSMOUTH

PORTS VA BHC DAM NECK

PORTS VA BHC OCEANA

PORTS VA TPC VA BEACH

PORTS VA BHC YORKTOWN

SAN DG NAVEX 32ND ST PHCY

SAN DG HEM ONC PHCY

SAN DG NMC PHCY PARENT

USAH YONGSAN

DoD SEY-JOHN ePhcy

SEYJOHN PHCY 4TH MDG

SEYJOHN SATL PHCY

MONTEREY PHCY PRESIDIO OF

TRAVIS NO NEW REFILL PHCY

TRIPLER HEM ONC PHCY

DoD WR-PAT KITTYHAWK ePhcy

WRPAT KITTYHAW PHCY

WRPAT TELEPHONE CONSULT PHCY

DoD FT STEWART PX ePhcy DoD PORTS VA NMC PORTSMOUTH ePhcy

11/28/2016 RVM

New MTF Pharmacy: ANNAPOLIS BH REFILL PHCY / NCPDP 2140692 / NPI 1801339866

11/23/2016 RVM Update Per Elaine Sherman, requested Bragg Mini Mall name change to BRAGG WOMACK ANNEX PHCY, per COL Lance Raney.

10/31/2016 BN Update New MTF pharmary added Spangdahlem OTC Pharmacy NCPDP 8110823 | NPI 1255883997

10/20/2016 BN Update New MTF pharmacy added Bragg Mini Mall Pharmacy NCPDP 3466732 | NPI 1891246708

9/28/2016 BN Update TYNDALL SATL PHCY change name to TYNDALL MAIN PROVIDER PHCY NCPDP 1075286 NPI 1386708030 moved from inactive tab to active this NCPDP has been reassigned TYNDALL HOSPITAL PHCY change name to TYNDALL SATL PHCY NCPDP 1092232 NPI 1285733907 This change is per LtCol Fairley

08/29/2016 BN Update New MTF pharmay: DoD SOUTHCOM ePhcy / NCPDP 5732082 / NPI 1366997108 Moved from inactive to active tab: L Wood Refill Phcy / NCPDP 2633089 Moved from active to inactive tab: FT DIX TMC Phcy / NCPDP 3141734

06/14/2016: RVM Updates Sheyla from Decision Support Center (DSC) reported several active/inactive MTF pharmacies on CCL associated with inactive facilities. Sandy and Rosemary performed research and each active MTF was updated to Active DMIS Facility / ID. DSC and PASS agreed to leave Inactive MTF pharmacies associated with Inactive facilities; no action taken. Attached are the following changes:

0560474 CAMP PEND 62 ABC PHCY - changed DMIS ID from 1980 to 6225 0561490 CAMP PEND 33 ABC PHCY - changed DMIS ID from 1976 to 1407 0616601 CARSON WARRIOR PHCY - Inactive (No action taken) 0904056 WALTER REED MAIN PHCY - changed DMIS ID from 0037 to 0067 0904070 WALTER REED SUPPORT PHCY - Inactive (No action taken) 1562669 CAMP ATTERBURY PHCY - changed DMIS ID from 6017 to 0061 1826114 KNOX NELSON TMC PHCY - changed DMIS ID from 7198 to 0061 1929465 NEW ORLEANS NAC PHCY - Inactive (No action taken) 1930088 NEW ORLEANS EASTBANK PHCY- Inactive (No action taken) 2007234 BRUNSWICK PHCY- Inactive (No action taken) 2520826 PASCAGOULA PHCY- Inactive (No action taken) 2585872 CAMP SHELBY TMC PHCY - changed DMIS ID from 1230 to 0047 3141734 DIX TMC PHCY - changed DMIS ID from 7154 to 0086 3726443 SILL CBPCC PHCY- Inactive (No action taken) 3979082 WILLOW GROVE PHCY- changed DMIS ID from 0347 to 0067 4222888 CHARLESTON WS PHCY - Inactive (No action taken) 5127469 MCCOY TMC PHCY- changed DMIS ID from 1237 to 0061 5601097 CAMP PEND 41 ABC PHCY- changed DMIS ID from 1977 to 1409 5601516 CAMP PEND 43 ABMC PHCY- changed DMIS ID from 1978 to 1408 5601528 CAMP PEND 53 ABMC PHCY - changed DMIS ID from 1979 to 1406 5623435 SAN DG SANTEE PHCY - changed DMIS ID from 0409 to 0029 5651509 CAMP PEND 43 ABMC WCC PHCY - changed DMIS ID from 1978 to 1408 5651511 CAMP PEND 53 ABMC WCC PHCY- changed DMIS ID from 1979 to 1406 5651585 CAMP PEND 62 ABC WCC PHCY- changed DMIS ID from 1980 to 6225 5651826 CAMP PEND 41 ABC WCC PHCY- changed DMIS ID from 1977 to 1409 5651840 CAMP PEND 33 ABC WCC PHCY- changed DMIS ID from 1976 to 1407 8110140 UPWOOD CLINIC PHCY - changed DMIS ID from 7245 to 0814 8110164 SCHWEINFURT PHCY - Inactive (No action taken) 8110239 BAMBERG PHCY- Inactive (No action taken) 8110277 BITBURG PHCY- Inactive (No action taken) 8110328 BUTZBACH PHCY- Inactive (No action taken) 8110378 MANNHEIM PHCY- Inactive (No action taken) 8110392 HEIDELBERG PHCY- Inactive (No action taken) 8110417 HANAU PHCY- Inactive (No action taken) 8110568 LA MADDALENA PHCY- Inactive (No action taken) 8110683 MENWITH HILL PHCY- Inactive (No action taken) 8210027 CAMP LONG PHCY- Inactive (No action taken) 8210243 OKINAWA WHITE BEACH PHCY- Inactive (No action taken) 8210306 OKINAWA TORII PHCY- Inactive (No action taken) 8210445 TAEGU IDMT PHCY - changed DMIS ID from 0810 to 8907

05/06/2016: RVM Updates Request per Linda Benedict at Change Healthcare:

Could the London Phcy, NCPDP 8110621, no NPI, be removed from the inactive tab and placed on the delete tab?

Then Bahrain ISA BA Phacy, NCPDP 8110621, NPI 1891187449 can remain on the inactive tab?

Gina Notes: London is already on "Old Sites-Reused Codes" tab, but was also on Inactive tab. I deleted from Inactive tab. Will only send to CHC and DSC since ESI does not receive inactive tab information.

4/21/2016 - RVM Updates Identified were several differences between CCL and e-Pharmacy publish spreadsheet. Rosemary researched and identified items needing clarification:

e-Pharmacies Needing Fax Number Updates

e-Pharmacies that have been closed and no longer active; move to inactive tab:

e-Pharmacies name corrections:

New MTF Pharmacy:

SAN DG CENTRAL REFILL PHCY 5659442 / 1952765125: pharmacy is physically located at Camp Pendleton, but falls under San Diego. Will use San Diego DMIS ID.

MTF Pharmacy Name change:

BELVOIR WTU PHCY is changing to BELVOIR AMBULATORY PHCY 4836221 / 1689771438; the name has been BELVOIR WTU PHCY on the CCL since 2011, but Rosemary informed me that the name should be BELVOIR AMBULATORY PHCY, which is how it appears in NCPDP. Rose has no record of that change.

CCL Format Changes:

Removing Effective Date and Expiration columns; based of conversation with both Change Healthcare and ESI, the effective and expiration date columns are not utilized; the PASS will remove these fields.

3/23/2016: Active 684 [e-Phcy 169]; Inactive 434; ePhcy parent 12; Spare 29

1) CHINA LAKE WCC PHCY 5654872 1750778569 - Marked as e-Pharmacy, added fax number RVM

2) Moved several inactive pharmacies from ACTIVE tab to INACTIVE tab per Rosemary:

LA MADDALENA PHCY 8110568 1720157985

QUANTICO MAIN PHCY 4836423 1598864621

SUGAR GROVE PHCY 5011832 1326147463

SAN DG NMC CMOP 0521896 1962501924

MENWITH HILL PHCY 8110683 1679642862

SILL CBPCP PHCY 3726443 1912200221

SILL TMC # 1 PHCY 3726455 1457654766

LAJES FIELD PHCY 8110051 1851470017

SCHRIEVER REFILL PCTR PHCY 0623961 1285012922

HOOD PEDS PHCY 4510865 1881793032

DOD PAX RIVER EPHCY 2138508 1568877272 [MOVED TO SPARE CODE]

DOD PENSACOLA EPHCY 5721015 1730592593 [MOVED TO SPARE CODE]

BLISS RANGE PHCY 3212064 1316253297

BAHRAIN ISA AB PHCY 8110621 1891187449

L WOOD CLINIC ADMIN PHCY 2634029 1386743714

BITBURG PHCY 810277

BROOKS PHCY 4510978

KELLY OP PHCY 4511944

LACKLAND BMT OP PHCY 4511906

EARLE MAIN PHCY 3143536

3) WCC Transition for Lemoore and Fallon has been cancelled; these numbers were never used, moving to SPARE CODE tab RVM

FALLON WCC PHCY 2993726 1053708552

DoD LEMOORE WCC ePhcy 5654834 1093102808

LEMOORE OPS SC WCC PHCY 5654858 1205223021

LEMOORE WCC PHCY 5654846 1952798753

Also, changed color headers to match alphabetical order of group receiving CCL: CHC (Yellow) DSC (Blue) ESI (Green) PASS (Purple). Emdeon changed to Change Healthcare. RVM

3/16/2016:

New MTF Pharmacy CHINA LAKE REFILL PHCY/ NPI 1164883369 / NCPDP 5659252 - RVM Deactivated MTF: SCHWEINFURT / 8110164 / 1679642839- RVM Deactivated MTF: BAMBERG / 8110239 1447329644 - RVM

2/26/2016:

Roger Williams received word from USCG service consultant that all USCG sites are inactive; Hector agreed for the USCG sites on active tab to move to Inactive tab on CCL. The 35 USCG sites will not be deactivated at NCPDP at this time to avoid interference with possible programs, such as, iPLEDGE - RVM

2/24/2016:

As identified by Roger Williams/Dr. Steve Toney, changed service command for all Army sites and 1 Air Force site; no response from Navy - RVM

2/22/2016:

SAN DG MCX MIRAMAR PHCY NCPDP 5658832 NPI 1700245099 - RVM

1/20/2016:

DoD PAX RIVER EPHCY NPI 1568877272 - was provided incorrrect Service Command; should be NME

12/30/2015:

DoD OAK HARBOR ePhcy row, under Site column, removed space after Oak Harbor which was causing report issues

12/10/2015:

Marked Jackson Community e-Pharmacy as Inactive - RVM

10/26/2015: Active 738 [ePhcy 171]; Inactive 384; ePhcy using Parent ID 12; Spare 23)

New MTF Pharmacy: DoD HUNTER AF ePhcy NPI 1861805616 / NCPDP 1165338

10/23/2015: Per Rosemary, remove Hunter AF from Spare Codes tab - RVM

10/16/2015: (Same counts as 9/22/2015)

Per Roger Williams, update Service Command for the following pharmacies:

DoD Pax River ePhcy (NPI 1568877272) from HSON to NMNC DoD Ports VA Northwest NSG ePhcy (NPI 1548664949) from HSON to NME

Per Rosemary Gonzalez, Ft. Bliss (Richard Cisneros) request PDTS Pharmacy name change for the following pharmacy:

DoD FT BLISS ePhcy to DoD FT BLISS WBAMC ePhcy (NPI 1609289016)

9/22/2015: (Active 737 [ePhcy 170]; Inactive 384; ePhcy using Parent ID 12; Spare 24)

Moved 13 inactive MTF sites from ACTIVE tab to INACTIVE tab:

Yuma Flas Phcy 0324335/1972693208 Coleman Phcy 8110114/1417036633 Walter Reed IPP Site Phcy 0904107/1558460279 Walter Reed Support Phcy 0904070/1588763296 Tuzla Phcy 8110013/1013007665 Wuerzburg Phcy 8110253.1134298334 Delaware Bay USCG Phcy 3989019/1316132871 Hanau Phcy 8110417/1255400305 Pascagoula BMC Phcy 2520826/1912006339 Butzbach Phcy 8110328/1750450979 Okinawa Torii Phcy 8210306/1366511438 Mannheim Phcy 8110378/1508935644 Heidelberg Phcy 8110392/1306915459

9/16/2015: (Active 750 [ePhcy 170]; Inactive 371; ePhcy using Parent ID 12; 24 spare)

Added inactive notes for some MTF sites. Will run BO report to check last rx filled for those MTFs. RVM

9/4/2015:

New MTF Pharmacy:

BRAGG LINDEN OAKS PHCY NPI 1932577368 / NCPDP 3465324

8/20/2015:

-DoD NBHC PORTSMOUTH NEW HAMP ePHCY - Change Pharmacy City/State/Zip from Portsmouth, NH to Kittery, ME 03904 -PTSMTH NACC PHCY - Change Pharmacy City/State/Zip from Portsmouth, NH to Kittery, ME 03904 -Changing PDTS Pharmacy Name for all WCC Sites to include WCC11/13/2015

- Changed Effective Date for WCC sites which has been postponed per Leidos:

* Lemoore/Fallon 11/13/2015

* Camp Pendleton/29 Palms 01/15/2016

7/30/2015:

Emdeon identified an error with the chain code for Lemoore and Fallon pharmacies:

FALLON PHCY 2993726 1053708552 - Chain Code changed from 9EWA to 9EWB DoD LEMOORE ePhcy 5654834 1093102808 - Chain Code changed from 9EWB to 9EWA LEMOORE OPS SIDE PHCY 5654858 1205223021 - Chain Code changed from 9EWB to 9EWA LEMOORE PHCY 5654846 1952798753 - Chain Code changed from 9EWB to 9EWA

Per Roger Williams request, change Service Command from NRMC to JTFNCA for the following two sites:

DoD FAIRFAX ePhcy 1194122564

BELVOIR AP HILL (RPH) PHCY 1285733303

7/24/2015:

Site on Working Active List, but have been closed on 06/03/2015. Will remain on CCL for refill processing.

NPI I 1710084561 NEW ORLEANS EASTBANK PHCY

Changed Service from Army to Joint for the following two sites:

DoD FAIRFAX ePhcy 1194122564

BELVOIR AP HILL (RPH) PHCY 1285733303

Adding 33 new West Coast Consolidation (WCC) MTF pharmacies:

BRIDGEPORT PHCY 5654860 1912394727

CAMP PEND 13 ABC PHCY 5651814 1568876605

CAMP PEND 13 eRx PHCY 5651749 1205249042

CAMP PEND 14 ABC PHCY 5655064 1437546835

CAMP PEND 21 ABC PHCY 5651864 1043624497

CAMP PEND 22 ABC PHCY 5651927 1245645480

CAMP PEND 31 ABC PHCY 5651876 1598179905

CAMP PEND 33 ABC PHCY 5651840 1881008977

CAMP PEND 41 ABC PHCY 5651826 1285048348

CAMP PEND 43 ABMC PHCY 5651509 1093127789

CAMP PEND 52 ABC PHCY 5651991 1275948143

CAMP PEND 52 eRx PHCY 5651662 1972916740

CAMP PEND 53 ABMC PHCY 5651511 1962814582

CAMP PEND 62 ABC PHCY 5651585 1841603248

CAMP PEND PHCY 5655052 1437546827

CAMP PEND RAS PHCY 5655040 1609263003

DoD CAMP PEND ePhcy 5655115 1821485152

CHINA LAKE PHCY 5654872 1750778569

OCEANSIDE TOC eRx PHCY 5655090 1750768990

OCEANSIDE TOC PHCY 5655127 1821485145

POINT MUGU PHCY 5655103 1508253907

DoD PT HUENEME ePhcy 5655088 1033506431

PT HUENEME PHCY 5655076 1316334717

29 PALMS MAIN PHCY 5654923 1023405768

29 PALMS MSC PHCY 5654884 1326435124

29 PALMS REFILL PHCY 5654935 1386031029

DoD YUMA ePhcy 0359681 1942697685

YUMA MAIN PHCY 0359693 1699162339

DoD FALLON ePhcy 2993726 1053708552

FALLON PHCY

DoD LEMOORE ePhcy 5654834 1093102808

LEMOORE OPS SIDE PHCY 5654858 1205223021

LEMOORE PHCY 5654846 1952798753

6/26/2015:

ADD 2 NEW MTF SITES:

BAHRAIN EMC PHCY NPI 1063894061 / NCPDP 8110811

RILEY FH CBPCC PHCY NPI 1265814842 / NCPDP 1721617

CHANGE FOR DoD DUMFRIES EPHCY: FINAL SVC FROM ARMY TO JOINT; FINAL CMD FROM NRMC TO JTFNCA

6/18/2015:

Alphabetized by CHCS Host, Site and Pharmacy Name ~ RVM

5/29/2015: NAME CHANGE ONLY

LT Pulido at Camp Pendleton requested three Camp Pendleton e-pharmacies to get unpublished, but will continue to be used in CHCS for internal e-script management

NPI 1992117782 DoD CAMP PEND 13 ePhcy changed to CAMP PEND 13 eRx PHCY NPI 1174935969 DoD CAMP PEND 52 ePhcy changed to CAMP PEND 52 eRx PHCY NPI 1114330982 DoD OCEANSIDE TOC ePhcy changed to OCEANSIDE TOC eRx PHCY

5/27/2015: (Rows on tab: Active 715; Inactive 371; ePhcy Using Parent 11; Spare 23; e-Pharmacy 163):

ADD 1 NEW MTF SITE:

SCHRIEVER REFILL PCTR PHCY NPI 1285012922 / NCPDP 0623961

4/30/2015: (Rows on tabs: Active 714; Inactive 371; Ephcy Using Parent 11; Spare 23; E-pharmacy 163):

ADD 1 NEW MTF SITE:

CAMP LEJEUNE NH 200 PHCY NPI 1427435585 / NCPDP 3464790

4/22/2015: (Rows on tabs: Active=713; Inactive=371; Ephcy Using Parent = 11; spare 23; e-pharmacy 163):

ADD 2 NEW MTF SITES:

L WOOD eRx MAIN PHCY NPI 1275920076 / NCPDP 2642456 L WOOD eRx PX PHCY NPI 1548657612 / NCPDP 2642468

* These 2 e-phcies will not be published as DoD e-phcies; site is using #'s to capture workload internally in CHCS. Approved by Hector/Henry.

Site removed from inactive list and noted on tab Old Site-Dead Code: See message to right.

MCCLELLAN MCCLELLAN PHCY 0537920 1588612329

Site on Working Active List, marked inactive but with visits 5/1/13-5/1/15. Marked inactive, but left on active for for ESI. E-Phcy flag and phone number removed.

DoD PAX RIVER ePhcy 2138508 1568877272

Sites on Working Active List, but have been deactivated in CHCS and at NCPDP. Marked inactive but retained since visits 5/1/13-5/1/15:

ATLANTIC CITY USCG PHCY 3194646

BITBURG PHCY 8110277

BROOKS PHCY 4510978

BUTZBACH PHCY 8110328

COLEMAN PHCY 8110114

NEW YORK ACTIVITIES 3329023

DELAWARE USCG PHCY 3989019

DETROIT USCG PHCY 2369595

GALVESTON USCG PHCY 4526008

HANAU PHCY 8110417

HEIDELBERG PHCY 8110392

HOUSTON USCG ELLIGTON FLD PHCY 4526010

KELLY OP PHCY 4511944

LACKLAND BMT OP PHCY 4511906

MANNHEIM PHCY 8110378

MCKINLEYVILLE USCG PHCY 0586199

EARLE MAIN PHCY 3143536

NORTH BEND USCG PHCY 3814781

PASCAGOULA BMC PHCY 2520826

PT ANGELES USCG PHCY 4929999

ST. PETERSBURG USCG PHCY 1016369

TRAVERSE CITY USCG PHCY 2364432

TUZLA PHCY 8110013

WARRENTON USCG PHCY 3814779

WUERZBURG PHCY 8110253

YUMA FLAS PHCY 0324335

04/15/15: Active=711; Inactive = 372, spare 24, e-pharmacy 164):

Add E-RX fax numbers for ESI/Emdeon. No change to Emdeon information. Deliver to ESI only.

Update information for NCPDP 3006334 on inactive tab to 23708 as for the rest of Portsmouth NH. Already discussed with S. Keane. Not redelivered.

4/06/15 : (Active=711; Inactive = 372, spare 24, e-pharmacy 164) DoD PAX RIVER ePhcy 2138508 restored to active, removed from spare. Error correction.

3/27/15 : (Active=710; Inactive = 372, spare 25, e-pharmacy 163) Correction to files. Notified Keane and Bucar by email.

Removed duplicate Aberdeen ePHCY.

3/25/15: (Active=711; Inactive = 372, spare 25)

Add variable for e-pharmacy. Total 164 sites.

Moved 13 from Active to spare. (Intended for epharmacy, but sites decided not to open ePhcy.

Add SAN DG HEM/ONC PHCY 5651802 1265846323. Converted from spare SAN DG CLAIREMONT.

Rename Jacksonvle Refill Phcy - NCPDP/NPI previously intended for ePhcy

2/26/15: (Active=723; Inactive = 372, spare 13):

Add DoD ABERDEEN ePhcy to Active.

Removed duplicate appearance of FT. GREELY GREELY PHCY 0227872 on Inactive tab

2/19/15 (Active=722; Inactive = 373, spare 13) :

Update to NPI for BAHRAIN ISA AB PHCY Addition of FT SAM CBPCC WH (WESTOVER HILLS) PHCY

2/18/15: (Active=721; Inactive = 373, spare 13)

NEW: CHARLESTON NH BEAUFORT BEAUFORT MCAS PHCY 4222725 1215036470

Removed from inactive tab, but now to be put in use as BEAUFORT MCAS PHCY on active tab.

Moved 13 from Active to Spare:

DoD FT LEWIS ePhcy 4936071 DoD BARKSDALE ePhcy 1937575 DoD EVERETT ePhcy 4936108 DoD CHARLESTON NH ePhcy 4232257 DoD PAX RIVER ePhcy 2138508 DoD SAN DG CLAIREMONT TOC ePhcy 5651802 DoD SAN DG MIRAMAR ePhcy 5651814 DoD SAN DG NAVEX (32ND ST) ePhcy 5651749 DoD SAN DG NORTH ISLAND ePhcy 5651864 DoD SAN DG NTC ePhcy 5651927 DoD SAN DG SANTEE ePhcy 5651876 DoD SAN DG TOC EL ePhcy 5651840 DoD SAN DG TOC RB ePhcy 5651826

Restored to Inactive

MEADE CIVILIAN RX PHCY 2125880

NSA OHESS PHCY 2125789

CROUGHTON PHCY 8110671

GREELY PHCY 0202375

MCCLELLAN PHCY 0537920

MCCLELLAN DGMC VA PHCY 0585147

TAEGU IDMT PHCY 8210421

Restored to Active and Renamed. (Previously ePhcy)

ALBANY REFILL PHCY 1165263

KINGS BAY REFILL PHCY 1165287

29 PALMS REFILL PHCY 5651460

KEY WEST REFILL PHCY 5720811

Three addtional tabs added for information:

E-Phcy Using Parent Codes - These sites use the same NCPDP/NPI information as their parents. E-pharmacy workload at these sites is indistinguishable from other workload at the parents. This tab is for informatino only.

Spare Codes - These NCPDP/NPI were turned on at NCPDP but were never set up for use by military pharmacies. Subject to location constraints, they may be usable elsewhere in the future.

Old Sites-Reused Codes: This code now appears on the ACTIVE tab in use by an entirely different site, different location. The LONDON pharmacy is closed and was previously on the INACTIVE list. However, Emdeon considers that a duplicate, so it has now been removed.

2/6/15 (Active=733; Inactive = 366):

Added BAHRAIN ISA AB PHCY 8110621 1811182959 to Active Restored DoD FT JACKSON COMMUNITY ePhcy 4232500 1669877064 (Accidentally omitted).

2/3/15:

Long Term Inactive moved to a separate tab WORKING LIST-INACTIVE (366) All others (Active, short term inactive, unlabelled) remain on WORKING LIST (731)

1/29/15 (Active=731; Inactive = 366): DELIVERED TO EMDEON AND LM

FT. SAM HOUSTON

City for DoD FT SAM ePhcy 5911931 changed from CAMP BULLIS to FT SAM HOUSTON

1/27/15:

Total pharmacies: 1,097

New Additions DoD PORTS VA SCOTT CENTER ePhcy 4845838 (Already added) DoD CARLISLE DUNHAM ePHCY 6001161 (DoD CARLISLE DUNHAM PHCY 6001161 Removed) DoD PORTS VA NORTHWEST NSG ePhcy 4845888 DoD FT HAMILTON ePhcy 5812195 DoD DUMFRIES ePhcy 4845977 DoD FAIRFAX ePhcy 4845991 DoD HURLBURT ePhcy 5724150 DoD TRIPLER WARRIOR OHANA PHCY 1241607

EGLIN SFG PHCY 5724225

EGLIN DUKE FC PHCY 5724530

1/26/15:

9-sites sent to Jo-El Onstad, UBO, for her review. Four of the listed sites are now inactive. We will not modify them:

MCCHORD SPECIAL PATIENT PHCY

WASH DC ANDREWS NAF PHCY 2125753

CAMP DAWSON PHCY (except to set SVC CMD to correspond to JOINT Svc)

WASH DC DTHC MCNAIR REFILL PHCY

For 3 sites, she endorsed our final Service and Service Command assignment.

We use Service Command = JTFNCA for JOINT sites where Jo-El and other systems (e.g., DMIS) use Service Command=NCR MD.

So her indicatin of NCR MD is not in conflict with JOINT. No change as long as Service /Service Command corrrespond.

FT CARSON REFILL PROCESSING CENTER

MCCHORD POE PHCY (MAIN)

DoD WALTER REED NEX ePhcy

She was unsure about 2 sites. We will not change them at this time. Rosemary investigated their particular circumstances.

WALTER REED SOLDIER'S HOME PHCY

Rosemary spoke to Mr Groover regarding the WALTER REED SOLDIER'S HOME PHCY. The Prescriptions are processed at the WRNMMC in MD using the NPI assigned to the WALTER REED SOLDIER'S HOME PHCY and transported to WALTER REED SOLDIER'S HOME PHCY by van. No active Pharmacy at the actual WALTER REED SOLDIER'S HOME. The LBN is correct Walter Reed National Military Medical Center. We are waiting for them to update their TAX ID Letter which still shows the LBN as National Navy Medical Center. If Rosemary changes LBN at NPPES prior to the TAX ID change, it might cause some confusion.

BARBERS PT PHCY 1204104

There is a physician entering prescriptions at Barbers Point. The scripts are processed through AHLTA with the Barbers Point NPI and sent elsewhere in the Honolulu vicinity for processing . Rosemary says there are no reversals. This has been referred to DHA in Virginia.

01/19/15:

See highlighted section to the right. Preston identified multiple NCPDP to single NPI as an error and provided the following corrected NPI values:

DoD Barksdale ePhcy NPI should be – 1538571086 DoD Beale ePHcy NPI should be – 1518366574 DoD Everett ePhcy NPI should be – 1407266281

PASS_MTF_CCL_Working 010815b.xlsx (SRogers, 01/05/15 - Clarification notes for 1/5/15 meeting w Hector, post meeting notes and adjustments)

PASS_MTF_CCL_Working 122314.xlsx (SRogers, 12/23/14)

See tab Working List:

1. Started with two spreadsheets:

PASS_MTF_CCL_template.xlsx for delivery to Emdeon/ESI MTF_Chain_Code_List_With_NPI_10292014 with DMIS 11062014 for delivery to DHCAPE (Sheyla Keane, LM, for Steve Toney and MDR/M2)

2. Preston reviewed PASS template.xlsx and added First Rx Dispensed Date and Last Rx Dispensed Date in additional columns to the right of the Effective Date and Expiration Date. Using the tab "Preston Dates", Sandy copied those dates to "Working List".

3. 12/12/14 Meeting and instructions from Hector. Investigate the following sites:

a. Blank effective and expiration dates = 133 sites

b. Of blank sites, 76 ePhcy, 57 non-ePhcy

c. Of the 57 non-ePhcy, 35 without NPI - INACTIVE. Move to another tab. (SR - temporarily label 'INACTIVE, No transactions, No NPI, Inactivated at NCPDP')

d. 22 remain. Rosemary Gonzalez checked with individual sites. 1 active; 21 INACTIVE. SR - temporarily labelled "INACTIVE, No transactions, With NPI, Confirmed in site conversation by R. Gonzalez, Inactivated at NCPDP Dec 2014

4. Per Preston email 12/22/14:

The attachment, "PharmacyClosing.xlsx", contains a listing of pharmacies that we have a completed Pharmacy Termination Notification form on. This is the form that Rose spoke about during our meeting on Friday. I opened each form (241 files) and copied the data into the attached file. I did a spot check to see if any of the listed pharmacies are in the "PASS_MTF_CCL_12182014" file that I sent last week; I found that they were listed in the "Raw" (Active pharmacy listing) and "Inactive" spreadsheet.

Sandy used the tab "168" from Preston's spreadsheet "PharmacyClosing.xlsx" to map Closing Effective date to column labelled "NCPDP Closed Date" , set status to INACTIVE, and added comment "Previously closed".

Per 12/23/14 email from HM. Remove the dates ESI entered. They were place holders. Active sites only get activation dates.

Expiration date will only be used for closed pharmacies.

SR. Sites with no transactions have no dates.

Per Preston's 1/6 email (Changes applied to 12/23/14 spreadsheet):

1) The file contains spreadsheet "168" which contains a listing of 175 terminated pharmacies and their NCPDP numbers; there are 4 duplicate NCPDP numbers.

2) The file does not contain "Phcy w-shared NPIs-Inactive" spreadsheet that was in the PharmacyClosing file that I previously sent out. That spreadsheet contained a listing of 66 terminated pharmacies and their NCPDP numbers.

3) There are 234 unique NCPDP number listed from the "168" and "Phcy w-shared NPIs-Inactive" spreadsheets.

4) ) There are 6 pharmacies in which we have two termination forms on file. I entered a comment for each of these pharmacies in column U on the "Working" spreadsheet.

Actions / Discussion per 1/5/14 Meeting with H. Morales.

1. Look in Column V STATUS at sites that have not yet been clearly identified as ACTIVE or INACTIVE and filter out sites that with a transaction sometime in 2014, there are still 225 sites, some whose last transaction was years ago and 40 whose Facility Type Code (from the DMIS Table) is INACTIVE. What do we do with these?

1/5/15: Temporarily tag sites one of three ways: ACTIVE, INACTIVE (LAST ACTIVITY WITHIN 5/1/13-5/1/15), INACTIVE -Long Term (LT) (Closed and no activity since 5/1/13.)

Ultimately, the main delivery tab will only include ACTIVE and INACTIVE (Short Term).

2. Confirm from Hector's emails whether or not zip code remains.

Per 11/23/14 email from Hector, ZIP remains for Sheyla Keane, LM, supporting Analytics Branch.

3. Confer with Hector to determine dates to put in column "exp date".

ACTIVE sites will have no dates.

We don't seem to have dates for all INACTIVE sites. What to do?

Also, there is some discrepancy between "Last Rx Dispensed Date" and "NCPDP Closed Date". Preference?

Resolution:

1/5/15:

ACTIVE sites will have no dates.

INACTIVE-LT sites will not be delivered. Dates a relative non-issure, except that ultimately, we'll keep Closed Date.

INACTIVE - Keep last transaction date.

4. Confirm with Hector whether INACTIVE sites are to be removed for both EMDEON/ESI and for Keane (Analytics Branch).

1/5/15:

OUTSTANDING ITEM.

5. Revert to Service/Fac pre-Joelle change but let Hector know if there will be new values.

SR reviewed data and found that SVC and related SVC CMD were different in the two original spreadsheets. (Original PASS chain code list (Preston's list) and the Analytics Branch list (Keane) . I took the following steps:

a. Reinstated Preston's values for Service.

b. Compared Preston's values to Keane's values and identiified discrepant sites. Choose a final value as follows:

c. Reinstated Preston's values for SVC CMD.

d. Compared Preston's values to Keane's values and identiified discrepant vlues. Choose a final value as follows:

Final change - Distinguish 4 status:

ACTIVE - Specifically determined to be active, e.g., E-Pharmacy or site R. Gonzalez called.

INACTIVE -LT - Last transaction prior to 5/1/13, OR no transactions ever and NCPDP deactivated OR ever or no transactions since 5/1/13 to INACTIVE -ST - Last transaction in the 5/1/13 - 5/1/15 period but NCPDP closed.

blank - No reason to believe site is inactive.

5. Preston inserted column s "V". Data was copied from the Pharmacy Termination Notification forms to column U and V. There are 6 pharmacies that have two termination notifications forms. A comment was entered in column U for each of these pharmacies.

6. With decisions above, create final WORKING .xlsx.

7. With final WORKING.xlsx, create two deliverable versions.

The first three rows on the tab Working List are indications of the variable names and columns that will remain when we generate our final two deliverables:

PASS_MTF_CCL_mmddyyyy for Emdeon/ESI, per Row 2, Yellow Highlighted columns MTF_Chain_Code_List_mmddyyyy for Sheyla Keane, LM, supporting Analytics Branch, per Row 1, Blue Highlighted Columns.

In final review of deliverables, ensure the following:

All VLOOKUP , calculations, or in-cell comments are removed .

All formatting within rows, e.g., color coding, bolds, etc. is removed INACTIVE sites are moved off the main tab according to result of #4 above.

Three output files:

CHC receives Active and Inactive tab. Columns with yellow headers. Any code used in the W/H should not be reused. There may be no duplicates.

DSC: Active and Inactive, columns with blue header.

ESI: Active tab only. Columns with green header.

MCCLELLAN PHCY:

Roger identified RXs that were processed in Retail and VA CHDR that had a corresponding Site MTF name of McClellan associated with the RXs.

Only MTF transactions should have a Site MTF name associated with their RXs. All other Service Categories, Retail, Mail Order, Theater and VA CHDR, RXs should show a blank space when a Site MTF column is included in the output along with the Service Category (Claim). When I ran a follow up report to find out more details of the RXs with a Site MTF name of McClellan in this same time period I found that the Site MTF name and even a Branch of Service of Air Force was being linked to these transactions. The pharmacy processing these RXs is the McClellan VA CBOC Pharmacy with an NPI number of 1588612329.

Emdeon uses both the Active and Inactive tabs to generate its master pharmacy list. Leaving this site on the Inactive tab causes the situation above. Only by removing the site from the list altogether can the Emdeon problem be solved.

This does not apply to NPI 1396842159, named MCCLELLAN DGMC VA PHARMCY, also showing a Air Force Branch of Service and the same chain code of 0BG. This pharmacy, when looked up on SelectRX shows the same pharmacy name with an address of 5342 Dudley BLVD, McClellan, CA 95652 and a chain code of 0BG.

Working List Active