INSERT INTO `HRA_member_client_009_2024` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`) VALUES
(1023, 50892900, 44829497, '56716210', '0004968656001', '349460', '', '2661185', 'Robert', 'Smith', '', '{\"DOB\": 22407, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"PCP_NPI\": 1952398406, \"Pcp_Zip\": \"30501\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"GAINESVILLE\", \"Pcp_Name\": \"Dr. Jennifer Davis\", \"PCP_Phone\": 7705320800, \"Pcp_State\": \"GA\", \"Member_City\": \"Cleveland\", \"Office_Name\": \"Guilford Immediate Care\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Cleveland\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1961-05-06\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"1250 Jesse Jewell Pkwy SE Ste 300 \", \"Screening_IHA\": \"No\", \"member_id_two\": 349460, \"Member_Country\": \"WHITE\", \"PCP_Fax_Number\": \"7705320801\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"105 Bryant St\", \"Member_Address2\": \"D13\", \"Member_Zip_Code\": 30528, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO Box 2164\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30528, \"Member_Last_name\": \"Smith\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Robert\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"glennsmith147@gmail.com\", \"Member_Suspect_Codes\": 160, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 6783714729, \"Member_Identification_Number\": \"0004968656001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"05-31-2024 14:32:14\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-05-31 14:32:14\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-05-08T20:49\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-14T08:15\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-14T12:19\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-31T14:32\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-04-25T18:08\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-04-30T17:57\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-04-25T18:08\", \"reportStatus_date\": \"2024-04-25T18:08\"}, {\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 2, \"hraStatus_date\": \"2024-05-05T18:45\", \"reportStatus_date\": \"2024-04-30T17:57\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-05-08T20:49\", \"reportStatus_date\": \"2024-05-08T20:49\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-05-14T12:19\", \"reportStatus_date\": \"2024-05-14T12:19\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-05-31T14:32\", \"reportStatus_date\": \"2024-05-31T14:32\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-05-31T14:32\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-04-25T18:08\", \"username\": null}, {\"date\": \"2024-04-25T18:08\", \"username\": null}, {\"date\": \"2024-04-30T17:57\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-05-05T18:45\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-05-09T08:06\", \"username\": \"JScanlonQAL\"}], \"readyForQa\": [{\"date\": \"2024-05-08T20:49\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-05-14T12:19\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-05-14T08:15\", \"username\": \"fcopeland1\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-05-14T12:19\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"06-26-2024\", \"time\": \"14:41:40\", \"value\": [{\"add\": \"105 Bryant St\", \"age\": 63, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1961-05-06\", \"eno\": \"6783533853\", \"lob\": \"On Exchange\", \"pno\": 6783714729, \"zip\": 30528, \"add2\": \"D13\", \"add3\": \"\", \"city\": \"Cleveland\", \"gend\": 0, \"insh\": \"0004968656001\", \"mzip\": 30528, \"name\": \"Robert Smith\", \"plan\": \"Alliant\", \"pphy\": \"Dr. Jennifer Davis\", \"ppno\": 7705320800, \"race\": \"\", \"cliId\": \"\", \"email\": \"glennsmith147@gmail.com\", \"ename\": \"Scott Smith\", \"madd1\": \"PO Box 2164\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Cleveland\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"1250 Jesse Jewell Pkwy SE Ste 300 \", \"pcpnpi\": \"\", \"pcpzip\": \"30501\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Divorced\", \"pcpcity\": \"GAINESVILLE\", \"pcpname\": \"Guilford Immediate Care\", \"program\": \"ACA\", \"evalDate\": \"2024-05-07 02:00 PM\", \"evalName\": \"Delise Adams, FNP\", \"pcpfaxno\": \"7705320801\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:19\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"06-26-2024 14:41:40\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"4/25/2024 @ 06:08 PM\", \"result\": 0, \"comment\": \"Scheduled HRA w/Delise Adams for 5/7/24 @ 1-4pm time block. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0004968656001\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"56716210\", \"memberId\": \"0004968656001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"56716210\", \"memberId\": \"0004968656001\", \"scheduleDate\": \"2024-5-7T12:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-25-2024 18:08:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"04-30-2024 17:57:07\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2024-05-31 14:32:12\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"18c03487-1f7c-11ef-851b-275a750cca12\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'In Person', '2024-5-7T14:00', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:56:55', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0004968656001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0004968656001_Smith, Robert_05072024.pdf\", \"ftp_upload_date\": \"2024-05-31 14:32:12\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Davis, Jennifer_0004968656001_05072024.pdf\"}', 'ACA_0004968656001_Smith, Robert_05072024', NULL, 'PCP_Davis, Jennifer_0004968656001_05072024', NULL, '[{\"date\": \"2024-05-09T00:49:17.253Z\", \"signature\": \"data:image/png;base64,[encoded data, 23512 characters]\"}]', '2024-05-07T15:30', 'Member_Summary_0004968656001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0004968656001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0004968656001.pdf\", \"member_ftp_upload_date\": \"2024-05-31 14:32:13\"}', NULL, NULL, NULL, NULL),
(1024, NULL, NULL, NULL, '0004970352001', '373174', '', '2661185', 'Alejandro', 'Garcia Perez', '', '{\"DOB\": 26159, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1275582058, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"ROME\", \"Pcp_Name\": \"Mourad Nessim\", \"PCP_Phone\": 7622353400, \"Pcp_State\": \"GA\", \"Member_City\": \"WayRome\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"WayRome\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1971-08-14\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"1825 MARTHA BERRY BLVD NW\", \"Screening_IHA\": \"No\", \"member_id_two\": 373174, \"Mailing_County\": \"FLOYD\", \"Member_Country\": \"FLOYD\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"117 warwick way\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30161, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"117 warwick way\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30161, \"Member_Last_name\": \"Garcia Perez\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Alejandro\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"alex147164@gmail.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7068442467, \"Member_Identification_Number\": \"0004970352001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:32:17\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:17\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-06-11T19:02\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [{\"date\": \"2024-06-26T16:16\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-05-01T12:56\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-06-04T15:52\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-08-06T18:37\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-01T12:56\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-04T15:52\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-11T19:02\"}, {\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-26T16:16\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-06T18:37\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-15T05:45\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-04-23T17:31\", \"username\": null}, {\"date\": \"2024-04-23T17:31\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-05-20T12:47\", \"username\": \"DYork\"}], \"qaAssigned\": [], \"readyForQa\": [{\"date\": \"2024-05-20T12:48\", \"username\": \"DYork\"}, {\"date\": \"2024-05-20T12:48\", \"username\": \"DYork\"}, {\"date\": \"2024-05-20T12:48\", \"username\": \"DYork\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-06-07T13:48\", \"username\": \"AWalsh\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:56:55\", \"value\": [{\"add\": \"117 warwick way\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1971-08-14\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7068442467, \"zip\": 30161, \"add2\": \"\", \"add3\": \"\", \"city\": \"WayRome\", \"gend\": 0, \"insh\": \"0004970352001\", \"mzip\": 30161, \"name\": \"Alejandro Garcia Perez\", \"plan\": \"Alliant\", \"pphy\": \"Mourad Nessim\", \"ppno\": 7622353400, \"cliId\": \"\", \"email\": \"alex147164@gmail.com\", \"ename\": \"\", \"madd1\": \"117 warwick way\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"WayRome\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"1825 MARTHA BERRY BLVD NW\", \"pcpnpi\": 1275582058, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"ROME\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:19\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:19\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 13, \"callLog\": [{\"date\": \"11/6/2024 @ 06:11 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"8/6/2024 @ 06:37 PM\", \"result\": 6, \"comment\": \"virtual w/Faith Enwefah - member didn\'t understand what I was calling about, ok to c/b\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"8/13/2024 @ 06:36 PM\"}, {\"date\": \"6/26/2024 @ 04:16 PM\", \"result\": 14, \"comment\": \"Placed member as a F2F callback at end of July. Previous call notes on from 5/1 stated \'Member would like a call back in August. He will be in and out of town for the next few months and would like to schedule something in August. -MR\'\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"7/29/2024 @ 04:16 PM\"}, {\"date\": \"6/11/2024 @ 04:02 PM\", \"result\": 3, \"comment\": \"06/11/2024 JC: called for HRA- Faith Enwefah - Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/17/2024 @ 04:02 PM\"}, {\"date\": \"6/4/2024 @ 03:52 PM\", \"result\": 6, \"comment\": \"6/4/24 GM: Calling to schedule HRA w Faith 6/12 or 6/13. MEMBER PREVIOUSLY REQUESTED CALL IN AUGUST \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"8/1/2024 @ 03:52 PM\"}, {\"date\": \"5/1/2024 @ 12:56 PM\", \"result\": 6, \"comment\": \"Member would like a call back in August. He will be in and out of town for the next few months and would like to schedule something in August. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"8/1/2024 @ 12:55 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-01-2024 12:56:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"11-15-2024 05:45:03\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:56:55', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `HRA_member_client_009_2024` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`) VALUES
(1025, 57818338, 44829497, '56716210', '0004971521001', '368415', '', '2661185', 'Fedora', 'Ravello', '', '{\"DOB\": 23471, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"PCP_NPI\": 1811989411, \"Pcp_Zip\": \"30501\", \"Program\": \"ACA\", \"PCP_Flag\": null, \"Pcp_City\": \"GAINESVILLE\", \"Pcp_Name\": \"Dr. MARGARET DAVIS\", \"PCP_Phone\": 6782074373, \"Pcp_State\": \"GA\", \"Member_City\": \"Gainesville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gainesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1964-04-04\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"725 JESSE JEWELL PKWY SE\", \"Screening_IHA\": \"No\", \"member_id_two\": 368415, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"7705334727\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"670 Holly Drive\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30501, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"670 Holly Drive\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30501, \"Member_Last_name\": \"Ravello\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Fedora\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"THORARAVELLO@GMAIL.COM\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 3477858651, \"Member_Identification_Number\": \"0004971521001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"06-18-2024 23:12:01\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-06-18 23:12:01\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-06-14T17:59\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-06-18T16:02\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-06-18T18:09\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-06-18T23:12\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-04-25T11:28\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-05-08T10:50\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [{\"date\": \"2024-06-06T17:14\", \"text\": \"Rescheduled\", \"method\": \"api\", \"status\": 16}], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2024-04-29T14:22\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}, {\"date\": \"2024-05-08T10:51\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Cancellation\", \"type\": \"ReportStatus\", \"status\": 18, \"hraStatus\": 3, \"hraStatus_date\": \"2024-04-29T14:22\", \"reportStatus_date\": \"2024-04-29T14:22\"}, {\"text\": \"Cancellation\", \"type\": \"ReportStatus\", \"status\": 18, \"hraStatus\": 3, \"hraStatus_date\": \"2024-05-08T10:51\", \"reportStatus_date\": \"2024-05-08T10:51\"}, {\"text\": \"Rescheduled\", \"type\": \"HraStatus\", \"status\": 16, \"hraStatus\": 1, \"hraStatus_date\": \"2024-06-07T10:45\", \"reportStatus_date\": \"2024-06-06T17:14\"}, {\"text\": \"Completed\", \"type\": \"HraStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-06-17T19:37\", \"reportStatus_date\": \"2024-06-14T17:59\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-06-18T23:12\", \"reportStatus_date\": \"2024-06-18T23:12\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-06-18T23:12\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-04-25T11:28\", \"username\": null}, {\"date\": \"2024-05-08T10:50\", \"username\": null}, {\"date\": \"2024-05-08T10:50\", \"username\": \"admin\"}, {\"date\": \"2024-06-06T17:14\", \"username\": null}, {\"date\": \"2024-06-06T17:14\", \"username\": null}, {\"date\": \"2024-06-07T10:45\", \"username\": null}, {\"date\": \"2024-06-07T10:45\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-04-28T19:19\", \"username\": \"DAdams\"}, {\"date\": \"2024-06-06T20:50\", \"username\": \"DAdams\"}, {\"date\": \"2024-06-13T15:12\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-06-17T09:28\", \"username\": \"JScanlonQAL\"}], \"readyForQa\": [{\"date\": \"2024-06-14T17:59\", \"username\": \"DAdams\"}, {\"date\": \"2024-06-14T17:59\", \"username\": \"DAdams\"}, {\"date\": \"2024-06-17T19:37\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-06-18T18:09\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-06-18T16:02\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-06-18T18:09\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-06-17T11:25\", \"username\": \"JSilverio\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-04-29T14:22\", \"username\": \"AWalsh\"}, {\"date\": \"2024-05-08T10:51\", \"username\": \"TOdleAdmin\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-14-2025\", \"time\": \"05:27:12\", \"value\": [{\"add\": \"670 Holly Drive\", \"age\": 61, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1964-04-04\", \"eno\": \"6789974444\", \"lob\": \"On Exchange\", \"pno\": 3477858651, \"zip\": 30501, \"add2\": \"\", \"add3\": \"\", \"city\": \"Gainesville\", \"gend\": 1, \"insh\": \"0004971521001\", \"mzip\": 30501, \"name\": \"Fedora Ravello\", \"plan\": \"Alliant\", \"pphy\": \"Dr. MARGARET DAVIS\", \"ppno\": 6782074373, \"race\": \"\", \"cliId\": \"\", \"email\": \"THORARAVELLO@GMAIL.COM\", \"ename\": \"Cheryl Denny\", \"madd1\": \"670 Holly Drive\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gainesville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"725 JESSE JEWELL PKWY SE\", \"pcpnpi\": 1811989411, \"pcpzip\": \"30501\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Divorced\", \"pcpcity\": \"GAINESVILLE\", \"pcpname\": \"\", \"program\": \"ACA\", \"evalDate\": \"2024-6-13 3:00 PM\", \"evalName\": \"Delise Adams, FNP\", \"pcpfaxno\": \"7705334727\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [], \"score\": [], \"comment\": []}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:19\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-14-2025 05:27:12\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2024-04-29T14:22\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"AWalsh\", \"hraStatus\": 3, \"cancelText\": \"\", \"cancelStatus\": 0}, {\"date\": \"2024-05-08T10:51\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"TOdleAdmin\", \"hraStatus\": 3, \"cancelText\": \"\", \"cancelStatus\": 0}]}', NULL, '{\"memberId\": \"0004971521001\", \"clinician\": \"Delise Adams\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Mon, 17 Jun 2024 15:25:41 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"1.  Preventative Care Hep C if born between 1945-1965 education provided needs answer.  Thank You\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 17 Jun 2024 23:37:27 GMT\", \"name\": \"Delise \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Corrected. Thank you. \"}, \"mailId\": \"\"}], \"memberName\": \"Fedora Ravello\", \"codingAnalyst\": \"\", \"dateOfService\": \"06/13/2024 03:15 PM\", \"clinicianMailId\": \"deliseadams@sbcglobal.net\", \"qaAnalystMailId\": \"j.silverio@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 12, \"callLog\": [{\"date\": \"6/7/2024 @ 10:45 AM\", \"result\": 12, \"comment\": \" Rescheduled F2F HRA w/ Delise Adams for 6/13/24 @ 3:00pm SPECIFC TIME! No special instructions, park where you\'re comfortable. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"6/6/2024 @ 05:14 PM\", \"result\": 12, \"comment\": \"Scheduled F2F HRA w/Delise Adams for 6/7/24 @ 3:00pm SPECIFC TIME! No special instructions, park where you\'re comfortable. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"\"}, {\"date\": \"5/8/2024 @ 10:50 AM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0004971521001\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"56716210\", \"memberId\": \"0004971521001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"56716210\", \"memberId\": \"0004971521001\", \"scheduleDate\": \"2024-6-13T15:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"06-06-2024 17:14:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"06-07-2024 10:45:05\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 3}', NULL, 0, NULL, '[{\"date\": \"2024-06-18 23:11:59\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"b0e03c9f-2de9-11ef-910b-192660da839f\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'In Person', '2024-6-13T15:00', '2024-12-31', '2024-06-13T15:15', NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:56:56', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0004971521001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0004971521001_Ravello, Fedora_06132024.pdf\", \"ftp_upload_date\": \"2024-06-18 23:11:58\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_DAVIS, Dr. MARGARET_0004971521001_06132024.pdf\"}', 'ACA_0004971521001_Ravello, Fedora_06132024', NULL, 'PCP_DAVIS, Dr. MARGARET_0004971521001_06132024', NULL, '[{\"date\": \"2024-06-14T21:59:04.841Z\", \"signature\": \"data:image/png;base64,[encoded data, 23492 characters]\"}, {\"date\": \"2024-06-17T23:37:27.247Z\", \"signature\": \"data:image/png;base64,[encoded data, 23472 characters]\"}]', '2024-06-13T16:15', 'Member_Summary_0004971521001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0004971521001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0004971521001.pdf\", \"member_ftp_upload_date\": \"2024-06-18 23:12:00\"}', NULL, NULL, NULL, NULL);
INSERT INTO `HRA_member_client_009_2024` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`) VALUES
(1026, NULL, NULL, NULL, '0004972060001', '335769', '', '21881792', 'Robert', 'Manis', '', '{\"DOB\": 24313, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1265420731, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"DALTON\", \"Pcp_Name\": \"John Antalis\", \"PCP_Phone\": 7062780138, \"Pcp_State\": \"GA\", \"Member_City\": \"Dalton\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Dalton\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1966-07-25\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"1504 N THORTON AVE 107\", \"Screening_IHA\": \"No\", \"member_id_two\": 335769, \"Mailing_County\": \"WHITFIELD\", \"Member_Country\": \"WHITFIELD\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1891 Freeport Road\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 307200000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1891 Freeport Road\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30720, \"Member_Last_name\": \"Manis\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Robert\", \"Member_Middle_name\": \"S\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"manisscott15@gmail.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7062701242, \"Member_Identification_Number\": \"0004972060001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:32:17\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:17\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-24T09:09\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-02T11:03\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2024-05-22T11:53\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-24T09:09\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-02T11:03\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-05-22T11:53\", \"reportStatus_date\": \"2024-05-22T11:53\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-05-22T11:53\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:56:56\", \"value\": [{\"add\": \"1891 Freeport Road\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1966-07-25\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7062701242, \"zip\": 307200000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Dalton\", \"gend\": 0, \"insh\": \"0004972060001\", \"mzip\": 30720, \"name\": \"Robert S Manis\", \"plan\": \"Alliant\", \"pphy\": \"John Antalis\", \"ppno\": 7062780138, \"cliId\": \"\", \"email\": \"manisscott15@gmail.com\", \"ename\": \"\", \"madd1\": \"1891 Freeport Road\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Dalton\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"1504 N THORTON AVE 107\", \"pcpnpi\": 1265420731, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"DALTON\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:19\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:19\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-05-22T11:53\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"5/22/2024 @ 11:53 AM\", \"result\": 9, \"comment\": \"REFUSAL - MEMBER DECLINED OFFER TO SCHEDULE IN 2024. MEMBER STATED HE IS SELF-EMPLOYED AND IT IS KIND OF DIFFICULT TO SCHEDULE APPTS. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"5/2/2024 @ 11:03 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL   \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/7/2024 @ 11:03 AM\"}, {\"date\": \"4/24/2024 @ 09:09 AM\", \"result\": 3, \"comment\": \"LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"4/25/2024 @ 09:09 AM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-24-2024 09:09:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"04-22-2024 00:30:55\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 3}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:56:56', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1027, NULL, NULL, NULL, '0004974116001', '365038', '', '26056802', 'Susan', 'Froman', '', '{\"DOB\": 22228, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1407943301, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"DAWSONVILLE\", \"Pcp_Name\": \"RAMZI GHOSN\", \"PCP_Phone\": 7062658002, \"Pcp_State\": \"GA\", \"Member_City\": \"Dawsonville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Dawsonville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1960-11-08\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"73 PRESTIGE LN STE 103\", \"Screening_IHA\": \"No\", \"member_id_two\": 365038, \"Mailing_County\": \"DAWSON\", \"Member_Country\": \"DAWSON\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"150 Holts Ct\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30534, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"150 Holts Ct\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30534, \"Member_Last_name\": \"Froman\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Susan\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"sfroman.med@gmail.com\", \"Member_Suspect_Codes\": \"21, 30, 56, 57\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7706172936, \"Member_Identification_Number\": \"0004974116001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:32:17\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:17\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-03T17:02\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2024-05-14T16:02\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-03T17:02\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-05-14T16:02\", \"reportStatus_date\": \"2024-05-14T16:02\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-05-14T16:02\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:56:56\", \"value\": [{\"add\": \"150 Holts Ct\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1960-11-08\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7706172936, \"zip\": 30534, \"add2\": \"\", \"add3\": \"\", \"city\": \"Dawsonville\", \"gend\": 1, \"insh\": \"0004974116001\", \"mzip\": 30534, \"name\": \"Susan Froman\", \"plan\": \"Alliant\", \"pphy\": \"RAMZI GHOSN\", \"ppno\": 7062658002, \"cliId\": \"\", \"email\": \"sfroman.med@gmail.com\", \"ename\": \"\", \"madd1\": \"150 Holts Ct\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Dawsonville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"73 PRESTIGE LN STE 103\", \"pcpnpi\": 1407943301, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"DAWSONVILLE\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:19\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:19\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-05-14T16:02\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"5/14/2024 @ 04:02 PM\", \"result\": 9, \"comment\": \"REFUSAL - MEMBER DECLINED OFFER TO SCHEDULE IN 2024. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"5/3/2024 @ 05:02 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/17/2024 @ 05:02 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-03-2024 17:02:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"04-22-2024 00:30:55\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:56:56', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1028, NULL, NULL, NULL, '0004979427001', '347121', '', '2661185', 'Traci', 'Elliott', '', '{\"DOB\": 22768, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1194710293, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"GRAY\", \"Pcp_Name\": \"LINDA ARNOLD\", \"PCP_Phone\": 4789864743, \"Pcp_State\": \"GA\", \"Member_City\": \"Gray\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gray\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1962-05-02\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"260 W CLINTON ST\", \"Screening_IHA\": \"No\", \"member_id_two\": 347121, \"Member_Country\": \"JONES\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"295 Monticello Hwy\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 310320000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO Box 42\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31032, \"Member_Last_name\": \"Elliott\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Traci\", \"Member_Middle_name\": \"T\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"telliott986@gmail.com\", \"Member_Suspect_Codes\": \"11, 12, 13, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4789524529, \"Member_Identification_Number\": \"0004979427001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": 4789861829}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:32:17\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:17\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [{\"date\": \"2024-04-29T12:56\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-04-29T12:56\", \"reportStatus_date\": \"2024-04-29T12:56\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-04-29T12:56\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:56:56\", \"value\": [{\"add\": \"295 Monticello Hwy\", \"age\": \"\", \"ano\": \"\", \"cno\": 4789861829, \"dob\": \"1962-05-02\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4789524529, \"zip\": 310320000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Gray\", \"gend\": 1, \"insh\": \"0004979427001\", \"mzip\": 31032, \"name\": \"Traci T Elliott\", \"plan\": \"Alliant\", \"pphy\": \"LINDA ARNOLD\", \"ppno\": 4789864743, \"cliId\": \"\", \"email\": \"telliott986@gmail.com\", \"ename\": \"\", \"madd1\": \"PO Box 42\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gray\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"260 W CLINTON ST\", \"pcpnpi\": 1194710293, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"GRAY\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:19\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:19\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-04-29T12:56\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"4/29/2024 @ 12:56 PM\", \"result\": 9, \"comment\": \"Member refusal, not interested in the HRA. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-29-2024 12:56:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"04-22-2024 00:30:55\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:56:56', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `HRA_member_client_009_2024` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`) VALUES
(1029, 57818338, 44829497, '62685179', '0004982047001', '341780', '', '21881792', 'Gretchen', 'Baker', '', '{\"DOB\": 31341, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"PCP_NPI\": 1073564480, \"Pcp_Zip\": \"30525\", \"Program\": \"ACA\", \"PCP_Flag\": null, \"Pcp_City\": \"CLAYTON\", \"Pcp_Name\": \"Dr. KIMBERLY MARTIN\", \"PCP_Phone\": 7067544348, \"Pcp_State\": \"GA\", \"Member_City\": \"Rabun Gap\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Rabun Gap\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1985-10-21\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"896 HIGHWAY 441 S\", \"Screening_IHA\": \"No\", \"member_id_two\": 341780, \"Mailing_County\": \"Rabun\", \"Member_Country\": \"Rabun\", \"PCP_Fax_Number\": \"7067825111\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"13 Discover Cir\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 305680000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"13 Discover Cir\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30568, \"Member_Last_name\": \"Baker\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Gretchen\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"g85mb1021@gmail.com\", \"Member_Suspect_Codes\": \"19, 20, 21, 22, 37.2, 82, 84\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 8133252633, \"Member_Identification_Number\": \"0004982047001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"05-31-2024 14:32:21\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-05-31 14:32:21\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-09T13:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-16T19:20\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-05-28T17:01\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-30T22:04\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-31T12:22\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-31T14:32\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-05-20T13:19\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-09T13:17\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-05-20T13:19\", \"reportStatus_date\": \"2024-05-20T13:19\"}, {\"text\": null, \"type\": \"HraStatus\", \"status\": null, \"hraStatus\": 2, \"hraStatus_date\": \"2024-05-27T06:15\", \"reportStatus_date\": null}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-05-31T14:32\", \"reportStatus_date\": \"2024-05-31T14:32\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-05-31T14:32\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-05-20T13:19\", \"username\": null}, {\"date\": \"2024-05-20T13:19\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-05-27T06:15\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [{\"date\": \"2024-05-28T18:10\", \"username\": \"JScanlonQAL\"}], \"readyForQa\": [{\"date\": \"2024-05-28T17:01\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-28T17:01\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-30T14:38\", \"username\": \"FEnwefah\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-05-31T12:22\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-05-30T22:04\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-05-31T12:22\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-05-30T09:13\", \"username\": \"JSilverio\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-23-2025\", \"time\": \"06:09:06\", \"value\": [{\"add\": \"13 Discover Cir\", \"age\": 39, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1985-10-21\", \"eno\": \"813 767 1342\", \"lob\": \"On Exchange\", \"pno\": 8133252633, \"zip\": 305680000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Rabun Gap\", \"gend\": 1, \"insh\": \"0004982047001\", \"mzip\": 30568, \"name\": \"Gretchen Baker\", \"plan\": \"Alliant\", \"pphy\": \"Dr. KIMBERLY MARTIN\", \"ppno\": 7067544348, \"cliId\": \"\", \"email\": \"g85mb1021@gmail.com\", \"ename\": \"Ann Baker\", \"madd1\": \"13 Discover Cir\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Rabun Gap\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"896 HIGHWAY 441 S\", \"pcpnpi\": 1073564480, \"pcpzip\": \"30525\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Single\", \"pcpcity\": \"CLAYTON\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"7067825111\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [], \"score\": [], \"comment\": []}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-27-2024\", \"time\": \"06:15:13\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-23-2025 06:09:06\"}', NULL, NULL, '{\"memberId\": \"0004982047001\", \"clinician\": \"Faith Enwefah\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Thu, 30 May 2024 13:13:56 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"1.  AOD genitourinary please report symptoms.\\n2.  AOD musculoskeletal please choose diagnosis.\\n3.  PAT and med list report opioid abuse but its not reported in the HRA AOD or pain section.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 30 May 2024 18:38:13 GMT\", \"name\": \"Faith \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Resolved.\\nThank you\"}, \"mailId\": \"\"}], \"memberName\": \"Gretchen Baker\", \"codingAnalyst\": \"\", \"dateOfService\": \"05/28/2024 12:30 PM\", \"clinicianMailId\": \"f.enwefah@focuscares.com\", \"qaAnalystMailId\": \"j.silverio@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"5/20/2024 @ 01:19 PM\", \"result\": 0, \"comment\": \"SCHEDULED FAITH E ON 5/28 @ 12:30 - TEXTED LINK TO MEMBERS PHONE\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"5/16/2024 @ 07:20 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/17/2024 @ 07:20 PM\"}, {\"date\": \"5/9/2024 @ 01:17 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/10/2024 @ 01:15 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0004982047001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"62685179\", \"memberId\": \"0004982047001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"62685179\", \"memberId\": \"0004982047001\", \"scheduleDate\": \"2024-5-28T12:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-09-2024 13:17:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"05-20-2024 13:19:12\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 3}', NULL, 0, NULL, '[{\"date\": \"2024-05-31 14:32:19\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"1cf6b32c-1f7c-11ef-8a35-bfe6e9f1dc5d\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'Virtual', '2024-5-28T12:30', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:56:57', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0004982047001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0004982047001_Baker, Gretchen_05282024.pdf\", \"ftp_upload_date\": \"2024-05-31 14:32:18\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_MARTIN, KIMBERLY_0004982047001_05282024.pdf\"}', 'ACA_0004982047001_Baker, Gretchen_05282024', NULL, 'PCP_MARTIN, KIMBERLY_0004982047001_05282024', NULL, '[{\"date\": \"2024-05-28T21:01:52.260Z\", \"signature\": \"data:image/png;base64,[encoded data, 23408 characters]\"}, {\"date\": \"2024-05-30T18:38:13.461Z\", \"signature\": \"data:image/png;base64,[encoded data, 23464 characters]\"}]', '2024-05-28T13:30', 'Member_Summary_0004982047001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0004982047001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0004982047001.pdf\", \"member_ftp_upload_date\": \"2024-05-31 14:32:20\"}', NULL, NULL, NULL, NULL);
INSERT INTO `HRA_member_client_009_2024` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`) VALUES
(1030, NULL, NULL, NULL, '0004982597001', '370703', '', '21881792', 'Rachel', 'Latson', '', '{\"DOB\": 24828, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1285894352, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"AUGUSTA\", \"Pcp_Name\": \"JEREMIAH WILSON\", \"PCP_Phone\": 7069220600, \"Pcp_State\": \"GA\", \"Member_City\": \"Blythe\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Blythe\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1967-12-22\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"127 TELFAIR ST\", \"Screening_IHA\": \"No\", \"member_id_two\": 370703, \"Mailing_County\": \"RICHMOND\", \"Member_Country\": \"RICHMOND\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"4107 Bath Edie Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30805, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"4107 Bath Edie Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30805, \"Member_Last_name\": \"Latson\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Rachel\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"buy2kep@yahoo.com\", \"Member_Suspect_Codes\": \"21, 88\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7066919442, \"Member_Identification_Number\": \"0004982597001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:32:17\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:17\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-02T15:56\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-09T13:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-16T19:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-20T13:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-26T16:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-02T15:56\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-09T13:18\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-20T13:17\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-26T16:19\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-02T15:56\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-04-23T17:31\", \"username\": null}, {\"date\": \"2024-04-23T17:31\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-05-20T12:47\", \"username\": \"DYork\"}], \"qaAssigned\": [], \"readyForQa\": [{\"date\": \"2024-05-20T12:48\", \"username\": \"DYork\"}, {\"date\": \"2024-05-20T12:48\", \"username\": \"DYork\"}, {\"date\": \"2024-05-20T12:48\", \"username\": \"DYork\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-06-07T13:48\", \"username\": \"AWalsh\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:56:57\", \"value\": [{\"add\": \"4107 Bath Edie Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1967-12-22\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7066919442, \"zip\": 30805, \"add2\": \"\", \"add3\": \"\", \"city\": \"Blythe\", \"gend\": 1, \"insh\": \"0004982597001\", \"mzip\": 30805, \"name\": \"Rachel Latson\", \"plan\": \"Alliant\", \"pphy\": \"JEREMIAH WILSON\", \"ppno\": 7069220600, \"cliId\": \"\", \"email\": \"buy2kep@yahoo.com\", \"ename\": \"\", \"madd1\": \"4107 Bath Edie Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Blythe\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"127 TELFAIR ST\", \"pcpnpi\": 1285894352, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"AUGUSTA\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:20\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:20\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/28/2024 @ 04:40 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"8/31/2024 @ 01:57 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Faith no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"8/17/2024 @ 02:02 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Faith no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"7/23/2024 @ 04:41 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/16/2024 @ 04:53 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/2/2024 @ 03:56 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"6/26/2024 @ 04:19 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL- Call attempt to schedule a virtual HRA w/ Faith E. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/27/2024 @ 04:19 PM\"}, {\"date\": \"5/20/2024 @ 01:17 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Faith Enwefah - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/27/2024 @ 01:17 PM\"}, {\"date\": \"5/16/2024 @ 07:21 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/17/2024 @ 07:21 PM\"}, {\"date\": \"5/9/2024 @ 01:18 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/10/2024 @ 01:18 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-09-2024 13:18:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"07-02-2024 15:56:34\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 10}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:56:57', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1031, NULL, NULL, NULL, '0004984670001', '330293', '', '21881792', 'Tonna', 'Matheny', '', '{\"DOB\": 26206, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1366056764, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"CLAYTON\", \"Pcp_Name\": \"LUCY SORTO\", \"PCP_Phone\": 7069609533, \"Pcp_State\": \"GA\", \"Member_City\": \"Clayton\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Clayton\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1971-09-30\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"563 MOUNTAIN CITY RD\", \"Screening_IHA\": \"No\", \"member_id_two\": 330293, \"Mailing_County\": \"Rabun\", \"Member_Country\": \"Rabun\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"157 Babe Ramey rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 305250000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"157 Babe Ramey rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30525, \"Member_Last_name\": \"Matheny\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Tonna\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"tonnaphillips22@gmail.com\", \"Member_Suspect_Codes\": \"10, 9\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 8643775177, \"Member_Identification_Number\": \"0004984670001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"10-15-2024 00:30:08\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2024-10-15 00:30:08\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-03T15:46\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-09T13:20\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-16T19:24\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-20T13:22\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-26T16:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-03T15:46\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-09T13:20\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-20T13:22\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-26T16:21\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-03T15:46\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:56:57\", \"value\": [{\"add\": \"157 Babe Ramey rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1971-09-30\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 8643775177, \"zip\": 305250000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Clayton\", \"gend\": 1, \"insh\": \"0004984670001\", \"mzip\": 30525, \"name\": \"Tonna Matheny\", \"plan\": \"Alliant\", \"pphy\": \"LUCY SORTO\", \"ppno\": 7069609533, \"cliId\": \"\", \"email\": \"tonnaphillips22@gmail.com\", \"ename\": \"\", \"madd1\": \"157 Babe Ramey rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Clayton\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"563 MOUNTAIN CITY RD\", \"pcpnpi\": 1366056764, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"CLAYTON\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:20\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:20\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"9/5/2024 @ 06:10 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"8/1/2024 @ 01:21 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA w/ Jansen Helm. - No VM setup.\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"7/18/2024 @ 02:19 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/3/2024 @ 03:46 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Faith Enwefah\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"6/26/2024 @ 04:21 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL- Call attempt to schedule a virtual HRA w/ Faith E. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/27/2024 @ 04:21 PM\"}, {\"date\": \"5/20/2024 @ 01:22 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Faith Enwefah - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/27/2024 @ 01:22 PM\"}, {\"date\": \"5/16/2024 @ 07:24 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Faith Enwefah - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/23/2024 @ 07:24 PM\"}, {\"date\": \"5/9/2024 @ 01:20 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/10/2024 @ 01:20 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-09-2024 13:20:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"07-03-2024 15:46:29\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 8}', NULL, 1, NULL, NULL, NULL, NULL, '2024-10-02', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:56:57', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1032, NULL, NULL, NULL, '0004985470001', '362752', '', '21881792', 'Tony', 'Stone', '', '{\"DOB\": 25028, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1558335844, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"CHATTANOOGA\", \"Pcp_Name\": \"David Close\", \"PCP_Phone\": 4238922221, \"Pcp_State\": \"TN\", \"Member_City\": \"Ringgold\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Ringgold\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1968-07-09\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"961 SPRING CREEK RD\", \"Screening_IHA\": \"No\", \"member_id_two\": 362752, \"Mailing_County\": \"CATOOSA\", \"Member_Country\": \"CATOOSA\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"63 Kristy Ln\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30736, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"63 Kristy Ln\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30736, \"Member_Last_name\": \"Stone\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Tony\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"gilman163@epbfi.com\", \"Member_Suspect_Codes\": \"120, 74\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4236535015, \"Member_Identification_Number\": \"0004985470001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:32:17\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:17\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-12-16T00:40\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-07-16T14:25\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-19T18:06\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T00:40\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2024-12-17T10:16\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-04-24T14:10\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-07-22T18:57\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-24T14:10\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-22T18:57\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-19T18:06\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-16T00:40\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-12-17T10:16\", \"reportStatus_date\": \"2024-12-17T10:16\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-12-17T10:16\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:56:58\", \"value\": [{\"add\": \"63 Kristy Ln\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1968-07-09\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4236535015, \"zip\": 30736, \"add2\": \"\", \"add3\": \"\", \"city\": \"Ringgold\", \"gend\": 0, \"insh\": \"0004985470001\", \"mzip\": 30736, \"name\": \"Tony Stone\", \"plan\": \"Alliant\", \"pphy\": \"David Close\", \"ppno\": 4238922221, \"cliId\": \"\", \"email\": \"gilman163@epbfi.com\", \"ename\": \"\", \"madd1\": \"63 Kristy Ln\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Ringgold\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"961 SPRING CREEK RD\", \"pcpnpi\": 1558335844, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"CHATTANOOGA\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"TN\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:20\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:20\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-12-17T10:16\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"12/17/2024 @ 10:16 AM\", \"result\": 9, \"comment\": \"REFUSED SAID SHE DID NOT TRUST TO SPEAK TO US \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"\"}, {\"date\": \"11/25/2024 @ 10:38 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 03:54 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"8/19/2024 @ 06:06 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Debbie no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"8/26/2024 @ 06:06 PM\"}, {\"date\": \"7/22/2024 @ 06:57 PM\", \"result\": 6, \"comment\": \"07/22/2024 JC: called for HRA-Connie Middleton-F2F: member req call back, not home\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"7/29/2024 @ 06:57 PM\"}, {\"date\": \"7/16/2024 @ 02:25 PM\", \"result\": 13, \"comment\": \"caller disconnected the call\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"7/17/2024 @ 02:25 PM\"}, {\"date\": \"4/24/2024 @ 02:10 PM\", \"result\": 6, \"comment\": \"MEMBER NOT AVAILABLE - CALL BACK REQUESTED. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"4/25/2024 @ 02:09 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-24-2024 14:10:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"12-16-2024 00:40:10\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 7}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:56:58', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `HRA_member_client_009_2024` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`) VALUES
(1033, 62035418, 44829497, '56716210', '0004988373001', '373215', '', '21881792', 'Nick', 'Long', '', '{\"DOB\": 26583, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"PCP_NPI\": 1366859233, \"Pcp_Zip\": \"31602\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"VALDOSTA\", \"Pcp_Name\": \"Chinmay Patel\", \"PCP_Phone\": 2292531206, \"Pcp_State\": \"GA\", \"Member_City\": \"lakepark\", \"Office_Name\": \"Northside Family Health\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"lakepark\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1972-10-11\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"247 NORTHSIDE DR STE B\", \"Screening_IHA\": \"No\", \"member_id_two\": 373215, \"Mailing_County\": \"ECHOLS\", \"Member_Country\": \"ECHOLS\", \"PCP_Fax_Number\": \"2294680058\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"121warrenLn\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 31636, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"121warrenLn\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31636, \"Member_Last_name\": \"Long\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Nick\", \"Member_Middle_name\": \"Lamar\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"nlong1395@gmail.com\", \"Member_Suspect_Codes\": \"130, 20, 21, 84\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 2294153372, \"Member_Identification_Number\": \"0004988373001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"08-06-2024 11:48:08\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-08-06 11:48:09\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-06-26T16:24\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-02T15:57\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-07-27T09:30\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-07-30T16:53\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-07-31T12:40\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-06T11:48\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-05-09T14:36\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-07-16T17:01\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-07-23T16:42\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [{\"date\": \"2024-05-10T10:58\", \"text\": \"Rescheduled\", \"method\": \"api\", \"status\": 16}, {\"date\": \"2024-05-21T14:49\", \"text\": \"Rescheduled\", \"method\": \"api\", \"status\": 16}], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2024-06-07T13:47\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [{\"date\": \"2024-05-17T16:38\", \"text\": \"Virtual No Show\", \"method\": \"api\", \"status\": 23}], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Rescheduled\", \"type\": \"HraStatus\", \"status\": 16, \"hraStatus\": 1, \"hraStatus_date\": \"2024-05-10T10:58\", \"reportStatus_date\": \"2024-05-10T10:58\"}, {\"text\": \"Virtual No Show\", \"type\": \"ReportStatus\", \"status\": 23, \"hraStatus\": 19, \"hraStatus_date\": \"2024-05-17T16:38\", \"reportStatus_date\": \"2024-05-17T16:38\"}, {\"text\": \"Rescheduled\", \"type\": \"HraStatus\", \"status\": 16, \"hraStatus\": 1, \"hraStatus_date\": \"2024-05-21T14:49\", \"reportStatus_date\": \"2024-05-21T14:49\"}, {\"text\": null, \"type\": \"HraStatus\", \"status\": null, \"hraStatus\": 2, \"hraStatus_date\": \"2024-05-30T06:19\", \"reportStatus_date\": null}, {\"text\": \"Cancellation\", \"type\": \"ReportStatus\", \"status\": 18, \"hraStatus\": 3, \"hraStatus_date\": \"2024-06-07T13:47\", \"reportStatus_date\": \"2024-06-07T13:47\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-26T16:24\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-02T15:57\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-07-16T17:01\", \"reportStatus_date\": \"2024-07-16T17:01\"}, {\"text\": \"Completed\", \"type\": \"HraStatus\", \"status\": 20, \"hraStatus\": 8, \"hraStatus_date\": \"2024-07-29T18:40\", \"reportStatus_date\": \"2024-07-27T09:30\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-07-31T12:40\", \"reportStatus_date\": \"2024-07-31T12:40\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-08-06T11:48\", \"reportStatus_date\": \"2024-08-06T11:48\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-05-17T16:38\", \"username\": \"SKey\"}], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-08-06T11:48\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-05-09T14:36\", \"username\": null}, {\"date\": \"2024-05-09T14:36\", \"username\": null}, {\"date\": \"2024-05-10T10:58\", \"username\": null}, {\"date\": \"2024-05-10T10:58\", \"username\": null}, {\"date\": \"2024-05-21T14:49\", \"username\": null}, {\"date\": \"2024-05-21T14:49\", \"username\": null}, {\"date\": \"2024-07-16T17:01\", \"username\": null}, {\"date\": \"2024-07-16T17:01\", \"username\": null}, {\"date\": \"2024-07-23T16:42\", \"username\": null}, {\"date\": \"2024-07-23T16:42\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-05-30T06:19\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-07-26T08:09\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-07-29T09:26\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2024-07-27T09:30\", \"username\": \"DAdams\"}, {\"date\": \"2024-07-27T09:30\", \"username\": \"DAdams\"}, {\"date\": \"2024-07-30T13:33\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-07-31T12:40\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-07-30T16:53\", \"username\": \"NSchaaf\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-07-31T12:40\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-07-29T18:40\", \"username\": \"NSchaaf\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-06-07T13:47\", \"username\": \"AWalsh\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-12-2024\", \"time\": \"17:02:30\", \"value\": [{\"add\": \"121warrenLn\", \"age\": 51, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1972-10-11\", \"eno\": \"2294153372\", \"lob\": \"On Exchange\", \"pno\": 2294153372, \"zip\": 31636, \"add2\": \"\", \"add3\": \"\", \"city\": \"lakepark\", \"gend\": 0, \"insh\": \"0004988373001\", \"mzip\": 31636, \"name\": \"Nick Lamar Long\", \"plan\": \"Alliant\", \"pphy\": \"Chinmay Patel\", \"ppno\": 2292531206, \"race\": \"\", \"cliId\": \"\", \"email\": \"nlong1395@gmail.com\", \"ename\": \"Jennifer Long\", \"madd1\": \"121warrenLn\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"lakepark\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"247 NORTHSIDE DR STE B\", \"pcpnpi\": 1366859233, \"pcpzip\": \"31602\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"VALDOSTA\", \"pcpname\": \"Northside Family Health\", \"program\": \"ACA\", \"evalDate\": \"2024-7-26 11:30 AM\", \"evalName\": \"Delise Adams, FNP\", \"pcpfaxno\": \"2294680058\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-30-2024\", \"time\": \"06:19:42\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-12-2024 17:02:30\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2024-05-17T16:38\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"SKey\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2024-06-07T13:47\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"AWalsh\", \"hraStatus\": 3, \"cancelText\": \"\", \"cancelStatus\": 0}]}', NULL, '{\"memberId\": \"0004988373001\", \"clinician\": \"Delise Adams\", \"qaAnalyst\": \"Natalie Schaaf\", \"queryData\": [{\"date\": \"Mon, 29 Jul 2024 22:40:14 GMT\", \"name\": \"Natalie \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Delise,\\n\\n1. Since patient is taking blood thinner Brilinta, can you add\\nto long term use medications.\\n2. In the preventative care section can you answer for osteoporosis.\\n3. For the date at the end of the HRA it is reading 5/30/2024 can you edit so that\\ndates match and is date of service 7/26/2024.\\n\\nthanks!\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Tue, 30 Jul 2024 17:33:59 GMT\", \"name\": \"Delise \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Corrections made. Thank you. \"}, \"mailId\": \"\"}], \"memberName\": \"Nick Long\", \"codingAnalyst\": \"\", \"dateOfService\": \"07/26/2024 11:30 AM\", \"clinicianMailId\": \"deliseadams@sbcglobal.net\", \"qaAnalystMailId\": \"n.schaaf@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"7/23/2024 @ 04:42 PM\", \"result\": 0, \"comment\": \"scheduled virtual HRA with delise on 7/26 at 11:30am text link to member\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/16/2024 @ 05:01 PM\", \"result\": 0, \"comment\": \"scheduled virtual HRA with delise on 7/26 at 11:30am text link to member\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/2/2024 @ 03:57 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"7/9/2024 @ 03:57 PM\"}, {\"date\": \"6/26/2024 @ 04:24 PM\", \"result\": 3, \"comment\": \"NO VM SETUP - Unable to leave a message. Call attempt to reschedule a virtual HRA w/ Faith E. \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/27/2024 @ 04:24 PM\"}, {\"date\": \"5/21/2024 @ 02:49 PM\", \"result\": 12, \"comment\": \"RESCHEDULED APPT W/ FAITH 3:30 ON 5/30 - TEXTED LINK TO MEMBER - WALKED MEMBER THROUGH HOW TO USE DOXY LINK. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"5/10/2024 @ 10:58 AM\", \"result\": 12, \"comment\": \"RESCHEDULED MEMBER TO A VIRTUAL APPT - 5/17 @ 4:30 WITH SALLIE K. TEXTED DOXY LINK TO MEMBERS PHONE. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"5/9/2024 @ 02:36 PM\", \"result\": 0, \"comment\": \"SCHEDULED SALLIE K ON 5/14 @ 9 - MEMBER HAS SMALL PETS, NO CATS/DOGS, PARK ANYWHERE AVAILABLE. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0004988373001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"56716210\", \"memberId\": \"0004988373001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"56716210\", \"memberId\": \"0004988373001\", \"scheduleDate\": \"2024-7-26T11:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-09-2024 14:36:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}, {\"date\": \"05-17-2024 16:38:43\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}, {\"date\": \"06-07-2024 13:47:16\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"07-23-2024 16:42:34\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 7}', NULL, 0, NULL, '[{\"date\": \"2024-08-06 11:48:07\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"467d8835-540b-11ef-a05d-c14d8cdc4f05\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'Virtual', '2024-7-26T11:30', '2024-12-31', '2024-07-26T15:30', NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:56:58', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0004988373001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0004988373001_Long, Nick_07262024.pdf\", \"ftp_upload_date\": \"2024-08-06 11:48:07\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_patel, chinmay_0004988373001_07262024.pdf\"}', 'ACA_0004988373001_Long, Nick_07262024', NULL, 'PCP_patel, chinmay_0004988373001_07262024', NULL, '[{\"date\": \"2024-07-27T13:30:53.216Z\", \"signature\": \"data:image/png;base64,[encoded data, 23460 characters]\"}, {\"date\": \"2024-07-30T17:33:59.427Z\", \"signature\": \"data:image/png;base64,[encoded data, 23464 characters]\"}]', '2024-07-26T16:30', 'Member_Summary_0004988373001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0004988373001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0004988373001.pdf\", \"member_ftp_upload_date\": \"2024-08-06 11:48:08\"}', NULL, NULL, NULL, NULL);
INSERT INTO `HRA_member_client_009_2024` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`) VALUES
(1034, NULL, NULL, NULL, '0004990869002', '366561', '', '2661185', 'Adam', 'Posten', '', '{\"DOB\": 31436, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1285620450, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"DAHLONEGA\", \"Pcp_Name\": \"Kimberly Kurtz\", \"PCP_Phone\": 7068676005, \"Pcp_State\": \"GA\", \"Member_City\": \"Dahlonega\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Dahlonega\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1986-01-24\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"1300 S CHESTATEE\", \"Screening_IHA\": \"No\", \"member_id_two\": 366561, \"Mailing_County\": \"LUMPKIN\", \"Member_Country\": \"LUMPKIN\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"862 Eli Knob\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30533, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"862 Eli Knob\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30533, \"Member_Last_name\": \"Posten\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Adam\", \"Member_Middle_name\": \"Heath\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"110, 21, 82\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7069690897, \"Member_Identification_Number\": \"0004990869002\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":1,\"cancelText\":\"Cancelled due to appointment time confusion.\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:32:18\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:17\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-08-01T13:24\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-06-21T14:48\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-26T17:31\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-02T13:46\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-03T15:22\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-18T14:22\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-24T17:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-01T13:24\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-06-27T13:01\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-07-01T15:30\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2024-07-02T11:16\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-06-21T14:48\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-07-01T15:30\", \"reportStatus_date\": \"2024-07-01T15:30\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": 3, \"hraStatus_date\": \"2024-07-02T11:16\", \"reportStatus_date\": \"2024-07-03T15:22\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-18T14:22\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-24T17:55\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-01T13:24\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-06-27T13:01\", \"username\": null}, {\"date\": \"2024-06-27T13:01\", \"username\": null}, {\"date\": \"2024-07-01T15:30\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-07-02T01:26\", \"username\": \"DAdams\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-07-02T11:16\", \"username\": \"TOdleAdmin\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"07-02-2024\", \"time\": \"01:26:06\", \"value\": [{\"add\": \"862 Eli Knob\", \"age\": 38, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1986-01-24\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7069690897, \"zip\": 30533, \"add2\": \"\", \"add3\": \"\", \"city\": \"Dahlonega\", \"gend\": 0, \"insh\": \"0004990869002\", \"mzip\": 30533, \"name\": \"Adam Heath Posten\", \"plan\": \"Alliant\", \"pphy\": \"Kimberly Kurtz\", \"ppno\": 7068676005, \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"862 Eli Knob\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Dahlonega\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"1300 S CHESTATEE\", \"pcpnpi\": 1285620450, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"DAHLONEGA\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"07-02-2024\", \"time\": \"01:26:06\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"07-02-2024 06:13:26\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2024-07-02T11:16\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"TOdleAdmin\", \"hraStatus\": 3, \"cancelText\": \"Cancelled due to appointment time confusion.\", \"cancelStatus\": 1}]}', NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/30/2024 @ 10:13 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/6/2024 @ 11:53 AM\", \"result\": 3, \"comment\": \"Call attempt to reschedule an HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"8/1/2024 @ 01:24 PM\", \"result\": 3, \"comment\": \"Call attempt to reschedule HRA. Attempt to reschedule w/ Jansen Helm. - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"7/24/2024 @ 05:55 PM\", \"result\": 3, \"comment\": \"07/24/2024 JC: called for HRA-Delise Adams-Virtual/F2F: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"7/31/2024 @ 05:55 PM\"}, {\"date\": \"7/18/2024 @ 02:22 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"7/19/2024 @ 02:22 PM\"}, {\"date\": \"7/3/2024 @ 03:22 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Faith Enwefah\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"7/10/2024 @ 03:22 PM\"}, {\"date\": \"7/2/2024 @ 01:46 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"7/9/2024 @ 01:45 PM\"}, {\"date\": \"6/27/2024 @ 01:01 PM\", \"result\": 0, \"comment\": \"Scheduled F2F HRA w/ Delise Adams for 7/2/24 @ 1:15pm. Park directly behind Chevy Silverado, Adam shares a driveway with his neighbors. They do have animals but will be putting them away. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"\"}, {\"date\": \"6/26/2024 @ 05:31 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"6/29/2024 @ 05:31 PM\"}, {\"date\": \"6/21/2024 @ 02:48 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"6/24/2024 @ 02:48 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"06-21-2024 14:48:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}, {\"date\": \"07-02-2024 11:16:26\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"08-01-2024 13:24:03\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 10}', NULL, 1, NULL, NULL, 'In Person', NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:56:58', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `HRA_member_client_009_2024` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`) VALUES
(1035, 2888643, 44829497, '56716210', '0004994521001', '363860', '', '26056802', 'DAVID', 'BLUE', '', '{\"DOB\": 24251, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"Pcp_Zip\": \"30501\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"Gainesville\", \"Pcp_Name\": \"Dr. Ryan D Berry\", \"PCP_Phone\": \"7705336632\", \"Member_City\": \"Dahlonega\", \"Office_Name\": \"Longstreet Clinc PC\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Dahlonega\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1966-05-24\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"725 Jesse Jewell Pkwy SE\", \"Screening_IHA\": \"No\", \"member_id_two\": 363860, \"Mailing_County\": \"LUMPKIN\", \"Member_Country\": \"LUMPKIN\", \"PCP_Fax_Number\": \"7702975643\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"25 Price Ln\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30533, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"25 Price Ln\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30533, \"Member_Last_name\": \"BLUE\", \"Medication_Review\": \"N\", \"Member_first_name\": \"DAVID\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"dblue14582@aol.com\", \"Member_Suspect_Codes\": 160, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 4043098285, \"Member_Identification_Number\": \"0004994521001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"05-31-2024 14:32:27\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-05-31 14:32:27\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-05-22T13:41\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-22T23:59\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-31T14:32\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-04-30T13:14\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-04-30T13:14\", \"reportStatus_date\": \"2024-04-30T13:14\"}, {\"text\": null, \"type\": \"HraStatus\", \"status\": null, \"hraStatus\": 6, \"hraStatus_date\": \"2024-05-13T17:14\", \"reportStatus_date\": null}, {\"text\": null, \"type\": \"HraStatus\", \"status\": null, \"hraStatus\": 8, \"hraStatus_date\": \"2024-05-20T07:33\", \"reportStatus_date\": null}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-05-22T23:59\", \"reportStatus_date\": \"2024-05-22T23:59\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-05-31T14:32\", \"reportStatus_date\": \"2024-05-31T14:32\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-05-31T14:32\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-04-30T13:14\", \"username\": null}, {\"date\": \"2024-04-30T13:14\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-05-13T14:34\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-05-15T17:44\", \"username\": \"JScanlonQAL\"}], \"readyForQa\": [{\"date\": \"2024-05-13T14:37\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-13T14:40\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-13T14:43\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-13T17:08\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-13T17:11\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-13T17:14\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-13T17:14\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T05:21\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T05:24\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T05:24\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T05:27\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T05:30\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T05:31\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T05:33\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T05:35\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T05:36\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T05:39\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T05:40\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T05:42\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T05:43\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T05:45\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T05:46\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T05:48\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T05:50\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T05:51\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T05:54\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T05:55\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T05:57\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T06:00\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T06:02\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T06:03\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T06:06\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T06:09\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T06:11\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T06:12\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T06:13\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T06:15\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T06:18\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T06:18\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T06:21\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T06:24\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T06:33\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T06:33\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T06:33\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T06:52\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T06:55\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T06:58\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T06:59\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-15T17:24\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T16:26\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-20T07:32\", \"username\": \"JScanlonQAL\"}, {\"date\": \"2024-05-22T02:00\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-05-22T23:59\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-05-22T13:41\", \"username\": \"JScanlonQAL\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-05-22T23:59\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-05-15T08:23\", \"username\": \"JScanlonQAL\"}, {\"date\": \"2024-05-16T10:49\", \"username\": \"JScanlonQAL\"}, {\"date\": \"2024-05-20T07:33\", \"username\": \"JScanlonQAL\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"06-26-2024\", \"time\": \"15:01:33\", \"value\": [{\"add\": \"25 Price Ln\", \"age\": 58, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1966-05-24\", \"eno\": \"5617046074\", \"lob\": \"On Exchange\", \"pno\": 4043098285, \"zip\": 30533, \"add2\": \"\", \"add3\": \"\", \"city\": \"Dahlonega\", \"gend\": 0, \"insh\": \"0004994521001\", \"mzip\": 30533, \"name\": \"DAVID A BLUE\", \"plan\": \"Alliant\", \"pphy\": \"Dr. Ryan D Berry\", \"ppno\": \"7705336632\", \"race\": \"\", \"cliId\": \"\", \"email\": \"dblue14582@aol.com\", \"ename\": \"Toni Eckenwiler\", \"madd1\": \"25 Price Ln\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Dahlonega\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"725 Jesse Jewell Pkwy SE\", \"pcpnpi\": \"\", \"pcpzip\": \"30501\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Widowed\", \"pcpcity\": \"Gainesville\", \"pcpname\": \"Longstreet Clinc PC\", \"program\": \"ACA\", \"evalDate\": \"2024-05-14 08:00 AM\", \"evalName\": \"Delise Adams, FNP\", \"pcpfaxno\": \"7702975643\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:20\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"06-26-2024 15:01:33\"}', NULL, NULL, '{\"memberId\": \"0004994521001\", \"clinician\": \"Delise Adams\", \"qaAnalyst\": \"JScanlon Scanlon\", \"queryData\": [{\"date\": \"Wed, 15 May 2024 12:23:53 GMT\", \"name\": \"JScanlon \", \"role\": \"qa_lead\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 15 May 2024 21:24:37 GMT\", \"name\": \"Delise \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 16 May 2024 14:49:34 GMT\", \"name\": \"JScanlon \", \"role\": \"qa_lead\", \"files\": [], \"query\": {\"feedback\": \"Hi Delise,\\n1. In the assessment of diagnosis, respiratory, COPD dx, medications- inhaled or oral steroid is selected, but I only see Anoro ellipta in the medication list. Please review and \\nmake any updates. Was he recently dx with COPD?\\n2.  The member is taking a statin for HLD. Please add this condition to the assessment of diagnosis, cardiovascular\\nThank you,\\nJessica\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Sat, 18 May 2024 20:26:10 GMT\", \"name\": \"Delise \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Added more information to COPD diagnosis in HRA. \"}, \"mailId\": \"\"}, {\"date\": \"Mon, 20 May 2024 11:33:09 GMT\", \"name\": \"JScanlon \", \"role\": \"qa_lead\", \"files\": [], \"query\": {\"feedback\": \"Hi Delise,\\nThank you for the updates.\\nIn the assessment of dx, respiratory, COPD- under medication, inhaled or oral steroid is selected, but I dont see one in the medication list. ( Ellipta only) Please \\nupdate that selection.\\nThank you,\\nJessica\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 22 May 2024 06:00:34 GMT\", \"name\": \"Delise \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"My apologies, selected in error. \"}, \"mailId\": \"\"}], \"memberName\": \"DAVID BLUE\", \"codingAnalyst\": \"\", \"dateOfService\": \"05/14/2024 08:00AM\", \"clinicianMailId\": \"deliseadams@sbcglobal.net\", \"qaAnalystMailId\": \"j.scalon@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"4/30/2024 @ 01:14 PM\", \"result\": 0, \"comment\": \"Scheduled F2F HRA w/ Delise Adams on 5/14 @ 8AM  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0004994521001\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"56716210\", \"memberId\": \"0004994521001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"56716210\", \"memberId\": \"0004994521001\", \"scheduleDate\": \"2024-5-14T08:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-30-2024 13:14:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"04-30-2024 13:14:06\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2024-05-31 14:32:25\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"20b8c3f1-1f7c-11ef-851b-af41dbb94a8d\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'In Person', '2024-5-14T08:00', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:56:58', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0004994521001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0004994521001_BLUE, DAVID_05142024.pdf\", \"ftp_upload_date\": \"2024-05-31 14:32:25\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Berry, Ryan D_0004994521001_05142024.pdf\"}', 'ACA_0004994521001_BLUE, DAVID_05142024', NULL, 'PCP_Berry, Ryan D_0004994521001_05142024', NULL, '[{\"date\": \"2024-05-15T10:58:51.153Z\", \"signature\": \"data:image/png;base64,[encoded data, 23536 characters]\"}, {\"date\": \"2024-05-15T21:24:37.715Z\", \"signature\": \"data:image/png;base64,[encoded data, 23444 characters]\"}, {\"date\": \"2024-05-18T20:26:07.772Z\", \"signature\": \"data:image/png;base64,[encoded data, 23528 characters]\"}, {\"date\": \"2024-05-22T06:00:34.246Z\", \"signature\": \"data:image/png;base64,[encoded data, 23432 characters]\"}]', '2024-05-14T09:00', 'Member_Summary_0004994521001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0004994521001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0004994521001.pdf\", \"member_ftp_upload_date\": \"2024-05-31 14:32:27\"}', NULL, NULL, NULL, NULL);
