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
(4196, 57818338, 44829497, '96917241', '0007345305001', '431417', '', '84929813', 'Dovetose', 'Lewis', '', '{\"DOB\": 23312, \"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\": \"31792\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"Thomasville\", \"Pcp_Name\": \"Dale Wing\", \"Rank_All\": \"\", \"PCP_Phone\": \"229-584-4100\", \"Pcp_State\": \"\", \"Member_City\": \"Boston\", \"Office_Name\": \"Archbold Primary Care \", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Boston\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1963-10-28\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"2621 East Pinetree Blvd\", \"Screening_IHA\": \"No\", \"member_id_two\": 431417, \"Mailing_County\": \"THOMAS\", \"Member_Country\": \"THOMAS\", \"PCP_Fax_Number\": \"2295845955\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"256 S Gossier St\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 31626, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"256 S Gossier St\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31626, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Lewis\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Dovetose\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45413, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"wezzie56@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 2294133366, \"Member_Identification_Number\": \"0007345305001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"08-20-2024 10:34:03\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-08-20 10:34:03\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-08T13:04\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-08-10T14:12\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-13T20:00\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-13T21:12\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-20T10:34\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-08-08T15:19\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-08-10T14:12\", \"reportStatus_date\": \"2024-08-10T14:12\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-08-13T21:12\", \"reportStatus_date\": \"2024-08-13T21:12\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-08-20T10:34\", \"reportStatus_date\": \"2024-08-20T10:34\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-08-20T10:34\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-08-08T15:19\", \"username\": null}, {\"date\": \"2024-08-08T15:19\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-08-10T13:31\", \"username\": \"NCox\"}], \"qaAssigned\": [{\"date\": \"2024-08-12T10:34\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2024-08-10T14:12\", \"username\": \"NCox\"}, {\"date\": \"2024-08-10T14:12\", \"username\": \"NCox\"}, {\"date\": \"2024-08-13T18:48\", \"username\": \"JSilverio\"}, {\"date\": \"2024-08-13T19:37\", \"username\": \"NCox\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-08-13T21:12\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-08-13T20:00\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-08-13T21:12\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-08-13T18:48\", \"username\": \"JSilverio\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"09-25-2024\", \"time\": \"10:36:41\", \"value\": [{\"add\": \"256 S Gossier St\", \"age\": 60, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1963-10-28\", \"eno\": \"229-498-2535\", \"lob\": \"On Exchange\", \"pno\": 2294133366, \"zip\": 31626, \"add2\": \"\", \"add3\": \"\", \"city\": \"Boston\", \"gend\": 1, \"insh\": \"0007345305001\", \"mzip\": 31626, \"name\": \"Dovetose Lewis\", \"plan\": \"Alliant\", \"pphy\": \"Dale Wing\", \"ppno\": \"229-584-4100\", \"cliId\": \"\", \"email\": \"wezzie56@gmail.com\", \"ename\": \"Eddie Lewis Sr.\", \"madd1\": \"256 S Gossier St\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Boston\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"2621 East Pinetree Blvd\", \"pcpnpi\": \"\", \"pcpzip\": \"31792\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"Thomasville\", \"pcpname\": \"Archbold Primary Care \", \"program\": \"ACA\", \"pcpfaxno\": \"2295845955\", \"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\": {\"sub\": [], \"indx\": [[\"Jehovah\'s Witness \"]], \"comment\": [[\"\"]]}, \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-10-2024\", \"time\": \"13:31:30\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"09-25-2024 10:36:41\"}', NULL, NULL, '{\"memberId\": \"0007345305001\", \"clinician\": \"Nykya Cox\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Tue, 13 Aug 2024 22:48:49 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"1.  Mini Cog and TUG are reported as N/A please add comments why.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Tue, 13 Aug 2024 23:37:47 GMT\", \"name\": \"Nykya \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"\"}, \"mailId\": \"\"}], \"memberName\": \"Dovetose Lewis\", \"codingAnalyst\": \"\", \"dateOfService\": \"08/10/2024 01:30 PM\", \"clinicianMailId\": \"n.cox@focuscares.com\", \"qaAnalystMailId\": \"j.silverio@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"8/8/2024 @ 03:19 PM\", \"result\": 0, \"comment\": \"Scheduled virtual HRA w/ Nykya Cox on 8/10 @ 1:30 - texted Doxy link to member. Member will use their phone to complete the assessment. \", \"inBound\": true, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"8/8/2024 @ 01:04 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Mariana Bernard\", \"callbackDate\": \"8/15/2024 @ 01:04 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0007345305001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"96917241\", \"memberId\": \"0007345305001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"96917241\", \"memberId\": \"0007345305001\", \"scheduleDate\": \"2024-8-10T13:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-08-2024 13:04:00\", \"schedulerId\": \"84929813\", \"schedulerLeadId\": \"84929813\"}]}', '{\"date\": \"08-08-2024 15:19:47\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 0, NULL, '[{\"date\": \"2024-08-20 10:34:00\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"3dbfa3ec-5f01-11ef-addd-794385f47bee\\\",\\\"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-8-10T13:30', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:35:38', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007345305001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0007345305001_Lewis, Dovetose_08102024.pdf\", \"ftp_upload_date\": \"2024-08-20 10:34:00\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Wing, Dale_0007345305001_08102024.pdf\"}', 'ACA_0007345305001_Lewis, Dovetose_08102024', NULL, 'PCP_Wing, Dale_0007345305001_08102024', NULL, '[{\"date\": \"2024-08-10T18:12:03.413Z\", \"signature\": \"data:image/png;base64,[encoded data, 25504 characters]\"}, {\"date\": \"2024-08-13T23:37:47.119Z\", \"signature\": \"data:image/png;base64,[encoded data, 25532 characters]\"}]', '2024-08-10T14:11', 'Member_Summary_0007345305001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007345305001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0007345305001.pdf\", \"member_ftp_upload_date\": \"2024-08-20 10:34:02\"}', 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
(4197, NULL, NULL, NULL, '0007345449001', '299401', '', '21881792', 'Yasmeen', 'Rodriguez', '', '{\"DOB\": 37600, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Cleveland\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Cleveland\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"2002-12-10\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 299401, \"Mailing_County\": \"WHITE\", \"Member_Country\": \"WHITE\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"162 Pine Crest Cir\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30528, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"162 Pine Crest Cir\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30528, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Rodriguez\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Yasmeen\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45444, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"yasmeenarodriguez02@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6783341204, \"Member_Identification_Number\": \"0007345449001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:37:31\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:37:31\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-12-16T01:07\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-22T15:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-23T15:00\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-29T14:42\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-29T13:57\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T01:07\", \"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-08-23T15:00\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-29T14:42\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-29T13:57\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-16T01:07\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:35:38\", \"value\": [{\"add\": \"162 Pine Crest Cir\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"2002-12-10\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6783341204, \"zip\": 30528, \"add2\": \"\", \"add3\": \"\", \"city\": \"Cleveland\", \"gend\": 1, \"insh\": \"0007345449001\", \"mzip\": 30528, \"name\": \"Yasmeen Rodriguez\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"yasmeenarodriguez02@gmail.com\", \"ename\": \"\", \"madd1\": \"162 Pine Crest Cir\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Cleveland\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:35:38\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:35:38\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"12/6/2024 @ 11:22 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/22/2024 @ 11:10 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/29/2024 @ 01:57 PM\", \"result\": 3, \"comment\": \"called for HRA-Virtual - Nykya Cox-GA, RN,NP : LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Rocheline Lovaincy\", \"callbackDate\": \"10/30/2024 @ 01:57 PM\"}, {\"date\": \"8/29/2024 @ 02:42 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA with Delise Adams LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"9/9/2024 @ 02:42 PM\"}, {\"date\": \"8/23/2024 @ 03:00 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA with Delise Adams LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"9/3/2024 @ 02:59 PM\"}, {\"date\": \"8/22/2024 @ 03:18 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA w/ Delise Adams. - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/23/2024 @ 03:18 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-22-2024 15:18:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"12-16-2024 01:07:57\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:35:38', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4198, NULL, NULL, NULL, '0007346678001', '434747', '', '33985161', 'Erika', 'Rukes', '', '{\"DOB\": 28817, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Warthen\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Warthen\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1978-11-23\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 434747, \"Mailing_County\": \"WASHINGTON\", \"Member_Country\": \"WASHINGTON\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"3515 Bay Springs Rd\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 31094, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"3515 Bay Springs Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31094, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Rukes\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Erika\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45444, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"misse78@outlook.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4782479875, \"Member_Identification_Number\": \"0007346678001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:37:31\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:37:31\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-12-16T00:49\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-14T14:02\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-09-13T16:48\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-09-27T17:26\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-16T16:43\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T00:49\", \"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-08-14T14:02\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-09-13T16:48\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-09-27T17:26\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-16T16:43\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-15T05:47\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-16T00:49\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-12-09T09:36\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:35:39\", \"value\": [{\"add\": \"3515 Bay Springs Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1978-11-23\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4782479875, \"zip\": 31094, \"add2\": \"\", \"add3\": \"\", \"city\": \"Warthen\", \"gend\": 1, \"insh\": \"0007346678001\", \"mzip\": 31094, \"name\": \"Erika Rukes\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"misse78@outlook.com\", \"ename\": \"\", \"madd1\": \"3515 Bay Springs Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Warthen\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:35:39\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:35:39\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 13, \"callLog\": [{\"date\": \"11/13/2024 @ 12:19 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/12/2024 @ 12:05 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/11/2024 @ 11:42 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/7/2024 @ 07:25 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 06:10 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/16/2024 @ 04:43 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - Mailbox Full. \", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/17/2024 @ 04:43 PM\"}, {\"date\": \"9/27/2024 @ 05:26 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"9/30/2024 @ 05:26 PM\"}, {\"date\": \"9/13/2024 @ 04:48 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"9/16/2024 @ 04:48 PM\"}, {\"date\": \"8/14/2024 @ 02:02 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a virtual HRA w/ Nykya Cox. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Alyia Williams\", \"callbackDate\": \"8/15/2024 @ 02:02 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-14-2024 14:02:00\", \"schedulerId\": \"33985161\", \"schedulerLeadId\": \"33985161\"}]}', '{\"date\": \"12-16-2024 00:49:39\", \"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', '07-08-2024 01:35:39', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4199, NULL, NULL, NULL, '0007347211002', '410677', '', NULL, 'Kimberly', 'Loescher', '', '{\"DOB\": 31503, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Braselton\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Braselton\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1986-04-01\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 410677, \"Mailing_County\": \"JACKSON\", \"Member_Country\": \"JACKSON\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"177 Springfield Ln\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30517, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"177 Springfield Ln\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30517, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Loescher\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Kimberly\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"21, 212\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Identification_Number\": \"0007347211002\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:37:31\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:37:31\", \"hrastatus\": 18, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:35:39\", \"value\": [{\"add\": \"177 Springfield Ln\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1986-04-01\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": \"\", \"zip\": 30517, \"add2\": \"\", \"add3\": \"\", \"city\": \"Braselton\", \"gend\": 1, \"insh\": \"0007347211002\", \"mzip\": 30517, \"name\": \"Kimberly Loescher\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"177 Springfield Ln\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Braselton\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:35:39\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:35:39\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"08-08-2024 00:33:13\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', NULL, NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:35:39', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4200, NULL, NULL, NULL, '0007347642001', '426275', '', '21881792', 'Steven', 'Hubbard', '', '{\"DOB\": 24103, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Temple\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Temple\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1965-12-27\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 426275, \"Mailing_County\": \"CARROLL\", \"Member_Country\": \"CARROLL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"937 RAINEY RD\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30179, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"937 RAINEY RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30179, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Hubbard\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Steven\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45352, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"woodward.j.1960@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4048623940, \"Member_Identification_Number\": \"0007347642001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:37:31\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:37:31\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-29T16:02\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [{\"date\": \"2024-10-15T10:56\", \"text\": \"Wrong Number\", \"method\": \"api\", \"status\": 7}], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-08-13T12:51\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-08-27T17:57\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-13T12:51\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-29T16:02\"}, {\"text\": \"Wrong Number\", \"type\": \"ReportStatus\", \"status\": 7, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-15T10:56\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:35:39\", \"value\": [{\"add\": \"937 RAINEY RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1965-12-27\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4048623940, \"zip\": 30179, \"add2\": \"\", \"add3\": \"\", \"city\": \"Temple\", \"gend\": 0, \"insh\": \"0007347642001\", \"mzip\": 30179, \"name\": \"Steven Hubbard\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"woodward.j.1960@gmail.com\", \"ename\": \"\", \"madd1\": \"937 RAINEY RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Temple\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:35:39\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:35:39\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 4, \"callLog\": [{\"date\": \"10/15/2024 @ 10:56 AM\", \"result\": 4, \"comment\": \"Call attempt to schedule an HRA - Wrong number - number belongs to wife - previous agent notes. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"8/29/2024 @ 04:02 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Faith no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"9/5/2024 @ 04:02 PM\"}, {\"date\": \"8/27/2024 @ 05:57 PM\", \"result\": 6, \"comment\": \"Per agent notes: 8/14 - Number belongs to member\'s wife. No alternate number to reach member. Call attempt to schedule an HRA w/ Faith Enwefah. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/28/2024 @ 05:57 PM\"}, {\"date\": \"8/13/2024 @ 12:51 PM\", \"result\": 6, \"comment\": \"Number belongs to member\'s wife. Spouse is not available at time of call. Call attempt to schedule a virtual HRA w/ Faith E. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/14/2024 @ 12:51 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-13-2024 12:51:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"10-15-2024 10:56:46\", \"status\": 2, \"details\": \"disconnected/wrong number\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 4}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:35:39', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4201, NULL, NULL, NULL, '0007348451001', '411751', '', '21881792', 'Alekzander', 'Joslin', '', '{\"DOB\": 34811, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Clarkesville\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Clarkesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1995-04-22\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 411751, \"Mailing_County\": \"HABERSHAM\", \"Member_Country\": \"HABERSHAM\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"301 Wall Bridge Loop\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30523, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"301 Wall Bridge Loop\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30523, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Joslin\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Alekzander\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"AlekzanderJoslin95@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7068946839, \"Member_Identification_Number\": \"0007348451001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:37:31\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:37:31\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-09-23T15:04\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-09-25T14:02\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-03T11:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-08-14T15:57\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-14T15:57\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-09-23T15:04\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-09-25T14:02\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-03T11:19\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:33\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-12-09T09:36\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:35:40\", \"value\": [{\"add\": \"301 Wall Bridge Loop\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1995-04-22\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7068946839, \"zip\": 30523, \"add2\": \"\", \"add3\": \"\", \"city\": \"Clarkesville\", \"gend\": 0, \"insh\": \"0007348451001\", \"mzip\": 30523, \"name\": \"Alekzander Joslin\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"AlekzanderJoslin95@gmail.com\", \"ename\": \"\", \"madd1\": \"301 Wall Bridge Loop\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Clarkesville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:35:40\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:35:40\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/31/2024 @ 12:43 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/30/2024 @ 12:19 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/29/2024 @ 11:51 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/3/2024 @ 11:19 AM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/4/2024 @ 11:19 AM\"}, {\"date\": \"9/25/2024 @ 02:02 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"9/26/2024 @ 02:02 PM\"}, {\"date\": \"9/23/2024 @ 03:04 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA with Delise--LVM-LLA \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"9/27/2024 @ 03:04 PM\"}, {\"date\": \"8/14/2024 @ 03:57 PM\", \"result\": 6, \"comment\": \"Member requested a call back for a later date and time. Call attempt to schedule a virtual HRA w/ Delise Adams. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/15/2024 @ 03:57 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-14-2024 15:57:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"11-11-2024 00:33:43\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 7}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:35:40', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4202, NULL, NULL, NULL, '0007350571001', '403024', '', '33985161', 'David', 'Brown', '', '{\"DOB\": 22238, \"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\": \"\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"PCP_Phone\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Waynesboro\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Waynesboro\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1960-11-18\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 403024, \"Mailing_County\": \"BURKE\", \"Member_Country\": \"BURKE\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"2203 GA Highway 24 S\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30830, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"2203 GA Highway 24 S\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30830, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Brown\", \"Medication_Review\": \"N\", \"Member_first_name\": \"David\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45323, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"\", \"Member_Email_Address\": \"david.brown8572@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7068368572, \"Member_Identification_Number\": \"0007350571001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 2, b'0', b'1', '{\"date\": \"01-01-2025 23:37:31\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:37:31\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-14T14:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-09-27T17:27\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2024-11-06T18:14\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-10-16T16:55\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [{\"date\": \"2024-10-28T07:49\", \"text\": \"Virtual No Show\", \"method\": \"api\", \"status\": 23}], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-14T14:05\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-09-27T17:27\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-10-16T16:55\", \"reportStatus_date\": \"2024-10-16T16:55\"}, {\"text\": \"Virtual No Show\", \"type\": \"ReportStatus\", \"status\": 23, \"hraStatus\": 19, \"hraStatus_date\": \"2024-10-28T07:49\", \"reportStatus_date\": \"2024-10-28T07:49\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-11-06T18:14\", \"reportStatus_date\": \"2024-11-06T18:14\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-10-28T07:49\", \"username\": \"FEnwefah\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-10-16T16:55\", \"username\": null}, {\"date\": \"2024-10-16T16:55\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-10-25T09:54\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-11-06T18:14\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"10-25-2024\", \"time\": \"09:54:18\", \"value\": [{\"add\": \"2203 GA Highway 24 S\", \"age\": 63, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1960-11-18\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7068368572, \"zip\": 30830, \"add2\": \"\", \"add3\": \"\", \"city\": \"Waynesboro\", \"gend\": 0, \"insh\": \"0007350571001\", \"mzip\": 30830, \"name\": \"David Brown\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"david.brown8572@gmail.com\", \"ename\": \"\", \"madd1\": \"2203 GA Highway 24 S\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Waynesboro\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"10-25-2024\", \"time\": \"09:54:18\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"10-25-2024 10:06:05\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2024-10-28T07:49\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"FEnwefah\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [{\"date\": \"2024-11-06T18:14\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"11/6/2024 @ 06:14 PM\", \"result\": 9, \"comment\": \"doesn\'t want to do this and sees no need if its not required\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Rebecca Mangold\", \"callbackDate\": \"\"}, {\"date\": \"10/16/2024 @ 04:55 PM\", \"result\": 0, \"comment\": \"Scheduled - virtual HRA on 10/25/2024 @ 11:30 - w/Faith Enwefah.  TEXTED doxy link to member. Member will use their phone.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"9/27/2024 @ 05:27 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - No VM setup.\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"9/30/2024 @ 05:27 PM\"}, {\"date\": \"8/14/2024 @ 02:05 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a virtual HRA w/ Nykya Cox. \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Alyia Williams\", \"callbackDate\": \"8/15/2024 @ 02:04 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0007350571001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"62685179\", \"memberId\": \"0007350571001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"62685179\", \"memberId\": \"0007350571001\", \"scheduleDate\": \"2024-10-25T11:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-14-2024 14:05:00\", \"schedulerId\": \"33985161\", \"schedulerLeadId\": \"33985161\"}, {\"date\": \"10-28-2024 07:49:36\", \"schedulerId\": \"33985161\", \"schedulerLeadId\": \"33985161\"}]}', '{\"date\": \"10-28-2024 07:49:36\", \"status\": 0, \"details\": \"scheduled member moved to no show/cancellation\", \"disabled\": false, \"notification\": {\"type\": 1, \"value\": \"\", \"previous_status\": 1}}', '{\"attemptCount\": 4}', NULL, 1, NULL, NULL, 'Virtual', NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:35:40', 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
(4203, 71932120, 44829497, '56716210', '0007350942001', '416965', '', '99038484', 'Alexis', 'Hill', '', '{\"DOB\": 33777, \"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\": \"30043\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"Lawrenceville\", \"Pcp_Name\": \"Elliott Raizes\", \"Rank_All\": \"\", \"PCP_Phone\": \"7709950466\", \"Pcp_State\": \"\", \"Member_City\": \"Commerce\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Commerce\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1992-06-22\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"1960 Riverside Parkway, Suite 101\", \"Screening_IHA\": \"No\", \"member_id_two\": 416965, \"Mailing_County\": \"\", \"Member_Country\": \"JACKSON\", \"PCP_Fax_Number\": \"7709950472\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"94 Hillcrest Dr\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30529, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"PO Box 213\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30529, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Hill\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Alexis\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45505, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Transgender\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"1, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 6787252801, \"Member_Identification_Number\": \"0007350942001\", \"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:44\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-09-12T11:23\", \"hrastatus\": \"\", \"reportstatus\": \"Cancellation\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-12T13:43\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-19T16:03\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": {\"0\": {\"date\": \"2024-11-07T17:27\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, \"3\": {\"date\": \"2024-11-12T21:19\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}}, \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-08-29T16:57\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-10-30T15:05\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2024-09-12T11:23\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-12T13:43\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-19T16:03\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-08-29T16:57\", \"reportStatus_date\": \"2024-08-29T16:57\"}, {\"text\": \"Cancellation\", \"type\": \"ReportStatus\", \"status\": 18, \"hraStatus\": 3, \"hraStatus_date\": \"2024-09-12T11:23\", \"reportStatus_date\": \"2024-09-12T11:23\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-10-30T15:05\", \"reportStatus_date\": \"2024-10-30T15:05\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-11-11T13:48\", \"reportStatus_date\": \"2024-11-11T13:48\"}, {\"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-08-29T16:57\", \"username\": null}, {\"date\": \"2024-08-29T16:57\", \"username\": null}, {\"date\": \"2024-10-30T15:05\", \"username\": null}, {\"date\": \"2024-10-30T15:05\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-09-12T01:30\", \"username\": \"DAdams\"}, {\"date\": \"2024-11-07T07:46\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-11-11T10:04\", \"username\": \"AWalsh\"}, {\"date\": \"2024-11-11T10:05\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2024-11-07T17:27\", \"username\": \"DAdams\"}, {\"date\": \"2024-11-07T17:27\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-11-11T13:48\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-11-11T11:12\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-11-11T13:48\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-09-12T11:23\", \"username\": \"TFerness2\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"01-13-2025\", \"time\": \"16:49:34\", \"value\": [{\"add\": \"94 Hillcrest Dr\", \"age\": 32, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1992-06-22\", \"eno\": \"7063354136\", \"lob\": \"On Exchange\", \"pno\": 6787252801, \"zip\": 30529, \"add2\": \"\", \"add3\": \"\", \"city\": \"Commerce\", \"gend\": 0, \"insh\": \"0007350942001\", \"mzip\": 30529, \"name\": \"Alexis Hill\", \"plan\": \"Alliant\", \"pphy\": \"Elliott Raizes\", \"ppno\": \"7709950466\", \"race\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"Hilda Hill\", \"madd1\": \"PO Box 213\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Commerce\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"1960 Riverside Parkway, Suite 101\", \"pcpnpi\": \"\", \"pcpzip\": \"30043\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Single\", \"pcpFlag\": 0, \"pcpcity\": \"Lawrenceville\", \"pcpname\": \"\", \"program\": \"ACA\", \"evalDate\": \"2024-11-07 1:21 PM\", \"evalName\": \"Delise Adams, FNP\", \"pcpfaxno\": \"7709950472\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Transgender\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"transgender female\"}, {\"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:30:32\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"01-13-2025 16:49:34\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2024-09-12T11:23\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"TFerness2\", \"hraStatus\": 3, \"cancelText\": \"\", \"cancelStatus\": 0}]}', NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"10/30/2024 @ 03:05 PM\", \"result\": 0, \"comment\": \"called for HRA-Virtual - Delise Adams-GA, NP : scheduled for 11/07 @ 1:15pm\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Rocheline Lovaincy\", \"callbackDate\": \"\"}, {\"date\": \"8/29/2024 @ 04:57 PM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA with Delise on 9/12 at 11:30am. Link texted, member using laptop.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"\"}, {\"date\": \"8/19/2024 @ 04:03 PM\", \"result\": 3, \"comment\": \"Called to schedule screening w/ Delise Adams LVM-8/19/2024 LLA\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"8/23/2024 @ 04:03 PM\"}, {\"date\": \"8/12/2024 @ 01:43 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Delise no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"8/19/2024 @ 01:43 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-12-2024 13:43:00\", \"schedulerId\": \"99038484\", \"schedulerLeadId\": \"99038484\"}, {\"date\": \"09-12-2024 11:23:42\", \"schedulerId\": \"99038484\", \"schedulerLeadId\": \"99038484\"}]}', '{\"date\": \"10-30-2024 15:05:46\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 4}', '{\"orderType\": 0, \"sortOrder\": 1730354841}', 0, NULL, '[{\"date\": \"2024-11-12 21:19:42\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"bdbd191a-a165-11ef-b6f0-19c3a0b3f52d\\\",\\\"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-7T13:15', '2024-12-31', '2024-11-07T13:21', NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:35:41', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007350942001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0007350942001_Hill, Alexis_11072024.pdf\", \"ftp_upload_date\": \"2024-11-12 21:19:41\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Raizes, Elliott_0007350942001_11072024.pdf\"}', 'ACA_0007350942001_Hill, Alexis_11072024', NULL, 'PCP_Raizes, Elliott_0007350942001_11072024', NULL, '[{\"date\": \"2024-11-07T22:27:23.610Z\", \"signature\": \"data:image/png;base64,[encoded data, 23364 characters]\"}]', '2024-11-07T14:14', 'Member_Summary_0007350942001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007350942001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0007350942001.pdf\", \"member_ftp_upload_date\": \"2024-11-12 21:19:44\"}', NULL, NULL, NULL, NULL),
(4204, NULL, NULL, NULL, '0007352096001', '411846', '', '21881792', 'Peter', 'Alvanos', '', '{\"DOB\": 23675, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Athens\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Athens\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1964-10-25\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 411846, \"Mailing_County\": \"CLARKE\", \"Member_Country\": \"CLARKE\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"362 Yonah Ave\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30601, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"362 Yonah Ave\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30601, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Alvanos\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Peter\", \"Member_Middle_name\": \"John\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"petesthedrummer@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7062548458, \"Member_Identification_Number\": \"0007352096001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:37:32\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:37:31\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-12-30T23:54\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-10-02T13:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-23T14:44\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T00:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T01:01\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-30T23:54\", \"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-10-02T13:19\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-23T14:44\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:29\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-16T01:01\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-30T23:54\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-11-12T21:19\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-08-29T16:57\", \"username\": null}, {\"date\": \"2024-08-29T16:57\", \"username\": null}, {\"date\": \"2024-10-30T15:05\", \"username\": null}, {\"date\": \"2024-10-30T15:05\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-09-12T01:30\", \"username\": \"DAdams\"}, {\"date\": \"2024-11-07T07:46\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-11-11T10:04\", \"username\": \"AWalsh\"}, {\"date\": \"2024-11-11T10:05\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2024-11-07T17:27\", \"username\": \"DAdams\"}, {\"date\": \"2024-11-07T17:27\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-11-11T13:48\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-11-11T11:12\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-11-11T13:48\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-09-12T11:23\", \"username\": \"TFerness2\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:35:41\", \"value\": [{\"add\": \"362 Yonah Ave\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1964-10-25\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7062548458, \"zip\": 30601, \"add2\": \"\", \"add3\": \"\", \"city\": \"Athens\", \"gend\": 0, \"insh\": \"0007352096001\", \"mzip\": 30601, \"name\": \"Peter John Alvanos\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"petesthedrummer@gmail.com\", \"ename\": \"\", \"madd1\": \"362 Yonah Ave\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Athens\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:35:41\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:35:41\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"12/6/2024 @ 10:08 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/14/2024 @ 11:07 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"11/16/2024 @ 09:30 AM\"}, {\"date\": \"10/28/2024 @ 02:27 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"10/30/2024 @ 09:30 AM\"}, {\"date\": \"10/23/2024 @ 02:44 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/24/2024 @ 02:44 PM\"}, {\"date\": \"10/2/2024 @ 01:19 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/3/2024 @ 01:18 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"10-02-2024 13:19:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"12-30-2024 23:54:45\", \"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', '07-08-2024 01:35:41', 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
(4205, NULL, NULL, NULL, '0007353171001', '413901', '', '84929813', 'Angel Xavier', 'Quinones Oquendo', '', '{\"DOB\": 33938, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Gainesville\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gainesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1992-11-30\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 413901, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"3134 Cedar Way Apt F3\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30507, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"3134 Cedar Way Apt F3\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30507, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Quinones Oquendo\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Angel Xavier\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7879881319, \"Member_Identification_Number\": \"0007353171001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:37:32\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:37:32\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-09T14:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-21T11:33\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-23T12:31\", \"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-08-23T12:35\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-09T14:05\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-23T12:35\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:52\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-11-12T21:19\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-08-29T16:57\", \"username\": null}, {\"date\": \"2024-08-29T16:57\", \"username\": null}, {\"date\": \"2024-10-30T15:05\", \"username\": null}, {\"date\": \"2024-10-30T15:05\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-09-12T01:30\", \"username\": \"DAdams\"}, {\"date\": \"2024-11-07T07:46\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-11-11T10:04\", \"username\": \"AWalsh\"}, {\"date\": \"2024-11-11T10:05\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2024-11-07T17:27\", \"username\": \"DAdams\"}, {\"date\": \"2024-11-07T17:27\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-11-11T13:48\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-11-11T11:12\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-11-11T13:48\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-09-12T11:23\", \"username\": \"TFerness2\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:35:41\", \"value\": [{\"add\": \"3134 Cedar Way Apt F3\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1992-11-30\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7879881319, \"zip\": 30507, \"add2\": \"\", \"add3\": \"\", \"city\": \"Gainesville\", \"gend\": 0, \"insh\": \"0007353171001\", \"mzip\": 30507, \"name\": \"Angel Xavier Quinones Oquendo\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"3134 Cedar Way Apt F3\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gainesville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:35:41\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:35:41\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/7/2024 @ 01:04 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 01:05 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 05:41 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/31/2024 @ 04:24 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"8/23/2024 @ 12:35 PM\", \"result\": 6, \"comment\": \"Member requested a call back - call attempt to schedule a HRA w/ Delise Adams. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/26/2024 @ 12:35 PM\"}, {\"date\": \"8/23/2024 @ 12:31 PM\", \"result\": 1, \"comment\": \"Call answered but no sound on call. Call to schedule a HRA w/ Delise Adams. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/26/2024 @ 12:31 PM\"}, {\"date\": \"8/21/2024 @ 11:33 AM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA w/ Delise Adams on 9/3. - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/22/2024 @ 11:33 AM\"}, {\"date\": \"8/9/2024 @ 02:05 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mariana Bernard\", \"callbackDate\": \"8/16/2024 @ 02:05 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-09-2024 14:05:00\", \"schedulerId\": \"84929813\", \"schedulerLeadId\": \"84929813\"}]}', '{\"date\": \"11-11-2024 00:52:59\", \"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', '07-08-2024 01:35:41', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4206, 55499828, 44829497, '56716210', '0007353619001', '429069', '', '21881792', 'Timothy', 'Saxon', '', '{\"DOB\": 22310, \"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\": \"30606\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"Athens\", \"Pcp_Name\": \"Lee Chisolm\", \"Rank_All\": \"\", \"PCP_Phone\": \"7062081406\", \"Pcp_State\": \"\", \"Member_City\": \"Bogart\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Bogart\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1961-01-29\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"1500 OGLETHORPE AVE SUITE 3300\", \"Screening_IHA\": \"No\", \"member_id_two\": 429069, \"Mailing_County\": \"OCONEE\", \"Member_Country\": \"OCONEE\", \"PCP_Fax_Number\": \"7062081407\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1564 Ruth Jackson Road\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30622, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"1564 Ruth Jackson Road\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30622, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Saxon\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Timothy\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45469, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"tsaxon61@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 7062075914, \"Member_Identification_Number\": \"0007353619001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'1', '{\"date\": \"10-08-2024 14:08:13\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-10-08 14:08:13\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-09-25T13:34\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-10-04T12:17\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-10-07T18:24\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-10-07T19:15\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-10-08T14:08\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-10-02T15:01\", \"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-09-25T13:34\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-10-07T19:15\", \"reportStatus_date\": \"2024-10-07T19:15\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-10-08T14:08\", \"reportStatus_date\": \"2024-10-08T14:08\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-10-08T14:08\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-10-02T15:01\", \"username\": null}, {\"date\": \"2024-10-02T15:01\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-10-03T14:27\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-10-07T11:29\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2024-10-04T12:17\", \"username\": \"DAdams\"}, {\"date\": \"2024-10-04T12:17\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-10-07T19:15\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-10-07T18:24\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-10-07T19:15\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"11-25-2024\", \"time\": \"15:25:42\", \"value\": [{\"add\": \"1564 Ruth Jackson Road\", \"age\": 63, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1961-01-29\", \"eno\": \"7706011807\", \"lob\": \"On Exchange\", \"pno\": 7062075914, \"zip\": 30622, \"add2\": \"\", \"add3\": \"\", \"city\": \"Bogart\", \"gend\": 0, \"insh\": \"0007353619001\", \"mzip\": 30622, \"name\": \"Timothy Saxon\", \"plan\": \"Alliant\", \"pphy\": \"Lee Chisolm\", \"ppno\": \"7062081406\", \"race\": \"\", \"cliId\": \"\", \"email\": \"tsaxon61@gmail.com\", \"ename\": \"Ann Saxon\", \"madd1\": \"1564 Ruth Jackson Road\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Bogart\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"1500 OGLETHORPE AVE SUITE 3300\", \"pcpnpi\": \"\", \"pcpzip\": \"30606\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"Athens\", \"pcpname\": \"\", \"program\": \"ACA\", \"evalDate\": \"2024-10-4 09:45 AM\", \"evalName\": \"Delise Adams, FNP\", \"pcpfaxno\": \"7062081407\", \"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\": [\"\", \"\"]}}, {\"a\": {\"indx\": [], \"score\": [], \"comment\": []}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"10-03-2024\", \"time\": \"14:27:38\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"11-25-2024 15:25:42\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"10/2/2024 @ 03:01 PM\", \"result\": 0, \"comment\": \"Scheduled virtual HRA w/ Delise A on 10/4 @ 9:45 - member will use their desktop - emailed doxy link to member @ tsaxon2961@gmail.com. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"9/25/2024 @ 01:34 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"9/26/2024 @ 01:34 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0007353619001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"56716210\", \"memberId\": \"0007353619001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"56716210\", \"memberId\": \"0007353619001\", \"scheduleDate\": \"2024-10-4T09:45\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"09-25-2024 13:34:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"10-02-2024 15:01:46\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 0, NULL, '[{\"date\": \"2024-10-08 14:08:11\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"47cb44bf-85a0-11ef-837b-9d28a69153e9\\\",\\\"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-10-4T09:45', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:35:42', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007353619001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0007353619001_Saxon, Timothy_10042024.pdf\", \"ftp_upload_date\": \"2024-10-08 14:08:11\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Chisolm, Lee_0007353619001_10042024.pdf\"}', 'ACA_0007353619001_Saxon, Timothy_10042024', NULL, 'PCP_Chisolm, Lee_0007353619001_10042024', NULL, '[{\"date\": \"2024-10-04T16:17:10.557Z\", \"signature\": \"data:image/png;base64,[encoded data, 23396 characters]\"}]', '2024-10-04T10:54', 'Member_Summary_0007353619001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007353619001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0007353619001.pdf\", \"member_ftp_upload_date\": \"2024-10-08 14:08:12\"}', NULL, NULL, NULL, NULL),
(4207, NULL, NULL, NULL, '0007353771001', '433031', '', NULL, 'Christopher', 'Perlote', '', '{\"DOB\": 23672, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Washington\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Washington\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1964-10-22\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 433031, \"Mailing_County\": \"WILKES\", \"Member_Country\": \"WILKES\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-07-31\", \"Member_Address1\": \"116 Sim Dill Dr\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30673, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"116 Sim Dill Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30673, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Perlote\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Christopher\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45444, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7069907567, \"Member_Identification_Number\": \"0007353771001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"08-08-2024 00:00:19\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2024-08-08 00:00:19\", \"hrastatus\": 18, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:35:42\", \"value\": [{\"add\": \"116 Sim Dill Dr\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1964-10-22\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7069907567, \"zip\": 30673, \"add2\": \"\", \"add3\": \"\", \"city\": \"Washington\", \"gend\": 0, \"insh\": \"0007353771001\", \"mzip\": 30673, \"name\": \"Christopher Perlote\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"116 Sim Dill Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Washington\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:35:42\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:35:42\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"08-08-2024 00:33:14\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', NULL, NULL, 1, NULL, NULL, NULL, NULL, '2024-07-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:35:42', 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
(4208, NULL, NULL, NULL, '0007354201002', '402870', '', NULL, 'Dionisio', 'Dieguez', '', '{\"DOB\": 22262, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Sale City\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Sale City\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1960-12-12\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 402870, \"Mailing_County\": \"MITCHELL\", \"Member_Country\": \"MITCHELL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"155 E Maple St\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 31784, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"155 E Maple St\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31784, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Dieguez\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Dionisio\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Identification_Number\": \"0007354201002\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:37:32\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:37:32\", \"hrastatus\": 18, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:35:42\", \"value\": [{\"add\": \"155 E Maple St\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1960-12-12\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": \"\", \"zip\": 31784, \"add2\": \"\", \"add3\": \"\", \"city\": \"Sale City\", \"gend\": 0, \"insh\": \"0007354201002\", \"mzip\": 31784, \"name\": \"Dionisio Dieguez\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"155 E Maple St\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Sale City\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:35:42\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:35:42\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"08-08-2024 00:33:14\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', NULL, NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:35:42', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4209, NULL, NULL, NULL, '0007354317001', '406576', '', '84929813', 'Rita', 'Stanfield', '', '{\"DOB\": 23066, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Chickamauga\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Chickamauga\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1963-02-24\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 406576, \"Mailing_County\": \"WALKER\", \"Member_Country\": \"WALKER\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"209 Walthall Ave\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30707, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"209 Walthall Ave\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30707, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Stanfield\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Rita\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"momakatfish1@hotmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4235809455, \"Member_Identification_Number\": \"0007354317001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:37:32\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:37:32\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-14T15:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-22T15:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-01T13:43\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-09T15:42\", \"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-08-14T15:19\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-22T15:05\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-01T13:43\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-09T15:42\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:33\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-11-12T21:19\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-08-29T16:57\", \"username\": null}, {\"date\": \"2024-08-29T16:57\", \"username\": null}, {\"date\": \"2024-10-30T15:05\", \"username\": null}, {\"date\": \"2024-10-30T15:05\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-09-12T01:30\", \"username\": \"DAdams\"}, {\"date\": \"2024-11-07T07:46\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-11-11T10:04\", \"username\": \"AWalsh\"}, {\"date\": \"2024-11-11T10:05\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2024-11-07T17:27\", \"username\": \"DAdams\"}, {\"date\": \"2024-11-07T17:27\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-11-11T13:48\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-11-11T11:12\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-11-11T13:48\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-09-12T11:23\", \"username\": \"TFerness2\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:35:43\", \"value\": [{\"add\": \"209 Walthall Ave\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1963-02-24\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4235809455, \"zip\": 30707, \"add2\": \"\", \"add3\": \"\", \"city\": \"Chickamauga\", \"gend\": 1, \"insh\": \"0007354317001\", \"mzip\": 30707, \"name\": \"Rita Stanfield\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"momakatfish1@hotmail.com\", \"ename\": \"\", \"madd1\": \"209 Walthall Ave\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Chickamauga\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:35:43\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:35:43\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/29/2024 @ 11:06 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/9/2024 @ 03:42 PM\", \"result\": 3, \"comment\": \"LVM to schedule with Connie Middleton for HRA-LLA\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"10/16/2024 @ 03:42 PM\"}, {\"date\": \"10/1/2024 @ 01:43 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/2/2024 @ 01:43 PM\"}, {\"date\": \"8/22/2024 @ 03:05 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Debbie no answer LVM. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"8/29/2024 @ 03:04 PM\"}, {\"date\": \"8/14/2024 @ 03:19 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mariana Bernard\", \"callbackDate\": \"8/21/2024 @ 03:19 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-14-2024 15:19:00\", \"schedulerId\": \"84929813\", \"schedulerLeadId\": \"84929813\"}]}', '{\"date\": \"11-11-2024 00:33:29\", \"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', '07-08-2024 01:35:43', 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
(4210, 3285757, 44829497, '62685179', '0007355663001', '403648', '', '47262451', 'Allison', 'Diaz', '', '{\"DOB\": 33602, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"PCP_NPI\": 1235621897, \"Pcp_Zip\": \"31015\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"Cordele\", \"Pcp_Name\": \"JODI LOTT\", \"Rank_All\": \"\", \"PCP_Phone\": \"2292760100\", \"Pcp_State\": \"GA\", \"Member_City\": \"Rochelle\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Rochelle\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1991-12-30\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"215 E 13th Ave,\", \"Screening_IHA\": \"No\", \"member_id_two\": 403648, \"Mailing_County\": \"BEN HILL\", \"Member_Country\": \"BEN HILL\", \"PCP_Fax_Number\": \"2292760300\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"446 Perry Rd\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 31079, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"446 Perry Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31079, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Diaz\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Allison\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 2293252093, \"Member_Identification_Number\": \"0007355663001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"09-10-2024 10:11:45\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-09-10 10:11:45\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-09T18:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-09-02T05:36\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-09-04T21:24\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-09-05T00:59\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-09-10T10:11\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-08-16T14:10\", \"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-08-09T18:19\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-08-16T14:10\", \"reportStatus_date\": \"2024-08-16T14:10\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-09-02T05:36\", \"reportStatus_date\": \"2024-09-02T05:36\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-09-05T00:59\", \"reportStatus_date\": \"2024-09-05T00:59\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-09-10T10:11\", \"reportStatus_date\": \"2024-09-10T10:11\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-09-10T10:11\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-08-16T14:10\", \"username\": null}, {\"date\": \"2024-08-16T14:10\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-08-30T10:01\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [{\"date\": \"2024-09-03T20:50\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2024-09-02T05:36\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-09-02T05:36\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-09-04T15:34\", \"username\": \"FEnwefah\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-09-05T00:59\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-09-04T21:24\", \"username\": \"BClark\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-09-05T00:59\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-09-04T10:14\", \"username\": \"BClark\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"10-29-2024\", \"time\": \"17:21:42\", \"value\": [{\"add\": \"446 Perry Rd\", \"age\": 32, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1991-12-30\", \"eno\": \"2293897185\", \"lob\": \"On Exchange\", \"pno\": 2293252093, \"zip\": 31079, \"add2\": \"\", \"add3\": \"\", \"city\": \"Rochelle\", \"gend\": 1, \"insh\": \"0007355663001\", \"mzip\": 31079, \"name\": \"Allison Diaz\", \"plan\": \"Alliant\", \"pphy\": \"JODI LOTT\", \"ppno\": \"2292760100\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"Lisa Chadwick\", \"madd1\": \"446 Perry Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Rochelle\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"215 E 13th Ave,\", \"pcpnpi\": 1235621897, \"pcpzip\": \"31015\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Divorced\", \"pcpFlag\": 0, \"pcpcity\": \"Cordele\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"2292760300\", \"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\": \"08-30-2024\", \"time\": \"10:01:56\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"10-29-2024 17:21:42\"}', NULL, NULL, '{\"memberId\": \"0007355663001\", \"clinician\": \"Faith Enwefah\", \"qaAnalyst\": \"Brianne Clark\", \"queryData\": [{\"date\": \"Wed, 04 Sep 2024 14:14:30 GMT\", \"name\": \"Brianne \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Faith,\\nThank you for your thorough assessment!\\n\\n1) Under medications, can you please select either taking or not taking for depression/anxiety & nausea medication\\n\\nThank you!\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 04 Sep 2024 19:34:49 GMT\", \"name\": \"Faith \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Resolved.\\nThank you.\"}, \"mailId\": \"\"}], \"memberName\": \"Allison Diaz\", \"codingAnalyst\": \"\", \"dateOfService\": \"08/30/2024 10:00 AM\", \"clinicianMailId\": \"f.enwefah@focuscares.com\", \"qaAnalystMailId\": \"b.clark@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"8/16/2024 @ 02:10 PM\", \"result\": 0, \"comment\": \"virtual appt scheduled with Allison 8/30/2024 Via Doxy- LLA\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"8/9/2024 @ 06:19 PM\", \"result\": 13, \"comment\": \"Caller Disconnected at beginning of call -LLA\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"8/12/2024 @ 06:19 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0007355663001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"62685179\", \"memberId\": \"0007355663001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"62685179\", \"memberId\": \"0007355663001\", \"scheduleDate\": \"2024-8-30T10:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-09-2024 18:19:00\", \"schedulerId\": \"47262451\", \"schedulerLeadId\": \"47262451\"}]}', '{\"date\": \"08-16-2024 14:10:40\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 0, NULL, '[{\"date\": \"2024-09-10 10:11:43\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"9b32e11a-6f7e-11ef-86b7-e1684dc6fd0b\\\",\\\"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-8-30T10:00', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:35:43', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007355663001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0007355663001_Diaz, Allison_08302024.pdf\", \"ftp_upload_date\": \"2024-09-10 10:11:42\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_LOTT, JODI_0007355663001_08302024.pdf\"}', 'ACA_0007355663001_Diaz, Allison_08302024', NULL, 'PCP_LOTT, JODI_0007355663001_08302024', NULL, '[{\"date\": \"2024-09-02T09:36:42.184Z\", \"signature\": \"data:image/png;base64,[encoded data, 23404 characters]\"}, {\"date\": \"2024-09-04T19:34:49.269Z\", \"signature\": \"data:image/png;base64,[encoded data, 23400 characters]\"}]', '2024-08-30T11:00', 'Member_Summary_0007355663001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007355663001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0007355663001.pdf\", \"member_ftp_upload_date\": \"2024-09-10 10:11:45\"}', 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
(4211, NULL, NULL, NULL, '0007355983001', '415609', '', '26605185', 'Jacob', 'Stovall', '', '{\"DOB\": 33640, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Toccoa\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Winder\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1992-02-06\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 415609, \"Mailing_County\": \"\", \"Member_Country\": \"HABERSHAM\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"467 W Doyle St\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30577, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"65 creekwood rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30680, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Stovall\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Jacob\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"sonyastephens603@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4703743315, \"Member_Identification_Number\": \"0007355983001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:37:32\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:37:32\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-12-31T00:10\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-12-16T00:48\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T01:09\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-30T23:59\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-31T00:04\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-31T00:07\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-31T00:10\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-11-15T05:44\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-16T01:09\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-30T23:59\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-31T00:10\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-11-12T21:19\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-08-29T16:57\", \"username\": null}, {\"date\": \"2024-08-29T16:57\", \"username\": null}, {\"date\": \"2024-10-30T15:05\", \"username\": null}, {\"date\": \"2024-10-30T15:05\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-09-12T01:30\", \"username\": \"DAdams\"}, {\"date\": \"2024-11-07T07:46\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-11-11T10:04\", \"username\": \"AWalsh\"}, {\"date\": \"2024-11-11T10:05\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2024-11-07T17:27\", \"username\": \"DAdams\"}, {\"date\": \"2024-11-07T17:27\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-11-11T13:48\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-11-11T11:12\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-11-11T13:48\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-09-12T11:23\", \"username\": \"TFerness2\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:35:44\", \"value\": [{\"add\": \"467 W Doyle St\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1992-02-06\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4703743315, \"zip\": 30577, \"add2\": \"\", \"add3\": \"\", \"city\": \"Toccoa\", \"gend\": 0, \"insh\": \"0007355983001\", \"mzip\": 30680, \"name\": \"Jacob Stovall\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"sonyastephens603@gmail.com\", \"ename\": \"\", \"madd1\": \"65 creekwood rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Winder\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:35:44\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:35:44\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"12/18/2024 @ 09:48 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"12/17/2024 @ 09:49 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"12/12/2024 @ 11:11 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"12/11/2024 @ 12:05 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"12/13/2024 @ 09:30 AM\"}, {\"date\": \"12/10/2024 @ 12:24 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"12/12/2024 @ 09:30 AM\"}, {\"date\": \"11/25/2024 @ 01:44 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"11/27/2024 @ 09:30 AM\"}, {\"date\": \"11/6/2024 @ 05:26 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"11/08/2024 @ 09:30 AM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"11-15-2024 05:44:25\", \"schedulerId\": \"26605185\", \"schedulerLeadId\": \"26605185\"}]}', '{\"date\": \"12-31-2024 00:10:01\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 7}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:35:44', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4212, NULL, NULL, NULL, '0007356189002', '423422', '', NULL, 'Chandler', 'Redding', '', '{\"DOB\": 34223, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Homer\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Homer\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1993-09-11\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 423422, \"Mailing_County\": \"BANKS\", \"Member_Country\": \"BANKS\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"710 Yonah Homer Rd\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30547, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"710 Yonah Homer Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30547, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Redding\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Chandler\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45323, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Identification_Number\": \"0007356189002\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:37:32\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:37:32\", \"hrastatus\": 18, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:35:44\", \"value\": [{\"add\": \"710 Yonah Homer Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1993-09-11\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": \"\", \"zip\": 30547, \"add2\": \"\", \"add3\": \"\", \"city\": \"Homer\", \"gend\": 1, \"insh\": \"0007356189002\", \"mzip\": 30547, \"name\": \"Chandler Redding\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"710 Yonah Homer Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Homer\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:35:44\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:35:44\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"08-08-2024 00:33:15\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', NULL, NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:35:44', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4213, NULL, NULL, NULL, '0007358578001', '418399', '', '21881792', 'Adam', 'Hill', '', '{\"DOB\": 34360, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Athens\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Athens\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1994-01-26\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 418399, \"Mailing_County\": \"OCONEE\", \"Member_Country\": \"OCONEE\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"150 Studio Ct\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30605, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"150 Studio Ct\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30605, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Hill\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Adam\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45323, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"adamhill0604@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7063402391, \"Member_Identification_Number\": \"0007358578001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'1', '{\"date\": \"01-01-2025 23:37:32\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:37:32\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [{\"date\": \"2024-10-02T13:21\", \"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-10-02T13:21\", \"reportStatus_date\": \"2024-10-02T13:21\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-10-02T13:21\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:35:44\", \"value\": [{\"add\": \"150 Studio Ct\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1994-01-26\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7063402391, \"zip\": 30605, \"add2\": \"\", \"add3\": \"\", \"city\": \"Athens\", \"gend\": 0, \"insh\": \"0007358578001\", \"mzip\": 30605, \"name\": \"Adam Hill\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"adamhill0604@gmail.com\", \"ename\": \"\", \"madd1\": \"150 Studio Ct\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Athens\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:35:44\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:35:44\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-10-02T13:21\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"10/2/2024 @ 01:21 PM\", \"result\": 9, \"comment\": \"Member declined offer to schedule HRA - Refused\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"10-02-2024 13:21:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"08-08-2024 00:33:15\", \"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', '07-08-2024 01:35:44', 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
(4214, 57818338, 44829497, '62685179', '0007358760001', '424852', '', '21881792', 'Tressa', 'Hewett', '', '{\"DOB\": 26991, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"Pcp_Zip\": \"31210\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"Macon\", \"Pcp_Name\": \"Lesley Cown\", \"Rank_All\": \"\", \"PCP_Phone\": \"4787577345\", \"Pcp_State\": \"\", \"Member_City\": \"Carrollton\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Carrollton\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1973-11-23\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"4061 Vineville Avenue\", \"Screening_IHA\": \"No\", \"member_id_two\": 424852, \"Mailing_County\": \"CARROLL\", \"Member_Country\": \"CARROLL\", \"PCP_Fax_Number\": \"4787574911\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"200 Somerset Place C 3\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30116, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"200 Somerset Place C 3\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30116, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Hewett\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Tressa\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45323, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"tressahewett@gmail.com\", \"Member_Suspect_Codes\": \"21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 4703048065, \"Member_Identification_Number\": \"0007358760001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 2, b'1', b'1', '{\"date\": \"09-17-2024 14:05:36\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-09-17 14:05:36\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-09-09T17:24\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-09-12T03:49\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-09-12T12:34\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-09-17T14:05\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-08-09T16:29\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [{\"date\": \"2024-08-27T14:15\", \"text\": \"Rescheduled\", \"method\": \"api\", \"status\": 16}], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [{\"date\": \"2024-08-13T13:14\", \"text\": \"Virtual No Show\", \"method\": \"api\", \"status\": 23}], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 2, \"hraStatus_date\": \"2024-08-12T06:52\", \"reportStatus_date\": \"2024-08-09T16:29\"}, {\"text\": \"Virtual No Show\", \"type\": \"ReportStatus\", \"status\": 23, \"hraStatus\": 19, \"hraStatus_date\": \"2024-08-13T13:14\", \"reportStatus_date\": \"2024-08-13T13:14\"}, {\"text\": \"Rescheduled\", \"type\": \"HraStatus\", \"status\": 16, \"hraStatus\": 1, \"hraStatus_date\": \"2024-08-27T14:15\", \"reportStatus_date\": \"2024-08-27T14:15\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-09-09T17:24\", \"reportStatus_date\": \"2024-09-09T17:24\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-09-12T12:34\", \"reportStatus_date\": \"2024-09-12T12:34\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-09-17T14:05\", \"reportStatus_date\": \"2024-09-17T14:05\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-08-13T13:14\", \"username\": \"FEnwefah\"}], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-09-17T14:05\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-08-09T16:29\", \"username\": null}, {\"date\": \"2024-08-09T16:29\", \"username\": null}, {\"date\": \"2024-08-27T14:15\", \"username\": null}, {\"date\": \"2024-08-27T14:15\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-08-12T06:52\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-09-09T06:53\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [{\"date\": \"2024-09-10T09:16\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2024-09-09T17:24\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-09-09T17:24\", \"username\": \"FEnwefah\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-09-12T12:34\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-09-12T03:49\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-09-12T12:34\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"12-18-2024\", \"time\": \"16:57:55\", \"value\": [{\"add\": \"200 Somerset Place C 3\", \"age\": 51, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1973-11-23\", \"eno\": \"404 8231147\", \"lob\": \"On Exchange\", \"pno\": 4703048065, \"zip\": 30116, \"add2\": \"\", \"add3\": \"\", \"city\": \"Carrollton\", \"gend\": 1, \"insh\": \"0007358760001\", \"mzip\": 30116, \"name\": \"Tressa Hewett\", \"plan\": \"Alliant\", \"pphy\": \"Lesley Cown\", \"ppno\": \"4787577345\", \"cliId\": \"\", \"email\": \"tressahewett@gmail.com\", \"ename\": \"Brianna Hewett\", \"madd1\": \"200 Somerset Place C 3\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Carrollton\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"4061 Vineville Avenue\", \"pcpnpi\": \"\", \"pcpzip\": \"31210\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Widowed\", \"pcpFlag\": 0, \"pcpcity\": \"Macon\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"4787574911\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [], \"score\": [], \"comment\": []}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-12-2024\", \"time\": \"06:52:17\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"12-18-2024 16:57:55\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2024-08-13T13:14\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"FEnwefah\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 12, \"callLog\": [{\"date\": \"8/27/2024 @ 02:15 PM\", \"result\": 12, \"comment\": \"Rescheduled appt - w/ Faith on 9/9 @ 2:30 - texted doxy link to member - member will use their phone. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"8/9/2024 @ 04:29 PM\", \"result\": 0, \"comment\": \"Scheduled Faith E on 8/12 @ 2:30 - member will use phone. Texted doxy link to member. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0007358760001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"62685179\", \"memberId\": \"0007358760001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"62685179\", \"memberId\": \"0007358760001\", \"scheduleDate\": \"2024-9-9T14:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-09-2024 16:29:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}, {\"date\": \"08-13-2024 13:14:46\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"08-27-2024 14:15:31\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 0, NULL, '[{\"date\": \"2024-09-17 14:05:35\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"6fa4ec33-751f-11ef-a23c-f1a2d94f7930\\\",\\\"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-9T14:30', '2024-12-31', '2024-09-09T14:30', NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:35:45', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007358760001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0007358760001_Hewett, Tressa_09092024.pdf\", \"ftp_upload_date\": \"2024-09-17 14:05:34\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_, DR. lisley_0007358760001_09092024.pdf\"}', 'ACA_0007358760001_Hewett, Tressa_09092024', NULL, 'PCP_, DR. lisley_0007358760001_09092024', NULL, '[{\"date\": \"2024-09-09T21:24:36.202Z\", \"signature\": \"data:image/png;base64,[encoded data, 23412 characters]\"}]', '2024-09-09T15:30', 'Member_Summary_0007358760001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007358760001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0007358760001.pdf\", \"member_ftp_upload_date\": \"2024-09-17 14:05:35\"}', NULL, NULL, NULL, NULL),
(4215, NULL, NULL, NULL, '0007358848001', '427148', '', '99038484', 'Ellene', 'Cole', '', '{\"DOB\": 33416, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Macon\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Macon\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1991-06-27\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 427148, \"Mailing_County\": \"BIBB\", \"Member_Country\": \"BIBB\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"2427 Brevard Dr\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 31206, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"2427 Brevard Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31206, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Cole\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Ellene\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45505, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"ellenecole69@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4783708822, \"Member_Identification_Number\": \"0007358848001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:37:33\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:37:32\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [{\"date\": \"2024-08-14T14:03\", \"text\": \"Wrong Number\", \"method\": \"api\", \"status\": 7}], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Wrong Number\", \"type\": \"ReportStatus\", \"status\": 7, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-14T14:03\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:35:45\", \"value\": [{\"add\": \"2427 Brevard Dr\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1991-06-27\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4783708822, \"zip\": 31206, \"add2\": \"\", \"add3\": \"\", \"city\": \"Macon\", \"gend\": 1, \"insh\": \"0007358848001\", \"mzip\": 31206, \"name\": \"Ellene Cole\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"ellenecole69@gmail.com\", \"ename\": \"\", \"madd1\": \"2427 Brevard Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Macon\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:35:45\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:35:45\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 4, \"callLog\": [{\"date\": \"8/14/2024 @ 02:03 PM\", \"result\": 4, \"comment\": \"Called to Schedule Virtual HRA with Faith Wrong number.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-14-2024 14:03:00\", \"schedulerId\": \"99038484\", \"schedulerLeadId\": \"99038484\"}]}', '{\"date\": \"08-14-2024 14:03:14\", \"status\": 2, \"details\": \"disconnected/wrong number\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:35:45', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4216, NULL, NULL, NULL, '0007359186001', '435627', '', '84929813', 'Timmy', 'Edwards', '', '{\"DOB\": 25550, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Chatsworth\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Chatsworth\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1969-12-13\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 435627, \"Mailing_County\": \"MURRAY\", \"Member_Country\": \"MURRAY\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"5202 Holly Creek Cool Sprgs Rd\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30705, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"5202 Holly Creek Cool Sprgs Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30705, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Edwards\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Timmy\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 45474, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"cueballswife@icloud.com\", \"Member_Suspect_Codes\": \"130, 161.2\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7065810309, \"Member_Identification_Number\": \"0007359186001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'1', '{\"date\": \"01-01-2025 23:37:33\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:37:33\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-12T14:25\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-20T16:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-01T13:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2024-10-09T15:44\", \"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-08-12T14:25\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-20T16:05\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-01T13:18\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-10-09T15:44\", \"reportStatus_date\": \"2024-10-09T15:44\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-10-09T15:44\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:35:45\", \"value\": [{\"add\": \"5202 Holly Creek Cool Sprgs Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1969-12-13\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7065810309, \"zip\": 30705, \"add2\": \"\", \"add3\": \"\", \"city\": \"Chatsworth\", \"gend\": 0, \"insh\": \"0007359186001\", \"mzip\": 30705, \"name\": \"Timmy A Edwards\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"cueballswife@icloud.com\", \"ename\": \"\", \"madd1\": \"5202 Holly Creek Cool Sprgs Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Chatsworth\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:35:45\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:35:45\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-10-09T15:44\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"10/9/2024 @ 03:44 PM\", \"result\": 9, \"comment\": \"Member is not interested in HRA-LLA\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"10/1/2024 @ 01:18 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/2/2024 @ 01:18 PM\"}, {\"date\": \"8/20/2024 @ 04:05 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Connie no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"8/27/2024 @ 04:04 PM\"}, {\"date\": \"8/12/2024 @ 02:24 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mariana Bernard\", \"callbackDate\": \"8/19/2024 @ 02:24 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-12-2024 14:24:00\", \"schedulerId\": \"84929813\", \"schedulerLeadId\": \"84929813\"}]}', '{\"date\": \"08-08-2024 00:33:15\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 4}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:35:45', 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
(4217, NULL, NULL, NULL, '0007360517001', '435942', '', '47262451', 'Malandy', 'Shollenberger', '', '{\"DOB\": 26166, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Hazlehurst\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Hazlehurst\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1971-08-21\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 435942, \"Mailing_County\": \"JEFF DAVIS\", \"Member_Country\": \"JEFF DAVIS\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"74 Wilson St Apt B2\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 31539, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"74 Wilson St Apt B2\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31539, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Shollenberger\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Malandy\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45474, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"Malandy1971@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 9123813427, \"Member_Identification_Number\": \"0007360517001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 2, b'0', b'0', '{\"date\": \"01-01-2025 23:37:33\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:37:33\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-09T15:48\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-15T19:37\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-09-12T15:12\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-31T17:46\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-12-10T09:42\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [{\"date\": \"2024-12-21T13:41\", \"text\": \"Virtual No Show\", \"method\": \"api\", \"status\": 23}], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-09T15:48\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-15T19:37\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-09-12T15:12\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-31T17:46\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-12-10T09:42\", \"reportStatus_date\": \"2024-12-10T09:42\"}, {\"text\": \"Virtual No Show\", \"type\": \"ReportStatus\", \"status\": 23, \"hraStatus\": 19, \"hraStatus_date\": \"2024-12-21T13:41\", \"reportStatus_date\": \"2024-12-21T13:41\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-12-21T13:41\", \"username\": \"NCox\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-12-10T09:42\", \"username\": null}, {\"date\": \"2024-12-10T09:42\", \"username\": null}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:35:46\", \"value\": [{\"add\": \"74 Wilson St Apt B2\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1971-08-21\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 9123813427, \"zip\": 31539, \"add2\": \"\", \"add3\": \"\", \"city\": \"Hazlehurst\", \"gend\": 1, \"insh\": \"0007360517001\", \"mzip\": 31539, \"name\": \"Malandy Shollenberger\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"Malandy1971@gmail.com\", \"ename\": \"\", \"madd1\": \"74 Wilson St Apt B2\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Hazlehurst\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:35:46\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:35:46\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2024-12-21T13:41\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"NCox\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"12/10/2024 @ 09:42 AM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA with Nykya on December 21st at 1:30PM\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"12/10/2024 @ 09:34 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"12/12/2024 @ 09:30 AM\"}, {\"date\": \"12/9/2024 @ 09:23 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"12/11/2024 @ 09:30 AM\"}, {\"date\": \"10/31/2024 @ 05:46 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Latoya Bagley\", \"callbackDate\": \"11/4/2024 @ 05:45 PM\"}, {\"date\": \"9/12/2024 @ 03:12 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"9/13/2024 @ 03:12 PM\"}, {\"date\": \"8/15/2024 @ 07:37 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Nykya Cox \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"8/22/2024 @ 07:37 PM\"}, {\"date\": \"8/9/2024 @ 03:48 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"8/12/2024 @ 03:48 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-09-2024 15:48:00\", \"schedulerId\": \"47262451\", \"schedulerLeadId\": \"47262451\"}, {\"date\": \"12-21-2024 13:41:26\", \"schedulerId\": \"47262451\", \"schedulerLeadId\": \"47262451\"}]}', '{\"date\": \"12-21-2024 13:41:26\", \"status\": 0, \"details\": \"scheduled member moved to no show/cancellation\", \"disabled\": false, \"notification\": {\"type\": 1, \"value\": \"\", \"previous_status\": 1}}', '{\"attemptCount\": 2}', NULL, 1, NULL, NULL, 'Virtual', NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:35:46', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4218, NULL, NULL, NULL, '0007363167001', '403755', '', '21881792', 'Charles', 'Coursey', '', '{\"DOB\": 26884, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Villa Rica\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Villa Rica\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1973-08-08\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 403755, \"Mailing_County\": \"CARROLL\", \"Member_Country\": \"CARROLL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"164 Hunters Lake Dr\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30180, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"164 Hunters Lake Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30180, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Coursey\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Charles\", \"Member_Middle_name\": \"Lee\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"ambushbug73@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6789534589, \"Member_Identification_Number\": \"0007363167001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:37:33\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:37:33\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-12-16T00:49\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-13T15:41\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-28T12:14\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-29T09:57\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-15T10:58\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T00:49\", \"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-08-13T15:41\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-29T09:57\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-15T10:58\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-15T05:47\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-16T00:49\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-11-12T21:19\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-08-29T16:57\", \"username\": null}, {\"date\": \"2024-08-29T16:57\", \"username\": null}, {\"date\": \"2024-10-30T15:05\", \"username\": null}, {\"date\": \"2024-10-30T15:05\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-09-12T01:30\", \"username\": \"DAdams\"}, {\"date\": \"2024-11-07T07:46\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-11-11T10:04\", \"username\": \"AWalsh\"}, {\"date\": \"2024-11-11T10:05\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2024-11-07T17:27\", \"username\": \"DAdams\"}, {\"date\": \"2024-11-07T17:27\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-11-11T13:48\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-11-11T11:12\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-11-11T13:48\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-09-12T11:23\", \"username\": \"TFerness2\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:35:46\", \"value\": [{\"add\": \"164 Hunters Lake Dr\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1973-08-08\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6789534589, \"zip\": 30180, \"add2\": \"\", \"add3\": \"\", \"city\": \"Villa Rica\", \"gend\": 0, \"insh\": \"0007363167001\", \"mzip\": 30180, \"name\": \"Charles Lee Coursey\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"ambushbug73@gmail.com\", \"ename\": \"\", \"madd1\": \"164 Hunters Lake Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Villa Rica\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:35:46\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:35:46\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/13/2024 @ 12:17 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/12/2024 @ 12:05 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/11/2024 @ 11:41 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/7/2024 @ 07:22 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 05:43 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/15/2024 @ 10:58 AM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/16/2024 @ 10:58 AM\"}, {\"date\": \"8/29/2024 @ 09:57 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a virtual HRA w/Faith\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Alyia Williams\", \"callbackDate\": \"9/3/2024 @ 09:57 AM\"}, {\"date\": \"8/28/2024 @ 12:14 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Faith no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"9/4/2024 @ 12:12 PM\"}, {\"date\": \"8/13/2024 @ 03:41 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA w/ Faith Enwefah. - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/14/2024 @ 03:41 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-13-2024 15:41:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"12-16-2024 00:49:19\", \"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', '07-08-2024 01:35:46', 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
(4219, 57818338, 44829497, '83326555', '0007364074001', '432386', '', '84929813', 'Sheila', 'Thomas', '', '{\"DOB\": 24440, \"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\": \"37404\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"Chattanooga\", \"Pcp_Name\": \"Kristopher Meadows\", \"Rank_All\": \"\", \"PCP_Phone\": \"4234953940\", \"Pcp_State\": \"\", \"Member_City\": \"Chickamauga\", \"Office_Name\": \"CHI Memorial Medical Group \", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Chickamauga\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1966-11-29\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"725 Glenwood Dr Ste E788\", \"Screening_IHA\": \"No\", \"member_id_two\": 432386, \"Mailing_County\": \"WALKER\", \"Member_Country\": \"WALKER\", \"PCP_Fax_Number\": \"4234953949\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"125 J D Dr\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30707, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"125 J D Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30707, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Thomas\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Sheila\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45413, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"t.sheila@comcast.net\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 4234021246, \"Member_Identification_Number\": \"0007364074001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"09-03-2024 12:41:40\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-09-03 12:41:40\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-08-28T11:32\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-30T10:53\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-30T11:07\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-09-03T12:41\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-08-14T15:29\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-08-14T15:29\", \"reportStatus_date\": \"2024-08-14T15:29\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-08-30T11:07\", \"reportStatus_date\": \"2024-08-30T11:07\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-09-03T12:41\", \"reportStatus_date\": \"2024-09-03T12:41\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-09-03T12:41\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-08-14T15:29\", \"username\": null}, {\"date\": \"2024-08-14T15:29\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-08-27T12:53\", \"username\": \"CMiddleton\"}], \"qaAssigned\": [{\"date\": \"2024-08-28T11:48\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2024-08-28T11:32\", \"username\": \"CMiddleton\"}, {\"date\": \"2024-08-28T11:32\", \"username\": \"CMiddleton\"}, {\"date\": \"2024-08-29T13:05\", \"username\": \"CMiddleton\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-08-30T11:07\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-08-30T10:53\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-08-30T11:07\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-08-28T22:11\", \"username\": \"JSilverio\"}, {\"date\": \"2024-08-29T13:05\", \"username\": \"CMiddleton\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"10-22-2024\", \"time\": \"12:03:21\", \"value\": [{\"add\": \"125 J D Dr\", \"age\": 57, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1966-11-29\", \"eno\": \"4234021247\", \"lob\": \"On Exchange\", \"pno\": 4234021246, \"zip\": 30707, \"add2\": \"\", \"add3\": \"\", \"city\": \"Chickamauga\", \"gend\": 1, \"insh\": \"0007364074001\", \"mzip\": 30707, \"name\": \"Sheila Thomas\", \"plan\": \"Alliant\", \"pphy\": \"Kristopher Meadows\", \"ppno\": \"4234953940\", \"cliId\": \"\", \"email\": \"t.sheila@comcast.net\", \"ename\": \"Stanley Stong \", \"madd1\": \"125 J D Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Chickamauga\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"725 Glenwood Dr Ste E788\", \"pcpnpi\": \"\", \"pcpzip\": \"37404\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Divorced\", \"pcpFlag\": 0, \"pcpcity\": \"Chattanooga\", \"pcpname\": \"CHI Memorial Medical Group \", \"program\": \"ACA\", \"pcpfaxno\": \"4234953949\", \"pcpstate\": \"TN\", \"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\": \"08-27-2024\", \"time\": \"12:53:06\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"10-22-2024 12:03:21\"}', NULL, NULL, '{\"memberId\": \"0007364074001\", \"clinician\": \"Connie Middleton\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Thu, 29 Aug 2024 02:11:08 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"1.  AOD genitourinary med list reports HRT please add to this section.\\n2.  Patient summary please list what ID was used for verification of address and DOB.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 29 Aug 2024 17:05:16 GMT\", \"name\": \"Connie \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Done\"}, \"mailId\": \"\"}], \"memberName\": \"Sheila Thomas\", \"codingAnalyst\": \"\", \"dateOfService\": \"08/28/2024 10:00 AM\", \"clinicianMailId\": \"c.middleton@focuscares.com\", \"qaAnalystMailId\": \"j.silverio@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"8/14/2024 @ 03:29 PM\", \"result\": 0, \"comment\": \"scheduled virtual appt with connie for 8/28 @ 10am\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Mariana Bernard\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0007364074001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"83326555\", \"memberId\": \"0007364074001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"83326555\", \"memberId\": \"0007364074001\", \"scheduleDate\": \"2024-8-28T10:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-14-2024 15:29:00\", \"schedulerId\": \"84929813\", \"schedulerLeadId\": \"84929813\"}]}', '{\"date\": \"08-14-2024 15:29:18\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2024-09-03 12:41:39\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"643cbe05-6a13-11ef-a23c-9d59f83c92d8\\\",\\\"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-8-28T10:00', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:35:46', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007364074001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0007364074001_Thomas, Sheila_08282024.pdf\", \"ftp_upload_date\": \"2024-09-03 12:41:38\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_, Dr. Kristopher Meadows_0007364074001_08282024.pdf\"}', 'ACA_0007364074001_Thomas, Sheila_08282024', NULL, 'PCP_, Dr. Kristopher Meadows_0007364074001_08282024', NULL, '[{\"date\": \"2024-08-28T15:32:54.047Z\", \"signature\": \"data:image/png;base64,[encoded data, 24236 characters]\"}]', '2024-08-28T11:32', 'Member_Summary_0007364074001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007364074001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0007364074001.pdf\", \"member_ftp_upload_date\": \"2024-09-03 12:41:40\"}', NULL, NULL, NULL, NULL),
(4220, NULL, NULL, NULL, '0007364340001', '333752', '', '99038484', 'serena', 'goodson', '', '{\"DOB\": 27178, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Alto\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Alto\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1974-05-29\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 333752, \"Mailing_County\": \"BANKS\", \"Member_Country\": \"BANKS\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"261 WYNN LAKE RD\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30510, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"261 WYNN LAKE RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30510, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"goodson\", \"Medication_Review\": \"N\", \"Member_first_name\": \"serena\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45383, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"serenagoodson02@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7063918575, \"Member_Identification_Number\": \"0007364340001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:37:33\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:37:33\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-12T13:20\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [{\"date\": \"2024-08-19T15:54\", \"text\": \"Wrong Number\", \"method\": \"api\", \"status\": 7}], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-12T13:20\"}, {\"text\": \"Wrong Number\", \"type\": \"ReportStatus\", \"status\": 7, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-19T15:54\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:35:47\", \"value\": [{\"add\": \"261 WYNN LAKE RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1974-05-29\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7063918575, \"zip\": 30510, \"add2\": \"\", \"add3\": \"\", \"city\": \"Alto\", \"gend\": 1, \"insh\": \"0007364340001\", \"mzip\": 30510, \"name\": \"serena goodson\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"serenagoodson02@gmail.com\", \"ename\": \"\", \"madd1\": \"261 WYNN LAKE RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Alto\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:35:47\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:35:47\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 4, \"callLog\": [{\"date\": \"8/19/2024 @ 03:54 PM\", \"result\": 4, \"comment\": \"This is the wrong number for member- its just music playing- LLA\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"8/12/2024 @ 01:20 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Delise no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"8/19/2024 @ 01:20 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-12-2024 13:20:00\", \"schedulerId\": \"99038484\", \"schedulerLeadId\": \"99038484\"}]}', '{\"date\": \"08-19-2024 15:54:48\", \"status\": 2, \"details\": \"disconnected/wrong number\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:35:47', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4221, NULL, NULL, NULL, '0007364587001', '414886', '', '21881792', 'James', 'Stover', '', '{\"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_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Winder\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Winder\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1960-04-30\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 414886, \"Mailing_County\": \"BARROW\", \"Member_Country\": \"BARROW\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"424 Highway 211 NW Apt B\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30680, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"424 Highway 211 NW Apt B\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30680, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Stover\", \"Medication_Review\": \"N\", \"Member_first_name\": \"James\", \"Member_Middle_name\": \"L\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"Greatwhitecop@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4703580713, \"Member_Identification_Number\": \"0007364587001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:37:33\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:37:33\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [{\"date\": \"2024-09-26T17:08\", \"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-09-26T17:08\", \"reportStatus_date\": \"2024-09-26T17:08\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-09-26T17:08\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:35:47\", \"value\": [{\"add\": \"424 Highway 211 NW Apt B\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1960-04-30\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4703580713, \"zip\": 30680, \"add2\": \"\", \"add3\": \"\", \"city\": \"Winder\", \"gend\": 0, \"insh\": \"0007364587001\", \"mzip\": 30680, \"name\": \"James L Stover\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"Greatwhitecop@gmail.com\", \"ename\": \"\", \"madd1\": \"424 Highway 211 NW Apt B\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Winder\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:35:47\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:35:47\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-09-26T17:08\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"9/26/2024 @ 05:08 PM\", \"result\": 9, \"comment\": \"Member declined offer to schedule HRA - Refused\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"09-26-2024 17:08:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"08-08-2024 00:33:15\", \"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', '07-08-2024 01:35:47', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
