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
(4551, NULL, NULL, NULL, '0007655687001', '430987', '', '99038484', 'Tamira', 'Joiner', '', '{\"DOB\": 30354, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"MACON\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"MACON\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1983-02-07\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 430987, \"Mailing_County\": \"BIBB\", \"Member_Country\": \"BIBB\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1187 EDNA PL\", \"Member_Address2\": \"1107\", \"Member_Language\": \"\", \"Member_Zip_Code\": 31204, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"1187 EDNA PL\", \"Mailing_Address2\": \"1107\", \"Mailing_Zip_Code\": 31204, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Joiner\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Tamira\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45413, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"83beautifulbutterfly@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4787334469, \"Member_Identification_Number\": \"0007655687001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:38:05\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:38:05\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-12-16T00:38\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-09-13T11:37\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-09-30T12:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-17T10:48\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T00:38\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-08-14T16:56\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-14T16:56\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-09-13T11:37\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-09-30T12:19\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-17T10:48\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-15T05:41\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-16T00:38\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-10-18T16:05\", \"username\": \"TFerness2\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-10-14T15:19\", \"username\": null}, {\"date\": \"2024-10-14T15:19\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-10-17T20:49\", \"username\": \"DAdams\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:38:01\", \"value\": [{\"add\": \"1187 EDNA PL\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1983-02-07\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4787334469, \"zip\": 31204, \"add2\": \"1107\", \"add3\": \"\", \"city\": \"MACON\", \"gend\": 1, \"insh\": \"0007655687001\", \"mzip\": 31204, \"name\": \"Tamira Joiner\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"83beautifulbutterfly@gmail.com\", \"ename\": \"\", \"madd1\": \"1187 EDNA PL\", \"madd2\": \"1107\", \"madd3\": \"\", \"mcity\": \"MACON\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:38:01\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:38:01\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 13, \"callLog\": [{\"date\": \"11/6/2024 @ 01:59 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 11:34 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/17/2024 @ 10:48 AM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/18/2024 @ 10:48 AM\"}, {\"date\": \"9/30/2024 @ 12:18 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/1/2024 @ 12:18 PM\"}, {\"date\": \"9/13/2024 @ 11:37 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"9/17/2024 @ 11:37 AM\"}, {\"date\": \"8/14/2024 @ 04:56 PM\", \"result\": 6, \"comment\": \"Called to Schedule Virtual HRA with Faith but member requested a call back.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"8/21/2024 @ 04:54 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-14-2024 16:56:00\", \"schedulerId\": \"99038484\", \"schedulerLeadId\": \"99038484\"}]}', '{\"date\": \"12-16-2024 00:38:09\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:38:01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4552, NULL, NULL, NULL, '0007655735001', '432074', '', '99038484', 'William', 'Greene', '', '{\"DOB\": 24995, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Macon\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Bolingbroke\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1968-06-06\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 432074, \"Mailing_County\": \"\", \"Member_Country\": \"MONROE\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"10459 Estes Road\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 31210, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"PO Box 121\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31004, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Greene\", \"Medication_Review\": \"N\", \"Member_first_name\": \"William\", \"Member_Middle_name\": \"Scott\", \"Plan_Effective_Date\": 45413, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"wsgreene1968@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4789601907, \"Member_Identification_Number\": \"0007655735001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:38:05\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:38:05\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-12-16T00:38\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-14T16:57\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-09-13T11:38\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-09-30T12:20\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-17T10:50\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T00:38\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-14T16:57\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-09-13T11:38\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-09-30T12:20\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-17T10:50\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-16T00:38\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:38:01\", \"value\": [{\"add\": \"10459 Estes Road\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1968-06-06\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4789601907, \"zip\": 31210, \"add2\": \"\", \"add3\": \"\", \"city\": \"Macon\", \"gend\": 0, \"insh\": \"0007655735001\", \"mzip\": 31004, \"name\": \"William Scott Greene\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"wsgreene1968@gmail.com\", \"ename\": \"\", \"madd1\": \"PO Box 121\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Bolingbroke\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:38:01\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:38:01\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"12/19/2024 @ 04:19 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"12/17/2024 @ 09:47 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"12/12/2024 @ 10:05 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"12/11/2024 @ 10:06 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"12/10/2024 @ 10:28 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"12/9/2024 @ 10:39 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/22/2024 @ 12:45 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 11:34 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/17/2024 @ 10:50 AM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/18/2024 @ 10:50 AM\"}, {\"date\": \"9/30/2024 @ 12:20 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/2/2024 @ 12:20 PM\"}, {\"date\": \"9/13/2024 @ 11:38 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"9/17/2024 @ 11:38 AM\"}, {\"date\": \"8/14/2024 @ 04:57 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Faith no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"8/21/2024 @ 04:57 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-14-2024 16:57:00\", \"schedulerId\": \"99038484\", \"schedulerLeadId\": \"99038484\"}]}', '{\"date\": \"12-16-2024 00:38:10\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 12}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:38:01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4553, NULL, NULL, NULL, '0007660974001', '433786', '', '99038484', 'Angel', 'Gnahore', '', '{\"DOB\": 28752, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Dawsonville\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Dawsonville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1978-09-19\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 433786, \"Mailing_County\": \"LUMPKIN\", \"Member_Country\": \"LUMPKIN\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"339 Redwood Dr\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30534, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"339 Redwood Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30534, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Gnahore\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Angel\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45444, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"Agnahore@hotmail.com\", \"Member_Suspect_Codes\": \"1, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7622869401, \"Member_Identification_Number\": \"0007660974001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'1', '{\"date\": \"01-01-2025 23:38:05\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:38:05\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-10-31T13:47\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-09T13:26\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-09-11T12:13\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-09-25T17:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-03T13:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-31T13: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-08-09T13:26\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-09-11T12:13\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-09-25T17:21\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-03T13:18\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-31T13:47\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-10-18T16:05\", \"username\": \"TFerness2\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-10-14T15:19\", \"username\": null}, {\"date\": \"2024-10-14T15:19\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-10-17T20:49\", \"username\": \"DAdams\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:38:02\", \"value\": [{\"add\": \"339 Redwood Dr\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1978-09-19\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7622869401, \"zip\": 30534, \"add2\": \"\", \"add3\": \"\", \"city\": \"Dawsonville\", \"gend\": 1, \"insh\": \"0007660974001\", \"mzip\": 30534, \"name\": \"Angel Gnahore\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"Agnahore@hotmail.com\", \"ename\": \"\", \"madd1\": \"339 Redwood Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Dawsonville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:38:02\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:38:02\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/31/2024 @ 01:47 PM\", \"result\": 3, \"comment\": \"called for HRA-Virtual - Faith Enwefah-GA, RN,NP : LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Rocheline Lovaincy\", \"callbackDate\": \"\"}, {\"date\": \"10/30/2024 @ 01:14 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/3/2024 @ 01:17 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/4/2024 @ 01:17 PM\"}, {\"date\": \"9/25/2024 @ 05:21 PM\", \"result\": 1, \"comment\": \"Call answered but no sound on call. Call attempt to schedule an HRA. - Dead air \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"9/26/2024 @ 05:21 PM\"}, {\"date\": \"9/11/2024 @ 12:13 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM - 9/20 - Delise Adams. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"9/12/2024 @ 12:13 PM\"}, {\"date\": \"8/9/2024 @ 01:26 PM\", \"result\": 1, \"comment\": \"Called to Schedule Virtual HRA with Jansen , dead air.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"8/16/2024 @ 01:26 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-09-2024 13:26:00\", \"schedulerId\": \"99038484\", \"schedulerLeadId\": \"99038484\"}]}', '{\"date\": \"10-31-2024 13:47:32\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 6}', '{\"orderType\": 0, \"sortOrder\": 1730441247}', 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:38:01', 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
(4554, 43427090, 44829497, '83326555', '0007663271001', '431390', '', '84929813', 'Sheila', 'Toles', '', '{\"DOB\": 22416, \"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\": \"30105\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"Armuchee \", \"Pcp_Name\": \"Dr.Frank Hampton\", \"Rank_All\": \"\", \"PCP_Phone\": \"7622353830\", \"Pcp_State\": \"\", \"Member_City\": \"Menlo\", \"Office_Name\": \"Armuchee Medical Group\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Menlo\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1961-05-15\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"5470 Martha Berry Hwy\", \"Screening_IHA\": \"No\", \"member_id_two\": 431390, \"Mailing_County\": \"\", \"Member_Country\": \"CHATTOOGA\", \"PCP_Fax_Number\": \"7062919391\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"102 E Wheatstone Street\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30731, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"PO Box 221\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30731, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Toles\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Sheila\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45444, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 7065062611, \"Member_Identification_Number\": \"0007663271001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"12-03-2024 16:03:41\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-12-03 16:03:41\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-26T15:41\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-09T17:45\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-11-20T10:57\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-11-29T19:04\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-12-01T13:05\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-12-03T16:03\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-11-06T14:09\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-08-15T11:20\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-10-01T16:56\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-15T11:20\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-26T15:41\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-01T16:56\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-09T17:45\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-11-06T14:09\", \"reportStatus_date\": \"2024-11-06T14:09\"}, {\"text\": \"Completed\", \"type\": \"HraStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-11-25T17:05\", \"reportStatus_date\": \"2024-11-20T10:57\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-12-01T13:05\", \"reportStatus_date\": \"2024-12-01T13:05\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-12-03T16:03\", \"reportStatus_date\": \"2024-12-03T16:03\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-12-03T16:03\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-11-06T14:09\", \"username\": null}, {\"date\": \"2024-11-06T14:09\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-11-20T08:50\", \"username\": \"CMiddleton\"}], \"qaAssigned\": [{\"date\": \"2024-11-20T12:01\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2024-11-20T10:57\", \"username\": \"CMiddleton\"}, {\"date\": \"2024-11-20T10:57\", \"username\": \"CMiddleton\"}, {\"date\": \"2024-11-25T17:05\", \"username\": \"CMiddleton\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-12-01T13:05\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-11-29T19:04\", \"username\": \"APyo\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-12-01T13:05\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-11-23T17:54\", \"username\": \"APyo\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"02-24-2025\", \"time\": \"12:07:04\", \"value\": [{\"add\": \"102 E Wheatstone Street\", \"age\": 63, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1961-05-15\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7065062611, \"zip\": 30731, \"add2\": \"\", \"add3\": \"\", \"city\": \"Menlo\", \"gend\": 1, \"insh\": \"0007663271001\", \"mzip\": 30731, \"name\": \"Sheila Toles\", \"plan\": \"Alliant\", \"pphy\": \"Dr.Frank Hampton\", \"ppno\": \"7622353830\", \"race\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"Abby Lee (granddaughter)  (doesn\'t know phone number)\", \"madd1\": \"PO Box 221\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Menlo\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"5470 Martha Berry Hwy\", \"pcpnpi\": \"\", \"pcpzip\": \"30105\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Divorced\", \"pcpFlag\": 0, \"pcpcity\": \"Armuchee \", \"pcpname\": \"Armuchee Medical Group\", \"program\": \"ACA\", \"evalDate\": \"2024-11-20 10:00 AM\", \"evalName\": \"Connie Middleton, FNP\", \"pcpfaxno\": \"7062919391\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [false, null, null, null, true], \"score\": [], \"comment\": [null, null, null, null, \"Virtual\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"11-20-2024\", \"time\": \"08:50:13\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"02-24-2025 12:07:04\"}', NULL, NULL, '{\"memberId\": \"0007663271001\", \"clinician\": \"Connie Middleton\", \"qaAnalyst\": \"Angela Pyo\", \"queryData\": [{\"date\": \"Sat, 23 Nov 2024 22:54:52 GMT\", \"name\": \"Angela \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Connie, thank you for your thorough assessment.\\n\\n1)\\tIn the Demographics section: May you enter the phone number for the PCP?\\n\\nThank you,\\nAngela Pyo \\n\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 25 Nov 2024 22:05:51 GMT\", \"name\": \"Connie \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Done\"}, \"mailId\": \"\"}], \"memberName\": \"Sheila Toles\", \"codingAnalyst\": \"\", \"dateOfService\": \"11/20/2024 10:00 AM\", \"clinicianMailId\": \"c.middleton@focuscares.com\", \"qaAnalystMailId\": \"a.pyo@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"11/6/2024 @ 02:09 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Rebecca Mangold\", \"callbackDate\": \"\"}, {\"date\": \"10/9/2024 @ 05:45 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"10/16/2024 @ 05:45 PM\"}, {\"date\": \"10/1/2024 @ 04:56 PM\", \"result\": 6, \"comment\": \"Member stated does not receive mail at her mailing address. Member provided a PO Box for mail delivery - call back in 2 to 3 weeks after receipt of letter. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/2/2024 @ 04:56 PM\"}, {\"date\": \"8/26/2024 @ 03:41 PM\", \"result\": 1, \"comment\": \"Call answered but no sound on call. Call to schedule a HRA w/ Deborah York.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/27/2024 @ 03:41 PM\"}, {\"date\": \"8/15/2024 @ 11:20 AM\", \"result\": 6, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Mariana Bernard\", \"callbackDate\": \"8/16/2024 @ 11:20 AM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0007663271001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"83326555\", \"memberId\": \"0007663271001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"83326555\", \"memberId\": \"0007663271001\", \"scheduleDate\": \"2024-11-20T10:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-15-2024 11:20:00\", \"schedulerId\": \"84929813\", \"schedulerLeadId\": \"84929813\"}]}', '{\"date\": \"11-06-2024 14:09:02\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 5}', NULL, 0, NULL, '[{\"date\": \"2024-12-03 16:03:39\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"12236f0b-b1ba-11ef-9595-13a63d03670b\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'Virtual', '2024-11-20T10:00', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:38:02', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007663271001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0007663271001_Toles, Sheila_11202024.pdf\", \"ftp_upload_date\": \"2024-12-03 16:03:39\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Hampton, Dr.Frank_0007663271001_11202024.pdf\"}', 'ACA_0007663271001_Toles, Sheila_11202024', NULL, 'PCP_Hampton, Dr.Frank_0007663271001_11202024', NULL, '[{\"date\": \"2024-11-20T15:57:13.244Z\", \"signature\": \"data:image/png;base64,[encoded data, 24172 characters]\"}, {\"date\": \"2024-11-25T22:05:49.480Z\", \"signature\": \"data:image/png;base64,[encoded data, 24176 characters]\"}]', '2024-11-20T10:55', 'Member_Summary_0007663271001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007663271001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0007663271001.pdf\", \"member_ftp_upload_date\": \"2024-12-03 16:03:41\"}', 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
(4555, NULL, NULL, NULL, '0007663408001', '338255', '', '84929813', 'Judy', 'Reece', '', '{\"DOB\": 23663, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Calhoun\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Calhoun\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1964-10-13\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 338255, \"Mailing_County\": \"GORDON\", \"Member_Country\": \"GORDON\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"251 Tucker Hollow Rd SE\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30701, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"251 Tucker Hollow Rd SE\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30701, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Reece\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Judy\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 45444, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"judyreece64@yahoo.com\", \"Member_Suspect_Codes\": \"130, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7705483380, \"Member_Identification_Number\": \"0007663408001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2026 23:30:33\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2026-01-01 23:30:33\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-14T14:27\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-26T12:50\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-10-01T13:00\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-14T14:27\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-26T12:50\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-01T13:00\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:41\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-10-18T16:05\", \"username\": \"TFerness2\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-10-14T15:19\", \"username\": null}, {\"date\": \"2024-10-14T15:19\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-10-17T20:49\", \"username\": \"DAdams\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:38:03\", \"value\": [{\"add\": \"251 Tucker Hollow Rd SE\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1964-10-13\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7705483380, \"zip\": 30701, \"add2\": \"\", \"add3\": \"\", \"city\": \"Calhoun\", \"gend\": 1, \"insh\": \"0007663408001\", \"mzip\": 30701, \"name\": \"Judy A Reece\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"judyreece64@yahoo.com\", \"ename\": \"\", \"madd1\": \"251 Tucker Hollow Rd SE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Calhoun\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:38:03\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:38:03\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/31/2024 @ 10:35 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/30/2024 @ 09:49 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/28/2024 @ 05:04 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/1/2024 @ 01:00 PM\", \"result\": 6, \"comment\": \"Member stated she is a caregiver - member requested a call back number - Call attempt to schedule an HRA. - Call back \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/15/2024 @ 01:00 PM\"}, {\"date\": \"8/26/2024 @ 12:50 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a HRA w/ Connie Middleton. - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/27/2024 @ 12:50 PM\"}, {\"date\": \"8/14/2024 @ 02:27 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mariana Bernard\", \"callbackDate\": \"8/21/2024 @ 02:26 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-14-2024 14:27:00\", \"schedulerId\": \"84929813\", \"schedulerLeadId\": \"84929813\"}]}', '{\"date\": \"11-11-2024 00:41:06\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 1, NULL, NULL, NULL, NULL, '2025-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:38:03', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4556, NULL, NULL, NULL, '0007668265001', '433212', '', '33985161', 'Angie', 'Dickerson', '', '{\"DOB\": 35528, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Thomson\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Thomson\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1997-04-08\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 433212, \"Mailing_County\": \"MCDUFFIE\", \"Member_Country\": \"MCDUFFIE\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1891 Ridge Rd\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30824, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"1891 Ridge Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30824, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Dickerson\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Angie\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45444, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7065503971, \"Member_Identification_Number\": \"0007668265001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:38:05\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:38:05\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-12-31T00:03\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-15T15:34\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T00:48\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T01:08\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-30T23:59\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-31T00:03\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-15T15:34\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-15T05:44\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-16T01:08\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-30T23:59\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-31T00:03\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-10-18T16:05\", \"username\": \"TFerness2\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-10-14T15:19\", \"username\": null}, {\"date\": \"2024-10-14T15:19\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-10-17T20:49\", \"username\": \"DAdams\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:38:03\", \"value\": [{\"add\": \"1891 Ridge Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1997-04-08\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7065503971, \"zip\": 30824, \"add2\": \"\", \"add3\": \"\", \"city\": \"Thomson\", \"gend\": 1, \"insh\": \"0007668265001\", \"mzip\": 30824, \"name\": \"Angie Dickerson\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"1891 Ridge Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Thomson\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:38:03\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:38:03\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"12/18/2024 @ 09:28 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"12/17/2024 @ 10:19 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"12/12/2024 @ 11:08 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"12/11/2024 @ 12:04 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"12/10/2024 @ 12:15 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"12/12/2024 @ 09:30 AM\"}, {\"date\": \"11/25/2024 @ 01:01 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"11/27/2024 @ 09:30 AM\"}, {\"date\": \"11/6/2024 @ 03:58 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"11/08/2024 @ 09:30 AM\"}, {\"date\": \"8/15/2024 @ 03:34 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a virtual HRA w/ Nykya Cox. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Alyia Williams\", \"callbackDate\": \"8/16/2024 @ 03:34 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-15-2024 15:34:00\", \"schedulerId\": \"33985161\", \"schedulerLeadId\": \"33985161\"}]}', '{\"date\": \"12-31-2024 00:03:54\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 8}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:38:03', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4557, NULL, NULL, NULL, '0007668310001', '434165', '', '21881792', 'Neshanta', 'Johnson', '', '{\"DOB\": 29245, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Commerce\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Athens\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1980-01-25\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 434165, \"Mailing_County\": \"\", \"Member_Country\": \"BANKS\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"7309 Capstone Way\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30529, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"PO Box 6583\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30604, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Johnson\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Neshanta\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45444, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"marshan799@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7063722906, \"Member_Identification_Number\": \"0007668310001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:38:05\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:38:05\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-12-16T01:07\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-10-02T15:24\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-23T15:00\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T00:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T01:07\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-09-25T16:38\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-09-25T16:38\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-02T15:24\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-23T15:00\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:36\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-16T01:07\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-10-18T16:05\", \"username\": \"TFerness2\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-10-14T15:19\", \"username\": null}, {\"date\": \"2024-10-14T15:19\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-10-17T20:49\", \"username\": \"DAdams\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:38:04\", \"value\": [{\"add\": \"7309 Capstone Way\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1980-01-25\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7063722906, \"zip\": 30529, \"add2\": \"\", \"add3\": \"\", \"city\": \"Commerce\", \"gend\": 1, \"insh\": \"0007668310001\", \"mzip\": 30604, \"name\": \"Neshanta Johnson\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"marshan799@gmail.com\", \"ename\": \"\", \"madd1\": \"PO Box 6583\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Athens\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:38:04\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:38:04\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"12/6/2024 @ 11:24 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/22/2024 @ 11:13 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/29/2024 @ 02:37 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"10/31/2024 @ 09:30 AM\"}, {\"date\": \"10/23/2024 @ 03:00 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/24/2024 @ 02:59 PM\"}, {\"date\": \"10/2/2024 @ 03:24 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/3/2024 @ 03:24 PM\"}, {\"date\": \"9/25/2024 @ 04:38 PM\", \"result\": 6, \"comment\": \"Member needs an appt further out in month of October - attempting to schedule 1st week of Oct. Call back to attempt to schedule later part of October. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"9/26/2024 @ 04:38 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"09-25-2024 16:38:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"12-16-2024 01:07:18\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:38:04', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4558, NULL, NULL, NULL, '0007669625001', '435474', '', '21881792', 'Gregory', 'Benjamin', '', '{\"DOB\": 23243, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Bethlehem\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Bethlehem\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1963-08-20\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 435474, \"Mailing_County\": \"BARROW\", \"Member_Country\": \"BARROW\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"760 Slayton Dr\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30620, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"760 Slayton Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30620, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Benjamin\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Gregory\", \"Member_Middle_name\": \"J\", \"Plan_Effective_Date\": 45474, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"gregorybenjamin46@yahoo.cm\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7706011739, \"Member_Identification_Number\": \"0007669625001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 2, b'0', b'1', '{\"date\": \"11-22-2024 23:30:27\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"11-22-2024 23:30:27\", \"hrastatus\": \"\", \"reportstatus\": \"Termed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-10-23T17:54\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-10-02T14:45\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [{\"date\": \"2024-10-10T17:14\", \"text\": \"Virtual No Show\", \"method\": \"api\", \"status\": 23}], \"callBackRequested\": [{\"date\": \"2024-09-25T13:09\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-09-25T13:09\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-10-02T14:45\", \"reportStatus_date\": \"2024-10-02T14:45\"}, {\"text\": \"Virtual No Show\", \"type\": \"ReportStatus\", \"status\": 23, \"hraStatus\": 19, \"hraStatus_date\": \"2024-10-10T17:14\", \"reportStatus_date\": \"2024-10-10T17:14\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-23T17:54\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:29\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-10-10T17:14\", \"username\": \"NCox\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-10-02T14:45\", \"username\": null}, {\"date\": \"2024-10-02T14:45\", \"username\": null}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:38:04\", \"value\": [{\"add\": \"760 Slayton Dr\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1963-08-20\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7706011739, \"zip\": 30620, \"add2\": \"\", \"add3\": \"\", \"city\": \"Bethlehem\", \"gend\": 0, \"insh\": \"0007669625001\", \"mzip\": 30620, \"name\": \"Gregory J Benjamin\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"gregorybenjamin46@yahoo.cm\", \"ename\": \"\", \"madd1\": \"760 Slayton Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Bethlehem\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:38:04\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:38:04\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2024-10-10T17:14\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"NCox\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/23/2024 @ 05:54 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/24/2024 @ 05:54 PM\"}, {\"date\": \"10/2/2024 @ 02:45 PM\", \"result\": 0, \"comment\": \"Scheduled a virtual HRA w/ Nykya C on 10/10 @ 4:30 -- member will use their phone - doxy link texted to member. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"9/25/2024 @ 01:09 PM\", \"result\": 6, \"comment\": \"Member requested a call back at a later date and time - at doctor\'s appt.  - Call attempt to schedule an HRA. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"9/26/2024 @ 01:08 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"09-25-2024 13:09:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}, {\"date\": \"10-10-2024 17:14:55\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"10-10-2024 17:14:55\", \"status\": 0, \"details\": \"scheduled member moved to no show/cancellation\", \"disabled\": false, \"notification\": {\"type\": 1, \"value\": \"\", \"previous_status\": 1}}', '{\"attemptCount\": 3}', '{\"orderType\": 0, \"sortOrder\": 1730268447}', 1, NULL, NULL, 'Virtual', NULL, '2024-10-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:38:04', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4559, NULL, NULL, NULL, '0007670818001', '430360', '', '26056802', 'Gary', 'Braswell', '', '{\"DOB\": 22008, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Flowery Branch\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Flowery Branch\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1960-04-02\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 430360, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"7748 Soaring Eagle Dr\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30542, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"7748 Soaring Eagle Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30542, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Braswell\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Gary\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45383, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"kegbim@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6789433530, \"Member_Identification_Number\": \"0007670818001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:38:05\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:38:05\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-26T16:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-27T14:41\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-28T16:40\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-08-08T16:27\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-08T16:27\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-26T16:55\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-28T16:40\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:47\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-10-10T17:14\", \"username\": \"NCox\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-10-02T14:45\", \"username\": null}, {\"date\": \"2024-10-02T14:45\", \"username\": null}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:38:05\", \"value\": [{\"add\": \"7748 Soaring Eagle Dr\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1960-04-02\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6789433530, \"zip\": 30542, \"add2\": \"\", \"add3\": \"\", \"city\": \"Flowery Branch\", \"gend\": 0, \"insh\": \"0007670818001\", \"mzip\": 30542, \"name\": \"Gary Braswell\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"kegbim@gmail.com\", \"ename\": \"\", \"madd1\": \"7748 Soaring Eagle Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Flowery Branch\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:38:05\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:38:05\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/31/2024 @ 09:11 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"8/28/2024 @ 04:40 PM\", \"result\": 13, \"comment\": \"Called to schedule Virtual HRA with Delise Adams LVM \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"9/6/2024 @ 04:40 PM\"}, {\"date\": \"8/27/2024 @ 02:41 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA with Delise Adams LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"9/5/2024 @ 02:38 PM\"}, {\"date\": \"8/26/2024 @ 04:55 PM\", \"result\": 13, \"comment\": \"Called to schedule Virtual HRA with Delise Adams Caller Disconnected \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"9/2/2024 @ 04:55 PM\"}, {\"date\": \"8/8/2024 @ 04:27 PM\", \"result\": 6, \"comment\": \"Called to schedule Virtual HRA w/ Delise Adams - member states he needs a call back in 3 weeks (week of 8/26) \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"8/15/2024 @ 04:27 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-08-2024 16:27:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"11-11-2024 00:47:20\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 5}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:38:05', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4560, NULL, NULL, NULL, '0007670818002', '430361', '', NULL, 'Kimberly', 'Braswell', '', '{\"DOB\": 25912, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Flowery Branch\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Flowery Branch\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1970-12-10\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 430361, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"7748 Soaring Eagle Dr\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30542, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"7748 Soaring Eagle Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30542, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Braswell\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Kimberly\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45383, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Identification_Number\": \"0007670818002\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:38:06\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:38:05\", \"hrastatus\": 18, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:38:05\", \"value\": [{\"add\": \"7748 Soaring Eagle Dr\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1970-12-10\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": \"\", \"zip\": 30542, \"add2\": \"\", \"add3\": \"\", \"city\": \"Flowery Branch\", \"gend\": 1, \"insh\": \"0007670818002\", \"mzip\": 30542, \"name\": \"Kimberly Braswell\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"7748 Soaring Eagle Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Flowery Branch\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:38:05\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:38:05\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"08-08-2024 00:33:46\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', NULL, NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:38:05', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4561, NULL, NULL, NULL, '0007670818003', '430362', '', NULL, 'Payton', 'Braswell', '', '{\"DOB\": 38343, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Flowery Branch\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Flowery Branch\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"2004-12-22\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 430362, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"7748 Soaring Eagle Dr\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30542, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"7748 Soaring Eagle Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30542, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Braswell\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Payton\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45383, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Identification_Number\": \"0007670818003\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:38:06\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:38:06\", \"hrastatus\": 18, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:38:05\", \"value\": [{\"add\": \"7748 Soaring Eagle Dr\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"2004-12-22\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": \"\", \"zip\": 30542, \"add2\": \"\", \"add3\": \"\", \"city\": \"Flowery Branch\", \"gend\": 1, \"insh\": \"0007670818003\", \"mzip\": 30542, \"name\": \"Payton Braswell\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"7748 Soaring Eagle Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Flowery Branch\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:38:05\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:38:05\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"08-08-2024 00:33:46\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', NULL, NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:38:05', 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
(4562, NULL, NULL, NULL, '0007670942001', '433195', '', '84929813', 'Clyde', 'Abbott', '', '{\"DOB\": 22235, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Gainesville\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gainesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1960-11-15\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 433195, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"3651 Bob Bryant Rd\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30507, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"3651 Bob Bryant Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30507, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Abbott\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Clyde\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45444, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6789898118, \"Member_Identification_Number\": \"0007670942001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'1', '{\"date\": \"01-01-2025 23:38:06\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:38:06\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-09-26T12:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [{\"date\": \"2024-10-03T15:13\", \"text\": \"Ineligible\", \"method\": \"api\", \"status\": 2}], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-08-09T14:29\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-08-27T11:16\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-09T14:29\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-27T11:16\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-09-26T12:19\"}, {\"text\": \"Ineligible\", \"type\": \"ReportStatus\", \"status\": 2, \"hraStatus\": 14, \"hraStatus_date\": \"2024-10-03T15:13\", \"reportStatus_date\": \"2024-10-03T15:13\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [{\"date\": \"2024-10-03T15:13\", \"username\": null}], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:38:06\", \"value\": [{\"add\": \"3651 Bob Bryant Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1960-11-15\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6789898118, \"zip\": 30507, \"add2\": \"\", \"add3\": \"\", \"city\": \"Gainesville\", \"gend\": 0, \"insh\": \"0007670942001\", \"mzip\": 30507, \"name\": \"Clyde Abbott\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"3651 Bob Bryant Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gainesville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:38:06\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:38:06\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 2, \"callLog\": [{\"date\": \"10/3/2024 @ 03:13 PM\", \"result\": 2, \"comment\": \"INELIGIBLE - Member stated no longer on health plan. Call attempt to schedule an HRA. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"9/26/2024 @ 12:19 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"9/27/2024 @ 12:19 PM\"}, {\"date\": \"8/27/2024 @ 11:16 AM\", \"result\": 6, \"comment\": \"Member states that he is still waiting to receive the letter.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"9/3/2024 @ 11:16 AM\"}, {\"date\": \"8/9/2024 @ 02:29 PM\", \"result\": 6, \"comment\": \"member would like to receive letter in the mail first. he claims he has not. updated address to the correct one. 3561 Bob Bryant Rd\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Mariana Bernard\", \"callbackDate\": \"8/23/2024 @ 02:28 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-09-2024 14:29:00\", \"schedulerId\": \"84929813\", \"schedulerLeadId\": \"84929813\"}]}', '{\"date\": \"08-08-2024 00:33:46\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 4}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:38:06', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4563, 57818338, 44829497, '56716210', '0007671928001', '431626', '', '21881792', 'Gary', 'Cannon', '', '{\"DOB\": 22217, \"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\": \"30582\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"Young Harris \", \"Pcp_Name\": \"Paula Boyle\", \"Rank_All\": \"\", \"PCP_Phone\": \"7064396873\", \"Pcp_State\": \"\", \"Member_City\": \"Hiawassee\", \"Office_Name\": \"Union General Young Harris Clinic\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Hiawassee\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1960-10-28\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"1155 Main St\", \"Screening_IHA\": \"No\", \"member_id_two\": 431626, \"Mailing_County\": \"TOWNS\", \"Member_Country\": \"TOWNS\", \"PCP_Fax_Number\": \"7064396874\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"899 Bauer Rd\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30546, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"899 Bauer Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30546, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Cannon\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Gary\", \"Member_Middle_name\": \"Neil\", \"Plan_Effective_Date\": 45413, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"gettheleadout@bellsouth.net\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 7625003289, \"Member_Identification_Number\": \"0007671928001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"12-03-2024 16:03:46\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-12-03 16:03:46\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-10-25T13:54\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-11-26T16:03\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-12-02T17:40\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-12-02T17:59\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-12-03T16:03\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-11-22T12:13\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-10-25T13:54\"}, {\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 2, \"hraStatus_date\": \"2024-11-25T19:21\", \"reportStatus_date\": \"2024-11-22T12:13\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-12-02T17:59\", \"reportStatus_date\": \"2024-12-02T17:59\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-12-03T16:03\", \"reportStatus_date\": \"2024-12-03T16:03\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-12-03T16:03\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-11-22T12:13\", \"username\": null}, {\"date\": \"2024-11-22T12:13\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-11-25T19:21\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-12-02T12:08\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2024-11-26T16:03\", \"username\": \"DAdams\"}, {\"date\": \"2024-11-26T16:03\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-12-02T17:59\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-12-02T17:40\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-12-02T17:59\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"01-16-2025\", \"time\": \"10:35:38\", \"value\": [{\"add\": \"899 Bauer Rd\", \"age\": 64, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1960-10-28\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7625003289, \"zip\": 30546, \"add2\": \"\", \"add3\": \"\", \"city\": \"Hiawassee\", \"gend\": 0, \"insh\": \"0007671928001\", \"mzip\": 30546, \"name\": \"Gary Neil Cannon\", \"plan\": \"Alliant\", \"pphy\": \"Paula Boyle\", \"ppno\": \"7064396873\", \"race\": \"\", \"cliId\": \"\", \"email\": \"gettheleadout@bellsouth.net\", \"ename\": \"Paula Cannon\", \"madd1\": \"899 Bauer Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Hiawassee\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"1155 Main St\", \"pcpnpi\": \"\", \"pcpzip\": \"30582\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"Young Harris \", \"pcpname\": \"Union General Young Harris Clinic\", \"program\": \"ACA\", \"evalDate\": \"2024-11-26 1:15 PM\", \"evalName\": \"Delise Adams, FNP\", \"pcpfaxno\": \"7064396874\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [null, null, null, null, true], \"score\": [], \"comment\": [null, null, null, null, \"virtual visit\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"11-25-2024\", \"time\": \"19:21:26\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"01-16-2025 10:35:38\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"11/22/2024 @ 12:13 PM\", \"result\": 0, \"comment\": \"SCHEDULED - VIRTUAL  - DELISE ADAMS - 11/26 @ 1:15 - DOXY LINK SENT VIA TEXT\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"10/25/2024 @ 01:54 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/28/2024 @ 01:54 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0007671928001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"56716210\", \"memberId\": \"0007671928001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"56716210\", \"memberId\": \"0007671928001\", \"scheduleDate\": \"2024-11-26T13:15\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"10-25-2024 13:54:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"11-22-2024 12:13:22\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 0, NULL, '[{\"date\": \"2024-12-03 16:03:45\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"15504430-b1ba-11ef-a31f-3f1006172d34\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'Virtual', '2024-11-26T13:15', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:38:06', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007671928001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0007671928001_Cannon, Gary_11262024.pdf\", \"ftp_upload_date\": \"2024-12-03 16:03:44\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Boyle, Paula_0007671928001_11262024.pdf\"}', 'ACA_0007671928001_Cannon, Gary_11262024', NULL, 'PCP_Boyle, Paula_0007671928001_11262024', NULL, '[{\"date\": \"2024-11-26T21:03:41.685Z\", \"signature\": \"data:image/png;base64,[encoded data, 23432 characters]\"}]', '2024-11-26T13:53', 'Member_Summary_0007671928001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007671928001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0007671928001.pdf\", \"member_ftp_upload_date\": \"2024-12-03 16:03:45\"}', NULL, NULL, NULL, NULL);
INSERT INTO `HRA_member_client_009_2024` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`) VALUES
(4564, NULL, NULL, NULL, '0007672012001', '433430', '', '99038484', 'Johnnie', 'Mccracken', '', '{\"DOB\": 22997, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Moultrie\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Moultrie\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1962-12-17\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 433430, \"Mailing_County\": \"COLQUITT\", \"Member_Country\": \"COLQUITT\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1700 4th St SE\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 31768, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"1700 4th St SE\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31768, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Mccracken\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Johnnie\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45444, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"mccrackenjonnie@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 2292649299, \"Member_Identification_Number\": \"0007672012001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:38:06\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:38:06\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-12-16T00:38\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-12-16T00:38\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [{\"date\": \"2024-08-09T17:18\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-09-13T12:48\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-09-30T12:21\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-10-17T10:52\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-09T17:18\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-09-13T12:48\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-09-30T12:21\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-17T10:52\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-15T05:46\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-16T00:38\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-10-10T17:14\", \"username\": \"NCox\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-10-02T14:45\", \"username\": null}, {\"date\": \"2024-10-02T14:45\", \"username\": null}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:38:07\", \"value\": [{\"add\": \"1700 4th St SE\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1962-12-17\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 2292649299, \"zip\": 31768, \"add2\": \"\", \"add3\": \"\", \"city\": \"Moultrie\", \"gend\": 0, \"insh\": \"0007672012001\", \"mzip\": 31768, \"name\": \"Johnnie Mccracken\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"mccrackenjonnie@gmail.com\", \"ename\": \"\", \"madd1\": \"1700 4th St SE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Moultrie\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:38:07\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:38:07\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/12/2024 @ 11:36 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/11/2024 @ 11:31 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/7/2024 @ 02:18 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 02:19 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 02:13 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/17/2024 @ 10:52 AM\", \"result\": 10, \"comment\": \"Call attempt to schedule an HRA - Disconnected \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/18/2024 @ 10:52 AM\"}, {\"date\": \"9/30/2024 @ 12:21 PM\", \"result\": 10, \"comment\": \"Call attempt to schedule an HRA - Disconnected\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/1/2024 @ 12:21 PM\"}, {\"date\": \"9/13/2024 @ 12:48 PM\", \"result\": 10, \"comment\": \"Primary number no longer in service. Call attempt to schedule an HRA - Disconnected\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"9/16/2024 @ 12:48 PM\"}, {\"date\": \"8/9/2024 @ 05:18 PM\", \"result\": 10, \"comment\": \"Called to Schedule Virtual HRA with Jansen number disconnected.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"8/16/2024 @ 05:17 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-09-2024 17:18:00\", \"schedulerId\": \"99038484\", \"schedulerLeadId\": \"99038484\"}]}', '{\"date\": \"12-16-2024 00:38:58\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 9}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:38:07', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4565, NULL, NULL, NULL, '0007672012002', '433431', '', NULL, 'Ellen', 'McCracken', '', '{\"DOB\": 25998, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Moultrie\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Moultrie\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1971-03-06\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 433431, \"Mailing_County\": \"COLQUITT\", \"Member_Country\": \"COLQUITT\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1700 4th St SE\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 31768, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"1700 4th St SE\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31768, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"McCracken\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Ellen\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45444, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Identification_Number\": \"0007672012002\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:38:06\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:38:06\", \"hrastatus\": 18, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:38:07\", \"value\": [{\"add\": \"1700 4th St SE\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1971-03-06\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": \"\", \"zip\": 31768, \"add2\": \"\", \"add3\": \"\", \"city\": \"Moultrie\", \"gend\": 1, \"insh\": \"0007672012002\", \"mzip\": 31768, \"name\": \"Ellen McCracken\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"1700 4th St SE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Moultrie\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:38:07\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:38:07\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"08-08-2024 00:33:46\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', NULL, NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:38:07', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4566, NULL, NULL, NULL, '0007672057001', '434659', '', NULL, 'Jennifer', 'Thomas', '', '{\"DOB\": 33099, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Thomasville\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Thomasville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1990-08-14\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 434659, \"Mailing_County\": \"THOMAS\", \"Member_Country\": \"THOMAS\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"221 Covington Ave Apt 155\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 31792, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"221 Covington Ave Apt 155\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31792, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Thomas\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Jennifer\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45444, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"ms.dthomas90@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 2292005318, \"Member_Identification_Number\": \"0007672057001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"08-08-2024 00:00:20\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2024-08-08 00:00:20\", \"hrastatus\": 18, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:38:07\", \"value\": [{\"add\": \"221 Covington Ave Apt 155\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1990-08-14\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 2292005318, \"zip\": 31792, \"add2\": \"\", \"add3\": \"\", \"city\": \"Thomasville\", \"gend\": 1, \"insh\": \"0007672057001\", \"mzip\": 31792, \"name\": \"Jennifer Thomas\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"ms.dthomas90@gmail.com\", \"ename\": \"\", \"madd1\": \"221 Covington Ave Apt 155\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Thomasville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:38:07\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:38:07\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"08-08-2024 00:33:47\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', NULL, NULL, 1, NULL, NULL, NULL, NULL, '2024-07-22', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:38:07', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4567, NULL, NULL, NULL, '0007673088001', '423174', '', '99038484', 'MARLON', 'ELDRIDGE', '', '{\"DOB\": 25744, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Bainbridge\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Bainbridge\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1970-06-25\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 423174, \"Mailing_County\": \"DECATUR\", \"Member_Country\": \"DECATUR\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"636 Randolph Ct\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 39819, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"636 Randolph Ct\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 39819, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"ELDRIDGE\", \"Medication_Review\": \"N\", \"Member_first_name\": \"MARLON\", \"Member_Middle_name\": \"L\", \"Plan_Effective_Date\": 45323, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"truckerlife_70@yahoo.com\", \"Member_Suspect_Codes\": \"21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 2292207553, \"Member_Identification_Number\": \"0007673088001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:38:06\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:38:06\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-11-22T10:36\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": {\"0\": {\"date\": \"2024-09-11T17:09\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, \"2\": {\"date\": \"2024-11-22T10:36\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}}, \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-08-07T18:13\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-09-13T17:50\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-07T18:13\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-09-13T17:50\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:29\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-22T10:36\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-10-10T17:14\", \"username\": \"NCox\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-10-02T14:45\", \"username\": null}, {\"date\": \"2024-10-02T14:45\", \"username\": null}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:38:08\", \"value\": [{\"add\": \"636 Randolph Ct\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1970-06-25\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 2292207553, \"zip\": 39819, \"add2\": \"\", \"add3\": \"\", \"city\": \"Bainbridge\", \"gend\": 0, \"insh\": \"0007673088001\", \"mzip\": 39819, \"name\": \"MARLON L ELDRIDGE\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"truckerlife_70@yahoo.com\", \"ename\": \"\", \"madd1\": \"636 Randolph Ct\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Bainbridge\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:38:08\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:38:08\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"12/6/2024 @ 10:08 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/22/2024 @ 10:36 AM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"10/28/2024 @ 04:07 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/13/2024 @ 05:50 PM\", \"result\": 6, \"comment\": \"Call back member was working-LLA\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"9/20/2024 @ 05:50 PM\"}, {\"date\": \"9/11/2024 @ 05:09 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"9/12/2024 @ 05:08 PM\"}, {\"date\": \"8/7/2024 @ 06:13 PM\", \"result\": 6, \"comment\": \"Called to Schedule Virtual HRA with Debbie but member requested a call back.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"8/14/2024 @ 06:12 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-07-2024 18:13:00\", \"schedulerId\": \"99038484\", \"schedulerLeadId\": \"99038484\"}]}', '{\"date\": \"11-22-2024 10:36:35\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:38:08', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4568, NULL, NULL, NULL, '0007675764001', '432987', '', '99038484', 'JOSEPH', 'CARROLL', '', '{\"DOB\": 28815, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"PCP_Phone\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Dalton\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Dalton\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1978-11-21\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 432987, \"Mailing_County\": \"WHITFIELD\", \"Member_Country\": \"WHITFIELD\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"2470 Crow Valley Rd NW\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30720, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"2470 Crow Valley Rd NW\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30720, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"CARROLL\", \"Medication_Review\": \"N\", \"Member_first_name\": \"JOSEPH\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45444, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"84\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4356954500, \"Member_Identification_Number\": \"0007675764001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 2, b'0', b'1', '{\"date\": \"01-01-2025 23:38:06\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:38:06\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-20T16:16\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-22T16:48\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-01T15:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-09T17:45\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-10-30T12:01\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [{\"date\": \"2024-11-18T06:30\", \"text\": \"Virtual No Show\", \"method\": \"api\", \"status\": 23}], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-22T16:48\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-01T15:05\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-09T17:45\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-10-30T12:01\", \"reportStatus_date\": \"2024-10-30T12:01\"}, {\"text\": \"Rescheduled\", \"type\": \"HraStatus\", \"status\": 16, \"hraStatus\": 1, \"hraStatus_date\": \"2024-11-11T12:33\", \"reportStatus_date\": \"2024-11-11T12:33\"}, {\"text\": \"Virtual No Show\", \"type\": \"ReportStatus\", \"status\": 23, \"hraStatus\": 19, \"hraStatus_date\": \"2024-11-18T06:30\", \"reportStatus_date\": \"2024-11-18T06:30\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-11-18T06:30\", \"username\": \"FEnwefah\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-10-30T12:01\", \"username\": null}, {\"date\": \"2024-10-30T12:01\", \"username\": null}, {\"date\": \"2024-11-11T12:33\", \"username\": null}, {\"date\": \"2024-11-11T12:33\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-11-08T01:16\", \"username\": \"DAdams\"}, {\"date\": \"2024-11-15T08:28\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-11-11T11:36\", \"username\": \"AWalsh\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"11-15-2024\", \"time\": \"08:28:08\", \"value\": [{\"add\": \"2470 Crow Valley Rd NW\", \"age\": 45, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1978-11-21\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4356954500, \"zip\": 30720, \"add2\": \"\", \"add3\": \"\", \"city\": \"Dalton\", \"gend\": 0, \"insh\": \"0007675764001\", \"mzip\": 30720, \"name\": \"JOSEPH CARROLL\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"2470 Crow Valley Rd NW\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Dalton\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [], \"score\": [], \"comment\": []}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"11-08-2024\", \"time\": \"01:16:28\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"11-15-2024 10:26:04\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2024-11-18T06:30\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"FEnwefah\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2024-11-11T11:36\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"AWalsh\", \"hraStatus\": 3, \"cancelText\": \"\", \"cancelStatus\": 0}]}', NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/11/2024 @ 12:33 PM\", \"result\": 12, \"comment\": \"Inbound - Rescheduled - Member returned call - rescheduled virtual HRA w/ Faith E on 11/15 @ 10 - member will use their phone - texted Doxy info to member. \", \"inBound\": true, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"10/30/2024 @ 12:01 PM\", \"result\": 0, \"comment\": \"called for HRA-Virtual - Delise Adams-GA, NP : scheduled for 11/08 @ 3pm\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Rocheline Lovaincy\", \"callbackDate\": \"\"}, {\"date\": \"10/30/2024 @ 11:40 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/9/2024 @ 05:45 PM\", \"result\": 3, \"comment\": \"LVM to schedule with Connie Middleton for HRA-LLA\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"10/16/2024 @ 05:45 PM\"}, {\"date\": \"10/1/2024 @ 03:05 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/2/2024 @ 03:05 PM\"}, {\"date\": \"8/22/2024 @ 04:48 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Debbie no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"8/29/2024 @ 04:48 PM\"}, {\"date\": \"8/20/2024 @ 04:16 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Connie no answer No VM Setup.\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"8/27/2024 @ 04:15 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-20-2024 16:16:00\", \"schedulerId\": \"99038484\", \"schedulerLeadId\": \"99038484\"}, {\"date\": \"11-11-2024 11:36:59\", \"schedulerId\": \"99038484\", \"schedulerLeadId\": \"99038484\"}, {\"date\": \"11-18-2024 06:30:36\", \"schedulerId\": \"99038484\", \"schedulerLeadId\": \"99038484\"}]}', '{\"date\": \"11-18-2024 06:30:36\", \"status\": 0, \"details\": \"scheduled member moved to no show/cancellation\", \"disabled\": false, \"notification\": {\"type\": 1, \"value\": \"\", \"previous_status\": 1}}', '{\"attemptCount\": 7}', NULL, 1, NULL, NULL, 'Virtual', NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:38:08', 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
(4569, 71932120, 44829497, '56716210', '0007675772001', '433188', '', '21881792', 'Tracy', 'Gaudlock', '', '{\"DOB\": 24142, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"Pcp_Zip\": \"30501\", \"Program\": \"ACA\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Gainesville\", \"Pcp_Name\": \"Kenneth Fogarty II\", \"Rank_All\": \"\", \"PCP_Phone\": \"7705399600\", \"Pcp_State\": \"\", \"Member_City\": \"GAINESVILLE\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Cleveland\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1966-02-04\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"2350 LIMESTONE PKWY\", \"Screening_IHA\": \"No\", \"member_id_two\": 433188, \"Mailing_County\": \"WHITE\", \"Member_Country\": \"WHITE\", \"PCP_Fax_Number\": \"7705341470\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"3138 BARRETT RD\", \"Member_Address2\": \"\", \"Member_Address3\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30528, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"36 Bobcat Alley\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30528, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Gaudlock\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Tracy\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45444, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"tracygaudlock01@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 7705301190, \"Member_Identification_Number\": \"0007675772001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"09-24-2024 12:52:58\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-09-24 12:52:58\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-09-17T17:52\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-09-23T11:29\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-09-23T12:42\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-09-24T12:52\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [{\"date\": \"2024-09-16T09:35\", \"text\": \"F2F No Show\", \"method\": \"api\", \"status\": 24}], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-08-22T15:43\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-09-06T10:20\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-09-16T09:37\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-08-22T15:43\", \"reportStatus_date\": \"2024-08-22T15:43\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-09-06T10:20\", \"reportStatus_date\": \"2024-09-06T10:20\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-09-16T09:37\", \"reportStatus_date\": \"2024-09-16T09:37\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-09-23T12:42\", \"reportStatus_date\": \"2024-09-23T12:42\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-09-24T12:52\", \"reportStatus_date\": \"2024-09-24T12:52\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-09-16T09:35\", \"username\": \"TFerness2\"}], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-09-24T12:52\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-08-22T15:43\", \"username\": null}, {\"date\": \"2024-08-22T15:43\", \"username\": null}, {\"date\": \"2024-09-06T10:20\", \"username\": null}, {\"date\": \"2024-09-06T10:20\", \"username\": null}, {\"date\": \"2024-09-16T09:37\", \"username\": \"LAtherholt\"}], \"inProgress\": [{\"date\": \"2024-09-04T21:00\", \"username\": \"DAdams\"}, {\"date\": \"2024-09-17T09:47\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-09-18T12:56\", \"username\": \"TFerness2\"}], \"readyForQa\": [{\"date\": \"2024-09-17T17:52\", \"username\": \"DAdams\"}, {\"date\": \"2024-09-17T17:52\", \"username\": \"DAdams\"}, {\"date\": \"2024-09-20T20:44\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-09-23T12:42\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-09-23T11:29\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-09-23T12:42\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-09-19T10:14\", \"username\": \"MJoseph\"}, {\"date\": \"2024-09-20T20:43\", \"username\": \"DAdams\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"11-12-2024\", \"time\": \"17:16:31\", \"value\": [{\"add\": \"3138 BARRETT RD\", \"age\": 58, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1966-02-04\", \"eno\": \"7063485089\", \"lob\": \"On Exchange\", \"pno\": 7705301190, \"zip\": 30528, \"add2\": \"\", \"add3\": \"\", \"city\": \"GAINESVILLE\", \"gend\": 0, \"insh\": \"0007675772001\", \"mzip\": 30528, \"name\": \"Tracy Gaudlock\", \"plan\": \"Alliant\", \"pphy\": \"Kenneth Fogarty II\", \"ppno\": \"7705399600\", \"race\": \"\", \"cliId\": \"\", \"email\": \"tracygaudlock01@gmail.com\", \"ename\": \"Kimberly Bregante\", \"madd1\": \"36 Bobcat Alley\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Cleveland\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"2350 LIMESTONE PKWY\", \"pcpnpi\": \"\", \"pcpzip\": \"30501\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Single\", \"pcpFlag\": \"\", \"pcpcity\": \"Gainesville\", \"pcpname\": \"\", \"program\": \"ACA\", \"evalDate\": \"2024-9-17 09:45 AM\", \"evalName\": \"Delise Adams, FNP\", \"pcpfaxno\": \"7705341470\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [], \"score\": [], \"comment\": []}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"09-04-2024\", \"time\": \"21:00:58\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"11-12-2024 17:16:31\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2024-09-16T09:35\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"TFerness2\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, '{\"memberId\": \"0007675772001\", \"clinician\": \"Delise Adams\", \"qaAnalyst\": \"Manoucheca Joseph\", \"queryData\": [{\"date\": \"Thu, 19 Sep 2024 14:14:39 GMT\", \"name\": \"Manoucheca \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Delise,\\n\\n1. The date of the exam was noted as 09/17/2024 but the visit was conducted on 09/05/2024. Please update.\\n\\nThank you,\\nManoucheca\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Sat, 21 Sep 2024 00:44:47 GMT\", \"name\": \"Delise \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Member was seen on 9/17/2024. He no showed on 9/5/2024. I corrected the dates. Thank you. \"}, \"mailId\": \"\"}], \"memberName\": \"Tracy Gaudlock\", \"codingAnalyst\": \"\", \"dateOfService\": \"09/17/2024 09:45 AM\", \"clinicianMailId\": \"deliseadams@sbcglobal.net\", \"qaAnalystMailId\": \"m.joseph@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 12, \"callLog\": [{\"date\": \"9/6/2024 @ 10:20 AM\", \"result\": 12, \"comment\": \"Rescheduled Delise A 9/17 @ 9:45 - no pets, park anywhere avail. no to COVID FLU questions. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"8/22/2024 @ 03:43 PM\", \"result\": 0, \"comment\": \"Scheduled Delise A 9/5 @ 9:45 - no pets, park anywhere avail. no to COVID FLU questions. Member updated address: 3138 BARRETT RD GAINESVILLE \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0007675772001\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"56716210\", \"memberId\": \"0007675772001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"56716210\", \"memberId\": \"0007675772001\", \"scheduleDate\": \"2024-9-17T09:45\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-22-2024 15:43:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}, {\"date\": \"09-16-2024 09:35:03\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"09-16-2024 09:35:03\", \"status\": 0, \"details\": \"scheduled member moved to no show/cancellation\", \"disabled\": false, \"notification\": {\"type\": 1, \"value\": \"\", \"previous_status\": 1}}', '{\"attemptCount\": 2}', '{\"orderType\": 1, \"sortOrder\": 1726493703}', 1, NULL, '[{\"date\": \"2024-09-24 12:52:57\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"731693fc-7a95-11ef-a242-3f1df55ec2a6\\\",\\\"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-9-17T09:45', '2024-12-31', '2024-09-17T09:45', NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:38:09', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007675772001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0007675772001_Gaudlock, Tracy_09172024.pdf\", \"ftp_upload_date\": \"2024-09-24 12:52:56\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Fogharty, Kenneth_0007675772001_09172024.pdf\"}', 'ACA_0007675772001_Gaudlock, Tracy_09172024', NULL, 'PCP_Fogharty, Kenneth_0007675772001_09172024', NULL, '[{\"date\": \"2024-09-17T21:52:28.959Z\", \"signature\": \"data:image/png;base64,[encoded data, 23460 characters]\"}, {\"date\": \"2024-09-21T00:44:46.668Z\", \"signature\": \"data:image/png;base64,[encoded data, 23484 characters]\"}]', '2024-09-17T11:10', 'Member_Summary_0007675772001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007675772001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0007675772001.pdf\", \"member_ftp_upload_date\": \"2024-09-24 12:52: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
(4570, 3285757, 44829497, '96917241', '0007676903001', '433713', '', '99038484', 'Joy', 'Moncayo', '', '{\"DOB\": 31744, \"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\": \"\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"PCP_Phone\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Moultrie\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Moultrie\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1986-11-28\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 433713, \"Mailing_County\": \"COLQUITT\", \"Member_Country\": \"COLQUITT\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1059 Tallokas Pointe Rd Apt 206\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 31768, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"1059 Tallokas Pointe Rd Apt 206\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31768, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Moncayo\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Joy\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45444, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"joy.moncayo11@gmail.com\", \"Member_Suspect_Codes\": \"212\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 2294296937, \"Member_Identification_Number\": \"0007676903001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 2, b'1', b'1', '{\"date\": \"10-01-2024 12:20:38\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-10-01 12:20:38\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-09T16:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-09-21T11:44\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-09-24T17:27\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-09-24T20:19\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-10-01T12:20\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-09-13T12:57\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-09T16:55\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-09-13T12:57\", \"reportStatus_date\": \"2024-09-13T12:57\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-09-21T11:44\", \"reportStatus_date\": \"2024-09-21T11:44\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-09-24T20:19\", \"reportStatus_date\": \"2024-09-24T20:19\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-10-01T12:20\", \"reportStatus_date\": \"2024-10-01T12:20\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-10-01T12:20\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-09-13T12:57\", \"username\": null}, {\"date\": \"2024-09-13T12:57\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-09-21T10:28\", \"username\": \"NCox\"}], \"qaAssigned\": [{\"date\": \"2024-09-23T12:09\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2024-09-21T11:44\", \"username\": \"NCox\"}, {\"date\": \"2024-09-21T11:44\", \"username\": \"NCox\"}, {\"date\": \"2024-09-24T08:33\", \"username\": \"NCox\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-09-24T20:19\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-09-24T17:27\", \"username\": \"BClark\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-09-24T20:19\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-09-24T00:14\", \"username\": \"BClark\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"11-18-2024\", \"time\": \"17:59:37\", \"value\": [{\"add\": \"1059 Tallokas Pointe Rd Apt 206\", \"age\": 37, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1986-11-28\", \"eno\": \"2295292700\", \"lob\": \"On Exchange\", \"pno\": 2294296937, \"zip\": 31768, \"add2\": \"\", \"add3\": \"\", \"city\": \"Moultrie\", \"gend\": 1, \"insh\": \"0007676903001\", \"mzip\": 31768, \"name\": \"Joy Moncayo\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"joy.moncayo11@gmail.com\", \"ename\": \"Noel Valentine \", \"madd1\": \"1059 Tallokas Pointe Rd Apt 206\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Moultrie\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Female\", \"pphycomment\": \"does not have PCP, only sees OBGYN \", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"1\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [], \"score\": [], \"comment\": []}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"09-21-2024\", \"time\": \"10:28:57\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"11-18-2024 17:59:37\"}', NULL, NULL, '{\"memberId\": \"0007676903001\", \"clinician\": \"Nykya Cox\", \"qaAnalyst\": \"Brianne Clark\", \"queryData\": [{\"date\": \"Tue, 24 Sep 2024 04:14:15 GMT\", \"name\": \"Brianne \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Nykya,\\nThank you for your thorough assessment!\\n\\n1) Under preventative care, can you please add a date/year for all of the \\\"yes\\\" answers, and was it recommended for member to have a flu vaccine?\\n2) Under assessment of dx can you please select yes or no for integument problems\\n3) Can you put self-reported for vital signs\\n\\nThank you!\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Tue, 24 Sep 2024 12:33:50 GMT\", \"name\": \"Nykya \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"\"}, \"mailId\": \"\"}], \"memberName\": \"Joy Moncayo\", \"codingAnalyst\": \"\", \"dateOfService\": \"09/21/2024 10:30 AM\", \"clinicianMailId\": \"n.cox@focuscares.com\", \"qaAnalystMailId\": \"b.clark@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"9/13/2024 @ 12:57 PM\", \"result\": 0, \"comment\": \"Scheduled Nykya C on 9/21 @ 10:30 - member will use their phone - texted doxy link to member \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"8/9/2024 @ 04:55 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Jansen no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"8/16/2024 @ 04:55 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0007676903001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"96917241\", \"memberId\": \"0007676903001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"96917241\", \"memberId\": \"0007676903001\", \"scheduleDate\": \"2024-9-21T10:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-09-2024 16:55:00\", \"schedulerId\": \"99038484\", \"schedulerLeadId\": \"99038484\"}]}', '{\"date\": \"09-13-2024 12:57:27\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 0, NULL, '[{\"date\": \"2024-10-01 12:20:37\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"17bc4b48-8011-11ef-870a-c3e925cde49c\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'Virtual', '2024-9-21T10:30', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:38:09', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007676903001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0007676903001_Moncayo, Joy_09212024.pdf\", \"ftp_upload_date\": \"2024-10-01 12:20:36\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP__0007676903001_09212024.pdf\"}', 'ACA_0007676903001_Moncayo, Joy_09212024', NULL, 'PCP__0007676903001_09212024', NULL, '[{\"date\": \"2024-09-21T15:44:10.934Z\", \"signature\": \"data:image/png;base64,[encoded data, 25504 characters]\"}, {\"date\": \"2024-09-24T12:33:50.331Z\", \"signature\": \"data:image/png;base64,[encoded data, 25536 characters]\"}]', '2024-09-21T11:15', 'Member_Summary_0007676903001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007676903001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0007676903001.pdf\", \"member_ftp_upload_date\": \"2024-10-01 12:20:37\"}', 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
(4571, NULL, NULL, NULL, '0007677971001', '429242', '', NULL, 'Deborah', 'Meherg', '', '{\"DOB\": 24340, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Buchanan\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Buchanan\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1966-08-21\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 429242, \"Mailing_County\": \"HARALSON\", \"Member_Country\": \"HARALSON\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-07-31\", \"Member_Address1\": \"221 Corinth Five Points Rd\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30113, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"221 Corinth Five Points Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30113, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Meherg\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Deborah\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45383, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4047977063, \"Member_Identification_Number\": \"0007677971001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"08-08-2024 00:00:20\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2024-08-08 00:00:20\", \"hrastatus\": 18, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:38:09\", \"value\": [{\"add\": \"221 Corinth Five Points Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1966-08-21\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4047977063, \"zip\": 30113, \"add2\": \"\", \"add3\": \"\", \"city\": \"Buchanan\", \"gend\": 1, \"insh\": \"0007677971001\", \"mzip\": 30113, \"name\": \"Deborah Meherg\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"221 Corinth Five Points Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Buchanan\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:38:09\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:38:09\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"08-08-2024 00:33:47\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', NULL, NULL, 1, NULL, NULL, NULL, NULL, '2024-07-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:38:09', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4572, NULL, NULL, NULL, '0007677995001', '430173', '', '99038484', 'Benjamin', 'Franklin', '', '{\"DOB\": 23346, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Jasper\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Big Canoe\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1963-12-01\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 430173, \"Mailing_County\": \"\", \"Member_Country\": \"DAWSON\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"368 North Sanderlin Mtn Drive\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30143, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"10798 Big Canoe\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30143, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Franklin\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Benjamin\", \"Member_Middle_name\": \"Philmore\", \"Plan_Effective_Date\": 45383, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"philfranklin07@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6785766681, \"Member_Identification_Number\": \"0007677995001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:38:07\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:38:06\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-12-16T01:05\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-26T15:22\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-23T18:02\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T00:36\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T00:44\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T01:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-26T15:22\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-23T18:02\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-15T05:41\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-16T01:05\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-11-18T06:30\", \"username\": \"FEnwefah\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-10-30T12:01\", \"username\": null}, {\"date\": \"2024-10-30T12:01\", \"username\": null}, {\"date\": \"2024-11-11T12:33\", \"username\": null}, {\"date\": \"2024-11-11T12:33\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-11-08T01:16\", \"username\": \"DAdams\"}, {\"date\": \"2024-11-15T08:28\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-11-11T11:36\", \"username\": \"AWalsh\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:38:10\", \"value\": [{\"add\": \"368 North Sanderlin Mtn Drive\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1963-12-01\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6785766681, \"zip\": 30143, \"add2\": \"\", \"add3\": \"\", \"city\": \"Jasper\", \"gend\": 0, \"insh\": \"0007677995001\", \"mzip\": 30143, \"name\": \"Benjamin Philmore Franklin\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"philfranklin07@gmail.com\", \"ename\": \"\", \"madd1\": \"10798 Big Canoe\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Big Canoe\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:38:10\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:38:10\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"12/19/2024 @ 02:52 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"12/17/2024 @ 09:31 AM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"12/12/2024 @ 09:47 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"12/11/2024 @ 09:37 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"12/10/2024 @ 09:42 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"12/9/2024 @ 09:41 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/22/2024 @ 12:22 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 01:32 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"11/08/2024 @ 09:30 AM\"}, {\"date\": \"11/1/2024 @ 09:34 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"11/03/2024 @ 09:30 AM\"}, {\"date\": \"10/23/2024 @ 06:02 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/24/2024 @ 06:02 PM\"}, {\"date\": \"8/26/2024 @ 03:22 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Debbie no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"9/2/2024 @ 03:22 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-26-2024 15:22:00\", \"schedulerId\": \"99038484\", \"schedulerLeadId\": \"99038484\"}]}', '{\"date\": \"12-16-2024 01:05:26\", \"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', '07-08-2024 01:38:10', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4573, NULL, NULL, NULL, '0007679302001', '435355', '', '84929813', 'WADE', 'NEWPORT', '', '{\"DOB\": 22666, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Chatsworth\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Chatsworth\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1962-01-20\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 435355, \"Mailing_County\": \"MURRAY\", \"Member_Country\": \"MURRAY\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1337 Old Dalton Ellijay Rd\", \"Member_Address2\": \"Apt 26\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30705, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"1337 Old Dalton Ellijay Rd\", \"Mailing_Address2\": \"Apt 26\", \"Mailing_Zip_Code\": 30705, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"NEWPORT\", \"Medication_Review\": \"N\", \"Member_first_name\": \"WADE\", \"Member_Middle_name\": \"E\", \"Plan_Effective_Date\": 45474, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"newpowad9@gmail.com\", \"Member_Suspect_Codes\": \"21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7624480096, \"Member_Identification_Number\": \"0007679302001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:38:07\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:38:07\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [{\"date\": \"2024-08-12T14:26\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-08-20T16:16\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-08-22T13:13\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-10-09T17:46\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-12T14:26\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-22T13:13\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-09T17:46\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:33\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-11-18T06:30\", \"username\": \"FEnwefah\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-10-30T12:01\", \"username\": null}, {\"date\": \"2024-10-30T12:01\", \"username\": null}, {\"date\": \"2024-11-11T12:33\", \"username\": null}, {\"date\": \"2024-11-11T12:33\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-11-08T01:16\", \"username\": \"DAdams\"}, {\"date\": \"2024-11-15T08:28\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-11-11T11:36\", \"username\": \"AWalsh\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:38:10\", \"value\": [{\"add\": \"1337 Old Dalton Ellijay Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1962-01-20\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7624480096, \"zip\": 30705, \"add2\": \"Apt 26\", \"add3\": \"\", \"city\": \"Chatsworth\", \"gend\": 0, \"insh\": \"0007679302001\", \"mzip\": 30705, \"name\": \"WADE E NEWPORT\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"newpowad9@gmail.com\", \"ename\": \"\", \"madd1\": \"1337 Old Dalton Ellijay Rd\", \"madd2\": \"Apt 26\", \"madd3\": \"\", \"mcity\": \"Chatsworth\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:38:10\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:38:10\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/31/2024 @ 11:20 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/30/2024 @ 11:02 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/29/2024 @ 10:49 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/9/2024 @ 05:46 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"10/16/2024 @ 05:46 PM\"}, {\"date\": \"8/22/2024 @ 01:13 PM\", \"result\": 10, \"comment\": \"Called to Schedule Virtual HRA with Debbie number disconnected.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"8/29/2024 @ 01:12 PM\"}, {\"date\": \"8/20/2024 @ 04:16 PM\", \"result\": 10, \"comment\": \"Called to Schedule Virtual HRA with Connie number disconnected.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"8/27/2024 @ 04:16 PM\"}, {\"date\": \"8/12/2024 @ 02:26 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Mariana Bernard\", \"callbackDate\": \"8/19/2024 @ 02:26 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-12-2024 14:26:00\", \"schedulerId\": \"84929813\", \"schedulerLeadId\": \"84929813\"}]}', '{\"date\": \"11-11-2024 00:33:14\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 7}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:38:10', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4574, NULL, NULL, NULL, '0007682536002', '422657', '', NULL, 'Amanda', 'Detrick', '', '{\"DOB\": 28248, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Carrollton\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Carrollton\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1977-05-03\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 422657, \"Mailing_County\": \"CARROLL\", \"Member_Country\": \"CARROLL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"316 Chestnut Oak Dr\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30116, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"316 Chestnut Oak Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30116, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Detrick\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Amanda\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45323, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Identification_Number\": \"0007682536002\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:38:07\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:38:07\", \"hrastatus\": 18, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:38:11\", \"value\": [{\"add\": \"316 Chestnut Oak Dr\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1977-05-03\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": \"\", \"zip\": 30116, \"add2\": \"\", \"add3\": \"\", \"city\": \"Carrollton\", \"gend\": 1, \"insh\": \"0007682536002\", \"mzip\": 30116, \"name\": \"Amanda Detrick\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"316 Chestnut Oak Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Carrollton\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:38:11\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:38:11\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"08-08-2024 00:33:48\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', NULL, NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:38:11', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4575, NULL, NULL, NULL, '0007685028001', '428592', '', '26056802', 'Christina', 'Munday', '', '{\"DOB\": 37167, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Flowery Branch\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Flowery Branch\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"2001-10-03\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 428592, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"5058 Hartford Pl\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30542, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"5058 Hartford Pl\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30542, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Munday\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Christina\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45383, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"graceechristinaa@icloud.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7705618359, \"Member_Identification_Number\": \"0007685028001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'1', '{\"date\": \"10-15-2024 00:30:20\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2024-10-15 00:30:20\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-08T16:30\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-26T16:59\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-27T14:41\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-28T16:42\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-08T16:30\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-26T16:59\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-28T16:42\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:38:11\", \"value\": [{\"add\": \"5058 Hartford Pl\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"2001-10-03\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7705618359, \"zip\": 30542, \"add2\": \"\", \"add3\": \"\", \"city\": \"Flowery Branch\", \"gend\": 1, \"insh\": \"0007685028001\", \"mzip\": 30542, \"name\": \"Christina Munday\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"graceechristinaa@icloud.com\", \"ename\": \"\", \"madd1\": \"5058 Hartford Pl\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Flowery Branch\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:38:11\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:38:11\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"8/28/2024 @ 04:42 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA with Delise Adams NO VM SETUP \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"9/6/2024 @ 04:42 PM\"}, {\"date\": \"8/27/2024 @ 02:41 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA with Delise Adams NO VM SETUP \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"9/5/2024 @ 02:41 PM\"}, {\"date\": \"8/26/2024 @ 04:59 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA with Delise Adams NO VM SETUP \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"9/2/2024 @ 04:59 PM\"}, {\"date\": \"8/8/2024 @ 04:30 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Delise Adams\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"8/15/2024 @ 04:30 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-08-2024 16:30:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"08-08-2024 00:33:48\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 4}', '{\"orderType\": 0, \"sortOrder\": 1725605424}', 1, NULL, NULL, NULL, NULL, '2024-09-30', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:38:11', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4576, NULL, NULL, NULL, '0007685035001', '428806', '', '543416', 'JORGE', 'CONTRERAS', '', '{\"DOB\": 31103, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Gainesville\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gainesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1985-02-25\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 428806, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"3347 Willow Ridge Cir SW\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30504, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"3347 Willow Ridge Cir SW\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30504, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"CONTRERAS\", \"Medication_Review\": \"N\", \"Member_first_name\": \"JORGE\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45383, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6785703428, \"Member_Identification_Number\": \"0007685035001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:38:07\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:38:07\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-15T18:54\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-08T17: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-08-19T14:28\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-08-22T12:21\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-19T14:28\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-22T12:21\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-08T17:29\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:53\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-11-18T06:30\", \"username\": \"FEnwefah\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-10-30T12:01\", \"username\": null}, {\"date\": \"2024-10-30T12:01\", \"username\": null}, {\"date\": \"2024-11-11T12:33\", \"username\": null}, {\"date\": \"2024-11-11T12:33\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-11-08T01:16\", \"username\": \"DAdams\"}, {\"date\": \"2024-11-15T08:28\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-11-11T11:36\", \"username\": \"AWalsh\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:38:11\", \"value\": [{\"add\": \"3347 Willow Ridge Cir SW\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1985-02-25\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6785703428, \"zip\": 30504, \"add2\": \"\", \"add3\": \"\", \"city\": \"Gainesville\", \"gend\": 0, \"insh\": \"0007685035001\", \"mzip\": 30504, \"name\": \"JORGE CONTRERAS\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"3347 Willow Ridge Cir SW\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gainesville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:38:11\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:38:11\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 13, \"callLog\": [{\"date\": \"10/31/2024 @ 04:27 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/8/2024 @ 05:29 PM\", \"result\": 3, \"comment\": \"No vm set up-LLA\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"10/15/2024 @ 05:29 PM\"}, {\"date\": \"8/22/2024 @ 12:21 PM\", \"result\": 6, \"comment\": \"Member requested a call back. Call attempt to schedule a HRA w/ Delise Adams. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/23/2024 @ 12:21 PM\"}, {\"date\": \"8/19/2024 @ 02:28 PM\", \"result\": 6, \"comment\": \"Member only speaks spanish- wants cb- LLA\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"8/26/2024 @ 02:28 PM\"}, {\"date\": \"8/15/2024 @ 06:54 PM\", \"result\": 13, \"comment\": \"08/15/2024 JC: called for HRA-Delise Adams-Virtual or F2F: caller hung up, while dialing out to lang line\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"8/21/2024 @ 06:54 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-15-2024 18:54:00\", \"schedulerId\": \"543416\", \"schedulerLeadId\": \"543416\"}]}', '{\"date\": \"11-11-2024 00:53:20\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 5}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:38:11', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4577, NULL, NULL, NULL, '0007686373001', '432035', '', '543416', 'Jaime', 'Rivera', '', '{\"DOB\": 21475, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Gainesville\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gainesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1958-10-17\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 432035, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"926 Midtown Way\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30501, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"926 Midtown Way\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30501, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Rivera\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Jaime\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45413, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"rivera1958j@gmail.com\", \"Member_Suspect_Codes\": \"21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6787255970, \"Member_Identification_Number\": \"0007686373001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:38:07\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:38:07\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-15T18:59\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-19T14:30\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-22T12:24\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-08T17: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-08-19T14:30\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-22T12:24\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-08T17:31\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:53\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-11-18T06:30\", \"username\": \"FEnwefah\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-10-30T12:01\", \"username\": null}, {\"date\": \"2024-10-30T12:01\", \"username\": null}, {\"date\": \"2024-11-11T12:33\", \"username\": null}, {\"date\": \"2024-11-11T12:33\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-11-08T01:16\", \"username\": \"DAdams\"}, {\"date\": \"2024-11-15T08:28\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-11-11T11:36\", \"username\": \"AWalsh\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:38:12\", \"value\": [{\"add\": \"926 Midtown Way\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1958-10-17\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6787255970, \"zip\": 30501, \"add2\": \"\", \"add3\": \"\", \"city\": \"Gainesville\", \"gend\": 0, \"insh\": \"0007686373001\", \"mzip\": 30501, \"name\": \"Jaime Rivera\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"rivera1958j@gmail.com\", \"ename\": \"\", \"madd1\": \"926 Midtown Way\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gainesville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:38:12\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:38:12\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/31/2024 @ 04:28 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/8/2024 @ 05:31 PM\", \"result\": 7, \"comment\": \"rang then  fast busy-LLA\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"10/15/2024 @ 05:30 PM\"}, {\"date\": \"8/22/2024 @ 12:24 PM\", \"result\": 13, \"comment\": \"Caller answered the call through to greeting - caller then disconnected the call.  Call attempt to schedule a F2F or a virtual HRA w/ Delise Adams.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/23/2024 @ 12:24 PM\"}, {\"date\": \"8/19/2024 @ 02:30 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"8/26/2024 @ 02:30 PM\"}, {\"date\": \"8/15/2024 @ 06:59 PM\", \"result\": 3, \"comment\": \"08/15/2024 JC: called for HRA-Delise Adams-Virtual or F2F: No VM set up \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"8/21/2024 @ 06:59 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-15-2024 18:59:00\", \"schedulerId\": \"543416\", \"schedulerLeadId\": \"543416\"}]}', '{\"date\": \"11-11-2024 00:53:21\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 5}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:38:12', 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
(4578, 93442164, 44829497, '56716210', '0007687540001', '428314', '', '20099125', 'Carley', 'Loner', '', '{\"DOB\": 34066, \"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\": \"30528\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"Cleveland\", \"Pcp_Name\": \"Kaitlyn Vann\", \"Rank_All\": \"\", \"PCP_Phone\": \"7068651234\", \"Pcp_State\": \"\", \"Member_City\": \"Cleveland\", \"Office_Name\": \"Northeast Georgia Physicians Group\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Cleveland\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1993-04-07\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"2578 HELEN HWY\", \"Screening_IHA\": \"No\", \"member_id_two\": 428314, \"Mailing_County\": \"WHITE\", \"Member_Country\": \"WHITE\", \"PCP_Fax_Number\": \"7068657265\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"5411 Highway 129 S\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30528, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"5411 Highway 129 S\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30528, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Loner\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Carley\", \"Member_Middle_name\": \"Ann\", \"Plan_Effective_Date\": 45352, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"Carleyloner11@gmail.com\", \"Member_Suspect_Codes\": \"130\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 7069089527, \"Member_Identification_Number\": \"0007687540001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"09-03-2024 12:41:56\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-09-03 12:41:56\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-08-27T12:43\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-30T18:15\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-31T13:37\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-09-03T12:41\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-08-15T11:16\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-08-15T11:16\", \"reportStatus_date\": \"2024-08-15T11:16\"}, {\"text\": null, \"type\": \"HraStatus\", \"status\": null, \"hraStatus\": 2, \"hraStatus_date\": \"2024-08-26T23:56\", \"reportStatus_date\": null}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-08-31T13:37\", \"reportStatus_date\": \"2024-08-31T13:37\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-09-03T12:41\", \"reportStatus_date\": \"2024-09-03T12:41\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-09-03T12:41\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-08-15T11:16\", \"username\": null}, {\"date\": \"2024-08-15T11:16\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-08-26T23:56\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-08-27T21:36\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2024-08-27T12:43\", \"username\": \"DAdams\"}, {\"date\": \"2024-08-27T12:43\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-08-31T13:37\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-08-30T18:15\", \"username\": \"mscanlon1\"}, {\"date\": \"2024-08-30T22:38\", \"username\": \"DAdams\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-08-31T13:37\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [{\"date\": \"2024-08-30T19:42\", \"username\": \"JWren1\"}, {\"date\": \"2024-08-30T22:38\", \"username\": \"DAdams\"}]}', '{\"history\": [{\"modified\": [{\"date\": \"10-22-2024\", \"time\": \"16:34:28\", \"value\": [{\"add\": \"5411 Highway 129 S\", \"age\": 31, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1993-04-07\", \"eno\": \"7708961992\", \"lob\": \"On Exchange\", \"pno\": 7069089527, \"zip\": 30528, \"add2\": \"\", \"add3\": \"\", \"city\": \"Cleveland\", \"gend\": 1, \"insh\": \"0007687540001\", \"mzip\": 30528, \"name\": \"Carley Ann Loner\", \"plan\": \"Alliant\", \"pphy\": \"Kaitlyn Vann\", \"ppno\": \"7068651234\", \"race\": \"\", \"cliId\": \"\", \"email\": \"Carleyloner11@gmail.com\", \"ename\": \"Everett Dale\", \"madd1\": \"5411 Highway 129 S\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Cleveland\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"2578 HELEN HWY\", \"pcpnpi\": \"\", \"pcpzip\": \"30528\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Single\", \"pcpFlag\": 0, \"pcpcity\": \"Cleveland\", \"pcpname\": \"Northeast Georgia Physicians Group\", \"program\": \"ACA\", \"evalDate\": \"2024-8-27 09:45 AM\", \"evalName\": \"Delise Adams, FNP\", \"pcpfaxno\": \"7068657265\", \"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\": \"08-26-2024\", \"time\": \"23:56:12\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"10-22-2024 16:34:28\"}', NULL, NULL, '{\"memberId\": \"0007687540001\", \"clinician\": \"Delise Adams\", \"qaAnalyst\": \"Jared Wren\", \"queryData\": [{\"date\": \"Fri, 30 Aug 2024 23:42:28 GMT\", \"name\": \"Jared \", \"role\": \"coder_lead\", \"files\": [], \"query\": {\"feedback\": \"Hello,\\n\\nCould the depression dx be more accurately described as Major depressive disorder? If so please use the \\\"major\\\" box under the depression header. If not, no action is needed. Thank you.\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Sat, 31 Aug 2024 02:38:38 GMT\", \"name\": \"Delise \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Did not feel I could describe the member\'s depression in detail because she was reluctant to specify the cause of her depression, frequency, and/or severity. \"}, \"mailId\": \"\"}], \"memberName\": \"Carley Loner\", \"codingAnalyst\": \"\", \"dateOfService\": \"\", \"clinicianMailId\": \"deliseadams@sbcglobal.net\", \"qaAnalystMailId\": \"j.wren@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"8/15/2024 @ 11:16 AM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA with Delise on  8/27 at 9:45am. Link texted, member using phone.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0007687540001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"56716210\", \"memberId\": \"0007687540001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"56716210\", \"memberId\": \"0007687540001\", \"scheduleDate\": \"2024-8-27T09:45\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-15-2024 11:16:00\", \"schedulerId\": \"20099125\", \"schedulerLeadId\": \"20099125\"}]}', '{\"date\": \"08-15-2024 11:16:13\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2024-09-03 12:41:55\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"6e18dada-6a13-11ef-881d-b3bfdad2767c\\\",\\\"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-27T09:45', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:38:12', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007687540001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0007687540001_Loner, Carley_08272024.pdf\", \"ftp_upload_date\": \"2024-09-03 12:41:55\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Vann, Kaitlyn_0007687540001_08272024.pdf\"}', 'ACA_0007687540001_Loner, Carley_08272024', NULL, 'PCP_Vann, Kaitlyn_0007687540001_08272024', NULL, '[{\"date\": \"2024-08-27T16:43:32.915Z\", \"signature\": \"data:image/png;base64,[encoded data, 23488 characters]\"}, {\"date\": \"2024-08-31T02:38:37.837Z\", \"signature\": \"data:image/png;base64,[encoded data, 23512 characters]\"}]', '2024-08-27T10:28', 'Member_Summary_0007687540001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007687540001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0007687540001.pdf\", \"member_ftp_upload_date\": \"2024-09-03 12:41:56\"}', NULL, NULL, NULL, NULL);
