{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Instructions","Updates","Provider File Layout","Data Elements","Layout Example ","Provider Type ","Provider Specialty"," County Code","State Code"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":60,"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":"Instructions","index":0,"n_rows":20,"n_cols":1,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
["MANAGED CARE SYSTEMS"]
["P.O. Box 64975, St. Paul, MN 55164-0975"]
["Telephone: 651-201-5166"]
["Email: health.managedcare@state.mn.us"]
["Please review the following instructions prior to creating a Provider File:"]
["1) File format:  Microsoft Excel."]
["2) File naming convention:  <CarrierName_NetAdHIX_NetworkID_MMDDYYYY.xlsx>"]
["3) 3) Submit Provider Files electronically via CloudDrive: "]
["https://clouddrive.web.health.state.mn.us/"]
["4) Submit a unique Provider File for each network. Match the network name to the SERFF listing."]
["5)  Indicate whether the submitted network is On Exchange (QHP), Off Exchange, or both."]
["6)  Indicate whether the submitted network is for an individual, small, or large group plan, or any combination.  "]
["7)  When an individual provider or facility is associated with more than one provider type, please submit a separate row for each category."]
["8) When an individual provider or facility is associated with more than one provider specialty, please submit a separate row for each category"]
["9. Essential Community Providers (ECPs)–Identify ECP providers and their category code. For more information about ECPs, visit Essential Community Providers (https://www.health.state.mn.us/facilities/insurance/managedcare/ecp/index.html)"]
["10) List Pediatric Specialty Hospitals (PH), Organ Transplant Specialty Centers (TC), Psychiatric Residential Treatment Facilities (PR), Residential Treatment Faculties (RT), and Lactation Counselors (LA) in the provider file. "]
["11) Include all pediatric specialty providers and pediatric sub-specialty providers in the carrier network on the spreadsheet under the “Pediatric Specialty” code (“PE”)."]
["12) Enter latitude (column BA) and longitude (column BB) for all provider locations."]
["13) Enable macros. Go to File, scroll down to Options. Then click on Trust Center Settings, chose Macros Settings tab and enable all macros. "]

{"sheet":"Updates","index":1,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Summary of Updates to Provider File for Plan Year 2025"]
["1) Please add your network information to the Provider File Layout sheet. You may send the whole file or just the Provider File Layout sheet. Follow the naming convention for your provider file(s) (see instructions tab). "]
["2) Fill out the new columns for telehealth (AL, AM, AN) and services children and adolescents (AC). "]
["3) Include additional mental health categories (see Annual Submission Instructions). "]
["4) Add in the additional provider specialty and facility information (see Annual Submission Instructions)."]

{"sheet":"Provider File Layout","index":2,"n_rows":2,"n_cols":54,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Carrier Name","Health Plan Name","Network Name  \n","Network ID  \n","MN HIX Provider ID (Placeholder - for future use)","\"On-Exchange\" (QHP/QDP) Network","\"Off-Exchange\" Network","Individual Plan","Small Group Plan","Large Group Plan","Network County List","Network Adequacy Contact Name","Network Adequacy Contact Telephone ","Network Adequacy Contact Address","Network Adequacy Contact Email Address","Data Element Contact Name","Data Element Contact Telephone","Data Element Contact Email Address"," Individual Provider Last Name","Individual Provider First Name","Individual Provider Middle Initial or Name","Facility Name","Facility Type Code","NPI","Provider Type  ","Provider Type Code","Provider Specialty ","Provider Specialty Code","Services Children and Adolescents? (Y/N)","Is PCP or PCC?","Carrier PCP/PCC ID","Is ECP?","Chemical Dependency ECP? (If yes, enter \"1\")","Family Planning ECP? (If yes, enter \"1\")","Indian Health Care Service Provider ECP? (If yes, enter \"1\")","Mental Health ECP? (If yes, enter \"1\")","Primary Care ECP? (If yes, enter \"1\")","Offers Telehealth (Y/N)","Telehealth Type","Telehealth Appointment Type","Provider Street Address 1","Provider Street Address 2","Provider City","Provider County","Provider State","Provider Zip Code","Provider Website Address","Accepting New Patients?","Medical Group / Health System","Hospital Admitting Privileges","Provider Status","Record Type","Latitude","Longitude"]
["End of spreadsheet"]

{"sheet":"Data Elements","index":3,"n_rows":55,"n_cols":8,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["Element #","Category","Data Element","Description","Possible/Allowed Values","Field Type/Format\n","Additional Information or Instructions","Examples"]
[1,"Admin","Carrier Name","The name of the health insurance issuer.  ","Required","Alphanumeric(150)"]
[2,"Admin","Health Plan Name","The name of the Health Plan as entered in the SERFF \"Plan & Benefits\" template, \"Marketing Plan Name\" field. ","Required","Alphanumeric(55)","Use \";\" to delimit between multiple Health Plan names."]
[3,"Admin","Network Name  \n","The network name to which the Health Plan is associated, as entered on the SERFF \"Network\" template, \"Network Name\" field.","Required","Alphanumeric(200)"]
[4,"Admin","Network ID  \n","The network ID generated in the SERFF \"Network\" template, \"Network ID\" field.","Required","Alphanumeric(6)"]
[5,"Admin","MN HIX Provider ID (for future use)","ID assigned to carrier/network provider once received by MN HIX.  ID will be provided back to the carrier for future use when making updates to a specific provider.","Optional (Pass as null until instructed)","Alphanumeric(15)","PLACEHOLDER - FOR FUTURE USE","000HPMN00112345"]
[6,"Admin","\"On-Exchange\" (QHP) Network","Identifies whether the network will be offered as a QHP or QDP network on the Minnesota Health Insurance Exchange, i.e., Mnsure","Required","Alphanumeric (1)","Enter \"Y\" or \"N\".  A network may be offered on-exchange, off- exchange, or both.","Y"]
[7,"Admin","\"Off-Exchange\" Network","Identifies whether the network will be offered in the private market, regardless of whether it is offered  on the Minnesota Health Insurance Exchange, i.e., Mnsure.","Required","Alphanumeric (1)","Enter \"Y\" or \"N\".  A network may be offered on-exchange, off- exchange, or both.","N"]
[8,"Admin","Plan type: Individual Plan","Identifies whether network will be offered in an Individual Plan. Networks may be offered as Individual, Small Group, Large Group, or any combination of all three.","Required","Alphanumeric (1)","Enter \"Y\" if network will be marketed as an individual/family health plan. Otherwise \"N\"","Y"]
[9,"Admin","Plan type: Small Group Plan","Identifies whether network will be offered in a Small Group Plan.  Networks may be offered as Individual, Small Group, Large Group, or any combination of all three.","Required","Alphanumeric (1)","Enter \"Y\" if network will be marketed as a Small Group health plan. Otherwise \"N\"","Y"]
[10,"Admin","Plan type: Large Group Plan","Identifies whether network will be offered in a Large Group Plan.  Networks may be offered as Individual, Small Group, Large Group, or any combination of all three.","Required","Alphanumeric (1)","Enter \"Y\" if network will be marketed as a Large Group health plan. Otherwise \"N\"","N"]
[11,"Admin","Network County List","A list of all counties in the proposed service area.","Required","Alphanumeric(100)","Include the county code(s).\nUse ';' to delimit between multiple county codes.\nSee County Code list.","001;002;003"]
[12,"Admin","Network Adequacy Contact Name","Contact information for an individual who is able to answer questions related to network adequacy.","Required","Alphanumeric(150)","Include full name.\n","Jane Doe"]
[13,"Admin","Network Adequacy Contact Telephone ",null,"Required","Alphanumeric(20)","Include telephone number extension, if applicable.","111-222-3333 x442"]
[14,"Admin","Network Adequacy Contact Address","Street, City, State, Zip","Required","Alphanumeric(200)"]
[15,"Admin","Network Adequacy Contact Email Address",null,"Required","Alphanumeric(50)"]
[16,"Admin","Data Element Contact Name","Contact information for an individual who is able to answer technical questions about the provider data elements submitted.","Required","Alphanumeric(150)","Include full name.\n","John Doe"]
[17,"Admin","Data Element Contact Telephone",null,"Required","Alphanumeric(20)",null,"111-222-5555 x444"]
[18,"Admin","Data Element Contact Email Address",null,"Required","Alphanumeric(50)"]
[19,"Provider Record Detail","Individual Provider Last Name","The last name of the provider of health and medical or other services.","Required for individuals, null for facilities","Alphanumeric(50)"]
[20,"Provider Record Detail","Individual  Provider First Name","The first name of the provider of health and medical services.\n","Required for individuals, null for facilities","Alphanumeric(50)"]
[21,"Provider Record Detail","Individual Provider Middle Initial or Name","The middle name of the  provider of health and medical services.\n","Optional for individuals, null for facilities","Alphanumeric(50)","Prefer full middle name"]
[22,"Provider Record Detail","Facility Name","The marketing name of the facility.","Required for facility providers, null for individuals\n\n","Alphanumeric(150)","Hospital name, Clinic name, etc."]
[23,"Facility Record Type Code","Facility Type Code","The facility type(s) code(s) that represent the type of facility rendering health and medical services.","Required","Alphanumeric(10)","When a facility type has more than one service type, please submit a separate row for each Facility Type. \n\nReference the Facility Type list for mapping purposes."]
[24,"Provider Record Detail","NPI","National Provider Identifier -  The NPI is a unique identification number for covered health care providers.  Provide Type 1 NPI for individual providers and Type 2 NPI for facilities.  ","Required \nfor covered healthcare providers.\nNull for atypical providers.","Alphanumeric(10)","For covered healthcare providers who have an assigned NPI."]
[25,"Provider Record Detail","Provider Type ","The provider type(s) that represent the type of provider rendering health and medical services.","Required\n","Alphanumeric(400);  \nSee Provider Type list.","When an individual provider or facility has more than one Provider Type, please submit a separate row for each Provider Type.\n\nReference the Provider Type list for mapping purposes.\n","Physician"]
[26,"Provider Record Detail","Provider Type Code","The provider type(s) code(s) that represent the type of provider rendering health and medical services.","Required\n","Alphanumeric(30);  \nSee Provider Type list.","When an individual provider or facility has more than one Provider Type, please submit a separate row for each Provider Type.\n\nReference the Provider Type list for mapping purposes.\n","20I"]
[27,"Provider Record Detail","Provider Specialty  ","The specialty(ies) that represent the medical specialty(ies) of the provider.","Optional.  Please include when applicable for individuals providers or facilities.","Alphanumeric(400);  \nSee Specialty Code list.","When an individual provider or facility has more than one Provider Specialty, please submit a separate row for each Provider Specialty.\n\nReference the Provider Specialty list for mapping purposes.\n","Family Practice"]
[28,"Provider Record Detail","Provider Specialty Code","The code(s) that represents the medical specialty of the provider.","Optional.  Please include when applicable for individuals providers or facilities.","Alphanumeric(100);  \nSee Specialty Code list.","When an individual provider or facility has more than one Provider Specialty, please submit a separate row for each Provider Specialty.\n\nReference the Provider Specialty list for mapping purposes.\n",77]
[29,"Provider Record Detail","Services Children and Adolescents","Indicate if this provider offers service for Children and Adolescents","Required","'\"Y\" or \"N\"","Applies if the response to question is \"Y\" and the service is available for Children and Adolescents."]
[30,"Provider Record Detail","Is PCP or PCC?","Is this a Primary Care Provider (PCP) or a Primary Care Clinic (PCC)?","Required for Primary Care Clinics.  Optional for individual providers at this time."," 'Y' or 'N'","Individual providers or facilities designated as a PCP or PCC should tie to the Primary Care map submission.  For 10/1/13, only clinics and facilities will be available on the MN HIX provider search.  Individual providers will be added to the provider search at a later date."]
[31,"Provider Record Detail","Carrier PCP/PCC ID","Carrier assigned ID used to designate PCP or PCC.","Optional.  Please provide if the carrier requires an ID other than the provider's NPI for PCC selection.","Alphanumeric(20)","For carriers that require a PCC with initial enrollment, this ID may be provided to MN HIX to display within the provider directories."]
[32,"Provider Record Detail","Is ECP?","Indicate if this provider is an Essential Community Provider as designated by Minnesota Department of Health (MDH)","Required"," 'Y' or 'N'"]
[33,"Provider Record Detail","Chemical Dependency ECP","Indicate if this is a Chemical Dependency ECP by entering \"1\"","Required","\"1\" or Null","Applies if response to question \"Is ECP?\" is \"Y\" and ECP is a Chemical Dependency ECP."]
[34,"Provider Record Detail","Family Planning ECP","Indicate if this is a Family Planning ECP by entering \"1\"","Required","\"1\" or Null","Applies if response to question \"Is ECP?\" is \"Y\" and ECP is a Family Planning ECP."]
[35,"Provider Record Detail","Indian Health Care Services Provider (ECP) ","Indicate if this is an Indian Health Care Services Provider ECP by entering \"1\"","Required","\"1\" or Null","Applies if response to question \"Is ECP?\" is \"Y\" and ECP is an Indian Health Care Services Provider ECP."]
[36,"Provider Record Detail","Mental Health ECP","Indicate if this is a Mental Health ECP by entering \"1\"","Required","\"1\" or Null","Applies if response to question \"Is ECP?\" is \"Y\" and ECP is a Mental Health ECP."]
[37,"Provider Record Detail","Primary Care ECP","Indicate if this is a Primary Care ECP by entering \"1\"","Required","\"1\" or Null","Applies if response to question \"Is ECP?\" is \"Y\" and ECP is a Primary Care ECP."]
[38,"Provider Record Detail","Offers Telehealth","Indicate if this provider offers telehealth for enrollees","Required","'\"Y\" or \"N\"","Applies if the response to question is \"Y\" and telehealth is available"]
[39,"Provider Record Detail","Telehealth type","Indicate if this provider uses one or all telehealth type","Required","'\"Audio\"', \"Visual\", \"Both\", or \"Unknown\"","Indicate type of telehealth service available"]
[40,"Provider Record Detail","Telehealth Appointment Type","Indicate if this provider uses telehealth for initial consult, follow up, both, or none","Required","\"Initial\", \"Follow-up\", \"Both\", or \"Unknown\"","Indicate telehealth's use"]
[41,"Provider Record Detail","Provider Street Address 1","Practice location - The rendering provider's physical practice location where services are provided.","Required","Alphanumeric(80)","Included all street address information in Address Line 1 if possible.","123 Hill Street"]
[42,"Provider Record Detail","Provider Street Address 2",null,"Optional","Alphanumeric(80)","Use Address Line 2 for suite numbers or P.O. Box information if needed","Suite 100"]
[43,"Provider Record Detail","Provider City",null,"Required","Alphanumeric(30)",null,"Hill"]
[44,"Provider Record Detail","Provider County",null,"Required","Alphanumeric(3);  \nSee County Code list",null,"001"]
[45,"Provider Record Detail","Provider State",null,"Required","Alphanumeric(2);\nSee State Code list",null,"MN"]
[46,"Provider Record Detail","Provider Zip Code",null,"Required","Alphanumeric(5)",null,55401]
[47,"Provider Record Detail","Provider Website address","The website address (URL) for the provider for display on the Health Insurance Exchange.","Optional","Alphanumeric(50)"]
[48,"Provider Record Detail","Accepting New Patients?","Indicate if the provider is accepting new patients at the location where services are delivered.  For Clinics, Yes or No required.  For individuals, Y, N, or U.","Required.  For clinics and facilities, 'Y' for Yes, 'N' for No.  For individual providers, 'Y' for Yes, 'N' for No, and 'U' for Unknown.\n\n\n"," 'Y' or 'N' or 'U'"]
[49,"Provider Record Detail","Medical Group / Health System","The marketing name of the Medical Group/Health System of which the clinic or hospital is a part of.","Required for provider type = Physician Clinic, Hospital Facility","Alphanumeric(150)","Additional provider types may be added in the future.","Example:  Fairview\nExample:  Allina"]
[50,"Provider Record Detail","Hospital Admitting Privileges","The main NPI of the hospital(s) where the individual healthcare provider has admitting privileges.","Required for individual providers where hospital admitting privileges apply, null for any other provider types.\n","Alphanumeric(200)","Use ';' to delimit up to 20 Hospitals.\n\nProvide the NPI at the facility level, not the department or sub-specialty area within the hospital. ","3344556677;4142434445; 9879879870"]
[51,"Provider Record Detail","Provider Status","Is the provider active?","Required"," 'A' = Active\n 'I'' = Inactive","A = Indicates provider/facility is active.\nI = Indicates provider/facility is no longer active (i.e. retired, deceased, changed practice type)"]
[52,"Admin","Record Type","Indicate if this is a new provider record or a change to an existing provider record.","Required"," 'N' = New Record\n 'C' = Change Record\n 'NC' = No Change to Record","N = Indicates this is the first time the record is being submitted.\nC = Indicates something in the record has been changed since the previous submission.\nNC = No change has been made to the record."]
[53,"Provider Record Detail","Latitude","Indicate latitude of provider location.","Required","Alphanumeric(10)",null,45.006630000000001]
[54,"Provider Record Detail","Longitude","Indicate longitude of provider location.","Required","Alphanumeric(10)",null,-93.654579999999996]

{"sheet":"Layout Example ","index":4,"n_rows":12,"n_cols":54,"rows_kept":12,"cut":false,"hidden":false,"merged":[[9,21,9,27],[9,0,9,14],[5,0,5,14],[1,21,1,26],[5,21,5,27]]}
["Carrier Name","Health Plan Name","Network Name  \n","Network ID  \n","MN HIX Provider ID (Placeholder - for future use)","\"On-Exchange\" (QHP/QDP) Network","\"Off-Exchange\" Network","Individual Plan","Small Group Plan","Large Group Plan","Network County List","Network Adequacy Contact Name","Network Adequacy Contact Telephone ","Network Adequacy Contact Address","Network Adequacy Contact Email Address","Data Element Contact Name","Data Element Contact Telephone","Data Element Contact Email Address"," Individual Provider Last Name","Individual Provider First Name","Individual Provider Middle Initial or Name","Facility Name","Facility Type Code","NPI","Provider Type  ","Provider Type Code","Provider Specialty  ","Provider Specialty Code","Services Children and Adolescents (Y/N)","Is PCP or PCC?","Carrier PCP/PCC ID","Is ECP?","Chemical Dependency ECP? (If yes, enter \"1\")","Family Planning ECP? (If yes, enter \"1\")","Indian Health Care Service Provider ECP? (If yes, enter \"1\")","Mental Health ECP? (If yes, enter \"1\")","Primary Care ECP? (If yes, enter \"1\")","Offers Telehealth (Y/N)","Telehealth Type","Telehealth Type","Provider Street Address 1","Provider Street Address 2","Provider City","Provider County","Provider State","Provider Zip Code","Provider Website Address","Accepting New Patients?","Medical Group / Health System","Hospital Admitting Privileges","Provider Status","Record Type","Latitude","Longitude"]
["Example 1:  Facility Provider records for a facility with multiple specialties"]
["ACME Health Insurance Company of America","Orange 1000","Arrow",12345,null,"N","Y","Y","Y","N","001;002;003","Jane Doe",1234449999,"1 Smith Rd, Oakdale, MN 55334","joe@carrier.com","Jim Smith",2223334444,"karen@carrier.com","null","null","null","Fairview Clinic",null,1234567890,"Physician Clinic","20F","Family Practice",77,"Y","Y","000000123456789","Y",null,1,null,null,1,"Y",null,null,"222 Oak St","Suite 120","Maple","002","MN",55333,"http://www.xyzclinic.com","Y","Fairview",null,"A","N",45.006630000000001,-93.654579999999996]
["ACME Health Insurance Company of America","Orange 1000","Arrow",12345,null,"N","Y","Y","Y","N","001;002;003","Jane Doe",1234449999,"1 Smith Rd, Oakdale, MN 55334","joe@carrier.com","Jim Smith",2223334444,"karen@carrier.com","null","null","null","Fairview Clinic",null,1234567890,"Dentist","20F","Endocrinology",42,"N","Y","000000123456789","N",null,null,null,null,null,"N",null,null,"222 Oak St","Suite 120","Maple","002","MN",55333,"http://www.xyzclinic.com","Y","Fairview",null,"A","N",45.006630000000001,-93.654579999999996]
["ACME Health Insurance Company of America","Orange 1000","Arrow",12345,null,"N","Y","Y","Y","N","001;002;003","Jane Doe",1234449999,"1 Smith Rd, Oakdale, MN 55334","joe@carrier.com","Jim Smith",2223334444,"karen@carrier.com","null","null","null","Fairview Clinic",null,1234567890,"Physician Clinic","20F","Gerontology",43,null,"Y","000000123456789","Y",null,null,null,null,1,"Y",null,null,"222 Oak St","Suite 120","Maple","002","MN",55333,"http://www.xyzclinic.com","Y","Fairview",null,"A","N",45.006630000000001,-93.654579999999996]
["Example 2:  Individual Provider record where provider practices at multiple locations"]
["ACME Health Insurance Company of America","Orange 1000","Arrow",12345,null,"N","Y","Y","Y","N","001;002;003","Jane Doe",1234449999,"1 Smith Rd, Oakdale, MN 55334","joe@carrier.com","Jim Smith",2223334444,"karen@carrier.com","Doe","John","P","null",null,9876543210,"Physician","20I","Family Practice",77,null,"Y","000000123456780","N",null,null,null,null,null,"Y",null,null,"222 Oak St","Suite 120","Maple","002\n","MN",55412,"http://www.xyzclinic.com","Y","Allina","2345678901;4412355888","A","N",45.006630000000001,-93.654579999999996]
["ACME Health Insurance Company of America","Orange 1000","Arrow",12345,null,"N","Y","Y","Y","N","001;002;003","Jane Doe",1234449999,"1 Smith Rd, Oakdale, MN 55334","joe@carrier.com","Jim Smith",2223334444,"karen@carrier.com","Doe","John","P","null",null,9876543210,"Physician","20I","Family Practice",77,null,"Y","000000123456780","N",null,null,null,null,null,"Y",null,null,"788 Widget Street",null,"Maple Grove","027","MN",55369,"http://www.xyzclinic.com","N","Allina","2345678901;4412355888","A","N",45.098239999999997,-93.441580000000002]
["ACME Health Insurance Company of America","Orange 1000","Arrow",12345,null,"N","Y","Y","Y","N","001;002;003","Jane Doe",1234449999,"1 Smith Rd, Oakdale, MN 55334","joe@carrier.com","Jim Smith",2223334444,"karen@carrier.com","Doe","John","P","null",null,9876543210,"Physician","20I","Allergy",11,null,"Y","000000123456780","N",null,null,null,null,null,"Y",null,null,"55 Main Street",null,"Brooklyn Park","027","MN",55122,"http://www.xyzclinic.com","U","Allina","2345678901;4412355888","A","N",45.664819999999999,-93.906859999999995]
["Example 3:  Individual Provider record, practices at a single location"]
["ACME Health Insurance Company of America","Orange 1000","Arrow",12345,null,"N","Y","Y","Y","N","001;002;003","Jane Doe",1234449999,"1 Smith Rd, Oakdale, MN 55334","joe@carrier.com","Jim Smith",2223334444,"karen@carrier.com","Jones","David","J","null",null,7788224433,"Physician","20I","General Surgery",51,null,"N",null,"N",null,null,null,null,null,"N",null,null,"77 Daily Street",null,"Brooklyn Park","027","MN",55123,"http://www.xyzclinic.com","N","Fairview","2345678901;4412355888","A","N",45.110689999999998,-93.39331]
["End of spreadsheet"]

{"sheet":"Provider Type ","index":5,"n_rows":65,"n_cols":2,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
["Individual Provider Type","Provider Type Code"]
["ACUPUNCTURIST","AP"]
["ALLIED DENTAL PROFESSIONALS (includes DENTAL THERAPIST, ADVANCED DENTAL THERAPIST, DENTAL HYGIENIST)","31"]
["AUDIOLOGIST, INDEPENDENT","43"]
["CERTIFIED NURSE MIDWIFE","66"]
["CERTIFIED NURSE SPECIALIST","68"]
["CERTIFIED PROFESSIONAL MIDWIFE","C1"]
["CERTIFIED REGISTERED NURSE ANESTHETIST","67"]
["CHIROPRACTOR (individual)","37"]
["DENTIST (individual)","30I"]
["LICENSED CLINICAL SOCIAL WORKER (LCSW)","102"]
["LICENSED INDEPENDENT CLINICAL SOCIAL WORKER (LICSW)","14"]
["LICENSED INDEPENDENT SOCIAL WORKER (LISW)","102"]
["LICENSED MARRIAGE AND FAMILY THERAPIST (LMFT)","25"]
["LICENSED MARRIAGE AND FAMILY THERAPIST ASSOCIATE (LMFTA)","105"]
["LICENSED PROFESSIONAL CLINICAL COUNSELOR (LPCC)","63"]
["LICENSED PROFESSIONAL COUNSELOR (LPC)","103"]
["LICENSED PSYCHOLOGIST (LP)","42"]
["MENTAL HEALTH CLINICAL NURSE SPECIALIST ","108"]
["NURSE PRACTITIONER (individual)","65"]
["OTHER LICENSED MENTAL HEALTH PROVIDERS ","M1"]
["OCCUPATIONAL THERAPIST","29"]
["OPTOMETRIST","35"]
["PHYSICAL THERAPIST","39"]
["PHYSICIAN (individual)","20I"]
["PHYSICIAN’S ASSISTANT","69"]
["PODIATRIST","36"]
["SPEECH-LANGUAGE PATHOLOGIST","40"]
["SUBSTANCE USE DISORDER - INPATIENT","CD1I"]
["SUBSTANCE USE DISORDER - OUTPATIENT","CD2I"]
[]
["Facility Type","Facility Type Code"]
["ACUTE INPATIENT HOSPITALS","040"]
["AMBULATORY SURGICAL CENTER",22]
["BIRTHING CENTER","B1"]
["CARDIAC CATHETERIZATION SERVICES","042"]
["CARDIAC SURGERY PROGRAM","041"]
["COMMUNITY HEALTH CLINIC","58"]
["COMMUNITY MENTAL HEALTH CENTER","10"]
["CRITICAL CARE SERVICES - INTENSIVE CARE UNITS (ICU)","043"]
["DENTAL GROUP (aka DENTAL CLINIC)"," 30F"]
["DIAGNOSTIC RADIOLOGY","047"]
["DURABLE MEDICAL EQUIPMENT SUPPLIER","76"]
["FAMILY PLANNING AGENCY",54]
["FEDERALLY QUALIFIED HEALTH CENTER",52]
["HOME HEALTH/HOME HEALTH CARE AGENCY",60]
["HOSPITAL FACILITY","01"]
["INDIAN HEALTH SERVICE FACILITY",51]
["MAMMOGRAPHY","048"]
["OUTPATIENT INFUSION/CHEMOTHERAPY","057"]
["PEDIATRIC DENTAL","P201"]
["PEDIATRIC SPECIALTY HOSPITAL","PH"]
["PERSONAL CARE ORGANIZATION",38]
["PHARMACY",70]
["PHYSICIAN CLINIC","20F"]
["PSYCHIATRIC RESIDENTIAL TREATMENT FACILITY","PR"]
["PUBLIC HEALTH CLINIC",57]
["RESIDENTIAL TREATMENT FACILITY","RT"]
["RURAL HEALTH CLINIC",53]
["SKILLED NURSING FACILITIES","00"]
["SUBSTANCE USE DISORDER - INPATIENT","CD1F"]
["SUBSTANCE USE DISORDER - OUTPATIENT","CD2F"]
["SURGICAL SERVICES (OUTPATIENT OR ASC)","045"]
["TRANSPLANT SURGERY CENTER","TC"]
["URGENT CARE","080"]

{"sheet":"Provider Specialty","index":6,"n_rows":64,"n_cols":3,"rows_kept":64,"cut":false,"hidden":false,"merged":[[62,0,62,2]]}
["Category","Specialty","Specialty Code"]
["CHIROPRACTOR","Acupuncture","AP"]
["DENTISTS","Dental – General Practitioner",62]
[null,"Oral Surgery",61]
[null,"Orthodontics",63]
[null,"Periodontics",65]
[null,"Pediatrics",16]
[null,"Prosthodontists ",73]
["NURSE PRACTITIONERS","Family Nurse Practitioner",35]
[null,"Mental Health Nurse Practitioner and Mental Health Clinical Nurse Specialist",82]
[null,"Neonatal Nurse Practitioner",94]
[null,"OB/GYN Nurse Practitioner",80]
[null,"Pediatric Nurse Practitioner",34]
[null,"Women’s Health Nurse Practitioner",96]
["PSYCHOLOGIST","Neuropsychology",81]
["PHYSICIANS","Acupuncture","AP"]
[null,"Allergy",11]
[null,"Anesthesiology",41]
[null,"Cardiovascular Disease",12]
[null,"Cardiovascular Surgery",91]
[null,"Child Psychiatry",21]
[null,"Colon and Rectal Surgery",50]
[null,"Dermatology",13]
[null,"Diabetes","06"]
[null,"Emergency Medicine ","037"]
[null,"Endocrinology",42]
[null,"Family Practice",77]
[null,"Gastroenterology",14]
[null,"General Practice","01"]
[null,"General Surgery",51]
[null,"Genetics","08"]
[null,"Gerontology","43"]
[null,"Gynecology",47]
[null,"Hematology","HT"]
[null,"Immunology",44]
[null,"Infectious Disease",72]
[null,"Internal Medicine",15]
[null,"Lactation Counselor","LA"]
[null,"Nephrology",92]
[null,"Neurological Surgery",52]
[null,"Neurology",22]
[null,"Nuclear Medicine",76]
[null,"Obstetrics",46]
[null,"Obstetrics and Gynecology",53]
[null,"Oncology Medical/Surgical","021"]
[null,"Oncology Radiation",60]
[null,"Ophthalmology",54]
[null,"Orthopedic Surgery",55]
[null,"Otolaryngology",56]
[null,"Pediatrics*",16]
[null,"Peripheral Vascular Diseases or Surgery",74]
[null,"Physical Medicine and Rehabilitation",17]
[null,"Plastic Surgery and Reconstructive Surgery",57]
[null,"Preventive Medicine",18]
[null,"Psychiatry",23]
[null,"Pulmonary Disease",19]
[null,"Radiology",32]
[null,"Radiation Therapy",76]
[null,"Reconstructive Surgery",24]
[null,"Rheumatology ",90]
[null,"Thoracic Surgery",58]
[null,"Urology",59]
["*Pediatric Specialty should be denoted \"PE\" per DHS coding structure."]
["End of spreadsheet"]

{"sheet":" County Code","index":7,"n_rows":91,"n_cols":2,"rows_kept":91,"cut":false,"hidden":false,"merged":[]}
["County Code","County"]
["001","Aitkin"]
["002","Anoka"]
["003","Becker"]
["004","Beltrami"]
["005","Benton"]
["006","Big Stone"]
["007","Blue Earth"]
["008","Brown"]
["009","Carlton"]
["010","Carver"]
["011","Cass"]
["012","Chippewa"]
["013","Chisago"]
["014","Clay"]
["015","Clearwater"]
["016","Cook"]
["017","Cottonwood"]
["018","Crow Wing"]
["019","Dakota"]
["020","Dodge"]
["021","Douglas"]
["022","Faribault"]
["023","Fillmore"]
["024","Freeborn"]
["025","Goodhue"]
["026","Grant"]
["027","Hennepin"]
["028","Houston"]
["029","Hubbard"]
["030","Isanti"]
["031","Itasca"]
["032","Jackson"]
["033","Kanabec"]
["034","Kandiyohi"]
["035","Kittson"]
["036","Koochiching"]
["037","Lac Qui Parle"]
["038","Lake"]
["039","Lake of the Woods"]
["040","Le Sueur"]
["041","Lincoln"]
["042","Lyon"]
["043","McLeod"]
["044","Mahnomen"]
["045","Marshall"]
["046","Martin"]
["047","Meeker"]
["048","Mille Lacs"]
["049","Morrison"]
["050","Mower"]
["051","Murray"]
["052","Nicollet"]
["053","Nobles"]
["054","Norman"]
["055","Olmsted"]
["056","Otter Tail"]
["057","Pennington"]
["058","Pine"]
["059","Pipestone"]
["060","Polk"]
["061","Pope"]
["062","Ramsey"]
["063","Red Lake"]
["064","Redwood"]
["065","Renville"]
["066","Rice"]
["067","Rock"]
["068","Roseau"]
["069","St. Louis"]
["070","Scott"]
["071","Sherburne"]
["072","Sibley"]
["073","Stearns"]
["074","Steele"]
["075","Stevens"]
["076","Swift"]
["077","Todd"]
["078","Traverse"]
["079","Wabasha"]
["080","Wadena"]
["081","Waseca"]
["082","Washington"]
["083","Watonwan"]
["084","Wilkin"]
["085","Winona"]
["086","Wright"]
["087","Yellow Medicine"]
["088","Other*"]
["*088 - Other - To be used for those providers located in IA, ND, SD, WI "]
["End of sheet"]

{"sheet":"State Code","index":8,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["State Code","State"]
["IA","Iowa"]
["MN","Minnesota"]
["ND","North Dakota"]
["SD","South Dakota"]
["WI","Wisconsin"]
["End of sheet"]