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
(1729, NULL, NULL, NULL, '0006372235001', '381926', '', '2661185', 'DANNA', 'IVERY', '', '{\"DOB\": 25883, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1508859448, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"THOMSON\", \"Pcp_Name\": \"DARYL WILEY\", \"PCP_Phone\": 7065951090, \"Pcp_State\": \"GA\", \"Member_City\": \"Harlem\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Thompson\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1970-11-11\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"2508 UNIVERSITY DR\", \"Screening_IHA\": \"No\", \"member_id_two\": 381926, \"Member_Country\": \"COLUMBIA\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"126 Village Run\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30814, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1429 Huntley Cir \", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30824, \"Member_Last_name\": \"IVERY\", \"Medication_Review\": \"N\", \"Member_first_name\": \"DANNA\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"danna_ivery@yahoo.com\", \"Member_Suspect_Codes\": \"161.2, 56, 57\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7065184042, \"Member_Identification_Number\": \"0006372235001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"06-21-2024 00:00:12\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2024-06-21 00:00:12\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-13T18:54\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-17T13:00\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-20T17:53\", \"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-13T18:54\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-20T17:53\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:00:33\", \"value\": [{\"add\": \"126 Village Run\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1970-11-11\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7065184042, \"zip\": 30814, \"add2\": \"\", \"add3\": \"\", \"city\": \"Harlem\", \"gend\": 1, \"insh\": \"0006372235001\", \"mzip\": 30824, \"name\": \"DANNA IVERY\", \"plan\": \"Alliant\", \"pphy\": \"DARYL WILEY\", \"ppno\": 7065951090, \"cliId\": \"\", \"email\": \"danna_ivery@yahoo.com\", \"ename\": \"\", \"madd1\": \"1429 Huntley Cir \", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Thompson\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"2508 UNIVERSITY DR\", \"pcpnpi\": 1508859448, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"THOMSON\", \"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:54\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:54\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"5/20/2024 @ 05:53 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Faith Enwefah - LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/27/2024 @ 05:52 PM\"}, {\"date\": \"5/17/2024 @ 01:00 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Faith Enwefah -LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/24/2024 @ 01:00 PM\"}, {\"date\": \"5/13/2024 @ 06:54 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/14/2024 @ 06:54 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-13-2024 18:54:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"04-22-2024 00:31:29\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 3}', '{\"orderType\": 0, \"sortOrder\": 1716792390}', 1, NULL, NULL, NULL, NULL, '2024-05-30', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:33', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1730, 57818338, 44829497, '62685179', '0006373022001', '404451', '', '2661185', 'Michael', 'Allen', '', '{\"DOB\": 22675, \"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\": \"31021\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"Dublin\", \"Pcp_Name\": \"Dr. Raghu Lolabhattu\", \"PCP_Phone\": \"478 272 2599\", \"Member_City\": \"Toomsboro\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Toomsboro\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1962-01-29\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"101 Mercer Dr # B \", \"Screening_IHA\": \"No\", \"member_id_two\": 404451, \"Mailing_County\": \"WILKINSON\", \"Member_Country\": \"WILKINSON\", \"PCP_Fax_Number\": \"4782726441\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"223 Main St\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 31090, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"223 Main St\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31090, \"Member_Last_name\": \"Allen\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Michael\", \"Member_Middle_name\": \"Wayne\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"michaelwnella@yahoo.com\", \"Member_Suspect_Codes\": \"20, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 4784567499, \"Member_Identification_Number\": \"0006373022001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"06-11-2024 11:15:27\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-06-11 11:15:27\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-05-30T16:01\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-06-03T15:34\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-06-04T09:04\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-06-11T11:15\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-05-13T19:00\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-05-20T17:59\", \"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-05-13T19:00\", \"reportStatus_date\": \"2024-05-13T19:00\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-05-20T17:59\", \"reportStatus_date\": \"2024-05-20T17:59\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 7, \"hraStatus_date\": \"2024-06-03T15:34\", \"reportStatus_date\": \"2024-06-03T15:34\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-06-04T09:04\", \"reportStatus_date\": \"2024-06-04T09:04\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-06-11T11:15\", \"reportStatus_date\": \"2024-06-11T11:15\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-06-11T11:15\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-05-13T19:00\", \"username\": null}, {\"date\": \"2024-05-13T19:00\", \"username\": null}, {\"date\": \"2024-05-20T17:59\", \"username\": null}, {\"date\": \"2024-05-20T17:59\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-05-14T17:58\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-30T06:13\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [{\"date\": \"2024-05-31T08:37\", \"username\": \"JScanlonQAL\"}], \"readyForQa\": [{\"date\": \"2024-05-14T18:00\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-15T14:46\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-15T14:46\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-30T16:01\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-30T16:01\", \"username\": \"FEnwefah\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-06-04T09:04\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-06-03T15:34\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-06-04T09:04\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"07-15-2024\", \"time\": \"15:46:50\", \"value\": [{\"add\": \"223 Main St\", \"age\": 62, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1962-01-29\", \"eno\": \"478 2518992\", \"lob\": \"On Exchange\", \"pno\": 4784567499, \"zip\": 31090, \"add2\": \"\", \"add3\": \"\", \"city\": \"Toomsboro\", \"gend\": 0, \"insh\": \"0006373022001\", \"mzip\": 31090, \"name\": \"Michael Wayne Allen\", \"plan\": \"Alliant\", \"pphy\": \"Dr. Raghu Lolabhattu\", \"ppno\": \"478 272 2599\", \"cliId\": \"\", \"email\": \"michaelwnella@yahoo.com\", \"ename\": \"Mary Jane Allen\", \"madd1\": \"223 Main St\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Toomsboro\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"101 Mercer Dr # B \", \"pcpnpi\": \"\", \"pcpzip\": \"31021\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpcity\": \"Dublin\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"4782726441\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Male\", \"pphycomment\": \"PCP added\", \"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-14-2024\", \"time\": \"17:58:45\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"07-15-2024 15:47:43\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 12, \"callLog\": [{\"date\": \"5/20/2024 @ 05:59 PM\", \"result\": 12, \"comment\": \"Rescheduled Virtual HRA w/ Faith Enwefah on 5/30 @ 2pm - doxy - sent via sms\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}, {\"date\": \"5/13/2024 @ 07:00 PM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA w/Faith Enwefah for 5/15/24 @ 2:45pm- MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0006373022001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"62685179\", \"memberId\": \"0006373022001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"62685179\", \"memberId\": \"0006373022001\", \"scheduleDate\": \"2024-5-30T14:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-13-2024 19:00:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"05-20-2024 17:59:45\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 0, NULL, '[{\"date\": \"2024-06-11 11:15:25\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"6de75826-2805-11ef-8cef-57cb7de1d3fb\\\",\\\"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-30T14:00', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:33', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006373022001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0006373022001_Allen, Michael_05302024.pdf\", \"ftp_upload_date\": \"2024-06-11 11:15:25\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Lolabhattu, DR_0006373022001_05302024.pdf\"}', 'ACA_0006373022001_Allen, Michael_05302024', NULL, 'PCP_Lolabhattu, DR_0006373022001_05302024', NULL, '[{\"date\": \"2024-05-30T20:01:51.224Z\", \"signature\": \"data:image/png;base64,[encoded data, 23408 characters]\"}]', '2024-05-30T15:45', 'Member_Summary_0006373022001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006373022001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0006373022001.pdf\", \"member_ftp_upload_date\": \"2024-06-11 11:15:26\"}', NULL, NULL, NULL, NULL),
(1731, NULL, NULL, NULL, '0006377461002', '391313', '', '21881792', 'Regina', 'Lunsford', '', '{\"DOB\": 26410, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1942798517, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"CHATSWORTH\", \"Pcp_Name\": \"CHELSEA FORRESTER\", \"PCP_Phone\": 7065293025, \"Pcp_State\": \"GA\", \"Member_City\": \"Dalton\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Dalton\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1972-04-21\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"800 GI MADDOX PKWY\", \"Screening_IHA\": \"No\", \"member_id_two\": 391313, \"Mailing_County\": \"WHITFIELD\", \"Member_Country\": \"WHITFIELD\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"635 Daris Dr\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30721, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"635 Daris Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30721, \"Member_Last_name\": \"Lunsford\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Regina\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"120, 146, 150, 82\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": \"7064630971\", \"Member_Identification_Number\": \"0006377461002\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:24\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:24\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-09T17:52\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-06-17T17:40\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-09T17:52\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [{\"date\": \"2024-06-13T16:11\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-06-21T12:50\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-06-29T15:08\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-06-17T17:40\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-21T12:50\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-29T15:08\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-09T17:52\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-07-11T15:14\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"06-21-2024\", \"time\": \"01:15:30\", \"value\": [{\"add\": \"635 Daris Dr\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1972-04-21\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7064630971, \"zip\": 30721, \"add2\": \"\", \"add3\": \"\", \"city\": \"Dalton\", \"gend\": 1, \"insh\": \"0006377461002\", \"mzip\": 30721, \"name\": \"Regina Lunsford\", \"plan\": \"Alliant\", \"pphy\": \"CHELSEA FORRESTER\", \"ppno\": 7065293025, \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"635 Daris Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Dalton\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"800 GI MADDOX PKWY\", \"pcpnpi\": 1942798517, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"CHATSWORTH\", \"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\": \"06-21-2024\", \"time\": \"01:15:30\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"06-21-2024 01:15:30\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/31/2024 @ 11:27 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/30/2024 @ 10:40 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"7/23/2024 @ 03:25 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA w/ Nykya Cox. - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"7/22/2024 @ 04:58 PM\", \"result\": 1, \"comment\": \"07/22/2024 JC: called for HRA-Connie Middleton-F2F:  Dead Air \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"7/9/2024 @ 05:52 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ FAITH ENWEFAH  OR w/ DELISE ADAMS \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"6/29/2024 @ 03:08 PM\", \"result\": 10, \"comment\": \"Called to schedule Virtual HRA w HRA w/ Faith Enwefah or Deborah York \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"7/6/2024 @ 03:08 PM\"}, {\"date\": \"6/21/2024 @ 12:50 PM\", \"result\": 10, \"comment\": \"06/21/2024 JC: called for HRA-Nykya Cox-Virtual: DISC \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/28/2024 @ 12:50 PM\"}, {\"date\": \"6/17/2024 @ 05:40 PM\", \"result\": 1, \"comment\": \"06/17/2024 JC: called for HRA-Faith Enwefah-Virtual:  Dead Air \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/20/2024 @ 05:40 PM\"}, {\"date\": \"6/13/2024 @ 04:11 PM\", \"result\": 10, \"comment\": \"DISCONNECTED - Members primary number no longer in service.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/14/2024 @ 04:11 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"06-13-2024 16:11:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"07-09-2024 17:52:59\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 9}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:34', 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
(1732, NULL, NULL, NULL, '0006379198001', '369797', '', '26056802', 'Maria', 'Guzman', '', '{\"DOB\": 24466, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Flowery Branch\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Flowery Branch\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1966-12-25\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 369797, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"6319 Iris Drive\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30542, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"6319 Iris Drive\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30542, \"Member_Last_name\": \"Guzman\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Maria\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6014510429, \"Member_Identification_Number\": \"0006379198001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:24\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:24\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-16T14:48\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2024-07-31T16:26\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2024-09-06T16:23\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-06-03T17:42\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-05T14:50\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-06T12:41\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-04-26T16:33\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-06-07T15:23\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-07-16T14:48\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-26T16:33\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-03T17:42\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-07T15:23\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2024-07-16T14:48\", \"reportStatus_date\": \"2024-07-16T14:48\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2024-07-31T16:26\", \"reportStatus_date\": \"2024-07-31T16:26\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2024-09-06T16:23\", \"reportStatus_date\": \"2024-09-06T16:23\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:45\"}]', '{\"utc\": [{\"date\": \"2024-07-16T14:48\", \"username\": null}, {\"date\": \"2024-07-31T16:26\", \"username\": null}, {\"date\": \"2024-09-06T16:23\", \"username\": null}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:00:34\", \"value\": [{\"add\": \"6319 Iris Drive\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1966-12-25\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6014510429, \"zip\": 30542, \"add2\": \"\", \"add3\": \"\", \"city\": \"Flowery Branch\", \"gend\": 1, \"insh\": \"0006379198001\", \"mzip\": 30542, \"name\": \"Maria Guzman\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"6319 Iris Drive\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Flowery Branch\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"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:54\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:54\"}', '{\"utc\": [{\"date\": \"2024-07-16T14:48\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}, {\"date\": \"2024-07-31T16:26\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}, {\"date\": \"2024-09-06T16:23\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 13, \"callLog\": [{\"date\": \"10/30/2024 @ 04:28 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/6/2024 @ 04:23 PM\", \"result\": 6, \"comment\": \"Called to schedule Virtual HRA with Nykya Cox, member needs Spanish interpreter\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kayla Hoff\", \"callbackDate\": \"\"}, {\"date\": \"7/31/2024 @ 04:26 PM\", \"result\": 6, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/16/2024 @ 02:48 PM\", \"result\": 6, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"6/7/2024 @ 03:23 PM\", \"result\": 6, \"comment\": \"CALL BACK - Member requested/will need an interpreter.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/10/2024 @ 03:23 PM\"}, {\"date\": \"6/6/2024 @ 12:41 PM\", \"result\": 1, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"6/13/2024 @ 12:41 PM\"}, {\"date\": \"6/5/2024 @ 02:50 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/12/2024 @ 02:50 PM\"}, {\"date\": \"6/3/2024 @ 05:42 PM\", \"result\": 13, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams - Member speaks Spanish and will need interpreter\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/10/2024 @ 05:42 PM\"}, {\"date\": \"4/26/2024 @ 04:33 PM\", \"result\": 6, \"comment\": \"Called to schedule F2F HRA w/ Sallie Key -Call Back - Member needs Spanish interpreter \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/10/2024 @ 04:33 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-26-2024 16:33:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"11-11-2024 00:45:00\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 9}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:34', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1733, NULL, NULL, NULL, '0006382105002', '382329', '', '84555898', 'Susan', 'McDowell', '', '{\"DOB\": 22458, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1124349964, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"GAINESVILLE\", \"Pcp_Name\": \"CRYSTAL TERRILL\", \"PCP_Phone\": 7067767470, \"Pcp_State\": \"GA\", \"Member_City\": \"Hoschton\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Hoschton\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1961-06-26\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"725 JESSE JEWELL PKWY SE\", \"Screening_IHA\": \"No\", \"member_id_two\": 382329, \"Mailing_County\": \"JACKSON\", \"Member_Country\": \"JACKSON\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"169 Water Oak Trl\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30548, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"169 Water Oak Trl\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30548, \"Member_Last_name\": \"McDowell\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Susan\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"142, 21, 35.2, 36\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": \"4703672840\", \"Member_Identification_Number\": \"0006382105002\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:33:24\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:24\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-12-16T00:43\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-12-16T00:36\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T00:43\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [{\"date\": \"2024-07-02T13:59\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-07-11T15:16\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-07-15T18:40\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-07-19T13:32\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-07-02T13:59\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-15T18:40\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-19T13:32\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-15T05:46\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-16T00:43\"}]', '{\"utc\": [{\"date\": \"2024-07-16T14:48\", \"username\": null}, {\"date\": \"2024-07-31T16:26\", \"username\": null}, {\"date\": \"2024-09-06T16:23\", \"username\": null}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"06-21-2024\", \"time\": \"01:15:30\", \"value\": [{\"add\": \"169 Water Oak Trl\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1961-06-26\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4703672840, \"zip\": 30548, \"add2\": \"\", \"add3\": \"\", \"city\": \"Hoschton\", \"gend\": 1, \"insh\": \"0006382105002\", \"mzip\": 30548, \"name\": \"Susan McDowell\", \"plan\": \"Alliant\", \"pphy\": \"CRYSTAL TERRILL\", \"ppno\": 7067767470, \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"169 Water Oak Trl\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Hoschton\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"725 JESSE JEWELL PKWY SE\", \"pcpnpi\": 1124349964, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"GAINESVILLE\", \"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\": \"06-21-2024\", \"time\": \"01:15:30\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"06-21-2024 01:15:30\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/12/2024 @ 11:16 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/11/2024 @ 11:14 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/7/2024 @ 01:31 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 01:31 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 09:15 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"7/19/2024 @ 01:32 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"7/26/2024 @ 01:31 PM\"}, {\"date\": \"7/15/2024 @ 06:40 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"7/16/2024 @ 06:40 PM\"}, {\"date\": \"7/11/2024 @ 03:16 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"7/12/2024 @ 03:16 PM\"}, {\"date\": \"7/2/2024 @ 01:59 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"7/9/2024 @ 01:59 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"07-11-2024 15:16:00\", \"schedulerId\": \"84555898\", \"schedulerLeadId\": \"84555898\"}]}', '{\"date\": \"12-16-2024 00:43:59\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 9}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:34', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1734, NULL, NULL, NULL, '0006385727002', '402825', '', '543416', 'Karen', 'Cosper', '', '{\"DOB\": 23727, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Waco\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Waco\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1964-12-16\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 402825, \"Mailing_County\": \"CARROLL\", \"Member_Country\": \"CARROLL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1733 Old Highway 100\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30182, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1733 Old Highway 100\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30182, \"Member_Last_name\": \"Cosper\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Karen\", \"Member_Middle_name\": \"Lynn\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": \"7703631535\", \"Member_Identification_Number\": \"0006385727002\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"08-14-2024 00:00:20\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2024-08-14 00:00:20\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-06-14T19:23\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-18T17:42\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-21T12:57\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2024-06-29T15:18\", \"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-06-14T19:23\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-21T12:57\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-06-29T15:18\", \"reportStatus_date\": \"2024-06-29T15:18\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-06-29T15:18\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"06-21-2024\", \"time\": \"01:15:30\", \"value\": [{\"add\": \"1733 Old Highway 100\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1964-12-16\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7703631535, \"zip\": 30182, \"add2\": \"\", \"add3\": \"\", \"city\": \"Waco\", \"gend\": 1, \"insh\": \"0006385727002\", \"mzip\": 30182, \"name\": \"Karen Lynn Cosper\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"1733 Old Highway 100\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Waco\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"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\": \"06-21-2024\", \"time\": \"01:15:30\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"06-21-2024 01:15:30\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-06-29T15:18\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"6/29/2024 @ 03:18 PM\", \"result\": 9, \"comment\": \"Called to schedule Virtual HRA w HRA w/ Faith Enwefah or Deborah York - member states she has had an HRA before and is simply not interested\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}, {\"date\": \"6/21/2024 @ 12:57 PM\", \"result\": 3, \"comment\": \"06/21/2024 JC: called for HRA-Nykya Cox-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/28/2024 @ 12:57 PM\"}, {\"date\": \"6/18/2024 @ 05:42 PM\", \"result\": 3, \"comment\": \"06/18/2024 JC: called for HRA-Faith Enwefah-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/20/2024 @ 05:42 PM\"}, {\"date\": \"6/14/2024 @ 07:23 PM\", \"result\": 3, \"comment\": \"06/14/2024 JC: called for HRA-Faith Enwefah-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/17/2024 @ 07:23 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"06-14-2024 19:23:00\", \"schedulerId\": \"543416\", \"schedulerLeadId\": \"543416\"}]}', '{\"date\": \"04-22-2024 00:31:29\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 4}', NULL, 1, NULL, NULL, NULL, NULL, '2024-07-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:35', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1735, NULL, NULL, NULL, '0006387508001', '409554', '', '2661185', 'Alexandra', 'Wyatt', '', '{\"DOB\": 35165, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Eastanollee\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Eastanollee\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1996-04-10\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 409554, \"Mailing_County\": \"STEPHENS\", \"Member_Country\": \"STEPHENS\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1846 Rumsey Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30538, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1846 Rumsey Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30538, \"Member_Last_name\": \"Wyatt\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Alexandra\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"alexandra.mote@yahoo.com\", \"Member_Suspect_Codes\": 212, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7065996554, \"Member_Identification_Number\": \"0006387508001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:25\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:24\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [{\"date\": \"2024-05-13T19:06\", \"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-05-13T19:06\", \"reportStatus_date\": \"2024-05-13T19:06\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-05-13T19:06\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:00:35\", \"value\": [{\"add\": \"1846 Rumsey Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1996-04-10\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7065996554, \"zip\": 30538, \"add2\": \"\", \"add3\": \"\", \"city\": \"Eastanollee\", \"gend\": 1, \"insh\": \"0006387508001\", \"mzip\": 30538, \"name\": \"Alexandra Wyatt\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"alexandra.mote@yahoo.com\", \"ename\": \"\", \"madd1\": \"1846 Rumsey Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Eastanollee\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"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:54\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:54\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-05-13T19:06\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"5/13/2024 @ 07:06 PM\", \"result\": 9, \"comment\": \"Refusal, not interested in the HRA. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-13-2024 19:06:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"04-22-2024 00:31:29\", \"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 06:00:35', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1736, NULL, NULL, NULL, '0006387552001', '411071', '', '2661185', 'Dean', 'Wilkerson', '', '{\"DOB\": 21872, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Bonaire\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Bonaire\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1959-11-18\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 411071, \"Mailing_County\": \"HOUSTON\", \"Member_Country\": \"HOUSTON\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"105 Elmdale Cir\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 31005, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"105 Elmdale Cir\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31005, \"Member_Last_name\": \"Wilkerson\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Dean\", \"Member_Middle_name\": \"Ellis\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"dean.wilkerson12@gmail.com\", \"Member_Suspect_Codes\": \"130, 142, 20, 75\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4785425883, \"Member_Identification_Number\": \"0006387552001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:25\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:25\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-17T13:55\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-07-09T13:20\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-11T15:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-15T18:39\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-17T13:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-04-29T14:06\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-29T14:06\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-15T18:39\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-17T13:55\"}]', '{\"utc\": [{\"date\": \"2024-07-16T14:48\", \"username\": null}, {\"date\": \"2024-07-31T16:26\", \"username\": null}, {\"date\": \"2024-09-06T16:23\", \"username\": null}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:00:35\", \"value\": [{\"add\": \"105 Elmdale Cir\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1959-11-18\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4785425883, \"zip\": 31005, \"add2\": \"\", \"add3\": \"\", \"city\": \"Bonaire\", \"gend\": 0, \"insh\": \"0006387552001\", \"mzip\": 31005, \"name\": \"Dean Ellis Wilkerson\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"dean.wilkerson12@gmail.com\", \"ename\": \"\", \"madd1\": \"105 Elmdale Cir\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Bonaire\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"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:54\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:54\"}', 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 @ 03:02 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Faith Mailbox full.\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"8/20/2024 @ 11:24 AM\", \"result\": 3, \"comment\": \"Call attempt to schedule a F2F or virtual HRA w/ Faith Enwefah. - Mailbox Full. \", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"8/17/2024 @ 02:05 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Faith no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"7/31/2024 @ 05:50 PM\", \"result\": 3, \"comment\": \" Called to schedule HRA w/ DELISE ADAMS lvm. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/17/2024 @ 01:55 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/15/2024 @ 06:39 PM\", \"result\": 3, \"comment\": \"called to schedule HRA/with Debbie York LVM. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"7/26/2024 @ 06:38 PM\"}, {\"date\": \"7/11/2024 @ 03:17 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/Connie Middleton left Voicemail. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"7/29/2024 @ 03:16 PM\"}, {\"date\": \"7/9/2024 @ 01:20 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ FAITH ENWEFAH  OR w/ DELISE ADAMS \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"7/18/2024 @ 01:19 PM\"}, {\"date\": \"4/29/2024 @ 02:06 PM\", \"result\": 6, \"comment\": \"Call back, member wanted an e-mail regarding the appt since he hadn\'t received the letter yet and he said he would call us back. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/6/2024 @ 02:06 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-29-2024 14:06:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"07-17-2024 13:55:33\", \"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 06:00:35', 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
(1737, NULL, NULL, NULL, '0006389128001', '415285', '', '26056802', 'Amdrea', 'Sanchez', '', '{\"DOB\": 34241, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": null, \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Gainesville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gainesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1993-09-29\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 415285, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"5240 Trudy Cir\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30504, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"5240 Trudy Cir\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30504, \"Member_Last_name\": \"Sanchez\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Amdrea\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"\", \"Member_Email_Address\": \"amdreasanchez26@gmail.com\", \"Member_Suspect_Codes\": \"145, 146, 212\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7709906943, \"Member_Identification_Number\": \"0006389128001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 2, b'1', b'1', '{\"date\": \"11-01-2024 00:30:06\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2024-11-01 00:30:05\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-06-06T19:06\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [{\"date\": \"2024-05-13T10:33\", \"text\": \"F2F No Show\", \"method\": \"api\", \"status\": 24}], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-04-25T16:19\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-04-30T17:56\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-07-10T14:05\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-07-29T17:34\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-08-19T13:38\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [{\"date\": \"2024-10-31T13:59\", \"text\": \"Ineligible\", \"method\": \"api\", \"status\": 2}], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [{\"date\": \"2024-07-17T15:30\", \"text\": \"Virtual No Show\", \"method\": \"api\", \"status\": 23}, {\"date\": \"2024-08-02T16:17\", \"text\": \"Virtual No Show\", \"method\": \"api\", \"status\": 23}, {\"date\": \"2024-09-16T10:53\", \"text\": \"Virtual No Show\", \"method\": \"api\", \"status\": 23}], \"callBackRequested\": [{\"date\": \"2024-06-10T16:12\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-04-25T16:19\", \"reportStatus_date\": \"2024-04-25T16:19\"}, {\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 2, \"hraStatus_date\": \"2024-05-05T17:05\", \"reportStatus_date\": \"2024-04-30T17:56\"}, {\"text\": \"F2F No Show\", \"type\": \"ReportStatus\", \"status\": 24, \"hraStatus\": 19, \"hraStatus_date\": \"2024-05-13T10:33\", \"reportStatus_date\": \"2024-05-13T10:33\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-10T16:12\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-07-10T14:05\", \"reportStatus_date\": \"2024-07-10T14:05\"}, {\"text\": \"Virtual No Show\", \"type\": \"ReportStatus\", \"status\": 23, \"hraStatus\": 19, \"hraStatus_date\": \"2024-07-17T15:30\", \"reportStatus_date\": \"2024-07-17T15:30\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-07-29T17:34\", \"reportStatus_date\": \"2024-07-29T17:34\"}, {\"text\": \"Virtual No Show\", \"type\": \"ReportStatus\", \"status\": 23, \"hraStatus\": 19, \"hraStatus_date\": \"2024-08-02T16:17\", \"reportStatus_date\": \"2024-08-02T16:17\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-08-19T13:38\", \"reportStatus_date\": \"2024-08-19T13:38\"}, {\"text\": null, \"type\": \"HraStatus\", \"status\": null, \"hraStatus\": 2, \"hraStatus_date\": \"2024-09-03T13:22\", \"reportStatus_date\": null}, {\"text\": \"Virtual No Show\", \"type\": \"ReportStatus\", \"status\": 23, \"hraStatus\": 19, \"hraStatus_date\": \"2024-09-16T10:53\", \"reportStatus_date\": \"2024-09-16T10:53\"}, {\"text\": \"Ineligible\", \"type\": \"ReportStatus\", \"status\": 2, \"hraStatus\": 14, \"hraStatus_date\": \"2024-10-31T13:59\", \"reportStatus_date\": \"2024-10-31T13:59\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-05-13T10:33\", \"username\": \"PFrey1\"}, {\"date\": \"2024-07-17T15:30\", \"username\": null}, {\"date\": \"2024-08-02T16:17\", \"username\": \"TFerness2\"}, {\"date\": \"2024-09-16T10:53\", \"username\": \"TFerness2\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-04-25T16:19\", \"username\": null}, {\"date\": \"2024-04-25T16:19\", \"username\": null}, {\"date\": \"2024-04-30T17:56\", \"username\": null}, {\"date\": \"2024-07-10T14:05\", \"username\": null}, {\"date\": \"2024-07-10T14:05\", \"username\": null}, {\"date\": \"2024-07-29T17:34\", \"username\": null}, {\"date\": \"2024-07-29T17:34\", \"username\": null}, {\"date\": \"2024-08-19T13:38\", \"username\": null}, {\"date\": \"2024-08-19T13:38\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-05-05T17:05\", \"username\": \"DAdams\"}, {\"date\": \"2024-07-16T19:40\", \"username\": \"CMiddleton\"}, {\"date\": \"2024-09-03T13:22\", \"username\": \"DYork\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [{\"date\": \"2024-10-31T13:59\", \"username\": null}], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"05-05-2024\", \"time\": \"17:05:47\", \"value\": [{\"add\": \"5240 Trudy Cir\", \"age\": 30, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1993-09-29\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7709906943, \"zip\": 30504, \"add2\": \"\", \"add3\": \"\", \"city\": \"Gainesville\", \"gend\": 1, \"insh\": \"0006389128001\", \"mzip\": 30504, \"name\": \"Amdrea Sanchez\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"amdreasanchez26@gmail.com\", \"ename\": \"\", \"madd1\": \"5240 Trudy Cir\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gainesville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"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\": \"05-11-2024\", \"time\": \"03:24:54\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"09-03-2024 13:47:31\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2024-05-13T10:33\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"PFrey1\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}, {\"date\": \"2024-07-17T15:30\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": null, \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}, {\"date\": \"2024-08-02T16:17\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"TFerness2\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}, {\"date\": \"2024-09-16T10:53\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"TFerness2\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 2, \"callLog\": [{\"date\": \"10/31/2024 @ 01:59 PM\", \"result\": 2, \"comment\": \"called for HRA-Virtual - Nykya Cox-GA, RN,NP : Ineligible, member canceled her insurance\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Rocheline Lovaincy\", \"callbackDate\": \"\"}, {\"date\": \"8/19/2024 @ 01:38 PM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA with Debbie for 09/03/2024 @ 1:30PM sent text with appt information. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"7/29/2024 @ 05:34 PM\", \"result\": 0, \"comment\": \"Called member to schedule HRA w/ NP Jansen Helm member scheduled for 08/02/2024 at 11:30am.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/10/2024 @ 02:05 PM\", \"result\": 0, \"comment\": \"scheduled HRA  with connie on 7/17 at 110 text link to member\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"6/10/2024 @ 04:12 PM\", \"result\": 6, \"comment\": \"CALL BACK AND SCHEDULE FOR JULY F2F VISIT WITH DELISE MV \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"7/1/2024 @ 04:12 PM\"}, {\"date\": \"6/6/2024 @ 07:06 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"6/10/2024 @ 07:06 PM\"}, {\"date\": \"4/25/2024 @ 04:19 PM\", \"result\": 0, \"comment\": \"Scheduled F2F HRA w/ Delise Adams on 5/7 @ 1130AM\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0006389128001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"72903859\", \"memberId\": \"0006389128001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"72903859\", \"memberId\": \"0006389128001\", \"scheduleDate\": \"2024-9-3T13:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-25-2024 16:19:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}, {\"date\": \"05-13-2024 10:33:21\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}, {\"date\": \"07-17-2024 15:30:48\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}, {\"date\": \"08-02-2024 16:17:48\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}, {\"date\": \"09-16-2024 10:53:13\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"09-16-2024 10:53:13\", \"status\": 0, \"details\": \"scheduled member moved to no show/cancellation\", \"disabled\": false, \"notification\": {\"type\": 1, \"value\": \"\", \"previous_status\": 1}}', '{\"attemptCount\": 7}', NULL, 1, NULL, NULL, 'Virtual', NULL, '2024-10-18', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:36', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1738, NULL, NULL, NULL, '0006390058001', '410229', '', '2661185', 'CRYSTAL', 'TOLBERT', '', '{\"DOB\": 31175, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"JAKIN\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"JAKIN\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1985-05-08\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 410229, \"Mailing_County\": \"EARLY\", \"Member_Country\": \"EARLY\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"186 MASONIC RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 39861, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"186 MASONIC RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 39861, \"Member_Last_name\": \"TOLBERT\", \"Medication_Review\": \"N\", \"Member_first_name\": \"CRYSTAL\", \"Member_Middle_name\": \"L\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"TOLBERT.CRYSTAL.58@GMAIL.COM\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 2295268188, \"Member_Identification_Number\": \"0006390058001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:33:25\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:25\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-13T19:07\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-17T13:01\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-20T18:03\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-29T15:24\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-07-02T18:49\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-13T19:07\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-20T18:03\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-29T15:24\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-02T18:49\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-15T05:41\"}]', '{\"utc\": [{\"date\": \"2024-07-16T14:48\", \"username\": null}, {\"date\": \"2024-07-31T16:26\", \"username\": null}, {\"date\": \"2024-09-06T16:23\", \"username\": null}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:00:36\", \"value\": [{\"add\": \"186 MASONIC RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1985-05-08\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 2295268188, \"zip\": 39861, \"add2\": \"\", \"add3\": \"\", \"city\": \"JAKIN\", \"gend\": 1, \"insh\": \"0006390058001\", \"mzip\": 39861, \"name\": \"CRYSTAL L TOLBERT\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"TOLBERT.CRYSTAL.58@GMAIL.COM\", \"ename\": \"\", \"madd1\": \"186 MASONIC RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"JAKIN\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"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:54\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:54\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/12/2024 @ 11:17 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/11/2024 @ 11:14 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/7/2024 @ 01:31 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 01:32 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 09:24 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"7/2/2024 @ 06:49 PM\", \"result\": 6, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"7/3/2024 @ 12:00 PM\"}, {\"date\": \"6/29/2024 @ 03:23 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w HRA w/ Faith Enwefah or Deborah York \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"7/6/2024 @ 03:23 PM\"}, {\"date\": \"5/20/2024 @ 06:03 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Faith Enwefah - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/27/2024 @ 06:03 PM\"}, {\"date\": \"5/17/2024 @ 01:01 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/20/2024 @ 01:01 PM\"}, {\"date\": \"5/13/2024 @ 07:07 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/14/2024 @ 07:07 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-13-2024 19:07:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"11-15-2024 05:41:27\", \"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 06:00:36', 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
(1739, 55499828, 44829497, '96917241', '0006392460001', '415661', '', '2661185', 'Walter', 'Wilson', '', '{\"DOB\": 34144, \"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\": \"31210\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"Macon\", \"Pcp_Name\": \"Ashwini Gore\", \"PCP_Phone\": \"4787468626\", \"Member_City\": \"Bonaire\", \"Office_Name\": \"The Jones Center\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Bonaire\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1993-06-24\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"265 Sheraton Blvd Ste 100 \", \"Screening_IHA\": \"No\", \"member_id_two\": 415661, \"Mailing_County\": \"HOUSTON\", \"Member_Country\": \"HOUSTON\", \"PCP_Fax_Number\": \"4787460491\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"510 Wrasling Way\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 31005, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"510 Wrasling Way\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31005, \"Member_Last_name\": \"Wilson\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Walter\", \"Member_Middle_name\": \"Jacob\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"wilson.j62493@yahoo.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 4789526824, \"Member_Identification_Number\": \"0006392460001\", \"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:13:16\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-06-18 23:13:16\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-29T14:12\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-06-14T18:10\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-06-17T11:30\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-06-17T14:23\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-06-18T23:13\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-06-06T14:59\", \"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-04-29T14:12\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-06-06T14:59\", \"reportStatus_date\": \"2024-06-06T14:59\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-06-17T14:23\", \"reportStatus_date\": \"2024-06-17T14:23\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-06-18T23:13\", \"reportStatus_date\": \"2024-06-18T23:13\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-06-18T23:13\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-06-06T14:59\", \"username\": null}, {\"date\": \"2024-06-06T14:59\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-06-14T16:53\", \"username\": \"NCox\"}], \"qaAssigned\": [{\"date\": \"2024-06-17T09:28\", \"username\": \"JScanlonQAL\"}], \"readyForQa\": [{\"date\": \"2024-06-14T18:10\", \"username\": \"NCox\"}, {\"date\": \"2024-06-14T18:10\", \"username\": \"NCox\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-06-17T14:23\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-06-17T11:30\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-06-17T14:23\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"07-17-2024\", \"time\": \"15:45:59\", \"value\": [{\"add\": \"510 Wrasling Way\", \"age\": 31, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1993-06-24\", \"eno\": \"4789193553\", \"lob\": \"On Exchange\", \"pno\": 4789526824, \"zip\": 31005, \"add2\": \"\", \"add3\": \"\", \"city\": \"Bonaire\", \"gend\": 0, \"insh\": \"0006392460001\", \"mzip\": 31005, \"name\": \"Walter Jacob Wilson\", \"plan\": \"Alliant\", \"pphy\": \"Ashwini Gore\", \"ppno\": \"4787468626\", \"race\": \"\", \"cliId\": \"\", \"email\": \"wilson.j62493@yahoo.com\", \"ename\": \"Faye Bradshaw \", \"madd1\": \"510 Wrasling Way\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Bonaire\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"265 Sheraton Blvd Ste 100 \", \"pcpnpi\": \"\", \"pcpzip\": \"31210\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Single\", \"pcpcity\": \"Macon\", \"pcpname\": \"The Jones Center\", \"program\": \"ACA\", \"evalDate\": \"2024-6-14 4:50 PM\", \"evalName\": \"Nykya Cox, FNP\", \"pcpfaxno\": \"4787460491\", \"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\": \"06-14-2024\", \"time\": \"16:53:39\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"07-17-2024 15:45:59\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"6/6/2024 @ 02:59 PM\", \"result\": 0, \"comment\": \"Scheduled virtual HRA W/ NYKYA C ON 6/14 @ 4:50 - texted link to member\'s phone. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"4/29/2024 @ 02:12 PM\", \"result\": 13, \"comment\": \"Caller disconnected during me telling him about what the HRA is. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"4/30/2024 @ 02:12 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0006392460001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"96917241\", \"memberId\": \"0006392460001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"96917241\", \"memberId\": \"0006392460001\", \"scheduleDate\": \"2024-6-14T16:50\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-29-2024 14:12:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"06-06-2024 14:59:54\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 0, NULL, '[{\"date\": \"2024-06-18 23:13:14\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"de00f8b7-2de9-11ef-989e-4f1504a8c686\\\",\\\"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-6-14T16:50', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:36', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006392460001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0006392460001_Wilson, Walter_06142024.pdf\", \"ftp_upload_date\": \"2024-06-18 23:13:14\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Gore, Ashwini_0006392460001_06142024.pdf\"}', 'ACA_0006392460001_Wilson, Walter_06142024', NULL, 'PCP_Gore, Ashwini_0006392460001_06142024', NULL, '[{\"date\": \"2024-06-14T22:10:20.391Z\", \"signature\": \"data:image/png;base64,[encoded data, 25492 characters]\"}]', '2024-06-14T17:35', 'Member_Summary_0006392460001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006392460001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0006392460001.pdf\", \"member_ftp_upload_date\": \"2024-06-18 23:13:16\"}', NULL, NULL, NULL, NULL),
(1740, NULL, NULL, NULL, '0006394643001', '408660', '', '21881792', 'Melissa', 'Spence', '', '{\"DOB\": 22051, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Bowdon\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Bowdon\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1960-05-15\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 408660, \"Mailing_County\": \"CARROLL\", \"Member_Country\": \"CARROLL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1346 N Highway 100\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30108, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1346 N Highway 100\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30108, \"Member_Last_name\": \"Spence\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Melissa\", \"Member_Middle_name\": \"R\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"melissa.spence25@yahoo.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7704908651, \"Member_Identification_Number\": \"0006394643001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:25\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:25\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-06-21T19:40\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-30T09:16\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-06T15:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-13T12:41\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-17T13:54\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-21T19:40\", \"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-06T15:55\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-17T13:54\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-21T19:40\"}]', '{\"utc\": [{\"date\": \"2024-07-16T14:48\", \"username\": null}, {\"date\": \"2024-07-31T16:26\", \"username\": null}, {\"date\": \"2024-09-06T16:23\", \"username\": null}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:00:36\", \"value\": [{\"add\": \"1346 N Highway 100\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1960-05-15\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7704908651, \"zip\": 30108, \"add2\": \"\", \"add3\": \"\", \"city\": \"Bowdon\", \"gend\": 1, \"insh\": \"0006394643001\", \"mzip\": 30108, \"name\": \"Melissa R Spence\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"melissa.spence25@yahoo.com\", \"ename\": \"\", \"madd1\": \"1346 N Highway 100\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Bowdon\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"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:54\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:54\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/31/2024 @ 09:31 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/30/2024 @ 09:25 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/28/2024 @ 04:42 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"8/31/2024 @ 03:18 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:31 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Faith no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"6/21/2024 @ 07:40 PM\", \"result\": 3, \"comment\": \"06/21/2024 JC: called for HRA-Nykya Cox-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"6/17/2024 @ 01:54 PM\", \"result\": 13, \"comment\": \"CALLER DISCONNECTED the call prior to and/or after greeting. Call attempt to schedule virtual HRA.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/18/2024 @ 01:54 PM\"}, {\"date\": \"6/13/2024 @ 12:41 PM\", \"result\": 13, \"comment\": \"CALLER DISCONNECTED the call prior to and/or after greeting.  Call attempt to schedule virtual HRA. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/14/2024 @ 12:41 PM\"}, {\"date\": \"5/6/2024 @ 03:55 PM\", \"result\": 13, \"comment\": \"CALLER DISCONNECTED THE CALL PRIOR TO GREETING.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/10/2024 @ 03:55 PM\"}, {\"date\": \"4/30/2024 @ 09:16 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/1/2024 @ 09:16 AM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-30-2024 09:16:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"06-21-2024 19:40:03\", \"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 06:00:36', 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
(1741, 57818338, 44829497, '56716210', '0006396675001', '397904', '', '21881792', 'Cidalia', 'Villarreal', '', '{\"DOB\": 21892, \"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\": 1326210899, \"Pcp_Zip\": \"30528\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"Cleveland\", \"Pcp_Name\": \"Haroon Mian \", \"PCP_Phone\": \"709697510\", \"Pcp_State\": \"GA\", \"Member_City\": \"Gainesville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gainesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1959-12-08\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"17 White St.\", \"Screening_IHA\": \"No\", \"member_id_two\": 397904, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"7063487791\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"3207 Joe Parker Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30507, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"3207 Joe Parker Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30507, \"Member_Last_name\": \"Villarreal\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Cidalia\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"none\", \"Member_Suspect_Codes\": \"20, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 4703545100, \"Member_Identification_Number\": \"0006396675001\", \"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:13:24\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-06-18 23:13:24\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-15T16:49\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-29T10:24\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-06-13T23:55\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-06-18T15:55\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-06-18T18:06\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-06-18T23:13\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-06-10T16:29\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-04-25T15:47\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-25T15:47\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-15T16:49\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-29T10:24\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-06-10T16:29\", \"reportStatus_date\": \"2024-06-10T16:29\"}, {\"text\": \"Completed\", \"type\": \"HraStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-06-17T19:35\", \"reportStatus_date\": \"2024-06-13T23:55\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-06-18T23:13\", \"reportStatus_date\": \"2024-06-18T23:13\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-06-18T23:13\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-06-10T16:29\", \"username\": null}, {\"date\": \"2024-06-10T16:29\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-06-12T23:54\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-06-14T08:37\", \"username\": \"JScanlonQAL\"}], \"readyForQa\": [{\"date\": \"2024-06-13T23:55\", \"username\": \"DAdams\"}, {\"date\": \"2024-06-13T23:55\", \"username\": \"DAdams\"}, {\"date\": \"2024-06-15T09:14\", \"username\": \"JSilverio\"}, {\"date\": \"2024-06-17T08:17\", \"username\": \"JSilverio\"}, {\"date\": \"2024-06-17T08:20\", \"username\": \"JSilverio\"}, {\"date\": \"2024-06-17T08:23\", \"username\": \"JSilverio\"}, {\"date\": \"2024-06-17T19:35\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-06-18T18:06\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-06-18T15:55\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-06-18T18:06\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-06-17T09:17\", \"username\": \"JSilverio\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"07-17-2024\", \"time\": \"15:55:29\", \"value\": [{\"add\": \"3207 Joe Parker Rd\", \"age\": 64, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1959-12-08\", \"eno\": \"4708460400\", \"lob\": \"On Exchange\", \"pno\": 4703545100, \"zip\": 30507, \"add2\": \"\", \"add3\": \"\", \"city\": \"Gainesville\", \"gend\": 1, \"insh\": \"0006396675001\", \"mzip\": 30507, \"name\": \"Cidalia Villarreal\", \"plan\": \"Alliant\", \"pphy\": \"Haroon Mian \", \"ppno\": \"709697510\", \"race\": \"\", \"cliId\": \"\", \"email\": \"none\", \"ename\": \"Luis Villarreal\", \"madd1\": \"3207 Joe Parker Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gainesville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"17 White St.\", \"pcpnpi\": 1326210899, \"pcpzip\": \"30528\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Widowed\", \"pcpcity\": \"Cleveland\", \"pcpname\": \"\", \"program\": \"ACA\", \"evalDate\": \"2024-06-13 09:45 PM\", \"evalName\": \"Delise Adams, FNP\", \"pcpfaxno\": \"7063487791\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Female\", \"pphycomment\": \"Medlink E. Aldaco\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"\", \"1\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\", \"\", \"\", \"\", \"\"]], \"comment\": [[\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]]}, \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"06-12-2024\", \"time\": \"23:54:58\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"07-17-2024 15:55:29\"}', NULL, NULL, '{\"memberId\": \"0006396675001\", \"clinician\": \"Delise Adams\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Sat, 15 Jun 2024 13:14:53 GMT\", \"name\": \"JSilverio\", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"1.  AOD Neuropsych    \", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 17 Jun 2024 12:23:04 GMT\", \"name\": \"JSilverio\", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"1.  AOD Neuropsych med list reports insomnia please add.\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 17 Jun 2024 13:17:49 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"1.\\t AOD Neuropsych Med list reports insomnia please add.\\n2.\\t Vital Signs BP 160/90 was this discussed with the member?  Please add comment.\\nShould this issue be added to the case management referral you sent?\\n3.\\t  Vital signs BMI obesity.  Should this issue be added to the case management referral you sent?\\n4.\\tHome Safety TUG score 18 I see that the member has PT scheduled do you think this issue should be added to the case management referral you sent also?\\n5.\\tExam Review cardiovascular Bilateral carotid bruit is reported.  Is this something the member is aware of?  Please add comment.  Should this issue be added to the case management referral you sent?\\n6.\\tExam review reports gait is abnormal.. Home safety TUG reports the gait is normal.  Please correct.\\n7.\\tHome Safety questions E and G are N/A please add comment why they are N/A.\\n8.\\tWas member educated about home safety?\\nThanks\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 17 Jun 2024 23:35:47 GMT\", \"name\": \"Delise \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Added. Thank you.\"}, \"mailId\": \"\"}], \"memberName\": \"Cidalia Villarreal\", \"codingAnalyst\": \"\", \"dateOfService\": \"06/13/2024 09:45 PM\", \"clinicianMailId\": \"deliseadams@sbcglobal.net\", \"qaAnalystMailId\": \"j.silverio@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"6/10/2024 @ 04:29 PM\", \"result\": 0, \"comment\": \"SCHEDULED F2F VISIT WITH DELISE ON 6/13 AT 9:45 AM MV \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"\"}, {\"date\": \"5/29/2024 @ 10:24 AM\", \"result\": 3, \"comment\": \"INTERPRETER - DANNY 16172 - Left a voicemail. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/30/2024 @ 10:23 AM\"}, {\"date\": \"5/15/2024 @ 04:49 PM\", \"result\": 13, \"comment\": \"Caller disconnected after asking for member. Used interpreter services to place call. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/17/2024 @ 04:49 PM\"}, {\"date\": \"4/25/2024 @ 03:47 PM\", \"result\": 6, \"comment\": \"LS First call attempt 4/24/2024\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Patty Frey\", \"callbackDate\": \"5/30/2024 @ 03:46 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0006396675001\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"56716210\", \"memberId\": \"0006396675001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"56716210\", \"memberId\": \"0006396675001\", \"scheduleDate\": \"2024-6-13T21:45\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-15-2024 16:49:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"06-10-2024 16:29:53\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 4}', NULL, 0, NULL, '[{\"date\": \"2024-06-18 23:13:22\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"e25ab54e-2de9-11ef-ba6f-1d075f0fa3af\\\",\\\"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-13T21:45', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:37', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006396675001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0006396675001_Villarreal, Cidalia_06132024.pdf\", \"ftp_upload_date\": \"2024-06-18 23:13:21\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_, Haroon Mian_0006396675001_06132024.pdf\"}', 'ACA_0006396675001_Villarreal, Cidalia_06132024', NULL, 'PCP_, Haroon Mian_0006396675001_06132024', NULL, '[{\"date\": \"2024-06-14T03:55:06.456Z\", \"signature\": \"data:image/png;base64,[encoded data, 23520 characters]\"}, {\"date\": \"2024-06-17T23:35:46.923Z\", \"signature\": \"data:image/png;base64,[encoded data, 23484 characters]\"}]', '2024-06-13T11:15', 'Member_Summary_0006396675001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006396675001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0006396675001.pdf\", \"member_ftp_upload_date\": \"2024-06-18 23:13:23\"}', 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
(1742, NULL, NULL, NULL, '0006397730001', '389160', '', '2661185', 'Blake', 'Buchanan', '', '{\"DOB\": 35364, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1528588142, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"DOUGLAS\", \"Pcp_Name\": \"JACOB ABRAHAM\", \"PCP_Phone\": 9123844024, \"Pcp_State\": \"GA\", \"Member_City\": \"Willacoochee\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Willacoochee\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1996-10-26\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"200 DOCTORS DR STE K\", \"Screening_IHA\": \"No\", \"member_id_two\": 389160, \"Mailing_County\": \"ATKINSON\", \"Member_Country\": \"ATKINSON\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"7017 willacoochee hwy\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 31650, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"7017 willacoochee hwy\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31650, \"Member_Last_name\": \"Buchanan\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Blake\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": 120, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 9122928806, \"Member_Identification_Number\": \"0006397730001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:25\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:25\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-08-19T13:35\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-13T19:09\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-19T13:35\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [{\"date\": \"2024-05-17T13:03\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-05-20T18:06\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-07-02T14:19\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-07-03T13:12\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-07-17T13:57\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-07-31T17:51\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-13T19:09\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-20T18:06\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-03T13:12\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-17T13:57\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-31T17:51\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-19T13:35\"}]', '{\"utc\": [{\"date\": \"2024-07-16T14:48\", \"username\": null}, {\"date\": \"2024-07-31T16:26\", \"username\": null}, {\"date\": \"2024-09-06T16:23\", \"username\": null}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:00:37\", \"value\": [{\"add\": \"7017 willacoochee hwy\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1996-10-26\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 9122928806, \"zip\": 31650, \"add2\": \"\", \"add3\": \"\", \"city\": \"Willacoochee\", \"gend\": 0, \"insh\": \"0006397730001\", \"mzip\": 31650, \"name\": \"Blake Buchanan\", \"plan\": \"Alliant\", \"pphy\": \"JACOB ABRAHAM\", \"ppno\": 9123844024, \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"7017 willacoochee hwy\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Willacoochee\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"200 DOCTORS DR STE K\", \"pcpnpi\": 1528588142, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"DOUGLAS\", \"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:54\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:54\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/13/2024 @ 12:19 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/12/2024 @ 12:05 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/11/2024 @ 11:42 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/7/2024 @ 07:34 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 06:16 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"8/19/2024 @ 01:35 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA with Connie Middleton NO VM SETUP \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"\"}, {\"date\": \"7/31/2024 @ 05:51 PM\", \"result\": 10, \"comment\": \"Called to schedule HRA w/ DELISE ADAMS LINE DISCONNECTED.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/17/2024 @ 01:57 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/3/2024 @ 01:12 PM\", \"result\": 10, \"comment\": \"Called to schedule HRA w/ Faith Enwefah\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/2/2024 @ 02:19 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"7/9/2024 @ 02:19 PM\"}, {\"date\": \"5/20/2024 @ 06:06 PM\", \"result\": 10, \"comment\": \"Called to schedule Virtual HRA w/ Faith Enwefah - Disconnected\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/27/2024 @ 06:06 PM\"}, {\"date\": \"5/17/2024 @ 01:03 PM\", \"result\": 10, \"comment\": \"Called to schedule Virtual HRA w/ Faith Enwefah -Disconnected\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/24/2024 @ 01:03 PM\"}, {\"date\": \"5/13/2024 @ 07:09 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/14/2024 @ 07:09 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-13-2024 19:09:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"08-19-2024 13:35:31\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 13}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:37', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1743, NULL, NULL, NULL, '0006398669001', '420153', '', '2661185', 'BRANDIE', 'STARR', '', '{\"DOB\": 27148, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Forsyth\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Forsyth\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1974-04-29\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 420153, \"Mailing_County\": \"MONROE\", \"Member_Country\": \"MONROE\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"56 Reedy Creek Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 31029, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"56 Reedy Creek Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31029, \"Member_Last_name\": \"STARR\", \"Medication_Review\": \"N\", \"Member_first_name\": \"BRANDIE\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"BRANDIEDSTARR@GMAIL.COM\", \"Member_Suspect_Codes\": \"161.2, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7705844996, \"Member_Identification_Number\": \"0006398669001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:25\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:25\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-02T18:50\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-29T12:31\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-06T16:40\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-12T17:08\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-15T17:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-02T18:50\", \"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-04-29T12:31\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-06T16:40\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-15T17:55\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-02T18:50\"}]', '{\"utc\": [{\"date\": \"2024-07-16T14:48\", \"username\": null}, {\"date\": \"2024-07-31T16:26\", \"username\": null}, {\"date\": \"2024-09-06T16:23\", \"username\": null}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:00:37\", \"value\": [{\"add\": \"56 Reedy Creek Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1974-04-29\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7705844996, \"zip\": 31029, \"add2\": \"\", \"add3\": \"\", \"city\": \"Forsyth\", \"gend\": 1, \"insh\": \"0006398669001\", \"mzip\": 31029, \"name\": \"BRANDIE STARR\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"BRANDIEDSTARR@GMAIL.COM\", \"ename\": \"\", \"madd1\": \"56 Reedy Creek Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Forsyth\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"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:54\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:54\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/31/2024 @ 09:33 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/6/2024 @ 05:06 PM\", \"result\": 3, \"comment\": \"attempt to sched virtual appt w/Nykya Cox\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"7/31/2024 @ 05:52 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ DELISE ADAMS lvm. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/17/2024 @ 01:59 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/2/2024 @ 06:50 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"6/15/2024 @ 05:55 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Delise Adams or Faith Enwefah \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/21/2024 @ 05:55 PM\"}, {\"date\": \"6/12/2024 @ 05:08 PM\", \"result\": 3, \"comment\": \"06/12/2024 JC: called for HRA-Nykya Cox-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/18/2024 @ 05:07 PM\"}, {\"date\": \"6/6/2024 @ 04:40 PM\", \"result\": 3, \"comment\": \"CALLER DISCONNECTED THE CALL VIRTUAL VISIT WITH DEBORAH YORK ON 6/11 MV \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"6/11/2024 @ 04:40 PM\"}, {\"date\": \"4/29/2024 @ 12:31 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"4/30/2024 @ 12:31 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-29-2024 12:31:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"07-02-2024 18:50:05\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 9}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:37', 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
(1744, 50892900, 44829497, '62685179', '0006400830001', '406133', '', '21881792', 'Dorothy', 'McKinney', '', '{\"DOB\": 22002, \"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\": \"30180\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"VILLA RICA\", \"Pcp_Name\": \"Dr. Virgina Price\", \"PCP_Phone\": \"770 459 4411\", \"Member_City\": \"Villa Rica\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Villa Rica\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1960-03-27\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"705 DALLAS HWY STE 101\", \"Screening_IHA\": \"No\", \"member_id_two\": 406133, \"Mailing_County\": \"CARROLL\", \"Member_Country\": \"CARROLL\", \"PCP_Fax_Number\": \"7704591896\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"104 Alton Cir\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30180, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"104 Alton Cir\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30180, \"Member_Last_name\": \"McKinney\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Dorothy\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"dotsweets27@yahoo.com\", \"Member_Suspect_Codes\": \"115, 161.1, 21, 88\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 6787686228, \"Member_Identification_Number\": \"0006400830001\", \"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:35:56\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-05-31 14:35:56\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-05-04T15:03\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-08T14:02\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-09T10:14\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-31T14:35\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-04-29T11:45\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-05-02T11:32\", \"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-29T11:45\", \"reportStatus_date\": \"2024-04-29T11:45\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-05-04T15:03\", \"reportStatus_date\": \"2024-05-04T15:03\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-05-09T10:14\", \"reportStatus_date\": \"2024-05-09T10:14\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-05-31T14:35\", \"reportStatus_date\": \"2024-05-31T14:35\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-05-31T14:35\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-04-29T11:45\", \"username\": null}, {\"date\": \"2024-04-29T11:45\", \"username\": null}, {\"date\": \"2024-05-02T11:32\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-05-03T06:26\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [{\"date\": \"2024-05-06T09:50\", \"username\": \"JScanlonQAL\"}], \"readyForQa\": [{\"date\": \"2024-05-04T15:03\", \"username\": \"FEnwefah\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-05-09T10:14\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-05-08T14:02\", \"username\": \"fcopeland1\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-05-09T10:14\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"07-01-2024\", \"time\": \"11:58:07\", \"value\": [{\"add\": \"104 Alton Cir\", \"age\": 64, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1960-03-27\", \"eno\": \"980 3225208\", \"lob\": \"On Exchange\", \"pno\": 6787686228, \"zip\": 30180, \"add2\": \"\", \"add3\": \"\", \"city\": \"Villa Rica\", \"gend\": 1, \"insh\": \"0006400830001\", \"mzip\": 30180, \"name\": \"Dorothy McKinney\", \"plan\": \"Alliant\", \"pphy\": \"Dr. Virgina Price\", \"ppno\": \"770 459 4411\", \"cliId\": \"\", \"email\": \"dotsweets27@yahoo.com\", \"ename\": \"Michael Sweat\", \"madd1\": \"104 Alton Cir\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Villa Rica\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"705 DALLAS HWY STE 101\", \"pcpnpi\": \"Added\", \"pcpzip\": \"30180\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Single\", \"pcpcity\": \"VILLA RICA\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"7704591896\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Female\", \"pphycomment\": \"added\", \"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:54\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"07-01-2024 11:58:07\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"4/29/2024 @ 11:45 AM\", \"result\": 0, \"comment\": \"SCHEDULED F.E. ON 5/3 @ 1:30. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0006400830001\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"62685179\", \"memberId\": \"0006400830001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"62685179\", \"memberId\": \"0006400830001\", \"scheduleDate\": \"2024-5-3T13:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-29-2024 11:45:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"05-02-2024 11:32:27\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2024-05-31 14:35:53\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"9cb81518-1f7c-11ef-851b-d7227b9e0d64\\\",\\\"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-3T14:00', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:38', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006400830001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0006400830001_McKinney, Dorothy_05032024.pdf\", \"ftp_upload_date\": \"2024-05-31 14:35:53\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Price, Virgina_0006400830001_05032024.pdf\"}', 'ACA_0006400830001_McKinney, Dorothy_05032024', NULL, 'PCP_Price, Virgina_0006400830001_05032024', NULL, '[{\"date\": \"2024-05-04T19:03:57.489Z\", \"signature\": \"data:image/png;base64,[encoded data, 23388 characters]\"}]', '2024-05-03T15:00', 'Member_Summary_0006400830001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006400830001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0006400830001.pdf\", \"member_ftp_upload_date\": \"2024-05-31 14:35:55\"}', NULL, NULL, NULL, NULL),
(1745, NULL, NULL, NULL, '0006402170001', '383029', '', '2661185', 'Ruby', 'gilbert', '', '{\"DOB\": 24954, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1710979331, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"TOCCOA\", \"Pcp_Name\": \"Todd Bethea\", \"PCP_Phone\": 7702197777, \"Pcp_State\": \"GA\", \"Member_City\": \"Lula\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Lula\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1968-04-26\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"58 BIG A RD\", \"Screening_IHA\": \"No\", \"member_id_two\": 383029, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"9270 Morrison Road\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30554, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"9270 Morrison Road\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30554, \"Member_Last_name\": \"gilbert\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Ruby\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"rubygilbert909@yahoo.com\", \"Member_Suspect_Codes\": \"20, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6789360143, \"Member_Identification_Number\": \"0006402170001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:25\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:25\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-11T15:19\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-01T17:53\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-14T12:12\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-10T14:06\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-11T15:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-05-21T17:13\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-01T17:53\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-14T12:12\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-21T17:13\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-11T15:19\"}]', '{\"utc\": [{\"date\": \"2024-07-16T14:48\", \"username\": null}, {\"date\": \"2024-07-31T16:26\", \"username\": null}, {\"date\": \"2024-09-06T16:23\", \"username\": null}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:00:38\", \"value\": [{\"add\": \"9270 Morrison Road\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1968-04-26\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6789360143, \"zip\": 30554, \"add2\": \"\", \"add3\": \"\", \"city\": \"Lula\", \"gend\": 1, \"insh\": \"0006402170001\", \"mzip\": 30554, \"name\": \"Ruby gilbert\", \"plan\": \"Alliant\", \"pphy\": \"Todd Bethea\", \"ppno\": 7702197777, \"cliId\": \"\", \"email\": \"rubygilbert909@yahoo.com\", \"ename\": \"\", \"madd1\": \"9270 Morrison Road\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Lula\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"58 BIG A RD\", \"pcpnpi\": 1710979331, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"TOCCOA\", \"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:55\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:55\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/7/2024 @ 02:01 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 01:55 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 10:46 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/9/2024 @ 02:24 PM\", \"result\": 3, \"comment\": \" CALLER DISCONNECTED -Caller answered the call prior to greeting and disconnected the call.  Call attempt to schedule a F2F or a virtual HRA w/Debbie \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Alyia Williams\", \"callbackDate\": \"\"}, {\"date\": \"7/29/2024 @ 05:40 PM\", \"result\": 3, \"comment\": \"07/29/2024 JC: called for HRA-Delise Adams-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"7/11/2024 @ 03:19 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/10/2024 @ 02:06 PM\", \"result\": 3, \"comment\": \"07/10/2024 MB:: called for HRA-Nykya-Virtual: LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mariana Bernard\", \"callbackDate\": \"7/17/2024 @ 02:06 PM\"}, {\"date\": \"5/21/2024 @ 05:13 PM\", \"result\": 6, \"comment\": \"Member goes by Denise!! She wasn\'t able to schedule at the moment but is interested. She has a busy schedule and would prefer an evening appt. She would like a call back for JUNE availability. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/28/2024 @ 05:13 PM\"}, {\"date\": \"5/14/2024 @ 12:12 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL -Call attempt to schedule HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/17/2024 @ 12:12 PM\"}, {\"date\": \"5/1/2024 @ 05:53 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/2/2024 @ 05:53 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-01-2024 17:53:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"07-11-2024 15:19:16\", \"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 06:00:38', 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
(1746, NULL, NULL, NULL, '0006404405001', '404500', '', '26056802', 'Kate', 'Javors', '', '{\"DOB\": 32876, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Commerce\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Commerce\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1990-01-03\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 404500, \"Mailing_County\": \"JACKSON\", \"Member_Country\": \"JACKSON\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"50 PRESTON CT\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30529, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"50 PRESTON CT\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30529, \"Member_Last_name\": \"Javors\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Kate\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"kati.javors@gmail.com\", \"Member_Suspect_Codes\": 88, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7708719233, \"Member_Identification_Number\": \"0006404405001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:33:25\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:25\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-29T18:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-13T10:50\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-20T13:37\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [{\"date\": \"2024-06-25T16:13\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-07-08T14:15\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-08-19T17:07\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-29T18:05\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-13T10:50\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-20T13:37\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-25T16:13\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-08T14:15\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-19T17:07\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:36\"}]', '{\"utc\": [{\"date\": \"2024-07-16T14:48\", \"username\": null}, {\"date\": \"2024-07-31T16:26\", \"username\": null}, {\"date\": \"2024-09-06T16:23\", \"username\": null}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:00:38\", \"value\": [{\"add\": \"50 PRESTON CT\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1990-01-03\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7708719233, \"zip\": 30529, \"add2\": \"\", \"add3\": \"\", \"city\": \"Commerce\", \"gend\": 1, \"insh\": \"0006404405001\", \"mzip\": 30529, \"name\": \"Kate Javors\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"kati.javors@gmail.com\", \"ename\": \"\", \"madd1\": \"50 PRESTON CT\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Commerce\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"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:55\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:55\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/6/2024 @ 12:44 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 02:54 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/31/2024 @ 02:47 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/30/2024 @ 02:23 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/29/2024 @ 02:08 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"8/19/2024 @ 05:07 PM\", \"result\": 10, \"comment\": \"Called to Schedule Virtual HRA with Debbie number disconnected.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"7/8/2024 @ 02:15 PM\", \"result\": 10, \"comment\": \"DISCONNECTED - Members primary number no longer in service.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"6/25/2024 @ 04:13 PM\", \"result\": 10, \"comment\": \"DISCONNECTED VIRTUAL VISIT WITH FAITH \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"6/28/2024 @ 04:13 PM\"}, {\"date\": \"6/20/2024 @ 01:37 PM\", \"result\": 3, \"comment\": \"LVM VIRTUAL VISIT WITH DEBBIE MV \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"6/24/2024 @ 01:37 PM\"}, {\"date\": \"5/13/2024 @ 10:50 AM\", \"result\": 3, \"comment\": \"MAILBOX FULL - UNABLE TO LEAVE MESSAGE.\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/16/2024 @ 10:50 AM\"}, {\"date\": \"4/29/2024 @ 06:05 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Sallie Key - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/13/2024 @ 06:05 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-29-2024 18:05:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"11-11-2024 00:36:07\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 11}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:38', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1747, NULL, NULL, NULL, '0006405911001', '414687', '', '21881792', 'Crystal', 'Giddens', '', '{\"DOB\": 31929, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Villa Rica\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Villa Rica\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1987-06-01\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 414687, \"Mailing_County\": \"CARROLL\", \"Member_Country\": \"CARROLL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"43 Community Square Blvd Unit 1059\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30180, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"43 Community Square Blvd Unit 1059\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30180, \"Member_Last_name\": \"Giddens\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Crystal\", \"Member_Middle_name\": \"Nicole\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4045870040, \"Member_Identification_Number\": \"0006405911001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:26\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:25\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [{\"date\": \"2024-04-29T11:53\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}, {\"date\": \"2024-08-26T11:42\", \"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-29T11:53\", \"reportStatus_date\": \"2024-04-29T11:53\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-08-26T11:42\", \"reportStatus_date\": \"2024-08-26T11:42\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-04-29T11:53\", \"username\": null}, {\"date\": \"2024-08-26T11:42\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:00:38\", \"value\": [{\"add\": \"43 Community Square Blvd Unit 1059\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1987-06-01\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4045870040, \"zip\": 30180, \"add2\": \"\", \"add3\": \"\", \"city\": \"Villa Rica\", \"gend\": 1, \"insh\": \"0006405911001\", \"mzip\": 30180, \"name\": \"Crystal Nicole Giddens\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"43 Community Square Blvd Unit 1059\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Villa Rica\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"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:55\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:55\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-04-29T11:53\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}, {\"date\": \"2024-08-26T11:42\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"8/26/2024 @ 11:42 AM\", \"result\": 9, \"comment\": \"Called to Schedule Virtual HRA with Debbie but member refused per call record dated 04/29/2024\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"4/29/2024 @ 11:53 AM\", \"result\": 9, \"comment\": \"REFUSAL - MEMBER DECLINED OFFER TO SCHEDULE IHA IN 2024.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-29-2024 11:53:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"04-22-2024 00:31:30\", \"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 06:00:38', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1748, NULL, NULL, NULL, '0006409587001', '407762', '', '84555898', 'Kimberly', 'Camacho', '', '{\"DOB\": 26453, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Winder\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Winder\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1972-06-03\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 407762, \"Mailing_County\": \"BARROW\", \"Member_Country\": \"BARROW\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"2238 Booth Cir\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30680, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"2238 Booth Cir\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30680, \"Member_Last_name\": \"Camacho\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Kimberly\", \"Member_Middle_name\": \"Dawn\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"Brockkimmi@gmail.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": \"6787263334\", \"Member_Identification_Number\": \"0006409587001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"7063389342\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:33:26\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:26\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-06-04T16:20\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [{\"date\": \"2024-06-10T18:20\", \"text\": \"Wrong Number\", \"method\": \"api\", \"status\": 7}, {\"date\": \"2024-06-21T13:03\", \"text\": \"Wrong Number\", \"method\": \"api\", \"status\": 7}], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Wrong Number\", \"type\": \"ReportStatus\", \"status\": 7, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-06-10T18:20\"}, {\"text\": \"Wrong Number\", \"type\": \"ReportStatus\", \"status\": 7, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-21T13:03\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"07-16-2024\", \"time\": \"03:21:15\", \"value\": [{\"add\": \"2238 Booth Cir\", \"age\": \"\", \"ano\": \"\", \"cno\": 7063389342, \"dob\": \"1972-06-03\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6787263334, \"zip\": 30680, \"add2\": \"\", \"add3\": \"\", \"city\": \"Winder\", \"gend\": 1, \"insh\": \"0006409587001\", \"mzip\": 30680, \"name\": \"Kimberly Dawn Camacho\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"Brockkimmi@gmail.com\", \"ename\": \"\", \"madd1\": \"2238 Booth Cir\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Winder\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"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\": \"07-16-2024\", \"time\": \"03:21:15\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"07-16-2024 03:21:15\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 4, \"callLog\": [{\"date\": \"6/21/2024 @ 01:03 PM\", \"result\": 4, \"comment\": \"06/21/2024 JC: called for HRA-Nykya Cox-Virtual: per perv note - Wrong Number someone answered and said that it was the wrong number \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"6/10/2024 @ 03:20 PM\", \"result\": 4, \"comment\": \"06/10/2024 JC: called for HRA- Faith Enwefah - Virtual: Wrong Number someone answered and said that it was the wrong number \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"6/4/2024 @ 04:19 PM\", \"result\": 3, \"comment\": \"MAILBOX FULL - Unable to leave a message. Call attempt to schedule HRA.\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"6/5/2024 @ 04:19 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"06-04-2024 16:19:00\", \"schedulerId\": \"84555898\", \"schedulerLeadId\": \"84555898\"}]}', '{\"date\": \"06-21-2024 13:03:58\", \"status\": 2, \"details\": \"disconnected/wrong number\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 3}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:39', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1749, NULL, NULL, NULL, '0006412165001', '412152', '', '21881792', 'Josh', 'Anderson', '', '{\"DOB\": 31324, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Clarksville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Clarksville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1985-10-04\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 412152, \"Mailing_County\": \"HABERSHAM\", \"Member_Country\": \"HABERSHAM\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"201 High Meadow Court\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30523, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"201 High Meadow Court\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30523, \"Member_Last_name\": \"Anderson\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Josh\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"Northgahomegroup@gmail.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7064991124, \"Member_Identification_Number\": \"0006412165001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:26\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:26\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-03T18:10\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-31T14:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-03T14:56\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-06T15:41\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-26T16:34\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-03T18:10\", \"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-06-03T14:56\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-06T15:41\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-26T16:34\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-03T18:10\"}]', '{\"utc\": [{\"date\": \"2024-07-16T14:48\", \"username\": null}, {\"date\": \"2024-07-31T16:26\", \"username\": null}, {\"date\": \"2024-09-06T16:23\", \"username\": null}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:00:39\", \"value\": [{\"add\": \"201 High Meadow Court\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1985-10-04\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7064991124, \"zip\": 30523, \"add2\": \"\", \"add3\": \"\", \"city\": \"Clarksville\", \"gend\": 0, \"insh\": \"0006412165001\", \"mzip\": 30523, \"name\": \"Josh Anderson\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"Northgahomegroup@gmail.com\", \"ename\": \"\", \"madd1\": \"201 High Meadow Court\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Clarksville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"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:55\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:55\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/31/2024 @ 12:43 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/30/2024 @ 12:21 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/29/2024 @ 11:52 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/5/2024 @ 06:07 PM\", \"result\": 7, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"8/20/2024 @ 11:22 AM\", \"result\": 7, \"comment\": \"Call attempt to schedule an HRA w/ Faith Enwefah.  - Line Busy \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"8/1/2024 @ 02:19 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Faith Enwefah \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}, {\"date\": \"7/18/2024 @ 06:13 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/3/2024 @ 06:10 PM\", \"result\": 3, \"comment\": \"07/03/2024 JC: called for HRA-Delise Adams-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"6/26/2024 @ 04:34 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"7/3/2024 @ 04:34 PM\"}, {\"date\": \"6/6/2024 @ 03:41 PM\", \"result\": 3, \"comment\": \"LVM VIRTUAL VISIT WITH DEBORAH YORK ON 6/11 MV \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"6/6/2024 @ 03:41 PM\"}, {\"date\": \"6/3/2024 @ 02:56 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL- Call attempt to schedule a virtual HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/4/2024 @ 02:56 PM\"}, {\"date\": \"5/31/2024 @ 02:55 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL- Call attempt to schedule a virtual HRA. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/3/2024 @ 02:55 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-31-2024 14:55:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"07-03-2024 18:10:23\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 12}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:39', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1750, NULL, NULL, NULL, '0006413094001', '400581', '', '2661185', 'Audra', 'McGraw', '', '{\"DOB\": 25388, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1316997489, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"WARNER ROBINS\", \"Pcp_Name\": \"MAHER ABDULLA\", \"PCP_Phone\": 4789712130, \"Pcp_State\": \"GA\", \"Member_City\": \"Warner Robins\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Warner Robins\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1969-07-04\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"301 OSIGIAN BLVD\", \"Screening_IHA\": \"No\", \"member_id_two\": 400581, \"Mailing_County\": \"HOUSTON\", \"Member_Country\": \"HOUSTON\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"107 Anthony Avenue\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 31093, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"107 Anthony Avenue\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31093, \"Member_Last_name\": \"McGraw\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Audra\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"audramcgraw@yahoo.com\", \"Member_Suspect_Codes\": \"161.2, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4785386450, \"Member_Identification_Number\": \"0006413094001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:26\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:26\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-02T18:50\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-29T17:07\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-10T16:54\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-12T17:08\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-15T17:59\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-02T18:50\", \"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-04-29T17:07\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-10T16:54\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-15T17:59\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-02T18:50\"}]', '{\"utc\": [{\"date\": \"2024-07-16T14:48\", \"username\": null}, {\"date\": \"2024-07-31T16:26\", \"username\": null}, {\"date\": \"2024-09-06T16:23\", \"username\": null}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:00:39\", \"value\": [{\"add\": \"107 Anthony Avenue\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1969-07-04\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4785386450, \"zip\": 31093, \"add2\": \"\", \"add3\": \"\", \"city\": \"Warner Robins\", \"gend\": 1, \"insh\": \"0006413094001\", \"mzip\": 31093, \"name\": \"Audra McGraw\", \"plan\": \"Alliant\", \"pphy\": \"MAHER ABDULLA\", \"ppno\": 4789712130, \"cliId\": \"\", \"email\": \"audramcgraw@yahoo.com\", \"ename\": \"\", \"madd1\": \"107 Anthony Avenue\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Warner Robins\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"301 OSIGIAN BLVD\", \"pcpnpi\": 1316997489, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"WARNER ROBINS\", \"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:55\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:55\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/6/2024 @ 05:52 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"7/31/2024 @ 05:53 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ DELISE ADAMS lvm. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/17/2024 @ 02:01 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/2/2024 @ 06:50 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"6/15/2024 @ 05:59 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Delise Adams or Faith Enwefah \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/21/2024 @ 05:59 PM\"}, {\"date\": \"6/12/2024 @ 05:08 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL- Call attempt to schedule a virtual HRA. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/13/2024 @ 05:08 PM\"}, {\"date\": \"6/10/2024 @ 01:54 PM\", \"result\": 3, \"comment\": \"06/10/2024 JC: called for HRA- Faith Enwefah - Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/14/2024 @ 01:54 PM\"}, {\"date\": \"4/29/2024 @ 05:07 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"4/30/2024 @ 05:07 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-29-2024 17:07:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"07-02-2024 18:50:44\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 8}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:39', 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
(1751, 71932120, 44829497, '83326555', '0006414631001', '406579', '', '2661185', 'Michael', 'Scott', '', '{\"DOB\": 22739, \"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\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"\", \"Pcp_Name\": \"Dr.  Morrell (but in process of changing physicans due to this office not taking insurance)\", \"PCP_Phone\": \"\", \"Member_City\": \"Athens\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Athens\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1962-04-03\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 406579, \"Mailing_County\": \"CLARKE\", \"Member_Country\": \"CLARKE\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"230 Cedar Springs Dr\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30605, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"230 Cedar Springs Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30605, \"Member_Last_name\": \"Scott\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Michael\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"gobraves0862@gmail.com\", \"Member_Suspect_Codes\": 20, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 7062028580, \"Member_Identification_Number\": \"0006414631001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"07-30-2024 10:48:33\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-07-30 10:48:33\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-07-09T13:22\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-07-19T14:27\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-07-26T11:28\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-07-26T13:00\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-07-30T10:48\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-05-13T19:23\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-07-11T15:24\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-07-15T18:41\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [{\"date\": \"2024-05-21T15:10\", \"text\": \"Virtual No Show\", \"method\": \"api\", \"status\": 23}], \"callBackRequested\": [{\"date\": \"2024-05-30T13:02\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-05-13T19:23\", \"reportStatus_date\": \"2024-05-13T19:23\"}, {\"text\": \"Virtual No Show\", \"type\": \"ReportStatus\", \"status\": 23, \"hraStatus\": 19, \"hraStatus_date\": \"2024-05-21T15:10\", \"reportStatus_date\": \"2024-05-21T15:10\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-30T13:02\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-07-15T18:41\", \"reportStatus_date\": \"2024-07-15T18:41\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-07-19T14:27\", \"reportStatus_date\": \"2024-07-19T14:27\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-07-26T13:00\", \"reportStatus_date\": \"2024-07-26T13:00\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-07-30T10:48\", \"reportStatus_date\": \"2024-07-30T10:48\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-05-21T15:10\", \"username\": \"SKey\"}], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-07-30T10:48\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-05-13T19:23\", \"username\": null}, {\"date\": \"2024-05-13T19:23\", \"username\": null}, {\"date\": \"2024-07-11T15:24\", \"username\": null}, {\"date\": \"2024-07-11T15:24\", \"username\": null}, {\"date\": \"2024-07-15T18:41\", \"username\": null}, {\"date\": \"2024-07-15T18:41\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-07-19T12:53\", \"username\": \"CMiddleton\"}], \"qaAssigned\": [{\"date\": \"2024-07-22T08:47\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2024-07-19T14:27\", \"username\": \"CMiddleton\"}, {\"date\": \"2024-07-19T14:27\", \"username\": \"CMiddleton\"}, {\"date\": \"2024-07-25T14:18\", \"username\": \"CMiddleton\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-07-26T13:00\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-07-26T11:28\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-07-26T13:00\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-07-25T12:05\", \"username\": \"MJoseph\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"09-06-2024\", \"time\": \"15:04:49\", \"value\": [{\"add\": \"230 Cedar Springs Dr\", \"age\": 62, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1962-04-03\", \"eno\": \"7062028581\", \"lob\": \"On Exchange\", \"pno\": 7062028580, \"zip\": 30605, \"add2\": \"\", \"add3\": \"\", \"city\": \"Athens\", \"gend\": 0, \"insh\": \"0006414631001\", \"mzip\": 30605, \"name\": \"Michael Scott\", \"plan\": \"Alliant\", \"pphy\": \"Dr.  Morrell (but in process of changing physicans due to this office not taking insurance)\", \"ppno\": \"\", \"race\": \"\", \"cliId\": \"\", \"email\": \"gobraves0862@gmail.com\", \"ename\": \"Beth Scott\", \"madd1\": \"230 Cedar Springs Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Athens\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"evalDate\": \"2024-07-19 01:00 PM\", \"evalName\": \"Connie Middleton, FNP\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"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\": \"07-15-2024\", \"time\": \"10:22:16\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"09-06-2024 15:04:49\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2024-05-21T15:10\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"SKey\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, '{\"memberId\": \"0006414631001\", \"clinician\": \"Connie Middleton\", \"qaAnalyst\": \"Manoucheca Joseph\", \"queryData\": [{\"date\": \"Thu, 25 Jul 2024 16:05:07 GMT\", \"name\": \"Manoucheca \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Connie,\\n\\n1. In the self assessment and social history, employment, the question-Are you interested in employment- was left unanswered. Please update.\\n2. In the preventative care screening, the question-One time screen for Abdominal Aortic Aneurysm if male with history of smoking, age 65-75-was left answered. Please update.\\n3. In the preventative care screening, One time screening for Hepatitis C if born between 1945-1965- was left unanswered. Please update.\\n4. In the allergies/medication section, long term use was left unanswered. Please update.\\n5. In the allergies/medication section, Medication compliance and knowledge of use and disease questions were left unanswered. Please update.\\n6. In the assessment of diagnoses, tinnitus symptoms were left unanswered. Please update.\\n7. In the assessment of diagnoses, gastrointestinal, abdominal openings and rectal problems were left unanswered. Please update.\\n8. In the assessment of diagnoses, integument, Eczema was supported with medication. Please add the Eczema med to the medication list. Please update.\\n9. In the assessment of diagnoses, endocrine, diabetes complications was left unanswered. Please update.\\n\\nThank you,\\nManoucheca\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 25 Jul 2024 18:18:32 GMT\", \"name\": \"Connie \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Updated - Sorry for so many omissions.  I was having a real problem that day getting the HRA to save the data.\\nThe OTC cream for eczema is topical.  There is no choice under route for that, and it will not let me type it in.  I put it in the next column\"}, \"mailId\": \"\"}], \"memberName\": \"Michael Scott\", \"codingAnalyst\": \"\", \"dateOfService\": \"07/19/2024 01:00 PM\", \"clinicianMailId\": \"c.middleton@focuscares.com\", \"qaAnalystMailId\": \"m.joseph@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"7/15/2024 @ 06:41 PM\", \"result\": 0, \"comment\": \"called member to schedule with Deborah York member already scheduled with Connie Middleton on July 19th at 1pm.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/11/2024 @ 03:24 PM\", \"result\": 0, \"comment\": \"Called to schedule HRA w/Connie Middleton MEMBER SCHEDULED FOR JULY 19TH AT 1PM \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/9/2024 @ 01:22 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ FAITH ENWEFAH  OR w/ DELISE ADAMS \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"7/17/2024 @ 01:21 PM\"}, {\"date\": \"5/30/2024 @ 01:02 PM\", \"result\": 6, \"comment\": \"Member would like a call back to attempt to reschedule virtual appointment. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/31/2024 @ 01:02 PM\"}, {\"date\": \"5/13/2024 @ 07:23 PM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA w/Sallie Key for 5/21/24 @ 3:00pm. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0006414631001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"83326555\", \"memberId\": \"0006414631001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"83326555\", \"memberId\": \"0006414631001\", \"scheduleDate\": \"2024-7-19T13:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-13-2024 19:23:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}, {\"date\": \"05-21-2024 15:10:39\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"07-15-2024 18:41:37\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 5}', NULL, 0, NULL, '[{\"date\": \"2024-07-30 10:48:31\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"ca3af149-4e82-11ef-bda0-db2d0a841214\\\",\\\"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-19T13:00', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:40', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006414631001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0006414631001_Scott, Michael_07192024.pdf\", \"ftp_upload_date\": \"2024-07-30 10:48:31\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_insurance), Dr.  Morrell (but in process of changing physicans due to this office not taking_0006414631001_07192024.pdf\"}', 'ACA_0006414631001_Scott, Michael_07192024', NULL, 'PCP_insurance), Dr.  Morrell (but in process of changing physicans due to this office not taking_0006414631001_07192024', NULL, '[{\"date\": \"2024-07-19T18:27:44.591Z\", \"signature\": \"data:image/png;base64,[encoded data, 24200 characters]\"}, {\"date\": \"2024-07-25T18:18:30.767Z\", \"signature\": \"data:image/png;base64,[encoded data, 24284 characters]\"}]', '2024-07-19T14:26', 'Member_Summary_0006414631001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006414631001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0006414631001.pdf\", \"member_ftp_upload_date\": \"2024-07-30 10:48:32\"}', 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
(1752, 57818338, 44829497, '56716210', '0006417099001', '406079', '', '21881792', 'Angela', 'Sargent', '', '{\"DOB\": 26423, \"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\": \"30534\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"DAWSONVILLE\", \"Pcp_Name\": \"Dr. Nabil Keith\", \"PCP_Phone\": \"7062164444\", \"Member_City\": \"Dawsonville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Dawsonville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1972-05-04\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"150 NORTHSIDE DAWSON DR\", \"Screening_IHA\": \"No\", \"member_id_two\": 406079, \"Mailing_County\": \"DAWSON\", \"Member_Country\": \"DAWSON\", \"PCP_Fax_Number\": \"7064291140\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"170 Vandiviere Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30534, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"170 Vandiviere Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30534, \"Member_Last_name\": \"Sargent\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Angela\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"angiekay72@bellsouth.net\", \"Member_Suspect_Codes\": \"161.2, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 6789675992, \"Member_Identification_Number\": \"0006417099001\", \"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:36:02\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-05-31 14:36:02\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-05-18T22:31\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-24T16:16\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-27T01:41\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-31T14:36\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-05-14T17:17\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-05-15T15:49\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-05-18T22:31\", \"reportStatus_date\": \"2024-05-18T22:31\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-05-27T01:41\", \"reportStatus_date\": \"2024-05-27T01:41\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-05-31T14:36\", \"reportStatus_date\": \"2024-05-31T14:36\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-05-31T14:36\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-05-14T17:17\", \"username\": null}, {\"date\": \"2024-05-14T17:17\", \"username\": null}, {\"date\": \"2024-05-15T15:49\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-05-16T23:11\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-05-19T11:46\", \"username\": \"JScanlonQAL\"}], \"readyForQa\": [{\"date\": \"2024-05-17T04:40\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-17T04:43\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-17T04:46\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-17T04:49\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-17T04:52\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-17T04:56\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-17T04:58\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-17T04:58\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T15:57\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T16:00\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T16:03\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T16:06\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T16:09\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T16:10\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T16:10\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T16:29\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T16:32\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T16:35\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T16:38\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T16:41\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T16:44\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T16:47\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T16:50\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T16:52\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T16:53\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T16:56\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T16:59\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T16:59\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T17:02\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T17:02\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T17:05\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T17:08\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T17:11\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T17:11\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T17:14\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T17:17\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T17:20\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T17:23\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T17:23\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T17:26\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T17:29\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T17:32\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T17:35\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T17:38\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T17:38\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T17:41\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T17:41\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T17:43\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T17:44\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T20:44\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T20:44\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T20:47\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T20:50\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T20:50\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T20:53\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T20:56\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T20:59\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T21:02\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T21:05\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T21:08\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T21:11\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T21:14\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T21:17\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T21:18\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T21:19\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T21:20\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T21:23\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T21:23\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T21:25\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T21:26\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T21:29\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T21:32\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T21:35\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T21:38\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T21:41\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T21:43\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T21:44\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T21:44\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T21:47\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T21:50\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T21:53\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T21:56\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T21:59\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T22:02\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T22:05\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T22:08\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T22:11\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T22:12\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T22:14\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T22:17\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T22:18\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T22:20\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T22:23\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T22:26\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T22:29\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T22:31\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T22:31\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T08:20\", \"username\": \"JSilverio\"}, {\"date\": \"2024-05-23T15:41\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-05-27T01:41\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-05-24T16:16\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-05-27T01:41\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-05-22T08:22\", \"username\": \"JSilverio\"}, {\"date\": \"2024-05-23T15:40\", \"username\": \"DAdams\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"07-01-2024\", \"time\": \"13:12:57\", \"value\": [{\"add\": \"170 Vandiviere Rd\", \"age\": 52, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1972-05-04\", \"eno\": \"6789723687\", \"lob\": \"On Exchange\", \"pno\": 6789675992, \"zip\": 30534, \"add2\": \"\", \"add3\": \"\", \"city\": \"Dawsonville\", \"gend\": 1, \"insh\": \"0006417099001\", \"mzip\": 30534, \"name\": \"Angela Sargent\", \"plan\": \"Alliant\", \"pphy\": \"Dr. Nabil Keith\", \"ppno\": \"7062164444\", \"race\": \"\", \"cliId\": \"\", \"email\": \"angiekay72@bellsouth.net\", \"ename\": \"Brent Sargent\", \"madd1\": \"170 Vandiviere Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Dawsonville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"150 NORTHSIDE DAWSON DR\", \"pcpnpi\": \"\", \"pcpzip\": \"30534\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpcity\": \"DAWSONVILLE\", \"pcpname\": \"\", \"program\": \"ACA\", \"evalDate\": \"2024-5-17 12:00 PM\", \"evalName\": \"Delise Adams, FNP\", \"pcpfaxno\": \"7064291140\", \"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\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-16-2024\", \"time\": \"23:11:25\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"07-01-2024 13:12:57\"}', NULL, NULL, '{\"memberId\": \"0006417099001\", \"clinician\": \"Delise Adams\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Wed, 22 May 2024 12:22:10 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"1.  Demographics section please choose gender.\\n2.  Preventative Care was member educated about osteoporosis?\\n3.  Vital Signs Are you interested in nutrition and/or weight changes ? needs answer.\\n4.  Vital Signs Are things preventing you from making changes?  needs answer.\\nThanks\\nJodi \", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 23 May 2024 19:41:28 GMT\", \"name\": \"Delise \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"1. Fixed\\n2. Changed to n/a\\n3. Answered\\n4. Answered.\\n\\nThank you.\"}, \"mailId\": \"\"}], \"memberName\": \"Angela Sargent\", \"codingAnalyst\": \"\", \"dateOfService\": \"05/17/2024 12:10 PM\", \"clinicianMailId\": \"deliseadams@sbcglobal.net\", \"qaAnalystMailId\": \"j.silverio@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"5/14/2024 @ 05:17 PM\", \"result\": 0, \"comment\": \"SCHEDULED DELISE ADAMS - 5/17 @ 10 PETS IN HOME, PARK ANYWHERE AVAILABLE. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0006417099001\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"56716210\", \"memberId\": \"0006417099001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"56716210\", \"memberId\": \"0006417099001\", \"scheduleDate\": \"2024-5-17T10:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-14-2024 17:17:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"05-15-2024 15:49:14\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2024-05-31 14:36:01\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"a111356f-1f7c-11ef-9ba6-b5ba5a5ad9e0\\\",\\\"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-17T12:00', '2024-12-31', '2024-05-17T12:10', NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:40', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006417099001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0006417099001_Sargent, Angela_05172024.pdf\", \"ftp_upload_date\": \"2024-05-31 14:36:00\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Keith, Nabil_0006417099001_05172024.pdf\"}', 'ACA_0006417099001_Sargent, Angela_05172024', NULL, 'PCP_Keith, Nabil_0006417099001_05172024', NULL, '[{\"date\": \"2024-05-19T02:31:41.372Z\", \"signature\": \"data:image/png;base64,[encoded data, 23456 characters]\"}, {\"date\": \"2024-05-23T19:41:27.975Z\", \"signature\": \"data:image/png;base64,[encoded data, 23444 characters]\"}]', '2024-05-17T13:10', 'Member_Summary_0006417099001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006417099001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0006417099001.pdf\", \"member_ftp_upload_date\": \"2024-05-31 14:36:02\"}', NULL, NULL, NULL, NULL);
