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
(1916, NULL, NULL, NULL, '0006684288001', '419913', '', '26056802', 'Aurelia', 'Reyes Gomez', '', '{\"DOB\": 22597, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Gainesville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gainesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1961-11-12\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 419913, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"3316 Laprad Cir\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30507, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"3316 Laprad Cir\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30507, \"Member_Last_name\": \"Reyes Gomez\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Aurelia\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6789979202, \"Member_Identification_Number\": \"0006684288001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:40\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:40\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-22T12:29\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-07-10T14:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-11T15:53\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-15T18:59\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-22T12:29\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-04-25T15:23\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-05-15T18:28\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-25T15:23\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-15T18:28\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-15T18:59\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-22T12:29\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-11-18T10:13\", \"username\": \"AWalsh\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-10-31T11:46\", \"username\": null}, {\"date\": \"2024-10-31T11:46\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-11-11T21:10\", \"username\": \"DAdams\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:29\", \"value\": [{\"add\": \"3316 Laprad Cir\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1961-11-12\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6789979202, \"zip\": 30507, \"add2\": \"\", \"add3\": \"\", \"city\": \"Gainesville\", \"gend\": 1, \"insh\": \"0006684288001\", \"mzip\": 30507, \"name\": \"Aurelia Reyes Gomez\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"3316 Laprad Cir\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gainesville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:25:03\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:03\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/11/2024 @ 11:08 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/7/2024 @ 01:01 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 12:50 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 02:41 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/31/2024 @ 02:05 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/9/2024 @ 10:58 AM\", \"result\": 14, \"comment\": \"Per previous notes member requested a cb with spanish interpreter Call attempt to schedule a virtual HRA w/ Nykya Cox \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Alyia Williams\", \"callbackDate\": \"\"}, {\"date\": \"7/29/2024 @ 06:23 PM\", \"result\": 3, \"comment\": \"Called member to schedule HRA w/ NP Jansen Helm lvm.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/22/2024 @ 12:29 PM\", \"result\": 1, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/15/2024 @ 06:59 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/11/2024 @ 03:53 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"7/12/2024 @ 03:52 PM\"}, {\"date\": \"7/10/2024 @ 02:18 PM\", \"result\": 3, \"comment\": \"07/10/2024 MB:: called for HRA-Nykya-Virtual: LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mariana Bernard\", \"callbackDate\": \"7/17/2024 @ 02:18 PM\"}, {\"date\": \"5/15/2024 @ 06:28 PM\", \"result\": 6, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams - Call Back - Member requests interpreter - Speaks Spanish\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/22/2024 @ 06:28 PM\"}, {\"date\": \"4/25/2024 @ 03:23 PM\", \"result\": 6, \"comment\": \"LS First call attempt 4/24/2024\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Patty Frey\", \"callbackDate\": \"5/9/2024 @ 03:23 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-15-2024 18:28:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"07-22-2024 12:29:00\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 13}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:29', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1917, NULL, NULL, NULL, '0006685456001', '413003', '', '21881792', 'Callie', 'Holladay', '', '{\"DOB\": 22610, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Roopville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Roopville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1961-11-25\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 413003, \"Mailing_County\": \"CARROLL\", \"Member_Country\": \"CARROLL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"2574 Roopville Veal Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30170, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"2574 Roopville Veal Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30170, \"Member_Last_name\": \"Holladay\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Callie\", \"Member_Middle_name\": \"Mae\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"Holladaycallie@yahoo.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 5613249372, \"Member_Identification_Number\": \"0006685456001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:40\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:40\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-06-24T17:18\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-30T09:29\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-06T16:09\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-14T14:27\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-18T15:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-24T17:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-06T16:09\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-14T14:27\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-24T17:18\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:30\", \"value\": [{\"add\": \"2574 Roopville Veal Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1961-11-25\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 5613249372, \"zip\": 30170, \"add2\": \"\", \"add3\": \"\", \"city\": \"Roopville\", \"gend\": 1, \"insh\": \"0006685456001\", \"mzip\": 30170, \"name\": \"Callie Mae Holladay\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"Holladaycallie@yahoo.com\", \"ename\": \"\", \"madd1\": \"2574 Roopville Veal Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Roopville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:25:03\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:03\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/6/2024 @ 03:04 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Rebecca Mangold\", \"callbackDate\": \"\"}, {\"date\": \"9/10/2024 @ 02:39 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA with Delise Adams LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"\"}, {\"date\": \"7/23/2024 @ 01:48 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"6/24/2024 @ 05:18 PM\", \"result\": 3, \"comment\": \"06/24/2024 JC: called for HRA-Nykya Cox-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"6/18/2024 @ 03:17 PM\", \"result\": 3, \"comment\": \"06/18/2024 JC: called for HRA-Faith Enwefah-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/25/2024 @ 03:17 PM\"}, {\"date\": \"6/14/2024 @ 02:27 PM\", \"result\": 3, \"comment\": \"06/14/2024 JC: called for HRA-Faith Enwefah-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/21/2024 @ 02:27 PM\"}, {\"date\": \"5/6/2024 @ 04:09 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL - ATTEMPT TO SCHEDULE FAITH 5/8.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/10/2024 @ 04:09 PM\"}, {\"date\": \"4/30/2024 @ 09:29 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/1/2024 @ 09:29 AM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-30-2024 09:29:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"06-24-2024 17:18:18\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 8}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:30', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1918, NULL, NULL, NULL, '0006687543001', '403661', '', '2661185', 'Raymond', 'White', '', '{\"DOB\": 22503, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Blakely\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Blakely\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1961-08-10\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 403661, \"Mailing_County\": \"EARLY\", \"Member_Country\": \"EARLY\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"3550 Union Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 39823, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"3550 Union Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 39823, \"Member_Last_name\": \"White\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Raymond\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 2293661989, \"Member_Identification_Number\": \"0006687543001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:33:40\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:40\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-12-16T01:07\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-12-16T00:18\", \"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\": [{\"date\": \"2024-05-14T17:17\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}, {\"date\": \"2024-09-11T17:54\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}, {\"date\": \"2024-10-24T12:43\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-14T17:17\"}, {\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-09-11T17:54\"}, {\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-24T12:43\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:30\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-16T01:07\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-11-18T10:13\", \"username\": \"AWalsh\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-10-31T11:46\", \"username\": null}, {\"date\": \"2024-10-31T11:46\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-11-11T21:10\", \"username\": \"DAdams\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:30\", \"value\": [{\"add\": \"3550 Union Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1961-08-10\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 2293661989, \"zip\": 39823, \"add2\": \"\", \"add3\": \"\", \"city\": \"Blakely\", \"gend\": 0, \"insh\": \"0006687543001\", \"mzip\": 39823, \"name\": \"Raymond White\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"3550 Union Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Blakely\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:25:03\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:03\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 13, \"callLog\": [{\"date\": \"12/6/2024 @ 10:40 AM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/22/2024 @ 10:50 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/28/2024 @ 04:35 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"10/30/2024 @ 09:30 AM\"}, {\"date\": \"10/24/2024 @ 12:43 PM\", \"result\": 14, \"comment\": \"Previous agent notes - Member does not have virtual capabilities. Call back to schedule a F2F HRA at a later time. Call attempt to schedule a HRA - F2F Callback\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/25/2024 @ 12:43 PM\"}, {\"date\": \"9/11/2024 @ 05:54 PM\", \"result\": 14, \"comment\": \"Previous agent notes - Member does not have virtual capabilities. Call back to schedule a F2F HRA at a later time. Call attempt to schedule a HRA - F2F Callback\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/11/2024 @ 05:54 PM\"}, {\"date\": \"5/14/2024 @ 05:17 PM\", \"result\": 14, \"comment\": \"Member doesn\'t have virtual capabilities, said it was okay to call back when we have a provider that can do F2F in his area. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/21/2024 @ 05:17 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-14-2024 17:17:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"12-16-2024 01:07:26\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:30', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1919, NULL, NULL, NULL, '0006687928002', '415511', '', '543416', 'Matthew', 'Davis', '', '{\"DOB\": 31012, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Lookout Mountain\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Lookout Mountain\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1984-11-26\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 415511, \"Mailing_County\": \"WALKER\", \"Member_Country\": \"WALKER\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"53 Gnome Trl\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30750, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"53 Gnome Trl\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30750, \"Member_Last_name\": \"Davis\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Matthew\", \"Member_Middle_name\": \"GP\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"1, 48\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": \"2396710471\", \"Member_Identification_Number\": \"0006687928002\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:41\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:40\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-09T17:58\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-06-13T18:27\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-18T11:47\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-21T14:38\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-01T12:59\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-09T17:58\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-06-13T18:27\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-21T14:38\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-01T12:59\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-09T17:58\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-11-18T10:13\", \"username\": \"AWalsh\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-10-31T11:46\", \"username\": null}, {\"date\": \"2024-10-31T11:46\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-11-11T21:10\", \"username\": \"DAdams\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"06-21-2024\", \"time\": \"01:15:32\", \"value\": [{\"add\": \"53 Gnome Trl\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1984-11-26\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 2396710471, \"zip\": 30750, \"add2\": \"\", \"add3\": \"\", \"city\": \"Lookout Mountain\", \"gend\": 0, \"insh\": \"0006687928002\", \"mzip\": 30750, \"name\": \"Matthew GP Davis\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"53 Gnome Trl\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Lookout Mountain\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"06-21-2024\", \"time\": \"01:15:32\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"06-21-2024 01:15:32\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/6/2024 @ 01:54 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 10:41 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"7/23/2024 @ 03:30 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule HRA w/ Nykya Cox. - Mailbox Full.\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"7/9/2024 @ 05:58 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ FAITH ENWEFAH  OR w/ DELISE ADAMS \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/1/2024 @ 12:59 PM\", \"result\": 3, \"comment\": \"07/01/2024 JC: called for HRA-Faith Enwefah-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"7/15/2024 @ 12:59 PM\"}, {\"date\": \"6/21/2024 @ 02:38 PM\", \"result\": 3, \"comment\": \"06/21/2024 JC: called for HRA-Nykya Cox-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/28/2024 @ 02:38 PM\"}, {\"date\": \"6/18/2024 @ 11:47 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL- Call attempt to schedule a virtual HRA.\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/19/2024 @ 11:46 AM\"}, {\"date\": \"6/13/2024 @ 06:27 PM\", \"result\": 3, \"comment\": \"06/13/2024 JC: called for HRA-Faith Enwefah-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/14/2024 @ 06:27 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"06-13-2024 18:27:00\", \"schedulerId\": \"543416\", \"schedulerLeadId\": \"543416\"}]}', '{\"date\": \"07-09-2024 17:58:39\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 8}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:30', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1920, NULL, NULL, NULL, '0006696869001', '410055', '', '21881792', 'KATHERINE', 'MORRIS', '', '{\"DOB\": 23071, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"LIZELLA\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"LIZELLA\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1963-03-01\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 410055, \"Mailing_County\": \"CRAWFORD\", \"Member_Country\": \"CRAWFORD\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"2182 CARL SUTTON ROAD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 31052, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"2182 CARL SUTTON ROAD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31052, \"Member_Last_name\": \"MORRIS\", \"Medication_Review\": \"N\", \"Member_first_name\": \"KATHERINE\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"KMDIXIEDAR63@YAHOO.COM\", \"Member_Suspect_Codes\": \"21, 88\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 2294574522, \"Member_Identification_Number\": \"0006696869001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:41\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:41\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-02T19:19\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-30T16:48\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-06T19:08\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-15T19:27\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-02T19:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2024-09-09T13:59\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-06-12T17:46\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-30T16:48\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-06T19:08\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-15T19:27\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-02T19:19\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-09-09T13:59\", \"reportStatus_date\": \"2024-09-09T13:59\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-09-09T13:59\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:31\", \"value\": [{\"add\": \"2182 CARL SUTTON ROAD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1963-03-01\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 2294574522, \"zip\": 31052, \"add2\": \"\", \"add3\": \"\", \"city\": \"LIZELLA\", \"gend\": 1, \"insh\": \"0006696869001\", \"mzip\": 31052, \"name\": \"KATHERINE MORRIS\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"KMDIXIEDAR63@YAHOO.COM\", \"ename\": \"\", \"madd1\": \"2182 CARL SUTTON ROAD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"LIZELLA\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:25:03\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:03\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-09-09T13:59\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"9/9/2024 @ 01:59 PM\", \"result\": 9, \"comment\": \"five9 says member refused\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Mariana Bernard\", \"callbackDate\": \"\"}, {\"date\": \"7/31/2024 @ 06:14 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/17/2024 @ 03:01 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/2/2024 @ 07:19 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Deborah York\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"6/15/2024 @ 07:27 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Delise Adams or Faith Enwefah \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/21/2024 @ 07:27 PM\"}, {\"date\": \"6/12/2024 @ 05:46 PM\", \"result\": 6, \"comment\": \"06/12/2024 JC: called for HRA-Faith Enwefah-Virtual: member req call back in august has surgery coming up not a good time \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"8/1/2024 @ 05:46 PM\"}, {\"date\": \"6/6/2024 @ 04:08 PM\", \"result\": 3, \"comment\": \"06/06/2024 JC: called for HRA-Faith Enwefah: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/10/2024 @ 04:08 PM\"}, {\"date\": \"4/30/2024 @ 04:48 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/1/2024 @ 04:48 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-30-2024 16:48:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"07-02-2024 19:19:32\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 8}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:31', 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
(1921, 62035418, 44829497, '56716210', '0006697403001', '394102', '', '2661185', 'Brandon', 'Ekey', '', '{\"DOB\": 27402, \"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\": \"30161\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"Rome\", \"Pcp_Name\": \"Horace Cline\", \"PCP_Phone\": \"7065093278\", \"Member_City\": \"Rome\", \"Office_Name\": \"Prestige Medical Group\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Rome\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1975-01-08\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"420 E 2nd Ave, Ste. 103\", \"Screening_IHA\": \"No\", \"member_id_two\": 394102, \"Mailing_County\": \"FLOYD\", \"Member_Country\": \"FLOYD\", \"PCP_Fax_Number\": \"7065094608\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"34 Cumberland Drive SE\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30161, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"34 Cumberland Drive SE\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30161, \"Member_Last_name\": \"Ekey\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Brandon\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"Ekeybrandon@gmail.com\", \"Member_Suspect_Codes\": \"120, 188, 20, 37.2, 84\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 7062520162, \"Member_Identification_Number\": \"0006697403001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"08-13-2024 08:59:26\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-08-13 08:59:27\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-22T20:01\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-07T14:48\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-08-03T13:13\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-06T20:08\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-06T21:45\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-13T08:59\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-06-11T20:02\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-07-31T12:23\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2024-07-08T17:08\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-07-11T15:53\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-22T20:01\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-07T14:48\"}, {\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 2, \"hraStatus_date\": \"2024-06-16T06:44\", \"reportStatus_date\": \"2024-06-11T20:02\"}, {\"text\": \"Cancellation\", \"type\": \"ReportStatus\", \"status\": 18, \"hraStatus\": 3, \"hraStatus_date\": \"2024-07-08T17:08\", \"reportStatus_date\": \"2024-07-08T17:08\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-11T15:53\"}, {\"text\": \"Completed\", \"type\": \"HraStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-08-05T22:58\", \"reportStatus_date\": \"2024-08-03T13:13\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-08-06T21:45\", \"reportStatus_date\": \"2024-08-06T21:45\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-08-13T08:59\", \"reportStatus_date\": \"2024-08-13T08:59\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-08-13T08:59\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-06-11T20:02\", \"username\": null}, {\"date\": \"2024-06-11T20:02\", \"username\": null}, {\"date\": \"2024-07-31T12:23\", \"username\": null}, {\"date\": \"2024-07-31T12:23\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-06-16T06:44\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-08-02T13:19\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-08-05T12:03\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2024-08-03T13:13\", \"username\": \"DAdams\"}, {\"date\": \"2024-08-03T13:13\", \"username\": \"DAdams\"}, {\"date\": \"2024-08-05T22:58\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-08-06T21:45\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-08-06T20:08\", \"username\": \"NSchaaf\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-08-06T21:45\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-08-05T18:52\", \"username\": \"NSchaaf\"}, {\"date\": \"2024-08-05T18:58\", \"username\": \"NSchaaf\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-07-08T17:08\", \"username\": \"PFrey1\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-19-2024\", \"time\": \"17:24:03\", \"value\": [{\"add\": \"34 Cumberland Drive SE\", \"age\": 49, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1975-01-08\", \"eno\": \"7063461468\", \"lob\": \"On Exchange\", \"pno\": 7062520162, \"zip\": 30161, \"add2\": \"\", \"add3\": \"\", \"city\": \"Rome\", \"gend\": 0, \"insh\": \"0006697403001\", \"mzip\": 30161, \"name\": \"Brandon Ekey\", \"plan\": \"Alliant\", \"pphy\": \"Horace Cline\", \"ppno\": \"7065093278\", \"race\": \"\", \"cliId\": \"\", \"email\": \"Ekeybrandon@gmail.com\", \"ename\": \"Pam Ekey\", \"madd1\": \"34 Cumberland Drive SE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Rome\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"420 E 2nd Ave, Ste. 103\", \"pcpnpi\": \"\", \"pcpzip\": \"30161\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Divorced\", \"pcpFlag\": 0, \"pcpcity\": \"Rome\", \"pcpname\": \"Prestige Medical Group\", \"program\": \"ACA\", \"evalDate\": \"2024-08-02 1:25 PM\", \"evalName\": \"Delise Adams, FNP\", \"pcpfaxno\": \"7065094608\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"06-16-2024\", \"time\": \"06:44:39\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-19-2024 17:24:03\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2024-07-08T17:08\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"PFrey1\", \"hraStatus\": 3, \"cancelText\": \"\", \"cancelStatus\": 0}]}', NULL, '{\"memberId\": \"0006697403001\", \"clinician\": \"Delise Adams\", \"qaAnalyst\": \"Natalie Schaaf\", \"queryData\": [{\"date\": \"Mon, 05 Aug 2024 22:52:30 GMT\", \"name\": \"Natalie \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Delise,\\n\\n1. Since patient is taking medication for depression/anxiety,\\ncan you add to the ROS.\\n\\nThanks!!\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 05 Aug 2024 22:58:09 GMT\", \"name\": \"Natalie \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hey Delise,\\n\\ncan you also add Alcohol abuse to neuro section as well. Thank you!\\nSorry forgot to include in previous query!!\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Tue, 06 Aug 2024 02:58:19 GMT\", \"name\": \"Delise \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"No worries. Corrections made. Thank you. \"}, \"mailId\": \"\"}], \"memberName\": \"Brandon Ekey\", \"codingAnalyst\": \"\", \"dateOfService\": \"08/02/2024 01:25 PM\", \"clinicianMailId\": \"deliseadams@sbcglobal.net\", \"qaAnalystMailId\": \"n.schaaf@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"7/31/2024 @ 12:23 PM\", \"result\": 0, \"comment\": \"Called to schedule HRA w/ DELISE ADAMS member scheduled for 8/02/24 at 1:15pm.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/11/2024 @ 03:53 PM\", \"result\": 6, \"comment\": \"Called to schedule HRA w/Connie Middleton Call back requested. MEMBER IS IN THE HOSPITAL CALL BACK AT A LATER DATE AND TIME.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"8/19/2024 @ 03:53 PM\"}, {\"date\": \"6/11/2024 @ 05:02 PM\", \"result\": 0, \"comment\": \"06/11/2024 JC: called for HRA- Faith Enwefah - Virtual: scheduled for 06/17/2024 @ 1:30pm - 2:30pm \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"5/7/2024 @ 02:48 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL - ATTEMPT TO SCHEDULE FAITH E. 5/10.   \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/10/2024 @ 02:48 PM\"}, {\"date\": \"4/22/2024 @ 08:01 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"4/23/2024 @ 08:01 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0006697403001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"56716210\", \"memberId\": \"0006697403001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"56716210\", \"memberId\": \"0006697403001\", \"scheduleDate\": \"2024-8-2T13:15\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-22-2024 20:01:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}, {\"date\": \"07-08-2024 17:08:59\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"07-31-2024 12:23:28\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 5}', NULL, 0, NULL, '[{\"date\": \"2024-08-13 08:59:26\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"de6c38cf-5973-11ef-9c50-2b1bea85fb58\\\",\\\"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-2T13:15', '2025-12-31', '2024-08-02T13:25', NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:31', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006697403001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0006697403001_Ekey, Brandon_08022024.pdf\", \"ftp_upload_date\": \"2024-08-13 08:59:25\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Cline, Horace_0006697403001_08022024.pdf\"}', 'ACA_0006697403001_Ekey, Brandon_08022024', NULL, 'PCP_Cline, Horace_0006697403001_08022024', NULL, '[{\"date\": \"2024-08-03T17:13:16.775Z\", \"signature\": \"data:image/png;base64,[encoded data, 23448 characters]\"}, {\"date\": \"2024-08-06T02:58:19.541Z\", \"signature\": \"data:image/png;base64,[encoded data, 23492 characters]\"}]', '2024-08-02T14:25', 'Member_Summary_0006697403001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006697403001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0006697403001.pdf\", \"member_ftp_upload_date\": \"2024-08-13 08:59:26\"}', 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
(1922, NULL, NULL, NULL, '0006700332001', '411229', '', '2661185', 'Savannah', 'Munroe', '', '{\"DOB\": 35326, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Cornelia\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Cornelia\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1996-09-18\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 411229, \"Mailing_County\": \"HABERSHAM\", \"Member_Country\": \"HABERSHAM\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"187 Myrl St\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30531, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"187 Myrl St\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30531, \"Member_Last_name\": \"Munroe\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Savannah\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"kaleymom159@gmail.com\", \"Member_Suspect_Codes\": 211, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7068946281, \"Member_Identification_Number\": \"0006700332001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:41\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:41\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-10T14:20\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2024-07-29T18:26\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-16T12:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-23T16:29\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-20T17:41\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-10T14:20\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-04-25T17:35\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-25T17:35\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-16T12:19\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-23T16:29\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-20T17:41\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-10T14:20\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2024-07-29T18:26\", \"reportStatus_date\": \"2024-07-29T18:26\"}]', '{\"utc\": [{\"date\": \"2024-07-29T18:26\", \"username\": null}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:31\", \"value\": [{\"add\": \"187 Myrl St\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1996-09-18\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7068946281, \"zip\": 30531, \"add2\": \"\", \"add3\": \"\", \"city\": \"Cornelia\", \"gend\": 1, \"insh\": \"0006700332001\", \"mzip\": 30531, \"name\": \"Savannah Munroe\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"kaleymom159@gmail.com\", \"ename\": \"\", \"madd1\": \"187 Myrl St\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Cornelia\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:25:03\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:03\"}', '{\"utc\": [{\"date\": \"2024-07-29T18:26\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 13, \"callLog\": [{\"date\": \"10/29/2024 @ 03:05 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/6/2024 @ 11:23 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"8/20/2024 @ 11:38 AM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA w/ Faith Enwefah - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"7/29/2024 @ 06:26 PM\", \"result\": 6, \"comment\": \"Called member to schedule HRA w/ NP Jansen Helm member request call back on Fridays she is off on that day.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/24/2024 @ 01:28 PM\", \"result\": 1, \"comment\": \"07/24/2024 JC: called for HRA-Delise Adams-Virtual/F2F:  Dead Air \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"7/10/2024 @ 02:20 PM\", \"result\": 3, \"comment\": \"07/10/2024 MB:: called for HRA-Nykya-Virtual: LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mariana Bernard\", \"callbackDate\": \"\"}, {\"date\": \"6/20/2024 @ 05:41 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"6/30/2024 @ 05:41 PM\"}, {\"date\": \"5/23/2024 @ 04:29 PM\", \"result\": 3, \"comment\": \"Called member to set up F2F HRA with Delise Adams \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christina Medina\", \"callbackDate\": \"5/30/2024 @ 04:29 PM\"}, {\"date\": \"5/16/2024 @ 12:19 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL -Call attempt to schedule HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/17/2024 @ 12:19 PM\"}, {\"date\": \"4/25/2024 @ 05:35 PM\", \"result\": 6, \"comment\": \"Call back, member is in the middle of moving and would like a call back May 13th to schedule. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/13/2024 @ 05:34 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-25-2024 17:35:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"07-10-2024 14:20:23\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 10}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1923, NULL, NULL, NULL, '0006700772001', '393634', '', '26056802', 'May', 'Moua', '', '{\"DOB\": 22635, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Winder\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Winder\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1961-12-20\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 393634, \"Mailing_County\": \"BARROW\", \"Member_Country\": \"BARROW\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1109 Jefferson Hwy\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30680, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1109 Jefferson Hwy\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30680, \"Member_Last_name\": \"Moua\", \"Medication_Review\": \"N\", \"Member_first_name\": \"May\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"mtmvue@yahoo.com\", \"Member_Suspect_Codes\": 37.2, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4702096870, \"Member_Identification_Number\": \"0006700772001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:33:41\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:41\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-09-26T16:48\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-03T16:57\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [{\"date\": \"2024-05-10T12:43\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [{\"date\": \"2024-04-25T16:57\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-11-06T18:25\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-25T16:57\"}, {\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-10T12:43\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-09-26T16:48\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-03T16:57\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-06T18:25\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:31\", \"value\": [{\"add\": \"1109 Jefferson Hwy\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1961-12-20\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4702096870, \"zip\": 30680, \"add2\": \"\", \"add3\": \"\", \"city\": \"Winder\", \"gend\": 1, \"insh\": \"0006700772001\", \"mzip\": 30680, \"name\": \"May Moua\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"mtmvue@yahoo.com\", \"ename\": \"\", \"madd1\": \"1109 Jefferson Hwy\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Winder\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:25:04\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:04\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 6, \"callLog\": [{\"date\": \"11/6/2024 @ 06:25 PM\", \"result\": 6, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Rebecca Mangold\", \"callbackDate\": \"11/13/2024 @ 06:24 PM\"}, {\"date\": \"10/3/2024 @ 04:57 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/4/2024 @ 04:56 PM\"}, {\"date\": \"9/26/2024 @ 04:48 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"9/27/2024 @ 04:48 PM\"}, {\"date\": \"5/10/2024 @ 12:43 PM\", \"result\": 14, \"comment\": \"MEMBER REQUESTED A F2F CALL BACK FOR LATER ON IN THE YEAR. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"7/8/2024 @ 12:43 PM\"}, {\"date\": \"4/25/2024 @ 04:57 PM\", \"result\": 10, \"comment\": \"Called to schedule F2F HRA w/ Sallie Key - Disconnected\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/9/2024 @ 04:57 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-25-2024 16:57:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"04-22-2024 00:31:38\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 5}', '{\"orderType\": 0, \"sortOrder\": 1731480693}', 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1924, NULL, NULL, NULL, '0006703932001', '408390', '', '21881792', 'Matthew', 'Moore', '', '{\"DOB\": 28797, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Villa Rica\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Villa Rica\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1978-11-03\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 408390, \"Mailing_County\": \"CARROLL\", \"Member_Country\": \"CARROLL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1004 Hickory Level Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30180, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1004 Hickory Level Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30180, \"Member_Last_name\": \"Moore\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Matthew\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": 1, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6783960195, \"Member_Identification_Number\": \"0006703932001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:41\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:41\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-02T19:24\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-29T12:08\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-06T12:30\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-14T18:59\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-18T17:25\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-02T19:24\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-29T12:08\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-06T12:30\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-14T18:59\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-18T17:25\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-02T19:24\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:32\", \"value\": [{\"add\": \"1004 Hickory Level Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1978-11-03\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6783960195, \"zip\": 30180, \"add2\": \"\", \"add3\": \"\", \"city\": \"Villa Rica\", \"gend\": 0, \"insh\": \"0006703932001\", \"mzip\": 30180, \"name\": \"Matthew Moore\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"1004 Hickory Level Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Villa Rica\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:25:04\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:04\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 4, \"callLog\": [{\"date\": \"11/6/2024 @ 05:41 PM\", \"result\": 4, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Rebecca Mangold\", \"callbackDate\": \"\"}, {\"date\": \"7/23/2024 @ 02:17 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/2/2024 @ 07:24 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Deborah York\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"6/18/2024 @ 05:25 PM\", \"result\": 3, \"comment\": \"06/18/2024 JC: called for HRA-Faith Enwefah-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"7/2/2024 @ 05:25 PM\"}, {\"date\": \"6/14/2024 @ 06:59 PM\", \"result\": 3, \"comment\": \"06/14/2024 JC: called for HRA-Faith Enwefah-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/20/2024 @ 06:58 PM\"}, {\"date\": \"5/6/2024 @ 12:30 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL - ATTEMPT TO SCHEDULE FAITH 5/8.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/10/2024 @ 12:30 PM\"}, {\"date\": \"4/29/2024 @ 12:08 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"4/30/2024 @ 12:08 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-29-2024 12:08:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"11-06-2024 17:41:21\", \"status\": 2, \"details\": \"disconnected/wrong number\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 7}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:32', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1925, NULL, NULL, NULL, '0006706195001', '394576', '', '21881792', 'Rosa', 'Cantu', '', '{\"DOB\": 29646, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1225252125, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"RINGGOLD\", \"Pcp_Name\": \"Lee Perry\", \"PCP_Phone\": 4238990431, \"Pcp_State\": \"GA\", \"Member_City\": \"Chickamauga\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Chickamauga\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1981-03-01\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"4630 BATTLEFIELD PKWY\", \"Screening_IHA\": \"No\", \"member_id_two\": 394576, \"Mailing_County\": \"WALKER\", \"Member_Country\": \"WALKER\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"209 Friendship Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30707, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"209 Friendship Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30707, \"Member_Ethnicity\": \"White\", \"Member_Last_name\": \"Cantu\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Rosa\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"cantu@ticua.org\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4235822865, \"Member_Identification_Number\": \"0006706195001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:41\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:41\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-11T15:55\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-30T11:25\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-13T15:40\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-17T17:15\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-22T13:46\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-11T15:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-30T11:25\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-17T17:15\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-22T13:46\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-11T15:55\"}]', '{\"utc\": [{\"date\": \"2024-07-29T18:26\", \"username\": null}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:32\", \"value\": [{\"add\": \"209 Friendship Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1981-03-01\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4235822865, \"zip\": 30707, \"add2\": \"\", \"add3\": \"\", \"city\": \"Chickamauga\", \"gend\": 1, \"insh\": \"0006706195001\", \"mzip\": 30707, \"name\": \"Rosa Cantu\", \"plan\": \"Alliant\", \"pphy\": \"Lee Perry\", \"ppno\": 4238990431, \"cliId\": \"\", \"email\": \"cantu@ticua.org\", \"ename\": \"\", \"madd1\": \"209 Friendship Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Chickamauga\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"4630 BATTLEFIELD PKWY\", \"pcpnpi\": 1225252125, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"RINGGOLD\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:25:04\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:04\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/30/2024 @ 11:38 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/29/2024 @ 11:06 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/5/2024 @ 06:02 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Candace Mailbox full.\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"7/31/2024 @ 12:27 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/15/2024 @ 06:59 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/11/2024 @ 03:55 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"6/22/2024 @ 01:46 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Nykya Cox or Faith Enwefah \", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/28/2024 @ 01:46 PM\"}, {\"date\": \"6/17/2024 @ 05:15 PM\", \"result\": 3, \"comment\": \"06/17/2024 JC: called for HRA-Faith Enwefah-Virtual: Mailbox Full \", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/24/2024 @ 05:15 PM\"}, {\"date\": \"6/13/2024 @ 03:40 PM\", \"result\": 3, \"comment\": \"MAILBOX FULL - Unable to leave a message. Call attempt to schedule virtual HRA. \", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/14/2024 @ 03:40 PM\"}, {\"date\": \"4/30/2024 @ 11:25 AM\", \"result\": 3, \"comment\": \"MAILBOX FULL - UNABLE TO LEAVE MESSAGE.\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/1/2024 @ 11:25 AM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-30-2024 11:25:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"07-11-2024 15:55:21\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 10}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:32', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1926, NULL, NULL, NULL, '0006706891001', '413712', '', '2661185', 'Doris', 'Johnson', '', '{\"DOB\": 22712, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Toccoa\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Toccoa\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1962-03-07\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 413712, \"Mailing_County\": \"STEPHENS\", \"Member_Country\": \"STEPHENS\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"127 Morgan Pl\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30577, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"127 Morgan Pl\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30577, \"Member_Last_name\": \"Johnson\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Doris\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"bigfixitady2@gmail.com\", \"Member_Suspect_Codes\": \"1, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7864178736, \"Member_Identification_Number\": \"0006706891001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:33:41\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:41\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-14T17:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [{\"date\": \"2024-05-30T14:50\", \"text\": \"Wrong Number\", \"method\": \"api\", \"status\": 7}, {\"date\": \"2024-07-31T16:37\", \"text\": \"Wrong Number\", \"method\": \"api\", \"status\": 7}], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-05-17T13:53\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-17T13:53\"}, {\"text\": \"Wrong Number\", \"type\": \"ReportStatus\", \"status\": 7, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-30T14:50\"}, {\"text\": \"Wrong Number\", \"type\": \"ReportStatus\", \"status\": 7, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-31T16:37\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:32\", \"value\": [{\"add\": \"127 Morgan Pl\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1962-03-07\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7864178736, \"zip\": 30577, \"add2\": \"\", \"add3\": \"\", \"city\": \"Toccoa\", \"gend\": 1, \"insh\": \"0006706891001\", \"mzip\": 30577, \"name\": \"Doris Johnson\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"bigfixitady2@gmail.com\", \"ename\": \"\", \"madd1\": \"127 Morgan Pl\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Toccoa\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:25:04\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:04\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 4, \"callLog\": [{\"date\": \"7/31/2024 @ 04:37 PM\", \"result\": 4, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"5/30/2024 @ 02:50 PM\", \"result\": 4, \"comment\": \"INTERPRETER - ROSE - 15683 - Number no longer belongs to member - wrong number. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"5/17/2024 @ 01:53 PM\", \"result\": 6, \"comment\": \"Call back, person who answered needs a Spanish interpreter, I don\'t know if it is Doris or not. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/22/2024 @ 01:53 PM\"}, {\"date\": \"5/14/2024 @ 05:18 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/15/2024 @ 05:18 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-14-2024 17:18:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"07-31-2024 16:37:38\", \"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', '21-04-2024 06:01:32', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1927, NULL, NULL, NULL, '0006710633001', '403156', '', '26056802', 'Donna', 'Myers', '', '{\"DOB\": 22609, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Braselton\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Braselton\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1961-11-24\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 403156, \"Mailing_County\": \"JACKSON\", \"Member_Country\": \"JACKSON\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"39 Rochester Ct\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30517, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"39 Rochester Ct\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30517, \"Member_Last_name\": \"Myers\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Donna\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"dmyers05@yahoo.com\", \"Member_Suspect_Codes\": \"20, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7066587565, \"Member_Identification_Number\": \"0006710633001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:41\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:41\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-11T15:54\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-25T19:42\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-10T14:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-04T18:12\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-27T12:26\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-11T15: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-04-25T19:42\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-10T14:17\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-04T18:12\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-27T12:26\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-11T15:54\"}]', '{\"utc\": [{\"date\": \"2024-07-29T18:26\", \"username\": null}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:33\", \"value\": [{\"add\": \"39 Rochester Ct\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1961-11-24\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7066587565, \"zip\": 30517, \"add2\": \"\", \"add3\": \"\", \"city\": \"Braselton\", \"gend\": 1, \"insh\": \"0006710633001\", \"mzip\": 30517, \"name\": \"Donna Myers\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"dmyers05@yahoo.com\", \"ename\": \"\", \"madd1\": \"39 Rochester Ct\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Braselton\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:25:04\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:04\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/28/2024 @ 04:47 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"8/31/2024 @ 03:37 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Faith no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"8/17/2024 @ 02:44 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Faith no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"7/31/2024 @ 12:28 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ DELISE ADAMS lvm.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/11/2024 @ 03:54 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/Connie Middleton left Voicemail.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"6/27/2024 @ 12:26 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"7/4/2024 @ 12:26 PM\"}, {\"date\": \"6/4/2024 @ 06:12 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/11/2024 @ 06:12 PM\"}, {\"date\": \"5/10/2024 @ 02:17 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL -Call attempt to schedule IHA. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/14/2024 @ 02:17 PM\"}, {\"date\": \"4/25/2024 @ 07:42 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Sallie Key - No VM Setup \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/9/2024 @ 07:42 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-25-2024 19:42:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"07-11-2024 15:54:51\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 9}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:33', 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
(1928, 71932120, 44829497, '56716210', '0006711613001', '388255', '', '2661185', 'Pamela', 'Jones', '', '{\"DOB\": 31031, \"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\": 1023643194, \"Pcp_Zip\": \"31093\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"WARNER ROBINS\", \"Pcp_Name\": \"DALE VANCE\", \"PCP_Phone\": \"4789756880\", \"Pcp_State\": \"GA\", \"Member_City\": \"Fort Valley\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Fort Valley\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1984-12-15\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"233 N HOUSTON RD STE 140E\", \"Screening_IHA\": \"No\", \"member_id_two\": 388255, \"Mailing_County\": \"PEACH\", \"Member_Country\": \"PEACH\", \"PCP_Fax_Number\": \"4789756869\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"383 S Jones Street\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 31030, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"383 S Jones Street\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31030, \"Member_Last_name\": \"Jones\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Pamela\", \"Member_Middle_name\": \"R\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"mrsjones3434@outlook.com\", \"Member_Suspect_Codes\": \"130, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 4787727671, \"Member_Identification_Number\": \"0006711613001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"08-06-2024 11:48:57\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-08-06 11:48:57\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-24T16:41\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-06T16:51\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-16T13:49\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-17T15:03\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-08-02T21:09\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-05T13:00\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-05T13:37\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-06T11:48\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-04-29T15:29\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-07-01T13:06\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-07-31T18:20\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2024-05-24T15:15\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [{\"date\": \"2024-07-11T09:30\", \"text\": \"Virtual No Show\", \"method\": \"api\", \"status\": 23}], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-04-29T15:29\", \"reportStatus_date\": \"2024-04-29T15:29\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": 3, \"hraStatus_date\": \"2024-05-24T15:15\", \"reportStatus_date\": \"2024-05-24T16:41\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-06T16:51\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-07-01T13:06\", \"reportStatus_date\": \"2024-07-01T13:06\"}, {\"text\": \"Virtual No Show\", \"type\": \"ReportStatus\", \"status\": 23, \"hraStatus\": 19, \"hraStatus_date\": \"2024-07-11T09:30\", \"reportStatus_date\": \"2024-07-11T09:30\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-17T15:03\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-08-05T13:37\", \"reportStatus_date\": \"2024-08-05T13:37\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-08-06T11:48\", \"reportStatus_date\": \"2024-08-06T11:48\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-07-11T09:30\", \"username\": \"TFerness2\"}], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-08-06T11:48\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-04-29T15:29\", \"username\": null}, {\"date\": \"2024-04-29T15:29\", \"username\": null}, {\"date\": \"2024-07-01T13:06\", \"username\": null}, {\"date\": \"2024-07-01T13:06\", \"username\": null}, {\"date\": \"2024-07-31T18:20\", \"username\": null}, {\"date\": \"2024-07-31T18:20\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-07-09T15:12\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-08-01T21:17\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-08-05T12:03\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2024-08-02T21:09\", \"username\": \"DAdams\"}, {\"date\": \"2024-08-02T21:09\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-08-05T13:37\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-08-05T13:00\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-08-05T13:37\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-05-24T15:15\", \"username\": \"TOdleAdmin\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-13-2024\", \"time\": \"14:48:22\", \"value\": [{\"add\": \"383 S Jones Street\", \"age\": 39, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1984-12-15\", \"eno\": \"4785880845\", \"lob\": \"On Exchange\", \"pno\": 4787727671, \"zip\": 31030, \"add2\": \"\", \"add3\": \"\", \"city\": \"Fort Valley\", \"gend\": 1, \"insh\": \"0006711613001\", \"mzip\": 31030, \"name\": \"Pamela R Jones\", \"plan\": \"Alliant\", \"pphy\": \"DALE VANCE\", \"ppno\": \"4789756880\", \"race\": \"\", \"cliId\": \"\", \"email\": \"mrsjones3434@outlook.com\", \"ename\": \"Michael Jones\", \"madd1\": \"383 S Jones Street\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Fort Valley\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"233 N HOUSTON RD STE 140E\", \"pcpnpi\": 1023643194, \"pcpzip\": \"31093\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"WARNER ROBINS\", \"pcpname\": \"\", \"program\": \"ACA\", \"evalDate\": \"2024-05-26 11:40 AM\", \"evalName\": \"Delise Adams, FNP\", \"pcpfaxno\": \"4789756869\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-20-2024\", \"time\": \"13:52:48\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-13-2024 14:48:22\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2024-07-11T09:30\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"TFerness2\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2024-05-24T15:15\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"TOdleAdmin\", \"hraStatus\": 3, \"cancelText\": \"Provider has Covid\", \"cancelStatus\": 1}]}', NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"7/31/2024 @ 06:20 PM\", \"result\": 0, \"comment\": \"Called to schedule HRA w/ DELISE ADAMS member already scheduled FOR 08/02/24 @ 11:30AM.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/17/2024 @ 03:03 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"7/18/2024 @ 03:03 PM\"}, {\"date\": \"7/16/2024 @ 01:49 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"7/17/2024 @ 01:49 PM\"}, {\"date\": \"7/1/2024 @ 01:06 PM\", \"result\": 0, \"comment\": \"07/01/2024 JC: called for HRA-Faith Enwefah-Virtual: scheduled for 07/10/2024 @ 9:00 - 10:00 am \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"6/6/2024 @ 04:51 PM\", \"result\": 1, \"comment\": \"DEAD AIR VIRTUAL VISIT WITH DEBORAH YORK ON 6/11 MV \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"6/11/2024 @ 04:51 PM\"}, {\"date\": \"5/24/2024 @ 04:41 PM\", \"result\": 3, \"comment\": \"Called member to cancel appt with Laura Mclendon scheduled 5/26 @ 10 - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/28/2024 @ 04:41 PM\"}, {\"date\": \"4/29/2024 @ 03:29 PM\", \"result\": 0, \"comment\": \"Scheduled HRA w/ Laura Mclendon for 5/26/24 @ 10:00am. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0006711613001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"56716210\", \"memberId\": \"0006711613001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"56716210\", \"memberId\": \"0006711613001\", \"scheduleDate\": \"2024-8-2T11:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-29-2024 15:29:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}, {\"date\": \"05-24-2024 15:15:49\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}, {\"date\": \"07-11-2024 09:30:48\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"07-31-2024 18:20:09\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 7}', NULL, 0, NULL, '[{\"date\": \"2024-08-06 11:48:56\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"63743c8c-540b-11ef-a457-5f7b93e0fd80\\\",\\\"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-2T11:30', '2024-12-31', '2024-05-26T11:40', NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:33', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006711613001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0006711613001_Jones, Pamela_08022024.pdf\", \"ftp_upload_date\": \"2024-08-06 11:48:55\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_VANCE, DALE_0006711613001_08022024.pdf\"}', 'ACA_0006711613001_Jones, Pamela_08022024', NULL, 'PCP_VANCE, DALE_0006711613001_08022024', NULL, '[{\"date\": \"2024-08-03T01:09:02.580Z\", \"signature\": \"data:image/png;base64,[encoded data, 23436 characters]\"}]', '2024-08-02T12:45', 'Member_Summary_0006711613001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006711613001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0006711613001.pdf\", \"member_ftp_upload_date\": \"2024-08-06 11:48:57\"}', 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
(1929, 57818338, 44829497, '62685179', '0006712490001', '414068', '', '21881792', 'Benjamin', 'Dunn', '', '{\"DOB\": 31111, \"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\": \"Sabry Gabriel\", \"PCP_Phone\": \"4782101670\", \"Member_City\": \"Macon\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Macon\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1985-03-05\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"101 Gateway Drive\", \"Screening_IHA\": \"No\", \"member_id_two\": 414068, \"Mailing_County\": \"BIBB\", \"Member_Country\": \"BIBB\", \"PCP_Fax_Number\": \"4782105813\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"945 Walnut St\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 31201, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"945 Walnut St\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31201, \"Member_Last_name\": \"Dunn\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Benjamin\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"benwrdunn@gmail.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 4787185038, \"Member_Identification_Number\": \"0006712490001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"07-23-2024 11:14:00\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-07-23 11:14:00\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-30T15:22\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-07-18T14:44\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-07-18T22:17\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-07-20T02:21\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-07-23T11:14\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-07-09T14:06\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-06-07T13:48\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-30T15:22\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-07T13:48\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-07-09T14:06\", \"reportStatus_date\": \"2024-07-09T14:06\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-07-20T02:21\", \"reportStatus_date\": \"2024-07-20T02:21\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-07-23T11:14\", \"reportStatus_date\": \"2024-07-23T11:14\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-07-23T11:14\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-07-09T14:06\", \"username\": null}, {\"date\": \"2024-07-09T14:06\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-07-18T10:04\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [{\"date\": \"2024-07-18T18:31\", \"username\": \"AWalsh\"}, {\"date\": \"2024-07-18T18:35\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2024-07-18T14:44\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-07-18T14:44\", \"username\": \"FEnwefah\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-07-20T02:21\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-07-18T22:17\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-07-20T02:21\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-06-2024\", \"time\": \"18:23:30\", \"value\": [{\"add\": \"945 Walnut St\", \"age\": 39, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1985-03-05\", \"eno\": \"7734106378\", \"lob\": \"On Exchange\", \"pno\": 4787185038, \"zip\": 31201, \"add2\": \"\", \"add3\": \"\", \"city\": \"Macon\", \"gend\": 0, \"insh\": \"0006712490001\", \"mzip\": 31201, \"name\": \"Benjamin Dunn\", \"plan\": \"Alliant\", \"pphy\": \"Sabry Gabriel\", \"ppno\": \"4782101670\", \"cliId\": \"\", \"email\": \"benwrdunn@gmail.com\", \"ename\": \"Jaimy Dunn-klinko\", \"madd1\": \"945 Walnut St\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Macon\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"101 Gateway Drive\", \"pcpnpi\": \"\", \"pcpzip\": \"31210\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"Macon\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"4782105813\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Male\", \"pphycomment\": \"PCP added.\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"07-11-2024\", \"time\": \"11:24:35\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-06-2024 18:23:30\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"7/9/2024 @ 02:06 PM\", \"result\": 0, \"comment\": \"Called to schedule HRA w/ FAITH ENWEFAH  OR w/ DELISE ADAMS SCHEDULED JULY 18TH 10AM \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"6/7/2024 @ 01:48 PM\", \"result\": 6, \"comment\": \"CALL BACK IN JULY IS CURRENTLY OVER SEAS AND CANNOT SCHEDULE VIRTUAL APP AT THE MOMENT. MV \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"7/9/2024 @ 01:48 PM\"}, {\"date\": \"4/30/2024 @ 03:22 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/1/2024 @ 03:22 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0006712490001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"62685179\", \"memberId\": \"0006712490001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"62685179\", \"memberId\": \"0006712490001\", \"scheduleDate\": \"2024-7-18T10:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-30-2024 15:22:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"07-09-2024 14:06:37\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 3}', NULL, 0, NULL, '[{\"date\": \"2024-07-23 11:13:57\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"2ebffc8c-4906-11ef-88ce-1bc67ebae731\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'Virtual', '2024-7-18T10:00', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:33', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006712490001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0006712490001_Dunn, Benjamin_07182024.pdf\", \"ftp_upload_date\": \"2024-07-23 11:13:56\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Gabriel, Dr._0006712490001_07182024.pdf\"}', 'ACA_0006712490001_Dunn, Benjamin_07182024', NULL, 'PCP_Gabriel, Dr._0006712490001_07182024', NULL, '[{\"date\": \"2024-07-18T18:44:36.611Z\", \"signature\": \"data:image/png;base64,[encoded data, 23412 characters]\"}]', '2024-07-18T11:00', 'Member_Summary_0006712490001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006712490001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0006712490001.pdf\", \"member_ftp_upload_date\": \"2024-07-23 11:13:59\"}', NULL, NULL, NULL, NULL),
(1930, NULL, NULL, NULL, '0006714837002', '419068', '', '543416', 'Shelly', 'Martineau', '', '{\"DOB\": 24765, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Carrollton\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Carrollton\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1967-10-20\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 419068, \"Mailing_County\": \"CARROLL\", \"Member_Country\": \"CARROLL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"218 N Ole Hickory Trl\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30117, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"218 N Ole Hickory Trl\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30117, \"Member_Last_name\": \"Martineau\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Shelly\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": \"8502819034\", \"Member_Identification_Number\": \"0006714837002\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:42\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:41\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-02T19:24\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-06-13T14:29\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-17T15:53\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-21T14:46\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-01T13:06\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-02T19:24\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-06-17T15:53\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-21T14:46\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-01T13:06\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-02T19:24\"}]', '{\"utc\": [{\"date\": \"2024-07-29T18:26\", \"username\": null}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"06-21-2024\", \"time\": \"01:15:32\", \"value\": [{\"add\": \"218 N Ole Hickory Trl\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1967-10-20\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 8502819034, \"zip\": 30117, \"add2\": \"\", \"add3\": \"\", \"city\": \"Carrollton\", \"gend\": 1, \"insh\": \"0006714837002\", \"mzip\": 30117, \"name\": \"Shelly Martineau\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"218 N Ole Hickory Trl\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Carrollton\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"06-21-2024\", \"time\": \"01:15:32\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"06-21-2024 01:15:32\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/31/2024 @ 10:40 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/30/2024 @ 10:27 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/29/2024 @ 10:19 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"8/31/2024 @ 05:24 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Faith no answer No VM Setup.\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"8/17/2024 @ 05:27 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Faith no answer No VM Setup.\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"7/22/2024 @ 01:44 PM\", \"result\": 3, \"comment\": \" Call attempt to schedule a HRA w/ Faith Enwefah. - No VM setup.\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"7/2/2024 @ 07:24 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Deborah York\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/1/2024 @ 01:06 PM\", \"result\": 3, \"comment\": \"Unable to leave a message. Call attempt to schedule a virtual HRA w/ Delise Adams.\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"7/2/2024 @ 01:06 PM\"}, {\"date\": \"6/21/2024 @ 02:46 PM\", \"result\": 3, \"comment\": \"06/21/2024 JC: called for HRA-Nykya Cox-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/27/2024 @ 02:46 PM\"}, {\"date\": \"6/17/2024 @ 03:53 PM\", \"result\": 3, \"comment\": \"NO VM SETUP - Unable to leave a message. Call attempt to schedule virtual HRA. \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/18/2024 @ 03:53 PM\"}, {\"date\": \"6/13/2024 @ 02:29 PM\", \"result\": 3, \"comment\": \"06/13/2024 JC: called for HRA-Faith Enwefah-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/14/2024 @ 02:28 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"06-13-2024 14:29:00\", \"schedulerId\": \"543416\", \"schedulerLeadId\": \"543416\"}]}', '{\"date\": \"07-02-2024 19:24:47\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 11}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:33', 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
(1931, 2888643, 44829497, '62685179', '0006715715001', '406716', '', '2661185', 'Peter', 'Arpke', '', '{\"DOB\": 25277, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"PCP_Phone\": \"\", \"Member_City\": \"Clarkesville\", \"Office_Name\": \"North east Georgia medical center\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Clarkesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1969-03-15\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 406716, \"Mailing_County\": \"HABERSHAM\", \"Member_Country\": \"HABERSHAM\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1485 Bear Gap Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30523, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1485 Bear Gap Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30523, \"Member_Last_name\": \"Arpke\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Peter\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"skyviking2003@yahoo.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 9419286644, \"Member_Identification_Number\": \"0006715715001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"05-31-2024 14:37:12\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-05-31 14:37:12\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-05-22T09:13\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-28T10:35\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-28T12:17\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-31T14:37\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-05-14T17:28\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 2, \"hraStatus_date\": \"2024-05-20T15:24\", \"reportStatus_date\": \"2024-05-14T17:28\"}, {\"text\": \"Completed\", \"type\": \"HraStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-05-24T05:46\", \"reportStatus_date\": \"2024-05-22T09:13\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-05-31T14:37\", \"reportStatus_date\": \"2024-05-31T14:37\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-05-31T14:37\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-05-14T17:28\", \"username\": null}, {\"date\": \"2024-05-14T17:28\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-05-20T15:24\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [{\"date\": \"2024-05-22T12:56\", \"username\": \"JScanlonQAL\"}], \"readyForQa\": [{\"date\": \"2024-05-21T14:31\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T14:34\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T14:37\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T14:40\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T14:43\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T14:46\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T14:49\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T14:52\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T14:55\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T14:58\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T15:01\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T15:04\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T15:04\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T15:07\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T15:10\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T15:13\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T15:14\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T15:16\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T15:19\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T15:23\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T15:25\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T17:00\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T17:01\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T17:02\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T17:03\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T17:05\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T17:06\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T17:09\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T17:12\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T17:15\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T17:17\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T17:17\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T09:04\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T09:06\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T09:06\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T09:10\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T09:11\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T09:11\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T09:13\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T09:13\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T09:13\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T05:46\", \"username\": \"FEnwefah\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-05-28T12:17\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-05-28T10:35\", \"username\": \"JScanlonQAL\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-05-28T12:17\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-05-23T10:18\", \"username\": \"JScanlonQAL\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"06-03-2024\", \"time\": \"14:54:41\", \"value\": [{\"add\": \"1485 Bear Gap Rd\", \"age\": 55, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1969-03-15\", \"eno\": \"941 993 0924\", \"lob\": \"On Exchange\", \"pno\": 9419286644, \"zip\": 30523, \"add2\": \"\", \"add3\": \"\", \"city\": \"Clarkesville\", \"gend\": 0, \"insh\": \"0006715715001\", \"mzip\": 30523, \"name\": \"Peter Arpke\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"skyviking2003@yahoo.com\", \"ename\": \"Chaise Arpke\", \"madd1\": \"1485 Bear Gap Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Clarkesville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Divorced\", \"pcpcity\": \"\", \"pcpname\": \"North east Georgia medical center\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Male\", \"pphycomment\": \"Added\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-16-2024\", \"time\": \"10:52:54\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"07-01-2024 14:56:04\"}', NULL, NULL, '{\"memberId\": \"0006715715001\", \"clinician\": \"Faith Enwefah\", \"qaAnalyst\": \"JScanlon Scanlon\", \"queryData\": [{\"date\": \"Thu, 23 May 2024 14:18:56 GMT\", \"name\": \"JScanlon \", \"role\": \"qa_lead\", \"files\": [], \"query\": {\"feedback\": \"Hi Faith,\\nThe HRA looks good, there is one minor item that needs to be updated.\\n1. In the preventative care section, cervical cancer screening has a recommendation/ education selected-  The member is male,Was this checked in error?\\nThank you,\\nJessica\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 24 May 2024 09:46:41 GMT\", \"name\": \"Faith \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Resolved\\nYes it was checked by error.\\nThank you.\"}, \"mailId\": \"\"}], \"memberName\": \"Peter Arpke\", \"codingAnalyst\": \"\", \"dateOfService\": \"05/21/2024 03:30PM\", \"clinicianMailId\": \"f.enwefah@focuscares.com\", \"qaAnalystMailId\": \"j.scalon@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"5/14/2024 @ 05:28 PM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA w/Faith Enwefah for 5/21/24 @ 3:30pm. Sent confirmation email to skyviking2003@yahoo.com and member will be using his Android smartphone for the appt. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0006715715001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"62685179\", \"memberId\": \"0006715715001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"62685179\", \"memberId\": \"0006715715001\", \"scheduleDate\": \"2024-5-21T15:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-14-2024 17:28:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"05-14-2024 17:28:45\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2024-05-31 14:37:10\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"ca722a82-1f7c-11ef-9ba6-d92dff09830c\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'Virtual', '2024-5-21T15:30', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:34', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006715715001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0006715715001_Arpke, Peter_05212024.pdf\", \"ftp_upload_date\": \"2024-05-31 14:37:10\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_center, North east Georgia medical_0006715715001_05212024.pdf\"}', 'ACA_0006715715001_Arpke, Peter_05212024', NULL, 'PCP_center, North east Georgia medical_0006715715001_05212024', NULL, '[{\"date\": \"2024-05-22T13:13:17.587Z\", \"signature\": \"data:image/png;base64,[encoded data, 23432 characters]\"}, {\"date\": \"2024-05-24T09:46:40.912Z\", \"signature\": \"data:image/png;base64,[encoded data, 23432 characters]\"}]', '2024-05-21T16:30', 'Member_Summary_0006715715001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006715715001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0006715715001.pdf\", \"member_ftp_upload_date\": \"2024-05-31 14:37:11\"}', 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
(1932, NULL, NULL, NULL, '0006716100001', '419961', '', '2661185', 'Geri', 'Hester', '', '{\"DOB\": 22013, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Norman Park\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Norman Park\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1960-04-07\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 419961, \"Mailing_County\": \"COLQUITT\", \"Member_Country\": \"COLQUITT\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"372 Jp Perry Rd\", \"Member_Address2\": \"\", \"Member_Address3\": \"\", \"Member_Zip_Code\": 31771, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"372 Jp Perry Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31771, \"Member_Last_name\": \"Hester\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Geri\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"rbh6213@gmail.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": \"2298916610\", \"Member_Identification_Number\": \"0006716100001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:42\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:42\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-11T15:55\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-14T17:31\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-17T13:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-09T14:11\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-11T15:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2024-09-09T16:02\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-05-21T09:34\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-17T13:55\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-21T09:34\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-11T15:55\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-09-09T16:02\", \"reportStatus_date\": \"2024-09-09T16:02\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-09-09T16:02\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"05-21-2024\", \"time\": \"09:33:53\", \"value\": [{\"add\": \"372 Jp Perry Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1960-04-07\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": \"2298916610\", \"zip\": 31771, \"add1\": \"\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Norman Park\", \"gend\": 1, \"insh\": \"0006716100001\", \"mzip\": 31771, \"name\": \"Geri A Hester\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"rbh6213@gmail.com\", \"ename\": \"\", \"madd1\": \"372 Jp Perry Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Norman Park\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:25:04\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:04\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-09-09T16:02\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"9/9/2024 @ 04:02 PM\", \"result\": 9, \"comment\": \"five9 note says member refused\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Mariana Bernard\", \"callbackDate\": \"\"}, {\"date\": \"7/31/2024 @ 12:31 PM\", \"result\": 4, \"comment\": \"updated number 2298916610\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/15/2024 @ 07:02 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/11/2024 @ 03:55 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/Connie Middleton left Voicemail.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/9/2024 @ 02:11 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ FAITH ENWEFAH  OR w/ DELISE ADAMS \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"7/23/2024 @ 02:10 PM\"}, {\"date\": \"5/21/2024 @ 09:34 AM\", \"result\": 6, \"comment\": \"HUSBAND PROVIDED UPDATED PHONE NUMBER - CALL BACK MEMBER TO ATTEMPT TO SCHEDULE VIRTUAL HRA. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/22/2024 @ 09:34 AM\"}, {\"date\": \"5/17/2024 @ 01:55 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Faith Enwefah - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/24/2024 @ 01:55 PM\"}, {\"date\": \"5/14/2024 @ 05:31 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/15/2024 @ 05:31 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-14-2024 17:31:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"07-31-2024 12:31:26\", \"status\": 2, \"details\": \"disconnected/wrong number\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 8}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:34', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1933, NULL, NULL, NULL, '0006718300001', '368990', '', '26056802', 'paul', 'cantillo', '', '{\"DOB\": 24668, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Gainesville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gainesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1967-07-15\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 368990, \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"2419 Old Thompson Bridge Rd # 815\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30501, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"2419 Old Thompson Bridge Rd H17\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30501, \"Member_Last_name\": \"cantillo\", \"Medication_Review\": \"N\", \"Member_first_name\": \"paul\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"paul_cantillo@yahoo.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4708463542, \"Member_Identification_Number\": \"0006718300001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:42\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:42\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-22T12:31\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-25T15:22\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-15T18:30\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-29T10:53\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-06T19:53\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-11T12:22\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-22T12: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\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-25T15:22\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-15T18:30\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-29T10:53\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-06T19:53\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-11T12:22\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-22T12:31\"}]', '{\"utc\": [{\"date\": \"2024-07-29T18:26\", \"username\": null}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:34\", \"value\": [{\"add\": \"2419 Old Thompson Bridge Rd # 815\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1967-07-15\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4708463542, \"zip\": 30501, \"add2\": \"\", \"add3\": \"\", \"city\": \"Gainesville\", \"gend\": 0, \"insh\": \"0006718300001\", \"mzip\": 30501, \"name\": \"paul cantillo\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"paul_cantillo@yahoo.com\", \"ename\": \"\", \"madd1\": \"2419 Old Thompson Bridge Rd H17\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gainesville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:25:04\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:04\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/11/2024 @ 11:08 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/7/2024 @ 01:01 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 12:50 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 02:42 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/31/2024 @ 02:07 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/9/2024 @ 10:59 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a virtual HRA w/ Nykya Cox \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Alyia Williams\", \"callbackDate\": \"\"}, {\"date\": \"8/2/2024 @ 03:22 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA - No VM setup.\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"7/22/2024 @ 12:31 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"6/11/2024 @ 12:22 PM\", \"result\": 3, \"comment\": \"LVM F2F VISIT WITH DELISE MV \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"\"}, {\"date\": \"6/6/2024 @ 07:52 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"6/20/2024 @ 07:52 PM\"}, {\"date\": \"5/29/2024 @ 10:53 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL - Call attempt to schedule a F2F HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/30/2024 @ 10:53 AM\"}, {\"date\": \"5/15/2024 @ 06:30 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams -  LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/22/2024 @ 06:30 PM\"}, {\"date\": \"4/25/2024 @ 03:22 PM\", \"result\": 3, \"comment\": \"LS First call attempt 4/24/2024\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Patty Frey\", \"callbackDate\": \"5/9/2024 @ 03:22 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-15-2024 18:30:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"07-22-2024 12:31:08\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 13}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:34', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1934, NULL, NULL, NULL, '0006720619001', '415885', '', '26056802', 'nancy', 'molina', '', '{\"DOB\": 26117, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"GAINSEVILLE\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"GAINSEVILLE\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1971-07-03\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 415885, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"6750 SAWNEE WAY\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30506, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"6750 SAWNEE WAY\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30506, \"Member_Last_name\": \"molina\", \"Medication_Review\": \"N\", \"Member_first_name\": \"nancy\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": \"7065185308\", \"Member_Identification_Number\": \"0006720619001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:42\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:42\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-08-02T15:24\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-25T15:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-15T18:33\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-29T10:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-06T19:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-11T12:24\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-02T15:24\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-25T15:21\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-15T18:33\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-29T10:55\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-06T19:55\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-11T12:24\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-02T15:24\"}]', '{\"utc\": [{\"date\": \"2024-07-29T18:26\", \"username\": null}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"07-16-2024\", \"time\": \"03:21:15\", \"value\": [{\"add\": \"6750 SAWNEE WAY\", \"age\": \"\", \"ano\": \"\", \"cno\": null, \"dob\": \"1971-07-03\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7065185308, \"zip\": 30506, \"add2\": \"\", \"add3\": \"\", \"city\": \"GAINSEVILLE\", \"gend\": 1, \"insh\": \"0006720619001\", \"mzip\": 30506, \"name\": \"nancy molina\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"6750 SAWNEE WAY\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"GAINSEVILLE\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"07-16-2024\", \"time\": \"03:21:15\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"07-16-2024 03:21:15\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/11/2024 @ 11:10 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/7/2024 @ 01:25 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 01:19 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 05:55 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/31/2024 @ 04:40 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/9/2024 @ 11:00 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a virtual HRA w/ Nykya Cox \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Alyia Williams\", \"callbackDate\": \"\"}, {\"date\": \"8/19/2024 @ 02:14 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA with Connie Middleton LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"\"}, {\"date\": \"8/2/2024 @ 03:24 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA w/ Connie Middleton. - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"6/11/2024 @ 12:24 PM\", \"result\": 3, \"comment\": \"LVM F2F VISIT WITH DELISE MV \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"\"}, {\"date\": \"6/6/2024 @ 07:55 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"6/20/2024 @ 07:55 PM\"}, {\"date\": \"5/29/2024 @ 10:55 AM\", \"result\": 1, \"comment\": \"DEAD AIR - Call was answered but no sound on call. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/30/2024 @ 10:55 AM\"}, {\"date\": \"5/15/2024 @ 06:33 PM\", \"result\": 1, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams - Dead Air\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/22/2024 @ 06:33 PM\"}, {\"date\": \"4/25/2024 @ 03:21 PM\", \"result\": 3, \"comment\": \"LS First call attempt 4/24/2025\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Patty Frey\", \"callbackDate\": \"5/9/2024 @ 03:21 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-15-2024 18:33:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"08-02-2024 15:24:53\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 13}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:35', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1935, NULL, NULL, NULL, '0006722415001', '397063', '', '21881792', 'Andrea', 'Spinks', '', '{\"DOB\": 29568, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1578626602, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"DOUGLASVILLE\", \"Pcp_Name\": \"Saurabh Desai\", \"PCP_Phone\": 7709490555, \"Pcp_State\": \"GA\", \"Member_City\": \"Villa Rica\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Villa Rica\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1980-12-13\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"6025 PROFESSIONAL PKWY\", \"Screening_IHA\": \"No\", \"member_id_two\": 397063, \"Mailing_County\": \"CARROLL\", \"Member_Country\": \"CARROLL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"2242 Old Scenic Dr\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30180, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"2242 Old Scenic Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30180, \"Member_Last_name\": \"Spinks\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Andrea\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"ambhill1477@gmail.com\", \"Member_Suspect_Codes\": \"130, 146, 151, 20, 21, 217, 30\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4705616017, \"Member_Identification_Number\": \"0006722415001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:42\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:42\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-02T19:25\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-06-18T17:26\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-02T19:25\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [{\"date\": \"2024-06-14T19:02\", \"text\": \"Wrong Number\", \"method\": \"api\", \"status\": 7}], \"cancellation\": [], \"disconnected\": [{\"date\": \"2024-04-29T12:10\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-05-06T12:32\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-29T12:10\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-06T12:32\"}, {\"text\": \"Wrong Number\", \"type\": \"ReportStatus\", \"status\": 7, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-14T19:02\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-18T17:26\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-02T19:25\"}]', '{\"utc\": [{\"date\": \"2024-07-29T18:26\", \"username\": null}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:35\", \"value\": [{\"add\": \"2242 Old Scenic Dr\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1980-12-13\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4705616017, \"zip\": 30180, \"add2\": \"\", \"add3\": \"\", \"city\": \"Villa Rica\", \"gend\": 1, \"insh\": \"0006722415001\", \"mzip\": 30180, \"name\": \"Andrea Spinks\", \"plan\": \"Alliant\", \"pphy\": \"Saurabh Desai\", \"ppno\": 7709490555, \"cliId\": \"\", \"email\": \"ambhill1477@gmail.com\", \"ename\": \"\", \"madd1\": \"2242 Old Scenic Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Villa Rica\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"6025 PROFESSIONAL PKWY\", \"pcpnpi\": 1578626602, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"DOUGLASVILLE\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:25:04\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:04\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 7, \"callLog\": [{\"date\": \"11/7/2024 @ 07:21 PM\", \"result\": 7, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 05:40 PM\", \"result\": 7, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"7/23/2024 @ 02:18 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/2/2024 @ 07:25 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Deborah York\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"6/18/2024 @ 05:26 PM\", \"result\": 13, \"comment\": \"06/18/2024 JC: called for HRA-Faith Enwefah-Virtual: caller hung up, \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"7/2/2024 @ 05:26 PM\"}, {\"date\": \"6/14/2024 @ 07:02 PM\", \"result\": 4, \"comment\": \"06/14/2024 JC: called for HRA-Faith Enwefah-Virtual: Wrong Number, said it was spectrum\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"5/6/2024 @ 12:32 PM\", \"result\": 10, \"comment\": \"DISCONNECTED \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/10/2024 @ 12:32 PM\"}, {\"date\": \"4/29/2024 @ 12:10 PM\", \"result\": 10, \"comment\": \"DISCONNECTED\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/29/2024 @ 12:10 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-29-2024 12:10:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"07-02-2024 19:25:34\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 8}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:35', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1936, NULL, NULL, NULL, '0006723071001', '417465', '', '84555898', 'Teresa', 'Wiley', '', '{\"DOB\": 24262, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Jefferson\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Jefferson\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1966-06-04\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 417465, \"Mailing_County\": \"JACKSON\", \"Member_Country\": \"JACKSON\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"131 Birch Fld\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30549, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"131 Birch Fld\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30549, \"Member_Last_name\": \"Wiley\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Teresa\", \"Member_Middle_name\": \"Suzanne\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"twiley0604@gmail.com\", \"Member_Suspect_Codes\": \"11, 12, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7063624566, \"Member_Identification_Number\": \"0006723071001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:42\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:42\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-06-04T16:51\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-06T18:07\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2024-08-19T14:14\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-06-21T17:15\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-07-01T15:37\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-06-06T18:07\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-21T17:15\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-01T15:37\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-08-19T14:14\", \"reportStatus_date\": \"2024-08-19T14:14\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-08-19T14:14\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:35\", \"value\": [{\"add\": \"131 Birch Fld\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1966-06-04\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7063624566, \"zip\": 30549, \"add2\": \"\", \"add3\": \"\", \"city\": \"Jefferson\", \"gend\": 1, \"insh\": \"0006723071001\", \"mzip\": 30549, \"name\": \"Teresa Suzanne Wiley\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"twiley0604@gmail.com\", \"ename\": \"\", \"madd1\": \"131 Birch Fld\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Jefferson\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:25:04\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:04\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-08-19T14:14\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"8/19/2024 @ 02:14 PM\", \"result\": 9, \"comment\": \"Called to Schedule Virtual HRA with Debbie but member refused.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"7/1/2024 @ 03:37 PM\", \"result\": 6, \"comment\": \"07/01/2024 JC: called for HRA-Faith Enwefah-Virtual: member req call back in a few months going thur chemo right now, call back in September \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"9/18/2024 @ 03:36 PM\"}, {\"date\": \"6/21/2024 @ 05:15 PM\", \"result\": 6, \"comment\": \"06/21/2024 JC: called for HRA-Nykya Cox-Virtual: member req call back in a few months going thur chemo right now, call back in September \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"9/11/2024 @ 05:15 PM\"}, {\"date\": \"6/6/2024 @ 03:07 PM\", \"result\": 3, \"comment\": \"06/06/2024 JC: called for HRA-Faith Enwefah: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/10/2024 @ 03:07 PM\"}, {\"date\": \"6/4/2024 @ 04:51 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL- Call attempt to schedule a virtual HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"6/5/2024 @ 04:51 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"06-04-2024 16:51:00\", \"schedulerId\": \"84555898\", \"schedulerLeadId\": \"84555898\"}]}', '{\"date\": \"04-22-2024 00:31:39\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 5}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:35', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `HRA_member_client_009_2024` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`) VALUES
(1937, NULL, NULL, NULL, '0006724356001', '418514', '', '21881792', 'Gerald', 'Caldwell', '', '{\"DOB\": 22524, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Carrollton\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Carrollton\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1961-08-31\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 418514, \"Mailing_County\": \"CARROLL\", \"Member_Country\": \"CARROLL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"131 Laurel Trce\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30116, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"131 Laurel Trce\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30116, \"Member_Last_name\": \"Caldwell\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Gerald\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"130, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 2564997553, \"Member_Identification_Number\": \"0006724356001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"08-14-2024 00:00:20\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2024-08-14 00:00:20\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-06-22T10:47\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-29T16:04\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-06T15:04\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-13T14:30\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-17T15:56\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-22T10:47\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-29T16:04\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-06T15:04\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-17T15:56\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-22T10:47\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:35\", \"value\": [{\"add\": \"131 Laurel Trce\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1961-08-31\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 2564997553, \"zip\": 30116, \"add2\": \"\", \"add3\": \"\", \"city\": \"Carrollton\", \"gend\": 0, \"insh\": \"0006724356001\", \"mzip\": 30116, \"name\": \"Gerald Caldwell\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"131 Laurel Trce\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Carrollton\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:25:04\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:04\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"7/22/2024 @ 01:51 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a F2F HRA w/ Faith Enwefah - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"6/22/2024 @ 10:47 AM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Nykya Cox or Faith Enwefah \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}, {\"date\": \"6/17/2024 @ 03:56 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL- Call attempt to schedule a virtual HRA. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/18/2024 @ 03:56 PM\"}, {\"date\": \"6/13/2024 @ 02:30 PM\", \"result\": 3, \"comment\": \"06/13/2024 JC: called for HRA-Faith Enwefah-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/19/2024 @ 02:30 PM\"}, {\"date\": \"5/6/2024 @ 03:04 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL - ATTEMPT TO SCHEDULE FAITH 5/8.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/9/2024 @ 03:04 PM\"}, {\"date\": \"4/29/2024 @ 04:04 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"4/30/2024 @ 04:04 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-29-2024 16:04:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"06-22-2024 10:47:11\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 1, NULL, NULL, NULL, NULL, '2024-07-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:35', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `HRA_member_client_009_2024` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`) VALUES
(1938, 57818338, 44829497, '56716210', '0006725672001', '410108', '', '26056802', 'catherine', 'douglas', '', '{\"DOB\": 34999, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": null, \"Pcp_City\": \"\", \"Pcp_Name\": \"needs one\", \"PCP_Phone\": \"\", \"Member_City\": \"Norcross\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Flowery Branch\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1995-10-27\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 410108, \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"2340 Beaver Ruin Rd \", \"Member_Address2\": \"Apt 71 \", \"Member_Address3\": \"\", \"Member_Zip_Code\": \"30071\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"3203 CREST VILLAGE CIR APT 320\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30542, \"Member_Last_name\": \"douglas\", \"Medication_Review\": \"N\", \"Member_first_name\": \"catherine\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"catherinedouglas20@gmail.com\", \"Member_Suspect_Codes\": 212, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 3376883492, \"Member_Identification_Number\": \"0006725672001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"06-18-2024 23:13:38\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-06-18 23:13:38\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-06-12T20:46\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-06-14T00:38\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-06-14T12:28\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-06-18T23:13\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-04-26T16:57\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [{\"date\": \"2024-06-03T17:53\", \"text\": \"Rescheduled\", \"method\": \"api\", \"status\": 16}], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2024-05-07T09:26\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-04-26T16:57\", \"reportStatus_date\": \"2024-04-26T16:57\"}, {\"text\": \"Cancellation\", \"type\": \"ReportStatus\", \"status\": 18, \"hraStatus\": 3, \"hraStatus_date\": \"2024-05-07T09:26\", \"reportStatus_date\": \"2024-05-07T09:26\"}, {\"text\": \"Rescheduled\", \"type\": \"HraStatus\", \"status\": 16, \"hraStatus\": 1, \"hraStatus_date\": \"2024-06-03T17:53\", \"reportStatus_date\": \"2024-06-03T17:53\"}, {\"text\": null, \"type\": \"HraStatus\", \"status\": null, \"hraStatus\": 2, \"hraStatus_date\": \"2024-06-10T22:16\", \"reportStatus_date\": null}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-06-14T12:28\", \"reportStatus_date\": \"2024-06-14T12:28\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-06-18T23:13\", \"reportStatus_date\": \"2024-06-18T23:13\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-06-18T23:13\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-04-26T16:57\", \"username\": null}, {\"date\": \"2024-04-26T16:57\", \"username\": null}, {\"date\": \"2024-06-03T17:53\", \"username\": null}, {\"date\": \"2024-06-03T17:53\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-06-10T22:16\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-06-13T10:23\", \"username\": \"JScanlonQAL\"}], \"readyForQa\": [{\"date\": \"2024-06-12T20:46\", \"username\": \"DAdams\"}, {\"date\": \"2024-06-12T20:46\", \"username\": \"DAdams\"}, {\"date\": \"2024-06-13T20:05\", \"username\": \"DAdams\"}, {\"date\": \"2024-06-13T20:05\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-06-14T12:28\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-06-14T00:38\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-06-14T12:28\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-06-13T14:34\", \"username\": \"JSilverio\"}, {\"date\": \"2024-06-13T20:05\", \"username\": \"DAdams\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-05-07T09:26\", \"username\": \"SKey\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"06-12-2024\", \"time\": \"20:46:23\", \"value\": [{\"add\": \"2340 Beaver Ruin Rd \", \"age\": 28, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1995-10-27\", \"eno\": \"3374427664\", \"lob\": \"On Exchange\", \"pno\": 3376883492, \"zip\": \"30071\", \"add2\": \"Apt 71 \", \"add3\": \"\", \"city\": \"Norcross\", \"gend\": 1, \"insh\": \"0006725672001\", \"mzip\": 30542, \"name\": \"catherine douglas\", \"plan\": \"Alliant\", \"pphy\": \"needs one\", \"ppno\": \"\", \"race\": \"\", \"cliId\": \"\", \"email\": \"catherinedouglas20@gmail.com\", \"ename\": \"Semaj Byrd\", \"madd1\": \"3203 CREST VILLAGE CIR APT 320\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Flowery Branch\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"evalDate\": \"2024-6-11 1:15 PM\", \"evalName\": \"Delise Adams, FNP\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"Muslim\"]], \"comment\": [[\"\"]]}, \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"06-10-2024\", \"time\": \"22:16:40\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"07-19-2024 14:21:47\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2024-05-07T09:26\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"SKey\", \"hraStatus\": 3, \"cancelText\": \"Patient was called to reschedule for Friday. She states in process of moving and requests a call back for reschedule in 2 weeks.\", \"cancelStatus\": 1}]}', NULL, '{\"memberId\": \"0006725672001\", \"clinician\": \"Delise Adams\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Thu, 13 Jun 2024 18:34:07 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"1.  Self Assessment who do you currently live with question needs answer.\\n2.  Exam Review Lymphatic palpation of submandibular nodes needs answer.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 14 Jun 2024 00:05:42 GMT\", \"name\": \"Delise \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"1. Answered\\n2. Answered\\n\\nThank you, Judi.\"}, \"mailId\": \"\"}], \"memberName\": \"catherine douglas\", \"codingAnalyst\": \"\", \"dateOfService\": \"06/11/2024 01:15 PM\", \"clinicianMailId\": \"deliseadams@sbcglobal.net\", \"qaAnalystMailId\": \"j.silverio@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 12, \"callLog\": [{\"date\": \"6/3/2024 @ 05:53 PM\", \"result\": 12, \"comment\": \"Scheduled F2F HRA w/ Delise Adams on 6/11 @ 115pm - sent via sms\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}, {\"date\": \"4/26/2024 @ 04:57 PM\", \"result\": 0, \"comment\": \"Scheduled F2F HRA w/ Sallie Key on 5/7 - pm - 130 - 430pm \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0006725672001\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"56716210\", \"memberId\": \"0006725672001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": -1, \"memberId\": \"0006725672001\", \"scheduleDate\": \"2024-6-11T13:15\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-26-2024 16:57:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}, {\"date\": \"05-07-2024 09:26:48\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"06-03-2024 17:53:24\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 0, NULL, '[{\"date\": \"2024-06-18 23:13:36\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"eb233e56-2de9-11ef-bb02-e58948d16722\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'In Person', '2024-6-11T13:15', '2024-08-28', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:36', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006725672001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0006725672001_douglas, catherine_06112024.pdf\", \"ftp_upload_date\": \"2024-06-18 23:13:36\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_one, needs_0006725672001_06112024.pdf\"}', 'ACA_0006725672001_douglas, catherine_06112024', NULL, 'PCP_one, needs_0006725672001_06112024', NULL, '[{\"date\": \"2024-06-13T00:46:23.337Z\", \"signature\": \"data:image/png;base64,[encoded data, 23528 characters]\"}, {\"date\": \"2024-06-14T00:05:37.989Z\", \"signature\": \"data:image/png;base64,[encoded data, 23500 characters]\"}]', '2024-06-11T13:50', 'Member_Summary_0006725672001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006725672001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0006725672001.pdf\", \"member_ftp_upload_date\": \"2024-06-18 23:13:38\"}', NULL, NULL, NULL, NULL);
