{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["ECM Outreach","VALIDATE DATA","Outreach Initiation Fields","ECM Status codes and Date Combo","Sheet4","Sheet1"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":26,"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":"ECM Outreach","index":0,"n_rows":1,"n_cols":11,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Primary Payer (MCP) Identifier","MCP Name","ECM Provider Name","ECM Provider National Provider Identifier (NPI)","ECM Provider Tax ID Number (TIN)","Member Client Index Number","Provider Type","Date of Outreach Attempt","Outreach Attempt Method","Outreach Attempt Successful","Time Spent Performing Outreach"]

{"sheet":"VALIDATE DATA","index":1,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[[15,1,15,9],[16,1,16,9],[17,1,17,4],[18,1,18,11],[19,1,19,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Instructions:"]
[null,"1. This spreadsheet checks for data integrity and valid set of values expected in an ECM Outreach file"]
[null,"2. Please click the \"Validate ECM Outreach Response\" button to check for any error or invalid values"]
[null,"3. Cells with errors will be highlighted in red"]
[null,"4. After the cell values in red are updated, please re-check the data by clicking \"Validate ECM Outreach Response\" button"]
[null,"5. Steps 2-4 needs to be repeated until there are no cells highlighted in red"]

{"sheet":"Outreach Initiation Fields","index":2,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,4],[3,1,3,4],[5,0,5,4]]}
["Outreach Initiation Response File (From ECM Provider)"]
["Naming Convention:","ECM_Outreach_YYYYMMDD_FROM_123456789   (123456789 = ECM Provider TIN)"]
["Frequency:","Monthly: By the 5th of each month"]
["File Description:","This file will include all outreach attempts made on the prior month, to potential ECM Members.  (i.e. If submitting file on February 5th, the outreach attempts reported should be from the month of January.  Any dates reported that do not fall in the prior month will be ignored when Health Plan is processing file.)"]
[]
["Outreach Initiation Response File Data Dictionary"]
["Data Element","Required Inclusion on Inbound File \n(to Health Plan)","Field Size","Sample Data","Notes"]
["Primary Payer (MCP) Identifier","Yes",3,352,"Member's HCP Plan Code"]
["MCP Name","Yes",110,"HEALTH NET","HEALTH NET, CALIFORNIA HEALTH & WELLNES, CALVIVA HEALTH"]
["ECM Provider Name","Yes",110,"ABC ECM PROVIDER"]
["ECM Provider National Provider Identifier (NPI)","Yes",10,1234597890]
["ECM Provider Tax ID Number (TIN)","Yes",9,123456789]
["Member Client Index Number","Yes",9,123456789,"Member CIN ID"]
["Provider Type","Yes",1,1,"Valid Values: \n1 - Outreach performed by clinical staff; \n2 - Outreach performed by non-clinical staff"]
["Date of Outreach Attempt","Yes",10,"2021-01-01"]
["Outreach Attempt Method","Yes",30,"In-Person","Valid Values: In-Person, Telephonic/Electronic"]
["Outreach Attempt Successful","Yes",2,"Y","Valid Values = \"Y or N\"\nPer DHCS, a successful attempt is defined as an actual interaction with the individual.\n"]
["Time Spent Performing Outreach","Yes",2,15,"In minutes"]

{"sheet":"ECM Status codes and Date Combo","index":3,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
["Valid ECM Status","ECM Enrollment Start Date","ECM Enrollment End Date","Exclusion/Disenrollment Date","Exclusion/Disenrollment Reason Code","Exclusion/Disenrollment Reason"]
["1 - Pending Outreach","Must be blank","Must be blank","Must be blank","Must be blank","Must be blank"]
["2 - Currently in Outreach","Must be blank","Must be blank","Must be blank","Must be blank","Must be blank"]
["3 - Enrolled","Cannot be left blank","Must be blank","Must be blank","Must be blank","Must be blank"]
["4 - Declined","Cannot be left blank","Can be blank or populated","Cannot be left blank","Cannot be left blank","Can be blank or populated",null,null,null,null,"dog"]
["5 - Excluded","Cannot be left blank","Cannot be left blank","Cannot be left blank","Cannot be left blank","Can be blank or populated"]
[]
[]
[]
["Valid Exclusion/Disenrollment Reason Code Values for Column E, Rows 5 and 6"]
[null,"BLANK"]
[1,"1.  The Member has met all care plan goals"]
[2,"2. The Member is ready to transition to a lower level of care"]
[3,"3. The Member no longer wishes to receive ECM or is unresponsive or unwilling to engage"]
[4,"4. The ECM Provider has not been able to connect with the Member after multiple attempts"]
[5,"5. Other "]
[]
["Primary Payer (MCP) Identifier","Original order",null,"HEALTH NET"]
[68,1,null,"CALVIVA HEALTH"]
[150,2,null,"CHPIV"]
[315,3]
[316,4]
[317,5]
[352,6]
[353,7]
[354,8]
[360,9]
[361,10]
[380,11]
[381,12]
[382,13]
[383,14]
[384,15]
[533,16]

{"sheet":"Sheet4","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet1","index":5,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[]
["Outreach Attempt Method values:",null,null,null,"Provider Type Values:",null,null,"Outreach Attempt Successful Values:"]
["In-Person",null,null,null,1,null,null,"Y"]
["Telephonic/Electronic",null,null,null,2,null,null,"N"]