{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Term Definitions","Workbook Instructions","Process Map","R&O Data Ref.","CM Data Ref.","Referral & Outreach","Case Management","Engagement Report","Success Stories","Personnel"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Term Definitions","index":0,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"Term Definitions "]
["Race/Ethnicity "]
["Indicates the race(s) the client identifies as.  Race Categories are based on the US Dept. of Health and Human Services implementation "]
["collection standards for race and ethnicity with the addition of 3 categories:  Cambodian, Laotian, and Middle Eastern.  "]
[]
["Gender"]
["Indicates an individuals self-identified gender. "]
[]
["Sexual Orientation "]
["Indicates voluntarily stated sexual orientation. "]
[]
["Source of Income/Support"]
["Identifies the individuals principal source of financial support.  "]
[]
["Direct Client Services"]
["Direct client services are intended to provide for clients' immediate needs. As referenced in the LEAD toolkit, flexible funds can be readily used "]
["by case managers to meet clients’ modest and variable needs. Meeting participants’ immediate needs allows case managers both to build trust "]
["and to increase efficacy of their interactions with participants. Expenditures may be as varied as buying a participant a sandwich, "]
["providing a package of diapers for a participant’s child, or covering the cost of a prerequisite TB test for someone eligible for emergency housing."]
[]
["Residence"]
["Indicates individuals primary residence over the last 30 days preceding date of collection.  "]
[]
["Contingency Management "]
["Type of behavior therapy in which individuals are 'reinforced', or rewarded for evidence of positive behavioral  change."]
[]
["Warm-Hand Off"]
["A transfer of care between two members of the health care team, where the handoff occurs in front of the patient explaining why the other "]
["team member can better address a specific issue with the patient emphasizing the other team member's competence.  "]
[]
["Encounter"]

{"sheet":"Workbook Instructions","index":1,"n_rows":53,"n_cols":8,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,"Referral and Outreach Instructions"]
["Use this spreadsheet to capture all referral and outreach services being provided"]
[]
["ProviderOne ID:  Input individual's ProviderOne ID number if applicable"]
["Client ID: This will be determined by the direct service provider, i.e. John Doe born 1989 = JODO89. "]
["First Name:  First name indicated on referral form"]
["Last Name: Last name indicated on referral form."]
["Alternate Name/AKA: If the individual goes by a street name  or prefers another name be used, use this column to indicate this name, i.e. Individual prefers to go by the name \"Bear\"."]
["DOB: Indicate individuals date of birth, i.e. 1/1/91."]
["Referral Date:  Enter date of referral, input numeric date, i.e. 1/1/22."]
["Outreach Date:  Enter date of outreach, input numeric date, i.e. 1/1/22."]
["Time of Referral:  Enter time of referral, please use 24 hour clock, i.e. 3:15 is 15:15."]
["Referral Response Time: Enter the number of minutes it took from time of referral until referral was responded to, i.e. 45 minutes."]
["Referral Source: Indicate where the referral came from.  Refer to full list of options in drop down box.  If not listed, please use \"Other\"."]
["Referral Reason: Indicate the reason for referral.  Refer to full list of options in drop down box.  If reason is not listed, please select \"Other\"."]
["Location of Referral/Outreach: Indicate address where outreach occurred, i.e. 234 Main St. 98504.  **If unable to identify address, identify the location and cross streets (if available)"]
["where outreach took place. i.e. Safeway on Grand and 15th, 98685 OR Seeley Lake Park, 98449."]
["Race: Indicate race. Select from drop down options.  If more than one race identified, select multiple drop-down options. "]
["Ethnicity: Indicate ethnicity, select from drop down options. If more than one ethnicity identified, select multiple drop-down options. "]
["Gender: Indicate which gender the individual identifies as.  If preferred gender is not listed, please indicate \"refused\"."]
["Sexual Orientation: Indicate sexual orientation. Select from drop down options.  If preferred sexual orientation is not listed, please select \"choosing not to disclose\"."]
["Source of Income/Support: If individual has an income source, please select from drop down options.  If none indicated, select \"none\"."]
["Housing Status: Indicate current housing status for the last 30 days proceeding date of collection. Select from drop down options."]
["Screening Outcome/Case Management Level: If any service is provided during encounter, select from drop down options. If multiple resources provided, list most significant or indicate \"Multiple\"."]
["Direct Client Services: Identify direct client services provided at outreach. If more than one service is provided, select multiple drop-down options. "]
["Notes: Use this space to enter any information relevant to the client."]
["Outreach Follow-up: Indicate whether outreach follow-up was conducted here."]
["Outreach Outcome: Indicate outreach outcome. Select from drop down options. If more than one outreach outcome is identified, select multiple drop-down options. "]
[]
[null,null,null,null,null,null,null,"Case Management Instructions "]
["Use this spreadsheet to capture all case management services provided."]
[]
["ProviderOne ID:  If applicable, input individual's ProviderOne ID number."]
["Client ID: This will be determined by the direct service provider. i.e. John Doe born 1989 = JODO89. "]
["First Name:  First name indicated on referral form"]
["Last Name: Last name indicated on referral form."]
["Alternate Name/AKA: If the individual goes by a street name  or prefers another name be used, use this column to indicate this name, i.e. Individual prefers to go by the name \"Bear\"."]
["DOB: Indicate individuals date of birth, i.e. 1/1/91."]
["Race: Indicate race. Select from drop down options.  If more than one race identified, select multiple drop-down options. "]
["Ethnicity: Indicate ethnicity, select from drop down options. If more than one ethnicity identified, select multiple drop-down options. "]
["Gender: Indicate which gender the individual identifies as.  If preferred gender is not listed, please indicate \"refused\"."]
["Sexual Orientation: Indicate sexual orientation. Select from drop down options.  If preferred sexual orientation is not listed, please select \"choosing not to disclose\"."]
["Date of Case Management Event: Enter date of case management. i.e. 1/1/22."]
["Case Management Phase/Engagement Level: Indicate case management phase and engagement level. Select from drop down options."]
["Contingency Management (Participation): Indicate \"Yes\" or \"No\" if individual is participating in Contingency Management. "]
["Outreach Follow-up: Indicate \"Yes\" or \"No\" if individual is participating in Outreach Follow-Up."]
["Engagement Time Spent: Indicate the amount of time it took to engage with client from referral start utilizing drop-down options."]
["Direct Client Services: Identify direct client services provided at outreach. If more than one service is provided, select multiple drop-down options. "]
["Referral to Services Made: Indicate referrals made. Select from drop down options. If more than one referral is made, select multiple drop-down options. "]
["Notes: Use this space to enter any information relevant to the client."]
["ROI Signed: Indicate \"Yes\" or \"No\" if ROI has been signed."]
["Consent Signed: Indicate \"Yes\" or \"No\" if consent form signed."]
["Individualized Service Plan Created/Updated: Indicate \"Yes\" or \"No\" if Individual Service Plan (plan created with individual's goals and ways to achieve those goals) is created or updated."]

{"sheet":"Process Map","index":2,"n_rows":43,"n_cols":6,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,5,0,16]]}
[null,null,null,null,null,"Recovery Navigator- Pre Arrest Diversion Process Map"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Knaphus-Soran, Emily.  Process Map. 16 November 2021. Microsoft Excel file"]

{"sheet":"R&O Data Ref.","index":3,"n_rows":22,"n_cols":24,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["ProviderOne ID","Client ID ","First Name ","Last Name ","Alternate Name/AKA","DOB (Indicate unknown if not collected)","Referral Date","Outreach Date","Time of Referral","Referral Response Time","Referral Source","Referral Reason ","Location of Referral/Outreach (i.e. Address)","Race","Ethnicity","Gender","Sexual Orientation (Sec. 1(3)m)","Source of Income/Support (Sec. 1(3)m)","Housing Status ","Screening Outcome/Case management level","Direct Client Services","Notes","Outreach Follow-up","Outreach Outcome"]
[null,null,null,null,null,null,null,null,null,"0-15","Business Community","Concern about safety of others",null,"American Indian/ Alaskan Native ","Cuban","Female","Heterosexual","Wages/Salary","Homeless without housing","Outreach Referral (declined services)","None",null,"Yes","Not Interested in Services"]
[null,null,null,null,null,null,null,null,null,"16-30","Casinos","Concern about self-harm",null,"Asian Indian","Hispanic - Specific Origin Unknown","Male","Gay/Lesbian/Queer/Homosexual","Public Assistance","Foster Home/ Foster Care","Outreach Status","Naloxone",null,"No","Consent Signed"]
[null,null,null,null,null,null,null,null,null,"31-45","Child Welfare","Unlawful Possession of Controlled Substance- ESB 5476",null,"Black or African American ","Mexican","Transgender","Bisexual","Retirement/Pension","Residential Care","Enrolled in Light Case Management","Shelter (e.g. Housing Voucher, Motel, Sleeping Bag)",null,null,"Exchanged Contact Information"]
[null,null,null,null,null,null,null,null,null,"46-60","Community Based Organization","Frequent contact with LE",null,"Cambodian","Not of Hispanic Origin","Intersex","Questioning","Disability","Crisis Residence","Enrolled in Intensive Case Management","Coffee",null,null,"ROI Signed- Enrolled"]
[null,null,null,null,null,null,null,null,null,"61-75","Emergency Department","In crisis",null,"Chinese","Other Specific Hispanic (e.g., Chilean, Salvadoran, Uruguayan)","Transgender Female","Choosing not to disclose","Other","Institutional Setting",null,"Hygiene Products",null,null,"Unsuccesful Contact Attempt (i.e. person absconded)"]
[null,null,null,null,null,null,null,null,null,"76-90","Faith-Based Organization","Interfering with business",null,"Filipino","Puerto Rican","Transgender Male",null,"None","Jail/Correctional Facility",null,"Family Support Services (e.g. Childcare, Diapers, food)",null,null,"Provided List of Resources"]
[null,null,null,null,null,null,null,null,null,"Greater than 90","Family Member","Solicitation",null,"Guamanian or Chamorro","Unknown","Unknown",null,"Unknown","Private Residence",null,"Bus Pass",null,null,"Called Crisis Services "]
[null,null,null,null,null,null,null,null,null,"Next-day follow up","Fire/EMS","Other",null,"Native Hawaiian","Refused","Refused",null,"Not Collected","Independent Living",null,"Medical Expenses",null,null,"Scheduled Follow-Up meeting"]
[null,null,null,null,null,null,null,null,null,"Two or more days","Harm Reduction Program (SSP)","General - MH",null,"Japanese","Not Collected",null,null,null,"Dependent Living",null,"Clothing",null,null,"Individual Arrested after Referral"]
[null,null,null,null,null,null,null,null,null,null,"HealthCare Referral","General - SUD",null,"White",null,null,null,null,"Private Residence- Youth",null,"Other",null,null,"Other"]
[null,null,null,null,null,null,null,null,null,null,"Homeless Encampment","Housing",null,"Korean",null,null,null,null,"Other Residential Status",null,"Multiple Resources Provided"]
[null,null,null,null,null,null,null,null,null,null,"Law Enforcement- Arrest Diversion","Criminal Infraction-Theft",null,"Laotian",null,null,null,null,"Homeless with Housing",null,"Transportation"]
[null,null,null,null,null,null,null,null,null,null,"Law Enforcement- Social Contact Referral","Criminal Infraction-Trespass",null,"Middle Eastern",null,null,null,null,"Unknown",null,"Appointment(s)"]
[null,null,null,null,null,null,null,null,null,null,"Motels","Homeless",null,"Other Asian",null,null,null,null,null,null,"Legal Advocacy/Legal Aid"]
[null,null,null,null,null,null,null,null,null,null,"Other",null,null,"Other Pacific Islander",null,null,null,null,null,null,"Food/Food Card"]
[null,null,null,null,null,null,null,null,null,null,"Outreach",null,null,"Other Race",null,null,null,null,null,null,"Gas Card"]
[null,null,null,null,null,null,null,null,null,null,"Self Referral",null,null,"Not provided",null,null,null,null,null,null,"Phone/Minutes"]
[null,null,null,null,null,null,null,null,null,null,"Social Contact",null,null,null,null,null,null,null,null,null,"Client Supportive Services"]
[null,null,null,null,null,null,null,null,null,null,"Housing ",null,null,null,null,null,null,null,null,null,"Recovery Goal Support"]
[null,null,null,null,null,null,null,null,null,null,"Criminal Legal System-Pre-Trial Services",null,null,null,null,null,null,null,null,null,"Peer Support"]
[null,null,null,null,null,null,null,null,null,null,"Criminal Legal System-Defense Attorney",null,null,null,null,null,null,null,null,null,"Gift Card(s)"]

{"sheet":"CM Data Ref.","index":4,"n_rows":22,"n_cols":21,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["ProviderOne ID ","Client ID ","First Name","Last Name","Alternate Name/AKA","DOB (Indicate unknown if not collected)","Race","Ethnicity","Gender","Sexual Orientation (Sec.1(3)m)","Date of Case Management Event","Case Management Phase/Engagement level","Contingency Management (Participation)","Outreach Follow-up","Engagement Time Spent","Direct Client Services","Referral to Services Made","Notes","ROI Signed","Consent Form Signed","Individualized Service Plan Created/Updated"]
[null,null,null,null,null,null,"American Indian/ Alaskan Native ","Cuban","Female","Heterosexual",null,"Light case management","Yes","Yes","0-15","None","Basic Needs e.g. hygiene, food, clothing",null,"Yes","Yes","Yes"]
[null,null,null,null,null,null,"Asian Indian","Hispanic - Specific Origin Unknown","Male","Gay/Lesbian/Queer/Homosexual",null,"Engaged/Intensive case management","No","No","16-30","Naloxone","Public Benefits e.g. DES, Social Security, Health Insurance",null,"No","No","No"]
[null,null,null,null,null,null,"Black or African American ","Mexican","Transgender","Bisexual",null,null,null,null,"31-45","Shelter (e.g. Housing Voucher, Motel, Sleeping Bag)","Physical healthcare Referral"]
[null,null,null,null,null,null,"Cambodian","Not of Hispanic Origin","Intersex","Questioning",null,null,null,null,"46-60","Coffee","Mental Health Referral"]
[null,null,null,null,null,null,"Chinese","Other Specific Hispanic (e.g., Chilean, Salvadoran, Uruguayan)","Transgender Female","Choosing not to disclose",null,null,null,null,"61-75","Hygiene Products","Substance Use Disorder Referral- Withdrawal Management"]
[null,null,null,null,null,null,"Filipino","Puerto Rican","Transgender Male",null,null,null,null,null,"76-90","Family Support Services (e.g. Childcare, Diapers, food)","Substance Use Disorder Referral- Assessment"]
[null,null,null,null,null,null,"Guamanian or Chamorro","Unknown","Unknown",null,null,null,null,null,"Greater than 90","Bus Pass","Substance Use Disorder Referral- Outpatient"]
[null,null,null,null,null,null,"Native Hawaiian","Refused","Refused",null,null,null,null,null,null,"Medical Expenses","Substance Use Disorder Referral- Inpatient"]
[null,null,null,null,null,null,"Japanese","Not Collected",null,null,null,null,null,null,null,"Clothing","Community Support Organizations (Recovery Café, other Non-Profit)"]
[null,null,null,null,null,null,"White",null,null,null,null,null,null,null,null,"Other","Self Help Support Group (AA/NA/Alanon/SMART recovery/etc"]
[null,null,null,null,null,null,"Korean",null,null,null,null,null,null,null,null,"Multiple Resources Provided","Faith-Based Organization"]
[null,null,null,null,null,null,"Laotian",null,null,null,null,null,null,null,null,"Transportation","Housing"]
[null,null,null,null,null,null,"Middle Eastern",null,null,null,null,null,null,null,null,"Appointment(s)","Multiple services provided"]
[null,null,null,null,null,null,"Other Asian",null,null,null,null,null,null,null,null,"Legal Advocacy/Legal Aid"]
[null,null,null,null,null,null,"Other Pacific Islander",null,null,null,null,null,null,null,null,"Food/Food Card"]
[null,null,null,null,null,null,"Other Race",null,null,null,null,null,null,null,null,"Gas Card"]
[null,null,null,null,null,null,"Not provided",null,null,null,null,null,null,null,null,"Phone/Minutes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Client Supportive Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Recovery Goal Support"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Peer Support"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gift Card(s)"]

{"sheet":"Referral & Outreach","index":5,"n_rows":22,"n_cols":24,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["ProviderOne ID","Client ID ","First Name ","Last Name ","Alternate Name/AKA","DOB (Indicate unknown if not collected)","Referral Date","Outreach Date","Time of Referral","Referral Response Time","Referral Source","Referral Reason ","Location of Referral/Outreach (i.e. Address)","Race","Ethnicity","Gender","Sexual Orientation (Sec. 1(3)m)","Source of Income/Support (Sec. 1(3)m)","Housing Status ","Screening Outcome/Case management level","Direct Client Services","Notes","Outreach Follow-up (Yes/No)","Outreach Outcome"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," "]

{"sheet":"Case Management","index":6,"n_rows":1,"n_cols":21,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["ProviderOne ID ","Client ID ","First Name","Last Name","Alternate Name/AKA","DOB (Indicate unknown if not collected)","Race","Ethnicity","Gender","Sexual Orientation (Sec. 1(3)m)","Date of Case Management Event","Case Management Phase/Engagement level","Contingency Management (Participation)","Outreach Follow-up","Engagement Time Spent","Direct Client Services","Referral to Services Made","Notes","ROI Signed","Consent Form Signed","Individualized Service Plan Created/Updated"]

{"sheet":"Engagement Report","index":7,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[[27,1,27,3],[19,3,19,4],[21,0,21,4],[0,0,0,4],[15,0,15,4],[16,0,17,4],[18,0,18,4],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[26,1,26,3],[34,1,34,3],[28,1,28,3],[29,1,29,3],[30,1,30,3],[31,1,31,3],[32,1,32,3],[33,1,33,3]]}
["How often did your PCG and your OWG meet this quarter? "]
[null,"Meeting Day/Time","Frequency","Counties Covered","List of Participants"]
["List PCG Meetings in Region"]
["PCG"]
[]
[]
[]
[]
[]
["OWG"]
[]
[]
[]
[]
[]
["Please discuss any barriers to the development and ongoing operations of the PCG and OWG.  "]
[]
[]
["Recovery Navigator Program(s) worked with existing outreach programs, community groups, businesses, families, fire/EMS, hospitals, homeless shelters, and faith-based organizations to coordinate care and encourage referrals.  "]
["New Engagements ","Total Engagements","New Partnerships","Total Partnerships"]
[]
["List of programs, community groups and businesses enrolled"]
["Business Name","Location",null,null,"Phone Number"]

{"sheet":"Success Stories","index":8,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9],[2,0,5,9],[6,0,6,9],[7,0,10,9]]}
["Please inlcude any success stories based off participant or partner participation in the recovery navigator program. Please be aware that these stories may be shared publicy so please be mindful when including names, PHI, and personal identifiers, redact or use broader terms like \"law enforcement officer\" or \"participant\".  "]
["Participant Success Story"]
[]
[]
[]
[]
["Partner/ Systemic Change Story"]

{"sheet":"Personnel","index":9,"n_rows":2,"n_cols":5,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Please list all region staff information below"]
["Name","Certifications","Position ","Location","Phone Number "]