{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Instructions & Guide lines","Data Sheet"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"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 & Guide lines","index":0,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2]]}
["To begin, select the Enable Content button that appears at the top of this workbook."]
["                                                                                                                                                                                                                                                                                                                                                                            \nPlease follow the instruction guidelines below while entering missed and late shift visit data into the Data Sheet tab of this workbook:\n      1.    All data should be manually typed or pasted into the Data Sheet tab of this workbook starting at row 9.\n                    a.   Important note: To paste data into the workbook, only paste AS VALUE (or select CTRL C to copy and CTRL V to paste from your keyboard). Data that is not pasted AS VALUE will corrupt the workbook. \n      2.    Continuously enter missed and late shift visit data into the Data Sheet tab from rows 9, 10, 11, etc. \n                    a.   Important note: Plan type (in column C9) should be left blank by the provider. Plan type will be entered by ACDE personnel. \n      3.    After data entry is complete, begin the data validation process by selecting the Data Validation button located at the top of column W of the Data Sheet tab.\n                    a.   Important note: If the data validation process finds a data entry error the user will receive a detailed error message in column Y of the Data Sheet tab. Please correct the error accordingly. (If you do not receive an error skip to step 4) \n                           i.      After correcting the error detailed in column Y, reselect the Data Validation button located at the top of column W to restart the validation process.\n      4.    Once data validation is complete, a validation success message will appear on the screen.\n      5.    Submit only completed and validated missed and late shift visit data via email to ACDEHHA@amerihealthcaritasde.com  \n"]
["Field","Instructions","Guidelines"]
["Month","Enter the month being reported.  ","This is a mandatory field. Record in month number. (E.g.: January is 1; June is 6)."]
["Year","Enter the year being reported.","This is a mandatory field. "]
["Plan Type","Providers should leave this field blank.","Providers should leave this field blank. ACDE personnel will look for plan type and record it."]
["Last Name","Enter the member's last name.","This is a mandatory field."]
["First Name","Enter the member's first name.","This is a mandatory field."]
["Member ID","Enter the member's ACDE Member ID number. Do not enter the member's Medicaid ID number.","This is mandatory field. The ACDE Member ID number should be 08 to 10 numeric characters. (E.g.: Do not enter as 2XXX89679-X1). "]
["County Name","Enter Kent, New Castle or Sussex.","This is a mandatory field. Only one county should be selected. "]
["Agency","Enter your company's name.","This is a mandatory field. "]
["Member DOB","Enter the member's date of birth in MM/DD/YYYY format.","This is a mandatory field. "]
["Number of hours authorized per week","Enter the total number of hours authorized by ACDE for the week.","This is a mandatory field. Only numeric characters should be entered into this field. This field can not be be zero.  If the provider has AC/HHA/HMR/SN/TPY services in units, then a mandatory conversion from units to hours is required. Calculate this as 1 unit= 15 minutes = 0.25 hours. (To convert ‘X’ Units into hours = 'X' * '0.25' hours). Please note: As PDN is already recorded in hours, there is no need to covert into hours."]
["Total Authorized Hours  Not Covered for the Week","Enter the total number of hours of care not provided during the week","This is a mandatory field. Only numeric characters should be entered into this field. This field can not be be zero.  If the provider has AC/HHA/HMR/SN/TPY services in units, then a mandatory conversion from units to hours is required. Calculate this as 1 Unit= 15 minutes = 0.25 hours. (To convert ‘X’ Units into hours = 'X' * '0.25' hours). Important notes: As PDN is already recorded in hours, there is no need to covert into hours. The number of ‘not-covered hours’ (column 'K') should not exceed number of ‘authorized hours’ (column 'J') and can not be zero."]
["Home Health Aide (HHA), Homemaker (HMR), Private Duty Nursing (PDN), Therapy (TPY) or Skilled Nurse (SN)","Enter the appropriate code for the type of service that was not covered during the week.","This is a mandatory field. Only one type of service should be entered."]
["Reason Codes","Enter a lowercase 'x' in the appropriate box for the reason the hours  were not covered. Enter a lowercase 'x' in the box for late if the hours  were partially covered. Enter missed if all of the hours  were not covered on the day in question. Reason codes: Provider No Show - PNS; Provider Canceled - PC;  Member No Show -MNS;  Member Canceled - MC;  Sheduling Error Provider  - SEP;  Scheduling Error Member - SEM;  Lack of Service Auth - LA;  Other -  OTR .","This is a mandatory field. Only one reason code should be selected as a lowercase 'x'. "]
["Late or Missed shift","Enter a lowercase 'x' in the appropriate box for late or missed shifts. Late and missed can not be selected at the same time.","This is a mandatory field. Either the late or missed box should be selected. If not-covered hours are equal to authorized hours, then the missed indicator should be selected as lowercase 'x' . If not-covered hours are less than authorized hours, then the late indicator should be selected as a lowercase 'x'."]
["Provide dates and hours not covered for the week and an explanation of why those hours were late or missed.","Provide dates and hours not covered for the week and an explanation of why those hours were late or missed.","This is an optional field."]
["Identify actions taken to resolve this members staffing issues. As of the date of this submission, has this issue been resolved? ","Describe any actions taken to resolve the staffing issues. Indicate if the issue has been resolved as of the date of the submission.","This is an optional field."]

{"sheet":"Data Sheet","index":1,"n_rows":8,"n_cols":24,"rows_kept":8,"cut":false,"hidden":false,"merged":[[6,12,6,19],[4,12,5,19],[4,20,6,21],[4,2,4,11],[5,9,5,10],[0,0,0,23],[1,16,2,23],[3,12,3,21],[1,0,1,15],[2,0,2,15],[3,4,3,11]]}
["MCO Name: AmeriHealth Caritas Delaware "]
["ONLY AFTER DATA VALIDATION IS COMPLETE Submit forms to acdeHHA@amerihealthcaritasde.com"]
[]
[null,null,null,null,"Providers SHOULD NOT send data to ACDE without Data Validation being Successfully Completed",null,null,null,null,null,null,null,"REASON CODES KEY"]
[null,null,"**** USE PASTE AS VALUES ONLY**** Otherwise the Sheet will be Corrupted",null,null,null,null,null,null,null,null,null,"Provider No Show - PNS  Provider Canceled - PC   Member No Show -MNS Member Canceled - MC  Sheduling Error Provider  - SEP  Scheduling Error Member  - SEM      Lack of Service Auth - LA     Other - OTR    Late - a partial shift  Missed - entire shift missed",null,null,null,null,null,null,null,"One of either Late in Shift or Missed Shift must be marked with 'x'\n(NOT BOTH)"]
[null,null,"Choose Others Plan type for DSHP, DSHP PLUS,DUAL & DDDS",null,null,null,null,null,null,"1 Unit =0.25 hours(15 Minutes)",null,"Attendant Care (AC)   Home Health Aide (HHA), Homemaker (HMR), Private Duty Nursing (PDN),  Skilled Nurse (SN) or Therapy (TPY) "]
["Month\n(1 to 12)","Year\n(2018-3000)","Plan Type","Last Name","First Name","AmeriHealth Caritas Delaware                Member ID#","County Name","Agency","DOB\n(MM/DD/YYYY)","Number of Authorized Hours \nper Week","Total Authorized Hours Not Covered for the Week","Not Covered Service","Reason Codes\n(Only one of these Reason Codes must be marked 'x')",null,null,null,null,null,null,null,null,null,"Provide dates and hours not covered for the week and an explanation of why those hours were late or missed.","Identify Actions taken to resolve this members staffing issues.  As of the date of this submission, has this issue been resolved? "]
["Mandatory","Mandatory","Provider Should Keep this Blank","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory \n(Cannot be zero)","Mandatory \n(Cannot be zero)","Mandatory","PNS","PC","MNS","MC","SEP","SEM","LA","OTR","LATE","MISSED","Optional","Optional"]