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
(2180, 3285757, 44829497, '56716210', '0007160438001', '414859', '', '2661185', 'Alyssa', 'Jackson', '', '{\"DOB\": 37335, \"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\": \"30535\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"Demorest\", \"Pcp_Name\": \"Sarah Parker \", \"PCP_Phone\": \"7067544348\", \"Member_City\": \"Cleveland\", \"Office_Name\": \"Medlink\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Cleveland\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"2002-03-20\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"396 441 Historic Hwy N \", \"Screening_IHA\": \"No\", \"member_id_two\": 414859, \"Mailing_County\": \"WHITE\", \"Member_Country\": \"WHITE\", \"PCP_Fax_Number\": \"7067540731\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"64 Ash Wood Lane\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30528, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"64 Ash Wood Lane\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30528, \"Member_Last_name\": \"Jackson\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Alyssa\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"jacksonalyssa07@gmail.com\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 7068099838, \"Member_Identification_Number\": \"0007160438001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"09-24-2024 10:49:08\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-09-24 10:49:08\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-03T18:51\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-25T19:10\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-16T13:03\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-24T12:58\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-20T15:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-03T18:51\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-09-12T20:10\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-09-17T21:35\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-09-18T13:29\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-09-24T10:49\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-08-26T11:16\", \"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-25T19:10\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-16T13:03\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-24T12:58\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-20T15:21\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-03T18:51\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-08-26T11:16\", \"reportStatus_date\": \"2024-08-26T11:16\"}, {\"text\": \"Completed\", \"type\": \"HraStatus\", \"status\": 20, \"hraStatus\": 8, \"hraStatus_date\": \"2024-09-16T23:26\", \"reportStatus_date\": \"2024-09-12T20:10\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-09-18T13:29\", \"reportStatus_date\": \"2024-09-18T13:29\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-09-24T10:49\", \"reportStatus_date\": \"2024-09-24T10:49\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-09-24T10:49\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-08-26T11:16\", \"username\": null}, {\"date\": \"2024-08-26T11:16\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-09-12T01:29\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-09-16T13:02\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2024-09-12T20:10\", \"username\": \"DAdams\"}, {\"date\": \"2024-09-12T20:10\", \"username\": \"DAdams\"}, {\"date\": \"2024-09-17T18:01\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-09-18T13:29\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-09-17T21:35\", \"username\": \"BClark\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-09-18T13:29\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-09-16T23:24\", \"username\": \"BClark\"}, {\"date\": \"2024-09-16T23:26\", \"username\": \"BClark\"}, {\"date\": \"2024-09-17T18:00\", \"username\": \"DAdams\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"11-12-2024\", \"time\": \"16:14:34\", \"value\": [{\"add\": \"64 Ash Wood Lane\", \"age\": 22, \"ano\": \"\", \"cno\": \"\", \"dob\": \"2002-03-20\", \"eno\": \"7068094615\", \"lob\": \"On Exchange\", \"pno\": 7068099838, \"zip\": 30528, \"add2\": \"\", \"add3\": \"\", \"city\": \"Cleveland\", \"gend\": 1, \"insh\": \"0007160438001\", \"mzip\": 30528, \"name\": \"Alyssa Jackson\", \"plan\": \"Alliant\", \"pphy\": \"Sarah Parker \", \"ppno\": \"7067544348\", \"race\": \"\", \"cliId\": \"\", \"email\": \"jacksonalyssa07@gmail.com\", \"ename\": \"Stacy Westmoreland\", \"madd1\": \"64 Ash Wood Lane\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Cleveland\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"396 441 Historic Hwy N \", \"pcpnpi\": \"\", \"pcpzip\": \"30535\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Single\", \"pcpFlag\": 0, \"pcpcity\": \"Demorest\", \"pcpname\": \"Medlink\", \"program\": \"ACA\", \"evalDate\": \"2024-09-12 09:50 AM\", \"evalName\": \"Delise Adams, FNP\", \"pcpfaxno\": \"7067540731\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [], \"score\": [], \"comment\": []}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"09-12-2024\", \"time\": \"01:29:11\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"11-12-2024 16:14:34\"}', NULL, NULL, '{\"memberId\": \"0007160438001\", \"clinician\": \"Delise Adams\", \"qaAnalyst\": \"Brianne Clark\", \"queryData\": [{\"date\": \"Tue, 17 Sep 2024 03:24:25 GMT\", \"name\": \"Brianne \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Delise,\\nThank you for your thorough assessment!\\n\\n1) Under self-assessment, can you please answer the 3rd AUDIT-C question\\n2) Under preventative care, was a cervical exam recommended? Can you please check the box if so\\n\\n\\nThank you!\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Tue, 17 Sep 2024 03:26:09 GMT\", \"name\": \"Brianne \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Can you also add dx of nausea/vomiting r/t medication use\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Tue, 17 Sep 2024 22:01:21 GMT\", \"name\": \"Delise \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Corrections made. Thank you. \"}, \"mailId\": \"\"}], \"memberName\": \"Alyssa Jackson\", \"codingAnalyst\": \"\", \"dateOfService\": \"09/12/2024 09:50 AM\", \"clinicianMailId\": \"deliseadams@sbcglobal.net\", \"qaAnalystMailId\": \"b.clark@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"8/26/2024 @ 11:16 AM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA with Delise on 9/12 at 9:45am. Member using laptop, link was emailed.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"\"}, {\"date\": \"8/1/2024 @ 03:05 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA w/ Jansen Helm. - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"7/22/2024 @ 07:01 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/19/2024 @ 12:14 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/3/2024 @ 06:51 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Faith Enwefah\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"6/20/2024 @ 03:21 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"6/30/2024 @ 03:21 PM\"}, {\"date\": \"5/24/2024 @ 12:58 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL - Call attempt to schedule a F2F HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/27/2024 @ 12:58 PM\"}, {\"date\": \"5/16/2024 @ 01:03 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL -Call attempt to schedule HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/17/2024 @ 01:03 PM\"}, {\"date\": \"4/25/2024 @ 07:10 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"4/26/2024 @ 07:10 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0007160438001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"56716210\", \"memberId\": \"0007160438001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"56716210\", \"memberId\": \"0007160438001\", \"scheduleDate\": \"2024-9-12T09:45\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-25-2024 19:10:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"08-26-2024 11:16:57\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 9}', NULL, 0, NULL, '[{\"date\": \"2024-09-24 10:49:07\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"26473f9d-7a84-11ef-a198-6b6be9b69e84\\\",\\\"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-9-12T09:45', '2024-12-31', '2024-09-12T09:50', NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:02:50', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007160438001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0007160438001_Jackson, Alyssa_09122024.pdf\", \"ftp_upload_date\": \"2024-09-24 10:49:06\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_, Sarah Parker_0007160438001_09122024.pdf\"}', 'ACA_0007160438001_Jackson, Alyssa_09122024', NULL, 'PCP_, Sarah Parker_0007160438001_09122024', NULL, '[{\"date\": \"2024-09-13T00:10:13.454Z\", \"signature\": \"data:image/png;base64,[encoded data, 23460 characters]\"}, {\"date\": \"2024-09-17T22:01:20.712Z\", \"signature\": \"data:image/png;base64,[encoded data, 23456 characters]\"}]', '2024-09-12T10:45', 'Member_Summary_0007160438001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007160438001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0007160438001.pdf\", \"member_ftp_upload_date\": \"2024-09-24 10:49:08\"}', NULL, NULL, NULL, NULL);
INSERT INTO `HRA_member_client_009_2024` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`) VALUES
(2181, 57818338, 44829497, '96917241', '0007160574001', '420501', '', '2661185', 'Ramona', 'Jeffries', '', '{\"DOB\": 27143, \"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\": \"30542\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"Flowery Branch\", \"Pcp_Name\": \"Anna Powell, MD \", \"PCP_Phone\": \"770-848-9130\", \"Member_City\": \"Cleveland\", \"Office_Name\": \"Northeast GA Physicians Group\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Cleveland\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1974-04-24\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"4754 Martin Road\", \"Screening_IHA\": \"No\", \"member_id_two\": 420501, \"Mailing_County\": \"WHITE\", \"Member_Country\": \"WHITE\", \"PCP_Fax_Number\": \"7708489131\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"537 Warwick Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30528, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"537 Warwick Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30528, \"Member_Last_name\": \"Jeffries\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Ramona\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"ramona@trammellci.com\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 9048917243, \"Member_Identification_Number\": \"0007160574001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"07-02-2024 11:50:55\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-07-02 11:50:55\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-06-20T17:46\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-06-26T14:01\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-06-26T15:01\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-07-02T11:50\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-05-16T13:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [{\"date\": \"2024-06-06T16:03\", \"text\": \"Rescheduled\", \"method\": \"api\", \"status\": 16}], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2024-05-21T12:41\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-04-25T19:14\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-25T19:14\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-05-16T13:11\", \"reportStatus_date\": \"2024-05-16T13:11\"}, {\"text\": \"Cancellation\", \"type\": \"ReportStatus\", \"status\": 18, \"hraStatus\": 3, \"hraStatus_date\": \"2024-05-21T12:41\", \"reportStatus_date\": \"2024-05-21T12:41\"}, {\"text\": \"Rescheduled\", \"type\": \"HraStatus\", \"status\": 16, \"hraStatus\": 1, \"hraStatus_date\": \"2024-06-06T16:03\", \"reportStatus_date\": \"2024-06-06T16:03\"}, {\"text\": \"Completed\", \"type\": \"HraStatus\", \"status\": 20, \"hraStatus\": 8, \"hraStatus_date\": \"2024-06-21T13:51\", \"reportStatus_date\": \"2024-06-20T17:46\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-06-26T15:01\", \"reportStatus_date\": \"2024-06-26T15:01\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-07-02T11:50\", \"reportStatus_date\": \"2024-07-02T11:50\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-07-02T11:50\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-05-16T13:11\", \"username\": null}, {\"date\": \"2024-05-16T13:11\", \"username\": null}, {\"date\": \"2024-06-06T16:03\", \"username\": null}, {\"date\": \"2024-06-06T16:03\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-06-20T17:05\", \"username\": \"NCox\"}], \"qaAssigned\": [{\"date\": \"2024-06-21T08:47\", \"username\": \"JScanlonQAL\"}], \"readyForQa\": [{\"date\": \"2024-06-20T17:46\", \"username\": \"NCox\"}, {\"date\": \"2024-06-20T17:46\", \"username\": \"NCox\"}, {\"date\": \"2024-06-21T13:50\", \"username\": \"JSilverio\"}, {\"date\": \"2024-06-25T16:47\", \"username\": \"NCox\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-06-26T15:01\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-06-26T14:01\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-06-26T15:01\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-06-21T13:51\", \"username\": \"JSilverio\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-05-21T12:41\", \"username\": null}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"07-30-2024\", \"time\": \"12:18:01\", \"value\": [{\"add\": \"537 Warwick Rd\", \"age\": 50, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1974-04-24\", \"eno\": \"706-219-2880\", \"lob\": \"On Exchange\", \"pno\": 9048917243, \"zip\": 30528, \"add2\": \"\", \"add3\": \"\", \"city\": \"Cleveland\", \"gend\": 1, \"insh\": \"0007160574001\", \"mzip\": 30528, \"name\": \"Ramona Jeffries\", \"plan\": \"Alliant\", \"pphy\": \"Anna Powell, MD \", \"ppno\": \"770-848-9130\", \"cliId\": \"\", \"email\": \"ramona@trammellci.com\", \"ename\": \"Sharon Jeffries\", \"madd1\": \"537 Warwick Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Cleveland\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"4754 Martin Road\", \"pcpnpi\": \"\", \"pcpzip\": \"30542\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Single\", \"pcpFlag\": 0, \"pcpcity\": \"Flowery Branch\", \"pcpname\": \"Northeast GA Physicians Group\", \"program\": \"ACA\", \"pcpfaxno\": \"7708489131\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"06-20-2024\", \"time\": \"17:05:45\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"07-30-2024 13:24:21\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2024-05-21T12:41\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": null, \"hraStatus\": 3, \"cancelText\": \"\", \"cancelStatus\": 0}]}', NULL, '{\"memberId\": \"0007160574001\", \"clinician\": \"Nykya Cox\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Fri, 21 Jun 2024 17:51:26 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"1.  Med list reports back pain please add in AOD musculoskeletal and pain sections of the HRA.  Thanks Judi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Tue, 25 Jun 2024 20:47:41 GMT\", \"name\": \"Nykya \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"\"}, \"mailId\": \"\"}], \"memberName\": \"Ramona Jeffries\", \"codingAnalyst\": \"\", \"dateOfService\": \"06/20/2024 04:50 PM\", \"clinicianMailId\": \"n.cox@focuscares.com\", \"qaAnalystMailId\": \"j.silverio@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 12, \"callLog\": [{\"date\": \"6/6/2024 @ 04:03 PM\", \"result\": 12, \"comment\": \"RESCHEDULED - rescheduled virtual HRA w/ Nykya Cox on 6/20 @ 4:50. Texted link to member\'s phone. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"5/16/2024 @ 01:11 PM\", \"result\": 0, \"comment\": \"SCHEDULED SALLIE KEY ON 5/21 @ 12 - EMAILED LINK TO MEMBER. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"4/25/2024 @ 07:14 PM\", \"result\": 6, \"comment\": \"Member would prefer virtual appt, would like a call back to schedule when we have that availability. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"4/26/2024 @ 07:14 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0007160574001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"96917241\", \"memberId\": \"0007160574001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"96917241\", \"memberId\": \"0007160574001\", \"scheduleDate\": \"2024-6-20T16:50\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-25-2024 19:14:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}, {\"date\": \"05-21-2024 12:41:22\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"06-06-2024 16:03:21\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 3}', NULL, 0, NULL, '[{\"date\": \"2024-07-02 11:50:53\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"dce5e183-388a-11ef-b982-135fa33528bc\\\",\\\"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-20T16:50', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:02:51', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007160574001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0007160574001_Jeffries, Ramona_06202024.pdf\", \"ftp_upload_date\": \"2024-07-02 11:50:53\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_, Anna Powell, MD_0007160574001_06202024.pdf\"}', 'ACA_0007160574001_Jeffries, Ramona_06202024', NULL, 'PCP_, Anna Powell, MD_0007160574001_06202024', NULL, '[{\"date\": \"2024-06-20T21:46:27.100Z\", \"signature\": \"data:image/png;base64,[encoded data, 25524 characters]\"}, {\"date\": \"2024-06-25T20:47:41.172Z\", \"signature\": \"data:image/png;base64,[encoded data, 25516 characters]\"}]', '2024-06-20T17:46', 'Member_Summary_0007160574001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007160574001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0007160574001.pdf\", \"member_ftp_upload_date\": \"2024-07-02 11:50:54\"}', 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
(2182, NULL, NULL, NULL, '0007160838001', '396689', '', '21881792', 'Joey', 'Buice', '', '{\"DOB\": 26050, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1568435501, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"DOUGLASVILLE\", \"Pcp_Name\": \"CHARLES CRATON\", \"PCP_Phone\": 7709473000, \"Pcp_State\": \"GA\", \"Member_City\": \"Temple\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Temple\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1971-04-27\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"8820 HOSPITAL DR\", \"Screening_IHA\": \"No\", \"member_id_two\": 396689, \"Mailing_County\": \"CARROLL\", \"Member_Country\": \"CARROLL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"305 Double D Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30179, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"305 Double D Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30179, \"Member_Last_name\": \"Buice\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Joey\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"buicejoey@bellsouth.net\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4048591869, \"Member_Identification_Number\": \"0007160838001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"08-14-2024 00:00:21\", \"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\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-04-29T13:02\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-29T13:02\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:02:51\", \"value\": [{\"add\": \"305 Double D Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1971-04-27\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4048591869, \"zip\": 30179, \"add2\": \"\", \"add3\": \"\", \"city\": \"Temple\", \"gend\": 0, \"insh\": \"0007160838001\", \"mzip\": 30179, \"name\": \"Joey Buice\", \"plan\": \"Alliant\", \"pphy\": \"CHARLES CRATON\", \"ppno\": 7709473000, \"cliId\": \"\", \"email\": \"buicejoey@bellsouth.net\", \"ename\": \"\", \"madd1\": \"305 Double D Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Temple\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"8820 HOSPITAL DR\", \"pcpnpi\": 1568435501, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"DOUGLASVILLE\", \"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:26:37\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:26:37\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 6, \"callLog\": [{\"date\": \"4/29/2024 @ 01:02 PM\", \"result\": 6, \"comment\": \"MEMBER NOT AVAILABE AT TIME OF CALL.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/6/2024 @ 01:02 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-29-2024 13:02:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"04-22-2024 00:31:51\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', '{\"orderType\": 0, \"sortOrder\": 1714979197}', 1, NULL, NULL, NULL, NULL, '2024-07-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:02:51', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2183, NULL, NULL, NULL, '0007160838002', '396690', '', '543416', 'Sheila', 'Buice', '', '{\"DOB\": 25195, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1225001605, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"DOUGLASVILLE\", \"Pcp_Name\": \"BETTYE DRYE-GLOVER\", \"PCP_Phone\": 4709569480, \"Pcp_State\": \"GA\", \"Member_City\": \"Temple\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Temple\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1968-12-23\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"8820 HOSPITAL DR\", \"Screening_IHA\": \"No\", \"member_id_two\": 396690, \"Mailing_County\": \"CARROLL\", \"Member_Country\": \"CARROLL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"305 Double D Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30179, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"305 Double D Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30179, \"Member_Last_name\": \"Buice\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Sheila\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"161.2, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": \"4048591869\", \"Member_Identification_Number\": \"0007160838002\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"08-14-2024 00:00:21\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2024-08-14 00:00:21\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [{\"date\": \"2024-06-18T16:51\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-06-14T17:31\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-06-14T17:31\"}, {\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-18T16:51\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"06-21-2024\", \"time\": \"01:15:34\", \"value\": [{\"add\": \"305 Double D Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1968-12-23\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4048591869, \"zip\": 30179, \"add2\": \"\", \"add3\": \"\", \"city\": \"Temple\", \"gend\": 1, \"insh\": \"0007160838002\", \"mzip\": 30179, \"name\": \"Sheila Buice\", \"plan\": \"Alliant\", \"pphy\": \"BETTYE DRYE-GLOVER\", \"ppno\": 4709569480, \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"305 Double D Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Temple\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"8820 HOSPITAL DR\", \"pcpnpi\": 1225001605, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"DOUGLASVILLE\", \"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:34\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"06-21-2024 01:15:34\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 14, \"callLog\": [{\"date\": \"6/18/2024 @ 04:51 PM\", \"result\": 14, \"comment\": \"Previous notes from 06/14/2024 JC: called for HRA-Faith Enwefah-Virtual: member req call back in a few months say it\'s not needed at the moment. Changed status to a F2F CALL BACK.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/5/2024 @ 04:51 PM\"}, {\"date\": \"6/14/2024 @ 05:31 PM\", \"result\": 6, \"comment\": \"06/14/2024 JC: called for HRA-Faith Enwefah-Virtual: member req call back in a few months say its not needed at the moment \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"8/14/2024 @ 05:30 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"06-14-2024 17:31:00\", \"schedulerId\": \"543416\", \"schedulerLeadId\": \"543416\"}]}', '{\"date\": \"04-22-2024 00:31:51\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', '{\"orderType\": 0, \"sortOrder\": 1722840764}', 1, NULL, NULL, NULL, NULL, '2024-07-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:02:51', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2184, NULL, NULL, NULL, '0007161204001', '406808', '', '26056802', 'Julio', 'Martinez', '', '{\"DOB\": 32180, \"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\": \"1988-02-07\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 406808, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"3830 Stoney Creek Dr\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30542, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"3830 Stoney Creek Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30542, \"Member_Ethnicity\": \"White\", \"Member_Last_name\": \"Martinez\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Julio\", \"Member_Middle_name\": \"E\", \"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\": 6786978458, \"Member_Identification_Number\": \"0007161204001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:34:05\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:34:05\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-11T17:44\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-30T18:32\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-13T12:07\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-03T18:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-05T18:28\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-11T17:44\", \"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-30T18:32\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-13T12:07\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-03T18:18\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-05T18:28\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-11T17:44\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-07-31T12:03\", \"username\": null}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-07-15T19:51\", \"username\": null}, {\"date\": \"2024-07-15T19:51\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-07-31T09:27\", \"username\": \"CMiddleton\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:02:52\", \"value\": [{\"add\": \"3830 Stoney Creek Dr\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1988-02-07\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6786978458, \"zip\": 30542, \"add2\": \"\", \"add3\": \"\", \"city\": \"Flowery Branch\", \"gend\": 0, \"insh\": \"0007161204001\", \"mzip\": 30542, \"name\": \"Julio E Martinez\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"3830 Stoney Creek Dr\", \"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:26:37\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:26:37\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/7/2024 @ 01:01 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 12:48 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 05:40 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/31/2024 @ 04:38 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/30/2024 @ 04:30 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/6/2024 @ 04:37 PM\", \"result\": 3, \"comment\": \"attempt to sched virtual appt w/Nykya Cox\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"7/31/2024 @ 01:04 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/11/2024 @ 05:44 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/Connie Middleton left Voicemail.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"6/5/2024 @ 06:28 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/12/2024 @ 06:28 PM\"}, {\"date\": \"6/3/2024 @ 06:18 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/10/2024 @ 06:18 PM\"}, {\"date\": \"5/13/2024 @ 12:07 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL -Call attempt to schedule HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/15/2024 @ 12:07 PM\"}, {\"date\": \"4/30/2024 @ 06:32 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/14/2024 @ 06:32 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-30-2024 18:32:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"07-11-2024 17:44:44\", \"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:02:52', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2185, NULL, NULL, NULL, '0007162420001', '407802', '', '2661185', 'Haley', 'Lott-Wilson', '', '{\"DOB\": 28009, \"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\": \"Douglas\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Douglas\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1976-09-06\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 407802, \"Mailing_County\": \"COFFEE\", \"Member_Country\": \"COFFEE\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"195 Red Clay Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 31533, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"195 Red Clay Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31533, \"Member_Last_name\": \"Lott-Wilson\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Haley\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": 1, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 9123106060, \"Member_Identification_Number\": \"0007162420001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:34:05\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:34:05\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [{\"date\": \"2024-05-15T14:03\", \"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-15T14:03\", \"reportStatus_date\": \"2024-05-15T14:03\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-05-15T14:03\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:02:52\", \"value\": [{\"add\": \"195 Red Clay Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1976-09-06\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 9123106060, \"zip\": 31533, \"add2\": \"\", \"add3\": \"\", \"city\": \"Douglas\", \"gend\": 1, \"insh\": \"0007162420001\", \"mzip\": 31533, \"name\": \"Haley Lott-Wilson\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"195 Red Clay Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Douglas\", \"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:26:37\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:26:37\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-05-15T14:03\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"5/15/2024 @ 02:03 PM\", \"result\": 9, \"comment\": \"Refusal, member not interested. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-15-2024 14:03:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"04-22-2024 00:31:51\", \"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:02:52', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2186, NULL, NULL, NULL, '0007169782001', '402590', '', '26056802', 'Erin', 'Campbell', '', '{\"DOB\": 29563, \"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\": \"Dahlonega\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Dahlonega\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1980-12-08\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 402590, \"Mailing_County\": \"LUMPKIN\", \"Member_Country\": \"LUMPKIN\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"265 Perkins Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30533, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"265 Perkins Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30533, \"Member_Last_name\": \"Campbell\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Erin\", \"Member_Middle_name\": \"Leigh\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"lcbcampbell@gmail.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4782882879, \"Member_Identification_Number\": \"0007169782001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:34:05\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:34:05\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-10T14:32\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-30T14:47\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-16T15:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-24T14:54\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-20T18:13\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-10T14:32\", \"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-30T14:47\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-16T15:05\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-24T14:54\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-20T18:13\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-10T14:32\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-07-31T12:03\", \"username\": null}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-07-15T19:51\", \"username\": null}, {\"date\": \"2024-07-15T19:51\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-07-31T09:27\", \"username\": \"CMiddleton\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:02:52\", \"value\": [{\"add\": \"265 Perkins Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1980-12-08\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4782882879, \"zip\": 30533, \"add2\": \"\", \"add3\": \"\", \"city\": \"Dahlonega\", \"gend\": 1, \"insh\": \"0007169782001\", \"mzip\": 30533, \"name\": \"Erin Leigh Campbell\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"lcbcampbell@gmail.com\", \"ename\": \"\", \"madd1\": \"265 Perkins Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Dahlonega\", \"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:26:37\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:26:37\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/30/2024 @ 10:18 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/6/2024 @ 12:08 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Faith no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"7/24/2024 @ 07:37 PM\", \"result\": 3, \"comment\": \"07/24/2024 JC: called for HRA-Delise Adams-Virtual/F2F: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"7/10/2024 @ 02:32 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"6/20/2024 @ 06:13 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"6/30/2024 @ 06:11 PM\"}, {\"date\": \"5/24/2024 @ 02:54 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL - Call attempt to schedule a F2F HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/28/2024 @ 02:54 PM\"}, {\"date\": \"5/16/2024 @ 03:05 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL -Call attempt to schedule HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/16/2024 @ 03:04 PM\"}, {\"date\": \"4/30/2024 @ 02:47 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/14/2024 @ 02:47 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-30-2024 14:47:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"07-10-2024 14:32:14\", \"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:02:52', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2187, NULL, NULL, NULL, '0007171054001', '403511', '', '21881792', 'Sandra', 'Corley', '', '{\"DOB\": 25786, \"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\": \"Carrollton\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Carrollton\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1970-08-06\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 403511, \"Mailing_County\": \"CARROLL\", \"Member_Country\": \"CARROLL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"881 Bonner Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30117, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"881 Bonner Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30117, \"Member_Last_name\": \"Corley\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Sandra\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"my4dimples@gmail.com\", \"Member_Suspect_Codes\": \"162, 2, 46\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6015967799, \"Member_Identification_Number\": \"0007171054001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'1', '{\"date\": \"01-01-2025 23:34:05\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:34:05\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-10-30T10:27\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-29T17:08\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-27T12:39\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-09T17:27\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-30T10:27\", \"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-06T15:38\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-29T17:08\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-06T15:38\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-27T12:39\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-09T17:27\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-30T10:27\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-07-31T12:03\", \"username\": null}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-07-15T19:51\", \"username\": null}, {\"date\": \"2024-07-15T19:51\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-07-31T09:27\", \"username\": \"CMiddleton\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:02:52\", \"value\": [{\"add\": \"881 Bonner Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1970-08-06\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6015967799, \"zip\": 30117, \"add2\": \"\", \"add3\": \"\", \"city\": \"Carrollton\", \"gend\": 1, \"insh\": \"0007171054001\", \"mzip\": 30117, \"name\": \"Sandra Corley\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"my4dimples@gmail.com\", \"ename\": \"\", \"madd1\": \"881 Bonner Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Carrollton\", \"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:26:37\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:26:37\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/30/2024 @ 10:27 AM\", \"result\": 13, \"comment\": \"called for HRA-Virtual - Connie Middleton-GA, RN,NP : caller disconnected\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Rocheline Lovaincy\", \"callbackDate\": \"\"}, {\"date\": \"10/29/2024 @ 10:19 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/9/2024 @ 05:27 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/10/2024 @ 05:27 PM\"}, {\"date\": \"8/27/2024 @ 12:39 PM\", \"result\": 3, \"comment\": \"Previous call went dead - returned call to schedule appt. Call attempt to schedule a HRA w/ Faith Enwefah - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/28/2024 @ 12:39 PM\"}, {\"date\": \"5/6/2024 @ 03:38 PM\", \"result\": 6, \"comment\": \"CALL BACK REQUESTED - MEMBER REQUESTED A CALLBACK FOR A LATER DATE AND TIME. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/10/2024 @ 03:38 PM\"}, {\"date\": \"4/29/2024 @ 05:08 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"4/30/2024 @ 05:07 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-29-2024 17:08:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"10-30-2024 10:27:53\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 6}', '{\"orderType\": 0, \"sortOrder\": 1730354814}', 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:02:52', 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
(2188, 55499828, 44829497, '56716210', '0007172491001', '417926', '', '26056802', 'Richard', 'Jack', '', '{\"DOB\": 27226, \"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\": \"30019\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"Dacula\", \"Pcp_Name\": \"Jennifer Cobernus\", \"PCP_Phone\": \"7708489360\", \"Member_City\": \"Winder\", \"Office_Name\": \"Northeast Georgia Physicians Group Dacula Primary Care\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Winder\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1974-07-16\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"852 Dacula Road\", \"Screening_IHA\": \"No\", \"member_id_two\": 417926, \"Mailing_County\": \"JACKSON\", \"Member_Country\": \"JACKSON\", \"PCP_Fax_Number\": \"7708489361\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"2147 Ebenezer Church Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30680, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"2147 Ebenezer Church Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30680, \"Member_Last_name\": \"Jack\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Richard\", \"Member_Middle_name\": \"H\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"rjack7416@gmail.com\", \"Member_Suspect_Codes\": \"160, 20\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 7707092555, \"Member_Identification_Number\": \"0007172491001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"07-16-2024 10:55:24\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-07-16 10:55:24\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-29T14:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-10T18:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-07-11T03:48\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-07-11T17:42\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-07-11T21:12\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-07-16T10:55\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-04-25T18:00\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-04-26T16:07\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-07-01T15:26\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2024-04-30T12:26\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": 1, \"hraStatus_date\": \"2024-04-26T16:07\", \"reportStatus_date\": \"2024-04-29T14:17\"}, {\"text\": \"Cancellation\", \"type\": \"ReportStatus\", \"status\": 18, \"hraStatus\": 3, \"hraStatus_date\": \"2024-04-30T12:26\", \"reportStatus_date\": \"2024-04-30T12:26\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-10T18:55\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-07-01T15:26\", \"reportStatus_date\": \"2024-07-01T15:26\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-07-11T21:12\", \"reportStatus_date\": \"2024-07-11T21:12\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-07-16T10:55\", \"reportStatus_date\": \"2024-07-16T10:55\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-07-16T10:55\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-04-25T18:00\", \"username\": null}, {\"date\": \"2024-04-25T18:00\", \"username\": null}, {\"date\": \"2024-04-26T16:07\", \"username\": null}, {\"date\": \"2024-07-01T15:26\", \"username\": null}, {\"date\": \"2024-07-01T15:26\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-07-09T00:43\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-07-11T11:33\", \"username\": \"AWalsh\"}, {\"date\": \"2024-07-11T11:33\", \"username\": \"AWalsh\"}, {\"date\": \"2024-07-11T11:34\", \"username\": \"AWalsh\"}, {\"date\": \"2024-07-11T11:45\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2024-07-11T03:48\", \"username\": \"DAdams\"}, {\"date\": \"2024-07-11T03:48\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-07-11T21:12\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-07-11T17:42\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-07-11T21:12\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-04-30T12:26\", \"username\": \"PFrey1\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-05-2024\", \"time\": \"17:10:46\", \"value\": [{\"add\": \"2147 Ebenezer Church Rd\", \"age\": 50, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1974-07-16\", \"eno\": \"7706398221\", \"lob\": \"On Exchange\", \"pno\": 7707092555, \"zip\": 30680, \"add2\": \"\", \"add3\": \"\", \"city\": \"Winder\", \"gend\": 0, \"insh\": \"0007172491001\", \"mzip\": 30680, \"name\": \"Richard H Jack\", \"plan\": \"Alliant\", \"pphy\": \"Jennifer Cobernus\", \"ppno\": \"7708489360\", \"race\": \"\", \"cliId\": \"\", \"email\": \"rjack7416@gmail.com\", \"ename\": \"Melinda Hart\", \"madd1\": \"2147 Ebenezer Church Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Winder\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"852 Dacula Road\", \"pcpnpi\": \"\", \"pcpzip\": \"30019\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"Dacula\", \"pcpname\": \"Northeast Georgia Physicians Group Dacula Primary Care\", \"program\": \"ACA\", \"evalDate\": \"2024-7-9 3:00 PM\", \"evalName\": \"Delise Adams, FNP\", \"pcpfaxno\": \"7708489361\", \"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\": \"07-09-2024\", \"time\": \"00:43:46\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-05-2024 17:10:46\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2024-04-30T12:26\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"PFrey1\", \"hraStatus\": 3, \"cancelText\": \"Provider Cancellation\", \"cancelStatus\": 1}]}', NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"7/1/2024 @ 03:26 PM\", \"result\": 0, \"comment\": \"Scheduled Delise A on 7/9 @ 3:00 - texted link to member\'s phone. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"6/10/2024 @ 03:55 PM\", \"result\": 3, \"comment\": \"06/10/2024 JC: called for HRA- Faith Enwefah - Virtual: Mailbox Full \", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/14/2024 @ 03:55 PM\"}, {\"date\": \"4/29/2024 @ 02:17 PM\", \"result\": 3, \"comment\": \"Called to reschedule F2F HRA w/ Sallie Key on 5/6 - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/13/2024 @ 02:17 PM\"}, {\"date\": \"4/25/2024 @ 06:00 PM\", \"result\": 0, \"comment\": \"Scheduled F2F HRA w/ Sallie Key on 4/29 @ 430pm F2F HRA w/ Sallie Key \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0007172491001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"56716210\", \"memberId\": \"0007172491001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"56716210\", \"memberId\": \"0007172491001\", \"scheduleDate\": \"2024-7-9T15:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-25-2024 18:00:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}, {\"date\": \"04-30-2024 12:26:27\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"07-01-2024 15:26:11\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 4}', NULL, 0, NULL, '[{\"date\": \"2024-07-16 10:55:23\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"6dd0774c-4383-11ef-a293-0553ef9f70a3\\\",\\\"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-9T15:00', '2024-12-31', '2024-07-09T15:30', NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:02:53', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007172491001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0007172491001_Jack, Richard_07092024.pdf\", \"ftp_upload_date\": \"2024-07-16 10:55:22\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Cobernus, Jennifer_0007172491001_07092024.pdf\"}', 'ACA_0007172491001_Jack, Richard_07092024', NULL, 'PCP_Cobernus, Jennifer_0007172491001_07092024', NULL, '[{\"date\": \"2024-07-11T07:48:48.684Z\", \"signature\": \"data:image/png;base64,[encoded data, 23448 characters]\"}]', '2024-07-09T16:28', 'Member_Summary_0007172491001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007172491001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0007172491001.pdf\", \"member_ftp_upload_date\": \"2024-07-16 10:55:24\"}', NULL, NULL, NULL, NULL),
(2189, NULL, NULL, NULL, '0007175824001', '396399', '', '2661185', 'Alice', 'Fluellen', '', '{\"DOB\": 21807, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1619365632, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"Fitzgerald\", \"Pcp_Name\": \"KATHRYN PETRIE\", \"PCP_Phone\": 2294239561, \"Pcp_State\": \"GA\", \"Member_City\": \"Sheryl\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Sheryl\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1959-09-14\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"118 Norman Dorminy Drive\", \"Screening_IHA\": \"No\", \"member_id_two\": 396399, \"Mailing_County\": \"BEN HILL\", \"Member_Country\": \"BEN HILL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"512 N BRAGG ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 31750, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"512 N BRAGG ST\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31750, \"Member_Last_name\": \"Fluellen\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Alice\", \"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\": 2294577906, \"Member_Identification_Number\": \"0007175824001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:34:06\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:34:06\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-03T12:38\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-15T14:07\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-17T15:15\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-21T10:54\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-01T15:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-03T12:38\", \"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-17T15:15\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-21T10:54\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-01T15:18\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-03T12:38\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-07-31T12:03\", \"username\": null}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-07-15T19:51\", \"username\": null}, {\"date\": \"2024-07-15T19:51\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-07-31T09:27\", \"username\": \"CMiddleton\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:02:54\", \"value\": [{\"add\": \"512 N BRAGG ST\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1959-09-14\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 2294577906, \"zip\": 31750, \"add2\": \"\", \"add3\": \"\", \"city\": \"Sheryl\", \"gend\": 1, \"insh\": \"0007175824001\", \"mzip\": 31750, \"name\": \"Alice Fluellen\", \"plan\": \"Alliant\", \"pphy\": \"KATHRYN PETRIE\", \"ppno\": 2294239561, \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"512 N BRAGG ST\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Sheryl\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"118 Norman Dorminy Drive\", \"pcpnpi\": 1619365632, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"Fitzgerald\", \"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:26:37\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:26:37\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/13/2024 @ 11:44 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/12/2024 @ 11:45 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/11/2024 @ 11:35 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/7/2024 @ 03:28 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 03:29 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/10/2024 @ 03:15 PM\", \"result\": 3, \"comment\": \"NO VOICEMAIL-Call attempt to schedule a virtual HRA w/  Nykya Cox \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Alyia Williams\", \"callbackDate\": \"\"}, {\"date\": \"8/19/2024 @ 02:49 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 @ 06:45 PM\", \"result\": 3, \"comment\": \" Called to schedule HRA w/ DELISE ADAMS NO VM SETUP. \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/17/2024 @ 03:39 PM\", \"result\": 1, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/3/2024 @ 12:38 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Faith Enwefah\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/1/2024 @ 03:18 PM\", \"result\": 13, \"comment\": \"07/01/2024 JC: called for HRA-Faith Enwefah-Virtual: caller hung up, \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"7/15/2024 @ 03:18 PM\"}, {\"date\": \"5/21/2024 @ 10:54 AM\", \"result\": 3, \"comment\": \"NO VM SETUP - UNABLE TO LEAVE A MESSAGE. CALL ATTEMPT TO SCHEDULE VIRTUAL HRA.  \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/23/2024 @ 10:54 AM\"}, {\"date\": \"5/17/2024 @ 03:15 PM\", \"result\": 1, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/21/2024 @ 03:15 PM\"}, {\"date\": \"5/15/2024 @ 02:07 PM\", \"result\": 1, \"comment\": \"No answer, line rang -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/16/2024 @ 02:07 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-15-2024 14:07:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"07-03-2024 12:38:07\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 14}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:02:54', 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
(2190, NULL, NULL, NULL, '0007176251001', '408054', '', '2661185', 'Karen', 'Quick', '', '{\"DOB\": 25078, \"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\": \"Augusta\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Augusta\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1968-08-28\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 408054, \"Mailing_County\": \"COLUMBIA\", \"Member_Country\": \"COLUMBIA\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"215 Caribe Dr\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30907, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"215 Caribe Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30907, \"Member_Last_name\": \"Quick\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Karen\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"kb.originals1@gmail.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7062840334, \"Member_Identification_Number\": \"0007176251001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:34:06\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:34:06\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-03T12:38\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-15T14:13\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-17T15:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-21T10:57\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-01T15:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-03T12:38\", \"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-17T15:17\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-21T10:57\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-01T15:21\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-03T12:38\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-07-31T12:03\", \"username\": null}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-07-15T19:51\", \"username\": null}, {\"date\": \"2024-07-15T19:51\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-07-31T09:27\", \"username\": \"CMiddleton\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:02:54\", \"value\": [{\"add\": \"215 Caribe Dr\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1968-08-28\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7062840334, \"zip\": 30907, \"add2\": \"\", \"add3\": \"\", \"city\": \"Augusta\", \"gend\": 1, \"insh\": \"0007176251001\", \"mzip\": 30907, \"name\": \"Karen Quick\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"kb.originals1@gmail.com\", \"ename\": \"\", \"madd1\": \"215 Caribe Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Augusta\", \"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:26:37\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:26:37\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/14/2024 @ 11:40 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/28/2024 @ 02:55 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"8/31/2024 @ 12:04 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 @ 11:33 AM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Faith no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"7/3/2024 @ 12:38 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Faith Enwefah\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/1/2024 @ 03:21 PM\", \"result\": 3, \"comment\": \"07/01/2024 JC: called for HRA-Faith Enwefah-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"7/15/2024 @ 03:21 PM\"}, {\"date\": \"5/21/2024 @ 10:57 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a virtual HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/23/2024 @ 10:56 AM\"}, {\"date\": \"5/17/2024 @ 03:17 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/21/2024 @ 03:17 PM\"}, {\"date\": \"5/15/2024 @ 02:13 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/16/2024 @ 02:13 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-15-2024 14:13:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"07-03-2024 12:38:47\", \"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:02:54', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2191, NULL, NULL, NULL, '0007178598001', '404633', '', '26056802', 'Janet', 'Franklin', '', '{\"DOB\": 21902, \"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\": \"Mt Airy\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Mt Airy\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1959-12-18\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 404633, \"Mailing_County\": \"HABERSHAM\", \"Member_Country\": \"HABERSHAM\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"2259 Blacksnake Road\", \"Member_Address2\": \"\", \"Member_Address3\": \"\", \"Member_Zip_Code\": 30563, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"2259 Blacksnake Road\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30563, \"Member_Last_name\": \"Franklin\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Janet\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": 56, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": \"4783979059\", \"Member_Identification_Number\": \"0007178598001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'1', '{\"date\": \"01-01-2025 23:34:06\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:34:06\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-11-01T14:46\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-07-09T14:43\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-11T17:48\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-11-01T14:46\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-06-05T14:09\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-07-16T12:31\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-06-05T14:09\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-11T17:48\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-16T12:31\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-01T14:46\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"06-05-2024\", \"time\": \"14:08:33\", \"value\": [{\"add\": \"2259 Blacksnake Road\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1959-12-18\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": \"4783979059\", \"zip\": 30563, \"add1\": \"\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Mt Airy\", \"gend\": 1, \"insh\": \"0007178598001\", \"mzip\": 30563, \"name\": \"Janet Franklin\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"2259 Blacksnake Road\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Mt Airy\", \"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:26:37\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:26:37\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 1, \"callLog\": [{\"date\": \"11/1/2024 @ 02:46 PM\", \"result\": 1, \"comment\": \"Called Member to set up virtual HRA 6 attempt dead air--LB\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Latoya Bagley\", \"callbackDate\": \"\"}, {\"date\": \"7/16/2024 @ 12:31 PM\", \"result\": 6, \"comment\": \"updated contact info 4783799059 \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"7/17/2024 @ 12:31 PM\"}, {\"date\": \"7/11/2024 @ 05:48 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/Connie Middleton MEMBER NOT AVAILABLE UPDATED TO MEMBERS CORRECT PHONENUMBER\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"7/30/2024 @ 05:44 PM\"}, {\"date\": \"7/9/2024 @ 02:43 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ FAITH ENWEFAH  OR w/ DELISE ADAMS \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"7/30/2024 @ 02:42 PM\"}, {\"date\": \"6/5/2024 @ 02:09 PM\", \"result\": 6, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams - updated number to 4783979059\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/12/2024 @ 02:09 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"06-05-2024 14:09:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"11-01-2024 14:46:54\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 5}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:02:54', 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
(2192, 57818338, 44829497, '56716210', '0007178621001', '405375', '', '21881792', 'Melanie', 'Thompson', '', '{\"DOB\": 22650, \"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\": \"30125\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"Cedartown\", \"Pcp_Name\": \"Jerry Thompson\", \"PCP_Phone\": \"7707487818\", \"Member_City\": \"Cedartown\", \"Office_Name\": \"Atrium Health Floyd Medical Center \", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Cedartown\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1962-01-04\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"2370 Rockmart Hwy Ste 100\", \"Screening_IHA\": \"No\", \"member_id_two\": 405375, \"Mailing_County\": \"POLK\", \"Member_Country\": \"POLK\", \"PCP_Fax_Number\": \"7707487819\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"387 Mountain Home Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30125, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"387 Mountain Home Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30125, \"Member_Last_name\": \"Thompson\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Melanie\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"boxer2mt@icloud.com\", \"Member_Suspect_Codes\": \"160, 161.1, 161.2\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 6789880420, \"Member_Identification_Number\": \"0007178621001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"11-12-2024 21:19:12\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-11-12 21:19:12\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-09T18:16\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-29T09:26\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-01T15:14\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-07T15:25\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-01T15:23\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-09T18:16\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-11-03T00:55\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-11-05T23:56\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-11-06T11:45\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-11-12T21:19\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-10-29T10:36\", \"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-29T09:26\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-01T15:14\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-07T15:25\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-01T15:23\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-09T18:16\"}, {\"text\": \"Completed\", \"type\": \"HraStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-11-04T19:55\", \"reportStatus_date\": \"2024-11-03T00:55\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-11-06T11:44\", \"reportStatus_date\": \"2024-11-06T11:45\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-11-12T21:19\", \"reportStatus_date\": \"2024-11-12T21:19\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-11-12T21:19\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-10-29T10:36\", \"username\": null}, {\"date\": \"2024-10-29T10:36\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-10-31T14:15\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-11-04T11:04\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2024-11-03T00:55\", \"username\": \"DAdams\"}, {\"date\": \"2024-11-03T00:55\", \"username\": \"DAdams\"}, {\"date\": \"2024-11-04T19:55\", \"username\": \"DAdams\"}, {\"date\": \"2024-11-05T23:51\", \"username\": \"JSilverio\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-11-06T11:44\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-11-05T23:56\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-11-06T11:45\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-11-04T12:52\", \"username\": \"JSilverio\"}, {\"date\": \"2024-11-04T19:53\", \"username\": \"DAdams\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"01-13-2025\", \"time\": \"16:05:45\", \"value\": [{\"add\": \"387 Mountain Home Rd\", \"age\": 63, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1962-01-04\", \"eno\": \"7703244415\", \"lob\": \"On Exchange\", \"pno\": 6789880420, \"zip\": 30125, \"add2\": \"\", \"add3\": \"\", \"city\": \"Cedartown\", \"gend\": 1, \"insh\": \"0007178621001\", \"mzip\": 30125, \"name\": \"Melanie Thompson\", \"plan\": \"Alliant\", \"pphy\": \"Jerry Thompson\", \"ppno\": \"7707487818\", \"race\": \"\", \"cliId\": \"\", \"email\": \"boxer2mt@icloud.com\", \"ename\": \"Tina Williams\", \"madd1\": \"387 Mountain Home Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Cedartown\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"2370 Rockmart Hwy Ste 100\", \"pcpnpi\": \"\", \"pcpzip\": \"30125\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Widowed\", \"pcpFlag\": 0, \"pcpcity\": \"Cedartown\", \"pcpname\": \"Atrium Health Floyd Medical Center \", \"program\": \"ACA\", \"evalDate\": \"2024-11-1 09:45 AM\", \"evalName\": \"Delise Adams, FNP\", \"pcpfaxno\": \"7707487819\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [], \"score\": [], \"comment\": []}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"10-31-2024\", \"time\": \"14:15:22\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"01-13-2025 16:05:45\"}', NULL, NULL, '{\"memberId\": \"0007178621001\", \"clinician\": \"Delise Adams\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Mon, 04 Nov 2024 17:52:04 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"1.  Medications member is treated with albuterol.  Please add steroids to long term medications.\\n2.  AOD Genitourinary vaginal atrophy per med list.  Please add to this section of the HRA.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Tue, 05 Nov 2024 00:55:06 GMT\", \"name\": \"Delise \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"1. Did you mean to say Fluticasone Propionate (nasal)? Are we including it under long term steroids?\\n2. Added vaginal atrophy.\\n\\nThank you.\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 06 Nov 2024 04:51:22 GMT\", \"name\": \"JSilverio\", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Denise\\n1.  IPRAT-ALBUT for asthma Uses Albuterol inhaler less than 2x/week.\\n\", \"response\": \"\"}, \"mailId\": \"\"}], \"memberName\": \"Melanie Thompson\", \"codingAnalyst\": \"\", \"dateOfService\": \"11/01/2024 09:45 AM\", \"clinicianMailId\": \"deliseadams@sbcglobal.net\", \"qaAnalystMailId\": \"j.silverio@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"10/29/2024 @ 10:36 AM\", \"result\": 0, \"comment\": \"called for HRA-Virtual - Delise Adams-GA, NP : scheduled for 11/01 @9:45am\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Rocheline Lovaincy\", \"callbackDate\": \"\"}, {\"date\": \"8/31/2024 @ 05:57 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Faith no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"8/17/2024 @ 06:12 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Faith no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"7/23/2024 @ 03:36 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/22/2024 @ 03:22 PM\", \"result\": 1, \"comment\": \"Call was answered but no sound on call. Call to schedule a HRA w/ Faith Enwefah. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"7/9/2024 @ 06:16 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ FAITH ENWEFAH  OR w/ DELISE ADAMS \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/1/2024 @ 03:23 PM\", \"result\": 3, \"comment\": \"07/01/2024 JC: called for HRA-Faith Enwefah-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"7/15/2024 @ 03:23 PM\"}, {\"date\": \"5/7/2024 @ 03:25 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL - ATTEMPT TO SCHEDULE FAITH E. 5/10.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/10/2024 @ 03:24 PM\"}, {\"date\": \"5/1/2024 @ 03:14 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/2/2024 @ 03:14 PM\"}, {\"date\": \"4/29/2024 @ 09:26 AM\", \"result\": 3, \"comment\": \"LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"4/30/2024 @ 09:26 AM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0007178621001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"56716210\", \"memberId\": \"0007178621001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": -1, \"memberId\": \"0007178621001\", \"scheduleDate\": \"2024-11-1T09:45\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-29-2024 09:26:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"10-29-2024 10:36:41\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 10}', NULL, 0, NULL, '[{\"date\": \"2024-11-12 21:19:11\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"ab4f3b9e-a165-11ef-b885-d18903287072\\\",\\\"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-11-1T09:45', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:02:54', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007178621001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0007178621001_Thompson, Melanie_11012024.pdf\", \"ftp_upload_date\": \"2024-11-12 21:19:10\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Thompson, Jerry_0007178621001_11012024.pdf\"}', 'ACA_0007178621001_Thompson, Melanie_11012024', NULL, 'PCP_Thompson, Jerry_0007178621001_11012024', NULL, '[{\"date\": \"2024-11-03T04:55:55.953Z\", \"signature\": \"data:image/png;base64,[encoded data, 23448 characters]\"}, {\"date\": \"2024-11-05T00:55:05.988Z\", \"signature\": \"data:image/png;base64,[encoded data, 23428 characters]\"}]', '2024-11-01T11:31', 'Member_Summary_0007178621001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007178621001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0007178621001.pdf\", \"member_ftp_upload_date\": \"2024-11-12 21:19:12\"}', 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
(2193, NULL, NULL, NULL, '0007178990001', '419881', '', '2661185', 'Mary', 'Waller', '', '{\"DOB\": 22563, \"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\": \"Clarkesville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Clarkesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1961-10-09\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 419881, \"Mailing_County\": \"HABERSHAM\", \"Member_Country\": \"HABERSHAM\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"683 Grant St Apt M\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30523, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"683 Grant St Apt M\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30523, \"Member_Last_name\": \"Waller\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Mary\", \"Member_Middle_name\": \"LeeAnn\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"leeannwaller@att.net\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4046612594, \"Member_Identification_Number\": \"0007178990001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:34:06\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:34:06\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-25T16:39\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2024-04-25T17:11\", \"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-25T17:11\", \"reportStatus_date\": \"2024-04-25T17:11\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-04-25T17:11\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:02:55\", \"value\": [{\"add\": \"683 Grant St Apt M\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1961-10-09\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4046612594, \"zip\": 30523, \"add2\": \"\", \"add3\": \"\", \"city\": \"Clarkesville\", \"gend\": 1, \"insh\": \"0007178990001\", \"mzip\": 30523, \"name\": \"Mary LeeAnn Waller\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"leeannwaller@att.net\", \"ename\": \"\", \"madd1\": \"683 Grant St Apt M\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Clarkesville\", \"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:26:37\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:26:37\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-04-25T17:11\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"4/25/2024 @ 05:11 PM\", \"result\": 9, \"comment\": \"REFUSAL - MEMBER RETURNED CALL AND DECLINED OFFER TO SCHEDULE IHA IN 2024. \", \"inBound\": true, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"4/25/2024 @ 04:39 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"4/26/2024 @ 04:39 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-25-2024 16:39:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"04-22-2024 00:31:51\", \"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:02:55', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2194, NULL, NULL, NULL, '0007183834001', '413886', '', '2661185', 'Octavia', 'Butler', '', '{\"DOB\": 27557, \"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\": \"Gainesville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gainesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1975-06-12\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 413886, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"815 Harrison Sq Apt G1\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30507, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"815 Harrison Sq Apt G1\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30507, \"Member_Last_name\": \"Butler\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Octavia\", \"Member_Middle_name\": \"Samantha\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"octaviabutler490@gmail.com\", \"Member_Suspect_Codes\": 1, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6782923155, \"Member_Identification_Number\": \"0007183834001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 2, b'0', b'0', '{\"date\": \"01-01-2025 23:34:06\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:34:06\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-10-31T15:05\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [{\"date\": \"2024-04-25T14:50\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}, {\"date\": \"2024-05-16T10:00\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}, {\"date\": \"2024-06-04T14:25\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}, {\"date\": \"2024-06-05T19:39\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [{\"date\": \"2024-11-11T13:24\", \"text\": \"Virtual No Show\", \"method\": \"api\", \"status\": 23}], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-25T14:50\"}, {\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-16T10:00\"}, {\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-05T19:39\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-10-31T15:05\", \"reportStatus_date\": \"2024-10-31T15:05\"}, {\"text\": \"Virtual No Show\", \"type\": \"ReportStatus\", \"status\": 23, \"hraStatus\": 19, \"hraStatus_date\": \"2024-11-11T13:24\", \"reportStatus_date\": \"2024-11-11T13:24\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-11-11T13:24\", \"username\": \"NCox\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-10-31T15:05\", \"username\": null}, {\"date\": \"2024-10-31T15:05\", \"username\": null}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:02:55\", \"value\": [{\"add\": \"815 Harrison Sq Apt G1\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1975-06-12\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6782923155, \"zip\": 30507, \"add2\": \"\", \"add3\": \"\", \"city\": \"Gainesville\", \"gend\": 1, \"insh\": \"0007183834001\", \"mzip\": 30507, \"name\": \"Octavia Samantha Butler\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"octaviabutler490@gmail.com\", \"ename\": \"\", \"madd1\": \"815 Harrison Sq Apt G1\", \"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\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:26:37\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:26:37\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2024-11-11T13:24\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"NCox\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"10/31/2024 @ 03:05 PM\", \"result\": 0, \"comment\": \"called for HRA-Virtual - Nykya Cox-GA, RN,NP : scheduled for 11/11 @ 12pm\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Rocheline Lovaincy\", \"callbackDate\": \"\"}, {\"date\": \"6/5/2024 @ 07:39 PM\", \"result\": 14, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams - Member needs a weekend appointment due to working until 5 p.m. during the week. Placed as a F2F callback\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/12/2024 @ 07:39 PM\"}, {\"date\": \"6/4/2024 @ 02:25 PM\", \"result\": 14, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams - Member needs a weekend appointment due to working until 5 p.m. during the week. Placed as a F2F callback.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/18/2024 @ 02:25 PM\"}, {\"date\": \"5/16/2024 @ 10:00 AM\", \"result\": 14, \"comment\": \"PREVIOUS CALL ON 4/25 - MEMBER NEEDS A LATE AFTERNOON APPT AFTER 4:30. NO APPTS AVAILABLE AT THIS TIME. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/3/2024 @ 10:00 AM\"}, {\"date\": \"4/25/2024 @ 02:49 PM\", \"result\": 14, \"comment\": \"Member works 7 days a week but gets off @ 4:30pm. She needs a time after then to be able to schedule. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"4/26/2024 @ 02:49 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0007183834001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"96917241\", \"memberId\": \"0007183834001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": -1, \"memberId\": \"0007183834001\", \"scheduleDate\": \"2024-11-11T12:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-25-2024 14:49:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}, {\"date\": \"11-11-2024 13:24:22\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"11-11-2024 13:24:22\", \"status\": 0, \"details\": \"scheduled member moved to no show/cancellation\", \"disabled\": false, \"notification\": {\"type\": 1, \"value\": \"\", \"previous_status\": 1}}', '{\"attemptCount\": 5}', '{\"orderType\": 1, \"sortOrder\": 1731349462}', 1, NULL, NULL, 'Virtual', NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:02:55', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2195, NULL, NULL, NULL, '0007184590001', '402523', '', '21881792', 'Milan', 'Kim', '', '{\"DOB\": 22164, \"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\": \"Blairsville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Blairsville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1960-09-05\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 402523, \"Mailing_County\": \"UNION\", \"Member_Country\": \"UNION\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"2280 Pleasant Grove Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30512, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"2280 Pleasant Grove Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30512, \"Member_Last_name\": \"Kim\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Milan\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"isak22@yahoo.com\", \"Member_Suspect_Codes\": 183, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6787703022, \"Member_Identification_Number\": \"0007184590001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:34:06\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:34:06\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-03T18:52\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-31T11:47\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-03T12:02\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-06T14:08\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-01T15:25\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-03T18:52\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2024-08-17T13:27\", \"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-03T12:02\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-06T14:08\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-01T15:25\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-03T18:52\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-08-17T13:27\", \"reportStatus_date\": \"2024-08-17T13:27\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-08-17T13:27\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:02:55\", \"value\": [{\"add\": \"2280 Pleasant Grove Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1960-09-05\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6787703022, \"zip\": 30512, \"add2\": \"\", \"add3\": \"\", \"city\": \"Blairsville\", \"gend\": 1, \"insh\": \"0007184590001\", \"mzip\": 30512, \"name\": \"Milan Kim\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"isak22@yahoo.com\", \"ename\": \"\", \"madd1\": \"2280 Pleasant Grove Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Blairsville\", \"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:26:37\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:26:37\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-08-17T13:27\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"8/17/2024 @ 01:27 PM\", \"result\": 9, \"comment\": \"Called to Schedule Virtual HRA with Faith but member refused on 04/24/2024 & 05/22/2024\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"8/1/2024 @ 03:07 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA w/ Jansen Helm. - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"7/19/2024 @ 12:17 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/3/2024 @ 06:52 PM\", \"result\": 13, \"comment\": \"Called to schedule HRA w/ Faith Enwefah\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/1/2024 @ 03:25 PM\", \"result\": 3, \"comment\": \"07/01/2024 JC: called for HRA-Faith Enwefah-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"7/15/2024 @ 03:25 PM\"}, {\"date\": \"6/6/2024 @ 02:08 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/7/2024 @ 02:08 PM\"}, {\"date\": \"6/3/2024 @ 12:02 PM\", \"result\": 13, \"comment\": \"CALLER DISCONNECTED the call prior to and/or after greeting.  Call attempt to schedule F2F HRA. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/4/2024 @ 12:02 PM\"}, {\"date\": \"5/31/2024 @ 11:47 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL- Call attempt to schedule a virtual HRA. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/3/2024 @ 11:46 AM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-31-2024 11:47:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"07-03-2024 18:52:16\", \"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:02:55', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `HRA_member_client_009_2024` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`) VALUES
(2196, 3285757, 44829497, '62685179', '0007185699001', '403539', '', '2661185', 'Judy', 'Stephens', '', '{\"DOB\": 22301, \"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\": \"30165\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"Rome\", \"Pcp_Name\": \"Dr. Bethany Jackson\", \"PCP_Phone\": \"7062951184\", \"Member_City\": \"Rome\", \"Office_Name\": \"Advent Health\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Rome\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1961-01-20\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"2112 Shorter Ave, ste. 200\", \"Screening_IHA\": \"No\", \"member_id_two\": 403539, \"Mailing_County\": \"FLOYD\", \"Member_Country\": \"FLOYD\", \"PCP_Fax_Number\": \"7062361919\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"124 Rising Fawn Trl NE\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30165, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"124 Rising Fawn Trl NE\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30165, \"Member_Last_name\": \"Stephens\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Judy\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"judysparks69@yahoo.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 7064777181, \"Member_Identification_Number\": \"0007185699001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"06-25-2024 09:47:49\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-06-25 09:47:49\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-23T12:32\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-07T14:58\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-06-18T16:22\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-06-20T21:12\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-06-21T08:59\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-06-25T09:47\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-06-12T12:40\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-06-17T16:13\", \"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-23T12:32\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-07T14:58\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-06-17T16:13\", \"reportStatus_date\": \"2024-06-17T16:13\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-06-21T08:59\", \"reportStatus_date\": \"2024-06-21T08:59\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-06-25T09:47\", \"reportStatus_date\": \"2024-06-25T09:47\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-06-25T09:47\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-06-12T12:40\", \"username\": null}, {\"date\": \"2024-06-12T12:40\", \"username\": null}, {\"date\": \"2024-06-17T16:13\", \"username\": \"TOdleAdmin\"}], \"inProgress\": [{\"date\": \"2024-06-17T15:54\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-06-18T10:28\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [{\"date\": \"2024-06-19T09:44\", \"username\": \"JScanlonQAL\"}], \"readyForQa\": [{\"date\": \"2024-06-18T16:22\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-06-18T16:22\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-06-20T10:36\", \"username\": \"FEnwefah\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-06-21T08:59\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-06-20T21:12\", \"username\": \"BClark\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-06-21T08:59\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-06-20T09:47\", \"username\": \"BClark\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-19-2024\", \"time\": \"15:52:34\", \"value\": [{\"add\": \"124 Rising Fawn Trl NE\", \"age\": 63, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1961-01-20\", \"eno\": \"9105815245\", \"lob\": \"On Exchange\", \"pno\": 7064777181, \"zip\": 30165, \"add2\": \"\", \"add3\": \"\", \"city\": \"Rome\", \"gend\": 1, \"insh\": \"0007185699001\", \"mzip\": 30165, \"name\": \"Judy Stephens\", \"plan\": \"Alliant\", \"pphy\": \"Dr. Bethany Jackson\", \"ppno\": \"7062951184\", \"cliId\": \"\", \"email\": \"judysparks69@yahoo.com\", \"ename\": \"Joseph Nicholson\", \"madd1\": \"124 Rising Fawn Trl NE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Rome\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"2112 Shorter Ave, ste. 200\", \"pcpnpi\": \"\", \"pcpzip\": \"30165\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Single\", \"pcpFlag\": 0, \"pcpcity\": \"Rome\", \"pcpname\": \"Advent Health\", \"program\": \"ACA\", \"pcpfaxno\": \"7062361919\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Female\", \"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\": \"06-17-2024\", \"time\": \"15:54:05\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-19-2024 15:52:34\"}', NULL, NULL, '{\"memberId\": \"0007185699001\", \"clinician\": \"Faith Enwefah\", \"qaAnalyst\": \"Brianne Clark\", \"queryData\": [{\"date\": \"Thu, 20 Jun 2024 13:47:34 GMT\", \"name\": \"Brianne \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Good morning Faith,\\nThank you for your thorough assessment!\\n1) Under preventative care, was a Hep C screen recommended due to member falling in this category? If so, can you please check the box.\\n2) Under Dx, can you please select yes/no for mouth and throat problems\\n3) Under HTN, it is marked adequately controlled, but no vitals were taken due to virtual visit so can you please add a comment how we know this is adequately controlled?\\n4) Mini cog was marked N/A however, member takes medication for early stages of Alzheimer\'s can you please correct if applicable \\nThank you!\\nBrianne\\n\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 20 Jun 2024 14:36:29 GMT\", \"name\": \"Faith \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"\"}, \"mailId\": \"\"}], \"memberName\": \"Judy Stephens\", \"codingAnalyst\": \"\", \"dateOfService\": \"06/18/2024 12:00 PM\", \"clinicianMailId\": \"f.enwefah@focuscares.com\", \"qaAnalystMailId\": \"b.clark@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"6/12/2024 @ 12:40 PM\", \"result\": 0, \"comment\": \"Scheduled Faith E. on 6/18 @ 12 - emailed link to member: judysparks69@yahoo.com\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"5/7/2024 @ 02:58 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL - ATTEMPT TO SCHEDULE FAITH E. 5/10.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/10/2024 @ 02:58 PM\"}, {\"date\": \"4/23/2024 @ 12:32 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"4/24/2024 @ 12:32 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0007185699001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"62685179\", \"memberId\": \"0007185699001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"62685179\", \"memberId\": \"0007185699001\", \"scheduleDate\": \"2024-6-18T12:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-23-2024 12:32:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"06-12-2024 12:40:00\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 3}', NULL, 0, NULL, '[{\"date\": \"2024-06-25 09:47:48\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"824d1605-32f9-11ef-bb02-23c2da771c25\\\",\\\"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-18T12:00', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:02:56', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007185699001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0007185699001_Stephens, Judy_06182024.pdf\", \"ftp_upload_date\": \"2024-06-25 09:47:48\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Jackson, DR._0007185699001_06182024.pdf\"}', 'ACA_0007185699001_Stephens, Judy_06182024', NULL, 'PCP_Jackson, DR._0007185699001_06182024', NULL, '[{\"date\": \"2024-06-18T20:22:02.689Z\", \"signature\": \"data:image/png;base64,[encoded data, 23440 characters]\"}, {\"date\": \"2024-06-20T14:36:29.162Z\", \"signature\": \"data:image/png;base64,[encoded data, 23420 characters]\"}]', '2024-06-18T13:00', 'Member_Summary_0007185699001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007185699001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0007185699001.pdf\", \"member_ftp_upload_date\": \"2024-06-25 09:47:49\"}', 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
(2197, NULL, NULL, NULL, '0007187394002', '411813', '', '25536263', 'Janet', 'Bowers', '', '{\"DOB\": 22036, \"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\": \"Hartwell\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Hartwell\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1960-04-30\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 411813, \"Mailing_County\": \"HART\", \"Member_Country\": \"HART\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"199 Cedar Creek Circle\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30643, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"199 Cedar Creek Circle\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30643, \"Member_Last_name\": \"Bowers\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Janet\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": \"\", \"Member_Identification_Number\": \"0007187394002\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:34:06\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:34:06\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-25T16:32\", \"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-25T16:32\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"05-28-2024\", \"time\": \"11:44:10\", \"value\": [{\"add\": \"199 Cedar Creek Circle\", \"age\": 64, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1960-04-30\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": \"\", \"zip\": 30643, \"add2\": \"\", \"add3\": \"\", \"city\": \"Hartwell\", \"gend\": 1, \"insh\": \"0007187394002\", \"mzip\": 30643, \"name\": \"Janet Bowers\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"199 Cedar Creek Circle\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Hartwell\", \"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-28-2024\", \"time\": \"11:44:10\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-28-2024 11:44:10\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"4/25/2024 @ 04:32 PM\", \"result\": 3, \"comment\": \"MR 1st call attempt on 04/22/24. Left VM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tema Ferness\", \"callbackDate\": \"4/30/2024 @ 04:31 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-25-2024 16:32:00\", \"schedulerId\": \"25536263\", \"schedulerLeadId\": \"25536263\"}]}', '{\"date\": \"04-22-2024 00:31:51\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', '{\"orderType\": 0, \"sortOrder\": 1714459837}', 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:02:56', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2198, NULL, NULL, NULL, '0007188223001', '402214', '', '2661185', 'Tonya', 'Cummings', '', '{\"DOB\": 23128, \"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\": \"Albany\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Albany\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1963-04-27\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 402214, \"Mailing_County\": \"DOUGHERTY\", \"Member_Country\": \"DOUGHERTY\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"2011 Pearl Ave\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 31707, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"2011 Pearl Ave\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31707, \"Member_Last_name\": \"Cummings\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Tonya\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"cummingsto57@gmail.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 2295188769, \"Member_Identification_Number\": \"0007188223001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:34:07\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:34:06\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-16T12:30\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-07-09T14:44\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-11T17:49\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-16T12:30\", \"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-15T14:15\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-05-30T16:45\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-15T14:15\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-30T16:45\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-11T17:49\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-16T12:30\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-07-31T12:03\", \"username\": null}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-07-15T19:51\", \"username\": null}, {\"date\": \"2024-07-15T19:51\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-07-31T09:27\", \"username\": \"CMiddleton\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:02:56\", \"value\": [{\"add\": \"2011 Pearl Ave\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1963-04-27\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 2295188769, \"zip\": 31707, \"add2\": \"\", \"add3\": \"\", \"city\": \"Albany\", \"gend\": 1, \"insh\": \"0007188223001\", \"mzip\": 31707, \"name\": \"Tonya Cummings\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"cummingsto57@gmail.com\", \"ename\": \"\", \"madd1\": \"2011 Pearl Ave\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Albany\", \"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:26:38\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:26:38\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/14/2024 @ 10:33 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/29/2024 @ 01:05 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/28/2024 @ 12:46 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"8/31/2024 @ 10:50 AM\", \"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 @ 10:50 AM\", \"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 @ 06:46 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ DELISE ADAMS lvm.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/17/2024 @ 03:40 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/16/2024 @ 12:30 PM\", \"result\": 3, \"comment\": \"07/16/2024 JC: called for HRA-Connie Middleton-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"7/11/2024 @ 05:49 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/Connie Middleton left Voicemail.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"7/30/2024 @ 05:49 PM\"}, {\"date\": \"7/9/2024 @ 02:44 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ FAITH ENWEFAH  OR w/ DELISE ADAMS \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"7/23/2024 @ 02:43 PM\"}, {\"date\": \"5/30/2024 @ 04:45 PM\", \"result\": 6, \"comment\": \"Member requested a call back to schedule a virtual HRA the week of 5/10 - Member has a lunch break at 2 and will need a late afternoon appt.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/10/2024 @ 04:45 PM\"}, {\"date\": \"5/15/2024 @ 02:15 PM\", \"result\": 6, \"comment\": \"Call back later, member was at work and she works with little kids. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/16/2024 @ 02:14 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-15-2024 14:15:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"07-16-2024 12:30:51\", \"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:02:56', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2199, 57818338, 44829497, '62685179', '0007188690001', '418827', '', '26056802', 'Tracy', 'parris', '', '{\"DOB\": 27145, \"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\": \"30547\", \"Program\": \"ACA\", \"PCP_Flag\": null, \"Pcp_City\": \"Homer\", \"Pcp_Name\": \"Nancy McCoy\", \"PCP_Phone\": \"7066774568\", \"Member_City\": \"Gillsville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gillsville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1974-04-26\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"1244 Historic Homer Hwy\", \"Screening_IHA\": \"No\", \"member_id_two\": 418827, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"7066773848\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"6284 Highway 52\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30543, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"6284 Highway 52\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30543, \"Member_Last_name\": \"parris\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Tracy\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"tracycariline426@live.com\", \"Member_Suspect_Codes\": 161.2, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 7067010519, \"Member_Identification_Number\": \"0007188690001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"07-23-2024 11:14:28\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-07-23 11:14:29\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-07-17T19:24\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-07-18T14:24\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-07-18T18:12\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-07-23T11:14\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-07-10T14:35\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-04-29T16:48\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-29T16:48\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-07-10T14:35\", \"reportStatus_date\": \"2024-07-10T14:35\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-07-18T18:12\", \"reportStatus_date\": \"2024-07-18T18:12\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-07-23T11:14\", \"reportStatus_date\": \"2024-07-23T11:14\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-07-23T11:14\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-07-10T14:35\", \"username\": null}, {\"date\": \"2024-07-10T14:35\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-07-17T07:11\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [{\"date\": \"2024-07-18T11:43\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2024-07-17T19:24\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-07-17T19:24\", \"username\": \"FEnwefah\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-07-18T18:12\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-07-18T14:24\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-07-18T18:12\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"16:57:42\", \"value\": [{\"add\": \"6284 Highway 52\", \"age\": 50, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1974-04-26\", \"eno\": \"6789937545\", \"lob\": \"On Exchange\", \"pno\": 7067010519, \"zip\": 30543, \"add2\": \"\", \"add3\": \"\", \"city\": \"Gillsville\", \"gend\": 1, \"insh\": \"0007188690001\", \"mzip\": 30543, \"name\": \"Tracy parris\", \"plan\": \"Alliant\", \"pphy\": \"Nancy McCoy\", \"ppno\": \"7066774568\", \"cliId\": \"\", \"email\": \"tracycariline426@live.com\", \"ename\": \"Barley Stowers\", \"madd1\": \"6284 Highway 52\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gillsville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"1244 Historic Homer Hwy\", \"pcpnpi\": \"\", \"pcpzip\": \"30547\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Single\", \"pcpcity\": \"Homer\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"7066773848\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Female\", \"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\": \"07-17-2024\", \"time\": \"07:11:48\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 16:57:42\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"7/10/2024 @ 02:35 PM\", \"result\": 0, \"comment\": \"Called to set up HRA with Faith Enwefah Left voicemail\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"4/29/2024 @ 04:48 PM\", \"result\": 6, \"comment\": \"Called to schedule F2F HRA w/ Sallie Key - Call Back - member is currently in the car looking for a tag office - Asked for call back at later time \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/13/2024 @ 04:48 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0007188690001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"62685179\", \"memberId\": \"0007188690001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"62685179\", \"memberId\": \"0007188690001\", \"scheduleDate\": \"2024-7-17T16:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-29-2024 16:48:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"07-10-2024 14:35:40\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 0, NULL, '[{\"date\": \"2024-07-23 11:14:27\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"4099b075-4906-11ef-a545-03490752f8e8\\\",\\\"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-17T16:00', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:02:56', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007188690001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0007188690001_parris, Tracy_07172024.pdf\", \"ftp_upload_date\": \"2024-07-23 11:14:27\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Nancy, Dr._0007188690001_07172024.pdf\"}', 'ACA_0007188690001_parris, Tracy_07172024', NULL, 'PCP_Nancy, Dr._0007188690001_07172024', NULL, '[{\"date\": \"2024-07-17T23:24:15.853Z\", \"signature\": \"data:image/png;base64,[encoded data, 23400 characters]\"}]', '2024-07-17T16:00', 'Member_Summary_0007188690001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007188690001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0007188690001.pdf\", \"member_ftp_upload_date\": \"2024-07-23 11:14:28\"}', NULL, NULL, NULL, NULL);
