{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Updates & Instructions","Contact Info & Service Area","Provider File Template","Lookup","Taxonomy Codes","County and State"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Updates & Instructions","index":0,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["MANAGED CARE SYSTEMS, P.O. Box 64975, St. Paul, MN 55164-0975, Telephone: 651-201-5166 "]
["Please add all your pharmacy network information to the provider file template. You may return the entire workbook or just the contact info and provider file template sheets."]
["The Contact Info & Service Area sheet requires macros to select the network's service area. Select service area in row 5, column B using the drop down list. You may select multiple counties per one cell. To delete a county, reselect it from the drop down list and it will be removed. If service area is entire state of Minnesota, select statewide."]
["We added taxonomy codes to further clarify our data in the provider file. The codes serve to connect pharmacy types to their respective measurement standard."]
["File format, Microsoft Excel Macro Enabled Workbook."]
["To enable macros. Go to file, scroll down to options. Then click on trust center settings, chose macros settings tab and enable all macros. "]
["Submit provider file(s) electronically through state support file sharing system."]
["Submit a unique provider file for each PBM pharmacy network."]
["Include the six distinct pharmacy types: Home Infusion (70H), Long Term Care (70L), Mail Order (70M), Retail (70R), Specialty (70S) and Tribal (70T). Use the pharmacy type and pharmacy type code in the provider file. If a given pharmacy is categorized as more than one type, report each type on distinct lines."]
["Validation used for the entire provider file. Please do not leave cell blanks. If information is unknown, use null."]
["If the validation button disappears, click the table with dots at the top of the ribbon. See image below."]

{"sheet":"Contact Info & Service Area","index":1,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["PBM Corporate Entity Name:"," ",null," "," "," "," "," "," "]
["Federal Employee ID# (FEIN):",null,null,null,null,null,null," "]
["Network Name:"]
["Network ID:"]
["Service Area:"]
["Primary Contact Name:"]
["Primary Contact Phone:"]
["Primary Contact Email:"]
["Secondary Contact Name:"]
["Secondary Contact Phone:"]
["Secondary Contact Email:"]

{"sheet":"Provider File Template","index":2,"n_rows":2,"n_cols":15,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
["NPI","Pharmacy License Number","Pharmacy Name","Pharmacy Types","Pharmacy Code","Taxonomy","Street Address 1","Street Address 2","City","County","State","Zip Code","Website Address","Independent or Chain (I/C)","Delivery Service Yes, No, Unknown(Y/N/U)"]

{"sheet":"Lookup","index":3,"n_rows":300,"n_cols":8,"rows_kept":300,"cut":false,"hidden":false,"merged":[]}
["Pharmacy Type ","Pharmacy Code","NUCC Taxonomy Code","County","State Code","Independent or Chain (I/C)","Delivery Service (Y/N/U)"]
["Retail ","70R","3336C0003X","Aitkin","AL","I","Y"]
["Home Infusion ","70H","3336H0001X","Anoka","AK","C","N"]
["ITU ","70T","332800000X","Becker","AZ",null,"U"]
["LTC ","70L","3336L0003X","Beltrami","AR"]
["Mail Order ","70M","3336M0002X","Benton","CA"]
["Specialty","70S","3336S0011X","Big Stone","CO"]
["Not Applicable","null","N/A","Blue Earth","CT"]
[null,null,null,"Brown","DE"]
[null,null,null,"Carlton","DC"]
[null,null,null,"Carver","FL"]
[null,null,null,"Cass","GA"]
[null,null,null,"Chippewa","HI"]
[null,null,null,"Chisago","ID"]
[null,null,null,"Clay","IL"]
[null,null,null,"Clearwater","IN"]
[null,null,null,"Cook","IA"]
[null,null,null,"Cottonwood","KS"]
[null,null,null,"Crow Wing","KY"]
[null,null,null,"Dakota","LA"]
[null,null,null,"Dodge","ME"]
[null,null,null,"Douglas","MD"]
[null,null,null,"Faribault","MA"]
[null,null,null,"Fillmore","MI"]
[null,null,null,"Freeborn","MN"]
[null,null,null,"Goodhue","MS"]
[null,null,null,"Grant","MO"]
[null,null,null,"Hennepin","MT"]
[null,null,null,"Houston","NE"]
[null,null,null,"Hubbard","NV"]
[null,null,null,"Isanti","NH"]
[null,null,null,"Itasca","NJ"]
[null,null,null,"Jackson","NM"]
[null,null,null,"Kanabec","NY"]
[null,null,null,"Kandiyohi","NC"]
[null,null,null,"Kittson","ND"]
[null,null,null,"Koochiching","OH"]
[null,null,null,"Lac Qui Parle","OK"]
[null,null,null,"Lake","OR"]
[null,null,null,"Lake of the Woods","PA"]
[null,null,null,"Le Sueur","RI"]
[null,null,null,"Lincoln","SC"]
[null,null,null,"Lyon","SD"]
[null,null,null,"McLeod","TN"]
[null,null,null,"Mahnomen","TX"]
[null,null,null,"Marshall","UT"]
[null,null,null,"Martin","VT"]
[null,null,null,"Meeker","VA"]
[null,null,null,"Mille Lacs","WA"]
[null,null,null,"Morrison","WV"]
[null,null,null,"Mower","WI"]
[null,null,null,"Murray","WY"]
[null,null,null,"Nicollet","CO"]
[null,null,null,"Nobles"]
[null,null,null,"Norman"]
[null,null,null,"Olmsted"]
[null,null,null,"Otter Tail"]
[null,null,null,"Pennington"]
[null,null,null,"Pine"]
[null,null,null,"Pipestone"]
[null,null,null,"Polk"]
[null,null,null,"Pope"]
[null,null,null,"Ramsey"]
[null,null,null,"Red Lake"]
[null,null,null,"Redwood"]
[null,null,null,"Renville"]
[null,null,null,"Rice"]
[null,null,null,"Rock"]
[null,null,null,"Roseau"]
[null,null,null,"Saint Louis"]
[null,null,null,"Scott"]
[null,null,null,"Sherburne"]
[null,null,null,"Sibley"]
[null,null,null,"Stearns"]
[null,null,null,"Steele"]
[null,null,null,"Stevens"]
[null,null,null,"Swift"]
[null,null,null,"Todd"]
[null,null,null,"Traverse"]
[null,null,null,"Wabasha"]
[null,null,null,"Wadena"]
[null,null,null,"Waseca"]
[null,null,null,"Washington"]
[null,null,null,"Watonwan"]
[null,null,null,"Wilkin"]
[null,null,null,"Winona"]
[null,null,null,"Wright"]
[null,null,null,"Yellow Medicine"]
[null,null,null,"Other"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"103G00000X"]
[null,null,null,null,null,null,null,"2086S0122X"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"N/A"]
[null,null,"null"]

{"sheet":"Taxonomy Codes","index":4,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,14],[9,0,9,6],[11,0,11,6],[12,7,12,13],[12,0,12,6],[10,0,10,6]]}
["Taxonomy Codes"]
[]
[]
[]
[]
[]
[]
[]
[]
["Taxonomy Codes"]
["Instructions:"]
["▪The taxonomy codes serve to connect pharmacy type to their respective measurement standard."]
["▪Pharmacy type description (column E) defines the specialty. "]
["▪Regulatory standard (column F) refers the  issuer to specific category so they may understand it's measurement standard."]
["1) Time and Distance (maps required)."]
["4) Plot specific pharmacy type on map. Do not plot population (maps required)."]
["Category","NUCC Taxonomy Code","Pharmacy Type","Pharmacy Code","Pharmacy Type Description","Regulatory Standard","NUCC Display Name (for reference only )"]
["Pharmacy","3336C0003X","Retail Pharmacy","70R  ","Prescriptions for local population, administer vaccines, and provider other professional services associated with pharmaceutical care.","Retail Pharmacy (Pharmacies)","Community/Retail Pharmacy"]
["Pharmacy","3336H0001X","Home Infusion Pharmacy","70H","Expertise in USP 797-coplaint sterile drug compounding for people with acute or chronic conditions.","Home Infusion Pharmacy (Pharmacies)","Home Infusion Therapy Pharmacy"]
["Pharmacy","332800000X","ITU Pharmacy","70T","Pharmacy operate by Indian health Services, an Indian tribe, tribal organization, or urban Indian organization.","ITU Pharmacy (Pharmacies)","Indian Health Service/Tribal/Urban Indian health (I/T/U) Pharmacy"]
["Pharmacy","3336L0003X","LTC Pharmacy","70L","Dispenses medicinal preparations delivered to patients residing within an intermediate or skilled nursing facilities.","LTC Pharmacy (Pharmacies)","Long Term Care Pharmacy"]
["Pharmacy","3336M0002X","Mail Order Pharmacy","70M","Pharmacists compound or dispense prescriptions or other medications using common carriers to deliver the medications to patients.","Mail Order Pharmacy (Pharmacies)","Mail Order Pharmacy"]
["Pharmacy","3336S0011X","Specialty Pharmacy","70S","A pharmacy that dispenses generally low volume and high cost medicinal preparations to patients who are undergoing intensive therapies for illnesses that are generally chronic, complex and potentially life threatening. ","Specialty Pharmacy (Pharmacies)","Specialty Pharmacy"]

{"sheet":"County and State","index":5,"n_rows":147,"n_cols":1,"rows_kept":147,"cut":false,"hidden":false,"merged":[]}
["Minnesota County Names"]
["Aitkin"]
["Anoka"]
["Becker"]
["Beltrami"]
["Benton"]
["Big Stone"]
["Blue Earth"]
["Brown"]
["Carlton"]
["Carver"]
["Cass"]
["Chippewa"]
["Chisago"]
["Clay"]
["Clearwater"]
["Cook"]
["Cottonwood"]
["Crow Wing"]
["Dakota"]
["Dodge"]
["Douglas"]
["Faribault"]
["Fillmore"]
["Freeborn"]
["Goodhue"]
["Grant"]
["Hennepin"]
["Houston"]
["Hubbard"]
["Isanti"]
["Itasca"]
["Jackson"]
["Kanabec"]
["Kandiyohi"]
["Kittson"]
["Koochiching"]
["Lac Qui Parle"]
["Lake"]
["Lake of the Woods"]
["Le Sueur"]
["Lincoln"]
["Lyon"]
["McLeod"]
["Mahnomen"]
["Marshall"]
["Martin"]
["Meeker"]
["Mille Lacs"]
["Morrison"]
["Mower"]
["Murray"]
["Nicollet"]
["Nobles"]
["Norman"]
["Olmsted"]
["Otter Tail"]
["Pennington"]
["Pine"]
["Pipestone"]
["Polk"]
["Pope"]
["Ramsey"]
["Red Lake"]
["Redwood"]
["Renville"]
["Rice"]
["Rock"]
["Roseau"]
["Saint Louis"]
["Scott"]
["Sherburne"]
["Sibley"]
["Stearns"]
["Steele"]
["Stevens"]
["Swift"]
["Todd"]
["Traverse"]
["Wabasha"]
["Wadena"]
["Waseca"]
["Washington"]
["Watonwan"]
["Wilkin"]
["Winona"]
["Wright"]
["Yellow Medicine"]
["Statewide*"]
["Other**"]
[]
["*For service area designation and not for listing individual pharmacies in the provider file."]
["**Used for counties outside of Minnesota."]
[]
[]
["State"]
["AL"]
["AK"]
["AZ"]
["AR"]
["CA"]
["CO"]
["CT"]
["DE"]
["FL"]
["GA"]
["HI"]
["ID"]
["IL"]
["IN"]
["IA"]
["KS"]
["KY"]
["LA"]
["ME"]
["MD"]
["MA"]
["MI"]
["MN"]
["MS"]
["MO"]
["MT"]
["NE"]
["NV"]
["NH"]
["NJ"]
["NM"]
["NY"]
["NC"]
["ND"]
["OH"]
["OK"]
["OR"]
["PA"]
["RI"]
["SC"]
["SD"]
["TN"]
["TX"]
["UT"]
["VT"]
["VA"]
["WA"]
["WV"]
["WI"]
["WY"]
["DC"]